FME Form

Mongodb supports EPSG 4326 by default you can specify a custom crs : https://www.mongodb.com/docs/manual/reference/operator/query/geometry/ My workflow is simple : geopackage to mongodb.  I tried : Specify source and destination projection : no effect (data are in 4326 in mongo)Extract geometry (projected in 2154) and store in attribute geometry2 but there is no json type (or even geometry type). Extract geometry and write it in a geometry attribute : fme returns an error.  

Starting out with feature reader, and I am definitely missing something. The input dataset has about 1,600 records. Why is the output at 366,458 (and counting) about 10% of the way through? Thank you,

I would like to convert ecw files into other raster formats, and since I do not know what output format other users prefer, I would like to provide a public user parameter with a list of available raster formats in FME, and use the parameter to specify the format used in the FeatureWriter. Looking at the FeatureWriter I cannot see the possibility of dynamic, or even a selection of output formats. It also seems rather cumbersome to get a list of all raster formats FME is able to write. Is there a possibility to tweak the FeatureWriter to take the format from a user parameter list?

Some jobs are queued before it is allocated an engine for processing due to shortage of available engines or based on priority of job queues. I would like to know how many jobs stayed in queue for more than 30 second before it was processed? This will help us to allocated additional engines... Is there a way to do this analytics in FME server? Thanks

Hello ,i would like to connect FME professional with Azure AD to write the output from Fme to azure .i would like to ask , after creating web connection in Fme professional. How could I publish the web connection in FME server ? to read the data from azure ad ,which transformer should I use storage blob connectors or https caller my second question : how let the workspace to write the output directly the file into Azure AD ?could someone explain idea or provide screenshot of workspace ? FME 2021 thanks in advance

I'm using a HTTP caller to download a ZIP file from a API. After that I'm using the ZipExtractor transformer to extract a number of csv files from the ZIP file to a folder and then a FeatureReader reads the files and so on. Only problem I'm having is that the CSV files change from time to time. They all start with the time of the export followed by the filename. So every time that happends I have to go back to the FeatureReader, select the files again and reconnect the files to their appropriatie transformers.  Is there a way to rename the files after the ZipExtractor ? I have found some topics using the Directory and File Pathnames Reader with the File Copy writer but I cannot get that to work. Any help would be greatly appreciated.

What is the best way to write and read to/from sharepoint subfolders without downloading or uploading first the files or folder using Sharepoint online connector?

I'm trying to write texts to Microstation and having trouble getting certain characters across, specifically ü and ç but there may be others. They are present in the source data and inside FME right up to the point where they enter the writer. I'm pretty sure it's an encoding issue, but can't seem to set UTF-8 on the Microstation writer. Any ideas on what I can do to get those characters into DGN?

Hello , How to split the content of one column to two columns ?my output of aggregator looks like string12-string56 at same cell in one column and all rows similar . i would like to have two attributes one called base include string12 and other attribute called next include string56 and implement the method for all rows  Which transformer should i use ?how to use it ?fme 2021 thanks in advance  

Hello ,i have used topology builder Parameter :end node and intersection , tolerance automatic .I need it to to let the lines properly noded .but my problem that it create intersection point for cross lines ,as even „X“ or „T“ .how could I use topology builder end node and intersection and avoid effect on cross lines ?my target : to let the line properly noded then count the no. of overlaps point on line . I have used topology builder end node only ,it does not create intersection point but my network need to clean so I have to clean the data first .what should I do ?FME 2021 thanks in advance .

Hello. I have been tasked with pulling a large amount of XML from BLOB fields in a table to find relationships between the data. The problem I'm having is every approach I've tried has stalled FME Because of the large number of attributes I'm pulling out of the XML after XMLFlattener and AttributeExposer. I have attached one blob field, and each of them are basically the same, just larger or smaller. The results I'm picturing in my head are grouped by the Equipment GUID and Cable GUID. 

Reading/writing files(e.g .xlsx) from /into local drive not working in FME Flow 2023.0 (b23332) but FME Form does read/write the same files from local drive.

I have a point feature class in a geodatabase. It doesn't contain metadata yet. I want to write one for it. I think I need to use XML Templater. But I can't read directly from GDB by adding a Esri GDB reader. what should my source be?  

The files are ziped .shp files broken up by state. I need to merge them into one nation wide dataset and safe to a geodatabase. A general workflow would be very helful. Or a list of Readers, Transformers and Writers and things to pay attention to.

I have an excel file that does not have any merged cells. Any cell that is left blank is supposed to take the value from the previous row. How do you do that in FME without looping through a list? This is what I haveAnd, this is what I want (with grey-color being the items I want to automate with FME): 

I have data going through feature writer that creates my csv, that then is uploaded to azure file storage using its connector in fme, once I successfully upload the csv, I want to delete that file from FME_DATASOURCE where I wrote it in the earlier step. How can I do that ?

I am trying to access each row of the excel data I read with pythoncaller. How can I do that         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        for row in data:            print(row)and how do I read FLOAT values as well? I do not understand what kind of object is returned by feature.getAttribute. If I print coulumnData, it is printed nicely row by row. But, how do I access those row of data? I want to do something like         coulumnData = feature.getAttribute('Column1')        data = str(coulumnData).split()        print(data[10]) 

I'm able to setup and use "OpenAICompletionsConnector" succesfully with text-davinci-003, but since the completions API models will be deprecated at the begging of the year 2024 I wanted to try Chat completions with gpt-3.5-turbo as described here.I understood that is hould use another transformer called "OpenAIChatGPTConnector". I use role "user " and as "content" I use the same prompt as for Completion to resolve not well-structured addresses. With this setup the Connector somehow aggregates all the features from input port and sends them as one prompt with only one result. I would need to resolve each row separately, i.e. send the whole prompt for every feature or if the chat works with history, send just one prompt and the deatils for every row (feature). Important is that I need result for every row (feature).Any ideas for the setup?Thanks  

When I read data from a PostgreSQL/PostGIS database and I inspect the features using the Inspector, all attributes seems to be of data type "string: (UTF-8)" when looking at the "Feature information" panel. But when I look at the "Table view" panel, the id column (defined as serial4 in the database) is formatted as a number (the value is aligned to the right). Boolean values are read as either "t" or "f" (still "string: (UTF-8)") while when reading boolean values from a GeoPackage they appear as "Yes" or "No" (and the data type says boolean). If I look at the debug logging I see that a boolean postgres attribute has an entry like:Attribute(string: UTF-8): `my-field' has value `bool,BTREE' While a GeoPackage attribute has an entry like:Attribute(string: UTF-8): `my-field' has value `boolean' Is this really the expected outcome? I would expect FME to correctly identify the data types and treat

Hi.. I have an FMW workflow that reads a shapefile with H3 polygons. Each polygon has a HEX color attribute (eg #000000). I need to do 2 operations: Style the shapefile filling each polygon with color using the HEX attributeRender and write the layer as a raster image (Geotiff or JPG) Can this be done, and how? Thanks, tC/.

Hi, I would like to use FME in order to retrieve some data by sending HTTP request to a REST API.  A GET request can only retrieve 1000 entries per call and follow the FIFO method (First In, First Out). So I need to GET 1000 entries, process the data and then DELETE 1000 entries and start the cycle again until there is no data left. I setup a loop in FME:I've read on this forum that a blocking transformer can not be used in a loop without beeing exported, so I've exported the custom transformer GET_API that contains (.FMX): So each loop should produce 1000 features.Outside the loop it works well when I only send 1 request. But inside the loop I get this error message: HTTPCaller is blocking and cannot be used in a loop I can not use a CLONER or something like that since I don't know how many cycle is needed. Do you have another solution ? Is that even possible ?  

I am trying to read a GeoTIFF that has LERC compression.I created a workbench in FME 2021 that read and mosaiced some GeoTIFFs with LERC compression and wrote them to GeoTIFFs with LZW compression. I was able to do that successfully.However I'm trying to do the same thing now in FME Workbench 2023.0 with the same files and I'm getting the following errors: 2023-08-15 13:18:41|   0.1|  0.0|INFORM|GEOTIFF reader: Opening file 'C:\Temp\DEMs\CB11_10000_0502.tiff'2023-08-15 13:18:41|   0.1|  0.0|WARN  |GEOTIFF reader: C:\Temp\DEMs\CB11_10000_0502.tiff: C:\Temp\DEMs\CB11_10000_0502.tiff:LERC compression support is not configured2023-08-15 13:18:41|   0.1|  0.0|ERROR |GEOTIFF reader: C:\Temp\DEMs\CB11_10000_0502.tiff: Cannot open TIFF file due to missing codec.2023-08-15 13:18:41|   0.1|  0.0|ERROR |GEOTIFF reader: Failed to open the dataset 'C:\Temp\DEMs\CB11_10000_0502.tiff'. Please ensure source data is valid and correct reader is selected2023-08-15 13:18:41|   0.1|  0.0|WARN  |GEOTIFF rea

Hi can yu hep me to understand where I can find the result of this website ? I supose I have to search for a json  https://egovjesolo.jentecloud.net/jalbopretorio/AlboPretorio https://www.comune.roma.it/gedalbonet/albo/listaatti thxFrancesco

I have a flow that pulls from an excel doc to an oracle database table. I have created LOVs based on some of the fields. Game plan is to create drop down list in my application.Question: How can I, within the flow, compare and replace the excel fields Descriptions with the LOV table ID value?Thanks