FME Form

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

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 Published Parameter which then gets to my second issue that it then adds commas "," into the path where the spaces are.   We'd like this workbench to be dynamic and allow any file path whether there's a space or not. Is there a solution that doesn't require my end users to change the file path to forward slashes, double quot

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" : "PLACEHOLDER"         },         "AddressProfileList" : [            {               "CountryName" : "Japan"            }         ]      }   ]} 

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 don't find very optimal).  Has anyone have an idea on how I can go around this?Kind regards,Anne-Marie  

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 is opened standalone and also in the Table View in the Visual Preview in Workbench.  This is also occurring in the Windows version of 2020 (FME(R) 2020.0.1.0 (20200407 - Build 20218 - WIN64)). It did not occur when we were using 2019.Does anyone know what is caus

I received a sample data file from a client who wanted me to convert all their files from CGI's OMS .gis extension or called the M3i format, data is for Electric utility. Though you can open the file in Notepad++, I tried to read it as well using Json Reader to be able to extract the attributes and geometry, but it seems it's hard to interpret the data structure from inside, to be able to parse it.. I also found this Safe webinar slides (here) talking about this format, and it looks like t's supported FME format thoughhere's a snippet of how this file looks like:GIS M3I standard data, version 1621295625593D702{GEOMETRY{SYMBOL{default;361368.971591387;194906.787360248;1;178621295625593D702{CONNECTIVITY{NODE{621295625593D702C1;621295625593D702C2621295625593D702{ATTRIBUTE{EQUIP_TYPE{ELBOW621295625593D702{ATTRIBUTE{STATUS{C621295625593D702{ATTRIBUTE{PHASE{B621295625593D702{ATTRIBUTE{ON_MAIN_LINE{T621295625593D702{ATTRIBUTE{DISPLAY_TEXT{\z3025J to 2433JB621295625593D702{ATTRIBUTE{TOOL_TIP{3

Hello, I'm using a WMS Reader to convert the wms to mbtiles. The workbench is called repeatedly for all my polygons (Bounding Box) with "FMEServerJobSubmitter" from a second workbench. The first conversions run succesfully but after a few iterations the process stops with the error:    HTTP/FTP transfer error: 'SSL connect error' Please ensure that your network connection is properly set up |No proxy settings have been entered. If you require a proxy to access external URLs, please ensure the appropriate information has been entered   The error occurs only in FME Server, in FME Desktop 2017.1 I do not have this problem.

Hello Friends, I'm new to FME.   How can I assign GIS Attribute field types in FME Attributes while converting.While Im converting ROAD_NAMEE given as character, after conversion its came as string in GIS. how can I get the same? PS. Converted from dgn to shp. dgn file elements are attached with tag. please help someone Thanks  

I'm using the EsriReprojector with source RD_New to destination GCS_WGS_1984 and geographic Transformation Amersfoort_To_WGS_1984_NTv2. Later I need my features to go back to RD New so I use the EsriReprojector again with the source and destination switched and the geographic transformation direction set to Reverse. But this gives me a different coordinate system: _Netherlands-RDNew-2008_0 instead of Netherlands-RDNew-2008 (what it used to be). Why is this a problem? Everything is projected with an offset of 100m.  When using geographic transformation Amersfoort_To_WGS_1984_2008_MB in reverse it seems to be fixed. Yet it still gives me the new coordinate system _Netherlands-RDNew-2008_0 Why, how, and will this give me problems when overwriting layers with Netherlands-RDNew-2008?  Any dutchies with the same question? 

hi，everyone,Thanks for browsing my question。I want add below map frame for my polygon,red is my polygon。how I cad export result to cad​.​

Hello friends, I’m new to FME. I have two dgn files for roads. One file for the central line of roads with all tag details. The other one is a new file, filled roads (create as region in microstation) based on the center line file. I would like to combine these two files and the output should be only one shp file. Not required the center line on the final shp. All tags should be as attributes in shp. Only the tags to copy from centerlinefile to new file which is falling on the top of the filled shapes. (like spatial join in GIS) Using Products : Microstaion SS4, FME Trial Thank you Chithra

Hello FME-Users,I have a problem with my CityGML Data. I want the final results to look like clean OBJ Files. When I load them into e.g. 3Ds Max they should have no errors. I also do not want faces to be seen in my 3D software. Instead I would like to see proper polygons (if quads are possible, I want to see them; they can be made out of triangles, but these triangles should be hidden).I found this image on Wikipedia showing the different possible Elements of a mesh:   My current FME workflow looks like this:  I have buildings made out of 3 elements: Groundsurface, Wallsurface and Roofsurface. I would like to bring all of these together as a mesh (with polygons). I used the GeometryCoercer to convert the rawdata into polygons. The MeshBuilder is used to create a mesh. Here I think my polygons were converted into surfaces... Below I also provide you with my settings from the Deaggregator and the Coerser.  In 3Ds Max the buildings look like that:this looks really faulty... The files are