Authoring

Is there a way to have the data inspector not show attributes that are empty? When looking at AIXM 5.1 data, the tables is filled with empty attributes and makes it hard to 'inspect; your data

I'm trying to convert some data into the TOMTOM POI format, but I keep getting errors and the output file is created but not populated. A simplified version of the workspace that generates the same error is here: The translation log contains this:TOMTOM_POI writer: Creating layer 'waypoints' with geometry type 'wkb_unknown'TOMTOM_POI writer: dataset C:\\Users\\myname\\AppData\\Local\\Temp\\_14244_1 does not support layer creation option OVERWRITETOMTOM_POI writer: Cannot create GPX layer waypoints with unknown geometry typeTOMTOM_POI writer: Unable to create feature type 'waypoints'. Ensure the dataset is valid, that the user has all required permissions and that the feature type name is valid for the formatTOMTOM_POI Writer: In Feature Type 'waypoints', 'fme_table_handling' has invalid value 'CREATE_IF_MISSING'. Possible values include: 'CREATE_IF_MISSING', 'DROP_CREATE', 'USE_EXISTING'A fatal error has occur

I have an aggregator transformer (to aggregate incoming features because I want a single feature to enter the subsequent Emailer transformer). I'm trying to use the python code (in PythonCaller transformer) to extract info about each of the aggregated features for output to the email. I'm using "for x in range (0, feature.getAttribute('Count')-1)" to try to loop over the lists but the workspace isn't accepting x.

Hello,With : - FME Server 2017 - Only 1 engine - A workspace with 1 FMEServerJobSubmitterCould you confirm that the child job launched by FMEServerJobSubmitter is always executed before any new job ?(ie someone asks for a new job before FMEServerJobSubmitter launches the child job)Regards.

Hi, In my workbench, I am writing a file which i want to send as attachment in an email notification from the same workbench. How can i control my FMEServerEmailGenerator to work if only the file is written?Note: I am using Fanout process in writer.

Hi,Can i get the Number of features read by FME workbench as like NumFeaturesOutput in response variable while running it as Jobsubmitter or Data Download Service?

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.