FME Form

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.

FME Desktop 2020: How the “dissolver” tool can aggregate the result? I couldn’t figure out if the “dissolver” tool can aggregate the result without the need to use the “aggregator” tool In the screenshot below, when dissolving and aggregating according to the “autocad_color”, the result should be two features      

Hello!I'm trying to use the following to find the position of a character/string in one of my attributes:@FindString(@Value(ColumnName),TEXT,1,caseSensitive=TRUE)When I replace TEXT with the text I am searching for, this works as expected, except for when the text to be found is a parenthesis, i.e. ( or ). In that case, the function interprets the parenthesis as the start or end of the function's arguments. I tried to escape the parenthesis using a forward slash (as suggested by the FindString() documentation to escape a quotation mark) as well as by surrounding it with quotation marks (as suggested by the FindString() documentation to escape a comma), but neither of these work.How can I properly escape ( and ) inside the function arguments?Thank you!

I have a single fixed license that I use for development work and a floating license that I use for production work. How can I easily switch between the two? Right now I have both added, and when I'm off network, it takes FOREVER for FME to presumably timeout with the floating license and try the fixed license.

FME Desktop 2020.0.0.0: What is the best practice to fix issues identified by “geometry validator” tool? For example, in the screenshot below, I got 1 failed, 4 invalid, 5 locations. What could be the best practice to fix them? The data is attached      

The question is about , the process of transferring FME Desktop licenses from one department to an other in the same organization with two different license servers. Do we need to give the license that are being transferred back to Safe again and ask a new licenses on the same account? Are there differences between a floating an single fixed in this operation? Are there other things to take into account in this operation? Thanks in advance.

using neighborhood find we need the workspace when the candidate find the base we don't want this base to be used again in the process even if it fit the transformer setting Ex: I have 4 polygons and 5 Points we need to find a point within a distance of 1 m to polygon, 2 of those points are within the distance, our goal is the process when we found the first match the second one should not be considered the parameter( number of neighbors to find ) is not working since each point will find 1 neighborhood, if one point find polygon, that polygon shouldn't not be used by another point Thanks 

I try to make a setup of a script workbench and a runner workbench. The script consists of a postgis feature reader and a gdb writer. The schema of the postgis feature reader is defined as a user parameter, and so is the destination of the gdb writer. The runner consists of a Postgis reader that reads a table containing schemas and paths for the gdb, and a workspace runner that runs the script and defines the user parameter mentioned above using the schemas and paths from the PG table.  However i just this error when trying to read the table of the schema: "021-12-21 12:53:57|  0.1| 0.0|ERROR |Error executing SQL command ('select * from "FME_PostGIS_SCHEMA"."DF_Mast" where false limit 0'): 'ERROR: relation "FME_PostGIS_SCHEMA.DF_Mast" does not exist" So it just inserts the name of the user parameter rather than the actual schema it was support to insert.  I hope you can help.  Regards Rasmus

I have a workspace with a single 3D model (a tree) and a point dataset of several thousand points. Is it possible to replicate the 3D model and geo-reference it for every point?

Data: