FME Form

hello there we need to aggregate all features into one, we are unable to write it to PostGIS or shapefile, by checking the geometry we find type collection how could we solve this and write the output, all features are line features Thanks 

I have a column in a table with names and I want to find the ones with alphanumeric string and replace it with a null value. Apparently this is erroneous data in the table.  Sample Data in the column NAME:GREEN-BROWN TREES --> Leave as isFORT/STRONG -> Leave as isPEACE RIVER --> Leave as is3T7H8HF54FD --> This is the data I want to find and replace with Null Greatly appreciated. Thank you.  

When running "my" workspace I get an error at the end of the translation, after writing the output, with the message: "Error running translation." No further errors are given. The tail of the output:==============================================================================Total Features Written                                                      32=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-Translation was SUCCESSFUL with 773 warning(s) (32 feature(s) output)FME Session Duration: 1 minute 10.3 seconds. (CPU: 40.2s user, 6.5s system)END - ProcessID: 1680, peak process memory usage: 320516 kB, current process memory usage: 172000 kBError running translation. The workspace converts a DWG to GML. It uses an Excel sheet for some mapping rules/lookup tables. Other DWGs do not have this problem, only two DWGs cause this. The DWGs are not corrupt, at least AutoCAD complain that t

I know this can be done, but can not find the right way:How can I add the current Date and Time in the name of the Log file?Preferred format is: YYYYMMDDH24MIAny help is appreciated.

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"

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

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 geo

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​