- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27526 Posts

Recently active

Most replies Most views Newest first

doug_herrickContributor

asked in Transformers

WGS84 to GDA2020 reprojection via GDA94 issue

To reproject WGS84 (Lat/Long) to GDA2020 (Easting/Northing) in FME v2024.1, the only option appears to be via GDA94. This moves the data approx. 1.8m NE as it assumes that WGS84=GDA94 and GDA94+1.8m = GDA2020.While this is usually what people use, there is a need for a second option of WGS84=GDA2020 (ie a Null transformation + Geographic to Grid) as other software packages, such as Conquest have adopted this. For more information see: https://www.spatial.nsw.gov.au/__data/assets/pdf_file/0008/224396/WGS84_and_Australias_misaligned_web-maps_Information_Sheet.pdf. Is this something that FME will be implementing anytime soon?

491

2 months ago

saravanakumarSupporter

asked in Integration

Feature reader not reading data when run from bat file ?

Hi FME Enthusiasts,I am trying to run a fmw file by running a batch file. I tried to read smallworld data then convert into some other format. I create a batch file to execute but reader does not read the data. So I passed single record as input and ran the bat file it could able to read and converted into my destination format. but if i passed 100 records it was taking long time and waiting at “Getting feature using command number: (0)” it not moving further. If I manually run the same data with same fme workbench straight , which is working fine without any struggle. if anyone faced this kind of scenario early?.

473

2 months ago

juliarozemaContributor

asked in Data

How to Find Unicode Characters in Text String

We have some text fields that shouldn’t have any UNICODE characters. Turns out at least one has snuck into the data. Is there a way to Test to find UNICODE characters and then remove them?FME 2022.2.3

823

2 months ago

aresContributor

asked in Transformers

HttpCaller download csv from response_body url

I'm still a newbe to FME considering below.I'm trying to query open data from the Dutch https://public.ep-online.nl/api/v4/Mutatiebestand/DownloadInfo?fileType=csv (API-key required, available from https://epbdwebservices.rvo.nl/) to get the data from a csv-file. HttpCaller works, url obtained with JSONFragmenter (attributes to expose: 'downloadUrl’)+testfilter (to get the actual url). However, I can't seem to use this url in an FeatureReader or further HTTPCaller to actually get the data itself from the csv-file. Copying the url (contains a token valid only one time) does download the file from a browser as a zip-file, but how can this be done in FME?I tried to look at https://public.ep-online.nl/swagger/index.html but couldn't make anything out of it due to lack of technical knowhow. Any ideas? Setup as of now: FeatureReader tried below (the response_body solely contains the url):Also tried '@Value(_response_body)[*.csv]’ for parameter dataset, but also to no avail. Another try with

1008

2 months ago

gisbradoklaEnthusiast

asked in Transformers

zip file not reading correctly form 2023.1

I have read through this post to try to get a fix but it doesn’t address the issue i am having.The work flow is…use a Directory and pathname reader to get a list of zip file in a specific folder. sort by path created date sample the first 1 feed the path widows to the reader (esri geodatabase reader or featurereader [preferred]) I am trying to capture the feature datasets within the gdbI have gone to the parameters of the fgdb featurereader and exposed the geodb_feature_dataset format attribute as well as the fme feature type.I have also gone into the generic port and exposed the same. it does not show up as an attribute. i also have used an attributeexposer after and it is not possible to expose it because it is not there.If i change the reader to read *.gd this featuredataset still is not exposed in the featurereader.The only method i have had success with is to set the Output Port to One per Feature Type. This is not optimal as any transformer i want to use will have to be done on e

531

2 months ago

nordpilContributor

asked in Data

Shapefile with cst encoding spec (from GeoServer)

When exporting to shapefile from GeoServer/WFS one can specify encoding in the request, for my case I specified UTF-8.This shapefile has a cst-file that establishes the encoding (similar to cpg from ArcGIS).When I read this in Workbench/Server 2022.2 the fields have encoding cp-1252 and some garbled characters. If I change the filename to from cst to cpg the attributes come in with the correct encoding.Is this fixed in later versions, or should it be reported as a bug… ?

270

2 months ago

abinashroutvParticipant

asked in Authoring

How to add attribute of one shape file which is a building footprint to multipatch gdb file LOD3 Building model.

I have a LOD 0(BUILDING FOOTPRINT) file and a LOD 3 Building 3d model file. Lod 0 is in shapefile format and Lod 3 is in gdb format. The gdb file have no attribute value and lod 0 have. so i want to add its attribute to gdb. How to do it?

How to split a PDF based on text on pages

So I have a pain in the backside task I'd like to try and cut down to size.Basically we use a piece of software that automatically generates reports and logs for us and they can either be generated individually or as one large PDF. For my current project I need to generate thousands of these reports, which to do individually will be a nightmare, so I want to generate the single large PDF and have FME scan through the PDF and split out the pages. Each report has a location reference number and the sheet number (e.g. 1 of 7) so what I would like to do is have FME scan through the PDF, read the reference and sheet numbers, split out the pages and recombine into the individual location references.

4577

2 months ago

chaoluoContributor

asked in Transformers

multiplication for all the value if with the same name

Hi there, Anyone could help? I would like to build a FME workbench to run a multiplication for all the value if they are belongs to the same name. Attached a sample data e.g. I want to get the multiplication for armstrong_2006( 42*10*39*26), then I want the result to be added back in this spreadsheet. thanks.

Writing Autocad Dynamic Blocks

I saw that in this idea, writing dynamic autocad blocks was implemented in build 22098. Is there any documentation available for this yet? I understand this is still a beta build so it might not be available. The reason for this is im trying to write out FME aggregates as Autocad blocks with different colours stored as appearances for individual geometries within the aggregate and i cant find a way to preserve these when writing to Autocad.

663

2 months ago

bpoffetContributor

asked in Integration

Default background Map Authentication - Connection failed

When i try to “inspect feature caches” or “view sources data” it does not work and i get this error message : I am not able to use any defaut background map. When I click on “OK” then the software crash. Any suggestions ?

714

2 months ago

claraosuna

asked in Transformers

Run FME desktop automatically (scheduled)

Hi all,I would like to run FME Desktop automatically. After seeing some posts, the only method that I have found is using FME Server, however, I have not understood how it exactly works. Could anyone please help? Is there any other way?Many Thanks

83017

2 months ago

roshContributor

asked in Data

retrieving data list from many data tables

Hello everyone, I have a small problem I am just starting on FME so I need your help. I have at my disposal a database in which there are many schemas and many tables inside the schemas. I would like to be able to retrieve a list of each last update date of each table and a list of each first creation date of each table. Here I would like not to do it table by table but all at once! Thank you for your help and excuse me for my approximate English! (For information I am on FME 2021)to be a little clearer I want to create a loop that separates me and sends me the tables one by one to sort the attributes then writes the result in an excel file the problem is not the sorting table by table but the loop and how to automate the sending of a table by a table, Thank you!

392

2 months ago

parke372Contributor

asked in Transformers

DateTimeConverter in workspace - not recognizing format?

Hi, I have a workspace that i want to compare timestamps between two rows in a database based on some matching information.i’m using an sql extractor to pull the pertinent information, which spits out something like this: IMAP TIME SUBJECT DATETue Aug 20 02:42:25 EDT 2024 XXXXXXX_#6337.4 8/20/2024Tue Aug 20 02:42:52 EDT 2024 XXXXXXX_#6337.4 8/20/2024Tue Aug 20 04:06:13 EDT 2024 XXXXXXX_#704.0 8/20/2024Tue Aug 20 04:06:41 EDT 2024 XXXXXXX_#704.0 8/20/2024Tue Aug 20 05:33:15 EDT 2024 XXXXXXX_#7274.2 8/20/2024Tue Aug 20 05:33:47 EDT 2024 XXXXXXX_#7274.2 8/20/2024I’m then using a StringSearcher to extract the time with the regex \d+:\d+:\d+ and this gives me the time in essentially a %H:%M:%S format:Extracted original IMAP (for comparison)02:42:25 Tue Aug 20 02:42:25 EDT 202402:42:52 Tue Aug 20 02:42:52 EDT 202404:06:13 Tue Aug 20 04:06:13 EDT 202404:06:41 Tue Aug 20 04:06:41 EDT 2024

Creating new CSV files to upload to Azure Blob Storage, via FME Server

Hello,I was hoping to be able to create an FME workspace to be uploaded to FME server, that would run an SQL script (via SQL Creator) and create a CSV file that would then be uploaded directly to Azure Blob storage.I tried the 'AzureBlobStorageConnector' (using the 'File' upload option), but it appears that the file needs to be stored locally to use this option, which seems to be no good if I want to publish and automate this script via server. I also tried 'FeatureWriter', but couldn't see an option to write to a web service.Any help would be greatly appreciated!ThanksChris

1946

2 months ago

cfduneContributor

asked in Integration

FeatureReader crashes on reading ArcGIS Pro filegeodatabase

Hello,as it says in the title: FeatureReader crashes on reading ArcGIS Pro filegeodatabase. For my work I built a workbench were previously data got written to an Arcmap *.gdb which worked flawless. But now since my company is switching to ArcGIS Pro, I'm had to update the *.gdb to the ArcGIS Pro standards to be able to work with annotations. After running it with that updated *.gdb I received errors. After some fiddling it seemed that the issue was resolved. But a few runs later I found out that there were some attributes that I had to alter to the *.gdb to streamline it for later production steps. No probs so far. After doing that, the FeatureReader i use came up with the old attributes, and not the newly inserted. So I thought, I'll repoint it to the *.gdb, after doing so, the workbench crashed…I've tried different things to find out where the problem lies: Maybe a feature had bad geometry? Maybe to many features? Maybe the *.gdb was corrupted? But nothing I did helped. As a last st

1226

2 months ago

aharportContributor

asked in Transformers

Affine Warper without Using Offseter

Hello, I'm trying to use AffineWarper to transform 3D data (x,y,z) from a local coordinate system to a national coordinate system. This works well, but unfortunately the z coordinates are not changed. They retain the heights of the local system. Does the transformer only work in 2D?The offsetter doesn't help me here because the difference between the z-values is not the same for all coordinate pairs.Please help. Thank you.

354

2 months ago

doug_herrickContributor

asked in Transformers

A List query in FME 2022 doesn't work in FME 2024

Doing a query on a List named “LayerAttributes” worked in FME 2022 but doesn’t work in FME 2024. Any suggestions on how to work around this issue?In FME(R) 2022.2.3.0 (20230131 - Build 22789 - WIN64) I was able to query the list and get results. Here is a cutdown example where the query Value(LayerAttributes{@sum(@Value(LayerNameID),1)}) gives me the same results as LayerAttributes{7} However, in FME(R) 2024.1.1.0 (20240729 - Build 24619 - WIN64) the same query doesn’t work. @Value(LayerAttributes{@sum(@Value(LayerNameID),1)}) gives me <missing> and LayerAttributes{@sum(@Value(LayerNameID),1)} give me LayerAttributes{7}

703

2 months ago

mushailehObserver

asked in Data

Destination Esri Shapefile Folder not found

Hi all , i hope you can advise on this issue. i’m using the cloud FME Flow , i uploaded my fmw file but when i run the workspace i don’t find the shape files at the Destination Esri Shapefile Folder. any advise ?

171

2 months ago

cery.serenContributor

asked in Transformers

Geojson file - how to copy the array of features to a new Geojson file?

I am new to FME. I have a geojson file with an array of features - for example under functionalClass i have 6 different modes of transport and under category I have 5 different types of roads. I want to create a new geojson file but using an existing geopackage (with only the attribute field called roadName as a value) but I need the new geojson file to have the same array of features as the first one. What would be the best way to create this? I have consider the feature readers and writers, JsonTemplater and JsonFormatter. But I am a bit lost on where to start or what transformer is the best to use in this case? Or is there an easy way to extract the arrays in FME so I can build csv files and just map them using an attributemapper transformer? Thank you for your time.

201

2 months ago

dmbowmanContributor

asked in Data

ArcGIS Feature Service Reader Limiting Endpoints

We are moving to short-lived token authentication for ArcGIS Feature Service access. I am able to use the FeatureReader transformer and pass the token and read all endpoints (132 in total). However, I only want the transformer to retrieve a subset of endpoints. I attempted to create individual readers for each endpoint similar to what we had when using long tokens, but layers are now passing to the Initiator port. I thought adding a GeometryExtractor transformer would work, but it did not.

130

2 months ago

loldedubContributor

asked in Transformers

duplicate attributes on value-ranges

I have a dataset with attributes where in two columns the start and end of a range (postalcode)is it possible to duplicate the attributes with the missing postalcodes?example:range tels me: from 7595AM to 7595APthere are 2 postalcodes missing. 7595AN and 7595AO.from this attribute i would like to duplicate it to 4 attributes for each of the seperate postalcodes. thanx in advance. i am using FME Form 2024.1

PostGIS writer updates column while not in attribute definition.

Heya FME specialists, can you please give a thought on the next issue:Created a new table in PostGIS with FME from shape, using the PostGIS writer. (see 00_initiate.fmw) Point feature, attributes pkey and a, b, c with values. Insert, drop and create.Updated this table with the PostGIS writer. (see 01_update.fmw) Point feature, pkey, and only a, b with values. Update based on pkey, use existing.The problem is: We decided to maintain attribute c with QGIS directly in PostGIS but kept editing the geometry and attributes a and b in the shape. I deleted the attribute c in the writer assuming it wouldn't write it anymore to the database. That assumption appeared to be wrong and to prevent updating attribute c I had to use an AttributeKeeper in front of the PostGIS writer. My problem solved but curious if this is a DB writer syntax or a bug?Using FME Desktop 2016.1.0.1 on Windows 7. Uploaded workbenches in zip for reproduction.Thanks!

287

2 months ago

joySupporter

asked in Transformers

probems with DGN custom lines

Hello everyone,At the moment I am doing a conversion from BGT to NLCS (Dutch cad standard)I have an excel file (bgt to nlcs conversion) which has the corresponding color, line weight and linestyle names that I need for the conversion to NLCS.I have created a seedfile and via the Line style editor in Microstation 2023 I imported the rsc files that I needed in the seedfile.In fme, I don't use the dgnstyler, but I just defined the following attributes in the Attibutemanager:igds_style_nameigds_colorigds_weightIn the Level manager in the seed file, I haven't defined the levelname and the corresponding style yet, since it would be too much work for me. So based on Fme I just hope to give elements their corresponding color, lineweight and style. Color and weight has been succesfully (see below for snapshot of the output in the data inspector), only igds_style_name not yet. I haven’t used igds_style, since I don't know the number and I have the igds_style_name available in the excel file, so

140

2 months ago

cpedronContributor

asked in Data

Feature writer no dataset specified

I am getting the following error message when I try to run my workbench.“FeatureWriter_UtilMaster (WriterFactory): MULTI_WRITER: No dataset was specified for MULTI_WRITER_DATASET or FeatureWriter_UtilMaster_13_DATASET or FILEGDB_DATASET”I cannot for the life of my figure out what the issue is. My only theory is that because it is trying to write to a geodatabase, but the data I have been given to test with doesn’t actually have any geography. The writer is Featurewriter with output format Geodatabase (Esri Geodatabase (file gdb open api)) with the dataset as one of the attributes.Does anyone have any ideas that might help, or think I might be on the money that the lack of geometry is causing a geodatabase writer to fail.

401

2 months ago

1
...
19
20
21
22
23
24
25
...
1102

Page 22 / 1102

Badge winners

mglancloshas earned the badge Integrate Data with the FME Platform Training
davidpatruyohas earned the badge Integrate Data with the FME Platform Training
robertoavilahas earned the badge Welcome Back
awgeezrickhas earned the badge Integrate Data with the FME Platform Training
vmtnghas earned the badge Student (Grey)

Show all badges

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