FME Form

I get this error while creating PostGIS reader in both 2015 and 2017.1 FME versions.Please advise for the below error.ERROR |Error executing SQL command ('select version(), postgis_version()'): 'ERROR: function postgis_version() does not existLINE 1: select version(), postgis_version() ^HINT: No function matches the given name and argument types. You might need t...'2018-06-04 20:46:28| 2.4| 0.0|WARN |Error retrieving version for PostgreSQL database2018-06-04 20:46:28| 2.4| 0.0|INFORM|Successfully closed POSTGIS database reader2018-06-04 20:46:28| 2.4| 0.0|ERROR |Reader failed in open() callTagging in @takashi, @erik_jan, @TiaAtSafe, @Mark2AtSafe, @RylanAtSafe, @jlutherthomas

I have a test environment so the data included in this workspace is just test data. I get the data via a http-caller. If I save "_result_body" with a JSON Writer and use feature reader to read in the saved json file I can get the polygons with no problem. But this wont work for me, I need to be able to directly interpret the response I get from the http-caller. I been hacking away for two days now and I just wont work. So its best to ask for help, and also some general tips on how I should interpret the response body. I read some tutorials about JSON and GeoJSON but those examples are not near as complex as this one is. I included a workspace where I created the response-body as an attribute if someone wants to push me in the right direction it would be nice. And another question. The data should appear in Sweden. But looking at the individual cordinates it looks odd, and the response from the http caller didnt include any info about the coordinate system. Maybe I didnt fill

It would be nice to have an update on the FME AR app from Safers for Android as it has been lagging behind functionalities vis-a-vis iOS

To make matters worse, the extended data need a certain form (for example "CODE 1004 - Binary Data").I have already found some impulses in the forum (autocad_extended_data_list {}), none of which helped me to solve the problem.Does anyone have any ideas or food for thought from you?Many greetingsMartin

Bye! How can I color lines that cross 3D objects? I would like to color each line green before it crosses the 3D object, and the piece of line that is beyond the 3D object red. Thanks

I have a lot of files with different coordinate systems. However, coordinate extractor only works to get a coordinate system of a file. Is there a way to get a list of coordinate system names of multiple files in different formats (shp, tab, kmz..)

hello, i would like to run several python scripts, using the arcpy library inside FME, what have i done so far? I just created published parameters and insert the values of the variables I need, but I'm not able to execute. See attached log. What do I need to set up correctly?

To all Autodesk'ler,I have a DWT-file, which is noch an ordinary Autodesk template file, but an application module. I can open and read it with the Autodesk's 'Infractruscture Admin'. Editing it possible with 'Map3D', where you can see the representation definitions. Usually you are hosting your data in an oracle database and holding the representation in LAYER-files. With a DWT you now have everything in one file.I already tried to open this file with the inspector - no success.Does anyone has experience with this? Cheers,Maria

As a note, we can do this in QGIS using the Topological colouring.

I am struggling to replicate the results of running a workspace on FME Data Express and am wondering if I've discovered a bug. I have a workspace with 3 published parameters; A Geometry (point), a Choice (Multiple) and a Filename (Multiple). The idea of the workspace is to select a location(point), add an attribute(s) and upload(or capture) a JPG(s). I tested this workspace on desktop and it worked as expected. I published it to Server and ran it on the user interface and it worked as expected. But when I try to run it on the FME Data Express app, the job fails with an error on Server saying either "Parameter 'SourceDataset_JPEG' must be given a value." or a similar error about the Choice (Multiple) attribute. There is no log file. This is odd as I've even confirmed in the Resources folder on Server that the JPG file is getting uploaded to Server. However, when I change both of these parameter types to the non-Multiple versions ("Choice" and &

Hello, my team uses a solution called Sitetracker that works on top of Salesforce. I'd like to read data from Sitetracker and also write to it. In my FME Desktop workspace I tried adding a Reader. In the Add Reader dialog, I set:Format = "Salesforce" Dataset = URL of our Sitetracker instance "https://<companyname>.lightning.force.com/"In the Salesforce Parameters dialog I set:Host = URL as aboveUser = username of our service accountPassword = password of that service accountSecurity Token = security token provided by SalesForce emailTable List = "Quality__c" manually typed, as the ellipses show it to be stuck on loadingWhen I try clicking on the Table List ellipses, they get stuck on the Loading dialog as per this screenshot:If I manually type the name of our custom entity "Quality__c" into the Table List, then I can click "OK" on both dialogs.  If I use the URL prefixed with "https://", I get it hanging like this: If I use the URL without that prefix, I successfully can create t

My question is similar to this one, except I need to get it working on FME Server: https://community.safe.com/s/question/0D54Q000080hOreSAE/loop-through-multiple-choice-user-parameter I cannot use a Workspacerunner in FME Server to run the entire script for each of the user parameters selected. Is there a way to allow a FME Server script to be run for each of the user parameters provided? There may be 1 or 8 user parameters for which the script needs to be run...

I have to POST JSON bodies to web api, but first I have to compress json by gzip compression. How could I do that?

I have several lines (streets) with a condition-value.In an (excel) table, I have many rows with condition-values and other attributes I would like to join. Now, coming from my streets I need to find the "nearest" value in the excel-table and join its attributes. What would be the simplest way to do that?I have seen an approach of calculating "distances" to each value and then sort by lowest distance... Any other convenient way? thx for your ideas, best regards from switzerland.

When using the POD writer I get a warning message "POD writer: Compression tolerance '0.001' is too small for the point cloud coordinates and may produce poor results. Adjusting compression tolerance to '1'

Dear FME community,I have a question concerning the creation of a web feature service. On the following web-page (https://community.safe.com/s/article/how-to-create-a-wfs-service-using-fme-server) I have seen a tutorial on how to create a web feature service. Here a SpatiaLite-file is loaded into the workspace to create the web feature service. I have a geojson-file with some 2D geometry in it. It contains a tile-grid made out of polygons. Is it possible to either convert this geojson into a web feature service or create a new tile grid with labeled tiles? It would also be nice if one could hover over the tiles to highlight them in a different color. The whole web feature service should have a very small file-size so that the web-map does not take very long to load.  Thank you so much in advance for your help! With kind regardsChristian

I have the following. Reading an XML file then assigning its geometry and an SDE connection. When the comparison happens with the change detector it keeps repeating an update. Even though the geometry hasn't changed.  The output of the change detector list: both are empty no spaces/tabs or anything of that nature. I can't even find where to set geometryObject or remove it. fme_geometry appears to be correct. 

Hi FMEers,Back in 2014 I wrote a couple of blog posts about tips and tricks for FME: https://www.safe.com/blog/2014/08/fmeevangelist127/https://www.safe.com/blog/2014/10/fmeevangelist128/ Now it's time to update my list to 2021. So what tips and tricks for FME in 2021 would you suggest? Are they the same as 2014? To me, FME is more mature and there aren't as many "tricks". And FME Server tips are becoming more dominant. Am I wrong?  So let me know what you think in the comments below - and maybe you'll get your contribution mentioned in the new blog posts. Cheers Mark

Hi everyone, I'm struggling with the PointOnAreaOverlayer transformer. For some reason the transformer is not finding a spatial relationship when there clearly is one. My workspace starts out with two SQL-creators (one with geometry and one without geometry) that I merge based on a matching attribute. This works as expected. Next I filter the merged dataset based on a numeric value.After this I use a Shapefile reader and the aforementioned PointOnAreaOverlayer to count the number of points inside the shapefile polygons. No matter what I try, the results show there are no points intersecting the polygons. I've so far checked if the FeatureMerger is merging the geometry, which it is. Checked if all the inputs are in the right projecten, which they are. I am using user parameters to set the filter range and to set the overlap count attribute of the PointOnAreaOverlayer. Next are a few screenshots to further explain the situation. I hope you can help me with this.  As you can see,

I used fme desktop 2019my source data is fgdb with 104,073,607 (104 million +)featuresorg table shows 104073607 but only 80,900,000 records processed.there is no transformers between , reader is fgdb and writer is oracle spatial data. dont know , where was the issue. This is a silent failure of fme.no error msg. after writing the checked the counts, it was less. then i splitted the fgdb files into two part(using arcmap)then im fine. how to fix this issue? Please  

I tried to use TwilioSMSSender to send a web link text message to my mobile. The text message was http://qgsp.maps.arcgis.com/apps/webappviewer/index.html?id=56fc6ae6f9cb4d5b8aaa554126cc50e0&find=260819MKY1 . However, the text message was always cut off by the ampersand “&”, which means my text message received was http://qgsp.maps.arcgis.com/apps/webappviewer/index.html?id=56fc6ae6f9cb4d5b8aaa554126cc50e0 .Any suggestions will be appreciated. Thank you.

Hi experts,I want to read the TAB file but with WHERE statement to filter the number of records that I want. It could not perform and run into errors like below. Could you help to indicate where I did wrong. THanks. I had tried without "" for the fields name, treating the values like string and not string.Performing query against MAPINFO_EXTENDED dataset `C:\\QV\\MapData\\PARCEL.tab'UniversalReader: Unable to emulate search type 'fme_all_features' because fme_where is requestedFeatureReader_2 (QueryFactory): A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details

Hi! Hope someone can help me out with this: I'm trying to create some sort of dynamic way to filter specific set of Attributes. Since the AttributeKeeper needs this input: AttributeName1,AttributeName2,AttributeName3,etc input, I was wandering if I can use a AttriubuteValue for this..but this is where I got lost;) I've created an attribute with concatenated list of Attributes I want to keep. But what would be a good approche to use this value to keep specific set of Attributes? cheers,ronald 

Hey community!How can I merge des points from a line into one line?I have a lot of "points lines" that I create with the transformer "Iterative Snipper" to chop that every meter in the lines. And now I want to merge every points in lines with color from points (attached picture). Tnkx a lot!

Hi all, I feel like I'm asking a well-trod question, but I'm having trouble with blank PDFs being output and am going a bit mad with the PDFStyler, PDFPageFormatter and TableAdder. Basically, I need to create multiple PDFs, grouped by username, from input Excel files. So far, with very little luck, other than the fanout naming (of these usernames). With the TableAdder I end up getting everything squashed into blocks of unreadable text, despite trying different values.  I wasn't sure if I was missing anything obvious, or if there was an easier way to start this process. Thanks