- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form

FME Form

A space to discuss FME Form

27666 Posts

Most replies

Most views

Newest first

chaitanyamallaContributor

asked in Data

Cut 3D dgn/dxf lines by using 3d surface (pointcloud las, laz, dtm etc.,)

I have dgn/dxf formatted CAD 3D lines which are "cables" below the ground. These cables are sometimes 1m below ground and sometimes 50cm and 10cm etc. below the ground. I have pointcloud LAS data as ground elevation data.Now I want to extract the cables(lines) which are below the ground upto 50cm. I want to cut the cables layer with elevation model to selct the cables network from 0 to 50 cm below the ground.How can I cut those lines? I am trying with qgis and FME but, unable to get the right solution. Anyone has idea what software or methods to follow.

483

5 months ago

sameerContributor

asked in Transformers

SQLExecutor outputs NULL as value {NULL} - Possible Bug

Current Version: 2024.0.3.0 (20240603 - Build 24220) Since upgrading from 2023 to 2024, some weird behaviours have happened.Some critical workflows have not been outputting the correct information on our public facing website.In this case, I’m referring to the Building Control (BC) header on that page after you type in an address.Instead of stating that there was a BC information against a property, it would say no information found.Whilst investigating I found the following: The result of SQL Query was outputting NULL values as a string value called {NULL}.Never seen that before. Therefore, the Conditional Value was returning the wrong information. i.e. If xxx IS NULL and xyz HAS A VALUE….Subsequently I had to add a StringReplacer to fix this anomaly for now. SQL StatementWITH bc_html_aggAS(SELECT blpu_uprn, ARRAY_AGG(bc_html) AS bc_html FROM myproperty.buildc_html_temp GROUP BY blpu_uprn ORDER BY blpu_uprn)Select Distinct(bc_html_agg.blpu_uprn), b.address_string, bc_html_ag

604

5 months ago

jbriant

asked in Transformers

RealDWG custom hatches on FME Flow

Hi,I want to write a RealDWG using custom hatches on FME Flow.When working on FME Form, we put the hatch files in <FME install folder>/plugins/realdwg/Support and it works. But when uploading the workspace to FME Flow, where should these files be placed? Is there a designated location for them in the Resources?Any help appreciated.Cheers,Julien

1035

5 months ago

galigisEnthusiast

asked in Data

Load Data into a template GDB

HI All,What the best way of loading data into a blank template GDB? Attributes, domains, etc are already set up in the template GDB but need to know how to load data into the template using FME,Do I need to use the template GDB in the writer and then map the fields from the reader to the writer?Any idea how to do this?Thanks

281

5 months ago

martinjaegerContributor

asked in Data

SQL Server Error: "Unable to decrypt data"

In FME Form 2024.0.1.0 I got an error when trying to read data or schema with “Microsoft SQL Server Non-Spatial” Reader: “Unable to decrypt data”. On the same server, connection with SQL Server Management Studio works fine.Does anybody know this problem or has a solution?Regards, Martin

873

5 months ago

alfonsContributor

asked in Data

Reading multiple GDBs in subfolders with multiple FCs (identical schema)

HelloI have several GDBs with several FCs in different subdirectories. However, all GDBs have the same structure (same FC with identical attributes). I would like to merge all the data depending on the FC and then process it further in an existing workflow. Using the example, I was able to read and save all data, but it deleted all attributes and combined all FCs into one single FC. My question now is how I could read all FCs with the same name from all GDBs, merge them in one FC and then process them further in an existing workflow.

231

5 months ago

timnil00Contributor

asked in Transformers

How to find attributes in GIS that is not in my excel file?

Hello!I have a GIS layer with a field named “yttyp” wich contains all various of attributes since its a text type.I also have an Excel-file with allowed attributes. How can i check if there is unallowed attributes in my GIS layer that is not in my Excel-file, and list them in a new excel-file. I have tried change detector, listsearcher, featureMerger but i dont get it to work.

352

5 months ago

david_Contributor

asked in Data

How to update geometry column in SQL Server

I simply need to update a geometry column in a SQL Server table that is previously set to NULL. Could someone provide me with a simple example? I can't do it neither with a SQL Executor (previously using a GeometryExtractor to convert this geometry in Microsoft SQL Server Binary) nor with a featureWriter. I found this conversation from a while back but it didn't help me: Thank you!

952

5 months ago

scottshenbergerContributor

asked in Integration

Spatial Relator keep causing my workbench to fail

Hello, I am working creating a workbench that will take date for AGOL and from our sde database and join them together as a point feature for use in AGOL apps. All of a sudden, I get this error message:ArcGIS Online Feature Service Writer: Encountered an unexpected error. The error code from the server was '405' and the message was: 'This SqlTransaction has completed; it is no longer usable.'. Details: 'Unable to apply edits. Please check your parameters.'ARCGISONLINEFEATURES writer: An error has occurred. Check the logfile above for detailsAn error has occurred. Check the logfile above for detailsWhen I look at the log file I do not seem to locate any information. No sure what I am doing wrong.Thanks in advance. Scott

641

5 months ago

clairecoContributor

asked in Data

Create geodata, feature classes, domain value from excel file

Good eveningI produce a worbench wich create a file gdb and different features class (table, polyligne, polygon) from a excel file wich describe :fme_feature_type_name fme_feature_type_alias name alias fme_data_type geometry native_data_typeIs it possible in the same excel file :to create domain value (domain code and domain describe) to apply Global Id to apply editor trackor Thank you

datatoadContributor

Hey all, I am very new to FME and this may be a basic question, But I currently can’t find the answer elsewhere so I figured I would post and see if anyone can point me in the right direction. Currently, I am exporting from a GE small world database and moving the data to a FGDB for data analytics in other software. This is a complete export of all available data. That much I have been able to figure out with a few minor transformations. What I can’t yet figure out is how do I export only a small portion of the database. Say by a predefined polygon within the existing data set. For example My DB crosses a number of contiguous cities all having a defined boundary within the drawing. How do I tell FME to select and export only the lines and other objects within the city boundary of interest and excluded the data within the other city boundaries? Ultimately I need this breakdown so I Can export this to AutoCAD since the full DB is entirely too large for one drawing. Any help is apprec

523

5 months ago

flying_squirrelContributor

asked in Data

AIXM Workbench doesn't work in FME 2024

HelloI find this workbench on this website and i try to use it with FME 2024. It doesn’t work with the new version and i would like to know what is the issue. Could you please explain ?Thanks a lot

694

5 months ago

_fabian_Contributor

asked in Transformers

Use ODATA Reader to read nested complex types (arrays)

I’m trying to retrieve data from a nested JSON response of an ODATA Feed.For testing, I try to access the “Emails” property of this ODATA example service: https://services.odata.org/V4/(S(hg4u5ox0x0r2rjva5qwwra05))/TripPinServiceRW/PeopleThe JSON structure is as follows:{ "@odata.id": "http://services.odata.org/V4/(S(hg4u5ox0x0r2rjva5qwwra05))/TripPinServiceRW/People('russellwhyte')", "@odata.etag": "W/\"08DC9753B5381A6D\"", "@odata.editLink": "http://services.odata.org/V4/(S(hg4u5ox0x0r2rjva5qwwra05))/TripPinServiceRW/People('russellwhyte')", "UserName": "russellwhyte", "FirstName": "Russell", "LastName": "Whyte", "Emails": [ "Russell@example.com", "Russell@contoso.com" ], "AddressInfo": [ { "Address": "187 Suffolk Ln.", "City": { "CountryRegion": "United States", "Name": "Boise", "Region": "ID" } } ], "Gender": "Male", "Concurrency": 6385516329

592

5 months ago

mr_fmeEnthusiast

asked in Data

Remove cloud from Sentinel 2

Hi,I'm working with Sentinel-2 images. I would like to know if it's possible to use FME to remove or clip clouds from images. Does anyone have any ideas? Is it possible to use Google Earth Engine (GEE) with FME?Thank you.

571

5 months ago

jamesblytheContributor

asked in Authoring

BULK CONVERSION OF GEOTIFF FILES TO JPG2000

Hi.Could I please ask for a little assistance. I have about 1700 GeoTIFF files that I need to convert to 1700 JPG2000 files. So it is a 1:1 conversion for each file.I am familiar with converting GeoTIFF to JPG2000, but how do I do this en masse?FME Workbench 2020.Yours sincerely.James Blythe.

292

5 months ago

bubblebebContributor

asked in Authoring

Extract nested data from JSON to attribute table

Hi. I have the JSON data below and I have managed to expose attributes from this using the JSONFragmenter but am stuck with trying the extract the thirdparty.names from this record. As there are multiple names in this nested array I need to extract them either as a comma separated attribute. i.e. Leicestershire County Council, Mr J Tomms. Or as a list that I can work from. I cant seem to expose this attribute due to it’s nesting. Any help with the correct transformer and configuration would be great. Currently using FME Form 2023.2.2 but can update to 2024 if it is easier. { "_index" : "xxx", "_type" : "_doc", "_id" : "667951b042fcaa46307d1935", "_score" : null, "_source" : { "coi_num" : 68902, "engagement" : { "mail" : "Bob@home.com", "objectguid" : "8dc75819103e4e408684a75f87fd320b", "dn" : "CN=Bob Smith,OU=Rural,OU=Worcester,OU=FGUsers,DC=fg

bayramContributor

Hello, GML always writes a hyperlink at the beginning of the output, how can I fix this?

876

5 months ago

spatialexjamesContributor

asked in Integration

Is deleting from a Google Shared Drive supported?

I have been trying to automate uploading/deleting from a Google Drive Shared file using a GoogleDriveConnector, which I thought was recently changed to support shared drives. The first issue is that the files do no automatically overwrite if they have the same name, they create duplicates, whereas if you upload manually the files will become versioned. To get around this, I assumed I would be able to identify and delete the older file first before uploading the new file, however when trying to delete the older file I get:"2021-10-20 15:19:39| 21.6| 0.0|INFORM|Delete_existing_file: Object with id "File ID" does not exist on Google Drive. Nothing to delete". (I have removed the ID for this post). I have permissions to delete from the drive, and I have created the shareable link manually as a check to confirm that the file ID is correct and exists. I can successfully upload new files to the said folder, but I'm trying to avoid a scenario where I have a load of outd

384

5 months ago

rzel24Contributor

posted in Transformers

Deleting Files from a Google Share Drive (GoogleDriveConnector & HTTPCaller)

Hello all,Since I wasn’t able to find anything in the FME documentation about this and despite reading hundreds of community posts, I wanted to share what I’ve learned about using the GoogleDriveConnector transformer to delete files in Google Drive Shared Drives and Shared Folders.When using the GoogleDriveConnector in FME to delete files you need to make sure you have the right access. Shared Folders and Shared Drives have different types of access levels. For Shared Folders you have "Editor", "Commenter", "Viewer". If you want to be able to "Delete" files from these folders you will have to have an "Editor" level access right to the folder and the files.For Shared Drives, the access levels are "Manager", "Content Manager", "Contributor", "Commenter" and "Viewer".Due to the restrictions on the Shared Drive, its folders, and the difference in the actions each access levels can have, if you want to delete files from a Folder in a Share Drive folder you will need to have "Manager" level

660

5 months ago

p_c_20Contributor

asked in Data

Dealing with Excel where attribute schema is consistent but number of 'read me' header rows is not

I have a lot of excel spreadsheets that all have the same attribute schema. However, there are a varying number of header lines that precede the data in each. In FeatureReaders & Readers, we define the start point for data by line number. Given the consistency of the attribute schema and the inconsistency of the header spiel, I’m trying to think of a way to only read in the ssheets from the start of the data/attribute names, i.e. dynamically, defined by the first attribute name rather than the line number (I guess). Any ideas?

837

5 months ago

scarterContributor

asked in Transformers

Setting up a Web Connection for the AzureBlobStorageConnector transformer

Hello Forum, I need to start uploading data to a MS Azure Blob Storage account set up by our IT service providers.I have a Creator connected to a FeatureReader which is reading in the source file. The FeatureReader is connected to an AzureBlobStorageConnector transformer.But I first need to set up a new Web Connection through FME Options… I asked our IT provider for the Access Key ID and Secret Access Key of the Azure Blob Storage. They responded by saying that I should just use my standard network username (for the Access Key ID) and my standard network password (for the Secret Access Key). This really doesn’t sound right to me. I was expecting Access Key ID and Secret Access Key for the Azure Blob Storage. As I’ve not used Azure Blob before I don’t know what an Access Key ID and Secret Access Key would look like, but I’m sure it’s not my network username and password! Has anyone had successful experience with using the AzureBlobStorageConnector? If so, what did the Access Key ID and

334

5 months ago

spatialriqContributor

asked in Transformers

Compare shapefile to DEM

Hi, I’m fairly new to FME and having some issues with the PointOnRasterValueExtractor.All datasets are in EPSG:7850 (GDA2020, zone50) and the PointOnRasterValueExtractor seems to be working as I can see the correct values when I interrogate the points.The issue is when I try to write the output to a Shapefile. The Q__band values are all zeros.What am I doing wrong here?

1217

5 months ago

fbastian73Contributor

asked in Data

using directory and file pathnames reader to view/query data in some files

Hello experts,My question is simple.when using the Directory and File Pathnames to access a directory, can I then read files from that directory?I would like to be able to view and query the data in those 1042 filepaths passing the testfilter.see my current workbench: any help would be much appreciated,thank you.fb

403

5 months ago

jennychuContributor

asked in Data

how to create the TrafficSpace from TrafficArea in citygml 3.0?

Hello all, I am a beginner with CityGML and am currently trying to convert a dataset to CityGML 3 with generics extensions using FME Workbench.I re-organized the features in TrafficArea and added some new generic attributes. Then, I want to map these new features back to TrafficSpace to build the child-parent relation. But I always failed. I am not sure whether I used the wrong way to create the new TrafficSpace, and I didn’t find the tutorial online either. My workflow for the TrafficSpace is shown below. I extracted the boundaries from the TrafficArea and set them with lod2MultiCurve as the TrafficSpace back. Welcome for any suggestions or assistance! Thank you very much.

100

5 months ago

erik_janContributor

asked in Transformers

ListKeyValuePairCreator

Hi all,I am looking for a transformer that does the opposite of the ListKeyValuePairExtractor.It needs to create a list with FIELD_NAME and FIELD_VALUE pairs for all the attributes on a feature.I checked the transformer gallery and the FME Hub, but could not find such a transformer.Has anybody a solution?Could be a Python script. Thanks in advance.Erik

262

5 months ago

1
...
39
40
41
42
43
44
45
...
1107

Page 42 / 1107

Badge winners

sameershhas earned the badge Expert (Grey)
sameershhas earned the badge Teacher (Grey)
sameershhas earned the badge Student (Grey)
abhishekuhas earned the badge Expert (Grey)
abhishekuhas earned the badge Teacher (Grey)

Show all badges

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