Authoring

Can someone please explain how I can capture the Errors in the log file created by FME Server using Python. From what I have read I am still not sure if the python has to go in the startup, shutdown or PythonCaller transformer to capture any errors while it is running. I am also not a python developer so would appreciate a full working script or an example Workspace if possible? I am using FME 2016.

With FME 2015 Desktop, I use the StringSearcher do parse an attribute containing the below text:-rw-rw----    1 20712    110          1102 Dec 15 09:08 VPDZ22.201712150908.zip-rw-rw----    1 20712    110          1103 Dec 15 09:18 VPDZ22.201712150918.zip-rw-rw----    1 20712    110          1102 Dec 15 09:29 VPDZ22.201712150929.zip-rw-rw----    1 20712    110          1145 Dec 15 09:38 VPDZ22.201712150938.zip-rw-rw----    1 20712    110          1238 Dec 15 09:48 VPDZ22.201712150948.zipHereby I want to obtain a list with all names of the zip-files within this text.Therefore I try Regular Expressions such as e.g.(VPDZ22.[0-9]{12}.zip|asc)+I expect to obtain a list with 5 objects containing the 5 different zip-filenames. However, I always obtain a list containing only one single object, which is the first of the wanted zip-filenames:VPDZ22.201712150908.zipHow am I to design the Regular Expression for this to work correctly?

I created 3 published parameters but if one is left blank the attribute has no values. If just one or two of the three parameters is filled in the blank one has to display its standard values. How can I realize this?Update*: Before running the model the user need to fill in the parameters. Users can choose to fill in zipcodes or municipalities. If one of these parameters is left blank, the table in the dataviewer of the blank parameter has no data. If no parameters are given it won't show any data and I want all the data to be displayed when no parameters are given. The model is really simple since I created my reader with a more complicated model. I just want to give the users the possibility to get the access to the data based on location. I hope that my question is more clear now.

Hello everyone,I try to solve problem with numbers and values. In my project, I manage SQL select count via SQL Executor, so the result of query could be for example number 5. But what I need in second step, I have to create list with minimal value 0 and maximum value (result of query) 5. So list will contain following values 0,1,2,3,4 and 5.Any tips please?Thank You so much!Lubo

Hello,please, I have one problem to solve. Is it possible to change filename extension in FME? E.g. I need to change filename "Analysis.doc" to "Analysis.docx" automatically in workspace. Probably some Python script is suitable there... Unfortunately, I´m not Python expert.Could anybody help me please?Thak You so much!Lubo

Folks,This is a bit of an odd one. I have a massive and complex workspace and was trying to debug an issue with a missing output feature.I was "circuit tracing" for the want of a better term and visually everything "looked" OK. However once I got to the final step to check the connection of a transformer output port to the writer I found the port wasn't actually connected to anything.My only defense was the massive number of transformers and connectors terminating at the same location.So after being a bit embarrassed (it was in front of a client), I was wondering if there are any smarts or techniques that can be used to detect transformers where none of the outputs are connected to anything.A red cog is shown when a transformer isn't fully configured. If there was something that could be used to find unconnected or accidentally disconnected transformers it would be very helpful.Any thoughts appreciated.

HelloI have 150 CSV files. I would like to convert them to equivalent SHP files. I don't want to do it one by one of course hence I chose dynamic workflow. This should be just a mirror translation (with geometry creation from WKT along the way). But I can't get this to work. In the writer I tick the Dynamic Properties with Schema Sources set to "*.csv [CSV2]" but this doesn't create any shapefiles complaining: 'Features with no schema defined'When I untick the Dynamic Properties the shapefiles are created but only with the geometry, no attributes. Here's the workbench. The CSV filename is the name of the feature. Bunch of attribute renaming and removing. Creating geometries. Reader:Writer (I tried geometry defined by schema as well but same result):Am I missing something? Thanks!

When the workspace gets an email from the server, the attachment comes in as an array/list."email_publisher_attachment{1}"How do I search within the attachment list to find which is an excel file, then use that as the source attribute for the feature reader?

Good morning!I've been given a sample of data to create aggregates from them (I have attached that data)The only attribute of the features is type. I have to build aggregates using features of the same "type".For example, these lines and point must be an aggregate:Or these lines and polygon:I've been messing around with the transformer NeighborhoodAggregator, but I'm incapable of adding the proper settings to make it work for all the types. Looking at the data, I'm not really sure if it is even possible to make it work for all of them.I've been trying with spatial relationships, but I can't make it work either.I'm out of ideas. I'm starting to think that I will have to treat every type on its own. In the data sample there are only 4 or 5 types, but in the real deal there will be more than 60.I need to create the aggregates, because in the database the aggregate will be stored as a point feature.I'm in need of another point of view, so thank

.Hi there,Could someone help me to identify why only one of our team members get this error?This user cannot Read or Write ESRI GeoDatabases A Python interpreter could not be loadedProgram Terminating Translation FAILED.thanks

Hello FME-Community, I'm trying to find a workaround for the non-existing feature type TransformerInputPorts at the FME Workspace Reader.I would like to know whether it is possible to detect which input ports of a transformer are connected with other FME transformers within my workspace.The FME Workspace reader has among others feature types TransformerOutputPorts, Transformers and Connections.I tried to combine the information from these feature types, but without the desired resultsHow can I detect which input ports are (un-)connected for a specific transformer in my workspace ?

Is it possible to filter data by attribute, comparing it with list (for example Excel table classificator). Features must be filtering depending on is attribute has a match in list or not.

Hello fellow FME users,I was wondering if there is a way to use the equivalent of a logic gate in FME. What I mean by that is a transformer that only passes data if the conditions have been met. An AND gate for example only passes the data if all inputs van been met for example: I have a main data flow with a specific branch that only gets triggered if a condition is true. I test this by using a creator and tester to test if a published parameter has a specific value. I would like for the passed feature to act as a trigger to trigger a branch.I've added a picture for clarificationAn OR gate is not needed because lots of transformers act like that. So is there something that works like this, or maybe a Python solution? I can't program Python though.Thank you in advance!Michiel

I need to import shape data into MS SQL spatial database from various file geodatabases. My workspace will be published on the FME server where .net service will call it.The structure of the fgdb is always the same shape_length, shape area and AO number.The feature class name is different in each fgdb. Is there a ways I can have global user parameter to read any feature class name from fgdb???The other choice I would have is to receive the feature class name from the API service and pass as user param but I am not sure if this would work. Any suggestion??@hcode@takashi

Hi!I have an Ubuntu 16.04 VM on Amazon EC2 and installed FME there. Due to compatibility issues, it is not possible for me to get a GUI when establishing a remote connection the the VM. I developed some FME workspaces on another computer and want to run them on the Ubuntu VM. As one of the workspaces uses an ArcGIS Online Reader, I need to add a web connection to the FME installation.However, I haven't found a way to accomplish that without a GUI so far. Is it possible to add the web connection thorugh the command line? Or Can I add the web connection in FME installation from another computer (with GUI) and copy a specfic config file to the other installation?Thanks in advance for any suggestions!Greetings, André

Hi,I have a production server that is mission critical and I cannot impact performance. Unfortunately there is no mirroring or a secondary server I can access and it's hitting the production server or nothing. In reading from this server, I cannot impact that servers performance in any manner...fortunately I can schedule this in the evening when it's load is minimal, however I cannot impact the performance of this server for that minimal load.Does FME have any methods of 'running in the background' where it reads from the server only when it's resources are free (or minimally used)? Or diffrent wording...Is there any method I can use to ensure FME doesn't impact production performance while extracting data from a production server?MSSQL 2008 (source) to a Oracle 12c DW if that makes any difference for this question.Thanks!

recently I try to use Job id to check status of my submitted job on FME Server, based on FME Server Playgound, I try to use Get method to call this url: http://apptest:8080/fmerest/v3/transformations/jobs/397; this case job id is 397, authentication use token, I use browser of postman both get results:"message": "null for uri: http://apptest:8080/fmerest/v3/transformations/jobs/397". If I login FME Server, I can see the job is finished success. My question is how to get "STATUS", "RESULT DATA" information as attached below image. Thank you very much.

Hello,  I am developing workbenches that will process the input data depending on certain conditions. I am publishing to FME server so that it can be used in Java application.  I would like to know is it possible to pass any meaningful error message if data is not what is expected. I don't have a clue how I could achieve this. Any pointers in right direction?

I want to keep the attributes of Sentinel downloaded images for AWS server and view them in a shape (or kml) file with the footprint. What are the transformers that keep the attributes from AWS search also and in vector transformation? Thanks

Good afternoon everyone,I have one question regarding FME Server security. I am using FME Server 2014 with an Oracle database. Normally when we create a user in FME Server, the user is create in table FME_USERACCOUNT with an encrypted password. Now I have an issue that one of my web services have to access FME Job so my web services need username / password for basic authentication. Now I have two options either I store password in some local storage with my web service or my web service access Oracle schema fmeserver and get password for user. If i can have decrypted password, the management will be very simple for me. Can anyone guide me, may be I am missing some basic point over here. I don't have AD in my infrastructure. Can you please guide me ? Regards

I'm trying to improve a tool to process Ordnance Survey MasterMap data, and I've been trying WorkspaceRunner as a way to speed things up. The eventual goal is to have a Data Interop tool we could give to customers, have them fill in the bare minimum of data, and set it running without having to know much about what it's doing.The problem I'm running into is that I can't pass in parameters to set the location of the workbench that I'd like WorkspaceRunner to use and set the Parameters for that workspace; WorkspaceRunner can't look up the required parameters until the workspace is set, and because we can't know where the user will put the tool in a folder structure, it can't be hard-coded. I've tried setting the workspace, setting the parameters, then removing the workspace, but it didn't like that at all.There is an extra complication with Data Interop - FME will adjust the filepaths when the workbenches move, so long as the relative filepath

Hi Experts. I have an excel table 'lookup'(attached) with 2 sheets accounting and count. I want to add a column number in the count table wherein the value of number would be from the value attribute from accounting table with respect to the count attribute.I have tried using a combination of sorter, counter, lists and aggregator but didn't get the desired results. May be I had tried somewhat other way.Thanks.

I have a workspace that has several WorkspaceRunners running in sequence. If the workspace in the first WorkspaceRunner writes nothing, no need to run the remaining WorkspaceRunners. But how I can pass the number of the writes of the first workspace to the parent workspace?