FME Form

Hi everyone,I am brand new to FME and created my first workbench. In a nut shell it does this:Brings in 6 different enterprise geodatabase feature classes using 6 ESRI Geodatabase (ArcSDE Geodb) readers Each reader is connected to a tester to only select ‘active’ values in a status field Because I selected ‘resolve domains’ in the reader, an additional field for every field that had a domain was created. It was suffixed with “_resolved”, so I used 6 bulk attribute renamer transformers to rename the fields without the ‘_resolved” I then did 6 attribute removers and removed any fields I did not need when it came to exporting (note, many of the fields between each feature class were the same, but there were some differences) Finally, I used 6 different feature writers to export each feature class into a single geodatabaseAs you can see, I repeated the process 6 different times for every reader/feature class that I had. I was thinking to myself while doing this, ‘this cannot be the right w

Hi,I would like to create a workspace that reads all tables that start with the same prefix. I then want to save the result per table as a shape file. If a table is modified by a add or remove an attribute, the workspace should pick this up automatically. Is that possible? My first thought was to work with a dynamic reader, but then I get stuck that it will retrieve all tables, including in other schemas within the database. The second approach is, I create a query that generates select statements and puts these statements in a text file. I then read the text file with a textline reader and install an SQLExecuter. That's all going well.What I run into is that the SQLExceuter cannot automatically expose all attributes.

Hi, I need to find into a network of GPS lines the location where 2 line overlaps or where a single line overlapThe problem is that of course the lines aren’t exact the same (the lines derived form GPS points so I don’t have a duplicate geometry) and only a portion of this lines overlapssee picture attacherd If you need the sample of shape dataset let me know thx Francesco 

Hello Everyone, I have two datasets, which I essentially want to stack on one another. One datasets has data on rivers, streams, and brooks, while the other has information on ponds, lakes, and reservoirs. They all have the same attributes, so I just want to add the pond, lakes, and reservoir data as new rows in the river, streams, and brooks dataset. Can someone please help me figure this out?

Hello everyone,I encountered a similar issue as the one described in the following post:https://knowledge.safe.com/questions/95574/problem-with-postgis-reader-in-fme-2019-infinity-v.html Basically I had an invalid date in my PostgreSQL table (no idea how it got there). It had a value of 201910-11-10 which of course is not valid whatsoever. FME 2020 ( Build 20238 - WIN64) throws an error when you try to read this table using a Reader, a FeatureReader or an SQLExecutor/creator.I was able to bypass this by adding a where clause upon reading (e.g. mydatefield < '2021-01-01').I'm not looking for a solution for my problem here. I just wanted to add this to the forum so that people who encounter a similar issue know how to solve it. The FME software currently throws an error which is not really useful for debugging purposes (POSTGRES reader::bad_expected_access).

Hi,I’m using XSD Driven XML Writer with XSD’s specified in schemaLocation. When I use absolute paths it works fine. When I try to use relative paths to the schemas I receive a error message.http://www.company.de/example file://${FME_MF_DIR}schemas/app-schema/somename/5.1/somefile.xsdEnds up in an error:XML Parser error: 'Error at file: '' line: 0 column: 0 message: unable to open primary document entity 'C:\Windows\System32/file://${FME_MF_DIR}schemas/app-schema/somename/5.1/somefile.xsd''An error occurred while attempting to parse the XML Schema document 'file://${FME_MF_DIR}schemas/app-schema/somename/5.1/somefile.xsd'No idea why System32 is there since my FME_MF_DIR should be c:\projects\myproject 

Dear FME Community,  I have a FME Form and also ArcGIS Pro license. I am new to IFC format and also new to FME Workbench. I want to view and work with the IFC Files in ArcGIS Pro and later publish it as a WebScene in ArcGIS Online.I do not have Data Interoperability Extension License for ArcGIS Pro. To achieve this i need to clarify below questions :  Using FME 2023.2 and ArcGIS Pro 3.4.0How to convert IFC files to ESRI Geodatabase using Workbench ? Should i change the Coordinate system (Gauß-Krüger) of IFC files in order to view and work with the files in ESRI Geodatabase (ETRS89.UTM-32N) ?  Which coordinate system should the output files have in order to work in ArcGIS Pro ?Please find the screenshots for more information.IFC Files with Coord.System Writer Format with Coord.System A detailed solution with working steps would be helpful. Thank you. 

Hi,I created a simple StringSearcher in FME Form and want to use the resulting “All matches” list in consecutive transformers. I can access / log the results properly in FME Form. However, when I publish the workbench to FME Flow, the list isn’t exposed and cannot be accessed. Can You reproduce the behavior?RegardsStefan FME 2024.0.1.0 (20240328 - Build 24202 - win64)FME Flow 2024.0 (Build 24187 - win64) 

Hi! I have been using the HTTPCaller Specify Upload Body to upload files to Saleforce. It has been working smoothly with only one problem, which is the size limit that can be uploaded via this method. Saleforce advises that I need to use Mutipart method instead. If I’m using Python, below is the data that I will be sending with Multipart method (basically I just wanted to upload this file called test.PNG):[('entity_content', b'\n------boundaryString\nContent-Disposition: form-data; name="entity_content";\nContent-Type: application/json\n\n{\n    "ContentDocumentId" : "",\n    "ReasonForChange" : "test upload",\n    "PathOnClient" : "test.PNG"\n}\n\n------boundaryString\nContent-Type: application/octet-stream\nContent-Disposition: form-data; name="VersionData"; filename="test.PNG"\n\n'), ('VersionData', ('test.PNG', <_io.BufferedReader name='<file_path>test.PNG'>, 'application/octet-stream')), ('', b'\n------boundaryString--\n')] However I’m not sure how to populate those da

Using the same polygon the Generalizer (Douglas, tolerance=0) returns different results depending on the orientation of the polygon.Any explanation?

I'm trying to use the WHERE Clause in a FeatureReader. I'm reading in an Oracle SDE featureclass and want to only select those records that match an attribute in a csv file I've loaded. I'm assuming that I have everything setup correctly where the attributes from the csv file are FME Feature Attributes. It seems when I add the @Value(col0) to my WHERE Clause, it breaks. How can I check to make sure it is setup correctly?

Hi, I have downloaded, installed and uninstalled all versions of FME Form from 2024.0 up to latest 2024.2 and still having issues reading and or creating a new reader from Microsoft SQL Server. Every time I create a new and or update reader transformer, the reader disappears. Same when I create a new reader, it never show up. I have another machine that runs (2023.1.1.1 (20231011 - Build 23636 - WIN64) and it runs fine. I want to update my version as this old version is unable to read from Amazon RDS. Has anyone experienced this or experiencing this?Update * after further investigations. I have found the below. There seems to be incompatibility with the versions and I could not find a version that can read both version of MSQL. Microsoft SQL Versions FME Form 2023 (x64) FME Form 2024 (x64) Microsoft SQL Server 2017 - 14.0.3480.1 (x64) TRUE FALSE Microsoft SQL Server 2019 - 15.0.4410.1 (x64) FALSE TRUE

Is it possible to know that the relationship class "C04_EjesVia_LS_Rel" links the feature class "C04_EjesVia_LS" with the annotation class "A04_EjesVia_LS"? Any specific Reader configuration or attribute that I'm missunderstood?I attach FGDB sample. 

It appears the LabelPointReplacer removes the z-value from 3D point features and replaces it with NaN. I’m using FME Form 2024.0.3.0 as our IT-department isn’t fast enough with the updates 😑. Does anyone know if this is fixed in a newer version? Now I 3D-force it with the old z-value.

I tried generating measures on street segments but the measuregenerator is not calculating it right. It starts every segment  from 0 instead of calculating from the end log. Any ideas how to resolve or calculate measures on segments with no measures? Thanks in advance!

I have a Geometry column that includes an easting and northing that is separated by a space in the middle as follows: I want to split this data up so that eastings go into one column and northings go into another. I have tried using an AttributeSplitter with a space as the delimiter and then a ListExploder to view the results but unfortunately this doubles the number of records in my data instead of creating two unique columns. How can I create two separate columns from my data?

The three readers need to match up exactly. I would like to be able to see how many are perfect and how many need to be fixed. I would like the ones that don’t match to be dumped into an Excel spreadsheet that I can look at and make the necessary corrections. This is what I have so far. Top and bottom do match, middle one deliberately does not. What do I need to do and how should I proceed?

Hi, we have a dwg file and we wanna use this file in a gis software. We are aware that the fme cannot do georeferencing.Our approuch ist to use the Offsetter transformer to “move” the data to the correct place!That would be enough for us! So fist we used the AutoCAD DWG/DXW Reader to read the dwg file.Do we now have to set a coordinate system before using the Offsetter?Inside the inspector tha coordinates looks like this: Can anyone help us please?

Hi, i’m working on water treatment facilities. I’ve to categorize them in order to write a excel file which lists the existing and some deliverable.  I’ll try to explain the best i can : basically the data are from a gdb,  i’ve a tester to sort depending on categories. Some cat can have missing/null values, i need to “force” those missing values into the translation in ordrer to write the corresponding categories in the excel files.my situation now is that the missing values given they’re not written shift the writting in my writer and then do not correspond with their according row.i’ve 9 differents categories so 9 row but when i’ve just 5 filled categories, i’ve those 5 written but it change the alphabetical order in the written row so the categories dosent match the row. How can i say to the translator “if i’ve no values write the default value “0” else “no action”” Thanks, hope i’ve been clear enough

I know there seems to be lots of topics around this but just can’t seem to get it to work.I have a configuration file that I read in at the start of a workbench. In that file is a range of attributes that I turn into user parameters.One of these is to define a specific field from a table which I have called _extractSubjectParcelQueryFieldHow do I use the contents of this variable to be the attribute that I want to expose?  In my case the actual value of the user parameter is ‘land_id’ but this can change depending on the data coming in.  

Hi, I am trying to connect to Amazon RDS Microsoft SQL and I couldn’t find any documentation, connection or connector avaiable for FME Form. Is this only available on FME Flow?

Hi All,We are currently working on Maximo connector transformer(s), and have been successful in connecting and querying a Maximo database. However, there is an incredible amount of functionality available through the APIs, and I would like to initially concentrate on what is most useful to our users.So I am requesting your feedback on how you would like to use FME with Maximo. Do you want to add Assets or Work Orders? Do you want link Maximo info to your GIS or BIM data. Do you want to do complex queries? This is a chance for you to shape the design of a new series of transformers.Detailed uses cases would be greatly appreciated.

I am having a simple workspace; just a reader and writer (see screenshot below).The FeatureReader reads from a Microsoft SQL Server Non-Spatial and the FeatureWriter writes to Microsoft SQL Server Non-Spatial. The datamodel in both databases is the same and in the target database the table already exists.When writing it to the database there are warnings about the field type. For example (see also screenshot below)Microsoft SQL Server Non-Spatial Writer: Attribute `.....' of feature type `.....' has specified type `varchar(1)', but existing database table field has type `varchar(2)'. Information may be lost during conversionIt seems to double all the varchars; and also getting messages about bigint vs numeric. The data is correctly written in target but I want to get rid of all the warnings. I have tried various thing with reading the schema from both the source and the target table. Also tried with 'normal' readers and writers. And also tried with JDBC reader and writer.Does anyone ha

Hi all, I am experiencing an issue with writing dynamically to SDE for large datasets (i’m unsure of the exact number, but above ~5000 features seems to cause a fail).  My flow reads in a dataset name from an SQL table, matches it to a dataset that has been downloaded as part of a previous flow, checks if it has been updated and if so drops and recreates the Feature Class using a name given in the SQL tables.When running the flow in batch using a Workspace Runner, ~half of my datasets ran successfully, and ~half failed to be updated in the SDE. I have looked into this is some depth and the only pattern I can see is the datasets that are failing are larger. The error message I am getting is below. I have tried using a sampler on the data just before the FeatureWriter and the flow works correctly, which validates my findings. What could be the potential reasoning behind this behaviour? or has anyone else experienced similar? If there are any other suggestions of settings I could change t

Hi,I need to use Upsert to either Update or Insert features into an Oracle database.If I use Insert to add values it works a treat, so the connection to the Oracle tables is good.As the Oracle tables are large, when adding the writer I use Import from Dataset… This picks up the format of the date fields and all sorts. It works well for initially inserting the data.However, when dealing with deltas, which might be Inserts or Updates I want to use Upsert. I can test it on a filegeodatabase and it works perfectly. Taking that knowledge into the Oracle process like this: I use the NODE_ID as this is the unique identifier.However, this fails.So I have followed the guidance to implement fme_db_operation, I have created a new attribute field of that name, and used a FeatureReader, FeatureMerger, and then AttributeCreator to define whether the feature is classed as INSERT or UPDATE. All works well in the workspace, and a manual / visual comparison between Workbench and the Oracle table conclud