Authoring

I have a set of records (360 total) that are already assigned a relational ID to 3 other records (2 sets of 144 records, and 1 set of 72) I want to group the records in sets of 12 to assigning a _group_index and then start over again for the next relational ID.For Example:The first 144 records would already have the same relational ID (Let's say A). In relational set A, the first 12 records would receive a _group_index of 0, records 13-24 would receive a _group_index of 1, all the way through records 133-144 receiving a _group_index of 11. This is the end of relational set A, so relational set B would begin and contain 144 records as well. I would like the _group_index to start over and the first 12 records of relational set B (records 145-156) would receive a _group_index of 0. The number of records in each relational set is not always the same, but they are always a factor of 12. Relational set C in this example is a total of 72 records, so its first 12 rec

HiAfter changing the params using params += elem[i].name + "=" + elem[i].value + "&";params = params.substr(0, params.length-1); I am unable to submit a job through FMEServer.submitSyncJob(repository, workspace, params, callback) function, but able to run using FMEServer.runDataDownload.If i use the below line for params and do not change params:params = { "publishedParameters" : [] };then i am able to submit a job.What is the probable reason for this behavior?

Situation: I have a workspace with a JSONFragmenter transformer that occasionally receives malformed JSON (unescaped special characters). I want it to skip over them so I set the workspace parameter for "Rejected Feature Handling" to "Continue Translation" and all is good.But when I reference the above workspace using a WorkspaceRunner (Wait for Job to Complete is set to Yes) on both desktop or server, it bonks the parent workspace even though I have the same setting for the Rejected Feature Handling in the parent as well. So am I missing a setting somewhere?The band-aid fix is to add a Logger to the Rejected port. But I got a lot of JSONFragmenters and I'm hoping for a more elegant solution.-- Brian

Hi,when I replace the hardcoded string to a dataset with a parameter (in my case my $(FME_SHAREDSOURCE_DATA) Resources), the FeatureReader destroys all my 'one per feature type' or 'specified' Output Ports. Even if I add 'FeatureTypes to Read' as a Fixed List parameter. So how can I make the Output Ports persistent to prepare my workspace for FME Server? (FME 2017.1.1.0 build 17650)

Hello,I'm trying to convert compound geometry type from an Intergraph Access database into Esri file database. I'm wondering how to separate geometry type from compound into point, line and area features.

I'm using FeatureReader as CSV format and trying to expose attribute 'fme_feature_type'. It's returning NULL or CSV. Instead it has to return FILENAME.Any thoughts please?

I'm trying to change the default path for the Data Path, but when I do, FME Workbench is telling me that it does not have access to the directory. I'm not sure why it would not have access nor can I find the log file it keeps telling me to look for. Any ideas?

I'm trying to get FME Desktop 2018 Beta to run an AreaOnArea between two large SDE feature classes. It's millions of records in each dataset and FME chokes if I try to run the AreaOnArea in one go. I saw in the help you can use a custom transformer to apply parallel processing to help break the work into spatial chunks. I tried implementing this using by breaking my study area into tiles and then feeding each tiles into a custom transformer that imports the needed data and processes it, but when I check my results, the AreaOnArea results don't show the two datasets cutting each other.Here's the steps my workspace takes:1. Read in the project area polygon2. Use the Tiler transformer to cut the project area into 1 sq mile pieces3. Feed the tile features into a custom transformer4. Inside the custom transformer, use ArcSDEQuerier to read the features from my two input layers that intersect the tile, then feed these results i

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:

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

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 R

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 ac

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.