- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27667 Posts

dworkhkParticipant

Seeking Guidance on Iterating CSV Files and Configuring Table View Schema in Feature Reader

I'm currently working on a task where I need to iterate through each CSV file found within specified folders and convert them to SHP files. My approach involves using the path to identify all files under the specified folder and then filtering them by extension using an attribute filter. However, when I use the FeatureReader to read the CSV files, it reads all the CSV files and combines them into one table.I'm looking for guidance on how to set up a loop to iterate through the files one by one, rather than reading them all at once. Additionally, I've noticed that there are no columns shown in the visual preview, and I have to manually check all the columns in the column options to visualize them in the preview.Is there a way to configure the table view/data schema in the FeatureReader to address these issues? Any advice or suggestions would be greatly appreciated. Thank you!

442

7 months ago

ingallaContributor

asked in Authoring

Coordinate Transformation for Geotif

Can I ask a quick imagery / coordinate conversion question?I have lots of historic imagery files, the imagery are all flat tif files, not georeferenced whatsoever. I also have the corresponding .IF files (never heard of IF files) as shown below which contain georeferencing information. If I convert the tifs to geotiffs using the extent information below they all end up in Southern Ireland instead of Nottinghamshire UK. Any ideas what this Cassini projection is, or how to fix this….??I need to get these files into 27700 British National Grid# Extent information...extent minx = 28967.7430000000 miny = 267567.5460000000 maxx = 31381.6970000000 maxy = 269176.9600000000end# Cassini Projection...projection number = 33 zone = 32767 units = 2 ellipsoid = 9 parameter 0 = 6377563.3959999997 parameter 1 = 0.0066705398 parameter 2 = 1.0000000000 parameter 3 = 0.0000000000 parameter 4 = -1.1972600222 parameter 5 = 50.61770629

482

7 months ago

solyContributor

asked in Data

how to remove specific index of coordinates in a line and rebuild the line without this index?

Hello ,i would like to remove specific index of a vertex coordinates from a line .then build the line without this vertex .How could I achieve it ? my second question :How could I find which index vertex coordinates so close to next index coordinates ? then filter it to keep only one of them.thanks in advanceFME 2021

635

7 months ago

georajeshParticipant

asked in Integration

Publishing multiple items inside a file geodatabase to AGOL(Bath Publish)

Hello,I’m working with the ArcGIS Open data portal and I want to publish all my layers within a geodatabase to my AGOL folder as new Feature Services. Since there are multiple items(layers), I’m looking for a batch process. I’ve came across several transformers but none of them seems like working for me. I would appreciate your suggestion on transformer selection for this.Thank you.Rajesh

270

7 months ago

scarterContributor

asked in Authoring

Auto-deleting records based on a datestamp

Hello Forum, We will have a polygon dataset of construction sites. The dataset will be managed within QGIS collaboratively by several planning officers. When the officer adds a new polygon object they will add a end date. This is the end date of the individual construction site project. Once that end date is reached the record needs to be deleted. I could ask them to manually delete it in QGIS when the date is due. However I’d like to take that overhead off them and replace it with an automated way of deleting records. Is it possible to build in a process to consider the end date value and then filter records accordingly? One port would go to all records where the end date has not yet been breached (this will be my published layer). The second port would filter all records where the end date has been reached (this will become a ‘historics’ layer). I’m assuming the end date value would need to be in a particular format (datestamp, perhaps). Thanks,Stuart

805

7 months ago

caroline_pnwContributor

asked in Transformers

Compare and Merge 2 Features onto AGOL - including attachments

Hello, I have a master survey layer on ArcGIS online that will be continuously updated during the summer field season. I also have a master environmental layer that on AGOL that needs to be updated daily from the master survey layer. I know the steps to do this (attribute manager, change detection, etc) but I am running into problems when trying to ensure the attachments from the survey are included when appended to the master layer. The attachments do not transfer and we need those pictures in the master layer. How can I use FME to set this up?Thank you.

360

7 months ago

hawaiialexContributor

asked in Integration

Integration between Feature Class and Asset Management System via API / Change Detector

Hi Everyone,I’m working on an integration workflow between an editable polygon feature class in an enterprise geodatabase and an asset tracking the same asset in an Asset Management System (which will be where the majority of the info is populated). We cannot write directly to the Asset Management System database, and need to write/get to it via API.The GIS feature class has a few attributes that are not in the layer in the Asset Management System and vice versa therefore it is not a straightforward cloning. That being said, I will have the attributes/fields required in the GIS Feature layer already so that new fields/attributes themselves don’t need to be created in the FC. However, we want to set up an integration as the diagram shows above.So the lifecycle of the asset will start in GIS, whereby a user will trace out a polygon in GIS and the fields such as Geometry, Object ID and Asset ID will get autogenerated as a result. The user would then fill out the few GIS only fields in GI

320

7 months ago

schulte.aContributor

asked in Authoring

Is my idea for a self service mapping service a possibility?

Is this possible?I would like to create a self service map generator. There will be basically 2 paths that the user can go, interior or exterior maps, and features (door points, fire alarms, bike racks, etc) can be chosen to be turned on and shown in each map. This data all lives in an ever evolving SDE. And my idea is that all the parameters the user picks will be building an ArcPy script that is manipulating an ArcPro project.I’m laying out the base plan now, and would like to gather some ideas/input before starting off.Here’s an example of what I want this service to do, and my initial thoughts of going about it:Basically the user selections from the parameters will build an ArcPy scriptI will have 2 ArcPro Map projects, one for Interior, one for Exterior The user will select if they’d like to see the interior/exterior. If it’s interior; the interior ArcPro project has a map series created from every floor of every building from the “floor” layer (field called bldgFlr). Therefore w

723

7 months ago

solyContributor

asked in Data

question : the output of changed spike remover t

Hello ,Spike remover : It cleans the lines and removes spikes and fix it but Changed port : the line geometry is changed .( I mean the position of line )i would like to fix the spike but keep the line without changing the position of it .How could I achieve it ?my second question :how to find and define the part of line that has spike ?Spike removed create point I would like to get also the Part of line that spiked . FME 2021 thabks in advance .

771

7 months ago

robertrContributor

asked in Integration

fme.exe is using a file from Python Startup Script - crashes the script

Hello,I have a situation that I cannot seem to understand.It seems that fme.exe is locking/using a file that I try to rename in the Startup Script, although that file is not used at all in the workspace (the processing where the file gets created/saved/renamed is happening in the startup script).The logs don’t mention this file/folder as being used at all.i don’t have the file open in any other app, closed everything else except FME.This is happening on windows. Logs say:2024-05-24 11:32:20| 18.7| 18.5|INFORM|15160 fme.exe is using C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx2024-05-24 11:32:20| 19.1| 0.0|ERROR |Python Exception <PermissionError>: [WinError 32] The process cannot access the file because it is being used by another process: ‘C:\Users\myuser\Documents\DataProject\CAFile\dtCA.xlsx’ The interesting thig is that on another machine with the exact same setup (both for python and fme) it does work without any issues. I checked the debug file for both, the o

481

7 months ago

lambertusEnthusiast

asked in Data

Create equal sized polygons on point locations

Main question: how to create polygons at point locationsWithin FME 2024.0 I created a point dataset of cross sections with 866 points.At each location I want to create a square, which is sized 10 by 10 meters. The current points should be in the centre of the squares.Any suggestions how to achieve this?I tried the Bufferer but did not find the right settings yet to get a nice square at each point location. Output should be like the blue squares in this image:

824

7 months ago

kelin84Contributor

asked in Integration

FeatureWriter 2 AGOL fails on tables 'Must declare the scalar variable "@OBJECTID

Hi, I’m using a change detector to see if any updates has been made from the new data, to the data on ArcGIS Online. Previously I had the error about missing ObjectID on updated records, but I fixed that using a feature joiner from this Guide: How do I write updates to an existing ArcGIS Online feature service? – FME Support Center (safe.com) I got it working on points, lines and polygons, however if I want to update tables, I get the above error. By a search I found that this error has also been found in Survey123: Send Error Code 1000 - Esri CommunityTalking about GlobalID’s, I did try to activate GlobalID’s on my table service, and add that in my feature writer.Anyone who knows how to fix this?Thanks

911

7 months ago

patoche_78

asked in Transformers

Error message : searchEnvelopeNative.fmi could not be opened

Hi folks,I have the following error when I run my Workbench project : 2020-04-17 08:05:41| 785.3| 0.0|ERROR |SpatialRelator_15_Output Feature Recorder -1 2147615062(RecorderFactory): File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR |File C:\\Apps\\fme\\FME18578_32b\\metafile\\searchEnvelopeNative.fmi could not be opened 2020-04-17 08:05:41| 785.3| 0.0|ERROR | I've read some other articles about similar posts here, but I did what was suggested (FME Options > Translation > Log Message Filter and unchecked "log Debug") I'm using an FME Professional Suite (FME 2018.1.1.1, build 18578 - 32 bits). Even in a 64 bits version, the error message is still there. You can see that it begins to write datas, but then stop.The log file is attached and the error messages are line 9611 and after thank you for any help ! Patrick

494

7 months ago

dxirguContributor

asked in Authoring

Sorting levels on DGN Writer

Hi,I have a workspace to translate a Shapefile to DGN. The shp file has a attribute wich I can filter data to output in three different levels. In this levels, two of them, only have contour style, but the other one is full. When I write DGN file, the level with full style is on the top, so the other levels are hidden under this one. I've tried to put the level number in an attribute called idgs_level, but it doesn't work. I've also tried to put the level number in the writer parameteres, but doesn't work. The issue is, how can i control the order of the levels?Thanks

1174

7 months ago

spatialexjamesContributor

posted in Integration

Unable to pass text containing quotes via workspace runner user parameter

I think I may have run into unexpected behaviour. I’m trying to pass some text in a user parameter via a workspace runner but it’s stripping out the quotes within the text when I try to retrieve it.The text I am trying to pass through to a child workspace:"Building_Use" = 'Residential'In the log of the workspace runner it gets passed along in the command line arguments as:--SQL_WHERE_Clause {${="Building_Use" = 'Residential'=}}'and the child workspace receives it correctly when initiating the workbench as:``--SQL_WHERE_Clause' `"Building_Use" = 'Residential''.But when this is retrieved via a parameter fetcher or attribute creator it drops the quotes in the child workspace:Building_Use = 'Residential'However if I run the child workspace on its own (not via the workspace runner) it retrieves the text correctly. I can workaround this by replacing “ with another character before and then replacing it within the child-workspace, but I feel this shouldn’t be necessary. I couldn’t find anyone

363

7 months ago

tkow_trappersParticipant

asked in Transformers

How do I copy AGOL reocrds with file attachments to a separate AGOL feature service?

I am trying to to transfer records with jpg file attachments between two seperate AGOL hosted feature services. The source has also has point geometry which is stripped out prior to passing into the target table. I've been able to create the target table by using the AGOL feature writer, but I'm unable to access the attachments - even though I've exposed the attachment attributes and ticked the "include attachments" parameter in the feature reader.Does anyone have a working example of this transformation?Thanks in advance,Brett

30917

7 months ago

davekazemiContributor

asked in Transformers

Error : unique Attribute Names strings in the translation

Error:I have a workflow using a generic reader and it give me below warning:2022-03-10 22:07:41| 135.3| 0.3|WARN |Detected 2600000 unique Attribute Names strings in the translation. Several unique names may result from operations like list attribute creation or feature type fanout. Reducing the number of unique names may improve translation performance and reduce memory usageany idea what the reason is?

1735

7 months ago

sunsilk11Contributor

asked in Transformers

Process one feature at a time

Hi,I have multiple features, for each I need use an Oracle sequence to get the ID of the feature.Then I need to write the feature to the database. The ID must be unique.I have used a SQLExecutor to obtain the sequence next value. I am struggling when there are multiple features to write. FME is executing the SQLExecutor multiple times before getting single value for the ID. I need to process each feature at a time i.e. run through SQLExecutor, get the feature ID and write feature to database, then proceed to next feature. Any suggestions ?

992

7 months ago

michiedemContributor

asked in General

Counter does not start at chosen value (FME 2020.0.0.1 build 20202

I am having a problem with the counter transformer in multiple workbenches on multiple machines: It ofthen does not start at the set value (ussually 0 or 1). For instance; The counter in the image is set to start at 0. However: When I run the workbench it starts at 577. I have no clue at al why it does that. When I use featurecaching and I run the whole workbench one by one transformer it will start at 0. But ONLY when I manually start every single transformer before the counter. I have this on this machine and another computer in completely different workbenches. I use the counter to merge features. the workbench stops because it can not merge features based on wrong counts.

1066

7 months ago

justynakrajewskContributor

asked in Data

DGN Writer - lines

All two-point lines when exported to DGN, are saved as ‘Linestring’, not ‘Line’.I have a problem with this in the later stages of working in OpenCity Maps. All two-point lines are displayed as ‘Linestring’ and none of the functions work properly for me.In DGN Writer I select : Two point Line output; Type 3 Elements .Please, can anyone tell me how to write these lines as ‘Line’?

461

7 months ago

ajhemelsContributor

asked in Transformers

HTMLReportGenerator creating a table from excel sheet

I want all columns from the excel sheet in the table, not selecting them one by one in the column settings, is that possible?

261

7 months ago

tb09114Supporter

asked in Authoring

Batch processing reads data, but does not create any output

I am trying to run my workspace on the command line, using a command file.fme COMMAND_FILE C:\Projects\330004063_Test\cmd_file.txtIt takes a bit, not as long as I would have expected, considering the test run of the workspace in the workbench, but then I get the following three lines, and everything is over.Reading...Emptying factory pipelineTranslation was SUCCESSFUL with 2 warning(s) (0 feature(s) output)The content of the command file looks like this:C:\Projects\330004063_Test\fme\figuring_things_out.fmw --DestDataset_OGCGEOPACKAGE "C:\Projects\330004063_Test\output\roads_test1.gpkg" --SourceDataset_SHAPEFILE_4 "C:\Projects\330004063_Test\input\KTM_Baseline2019Roads_EW50.shp" When I run the workspace in the workbench it takes 7.5 seconds to run through the data and is producing the expected geopackage, containing 11.433 features.The command line run does not seem to process anything. At least there is no verbose handling of the processing. It also does not produce the expected test1

331

7 months ago

fred.haanContributor

asked in Transformers

Emailer Transformer : Fail with [Errno 11001] getaddrinfo failed

Hello, I use FME Forms 2024 and I have a very basic workbench just to test the emailer transformer and the configuration of our email system.The Emailer is the following version When I run I have this error and it fails: <class 'socket.gaierror'>: [Errno 11001] getaddrinfo failed Any Idea ?Is it a probleme of mail smtp mail server accessibility. What is the configuration to adapt ?RegardsFred

5201

7 months ago

rzickuhrParticipant

asked in Transformers

HTTPCaller Enverus API v3 custom header parameter ignored in Form but works in Postman

Enverus’s Developer API has a custom header option to change the location of next link from the header to the body. When I put X-Omit-Header-Next-Links in the header of Postman I get the expected response: Results from Postmanputting X-Omit-Header-Next-Links in the header of HTTPCaller seems to be ignored as no next link is in the response body and the link remains in the response headers.HTTP Caller with X-Omit-Header-Next-LinksBottom of response body in FormReturned API header attributes in FormAm I doing something wrong or has anyone experienced this behavior?Thanks in advance,Randy

523

7 months ago

gislinchuxianContributor

asked in Integration

WHAT IS FME FORM 2024 NEW LOCALIZED FILE NAME?

I would like to know the name of the localization language file for FME FORM 2024. I know that the localization language file for FME Desktop 2020 is named transformers-localized.* (for example, transformers-localized.zh). I want to know if the new version has changed the name of this file.

942

7 months ago

1
...
49
50
51
52
53
54
55
...
1107

Page 52 / 1107

Badge winners

langdonmshas earned the badge Student (Grey)
langdonmshas earned the badge Teacher (Grey)
langdonmshas earned the badge Welcome Back
sclarke_97has earned the badge Welcome Back
nirmanbhagathas earned the badge FME Form Advanced Training

Show all badges

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