FME Form

The system integrate data from ArcGis API Services(source) to Microsoft SQL Spatial DB(target). When the api side have new row of data, i want to check if the data that is already pulled to DB is already existing using let say object_id field. I cannot use upsert at the writer since the flow is that we do not the want any change of pulled data since it will need to go through manual approval for any data changes. How to insert new row of data only without updating existing data? 

I need to incorporate a custom coordinate system definition into FME Form, but can’t find the right parameters in the online form to fulfil the definition.The following parameters define the map projection, but e.g. ITRF does not exist anywhere in the online tool.projection type: Gauss Kruger (Transverse Mercator)reference ellipsoid. GRS80datum / reference frame. ITRF2005central meridian. 11° 20’scale factor at central meridian. 1.0false northing. 0.0 meterfalse easting. 1000000.0 meter How can I create a proper fme file with these parameters?

Hello,I have a Navisworks 3D file of our facility that needs to be viewed in ArcGIS Pro and published as a 3D Scene. We exported it out to a fbx for City Engine which is then exported to a scene layer package to be viewed in ArcPro and this “works”, but we have a only layer with zero attribution. Is there a way I can either use the original Navisworks file or the fbx to break out the all the features withing the facility and create an output as a multipatch gdb?  sorry for my noobnessthanks in advance.-C

If yes please may i request you to share me demo workbench ?  If NO, is there a workaround to convert Navisworks files to IFC format ?   Any suggestion / idea / workbench is more than highly appreciated forever . I also request FME experts who even have little know-how please requested is your little for any leads . thank you / Br

Hi everyone,Curious if I could pick your brain on the workflow below.I would like to just write the asset_id field values from the GIS feature class into the corresponding assetID field in the API table. I’d want to write the asset_id from the GIS FC to the assetID field in the API table only if the assetID doesn’t exist in the API table. They have different field names.Curious where I would place the HttpCaller transformer with the PUT request in the workspace.The GIS EGDB reader would be at the start of the workspace exposing the relevant fields. Once I rename the asset_id field from the GIS feature class to match that of assetID for the API table, what would I do? Could I hook up the output from an AttributeManager directly to an HTTPCaller without a Creator?  

Path issues while attempting load Python module. FME Pip installed Pypdf. It got installed to: C:\Users\james.hawks\Documents\FME\Plugins\Python\python39\pypdf But workbench cant see that for unknown reasons.  Python Exception <ModuleNotFoundError>: No module named 'PyPDF'

Hi everyone,I need to update the block attributes with the csv data, but I don’t know what I’m doing wrong. Can someone check my script and with this issues? I’ll really appreciate it. 

Hi, I have a JSON that I want to "flatten”, Currently, it has this structure. {"A":{"id":"1","Name":"Aa","IsTrue":"True"},"1stList":[{"Type":"Yes","Number":"100"},{"Type":"No","Number":"100"},{"Type":"Maybe","Number":"1000"},{"Type":"Unknown","Number":"11"},{"Type":"Hh"}],"2ndList":[{"X":"10","Y":"100","Z":"Abc","Q":"Def"}]}{"A":{"id":"2","Name":"Bb","IsTrue":"True"},"2ndList":[{"X":"10","Y":"11","R":"100000","Z":"Efg","Q":"Klmo"}]}{"A":{"id":"3","Name":"Cc","IsTrue":"True"},"2ndList":[{"X":"10","Y":"12","Z":"Lmno","Q":"Stuv"}]}Just reading it with the following parameter settings doesn't work:Flatten Nested JSON Values into Attributes: YES I've tried with 2 listexploders after reading, but that also doesn't give the correct result.I just want the endresult to be a flat table. How can I best achieve this in FME? 

Hi,I have a FME workbench and in the Fanout Expression, i have to manually amend the date (YYYY-MM) in the file name each month from 2024-06 to 2024-07 when running at the start of the month for the previous months data.E.g. the fanout expression will look like this:R@Value(ba_id)-2024-06-filename.xlsx So at the 01st August I would amend the above filename date to 2024-07. Is there a way to automate or code the date so I don’t have to manually change from 2024-06 to 2024-07 etc.

I am having 100 individual text files consist of Point feature..So..........At a time, How could i convert each files into KML files respectively? 

To reproject WGS84 (Lat/Long) to GDA2020 (Easting/Northing) in FME v2024.1, the only option appears to be via GDA94.  This moves the data approx. 1.8m NE as it assumes that WGS84=GDA94 and GDA94+1.8m = GDA2020.While this is usually what people use, there is a need for a second option of WGS84=GDA2020 (ie a Null transformation + Geographic to Grid) as other software packages, such as Conquest have adopted this.  For more information see: https://www.spatial.nsw.gov.au/__data/assets/pdf_file/0008/224396/WGS84_and_Australias_misaligned_web-maps_Information_Sheet.pdf. Is this something that FME will be implementing anytime soon?

Hi FME Enthusiasts,I am trying to run a fmw file by running a batch file. I tried to read smallworld data then convert into some other format. I create a batch file to execute but reader does not read the data. So I passed single record as input and ran the bat file it could able to read and converted into my destination format. but if i passed 100 records it was taking long time and waiting at “Getting feature using command number: (0)” it not moving further. If I manually run the same data with same fme workbench straight , which is working fine without any struggle. if anyone faced this kind of scenario early?.   

We have some text fields that shouldn’t have any UNICODE characters.  Turns out at least one has snuck into the data.  Is there a way to Test to find UNICODE characters and then remove them?FME 2022.2.3

I'm still a newbe to FME considering below.I'm trying to query open data from the Dutch https://public.ep-online.nl/api/v4/Mutatiebestand/DownloadInfo?fileType=csv (API-key required, available from https://epbdwebservices.rvo.nl/) to get the data from a csv-file. HttpCaller works, url obtained with JSONFragmenter (attributes to expose: 'downloadUrl’)+testfilter (to get the actual url). However, I can't seem to use this url in an FeatureReader or further HTTPCaller to actually get the data itself from the csv-file. Copying the url (contains a token valid only one time) does download the file from a browser as a zip-file, but how can this be done in FME?I tried to look at 

I have read through this post to try to get a fix but it doesn’t address the issue i am having.The work flow is…use a Directory and pathname reader to get a list of zip file in a specific folder. sort by path created date sample the first 1 feed the path widows to the reader (esri geodatabase reader or featurereader [preferred]) I am trying to capture the feature datasets within the gdbI have gone to the parameters of the fgdb featurereader and exposed the geodb_feature_dataset format attribute as well as the fme feature type.I have also gone into the generic port and exposed the same. it does not show up as an attr

When exporting to shapefile from GeoServer/WFS one can specify encoding in the request, for my case I specified UTF-8.This shapefile has a cst-file that establishes the encoding (similar to cpg from ArcGIS).When I read this in Workbench/Server 2022.2 the fields have encoding cp-1252 and some garbled characters. If I change the filename to from cst to cpg the attributes come in with the correct encoding.Is this fixed in later versions, or should it be reported as a bug… ?

I have a LOD 0(BUILDING FOOTPRINT) file and a LOD 3 Building 3d model file. Lod 0 is in shapefile format and Lod 3 is in gdb format. The gdb file have no attribute value and lod 0 have. so i want to add its attribute to gdb. How to do it?

So I have a pain in the backside task I'd like to try and cut down to size.Basically we use a piece of software that automatically generates reports and logs for us and they can either be generated individually or as one large PDF. For my current project I need to generate thousands of these reports, which to do individually will be a nightmare, so I want to generate the single large PDF and have FME scan through the PDF and split out the pages. Each report has a location reference number and the sheet number (e.g. 1 of 7) so what I would like to do is have FME scan through the PDF, read the reference and sheet numbers, split out the pages and recombine into the individual location references.

Hi there, Anyone could help? I would like to build a FME workbench to run a multiplication for all the value if they are belongs to the same name. Attached a sample data e.g. I want to get the multiplication for armstrong_2006( 42*10*39*26), then I want the result to be added back in this spreadsheet. thanks. 

I saw that in this idea, writing dynamic autocad blocks was implemented in build 22098. Is there any documentation available for this yet? I understand this is still a beta build so it might not be available. The reason for this is im trying to write out FME aggregates as Autocad blocks with different colours stored as appearances for individual geometries within the aggregate and i cant find a way to preserve these when writing to Autocad.

When i try to “inspect feature caches” or “view sources data” it does not work and i get this error message :  I am not able to use any defaut background map. When I click on “OK” then the software crash.  Any suggestions ? 

Hi all,I would like to run FME Desktop automatically. After seeing some posts, the only method that I have found is using FME Server, however, I have not understood how it exactly works. Could anyone please help? Is there any other way?Many Thanks

Hello everyone, I have a small problem I am just starting on FME so I need your help. I have at my disposal a database in which there are many schemas and many tables inside the schemas. I would like to be able to retrieve a list of each last update date of each table and a list of each first creation date of each table. Here I would like not to do it table by table but all at once! Thank you for your help and excuse me for my approximate English! (For information I am on FME 2021)to be a little clearer I want to create a loop that separates me and sends me the tables one by one to sort the attributes then writes the result in an excel file the problem is not the sorting table by table but the l

Hi, I have a workspace that i want to compare timestamps between two rows in a database based on some matching information.i’m using an sql extractor to pull the pertinent information, which spits out something like this: IMAP TIME                                    SUBJECT                   DATETue Aug 20 02:42:25 EDT 2024    XXXXXXX_#6337.4    8/20/2024Tue Aug 20 02:42:52 EDT 2024    XXXXXXX_#6337.4    8/20/2024Tue Aug 20 04:06:13 EDT 2024    XXXXXXX_#704.0      8/20/2024Tue Aug 20 04:06:41 EDT 2024    XXXXXXX_#704.0      8/20/2024Tue Aug 20 05:33:15 EDT 2024    XXXXXXX_#7274.2    8/20/2024Tue Aug 20 05:33:47 EDT 2024    XXXXXXX_#7274.2    8/20/2024I’m then using a StringSearcher to extract the time with the regex \d+:\d+:\d+ and this gives me the time in essentially a %H:%M:%S format:Extracted   original IMAP (for comparison)02:42:25    Tue Aug 20 02:42:25 EDT 2024

Hello,I was hoping to be able to create an FME workspace to be uploaded to FME server, that would run an SQL script (via SQL Creator) and create a CSV file that would then be uploaded directly to Azure Blob storage.I tried the 'AzureBlobStorageConnector' (using the 'File' upload option), but it appears that the file needs to be stored locally to use this option, which seems to be no good if I want to publish and automate this script via server. I also tried 'FeatureWriter', but couldn't see an option to write to a web service.Any help would be greatly appreciated!ThanksChris