Skip to main content

- - Community Resources
Ideas
Product Updates
Events
Blog

EN

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,713 Posts
24,736 Replies

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

6713 Posts

Recently active

Most replies Most views Newest first

Unable to convert value taken from Z_ORIGIN keyword to a float data type

Hello,I am writing to ESRI geodatabase that uses MS SQL. Every time I get "Unable to convert value taken from Z_ORIGIN keyword to a float data type". So far i have:Used a 2dforcer,changed the "z scale and z origin" to 0 or 0.00000under table creation parameters set "Contains Z Values" to No (also set to yes, and blank on other trys)Recreated the writersSet the writer geometry to table, not a point file.Nothing has worked. I am under the assumption that the writer is passing a "Null" value to the writer which in turn says that "null" cant be a float value.Finally I have looked at the other posts on this and nothing has helped. Any suggestions? Just to update, I used a vertex creator to make new geometry, and still didn't work, but i can insert all of this into a file geodatabase and then import that to my enterprise database. If anyone has any help please post it, this issue doesn't have a good answer on the forms yet.

lambertusEnthusiast

PostGIS Reader - warning about 3D feactures

I created a 2D spatial point dataset in a PostGIS database.Today I tried to load them into FME, that works perfect. I get the right locations including the according attributes.I only get this warning:Dimension metadata is ambiguous for spatial column 'geom'. Reporting 3D when 2D+measures might be presentDid I forget to set some specific settings while creating this dataset? There should be no 3D data present, I only saved 2D data :)

alicevdbContributor

WHERE Clause can read text with macronated o, but fails to read a User Parameter with same text macronated o.

Context: Feature Type with a WHERE clausePurpose: To only read records relating to a user defined Iwi (Maori Tribe).When the WHERE Clause is, for example: "IWI"='Whakatōhea', the transaction is successful and returns the expected records. However, when the WHERE Clause is set with a User Parameter "IWI"='$(IWI)'and the User Parameter is set with the value Whakatōhea, the transaction is successful but no records are found.This behavior is only affecting records with macronated vowels, which is common in Maori language. Users need to be able to input their Iwi of interest for this workbench.Can anyone suggest where the WHERE clause setup might fail?Many thanks

tbarker1986Contributor

DWG Writer: Preserve Template File Paper Space Issue

Hi All, i’m having an issue writing to an AutoCAD DWG file, with a template file. I want to preserve the Model Space, but not the Paper space as i’m editing some attributes within the drawing title block in FME which I want to write back out in the paper space.Even though I am setting preserve paper space in the writer to No, the original blocks from the template file, including the original attribute values, are being written as well as a copy of the block with the new attribute values I have updated in FME. As a result I have 2 overlapping blocks, 1 with the new values I want to keep and 1 with the original values I am trying to replace. I just want a single block with my new values.In the attached, you can see the output from the writer, with the same block duplicated with the new value I have updated and the old value in the template (highlighted in yellow).Any thoughts/ideas/assistance with this would be greatly appreciated, whether this is possible or not possible. I have done si

lambertusEnthusiast

PostGIS performance tricks

Recently I put different tables into a PostGIS database. One of these tables contains 23M unique records and does not contain spatial data. I would like to read them into a FME workbench. Do you have some suggestions how I could improve my reading process?Is it possible for example to preselect already a set of columns I need while reading my table using 'SQL to Run before Read'?’ If so do you have a example SQL querry? Is there a performance difference between 'SQL to Run before Read'?’ and the WHERE clause option in the Constraints menu?

ricardoaContributor

Create polygons from a string of coordinates

Hi there!I want to create polygons from an attribute that contains a string of coordinates and other information. My problem is that I don't know how to only extract the coordinates from the string and then create the polygons by their ID attribute. The string in the coordinates attribute looks like this:“{"type":"Feature","properties":{},"geometry":{"type":"Polygon","coordinates":[[[13.707920553133594,60.03475791657763],[13.708950521395312,60.03304306231432],[13.705474378512012,60.03160680337132],[13.702513219759567,60.02997753853561],[13.702255727694139,60.030577803349054],[13.703929426119434,60.03184261136259],[13.706161024019824,60.032571461785544],[13.707920553133594,60.03475791657763]]]}}” ID attribute 1 to 10 Regards, Ricardo :)

mr_fmeEnthusiast

Run two custom transformer identical in Workspace

Hi,I'm using two SentinelDownloaders in my workspace: one to download data from a specific year and another to download data from the previous year. At the end, my workspace shows a "FAILED" message in the API after completing the first SentinelDownloader. I understand there is a conflict because it's the same transformer being used for different dates in the same execution.How can I run this workspace without problems?Thank´s

neaContributor

Not able to create a web connection

i”m unable to create the web connection despite all the documentation.

topotomaContributor

Featurewriter Excel error "Named range from /xl/workbook.xml part" only with 2024.1.2.0

Hello,When using Featurewriter with a template excel file, i encounter en error when trying to open the written excel file which indicates a problem with the Named range "Named range from /xl/workbook.xml part".This happens only since updating to 2024.1.2.0, if I use the same workspace with 2022 version it’s fine.Has this happened to someone else ? is there a workaround ?I’ve tried a lot of things but couldn’t find the issue so for now we run this workspace with 2022.Thanks for your help.

pushpaContributor

Column names on Oracle VIEW doesn't show on FME workbench.

Hi there,I have placed few VIEWS on Oracle Database changing TABLE column names. ie: ID as PLANT_ITEM_IDWhen I connect the VIEW via FME 2023.2.1.0 all column names are showing as what is recorded on Oracle Tables. It is ignoring column names I have set up on VIEWs. How do I get around this issue?I don’t want to use “attribute manager” to change the names. I have already done that on my VIEWs.Is there a way I can see the Column names on VIEWS through FME?thanksRegards,Pushpa

mr_fmeEnthusiast

Problems with feature count server

Hi,Suddenly, the feature count in FME Desktop disappeared, even with the "Enable Feature Counting" option ON.The log shows: Cannot connect to feature count server "65051."Why does this happen?The problem occurs with all formats.Thanks.

mr_fmeEnthusiast

Hi,I need to extract pixel with value 3 ,8 and 9. Have some transformer that filter the pixel value? Thank´s

dustinInfluencer

Help with understading OSM donuts

I could use some help in understanding how donuts are stored in OSM XML. Or more specifically, why FME Data Inspector is not constructing the donut from the XML. Here is the simple shapefile test data I’ve created.In FME, I’m writing out the OSM using the normal writer:When I read that OSM back into Data Inspector, it doesn’t recognize the shape as a multipolygon. The geometry type is fme_no_geom:The XML code is below. I’m seeing the relation present, so I’m not sure what else is required.<?xml version="1.0" encoding="UTF-8"?><osm version="0.6"> <node lat="34.6596384" lon="-87.0320968" id="-7"/> <node lat="34.5631538" lon="-86.8849822" id="-10"/> <node lat="34.7427899" lon="-86.9769288" id="-8"/> <node lat="34.4741373" lon="-86.9217608" id="-4"/> <node lat="34.6293808" lon="-86.7401662" id="-2"/> <node lat="34.5063457" lon="-87.0619795" id="-5"/> <node lat="34.5536885" lon="-86.9194622" id="-16"/> <node lat="34.5669396" lon="-87.

smithgkContributor

Converting Overpass Turbo (OSM) data from xml

Hello,There have been some previous posts about converting OSM data in FME, but I’m hoping to breath some new life into the conversation. I have an Overpass Turbo query here meant to query ski area boundaries, lifts, and runs within Colorado. The query works just fine in Overpass Turbo, and I’m able to read the raw XML data into FME with the HTTP Caller no problem. The issue I’m running into is visualizing the data beyond that. I’m aware of the example workflow that is similar to my process, but I don’t understand how the XSLT Processor and XML Fragmenter transformers work. If I use those transformers in my workflow, all the coordinate information seems to disappear when the data is fragmented.Does anyone know how to properly display the XML data in FME? I might need a geometry filter to split out points, lines, and polygons, but I don’t think that’s what is holding me back currently. Any help would be greatly appreciated!

Apply Python shutdown script on file before FME Flow Download service

Hi,I’m trying to modify the output file of a workspace using a Python shutdown script before it’s caught by the download service (or after, but before downloading). Is there any way to do that?The configuration is:workspace creating an output text file (interlis) workspace added to a Flow app with a download serviceI’ve tried to use the destination dataset parameter from the writer but without success. The script is :import fmedest_dataset = fme.macroValues['DestDataset_Interlis']with open(dest_dataset, 'r') as file: filedata = file.read()filedata = filedata.replace(',', '.')with open(dest_dataset, 'w') as file: file.write(filedata)Or if you have any clue on how to force an Interlis writer to use dots instead of commas as separator without changing the server locale, I’ll take that info as well. FME versions:Flow 2023.1.1.1 Form 2023.1.1.1 Best regards,Julien

scarecrowContributor

Raster renaming in Esri SDE

Hi All,I’m creating an archiving workbench for our Esri Enterprise SDE databases. I’m trying to automate checking for an existing version of a raster in either our shared or archived databases and then assigning a version suffix according to if the data already exists in one of the databases. I have the majority of the workbench sorted but struggling to automate renaming the raster to include the version suffix when writing to archive.In my example below I’ve identified that there are two existing versions of the test data “gen_aaa_aaa_test_ras” so I’ve created a name field “archhiveddataname”, which contains the the name I want to give the raster when I write it to Archived “gen_aaa_aaa_test_ras_2”. I can access this information from the schema port but not from the generic. If I include the information from the schema port I get an error saying that I’m trying to write non-raster geometry and the workbench fails. I’m using FME 2023.1.2.0 (20231110 - Build 23641 - WIN64) Thanks in adv

caroline_pnwContributor

Updating a Feature Service through ArcGIS Portal - Using Dynamic Schema

I am trying to see if I can update a feature layer in our ESRI Portal from a FGDB. We know we can insert, update, and delete features and have success on those fronts. However, we will like to also have dynamic schema available as we may change the data in our FGDB by removing/adding fields. I have tried several times to get a dynamic writer working to account for a schema change but without luck. I have tried to delete data in the feature layer to then insert but that had errors. Does anyone have advice or has done this? The FGDB is a testing stage as eventually we would want to update directly from SDE.

youssefContributor

How do i write Geometry to AIXM RunwayTimeSlice?

Hey guys, i really struggle to write my geometry to the RunwayTimeSlice Element of the AIXM 5 writer of FME. After the GeometryExtractor i got a string looking like this: <gml:Surface srsName="EPSG:31467" srsDimension="2"><gml:patches><gml:PolygonPatch><gml:exterior><gml:LinearRing><gml:posList>5544321.76358795 3466140.39319303 5544321.79681692 3466111.70099084 5544321.79831432 3466110.40802792 5544321.8330376 3466080.42553198 5544021.7716845 3466080.40979097 5543896.905 3466084.247 5542896.762 3466080.481 5540345.41046032 3466080.53414733 5540345.41261875 3466140.53829729 5542896.8 3466140.46 5543901.789 3466140.512 5544021.76302164 3466140.39707783 5544321.76358795 3466140.39319303</gml:posList></gml:LinearRing></gml:exterior></gml:PolygonPatch></gml:patches></gml:Surface> which should be the right format for the gml geometry. But when i try to write it in the surfaceProperties Attribute of the writer nothing ha

sigbonoContributor

ArcGIS Online Feature Service Reader Error Code '400' Deatils '24214'

We published a feature layer in ArcGIS Online and when we try to read the features in FME Form 2024.1 (20240628 - Build 24612 - WIN64), we get this error. ArcGIS Online Feature Service Reader: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Cannot perform query. Invalid query parameters.'. Details: '24214: Circular arc segments with Z values must have equal Z value for all 3 points., Unable to perform query. Please check your parameters.'Python Exception <ArcGISServerError>: FMEException: 928221: ArcGIS Online Feature Service Reader: Encountered an unexpected error. The error code from the server was '400' and the message was: 'Cannot perform query. Invalid query parameters.'. Details: '24214: Circular arc segments with Z values must have equal Z value for all 3 points., Unable to perform query. Please check your parameters.'We have published two more feature layers and it all works fine. Does this have something to do with our data

mr_fmeEnthusiast

Filter in the Feature Reader parameters

Hi,I’m using the Feature Reader to read Sentinel images.I would like to filter only the files (in a folder) that contain "B08" as part of the filename. There can be many files with "B08" in some part of the name.How can I do that? Thank´s

leestammContributor

Hi can FME deal with BPF files (point cloud data storage), or is it planning on supporting this..

paulmcm601Participant

Symbology issue when creating shapefile - ListExploder/Aggregator issue?

[Software FME Workbench 2021.2.3]Hi,Trying to generate an Esri Shapefile Polygon output of areas with data merged from multiple datasets to the Area dataset.The addition of Location Names (at least one per area) seems to be throwing up an issue.After doing the steps below the Transformer Views and Shapefile Symbology changes and goes a bit weird, and I’m not exactly sure how to sort it.Below polygon symbology is one area, but there are probably 30% of 1000 Polygons that have similar symbology issues.Any help would be greatly appreciated - Many thanks.Step One:Feature MergerRequestor: Area DatasetSupplier: Location Name DatasetMerge on AreaIDGenerate List:List Name: _listAdd to List: Selected AttributesSelected Attributes: Location_Name Feature Merger: Merged OutputStep Two:List ExploderList Attribute: _listAccumulation Mode: Merge List AttributesConflict Resolution: Use List Attribute Values List Exploder: Elements OutputStep Three:Aggregator to update the Location_Name to have multipl

markrmunozContributor

Writing date time from an xlsx

I'm trying to overwrite a date/time field with two columns from an excel file. I'd like to use attribute manager to concatenate the two columns into (Date) MM/dd/yyyy and (Time) HH:mm:ss AM/PM however I'm getting null values. The datetimeconverter led to an error saying my format wasn't FME standard. Any help is appreciated, thank you.

nbeekersContributor

Group records in range of Values and time

Hello, Im searching for a solution to give records a group value based on multiple values statements. Data needs to be grouped on a Vehicle in time asc.So far this is not the problem.The grouping also needs to Start with a value Status = "Start”and all the other records after Start.The grouping needs to be closed after Status End comes as a record.It looks like a range or a ranking. If someone has some idea thanks. Kind regards, Nick

iberzinsObserver

Reflectors in AMDB

Hello!I am importing data from Aerodrome data (gdb) to AMDB. Aerodrome has reflectors on the edges of taxyway. What should these reflectors be stored as in the AMDB?Maybe AerodromeSurfaceLighting or some kind of Marking or AerodromeSign or something else? The Reflectors

1
2
3
4
...
269

Page 1 / 269

Badge winners

t.yang_rmwbhas earned the badge Integrate Spatial Data
crystalatsafehas earned the badge Kanelbullens dag
ahuertahas earned the badge Welcome Back
chelseawuhas earned the badge Kanelbullens dag
dbaldacchino1has earned the badge English Speaker

Show all badges

29,799: Posts

Powered by Gainsight

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login

Login to the community

An FME Account is required to contribute

Login

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.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK