FME Form

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 an

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 o

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 messa

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 se

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

When I am using a regex in a string searcher, the output is as expected. When I am using the same regex as @FindRegularExpression in the Attribute Manager, my script always fails. What do I need to modify in the Attribute Manager regex? Thanks

I have a workbench that goes as follows:Read in attributes from a CSV. The attributes are locations, and Join those records with a buffer and spatial relator to find potential conflicts near the input locationWrite out the records to a PPT fileThe input table would look something like this  Location 1 | Table Text 1 | Table Text 2Location 2 | Table Text 1 | Table Text 2Location 3 | Table Text 1 | Table Text 2 And ideally, the final PPT file would look like this:Title Slide: Location 1Table Slide: Table Text 1Table Slide: Table Text 2Title Slide: Location 2Table Slide: Table Text 1Table Slide: Table Text 2Title Slide: Location 3Table Slide: Table Text 1Table Slide: Table Text 2and so on It's in step 3 that I run into issues. I can't find a way to dynamically filter attributes so that I can write to separate sl

Hi everyone!I'm new to FME and I have a question on how to group entries of a table based on two columns. This is the table:Now I want a new column with the group ID. It should look like this:Explanation:If the fruit is the same, they should belong to the same group --> Apples are in group 1.If the Buyer of group 1 also buys other fruits, then these fruits should also belong to group 1. -->Anna also buys Bananas, therefore Bananas belong to group 1 I tried different transformers, but did not find a solution. Can someone help?

Hello , i have many lines and many points .i have used anchored snapper then topology builder then edge output as in input network for shortest pathfinder and I used every point connector transformer for points to get lines to use it as input for from to shortest path finder . my question : i need to find all routes that possible .shortest path finder has found many paths but there are still too many no paths .How could I find all routes between points ?then extract ids from each route .i hope there is a good idea let me know .i have spent much time but no success .fme 2021