- - 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,033 Posts
13,790 Replies

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

4033 Posts

Recently active

Most replies Most views Newest first

plynnParticipant

asked in General

I have an excel file with many sheets. I need to process each sheet separately. How would I go about doing this?

3 years ago

zacharylee1204

asked in General

Finding missing value from a range of dataset

So I got a dataset, floorID and Unit Number. Here is what I want to do. For each of the floorID (meaning each floor), the unit number should start from 0001 to the max number in sequence. For instance, in my example, there are 4 floor ID "level1", the unit should be 0001-0004. In contrast, there are 3 floor ID "level2", so the unit should be 0001-0003. In my case, the input of floorID and unit number is unknown. But I want to find out the missing unit numbers or wrong input unit numbers. Could someone guide me how to work in this case? I have attached the correct and wrong output in here. Oh, also, I have another question. This is the sample of the data1-1, 1-2, 1-32-1, 2-2If I want to see if the incoming input is within this value, might I ask what kind of transformer should I use? Do I need to input these values manually? Thank you very much and sorry for all the questions. Zach

Hello, i'm trying to read a geopackage via the featurereader and performing a where clause to read only the necessary data - it's not working! is there a known problem with fme 2020 and the featurereader with geopackage?

Access ArcGIS Server Feature Service Query REST API and write out json as output

Hello, New to using web services here. I am trying to use oauth2 login to Portal ArcGIS Server feature service on a specific layer index and use the REST Query function to pass in a couple of parameters and then have the output to json format. For instance this is the ArcGIS Server Feature Service on a particular feature layer (e.g. index 3) https://ppp-snoopy.com/un/rest/services/SnoopyUN_Network/FeatureServer/3 Then pass in the string query parameters according to this reference page Query (Feature Service)—ArcGIS REST APIs | ArcGIS Developers where: GUID = 'abc1234xyz'gdbVersion : Snoopy.Surveyoutfields : objectid, GUIDf: json I am trying use HTTP Caller to access the ArcGIS Server feature service using NTLM authentication and got this error :{"error":{"code":499,"message":"Token Required","details":[]}} I also tried to use direct URL to the ArcGIS Server Feature Service (without Portal) and no luck. Any help wo

I want to know if there's a way to Generalize (in 3D) a 3D line. Common Generalizer tools are for 2D lines. But is a 3D Genralizer tool exist? I mean if I want to generalize a 3D line from a Z tolerance. Imagine a 3D polyline with ups and downs and I want to smooth or generalize the line. And the resulting line is within 20cm (in 3D) from the original 3D line. Thanks, Frank

586

3 years ago

f.kemminjeContributor

asked in General

Can I take features written count from Logfile using regular expression search?

Sorry Team, This is not one question. I have one fme file, which writes (conventional writers)to 50 PostGIS tables. I need table names and total features written counts from fme.Since I am writing to a staging database, I need to do validation of counts, before making / swapping these tables as the main tables for the application. once I am okay with the previous counts(count from the previous run) and current counts(comparing prev run with the current fme run), we are copying the tables to the main DB. table1 100000table2 50table3 6895698....like this to write these info (table_name , total_count)to one more postgres table ie fme_written_status table. I know our feature writer does this job, but I need to replace all the writers. summary port gives this output with total_features_written.But not one feature writer, I need 50 separate feature writers. because summary port gives total, not table-wise. can I replace all normal writers to feature writer transformers in one go? can I ac

3 years ago

arnold_bijlsmaEnthusiast

asked in General

Don't read geometry, only attributes

Is it possible to only read the (selected) attributes, and not the geometry?Quite often, I need to join the attributes from two spatial datasets, but only need the geometry from one. And I am assuming that reading in only the selected attributes without geometry is noticeably faster than reading the attributes with geometry.Is it possible to read any dataset without geometry (other than reading it with and then doing a GeometryRemover)? And does this apply to all formats?

3 years ago

rob_nason

asked in General

Results from FeatureJoiner changing number format

I have selected ~50 records from a shapefile of ~5.5 million records using a column of unique reference numbers. The unique reference numbers are stored in a CSV. I have used FeatureJoiner to join the CSV and shapefile. The resulting joined records have been correctly selected but the values in final two columns containing the X and Y coordinates have been altered when viewed in the visual preview. Where in the workspace has the change taken place?

3 years ago

hermannContributor

asked in General

xport/import database connections in FME server

You can export/import database connections in FMEworkbench (as xml or enc-file), wouldn*t it be nice to have the same function in FME server? Will we see it soon?

1643

3 years ago

zzupljaninContributor

asked in General

JSONFragmenter returns json_type = object instead of json_polygon

Hello, Can someone explain to me why is JSONFragmenter returning json_type = object instead of json_polygon? And how to adjust anything to get valid json_polygon? Parameters of JSONFragmenter: JSONFragmenter returns: Usually for this kind of JSON data I get (with correct geometry): JSON data for correct return is given as attachment, as well as the incorect one.

162

3 years ago

f.kemminjeContributor

asked in General

How to return value from Postgres procedure or function to SQL executor's Result port?

I am renaming the Postgres tables inside the SQL executor(Postgres).If the task is successful, I need a success mark or flag from the SQL executor(stored proc).here there are two flags variables in my code ie "done2" and "i"But the initiator only comes out, nothing comes from the output port. I need one feature from Result port 1 for success or 0 for failure.Can Anyone help me?CREATE OR REPLACE FUNCTION func1() RETURNS integer AS$BODY$DECLARE cntold INTEGER := 0 ; cntcur INTEGER := 0; i INTEGER := 0; BEGIN SELECT INTO cntold count(*) FROM @Value(table_name_old) limit 10; SELECT INTO cntcur count(*) FROM @Value(table_name) limit 10; --SELECT INTO cntnew count(*) FROM @Value(table_name_new) limit 10; IF cntold > 0 and cntcur > 0 THEN EXECUTE 'DROP TABLE @Value(table_name_old)'; EXECUTE 'ALTER TABLE @Value(table_name) RENAME TO @Value(table_name_old)'; EXECUTE 'ALTER TABLE @Value(table_name_new) RENAME TO @Value(

How to find points and lines that cannot fulfill certain criteria

Hello there, So I have bunch of points and lines in my database. For the final output, I would like to extract the points/line (possibly the name) that cannot fullfill the following criteria. 1) The points MUST touch the lines, but it can have a tolerance of 1m to the closest lines.2) The starting and ending of the lines MUST have points. So the sample shows that points 1-6 are correct, while the points 7-9 and the line below (C) are not correct. It is because the line C does not have the starting and ending points. Also, the points 7-9 do not contain lines within 1m buffer.Might I ask what kind of transformers I can use? I am not very good at FME and hopefully someone can give me a hand.Thank you very much. Zach

3 years ago

mark2atsafeSafer

asked in General

What's Up Wednesday: FME News for the Week Ending 22-October-2021

Hello #FMECommunity!Here is the news about FME for the week ending 22nd October. Community Activities: Random Acts of TransformationSo during our Community Webinar yesterday (depending on where you are and what your 'yesterday' is) Dale and I tried our hand at Random Acts of Transformation (RAOT) which is where we pick a transformer at random and try to explain it in as much detail as we can, with some lesser-known tips and tricks. Fate dealt us an XML-based transformer as our first go, which was a bit rocky, but then we gave a good description of the FeatureMerger transformer and that was a lot better. You can find just that section of the webinar on YouTube, where I hope to post more of these in the future. Community Activities: GeoguessrWe're nearing the end of the Geoguessr subscription (about 7-10 days remaining) and many users are having fun with this: We still have a few open spots if you want to play, so let me know. Community Activities: Postcard ExchangeSo while

3 years ago

krienContributor

asked in General

Hi all, Can someone tell me what the fme.uuid file is for when activating a Floating License and what the content means? Kind Regards, Krien Guijt

Add space and letter to text in string

Hi again, I would like to change my string containing "100000,00" to "100 000,00E". In other words, adding a space and an E in the string. I can not seem to find an easy solution for this. Thanks in advance!

Sum of inverse distance to points of interest

HI. I have one point layer that contains residential locations. The second layer contains the location of fast food outlets. I want to create a distance weighted count of nearby fast food outlets such that:outlets nearer than 500 metres away get a weight of 1 outlets more than 2000 metres away get a weight of 0those between 500 and 200 metres get a weight of 500/distance Could anyone tell me if this is this possible in FME please?

295

3 years ago

mr_fmeEnthusiast

asked in General

Problems with attribute name from EXCEL

I have an excel spreadsheet where the attribute name changes based on a formula, every time we fill in an X in line 2 the attribute has the same name, but the number can change to 1,2,3 and 4. I created a reading dynamic, but when for example the COD_STREET = 0 in the dynamic FME reader keeps showing COD_GATE = 4 in one of the attributes, what am I doing wrong? attachment follows the spreadsheet

837

3 years ago

user01Contributor

asked in General

Bad column type in postgreSQL : how to not skip features ?

Hello, I want to write features in postgreSQL. Because of a bad type of a table column some features are not written. Alert message for one of them :210 Value of attribute 'idrlt' could not be converted to type 'int4'. Feature will be logged and skippedI want them to be logged BUT written too (not skipped). Is it possible ? Thank you

3 years ago

filipfaust

asked in General

NeighborFinder: several matches for one street

Hi, Is it possible to connect a coordinate with a street using for example NeighborFinder and generate several hits for one street if there are several coordinates close to the street? For example, if there are 5 coffee shops close to Arbitrarystreet, I want it to say that there are 5 coffee shops nearby and not just that there is a coffee shop nearby. Thanks!

3 years ago

mark2atsafeSafer

asked in General

What's Up Wednesday: FME News for the Week Ending 15-October-2021

Hi FME'ers,Apologies for the lack of What's Up Wednesday last week. Both Liz and I were out of the office. Anyway, let's dive into FME news for this week. Upcoming WebinarsIt's been a while since I listed upcoming webinars, so here are a few. The most important to me is Build Your FME Community Network, where on October 19th Dale and I will cover some of the changes we're making to this community, and have a go at a couple of community activities. So make sure to join us because it should be both educational and entertaining. Also upcoming is the Masked Revit User on October 27th. This is where a special guest Revit user will demonstrate real-world examples of what others have made possible by using FME to automate preparing and extracting from Revit. The other webinar I wanted to highlight takes place on 20th October and is about Automation Keys in FME Server. Automations are really powerful items and one of the reasons is the ability to pass information from on

3 years ago

zzordo

asked in General

How Do I Set the Order of Operations?

I need the operations to work in the following order:TerminatorDatabaseDeleterData Load (rest of workspace) I tried using a WorkspaceRunner transformer, having split out the three functions. It works fine if I'm in FME, but if I try to run it using a batch file, it errors out. Ultimately, I want to be able to schedule this through Windows Task Scheduler to run nightly. It will compare the last updated date between two datasets, and terminate if the destination dataset is already up-to-date. Otherwise, it will proceed to delete a subset of the destination dataset (a "partial truncate" for lack of a better term), and then re-load the new data.

1933

3 years ago

lanceContributor

asked in General

How to specify the "return_true_curves" parameter when working with an ESRI Map Service feature?

I am new to FME Desktop and experimenting with downloading a feature from a Map Service hosted on an ESRI ArcGIS server. Is there a way to enable the "return_true_curves=True" when downloading the feature to a local FGDB. I have everything working using a Reader pointed to the map service; however, FME is converting the true curves to simple curves when reading or writing the data. I am able to download the feature using a query and the ArcGIS REST API in python to get a feature with two point curves to a FGDB. Would like to do this directly in FME.

Hi how to avoid to repeat 3 days of data read after a translation failed? Seems the temporary folder run out of space. Can I swap the temporary location and restart the process from certain point instead of starting again from the begin? Alex

3 years ago

kpyke5Contributor

asked in General

FME failing to open with an exception breakpoint

This morning all of my FME workbenches failed to open and I get an exception breakpoint application error. It says (0x8000000003) occurred in the application at location 0x00007FFAB8D6293. The only option is to terminate the program. Any help would be appreciated. Thank You.

151

3 years ago

goatboybozContributor

asked in General

Parse XML response (Tuple??)

Hi All, i have been banging my head against this for a while. Im trying to parse an api call response I get ( XML returned) . I have tried Flattening it. I have tried Fragmenting it, I have tried swearing at it. None of the things I have tried have worked. I don't really understand how this data is structured. Its nested I think, with something like tuples??? there is a Name, Number and Text for each attribute?? Any help or direction appreciated. Happy to learn. I'm trying to return the "number" value of NZTM 2000 Northing and NZTM 2000 Easting as attributes... Many Thanks for your suggestions.

163

3 years ago

Page 95 / 162

Badge winners

poonam21has earned the badge Integrate Data with the FME Platform Training
User15941217152509577149has earned the badge Welcome Back
gowthamvinohas earned the badge Teacher (Grey)
michaelhas earned the badge Welcome Back
gavhas earned the badge FME Certified Trainer

Show all badges

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