FME Form

Hey,Since a day or two I can no longer read my data. I always get the same error, even when I try it in another workspace. Does anyone know what it could be?I use FME 2021.0 and i'm trying to read a postgis table. ThxNathalie

Below is an example JSON response body for a single feature. What I want to do is extract all of the "points" elements (in bold) as a list. Which transformer should I use?How would I write the syntax to extract the detail in bold through a JSON query?Can it be parsed as an attribute? If so, how? {  "id" : "feature1",  "name" : "Feature 1",  "length" : "5,000 km",  "points" : [   {     "id" : "loc1",     "name" : "Location 1",     "country" : "CountryA",     "is_tbd" : null   },   {     "id" : "loc2",     "name" : "Location 2",     "country" : "CountryB",     "is_tbd" : null   }  ],  "notes1" : "test",  "notes2" : null}

Hi all,I have a polygon file that have field area, plot_uuid. I want to dissolve small polygon area <0.03 into the same plot_uuid.Could you tell me how to make it?In the below photo, 2 small polygon (yellow and green) will merge into large polygon that I want in the right photo.Thank you

I cannot for the life of me figure out how to apply a single attribute value from one table to another attribute in another table. Please help! There are no common attributes between both tables, so a FeatureMerger does not seem to work.

Hello there, So I have two attributes: "Floor" and "Purpose". Floor Purpose1 Lobby2 Restaurant3 Swimming pool So I want to verify the dataset. If the "Floor" is 1, "Purpose" must be lobby. May I ask what kind of transformer I should use? Thank you very much.

I am working with csv file which has field names that change. Field names are dates. I have the parameter for today's date, so I want to find the field which name has today's date and rename it to "TODAY". How can I do it?

Hi all, I have a polygon file. There area many small polygon like 0.00001, 0.0022,...I want to eliminate small polygon into bigger polygon based on query area. Could you tell me how to do it in FME? Thank you

can we connect to sde database and create our own version in FME? I would like to automate some processes that require editing in sde but in a version so we can verify changes before posting to the default database.

As input I have a csv file. The column names are dates. I use python to download it from an ftp and then merge with a spatial dataset to create polygons. I usually update an AGOL service but I don't know how to update an AGOL service if my column names (attributes) are changing daily. This would require to delete and republish, but FME cannot publish a service, can just do an update. Any help is greatly appreciated!

the ultimate goal is to have two outputs, the selected line or lines based on an attribute value and the neighbouring/adjacent lines within a 100m buffer. So am wondering what would be the best way to loop through the million records selecting features by attribute value then run the process and then the next batch so on ...? any help in decoding this will be highly appreciated.

Hi! For the transformation of a big data set I used the tiler. I now want to run the translation by picking one tile after another (run them sequential) but write the tiles into the same writer after the calculation,is there a tool I can use to fix this?

I am trying to export a SDE database into a file geodatabase with the domains intact. I first used a dynamic reader and writer, but only the data was written into the file geodatabase. I thought maybe I could use an xml schema file to bring the domains over. I used arcPy to export the schema file:arcpy.ExportXMLWorkspaceDocument_management('C:\\data\\connectionfile.sde', 'C:\\data\\output.xml', 'SCHEMA_ONLY', 'BINARY', 'METADATA'))This produced a schema file and I can open it in a text editor and see that it has the domains defined. However, when using this file in the "Import XML Workspace Document (Schema Only)" parameter, I get the following error:ERROR |Unable to import schema from template 'C:\\data\\output.xml'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create a table with a duplicate column.} I also get the same error when trying to use the Esri Geodatabas

My transpose is easy but cannot figure out how to do it in FME. I checked this article alreadyTranspose a Table Using FME (safe.com)I have my data with unique rows, but I want to create one row per column type instead.From my data:TO resultI tried the custom Attribute Transposer from the article but get missing values and columns

Dear Community, I would have a few questions for CityGML building.  I have a SHP file with building polygons (roof, wall, groundbase), and I would like to build a proper cityGML file. I read over the whole forum and also CityGML specification, but there is no description, WHICH attributes MUST be defined in case to have a proper CityGML output WITH geometry. In some of the forum topics here, there were good spots, and sample workspaces, which can be used to build simple buildings, but to build from SHP polygons, it's seems though for me. I'm trying to build a LOD 2 model. I have my walls, roof, ground, and the whole thing aggregated together (So I have the exterior shell and parts separately) They all have unique parent ID per building, set LOD name, feature role, geometry type and other attributes, which I found set inside related questions in this forum. But when I run the translation, I always receive a data set with no geometry inside, if I try to build a proper building mo

Upgrade: If we're only upgrading from 2021.2.0.1 (21789) to 2021.2.1.0 (21797), do I still have to have my DBA wipe out the tables and create new?

I have a shape file which has several names in it. These names comes under 6 departments. So i want to create an attribute named as department. I have the csv file where it is mention which name comes under which department.

I added a dropbox web connection with my concern user, everything worked out. After that, I wanted to add another dropbox web connection, but this time with another user. Unfortunately the login did not work out (see screenshot). I tried to clear cache and cookies from my standard browser, change standard browser to be sure that nothing is cached in the background, but still the same message appeared. I also tried to delete the other web connection, but still same issue occured.Does anyone have ideas how to solve this?

inputpossible output Shape column

FME Desktop 2020.0.0.0: How to filter based on exact two values? For example, in the screenshot below, I wanted to filter all the values that exactly have the number “10” Or “11”.  Then why the “101”, “102”, “110” are filtered with the syntax above?      

Shape

I'm using the FuzzyParallelLineFinder and want to aggregate the line pair geometries that were identified. Then, turn into a CAD block with unique ID, and/or WKT format in a spreadsheet.  The way it identifies parallel lines is : _line_id of one feature = _match_id of another and vice versa.  I attached a Dynamo script picture that does what I am looking for.  Thanks,@larue​  

Overall goal: Pair-up respective wall lines from a CAD drawing floor plan.Challenge: NeighborFinder will return most wall lines properly, but if there is a condition of 4 equidistant lines, the interior ones will be picked twice, one on each side. I want to have 2 discreet pairs: For context:After trying FeatureMerger in various ways, I think that a loop is my only option. Here is what I have so far:What am I missing? Thanks,@larue​   

I am able to create separate Excel files for each data source processed in the batch routine (consecutively), but can't figure out how to append the output of each translation into one file. The schema is the same throughout. Thanks, @larue

In enforcing our custom transformer naming convention we needed to rename our custom transformers in the CT library. I found the CT name was grayed out when opening up the Transformer Parameters editor (image below) Please kind share your solutions or suggestions?

I have a python script that I want to know how to run in FME that way so I don't have to manually trigger it? Any advice would be greatly appreciated.