FME Form

FME Version: FME(R) 2018.1.0.0 (20180717 - Build 18520 - WIN32) My workspace is built to identify points that are from a certain distance from a line featureclass. I use a neighbor finder to identify the points. While using the base and candidate features as points and lines respectively, I achieve what I want except for an error i.e. IFMELine was given an index beyond its current range. Despite this error, the translation runs successfully. On trying to find similar issues, I found this post that said it could be because the point is past the line. https://community.safe.com/s/question/0D54Q000080hgTy/neighborfinder-try-to-get-elevation-but-get-this-error-ifmeline-was-given-an-index-beyond-its-current-range One way I could circumvent this is to also convert the line to points using a chopper or so but it is not desirable for the the vertex could be farther away from the line itself.  Would anyone know what would be the best way to resolve this?Is there a method to identify these probl

Hello everyone, So I have two data set (Set A & Set B). I want to find how many B polygons are overlapped on A. I am able to find the overlapped polygon attribute by using spatial relator (by explode the list). However, the geometry of the exposed list is not correct. They all have the same geometry (from the test filter transformer). Is there anyway that I can have both correct attribute and geometry? Thank you for your help.

FME Desktop 2020: The “dissolver” tool fails to dissolve adjacent polygons based on their colors, In the screenshot below, I wanted to dissolve polygons based on their color. At the marked location, I expected that these polygons should be dissolved. However, they don’t and a line is still appearing. What could be the issue here? The data and workbench are attached     

I'm manipulating an IFC file, writing it back to IFC with a few changes. So far I couldn't figure out how to write a Material Layer Set. I can see it is defined in the geometry traits of my original IFC file but when I write it back out it seems to remove the information. Has anyone done this?Geometry traits on original IFC:Original data:IFC file translated with FME:

I have the following string: mapMarkers.push(bap(map,'','marker.php/oaaa/BusShelter:BusShelter:BusShelter/EB:WB:EB/1/null/null/39.69643098429845/-104.88185718655586/null','','interactive_view:f=D0007.1.1.1|f=D0007.1.2.1|f=D0007.1.3.1',1, null, null, 1, null, null, ["BusShelter"], true)); I'd like to extract the lat/long values as well as any values following f= So for the example above, I should get the following attributes: Lat=39.69643098429845Long = -104.88185718655586ID1 = D0007.1.1.1ID2 = D0007.1.2.1ID3 = D0007.1.3.1 Do I use a stringsearcher with a regex? If so, how?

Is there a reason why I can not setup a fme workspace on FME Server that accepts POST requests? It would be much cleaner to accept data in a post request. This would also allow for accepting image and other large binary data to go in to my workflow.

I'm writing data to a hosted ArcGIS Online feature Service, one field is of type string but I sometimes writes an integer to it. When I do that the number is converted to decimal. So 25 becomes 25.0.Has anyone solved this (without adding a space at the end)? 

Hi, I am using a PythonCaller to create an XML string. When I send this string through an XMLTemplater, all "<>" brackets are converted to "<" and ">" (html encodings). Adding a StringReplacer/StringPairReplacer to replace all brackets works fine but can take some time for larger content . Is there a way to prevent the XMLTemplater from converting brackets to encoded brackets? becomes:

Is there a Transformer that lets you download OSM/Openstreetmap Address points for a country?

When using the ArcGIS Online Feature Writer, sometimes during truncation, AGOL will encounter an error on delete.  It looks like this:2022-01-12 18:39:01|  25.9|  0.0|INFORM|ArcGIS Online Feature Service Writer: Truncating layer/table 'Meters'. 2578 features remaining2022-01-12 18:39:39|  26.1|  0.2|INFORM|ArcGIS Online Feature Service Writer: Truncating layer/table 'Meters'. 1578 features remaining2022-01-12 18:40:47|  26.2|  0.1|WARN  |ArcGIS Online Feature Service Writer: 'deleteResults' error for a feature in 'Meters'. The error code from the server was '1018' and the message was: 'The specified feature could not be deleted or does not exist.'2022-01-12 18:40:47|  26.2|  0.0|WARN  |... Last line repeated 315 times ...2022-01-12 18:40:47|  26.2|  0.0|ERROR |ArcGIS Online Feature Service Writer: 6000 features successfully deleted from layer/table 'Meters', but the server rejected the 1000 deletions in the last request due to errors. See warnings above. Aborting translation2022-01-12 

I dug around the Google Maps API documentation but I can't seem to figure it out on my own.

We are using FME Desktop 2022.0 Beta and have created many workbenches for nightly data processing. I want to run these in varying sequences using python but cannot get fmeobjects to load. We are running Python 3.7.11 64-bit (arcgispro-py3:conda) installed with ArcGIS Pro on a windows machine. The following code fails on import fmeobjects: ImportError: DLL load failed: The specified module could not be found.import syssys.path.append(r"C:\Program Files\FME\fmeobjects\python37") import fmeobjectsI see many posts pertaining to this issue but none of the recommend approaches work. I have also tried adding the path above to my PYTHONPATH with the same results. Input?  

Hello everyone, I should start by saying I'm an FME beginner user. I'm currently toying with an old ESRI coverage dataset that still has some importance. The files are split by index (grid) and so each layer is stored in a separate folder like shown below. My goal is to extract the data from only one theme ("batim_p" which is building point data) and to merge it into a unique layer. Although the schema is always the same, it is possible that some index folder do not hosts the data folder. The thing is that I have an arcpy script that does this within about 40 mins but the FME process I constructed (which basically is only a feature reader) takes almost 10 hours to do about the same thing. I believe my problem comes from the fact that the reader scans EVERYTHING, although I have only selected the feature type of interest in the initial parameters. So I tried to work around this by using a Path/Directory reader to extract the folder name and THEN use a featureReader t

I've been noticing something and having trouble resolving it.  I have a workflow that runs every half hour, it runs fine however I noticed that it is creating a legend.tiff file in temp in a numbered folder within /tmp. This does not seem to clear and is about 1GB. I would like if this file was not created or at least removed when the process finishes. It will eventually create too many of them and lead to the disk getting full. I can remove them manually or with script on intervals, however I feel there must be a way for FME not to create them. If any one has any tips on what transformer is creating them that would be great.

I'm trying to create a relationship (1: n) between a shapefile and four tables and publish it in an FGDB. I created two columns with AttributeCreator (goedb_feature_has_relationships) and (geodb_oid). As a writer, I have four options (see the following figure). I selected (Esri Geodatabase (File Geodb)).I noticed that format attributes from my writer doesn't contain (goedb_feature_has_relationships) and (geodb_oid). It is the same with other writers. Because of this, no relationship is created in the end. every excel file has a relationship (1:n) with my shapefile. I would be grateful if you could tell me why the problem is. Many Thanks. 

ContextI am building a custom transformer. I need to transform input features into points to process them and then build back the features geometry before to output them. Output features are expected to have the same geometry type as input ones. ProblemI thought I could just reconstruct the geometry of the features using the LineBuilder transformer, but it creates polygons with closed lines, even when the input feature is a line (fme_line), not a polygon. QuestionHow can I reset the features geometry to their original ones before sending the features to the output port? The GeometryCoercer could do the job if I could set the output geometry at runtime (e.g. using an attribute with original fme_geometry value).

Error message when converting four shapefiles into one FGDB. Error consists of:An error occurred while attempting to create the feature class 'SB_Aussenkasten'. The error number from ArcObjects is: '-2147220649'. The error message from ArcObjects is: {Cannot create double column table.}I would be thankful. if someone could tell me what the problem is. Thanks very much.  

Hello FME community, I have an excel file with the following columns (please see Photo) and would like to convert it to line (FeatureClass).I would be grateful if you could give me a hint.

I have imported data, from a shapefile, into an existing object in Smallworld before but we recently acquired a smaller Telco and will be importing their data into ours. I have a reader (shapefile) transforming into an existing object in our Smallworld writer.  In the type_ field of the shapefile there is data that matches what the spec_id should be in the SW object, and the spec_id field is an enumerated (integer-string) list. I have changed the data on the shapefile side to match what the spec should be, both integer wise and string wise. I'm still getting the Translator Error: Value "x" not in enumerator set.  I've tried to run just a basic import without setting the spec_id field from the shapefile and I get specification is mandatory error in the magik prompt box on the SW FME session. I'm sure this is a user based error, but have tried this on multiple objects and still running into the spec_id issue.  Thanks for any help.   

I am using a featurewriter to overwrite 2 feature classes in a file geodatabase. The attribute definition panel shows the correct GlobalID and guid types. However, the result is string fields. Any ideas?

Whenever I run the workspaces, it ends up with "Error running translation" at the first process of the translation. This occurs in all workspace files including official training files or most simple translation such as xls to csv.My work environment is MacOS Monterey (MacBook Pro 14 inch M1 Pro). And there are no problems if I run the same translation on Windows PC.

This has been asked before, at least here and here.  The problem is best described in the picture, with the starting point on top and desired outcome below. The data is huge, so manual attribute creation is not an option, the attributes should be generated like "Year@Value(number)" and "Explanation@Value(number)"I have tried the method used in these, with AttributeCreator with every option I can imagine, but to no avail. I've used it in conjunction with AttributeExposer, but without any good outcome.  Dear all, is there a solution to this?

Hi, I have bottom hole well locations in the attributes of surface hole well locations shapefile. I need to read those coordinates and generate a new shapefile in FME

I'm using an SQL Creator to return data from three tables (Microsoft SQL Server), one of which contains a geometry column.  Initially, I was just joining two tables and this all worked as expected with the geometry being correctly displayed within FME. When i amended the SQL to include a third table, the geometry column seems to have stopped being interpreted as geometry and is now displayed as an attribute containing binary data.  A bit more investigation, if I limit the fields being returned by the SQL creator, the geometry is interpreted correctly (bottom SQL creator). If i attempt to return all fields (explicitly naming or using *), the geometry field is returned as an attribute   Additional information, only the table I'm attempting to get the geometry from has a geometry column. Am I missing something obvious? FME(R) 2020.2.2.0 (20210111 - Build 20817 )

Hello, here is my question. I have two table. The first table is like a glossary. The second table is the input data.​Table 1 (glossary)​Number Fruit1-1 banana;apple <= (meaning can be either banana or apple)1-2 orange​Table 2 (Input data)Number Fruit1-1 banana1-1 apple​So my goal is to see if table 2 match with table 1. I have a input data (table 2). Both are number 1-1 and the fruit name also match with table 1. Hence, both the result should be passed.  However, I am not sure how to do the matching. As the table 1 fruit name is "banana;apple", separating by ";". I would like to have some guidance. Thank you very much!​