FME Form

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 th

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.

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

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

I created the grid, but I don't know which transfo I should use to clip the objects (clipper doesn't seem to be the correct one). Thanks in advance!

FME 2016 Build 16494 I want to automatically filter each info field value and the workspace will run them one by one. It's like:ThenandAnybody help me ! pls ....

i would like to merge the output pdf that include image to put directly inside sheet file at excel file . Do we have method to do that inside FME workbench ? or is there a method by using python in workbench to do that?thanks in advance .FME 2018

I have a line that I try to divide in smaller parts of 5 m each. The line is is from a shapefile. When I try to use the chopper it divides the line in random parts, varying in length from 7 to 113 meter, but in not a single case in 5 meter. Am I doing something wrong or is this a bug in the transformer?Hope someone can help.

Is it possible to save temp to DFS when declaring environment variable for FME_Temp? We currently would like to seperate the temp data that gets created when running a work space to hit DFS, which resides on premium SSDs, as well as benefiting from deduplication. Is it possible to do this via DFS going across the network, it sees the location specified within the user environment variable pointing to it's respective location on DFS. It also creates the folders on DFS, however it still writes to the C volume of the session host being ran on going to C:\\users\\users\\username\\appdata\\roaming\\safe software\\fme. Or is this only possible if I added an additional hard drive to our virtual machine, then brought online and provisioned, and changed user environment variable for fme temp to point there? I'm new to the application, and if anyone is able to assist, it would be vastly appreciated. Thanks!

I am reading in a complex CAD file from our engineering team. The DGN has multiple reference files, but the only information I need is the annotation layer. Specifically, the callout boxes and the leading arrows. When I read in the DGN as a Microstation v8 file in FME Data Inspector, the callout boxes are shifted in the wrong spot and the arrows are missing. Any ideas of what could be wrong and how to fix it?

When creating Areas from Lines using Areabuilder some areas are lost in the process. One example in the attached workspace, data and images is an area with "externid" "0381>NYNÄS>1:7>2". Not sure how many others are missing.

Hi,I am trying to create a map in a raster format and write it to MSWord ( using MSWordStyler) however I seem not to be able to create a legend for my map. ( a table holing the name of the attributes visualised on the map and their symbology on the next column) in my case the symbology is easy. just colored circles.Does any one have an experience with this orhave an idea what transformer to use in order to get this result? the part of my work space that creates the raster map:

Hello colleagues @Takashi Iijima​ . For the third day I have been trying to figure out how to configure Xmltemplate, but my programming skills are not enough((. Help to configure the Xml template to create a working xml file.Here is a sample of the result, all the pictures are arranged in their own groups<?xml version="1.0" encoding="utf-8"?><BlocksExchange version="3.2"> <Block> <Name>Block_223-32</Name> <Photogroups> <Photogroup> <Name>Photogroup 100_NS</Name> <ImageDimensions> <Width>31580</Width> <Height>13904</Height> </ImageDimensions> <CameraModelType>Perspective</CameraModelType> <CameraModelBand>Visible</CameraModelBand> <FocalLength>149.842</FocalLength> <SensorSize>118.741</SensorSize> <C

I'm probably wrong somewhere