- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,826 Posts
25,144 Replies

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

6826 Posts

gmbutler2Contributor

What transformers would I need to use to reference as the cell rotation angle in the dgnstyler?

I am using an aggregated object to insert a cell using the dgnstyler. The aggregated object has 2 geometries, a point and a line. I need to use the line as a reference for the angle of the cell rotation, but I do not know how to derive an angle for this line. Can someone help me find a way to do this?

7 years ago

katiem

asked in Data

Issue with using the XMLUpdater transformer to manipulate Metadata

I'm using the Esri Geodatabase (ArcSDE Geodb) reader with Feature Read Mode set to Metadata, to read in GEMINI metadata from SDE. I'd like to manipulate certain elements before sending the updated metadata back to the SDE feature class. Using the XMLUpdater I've been able to amend the content for some elements, however I haven't had any success when trying to amend the revision date, as there are three different date strings all with the same XML path: metadata/gmd:GEMINI_Metadata/gmd:identificationInfo/gmd:MD_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:date/md:CI_Date/gmd:date/gco:DateCurrently none of them are getting updated on the output XML. The different date types are differentiated in the gmd:dateType element, e.g: <gmd:dateType> <gmd:CI_DateTypeCode codeList="http://standards.iso.org/ittf/PubliclyAvailableStandards/ISO_19139_Schemas/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode" codeListValue="revision">Rev

My readers are csv files with uniform # of commas in each row, but with no headings. And each file name is unique and needs to be made an attribute. Is there a way to add attribute names as I read in each file?

7 years ago

eltigre333

asked in Data

How to Extract Coordinates from Oracle Spatial Object Table

Hello, I've searched all available online sources but none appear to have this issue.Very simple task: I've added an Oracle Spatial Reader, connected to desired table and now want to extract x/y but I get this error when running."Error - Cannot have NULL value for 'z coordinate'"I've looked at the table in Oracle developer and indeed the Z values are Null.I'm aware that this table has multiple Spatial columns so I've checked: Handle Multiple Spatial Columns: YesI've tried a SELECT statement to run before translation:SELECT c.GEOM.SDO_POINT.X AS X, c.GEOM.SDO_POINT.Y AS Y, FROM A.ENTITIES c WHERE ACCESS_CODE = 'O'I've tried to expose the attributes: oracle_sdo_point.x oracle_sdo_point.y oracle_sdo_point.zIs there a way to force this to 2D rather than looking at the Z values?Any ideas appreciated.

3050

7 years ago

tim_woodContributor

asked in Data

Log says "fixed reader/writer config issues" loading Workspace - how do I find out what was fixed?

When loading a 2016.1 Workspace in 2017.0, I saw this in the Translation Log:Workbench: Workspace integrity check during load found one or more readers/writers with configuration issues.Workbench: Backed up current workspace as: X:\\Path\\Folder\\Wibble (backup).fmwWorkbench: Fixed reader/writer configuration issues.How can I find out what was wrong with the Reader/Writers?

7 years ago

ciarabContributor

asked in Data

Generic Writer Autodesk AutoCAD DWG/DXF

Probably a simple solution to this but I can't seem to find it.If I have a generic writer and I want to write out to dwg or dxf how do I enforce it to write to dxf, it defaults to dwg . I have tried lots of things like creating a dummy writer for ACAD or creating an output published parameter with 2 options for the AutoCAD writer with 2 different values-- this works but if I select DWG or DXF I still get a dwg file.I can add a tester which sorts whether the end user selected DWG or DXF and then filters it into an ACAD writer that has the extension hardcoded..but I don't really want to do that when I feel like I have just missed something? Any help would be appreciated

Text Node Linkages in Microstation

When translating text nodes into Microstation I have found that the linkage is not being created during the translation. Once the dgn is created I must select the text node and edit it before the linkage shows up. This is an issue when I need to project the data into a different coordinate system because the text nodes end up in a different location then everything else. Is there a way to have the linkage created during the translation process?

I simply want to import a drawing from a client which has the DGN extension; into AUTOCAD 2017. It says " DGN must be in version 7 or 8" and closes the dialog with an error. This FME software is far too complex for such a mundane purpose. I can redraw the entire project in less time than it would take to learn software such as this. Does anyone know of a simple tool to convert non supported DGN files to AutoCad 2017?

120

7 years ago

hlouieContributor

asked in Data

File Properties, change created and modified by date

I have a directory of PDF files scanned in 1996, I have feature dataset linked by PDF filename the with another attribute field with correct document creation date. How can change the PDF filename properties of creation data?

Issue mapping Oracle 11g database using schema mapper to a geodatabase

I'm having an issue using the schema mapper to remap the schema of a Oracle 11g database and write thte data into a file geodatabase using FME 2017.0.0.0 Build 17236. I have succesfully mapped the SQL Server version of the same schema and data with no problems. If I set up the Oracle mapping I can get it to map successfully but it will fail to output to the geodatabase and will automatically output to an .ffs file. I can then open up the .ffs file and everything is mapped properly, just not outputting to the right location. Any advice regarding this issue would be much appreciated.

7 years ago

bas_boers

asked in Data

How to create a INSPIRE GML without the gml:boundedBy-tag

Hi, I'd like to create a inspire GML-file (using the inspire GML writer) without the <gml:boundedBy>-tag. <gml:boundedBy> <gml:Envelope srsName="EPSG:28992" srsDimension="3"> <gml:lowerCorner>96465.102 471796.29 0.00</gml:lowerCorner> <gml:upperCorner>145855.225 563146.105 0.00</gml:upperCorner> </gml:Envelope> </gml:boundedBy>Is there a way to generate such a zipped gml (with the INSPIRE gml writer) without the above text/tag. How do I prevent my workbench from generating this tag. Thanks in advance.Bas Boers

160

7 years ago

courtney_mContributor

asked in Data

Updating SDE Feature Classes That Are Involved in a Relationship Class

I have a series of workspaces that sync an Oracle Database with an SDE database every hour (ORACLE_SPATIAL and GEODATABASE_SDE Readers > GEODATABASE_SDE Writer). I created several relationship classes in the SDE database (via ArcCatalog), and now my workspace fails to update any of the feature classes that are involved in a relationship class.I am receiving the following error: Error while retrieving an ArcObjects update cursor for the table/feature class 'DBO.EL_SERVICE_POINT'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session}If I delete the relationship classes, the Feature Types update as expected.I tried setting geodb_feature_has_relationships to 'yes' before writing to SDE, but I still received the same error.Also, the Transaction Type on the SDE reader and writer is set to "Versioned Edit Session", as I am updating a versioned SDE databa

i have i esri map doc shown in the pic blue bold lines has complex edge geometry an e specefic id and blue triangular points has their own spec id now i want retive blue triangular points and bold line id into dashed lines

7 years ago

stuartohara

asked in Data

Can I use attributes from a shape file grid to name my raster writer output files?

Hi All,I need to automate the process of cutting up an image file into approximately into 11,500 separate images.I have my image file. I have my grid shape file that contains attributes that I want to use as my output image file names.I can get image outputs using clipper that are exactly as I expect (correct dimensions etc) but cannot figure out how to name them correctly.I'm convinced that I'm missing something quite simple here.I have been searching through the knowledge center but can't find exactly what I'm looking for.Has anyone had experience with this? I'm using FME Desktop 2015

Timeout / Postgis-Writer

Hi ,is it possible to set a timeout-Parameter for writing in a Postgis-DB to ensure, that the connection will be closed.

7 years ago

nmattonContributor

asked in Data

Set writer output folder from attribute value

Hello FME's geeks !I am looking for writing outputs as shapefile to a path that is derived from the concatenation of an input parameters, a given string and a timestamp.In other words, the path should look like $(input_parameter1)/$(string)-$(TimeStamp)In my case,The input parameter is a folder given by user (Main_Input_Folder)The string is the basename of an input file given by the user without extention (eg : C:\inputFolder\myfile.shp => basename = myfile)For now, I am able to concatenate the input parameter and the Timestamp (creating a Python scripted private parameter for creating the string) giving something like $(input_parameter1)/$(TimeStamp) and use it to the "Destination Esri Shapefile Folder" parameter : However, to add the basename, I created another Python scripted private parameter to extract the basename (used code below) but when I try to add it to the "Destination Esri Shapefile Folder" parameter I get this error : Undefined macro `AOI_basebame' dereferenced in fi

Error in PostGIS writer-Error executing SQL command ('select * from "databasename"."tablename" where false limit 0'):

Hello, My reader is a MapInfo table and my writer is a PostGIS database. I tested the database and I was able to successfully connect to the database. However, when I run the workbench only 1 record goes through and I get the following error: Error executing SQL command ('select * from "databasename"."tablename" where false limit 0'):'Writer failed in write() callAny idea of what is going wrong?

870

7 years ago

fmelizardContributor

asked in Data

Sometimes the log files confuse what version of database I am using. Does ORACLE8I mean FME is trying to use Oracle version 8i?

2017-03-15 19:46:42| 131.8| 0.0|INFORM|ORACLE Reader: Using Oracle Reader to read tables from database `', server type `ORACLE8i', server name `bebop', user name `importantuser', password `***'

SQL Server BIT datatype not supported when writing to MySQL

I'd like to report what I suspect might be a bug with the MySQL data writer. Applies to FME 2015 Workbench.I have a simple workspace consisting of a SQL Server data reader and a MySQL data writer. It reads a MS SQL table with some fields being a BIT data type. This then gets pushed out to a MySQL database (using a drop command first). I observed some problems with this, specifically to do with the BIT datatype. (1) - The MySQL data writer dialog lacks support for BIT type. The nearest type FME can use is TINYINT. See screenshot below. Even if I choose Manual attribute definition, there is no "BIT" datatype in the dropdown list.(2) - You would assume that there shouldn't be any difficulty writing a Bit (1 or 0) to a Tinyint. However FME reports errors during the write process. Even trying various different types: int, smallint, varchar produced same results.Insert failed on table 'lynx_animals'. Error was 'Incorrect integer value: 'Yes' for c

Convert Packbits geotiff to lzw

I'm new to FME, and I need to transform a Packbit compressed geotiff file to a LZW compressed geotiff file. I'm using a geotiff reader and a geotiff writer, the later configured to use LZW compression. The output file is still in packbits

Creating a 3D box or sphere and allocationg x,y,z coordinates to it.

I've looked around and I can't seem to find anything that covers the applications of coordinates/ applying a location to a 3D element. The idea being that I can extract a list of points into a csv file then represent the list of coordinates as a 3D element within a DWG/DGN/IFC.Any help would be great thanks.

SMTP relay not installed as a service in FME 2017?

Please see https://knowledge.safe.com/questions/41408/smtp-relay-not-installed-with-fme-server-2017.htmlSounds like either an error or lacking information.

7 years ago

ericderoche

asked in Data

Does FME support autocad blocks that are dynamic?

I am using the latest build of Fme desktop and I am trying to use an autocad block that has dynamic content in it and is not working. If I take the dynamic parts of it out it works just fine. Does anyone know if Fme supports Autocad dynamic blocks?

Is there a way to speed up the point cloud simplifier?

I am trying the point cloud simplifier on a point cloud with 11 million points, but it is taking a very long time . It hasn't finished yet and it looks like it could take days to finish. Is it possible to speed up the transformer based on the parameter values?

Is there a way to print a selection on a postgre database in the logfile; using sqlexecutor?? For example, I write - select * from tabename - and want to print the results on the logfile.

7 years ago

Page 204 / 274

Badge winners

bradyhas earned the badge Welcome Back
magda_czhas earned the badge Student (Grey)
magda_czhas earned the badge Teacher (Grey)
magda_czhas earned the badge Welcome Back
formflowinghas earned the badge Welcome Back

Show all badges

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