General

I have used FME 2022.2.5 to write datetimes with millisecond accuracy to a Geopackage. But when I try to use the same FME and a FeatureReader to read the datetimes from the Geopackage I get truncated datetimes with second accuracy.  When I use the SQLite format in the FeatureReader when reading the features, the datetimes include millisecond accuracy.  I have inspected the Geopackage using DBeaver and there I can see the datetimes with milliseconds and the type is DATETIME. I would expect FME to be able to read DATETIME's from a Geopackage file with millisecond accuracy, but that might not be the case? Regards, Casper  

So, in the "List" table, I have, as far as I've seen, some duplicate entries. For example, in this image, rows with ID 2404 and 2405 are duplicates of IDs 1 and 2. I believe I have duplicate entries for all lists like that. Could someone help with how to solve this, or rather, how to delete duplicate entries?In the "RecordBoundaries" table, I must not have records with the same ID. I should do the following only for duplicate IDs because they belong to the same document: for example, let ID_Record 357 be one record, and the "creation date" is always an older date (January 1, 1861), while for the "confirmation date," the attribute from the duplicate record should be used (January 1, 1863). So, the process should be done only for duplicate IDs because there must be one record each for themselves.P.S. I have attached both files, "Popis" and "ZapisnikOmedjivanja," so you can immediately try with them and send back the edited f

I am working as a consultant for Consortech Solutions and I have a client who is trying to make his G3 Smallworld connection work in FME using the SBS Plugin for Smallworld. Unfortunately, the reader in FME doesn't work all the time. When it fails to show the table to choose from for reading data using the SBS plugin for Smallworld reader, the error message returned is "Bad or Invalid License for feature: spatialbiz_read [-12]". What's weird is that sometimes he is able to read his data in FME using that same reader but sometimes it fails to read the data.  Is that something people have experienced in the past and if so, is there a way to solve this issue?

I have 200+ shapefiles I would like to read in and merge into a single fgdb feature class. Some of the shapefiles have slightly varying schemas. Is there an efficient way to read them all in at once and validate if the schema is the correct format I would like? Rather than going through them one-by-one?

Hi all,I'm new to AIXM data but I'm facing the challenge of converting GIS data to AIXM 5.1. I am beginning to understand the structure and complexities of the model and I also went through the article and FME template that is online here. I can write out the desired structures but I can't write geometry. It seems it expects an attribute called part{} for the geometry. I have tried different variations of renaming and extracting the geometry.  Edit:Theres's an example of writing to FILEGDB to AIXM and back in this webinar, but the workspace itself isn't available anywhere. https://www.youtube.com/watch?v=3KW0Bj01Wj0&t=960s&ab_channel=FMEChannelWould it be possible to share this AustriaObstacles filegdb to aixm workspace? Any pointers would be greatly appreciated!Thanks!

Hello , How to solve self intersection ( p-case ) ?i would like identify which lines has p-Case and solve this problem ?as example I have a line with specific id starts at point and closed back at the same point .Will be possible to let the line to cross this point and no intersection at start point ,if it is possible .Thanks in advance .FME 2021

Greetings,I used FeatureJoiner to merge a Spatial and non-spatial records using a common value (grid_id).  I use a Tester to select a scenario ie date is 2000, 2030, 2040, etc.I then use a StringConcaternator to add a value to a cell (overwrite cell value), the cell for 2000 will be 0 -5. I also have a Tester for 2030 (2C), 2030 (4C), 2040 (2C), 2040 (4C), etc. The records in the FeatureHolder, should all be written to a single row.Instead I have a row per date/scenario?? For 2000 I have the following data. The output is written over n rows, not a single row?? How do I append records into a single row??Any suggestions are appreciated. ThanksClive

I've built an AutoCAD based automation in FME Form and use blocks with text for some of the output features. The text aligns how it was designed in the block in the FME Form output.   However, when running in FME Flow the text shifts. If I move the block slightly or edit the text in AutoCAD then it snaps back to the correctly designed position.I'm using the same template dwg in FME Form and FME Flow. 

Hello,I have a main table called "Documents". I need to create a table called "List" based on data from the "Documents" table. Within the "Documents" table, I have a column called "ElaborationType," and within it, the number 1 represents the main document. Numbers 6, 14, 33 represent documents related to the main document, i.e., they are lists. My goal is to generate results in the "List" table where the "RecordID" in that row matches the "ElaborationType" equal to 1, but it also repeats or duplicates that number based on the numbers 6, 14, 33.(EXAMPLE: 2302(6), 2304(MAIN DOCUMENT NUMBER 1), 3177(14) belong to the same group because they are in the same cadastral municipality KO_ID).Within the "List" table, I need to have 2304, 2304 because they are lists for the main document 2304, and they must have their corresponding year from the "FromYear" attribute.Is it somehow possible to solve

This is the URL i'm trying to access. https://qpublic.schneidercorp.com/Application.aspx?AppID=1048&PageTypeID=4&KeyValue=450070160000It's a public link. If I try to access it via the HTTPCaller, it throws a 403 error. Why would accessing the link via HTTPCaller throws an error? Thanks

Is it possible to establish a connection to the Government of Canada's open data portal. From there I would like to be able to pull certain layers of interest and then transform them to output products I can share to staff/public.

https://engage.safe.com/support/downloads/fme/2023/win64/fme-form-2023.0.2.1-b23339-win-x64.exe

I ask I have checked subtype/Assetgroup but the data still displays coded values instead of description

Currently I am moving from FME 2018 to FME 2022, but during the FME Desktop Advanced trailhead training it says that some transformers only have cosmetic changes. I want to know what the main, commonly used transformers which I can advise my team to always upgrade in their workbenches. Thank you in advance

We updated our FME server from 2022.0.1 to 2023.0.1, ButWhen I try to convert a FGDB file to another format. I get the error screen as belowWe installed Arcgis pro 2.9.3 already.But it is working fine in FEM server 2022.0.1

When the published workspace is unable to connect to database or ArcGIS services via feature reader, then the translation fails but the FME server job status is success. I would like to know if there is a way that FME server status can be marked as failure when specific condition are not met with in the FME workbench workflow??

Logs: OpenAICompletionsConnector_2 Input Input Collector (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_Input1680804321 Input Splitter (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_ParameterFetcher (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_EmptyNumericValues (TeeFactory): Cloned 3 input feature(s) into 3 output feature(s)OpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: Starting HTTP upload to 'api.openai.com'. Expected transfer size: 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [3]: HTTP Upload: sent 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [1]: Starting HTTP upload to 'api.openai.com'. Expected transfer size: 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [1]: HTTP Upload: sent 411 bytesOpenAICompletionsConnector_2_HTTPCaller (HTTPFactory): [2]: Starting HTTP

HelloAs stated in the title, the left pane takes too much space thus making harder to write / review codes. It basically cannot be resized. Noticed this in FME 2023.0.0.3 and 2023.0.1

here's the curl:curl --request POST \\   --url https://api.assetpanda.com/v3/session/token \\   --header 'accept: application/json' \\   --header 'content-type: application/json' \\   --data '{ "email": "username@company.com", "password": "pASSWORD123"}'

Install: WordToPDFWriter Dependencies1 comtypes python package To install this depenency,  start a command prompt as an administrator and execute the following command:  fme.exe python -m pip install comtypes --target "C:\\Users\\<YOURUSERNAME>\\Documents\\FME\\Plugins\\Python"2 Microsoft Word must me installed on your machine. ========================================================Error running on FME server: 119 2023-2-13 15:08:46 | Python Exception <ValueError>: NULL COM pointer access120 2023-2-13 15:08:46 | Traceback (most recent call last):121 2023-2-13 15:08:46 | File "<string>", line 47, in input122 2023-2-13 15:08:46 | File "C:\\Users\\xxx_fme\\Documents\\FME\\Plugins\\Python\\comtypes\\_meta.py", line 13, in _wrap_coclass123 2023-2-13 15:08:46 | result = punk.QueryInterface(itf)124 2023-2-13 15:08:46 | File "C:\\Users\\xxx_fme\\Documents\\FME\\Plugins\\Python\\comtypes\\__init__.py", line 1197, in QueryInterface125 20

View Data > Exercise: Customize Your Viewhttps://safe.my.trailhead.com/content/safe/modules/view-data/exercise-customize-your-viewUsed the geojson as input instead, worked out fine. 

I am very new to FME and have recently learned the basics of the software. I'm starting to apply some of this knowledge to building workflows and was curious the best way to go about reading in 200+ shapefiles to write to single feature class in a file geodatabase. They all have identical schemas so my thought was to read them in by adding the folder they're stored in, using *.shp as the dataset indicator, and using the Single Merged Feature Type option for the Workflow options. Is this the best way to do this?

Hi everybody, I created a Workspace. This Workspace should be started by an external http-request. If the workspace ended, i wanted to send back a response. I published the Workspace with fmedatastreaming + included the writer to the stream.The response was send as a file. I wanted to send the response as content in response. Any Ideas?   

How do you multiply each row of Attribute A with Attribute of B? Similar to excel operation? I need to convert imperial units to metric.  I can multiply the attribute with a User_Parameter and I can also multiply two attibutes together and I can also use the Expression Evaluator. But, for each operation I get about 200 lines of WARNING. What is going on? What is the correct way to multiply two attributes or an attribute with a user_parameter?

I have files in a folder. I want to select the files with a path_modified_date from the year prior. Example, if the path_modified_date contains "prior year" then zip these files. I know how to do the zip files part.  It is the If the path_modified_date contains "prior year" part that I am having trouble with. The files in question accumulate every year and I would like to set up an automation in FME Flow that runs every March and zips the files from the previous year. I know how to set up an automation. Here is what I have done so far in FME Form. The Tester passed if @Value(path_modified_date) Contains 2022; If I use this workbench as is, every year I want to run the workspace I would need to go in and manually change the Right Value in the Tester to the prior year. I want to know if there is a way where I can automate this portion?I added a Year field to Attribute Manager takes the left 4 digits (the year) from the path_modified_date field. Then I changed the Righ