Authoring

I simply would like to set up a dyamic Reader in PostGIS that will read all the tables I select at runtime, then having a postGIS dynamic writer connected to this reader that would copy the same geometry, schema definition and data from the reader, the name of the table will be the name of the of the original table plus underscore, something like "original_table" => "original_table_".Though it seems a very simple task to accomplish I tried in many ways but I cannot get FME to do it. I tried to follow the tutorial https://knowledge.safe.com/articles/1157/dynamic-workflow-tutorial-destination-schema-as-a.html but I get first a warning:Cannot find a matching schema named 'name_of_db_schema.original_table_' in the known set of schemas: 'name_of_db_schema.original_table_. Known schema sources ar

Just wondering, how can I give different priority to run couple of streams in one Workbench, I want to run one of them and then run the others . thanks.

We have a workspace - published in FME Server - that crunches a bunch of data, writes out one or more records to an Excel file, and then kicks off an FMEServerJobSubmitter to a second job that reads in the Excel file to update some features in ArcGIS Online. Our issue is that the second FME Server job fails because the Excel file it is trying to read is still in the process of being written in the first job. How do we ensure the Excel file is done writing in the first job before the second tries to read it? We are running FME Desktop and Server 2016. Thanks,Aaron

Hi All,Is it possible to retrieve the services available to a workspace via a call to FMEServer.getWorkspaceParameters or similar?  For example, I can get a list of repositories and then their workspaces - this works fine.I need to know what services are then available (e.g. Job Submitter, Data Download etc). Regards,Simon

Why does FME Workbench save some workspaces as text files and some as binaries?When workspace is stored as text file in xml format, we can try to compare different versions and to find differences that have been applied to workspace.It is really important in case of code review and especially if something is broken in new release and it is not dependent on input data.

Dears FME comunnity members.  I've a cloud of point with ID and a type (Start/end) along a linear. I would like to make a dynamic segmentation for keep cut lines between two points with same ID and different types. The aim is to extract linear concerns by two points and exclude other linears.You can see an explication of my problem with a draw in attachment.Thank you very much for your help.

I'm trying to get a range of dates as a new features.For ex: if the date range is 02/01/2018 - 02/06/2018, Output features has to be like 02/01/2018, 02/02/2018, 02/03/2018, 02/04/2018,02/05/2018, 02/06/2018Any thoughts please? Thank You

Looking for a way to preset job directives in a workspace so customers don't have to set them. Can you do that with FME_SERVER_REQUEST_PARAMETERS or another parameter in workbench before uploading it, or is there a config/setting somewhere in the web UI to change it?Use case: Have customers hit the data streaming url endpoint which submits the job, but jobs get submitted with a 100 priority tag, so sometimes they don't complete in the needed time frame. Don't want to have customers set priority or other job directive tags because they could potentially stop other critical jobs needed to run.

Hi guys, I'm trying to read a WMS using a FeatureReader. Using an ordinary reader works just fine, however, creating a box and use it as input for a featurereader (same params etc) yields no result.  Regards, Helmoet de Zwijger.

I have a bunch records that I'm aggregating. After this, I'm applying business rules and based on what's outputted, I'll know which of the original records I want to parse differently (i.e. not through aggregation, business rules set #2). I want to go back to the beginning of the workspace to allow these specific records to pass through in its original format. How do I do that?I'm thinking of aggregating the unique ids of the records I want, and use this value to test against the original records, like: ID in @Value(aggr_ids_to_keep), but then the record that has the aggr_ids_to_keep attribute will be its own record.Here's another way to look at what I mean. The recordset would be like {0:n,m} where 0:n are the original records and m is the one with aggr_ids_to_keep. In this scenario, how do I get m to compare against 0:n?

I am trying to find one or multiple ranges of values within a list in the most efficient way.My list-attribute looks like this: (1, 2, 3, 5, 6, 7, 9, 12,13,14,15,16).I would like to end up with the following result: (1-3, 5-7, 9,12-16).Is there an efficient way to do this without coding? Maybe using the variable setter?Since I am using only positive integers, my current way consists of adding 1 and substracting 1 to each value, then using mergers to find out, if the corresponding next value upwards or downwards exists, and then dividing my values into classes: - values that were not assigned the next upper or lower value --> keep as single value- values that were assigned upper only --> keep as lower value- values that were assigned lower only --> keep as upper value- values that have both --> ditch.

I have my parameter values in a SQLite table. I am able to access each value though a Python scripted parameter that opens the table and retrieves the value. However, this means that I have to open and close the SQL table one time for each parameter. Is there a way to make multiple parameters that can be read by the readers and transformers, perhaps in the Python startup script?

Hello,What is the best way to monitor the FME server "health"?If there are many of jobs being submitted I would like to know as soon as possible that the server will go down because of the overload. It would be great if I could get it from any logged information.

how could an app get data, via the notification feature of FME , without using the email notification i mean how could we push information to the other system and topic is triggered, any example.Thanks

Hi,Is it possible to call the s3Uploader transformer using a python shutdown script? My workflow currently uses a python shutdown script to convert the FME output data into a number of proprietary formats and now I would like to upload these proprietary files to AWS S3. I would preferred to do it all using a single work bench without install extra python modules(ie Boto3) Thanks

Hello everyone,I am trying to utilize tiler for parallel processing in FME Server environment. Workbench that has tiler transformers and parallel processing enabled, runs fine in FME Desktop environment. However, if i try to run the same workbench via FME Server, it throws the following error:  Tiler_2_PointCloudTiler(PointCloudTilingFactory): The keyword TILE_ROW_ATTRIBUTE has incorrect arguments. The clause must look like: TILE_ROW_ATTRIBUTE <attribute name>, where <attribute name> is the name of a new attribute that will be added to output features  Any help with this issue would be much appreciated.  Thanks! Boris 

Hi,I'm trying to find a transformer that's able to create a new attribute, check my data for different conditions based on values from multiple different attributes, and subsequently add to the value of the newly created attribute WHILE these conditions hold true. Something like an "overall score attribute".I put while in caps because with the attribute creator there are only "if" statements. I'm not a programmer, but I know that with if statements, as soon as one holds true, the scripts stops. That is what seems to happen with the attribute creator transformer that I have been using. I could be mistaken of course. Like I said, I'm not a programmer.However, I don't want that. I want the program to keep checking all conditions and adding to the "score attribute". How do I do that?So basically something like this: if/while attribute1 >= 10, add 1 to new overall score attributeif/while

Hi everyone,Here is my problem. I upgraded my FME Desktop from the 2014 version to the 2017.1 and I have an issue regarding a specific workbench.I use the FeatureReader transformer to read DWG files, and it works fine in FME 2014, but it doesn't in FME 2017.1. The execution is sucessfull but it seems that it reads only partially my DWG files (the output is not right), I have this error in the log : AutoCAD Reader: An error occurred for dataset '\\\\XXXXXX\\data_BD_Topo\\Topo\\1024500-6281500.DWG', in function AutoCAD2004Reader::read. Exception thrown: 'Invalid input' (Invalid input)MULTI_READER(R_2): Skipping to next ReaderI've tried to set a new FeatureReader from scratch, but I have the same problem...Any ideas ?? Thank you in advance,Fabien Laganne 

We don't have FME Server but we need for to be able to call a workbench to run remotely from machines that may not have FME Desktop installed.I've been playing with WMI as below. It successfully calls notepad and arcgis pro however fme.exe will startup but disappear from the process list before the workbench executes. If i copy/paste my cmdline onto the servers command prompt the workbench executes fine.import wmiimport osSW_SHOWMINIMIZED = 1server = 'DC3FMEDESKTOP'username = r'TFS' + os.sep + 'richardw-admin'print usernamepassword = 'password'c = wmi.WMI(server,user=username,password=password)startup = c.Win32_ProcessStartup.new (ShowWindow=SW_SHOWMINIMIZED)cmdline = "fme.exe S:\GIS\ESRIData\Scripts\FME\Server\\testremote.fmw \       --SourceDataset_FILEGDB \"S:\GIS\ESRIData\Authoritative\Climate_and_Environment\Meteorology.gdb\""#cmdline = "fme.exe"#cmdline = "C:\Progra

Hello, I have a correct fmw (footprint-1xls.jpg) that read the 4 coordinates from a xls and generate a footprint with 4 vertex (reader, vertex creator.line builder, line closer and geometry coercer). My questions are:- I dont know why the writer can not be a kml, it should be a shape, but also is ok for me- I would like to make the process for many xls in the same folder, obtaining many shapes with 4 coordintes each one. I have test with workapace runner but it does not work correctly (workspRunner). Many thanks, I appreciate your support ;-)

I obtain features from an WFS using the WFS Reader within a FME 2015 Workspace on FME Server. From time to time the job hangs and blocks the Server Engine for hours, while usually the run is successfully done after 2 minutes or so. I suppose that the WFS connection gets lost or so.Is there a smart way to have FME Server cancel a job after a certain amount of time (timeout function) in order to prevent such jobs from blocking a whole engine? Either any parameter in the server / engine configuration or a smart kind of routine within the workspace (i tried a timestamp and compare bevor / after routine, this however does not prevent the workspace from hanging)?

Hi,I know that you can set new attribute names and new attribute values using a list attributes as such:attribute{0}.nameattribute{0}.fme_data_typeBut how do I set the value of this new attribute?Is it something like:attribute{0}.value?Thanks

Hi All,We are converting Oracle spatial(SDO Geometry) to ESRI SDE (ST Geometry) using FME. In my data, some feature classes having VARCHAR2(2000) attribute columns. Those feature classes I am not able to process. Once I change VARCHAR2(2000) to NCLOB it worked for me. But i need to completed process with VARCHAR2(2000) only. Could anyone can help on this?

I have a tester that lets a shape through when name equals London area, this is fine, but when I add in a user parameter nothing is going through the tester. The only thin I can see is that the user parameter is adding speech marks to the beginning and end of the text string, hence it is not being found. I have imported all of the options from the name field in the shape file.Any ideas how to solve this?

I'm posting this here rather than on the regular forums, since I'm not sure how Safe feels about publicly posting performance benchmarks.Having seen the recent webinar introducing FME 2018 and the sometimes amazing performance improvement over FME 2017, I thought I'd make a simple test case to see for myself.I wanted the test case to be as simple as possible but still reflect a pretty common use case that had several possible solutions, so I settled on checking if an attribute value is null, and if yes map it to some other (default) value.Possible ways to do this includeNullAttributeMapper, maybe the most obvious choiceTester + AttributeCreator, the "old-timer" wayAttributeCreator with conditional testing, somewhat more creativeHere are my findings, all timings are given as mean CPU time in seconds on my mid-range laptop using one million features.FME 2017FME 2018Percent changeNullAttributeMapp