Authoring

I have a list of numbers from 1 to 100. I want every time I run the workspace that a random number is selected. But it must not be the same no. Before you have been through the entire list. I use the selected number to retrieve some specific information from a particular row in another table where Rowid equals the number. I do not think I've found a transformer that can do this.

I want to load all the dbf files under a folder into an Oracle database, each creating a new table. Attached is workspace I created, but it gives an error that the schema is not defined for the writer. This can be easily done using ESRI arcpy, so should be easy in FME.

FME version: 2016.1.3.2 (20170214 - Build 16717 - WIN64)Hi, i am trying to create a custom coordinate system (custom ellipsoid, custom datum, custom transformation and custom crs).The CRS i am trying to create is the EPSG:26331 (as parametrized by EPSG).Looking at the Coordinate System Gallery, there is a crs with name equal to EPSG:26331 (i will call this FME EPSG:26331)..But there is two points that i want to modify:Ellipsoid ParametersDatum Parameters.Ellipsoid Parameters:Searching into EPSG Registry (http://epsg-registry.org), the ellipsoid used by EPSG:26331 is EPSG:7012 - Clarke 1880 (RGS). This ellipsoid has:semi-major axis (E_RAD): 6378249.145 meterinverse flattening (inv_f): 293.465.using P_RAD = E_RAD [1-(1/inv_f)] = 6356514.8695497755In FME, this same ellipsoid has:semi-major axis (E_RAD): 6378249.1449999996 metersemi-minor axis (P_RAD): 6356514.8700000001.using the same formula above, we get inv_f = 293.4650060791153. A little different from what is in EPSG. (this was one o

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