- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27536 Posts

Recently active

Most replies Most views Newest first

spidermanContributor

asked in Transformers

How to exclude creating intersection point of cross lines ?

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 .

How to use SharePoint Online Connector to download files on SharePoint to a local drive?

As the question title states, I would like to use the SharePoint Online Connector to download files from SharePoint to my local computer's drive. I was able to set up the connector using a web service and it says "translation successful" when I run the SharePoint Online Connector on it's own but I'm not sure what readers and/or writers to add, or is there something wrong in the parameters? The files on SharePoint vary from .docx, .xlsx, and .pdf formats If someone has a basic template to show that would be great. Thanks!

5663

1 year ago

morijlumos

asked in Transformers

What would be the best approach to pulling attributes from very large xml BLOBs from a SQL Table into able attributes and values.

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.

1 year ago

angwanContributor

asked in General

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.

114

1 year ago

sanashaikh

asked in Transformers

Python Exception <AttributeError>: 'NoneType' object has no attribute 'name' I am facing this error, while reading the feature from dataset. This is coming in Feature Reader. Using latest FME version 2023.0.

2435

1 year ago

marrysharif

asked in Transformers

How to write metadata for a point feature class stored in an Esri GDB from scratch?

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?

How do I read all files from an FTP site, merge them into one dataset and write to a database.

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.

121

1 year ago

moostang88

asked in Transformers

How to fill unmerged cells with values from previous rows?

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):

182

1 year ago

taransingh2812Contributor

asked in Integration

How can I delete a respective csv file after uploading that created csv to azure file storage?

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 ?

How to read each row of a column with pythonCaller?

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])

How to setup OpenAI completion to use with gpt-3.5-turbo?

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

420

1 year ago

chauContributor

asked in General

Are all attributes from PostgreSQL read using the FeatureReader of type "string: (UTF-8)"?

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

204

1 year ago

tigercole

asked in Transformers

Color feature with HEX value in a column

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/.

How to send an unknow number of REST API request with HTTP Caller in a Loop.

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 ?

1583

1 year ago

rclarkenzContributor

asked in Transformers

How do I configure compression support for TIFF format?

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

1441

1 year ago

checcosisaniContributor

asked in Authoring

HTTP caller no result

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

1 year ago

wizkil

asked in Transformers

Using List of Values (LOV) database table with Excel Flat File

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

461

1 year ago

kattContributor

asked in Transformers

Regex to extract string

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

2823

1 year ago

daniel.m.getzContributor

asked in Transformers

Is it possible to make the attribute filter dynamic based on the attributes from the input reader?

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 slides like I see in the tutorial. The attribute names aren't fixed, so the Attribute Filter doesn't work, at least not that I can see so far. https://community.safe.

1495

1 year ago

hola1115Contributor

asked in Transformers

Hello im using fme json fragmenter to get the coordinate X and Y from the attribute response body, im getting the coordinate in the field _result but in to line with the json index 0 and 1, do you know how i can get the coordinate for each feature?

How to group accross multiple column entries?

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?

238

1 year ago

spidermanContributor

asked in Transformers

How to find all routes ?

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

412

1 year ago

vxn43Supporter

asked in General

Zip and delete files based on Date Modified?

In Portal for ArcGIS 10.6.1 in the backups folder there is a walarchive folder. The files in this folder accumulate daily. Annually 14,000 files are created. Each year these 14,000 files together equal approximately 143GB. There is no setting to change this in 10.6.1. Every January, for example, in order maintain a reasonable amount of disk space, I manually delete the 14,000 files from the prior year. It is a fairly straightforward task to delete these files, but I am starting to wonder if I could create a workbench and let FME do this. The file names are random digits and sometimes a letter is included in the name. There does not seem to be a pattern to the file names. I cannot reference the file names in a workbench because of this. The only way to identify which files to delete is by the Data Modified column in Windows File Explorer, example, delete all files between 1/1/2022 and 12/31/2022 would be a single year. Here is what I would like to do in FME: 1) Select all files

711

1 year ago

paetzold_sContributor

asked in Transformers

FeatureReader schema update, dynamically, automatically, csv columns

I have the following problem: I have multiple csv files with multiple columns. I want to dynamically change which columns to read.I have a user parameter to define which columns to read. Even though the " Attributes to Expose" Parameter of my FeatureReader gets updated correctly the Reader dosn't read the correct columns.Only after opening the properties of the Reader and closing it again by clicking "Ok" the Read reads the correct columns. I'm using FME Desktop 2020.2.3.0 on Windows 10 Maybe someone can tell me if this is a bug or if I'm just overlooking something. Many thanks in advance !

988

1 year ago

lija

asked in Transformers

How can I optimize the performance of my FME workflows when dealing with large datasets? Any best practices or recommended settings to consider?

Hii all,How can I optimize the performance of my FME workflows when dealing with large datasets? Any best practices or recommended settings to consider?Thanks in adavnce.

1517

1 year ago

1
...
117
118
119
120
121
122
123
...
1102

Page 120 / 1102

Badge winners

steveoladayiyehas earned the badge Integrate Spatial Data
vertiroyhas earned the badge Integrate Spatial Data
digit42has earned the badge Student (Grey)
digit42has earned the badge Teacher (Grey)
digit42has earned the badge Welcome Back

Show all badges

30,110: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.