FME Form

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 warni

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 typ

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.

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.  

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

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

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!​

Hello friends,Im a new user of FME. I have a dgn file with hundreds of points with or without tags. i need to convert this dgn to shp with unique custom ids. Is it any procedure or transformers to do this in fme. I mean each point have unique id numbers I tried with many videos and tutorials didn't solve my issue thanks

I have two variables within a script tag in the head of an html document.What's the best way to extract those two variables?Both variables are json data.  In the end I want the geojsondata and I want to add the metadata to the geojson data. I can extract the strings for the variables using regex, but is there something better to read javascript? 

When I am translating Smallworld 4.2 using a seed file that has a coordinate system set the file that is created does not have a coordinate system set. If I create a file from within Microstation using the same seed file the new file does have the coordinate system set. I verified that during the translation using FME the correct Seed file is being used. I then created a translation of a V8i Microstation file translating to another V8i Microstation file using the same Seed File and the coordinate system is unset in the created file. Am I missing some kind of setting? or is there a know problem with Coordinate systems and Microstation files?

Hello! I am using FME Desktop 2021 and I have constructed a workbench that reads a CSV file with one column field. Each CSV row is a text string, which represents an XML document. It is used as an FME attribute inside a SOAP request template (XML template) to download and parse an XML document. However, the XML document could be referencing other XML documents via their respective text strings. If I extract these strings from the XML response, is it possible to feed them back as an input for my workbench and download them before moving on to the next CSV record? Apologies if the question sounds unclear, I can provide more info if needed. Any suggestion would be highly appreciated.

Hello,  FME Desktop 2019.2.3.3 Build 19825 Win64 I'm getting a few issues when using the Directory and File Pathways reader to get the subfolds in a directory.  I have a Published Parameter that is set up for File_Path input. If I put a path with a space in the name I'm able to see all subfolders when running in FME Desktop, but once I write to csv the file paths are truncated to only show the path up to the first space. Example:  In FME Desktop I see this: \\\\unc_path\\a\\b\\a b c Here's what the csv output looks like: \\\\unc_path\\a\\b\\a  That led me to try and add double quotes "" "" around the path in the P

Hi, I'm looking to update a value of an existing JSON structure once it has already been constructed.I feel I'm using JSONUpdater for its correct purpose, but might be messing up the syntax. Attached is how it looks for me:Does this appear to be the correct syntax for trying to modifying a nested key/value pair?I also wonder if using the attribute "ProgramProfile" for the JSON Text field would be a better approach, as it does show up in the list of selectable attributes. I have not had luck with this approach either though. JSON sample being used:{   "UserInfoList" : [      {         "IntegrationUserID" : "123456789",         "UserProfile" : {            "FirstName" : "Johnny"         },         "ProgramProfile" : {            "UserCategoryName" : "PLAC

Hi, I'm fairly new to FME. I'm curently trying to set up a workbench that reads data from multiple sources and merges it. However, I have to be able to work repeatly within a specific extent which is provided with a shapefile (see pic below). For now, I just wan to manually input a shapefile with one feature ( hopefully I manage to find a way to loop the procedure with many features but that might be for another question). Right now, I can't seem to be able to pass the extent coordinate (which I get from a BoundsExtractor) to the search envelop of a FeatureReader. This post (https://community.safe.com/s/question/0D54Q000080hXiFSAU/assign-bounding-extents-to-reader-search-envelope) talks about using spatialFilter after the Feature Reader but that means I have to read ALL the data and then filter it (which I do

Hello all,Since updating to FME 2020 (FME(R) 2020.0.1.0 (20200407 - Build 20218 - linux-x64)) the columns filter in the data inspector table view does not work most of the time.When clicking on the "Columns" button then selecting some columns to display, on clicking "ok" the columns displayed in the table view are filtered to what appears to be a random set of columns. eg. After selecting the following in the column selector:  Clicking ok results in the following columns being displayed in the table view: As can be seen, they are not the same columns. This happens most of the time, though it does occasionally work correctly. I do not know what is different when it does work. This happens when Data Inspector i