- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,704 Posts
24,707 Replies

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

6704 Posts

Recently active

Most replies Most views Newest first

simbarashe

asked in Data

image scaling/ georeferencing

Good day I have an image dataset which I would like to do content conversion. As it stands y=-y, x=-x. How do I go about it to make x=x, y=y?It's my first time to use FME. I have tried to locate the scaler function but couldn't find it?

4 years ago

fikusas

asked in Data

Assigning CAD annotations as attribute values to features

I need to relate text values (annotations) to lines. In the example bellow, there are 3 lines and 2 annotations. The longest line (two segments) should get value "PEd100" and the other one should get PE32. Annotations aren't related to lines by common attribute, just placed near the lines.In this case both geometry and annotations are on the same layer, but it's not always the case. Any ideas?

4 years ago

fredtaylor

asked in Data

Hi guys. I need to add the lengths of all the parallel lines in an DWG file using FME. I used the FuzzyParallelLineFinder to try and accomplish this. After using a Tester to filter out all the "Attribute is Missing" results I am stuck.

It appears I now need to add all the _match_id(s) with their correlating unique _line_id by length.. Any tips on how to do this? Thanks in advance, Fred

4 years ago

bwnInfluencer

asked in Data

How to Read Oracle ST_GEOMETRY as Feature Geometry

So, I've read some of the earlier responses to similar questions but I don't know that I gleaned a definitive answer for this.The setup is in Oracle there are ArcGIS generated views of Versioned spatial data tables Eg. TableName_EVW and that View has SHAPE as an ST_Geometry (instead of Oracle's own SDO_Geometry).Yes, I know I can read this with the SDE Reader, but I need to get around SDE at the moment as it is misbehaving in the Covid world of VPNs whereas direct connection via native Oracle works MUCH better.So:All the FME Oracle Readers tried recognise the SHAPE field, but the Reader log tells me that it is skipping over the SHAPE field (presumably because it isn't SDO_Geometry data type)........despite that the log also tells me it recognises the Data Type as ST_Geometry. So the Readers by default return the non-spatial fields, and no geometries because it skips over the SHAPE field.SQLCreator/SQLExecutor methods don't work that well either. Same result even

4 years ago

jstanger

asked in Data

FeatureWriter using MITAB outputs incorrect CRS when incoming features are set to "LL-GDA2020_FME"

Using FME version 2019.2.3.1 it appears that if the MITAB writer format is selected within a FeatureWriter that non-standard CRS's default to an arbitrary "LL" CRS based on WGS84.When tested not using the FeatureWriter this doesn't appear to occur. The FeatureWriter does not allow setting of output Coord. System from an attribute therefore I am required to rely on "Same as source". I do have a MITAB workspace resource but again I cannot set the Coord. System as a Parameter and only as an Attribute in my use case.Is this a limitation on the FeatureWriter or on the MITAB writer and MapInfo format itself when it comes to very new Projections?

4 years ago

bernarddinon

asked in Data

Hello, I have a workspace with a Reader DWG. In the DWG, we use blocks with custom rotation. the reader does not keep the name and the rotation of the block. The outpul file doesn't contains this blocks. Can you help me? Best Regard Bernard Di

This some détails.Our Bloc "Orientage Crosse" has an custom orientation (Print Screen 1)Print Screen 1The dwg source has some block "Orientage Crosse" with a rotation and Angle1 (Print Screen 2 to Print Screen 6). In FME with the readers, the name of the block it's not "Orientage Crosse" but a specifi name like *U365, *U400,... (cf Print Screen 7 to Print Screen 10).The oriention and the Angle1 don't have the expected values. If my block hasn't angle1 like in print Screen 1, we don't have the problem. Someone can help me? Print Screen 2 Print Screen 3Print Screen 4Print Screen 5Print Screen 6Print Screen 7Print Screen 8Print Screen 9Print Screen 10

4 years ago

spizam

asked in Data

Can gINT (.gpj) files be read into FME? If not, are there workarounds? If not, are there any future plans to add it ?

4 years ago

johnglickContributor

asked in Data

Slow Loading Excel Format via Feature Writer in Desktop 2020

Since upgrading fme workbench to 2020.0, when I click on a feature writer with an excel format, it takes 30 seconds for the feature writer to open. Making any changes after it opens from there is painfully slow. Windows (windows 10) resource monitor shows fme desktop as being unresponsive for a bit while it's loading. Has anybody else experienced this?

4 years ago

virtualcitymattEvangelist

asked in Data

Wheres my dynamic KMZ/KML schema?

Does anyone know how to create a multi-layer KMZ/KML with a dynamic schema? Whenever I try It seems to only properly create the first layer with the correct schema and layer - everything else just becomes a placemark? I want to use the Schema From Schema Feature option in the output feature type. Has anyone got this working? If I create layers manually then FME will create multiple layers and schema definitions in the output doc.kml. If I use dynamic then I only get the first layer defined. I can merge all feature into a single layer for the file and the result looks great in Google Earth but the issue is there is one Schema in the output doc so when reading in with FME there is only one layer and one mega Schema.

4 years ago

1spatialmary

asked in Data

SQL Executor and spatialite - delete or drop commands rejected

I have some tables in a spatialite database, and I want to truncate the tables.It seems there is no TRUNCATE command in sqlite/spatialite so I've used 'DELETE FROM <my table>' in SQL Exector.I get a rejected feature with the following log message (in red text)."SPATIALITE reader: In ExecuteSQL(): sqlite3_step(DELETE FROM boundaries): SQL logic error or missing databaseSPATIALITE reader: Unable to execute SQL statement 'DELETE FROM boundaries'SPATIALITE reader: Unable to read feature type '__fme_execute_sql_results__'A fatal error has occurred. Check the logfile above for details."I can execute the same command using SQLExecutor on an Oracle database, so the issue seems to be with the spatiaLite reader/writer format.I've also tried 'DROP TABLE <my table>', but it returns the same rejection message.Reading some documentation online, it seems you cannot delete on views in sqlite/spatialite, but I'm trying to access a tabl

4 years ago

bharat

asked in Data

Disable FFS reader during runtime

I have various Workbenches which have FFS readers as input. In couple of WBs, there is a single FFS reader as input, whereas in few WBs, there are multiple FFS readers. As these WBs are required to be executed across various regions, some of the regions do not have one or the other FFS file. These WBs are executed using workspace runners. Before every workspace runner, i have place FileExistenceChecker transformer to check for existence of FFS file in that folder. If the FFS file exists, it is directed to that runner, else it skips and goes to the next FileExistenceChecker transformer. I have a problem with WBs having multiple FFS readers, as even if a single FFS file is not present, the FME stops midway. Is there a method to disable that particular FFS reader from the workspace runner, after it checks that the FFS file is not present in the folder ? OR any other workaround to bypass that FFS reader?

4 years ago

anthonystokes

asked in Data

How to update a feature layer on arcgis online using change detector?

I am attempting to read from an existing layer on arcgis online and check it against a layer in FGDB using change detector and update the same layer arcgis online if there are any changes made. They are all identical layers in terms of geometry. The only thing that will change is an attribute name in the table. So far it updates the data table correctly but it erases the geometry on AGOL.

Hi.I am wanting to export a point layer (GEODATABASE FILE) to a .dwg using the pre-reconfigured block template symbols. I have attempted using the DWGStyler but it will not pick up the templates symbols for some reason and just places a point. I have tried following https://community.safe.com/s/question/0D54Q000080hglVSAQ/replace-point-with-symbol-from-a-dwg but there is not quite enough detail on how to go about it. Can someone please provide the parameters that I need to fill to get the symbol to a dwg file.Thanks.

4 years ago

hemchandraprasa

asked in Data

We are looking for a simple FME code to convert shape files to Smallworld XML with relationship as per given sample XML file & the input shape file. The detail query is attached.Markatsafe had given a great answer before on other question to us.

4 years ago

checcosisaniContributor

asked in Data

Read excel from sharepoint

Read excel from sharepoint I try to read an excel file stored in company sharepoint site but no successI need to ask to IT some special rights ?any idea ? thx Francesco

Is there any way that a FME workbench could be set up to take several thousand documents from a directory folder and load them into MS Sharepoint?

4 years ago

jstafford

asked in Data

How can I create a primary key so Microsoft Access Writer won't throw an error?

I am creating a query from Snowflake and want to write the results to a Microsoft Access database. The job fails when writing to Access with the following error: Microsoft Access Writer: Writer mode for feature type `tblDaily' requires key column specification, or a where clause specification. I have searched on line and can't find a good example of how to correct this error. Can you point me in the right direction? Thanks!

4 years ago

holmgrenca

asked in Data

ProjectWiseWSGConnector to move files from local machine

Hi. I have a bunch of xlsx files that are created daily that need to be loaded to PW. They are all in the same directory so I used a TestFilter to separate them out. I can't select the 'File' option on the PW Connector b/c the date changes everyday and the Folder option won't work either. I did have some surface success with Attribute, but the files are corrupt when they land in PW. I am a bit of a newbie, so any help would be appreciated.

4 years ago

verdoodtdriesContributor

asked in Data

Geodatabase Error (-2147024893) .

Hi FME-users,I have a model in FME 2015.1 reading dynamically from a file gDB.If I ran the model locally, everything works fine. However, if I run the model on FME Server, I get following error:Geodatabase Error (-2147024893): The system cannot find the path specified.The path is provided by a published parameter which I'm passing to the model.Can anyone tell me more about this error?

4 years ago

alexanderallan

asked in Data

PostGIS Feature Reader not Dynamically bringing postgis attributes

I have a list of postgis tables and their schemas coming from a python caller. I want to dynamically read all the postgis layers and export them. However I cannot get the layer attributes to come through - only the geometry comes through in the feature reader.I'm passing the schema.table as an attribute called datasetName into the "Feature Types to Read". See below the inspector giving a valid value. When running I don't get the attributes that I expected along with the geometry: If, however, I paste in the text that I generated for the datasetName, i.e: o6_energy.bgs_eng_gas_goodcbmpotentialgbv1_bgs_bslnThen it creates a new port with the attributes I wanted: Hey presto, the attributes are there: Can I not dynamically provide the datasetName and get the geometry + attributes to come out of a single predictable port?Note it's not coming out of the generic port anymore, it's created another port with the dataset name. This is massively inconvenient as- as i

4 years ago

neal.gribben

asked in Data

Smallworld to MS SQL Spatial (JDBC) fails to write any features

I am trying to write from Smallworld 4.3, using FME 2018 build 18301 and the MS SQL Spatial (JDBC) writer. The writer creates the new table ok, but when it tries to write the features I get the following error: “C:\\apps\\FME2018\\metafile\\mssql_jdbc_spatial_.fmi could not be opened”. If I look in this directory there are 3 .fmi files that start with mssql_jdbc_spatial_, ie Destination, geommap, & Source. I presume FME is looking for some sort of parameter value, and trying to make some decision on which of these 3 files to use, however I can’t see any missing parameters in my mapping file. Can anyone point me in the right direction please?Thanks Neal

4 years ago

mr_fmeEnthusiast

asked in Data

Run a batch process

Hi, I have a very simple workspace, the result of which is excel spreadsheets. However, there is a published parameter where I always need to inform dates, for example: 20200709030000, 20200710030000,20200712030000. Currently I need to run date by date, is there a way to run date by date automatically, that is, entering the required dates in one go? Thank you very much

4 years ago

emain

asked in Data

Recognize "strikethrough" in cells

I am merging an excel spreadsheet and an ArcGIS SDE feature class on a common field. Some of the entries in the spreadsheet have a "Strikethrough" effect--these entries should be ignored, however, FME is matching them anyway. How can I get it to ignore any entries with strikethrough?

4 years ago

ianh

asked in Data

ArcGIS Portal Feature Service name

I am trying to read the domain names from a portal feature service. I believe this requires the use of the REST API and httpCaller. I am also using a Portal Feature Service Reader to do everything else I want to do.I have tried everything I can think of to get hold of the Feature Service parameter with no success.Is there any sort of elegant way to get hold of this parameter so I can use it in the httpCaller to return queryDomains?My last resort would be for the user to have to effectively do this twice when picking the feature service to read (in the reader) and also get them to supply a text published parameter in the run dialogue (for use in the httpCaller).Am I missing something? thanks in advance Ian

4 years ago

mladenamovic

asked in Data

I need a help for POSTGIS to GML feature transformation.

I need a help for POSTGIS to GML feature transformation. All attributes are written except geometry in GML and after translation I got Attribute table. All geometry data are ok in POSTGIS DB.

4 years ago

Page 59 / 269

Badge winners

kersyhas earned the badge Welcome Back
jambrogihas earned the badge Student (Grey)
jambrogihas earned the badge Teacher (Grey)
jambrogihas earned the badge Welcome Back
dannhas earned the badge Webinar Watcher (Grey)

Show all badges

29,738: 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.