- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,032 Posts
13,814 Replies

When you subscribe we will email you when there is a new topic in this category

4032 Posts

mapixseContributor

Exercise in training module refers to MapInfo file which isn't included

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.

1 year ago

creinierContributor

asked in General

Reading in hundreds of files.

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?

start workspace by http-Request -> Send response

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?

Multiplication of two attributes

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?

490

1 year ago

vxn43Supporter

asked in General

Select Files with path_modified_date last year

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

AutoDesk dwg schema reading performance.

The FeatureReader has the option to read "Schema and Data Features", "Data Featues" and "Schema Features". In an attempt to optimize a process which converts a bunch of AutoDesk dwg's I tried to first read only the schema (the layers), determine which of the layers need to be read and feed that list in a second FeatureReader as Feature Types to Read. I found out I was getting slower performance, due to the FeatureReader being really slow to read the Schema Features.Reading SchemaFeatures from the dwg took 120 seconds.Reading Data Features from the dwg took 2 seconds.Reading from an empty file did not result in a different performance. Why is this so slow? Does it have anything to do with the parameters?I think the FeatureReaders FME Defaults should be "Data Features" as a lot of users would benefit from the increased performance.

230

1 year ago

izabretonContributor

asked in General

Generate attributes per feature type table dynamically

Hi, I would like to create a table showing all the attributes available per feature type and the count for each one. For example, I have these datasets: Trails, Activities, Landscape which contain similar attributes, but also different attributes. (similar = objectid, name...) (different= trail size, type activity). I want to generate an overview with all the attributes and to which feature type they belong to. Any idea how I can do that without using too many transformers? I have already tried many options:1) attribute exploder, unique values (but then I can trace back to whcih feature type it belongs to)2) attribute manager, change values to feature type, then statistic calculator (but then I have to use one attribute mananger per feature type which is redundent). Any ideas how I can make this script dynamic? Thanks

Why is featurereader reading way more records than are in the input?

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,

330

1 year ago

naveenContributor

asked in General

FME Server 2021 - How to know the job queue time (i.e. waiting for engines

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

180

1 year ago

spidermanContributor

asked in General

How could I create connection between FME and Azure AD?

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

1 year ago

spidermanContributor

asked in General

How to split one column to two columns ?

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

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!

7020

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.

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.

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

440

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

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 ?

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?

270

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

740

1 year ago

spidermanContributor

asked in General

Error :Invalid line geometry after using network topology calculator

Hello , i got 6 lines at rejected port from network topology calculator transformer .the reason is invalid line geometry .How could I fix it ? What does the reason and what should I check ?FME 2021 thanks in advance .

n.dContributor

Hello.I have some data like this:123 m32 m56 m...and I want to keep the numeric part and ommit the unit (m). Which way is the best?

110

1 year ago

gogopotter90Contributor

asked in General

How to remove insterction point in line

I have self interaction in line .line has id but it make circle and intersect itself .how could I remove the intersection point at same line ? my problem : after using intersection lines ,I found this line divide to 3 lines ,because it intersect itself in point .will be possible to let intersector Transformator to create find intersection lines but between different id and ignore the intersection lines for line that has specific id .Could I specific it in parameter ,to find intersection lines only for different id ?

110

1 year ago

checcosisaniContributor

asked in General

CSS Selector

Hiwhich is the correct css to extratc only the first div this not work #tabella > tbody > tr:nth-child(-n+30) > td.text-left > div:first-child thxFrancesco

1 year ago

garbadekContributor

asked in General

Dynamically set "Attributes to Expose" in Feature Reader Parameters

Is there a way to dynamically set the "Attributes to Expose" option in the Feature Reader Parameters dialog box. I've set a variable equal to the attributes I want, and I've created a user parameter pointing to a .csv file containing the attributes (one on each line), figuring I could update the .csv each time through a loop with the attributes I want from the next file.... but neither of these worked (at least in the form I tried them): I apologize for asking so many questions. I promise to answer some when I get better at this.

380

1 year ago

Page 20 / 162

Badge winners

ryanwillshearhas earned the badge FME Form Basic Training
barkushas earned the badge Welcome Back
anteboy65has earned the badge Welcome Back
tamadurhas earned the badge Welcome Back
buraskyhas earned the badge Integrate Spatial Data

Show all badges

30,366: 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.