Best Answers

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 are: 'POSTGIS_1'. Please verify writer feature type configuration.Then an error message:POSTGIS Writer: Fanout for feature type 'name_of_db_schema.origina

Hi All,I am trying to use workspace runner for one my task.i have around 50 GDB which i want to run using one of my other workbench output of this workbench is going to be in XML . that is reason why i had thought of using workspace runner. I am using path reader to specify the folder , where i had kept my GDB's . I want my output XMl's to be stored in folder with name of input file GDB. not sure how i can do that . the workbench which i will be running using the work space runner has already set for segregate the output XML base on other fan out criterion. any help will be appreciated on this on how i can stored my XML's in folder with input GDB name .

Hi,I'm new to the Docker world and trying to get an understanding of how things work. I've downloaded a couple of the Docker compose files for FME Server and have done some initial playing around with them using the Docker for Windows platform. From my observations to date, all data is lost if the Docker instance is shut down using the docker-compose down -v command, so an FME Server backup should be performed prior to shutdown.According to information given in this post, it is recommended to leave the Docker container running and let Docker itself manage bringing the FME Server instance up/down if the host machine is rebooted. This will preserve configuration changes, so all good so far, just don't shut down the container!What happens if the host machine crashes? I assume that Docker will not be able to shut down cleanly and all FME Server configuration information will be lost? To this end, I was hoping to set up a scheduled backup on FME Server but the compose file provi

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

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

When playing around with FME 2017 today on a new project, we noticed that attaching an sde writer to a workflow dramatically slows down the reader. Has anyone else noticed this issue occur? Worth noting is that we aren't using versioning or transactions (transaction type = 'none') and the only reason we are using the GEODATABASE_SDE writer is because we need to write esri's ST geometry.Writing to Inspector: FME Session Duration: 16.5 seconds. (CPU: 11.1s user, 1.6s system)Writing to SDE: FME Session Duration: 2 minutes 6.0 seconds. (CPU: 51.0s user, 2.5s system)Since Oracle writers work fast and all we need is the esri ST geometry type, we were thinking about trying to hack together a solution where we could trick FME into writing the point geometry out in the expected format ie: SDE.ST_GEOMETRY(1,1,-10106993.68204,5190612.4770125,-10106993.68204,5190612.4770125,0,0,NULL,NULL,0,0,300041,(BLOB))

Hi,I need to identify short segments in polygon using some tolerance for better understanding I am attaching the snapshotRegards,K.Jayakumar

I have a set of point objects with rotation attributes. I would like to use this rotational value to go in a straight line in that direction until it encounters something. In this case it will be a line object. Finally I would like to retrieve a attribute from this neighbouring line. The Neighbour finder will pick the nearest object, but I want to pick the first object along the points bearing/heading. Is there some way to do this?

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?

Where can I download the data files for the "Getting Started Exercises"

I need to simply sort according to region, and then for each region, set a counter from 1 - n. Thus each region will have a 1,2,3 etc. I have set up a sorter ok but the counter does not start from 1 again on the next region.

I have a a set of point objects with a rotation attribute. These are later to be turned into labels. Each label point has a corresponding reference point that it needs to be facing away from. That's where the "behind" and "front" come into the picture. A quick example of what I want to do: Say I have a label point rotated to 20 degrees, and the reference point is at an angle of 50 degrees. This means that the reference is in the "forward" 180 degree sector and that the label needs to be flipped/rotated 180 degrees. The above example is straightforward but the fact that this is a rotating object that jumps from 360 degrees to 0 has me pulling my hairs. I need help with the math, and syntax. I have tried to incorporate a modulus 360 but have not managed to get it working. I am using a Testfilter to detect the relations between the points. What should the formula look like?Let assume that the rotation of the label is R and the angle to the reference point

Hello!  I like to read line geometry from a PostGIS DB and save it to an ESRI File GDB. When I check the translation via Inspector everything looks ok but when I save it to the file GDB the geometry suddenly looks very generalized. The same translation to shapefile works just fine. Any idea what I'm doing wrong? Thank you for your help.

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?

I am wondering if anyone have any suggestions to use FME to process live data streams that are funneled into various text files, server log files being one of the examples. Thanks!

I have two Netapp share locations mounted to an instance of FME Server on Linux. These locations are setup as FME Server Resources. Jobs can successfully write out to one of them but not the other. All permissions are EXACTLY the same on both Netapp shares. I am at a loss as to what could be going on here.

In SOAPui, I have this SOAPAction in the xml editor: SOAPAction: "http://schema.bpost.be/services/common/address/ExternalMailingAddressProofingCS/v001/validateAddress".I don't understand where do I have to create this action in the HTTPCaller of FME?

Hi,I would like to identify overlaps but only from a single source of data. That data has 1500+ records of unique Region Name. However, I found an instance where a part of a region is overlapping another adjacent region. I would like to identify how many instances I have in my database identifying at least 1 region name and creating an area of the overlapped.as shown below, green area has a portion of the adjacent boundary.any help is appreciated. thanksLex

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,  I'm attempting to geotag photos with FME Desktop by writing coordinates to the jpgs with an AttributeCreator.  The following headers have been attempted with no luck: jpeg_exif_gpslatitude jpeg_exif_gpslatitude jpeg_exif_gpsmapdatum etc... which is how the data appears in the data inspector with a properly geotagged photo. The tag names from http://www.sno.phy.queensu.ca/~phil/exiftool/TagNames/GPS.html were also attempted with no luck.  The proper data types were also considered.  Any idea of how to write gps EXIF data to jpg?  I know its possible with the exiftool and other third party apps but I'd like to keep it all within one workbench, without calling any other applications.  Thanks,  John 

Hi,  I have this workspace to add a geotag to a jpeg, based on a GARMIN glo GPS logger. I merge the GPS data with the jpeg by the date. When I take a look at the inspector merging seems to go well. But there is no exif information in the created jpeg (no original exif info and no latitude, longitude and altitude info). Anyone can help? I am new to FME.  Best, J. 

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 

I have a strange issue where Dashboard seems to run (ran it manually) and within a couple of seconds, it is empty. Needless to say, no history is available, either....Cleanup is running things with a longevity of 1 week, so I assume that cannot be the issue....Anybody experienced this before ? This worked fine before in 2017.1.1