- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Data

Data

Using readers and writers to extract and load data.

6,778 Posts
24,917 Replies

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

6778 Posts

Recently active

Most replies Most views Newest first

bfegyverneki

asked in Data

Why is there a 10 Character limit to V8DGN Cell Names in the V8DGN Writer?

Why is there a 10 Character limit to V8DGN Cell Names in the V8DGN Writer when the V8DGN file format allows for a 512 character cell name? The old igds days are long gone and I don't understand why FME V8 DGN writers would not use the V8DGN file format attributes sizes? 10 Characters is not enough in the V8 DGN world for a cell name.

7 years ago

krostir

asked in Data

?KML with ExtendedData to Shapefile

I am trying to convert a Google KML file to ESRI Shapefile and to include the ExtendedData as attributes.European Space Agency is publishing planned satellite observation scenario as a KML file that has several attributes in the ExtendedData tag (see ). These attributes are always the same, as here:<ExtendedData> <Data name="SatelliteId"> <value>S1A</value> </Data> <Data name="DatatakeId"> <value>1C269</value> </Data> <Data name="Mode"> <value>EW</value> </Data> <Data name="Swath"> <value>NA</value> </Data> <Data name="Polarisation"> <value>DH</value> </Data> <Data name="ObservationTimeStart"> <value>2017-06-06T20:19:16</value> </Data> <Data name="ObservationTimeStop"> <value>2017-06-06T20:20:32</value> </Data> <Data name="ObservationDuration">

How to obtain a good structure

Hello,It's hard to explain. I'm french guy and new in FMEI give you a "fmw" file and try to explain my problem. I try to transform an AIXM 4.5 file to an AIXM 5.1 file. This concern the "AirportHeliport" feature. I follow different examples on the FME website and some examples in my office.I have a problem with the final schema. I try to obtain the "servedCity" structure at the end of the transformation but in the final output file (XML File) the structure "ARP" disappear ... I don't want that, but i don't understand why ...So, if i connect the bookmark "servedCity" the result with ARP disappear and if i disconnect "servedCity" the result with ARP appear.what is wrong with the "geometryPropertysetter" transformer ? I saw it's necessary to use it with the XML_Geometry type but i don't understand why the structure in the xml file disappearPlease some helpMy first Zip : airportheliport_without_se

113

7 years ago

whkartoContributor

asked in Data

Flipped triangles at OGCKML Writer output

Hi everybody!I'm facing a problem with the ocgkml Writer. When I route 3D surface geometry of building models to the writer, I'm getting flipped surfaces for my facade features. Unfortunately this behaviour doesn't remain constant for all facade triangales, some of them are oriented correctly and some are not. The input features look correct to me and exports to collada prove this to be wright.An export with FME 2015 also shows a correct export with all walls oriented correctly. So this has to be an issue with FME 2016 and 2017. Has anybody else encountered this behaviour and found some workaround for this? Find attached the sample data together with a snipped of the workspace and the exported KML filesThanks in advance to everybody who can help me!

7 years ago

helmoet

asked in Data

Directory and path reader does not support nul

Hi, I came across the following issue: using a directory and path reader (filtering for files only) and supplying an empty folder works fine (it doesn't produce any files, but that's just fine). However, say I want to skip any processing from this reader, as an innocent user I supply the Windows nul: device. Now my workspace crashes, how is that? Of course, there are a lot of ways around this problem, but wouldn't it be nice if the directory and path reader behaves in the same way like, say, the Windows dir command?

319

7 years ago

f.kemminjeContributor

asked in Data

how to create line string from json point array

Deleting the template sheets after writing Excel file with a template file

Hello everybody,I want to create an Excel file with the FeatureWriter. To get the output well formatted I created a new file before that all as a template file. Well, the FeatureWriter does something I don't want to have. It creates a copy of the template file and creates a new sheet in this copy with the output.. This sheet is exactly that what I want to have but the additional sheets of the copy are disturbing. Is it possible to remove the sheets of the template and just keep the sheet which contains the output?Best regards,Felix

Can you send a link toTutorial: KML Transformations

I'm an entry level FME user and I'm struggling trying to transform a file geodatabase to kml. The feature class consists of 67k culvert line features with 38 attributes. Both FME and ArcGIS seem to generate the kml but Google Earth encounter an error whey trying to open it. I thought the tutorial could help me discover what I need to do to fix this.

155

7 years ago

Anonymous

asked in Data

Read and Write Geometry in Oracle Spatial Database

Can FME read and write features that are in ESRI's SDE.ST_GEOMETRY in an Oracle Spatial database? I have a table that is in ST_GEOMETRY, but the Oracle Spatial reader cannot show it because there is no entry in the user_sdo_geom_metadata table. I don't see an ESRI reader that would be able to read from Oracle. Likewise, when I try to write from a file geodatabase that is in ST_GEOMETRY, FME converts the geometry to SDO_GEOMETRY.Thanks

Write automatically to a subdirectory of the source data

Hello, I have to read sources that have the same structure in n paths all structured in the same way that I therefore designate to read by ..... dep \\ com ??? \\ shape \\ parcel.shp. ??? Is 001, 002, 003, etc ... No problem for reading. However, I would like the destinations to be written each time in a subdirectory (example: ..... dep \\ com ??? \\ shape \\ l93 \\ parcel.shp. Can you help me ? Thank you.

254

7 years ago

danilo_fmeEvangelist

asked in Data

Insert color in Attribute Names in XLS

Hello FME Users,I need to put the color in Attributes Names in my XLS file. I saw the configuration in Output XLS, but it change the color all my columm:The Line 1 is the Attribute Name The Line 2 is the Value.Thanks

284

7 years ago

pchengContributor

asked in Data

Excel Exact Position Placement

Hey Safers,I was wondering if it was possible to position an attribute to an exact row/column position!Using the image below as an example I want to designate an attribute 'LICENSE' to the cell indicated by the red arrow, let's say its at G-5Is there a formula I could use? The spreadsheet can't reference a raw data table as its a fan out of many pipelines in one workbook (a,b,c,d)Thanks,Patrick

The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {FDO error: -2147216072}

Hi All,I am facing an issue while translating data from Oracle Spatial to ESRI Geodatabase. while translating the data using FME workbench getting error message "Unable to drop the table/feature class 'GD_EXPANSION_JOINT_point'. The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {FDO error: -2147216072}". i did google search for this FDO error number but did not find anything. Could anyone help me out in this error.Thanks in advance.Thanks & Regards,Ravi Kumar

16179

7 years ago

pschoutParticipant

asked in Data

read dat from $(FME_SHAREDRESOURCE_DATA)

Is it possible to read data from $(FME_SHAREDRESOURCE_DATA) with the feature reader? In a workspace i write excel datasets to $(FME_SHAREDRESOURCE_DATA), I want to read these because they contains attributes which i need to dicede to send a mail (or not) with another job.(The full path to the data is : $(FME_SHAREDRESOURCE_DATA)/Informatie_Management/Vaarwegmeldingen/Meldingen_borden.xls)I use FME server 2015

Sending Count over Total of files written by FeatureWriter as the are emitted?

I currently have a custom Transformer that gets a parameter MaxTileCount (the value of _num_tiles) from a WebMapTiler and it counts the number of features and sends a HTTP message every 10 messages to show progress.That is all working fine.However, now I have issue. The PNGwriter is no longer a PNGRaster writer, but has changed to a FeatureWriter that does a fanout. Well that takes a lot of time, So I want to move the Notifier to later in the pipe, after the "pngWriter (FeatureWriter). The issue I have is that I don't know how to count anymore the number of files written by the FeatureWriter as they are emitted, nor do I have access to _num_tiles which is the total number of tiles coming from the WebMapTiler.In simple words, I want to send a HTTPPost message with count/total as the files are written by the FeatureWriter any idea who to do this?The second notifier fails. So I disabled it.

427

7 years ago

jordiewParticipant

asked in Data

Excel writer creating XML errors

I'm using FME Desktop 2017.0.1.1. I have a csv file that I need to merge with 6 different csv files. The 6 different csv files are derived from MapInfo table that Intersects with another table and the selection is exported as a csv. I have AttributeManager, AttributeCreater, DateFormater and FeatureMerger for each csv. These csv files are FeatureMerger with another csv and the writer is a 6 sheet excel workbook. When "Translation was SUCCESSFUL with 0 warning(s) (81575 feature(s) output" the excel xlsx file contains errors: "Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Unexpected end of input. Line 1, column 1614248. Replaced Part: /xl/worksheets/sheet1.xml part with XML error. Unexpected end of input. Line 1, column 1614250. Replaced Part: /xl/worksheets/sheet2.xml part with XML error. Unexpected end of input. Line 1, column 1614250. Replaced Part: /xl/worksheets/sheet3.xml part with XML error. Unexpected end of input. Line 1, column 1614250. Replaced Part: /

Hi, I'm trying to insert block in a DWG file with a specified rotation. If I use feature and replace them with a block they all appear with the wrong rotation. Here I set the rotation at 0 for all of these :

574

7 years ago

takashiContributor

asked in Data

Restriction on Deleting Questions

I noticed that some users delete their questions, even though answers helpful to other users have been posted. I think it would be better if there were a restriction that a question having answers cannot be deleted unconditionally.

7 years ago

rob14

asked in Data

Generate list of all unique characters contained in (huge free text) field.

Hi,Can anyone provide some advice as to the most efficient way to explode a huge free text field or fields into all of its character elements retain a single instance of each. I am essentially trying to complete a pre-flight check in order to understand whether there are any ‘odd’ or ‘unexpected’ characters in an ever expanding data set, over which I have no control. I have created a process below which completes the task; however, it is very inefficient and as the number of records increases it will become too slow. 1. Derive string length of free text field 2. clone by number derived in 1 (clone number created in process) 3. substring extract using clone number to obtain character at that position 4. Duplicate remover to create my list. 5. Expose character code. 6. Output listThanks in advance,Rob

765

7 years ago

donatsafeParticipant

asked in Data

if I have a dynamic url (like `https://www.donneesquebec.ca/recherche/dataset/a8a678b0-875f-4607-b347-009a5096ff45/resource/fad04899-abd8-4d3f-a841-4f8b11edac57/download/a01convertxmlcorpomun.xml` could FME parse that xml and export it into PG

7 years ago

jbradforContributor

asked in Data

Oracle 12c - Bad Packet Error Resolution

While converting from Oracle 11g to 12c, we executed a simple Oracle Non Spatial Workspace that moved 4 million rows from a CSV file to an Oracle table on 12c. It consistently threw the ORA-12592: TNS:bad packet error after running for 30-40 seconds.We ran the same workspace against 11g and it worked fine.After researching the issue we ended up modifying the Oracle 12c Server SQLNET.ora file by adding this parm:SQLNET.SEND_TIMEOUT=600Modifying the client side SQLBET.ORA did not resolve the issue. Modifying the server side SQLNET.ORA file did.

DXF Overwrite color from Block-definition

is it able to Change a Color from a Block-Definition, so that a Symbol gets a other color as defined in the Block-Definition.I want to change the green Symbol from Blockdefinition to overwrite in blue Color

FME support for OGC Geopackage extension http://www.geopackage.org/spec/#extension_geometry_types

7 years ago

greenroze

asked in Data

DXF written through FME can not open proper in ArcGIS

Hello people, i splitted one DXF-File into 4 separeted DXF-Files. One of them i tried to open in ArcGIS, but can not see the features there. Somehow DXF-Files, which were written through FME, could be read only in FME Viewer, but not in ArcGIS. Do you have any ideas, how can i fix it? I tried already all possible format of DXF in FME to write, but still does not work. (the main DXF-File can be open and the features could be seen in ArcGIS as well)

7 years ago

Page 195 / 272

Badge winners

wouterdusardohas earned the badge Teacher (Grey)
wouterdusardohas earned the badge Conversationalist
cnorthhas earned the badge Welcome Back
maadh.mamarihas earned the badge Teacher (Grey)
dietervdshas earned the badge Integrate Data with the FME Platform Training

Show all badges

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