Best Answers

table 1table 2 Expected result is : table 3:actgeneric_id------- fNotam_id1.2.1.1.3.1 ---------- 1.2.1.1.31.2.1.1.3.5.1----------1.2.1.1.31.2.1.1.3.5.2----------1.2.1.1.3 .... .... ..... .....1.2.1.1.4.1------------1.2.1.1.41.2.1.1.4.2------------1.2.1.1.4............ 

I am trying to use SpatialRelator with SDE and GDB layers that are the same data but the data is not matching up. I am using "Requestor OGC-Equals Supplier" to compare the layers. The point is when we get new data we can uploaded only the changed data into the SDE but I am unable to get the layers to match up. Both are WGS 84 and line up in FME Maps and in ArcGIS Pro they also intersect when running tools. There is no errors in the FME work flows that pop up after running it.

Table A:Table B:Result:How can i do it with Feature Merge transfomer in FME 2016 Build 16494 ? pls ..

Hi everyone, I am trying to download a set of files with the AutodeskBIM360DocsConnector and save them to a temporary location. The temp location is generated with the TempPathCreator. The BIM 360 connector does not have the option to pick an attribute for the "Download to Folder" parameter. Typing out @Value(DownloadLocation) seems to trigger FME to recognize that I want to use an attribute value, however during translation the attribute value is ignored and instead FME uses the string I typed in i.e. it creates a map named "@Value(DownloadFolder)".   

Hi FME Community,I have converted my Excel file into a CSV file. I would like the heading to be automatically deleted.In the picture I have shown with red marking which part has to be deletedI would be grateful if you could tell me whether there is a solution.Thanks in advance

I have a basic project as shown in the screenshot. In this example there are 54 items that need data cleansing (at the rejected port), I am wanting to send ONE email at the conclusion of this run, with a list of all the Property Numbers that were captured here.  If I add an emailer at this 'rejected' port I will get 54 emails. I am assuming there is a simple way to list then expand into the body of a single email? 

Hello everyone,​So I want to do something similar to "IMDF Validator".​My data format is "GeoJSON" in one single file. When I import the data, it will break into 4 feature types. ​I just not sure how to set up something similar to IMDF validator, with "Creator" at the front (just like the picture I uploaded? Also, the user parameter of IMDF validator is set default in ZIP file, yet I have to set it to geojson file.​Should I use Create Custom Transformer? But I am not sure how to set the parameter. It is because my data will be getting more and more complicated. I have to make it more tidy first.​Thank you in advanced. Zach

So I have multiple columns of data that return a yes or no value. I'm really only concerned with the yes value.  When the value in the Cut Grass attribute is 'Yes' - i want to replace the Yes with say "cut grass to 100mm"Then i have another Yes value in Remove Flammable materials column and I want to replace the Yes with "remove materials".  Is there a multiple string replacer transformer that I can use.  I need to do this for approx 13 different attributes. I have read about string replacer or attribute value mapper. But whilst string replacer can replace multiple attributes to the same replacement text it doesn't allow for differing replacement text individual to a column.

I've configured the SMTP Publisher to receive emails, but when I send them to FME Server I get undelivered responses.  I looked at the email.log for the FME Server Publishers and I see: "WARN Email received for unknown recipient [email address], so dropped  What does this mean?

Hi FME Community,I would like to reproject my file into another coordinate system. I am looking for correct coordinate system. ArcMap gives me a correct result. FME gives me wrong coordinate after the reprojector.the pictures show which coordinate systems I used in FME and ArcMap. In addition, my file belongs to Germany. Thanks a lot in advance   

I think it takes a lot of time to convert one by one.

Hello,I have the feeling that I want to do something very simple, and probably the answer is simple as well 😅 But I just don't know how to accomplish the following:I have a column named Period with the following values2017-012017-022017-052017-062017-092017-102017-12How can I add rows with the missing periods, so that I obtain the following table:2017-012017-022017-032017-042017-052017-062017-072017-082017-092017-102017-112017-12I don't necessarily need to automate this. So I am ok with typing in the new values (2017-03, 2017-04, 2017-07, 2017-08, 2017-11) in a transformer. But which transformer do I need for this? Thanks in advance,Eva

Hello I was wondering if there is a function that blurs car number plates and peoples faces in multiple images? thanks for any help you can give

I have a Salesforce custom object with 2 master-detail fields that both have read/write permissions. When I attempt to write to this object, I receive the "REQUIRED_FIELD_MISSING:Required fields are missing:" error. The two fields referenced are the 2 master-detail fields. The fields and the data are present when the write occurs but for some reason I receive this error. Any ideas?

 We're moving a database into Azure but all of the FME Azure writers assume it's an MS SQL database, and the MariaDB writer doesn't have any SSL settings.

Getting back to my little project started here after a brief hiatus... I am having trouble making a file uploaded to the 'Resources' folder using the Javascript API the input for a workbench. Using ...FMEServer.dataUpload( repository, workspace, fileObject, session, callback);I can get the file to be uploaded to here:$(FME_SHAREDRESOURCE_TEMP)/upload/MyFolder/MyWorkspace.fmw/Now, I want to use:FMEServer.runWorkspaceWithData( repository, workspace, params, callback)to process the uploaded file but all attempt to feed in the correct 'params' is failing. The workspace is still going back to the default parameters that it was published with. Currently, I'm trying this:var params = {          { "publishedParameters" : [{ "name" : 'SourceDataset_CSV2', "value" : <resourceFolderPath+inputFileName >},{ "name" : 'DestDataset_JSON', "value" : < ?????>}],  "service" : "fmedatastreaming" };Not sure  what to put for the destination value that I'm trying to capture. Javascript API docume

How to export "Feature output statistics" table for "Features Written" produced in the translation log? It will be nice to have this exported as an excel format. Thank you in advance!

I used to convert to/from Norwegian standard format SOSI, but since my latest FME update SOSI seems to have disappeared, I'm left with SOSI/GML which (I think) is not the format I need. What has happened here?

Please share the installation guide for FME server 2013 and lmgrd license configuration

I am trying to figure out on how to be able to convert points to lines using a field attribute value from the point feature class. The center would be output to the center of the point and have a length equal to the attribute value on a specifc field, half of the length to the right and the other half to left of the point. Thank you

I am trying to do an insert to CARTO table. It is mandatory to not drop the table because it is necessary anytime a table is created to make a specific SQL statement. This table just has to have the last insert values so a truncate command is required. I have tried with a SQL Executor with two statements. Truncate and Insert. What SQL Executor does is a truncate for every insert. At the end I have a table with only one row, the last value inserted. Any ideas?

Hi everyone,  Every time I load a reader into Workbench I get an error similar to this "Workspace generation failed. Parameter file was /private/var/folders/tr/rfmmyq590j17jq9ndl8my5lh0000gn/T/FME_1635634267372_8830."  Not sure what the issue is any help would be very much appreciated.  

Hi everyone,  I'm making a workbench where I try to write to a file GDB. To be able to use a fileGBD FME needs to be able to detect a ArcGIS license.  We do have arcmap and arcgis pro, but not on the virtual machine that runs FME. Do I need to install arcmap or arcgis pro on this machine to be able to write to file GDB's ?  thanks in advance

In the JSONTemplater is there a way to cast an array of strings into an array of intergers? https://community.safe.com/s/question/0D54Q000080hA0SSAU/how-to-coerce-attribute-type-for-jsontemplater?t=1636407693748  answers the question for regular attributes   but this does not work with fme:get-list-attribute. {"ids": [(fme:get-list-attribute("_list{}.id"))] }returns {"ids": ["1","2","3"]}    I would like{"ids": [1,2,3]}  

Hello FME Community,When I write the result, I choose Fantout based on an attribute. As a result, I get my data in Folders, but I would like to get my results not in a Folders but one after the other. I want to know if there is a solution for this. (The pictures show what I get as a result and what I actually expect)