- - 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

AutoCAD .dwg layers to match with template

Hi all,I have dwg file exported from 12d Model. I need to match layers from exported file with template layers that we use.For example exported layer named X-SURVEYFENCE is a polyline and it has defined style, colour and line weight. It has to be renamed to layer Z-FENCE with settings, that are already predefined in template (eg. surveydata.dwt).If you have any experience in cad-cad transformation please assist me in resolving this issue.Regards,Maksym

Hello. Is it possible to change the name of the logfile a workbench writes by using a workbench in batchmode?Regards Eduard

KML Time function please give an example for raster data

my email is hosain.moh00@gmail.com

7 years ago

fmelizardContributor

asked in Data

Using an updated version of my Excel File in a workspace doesn't produce results

I have a workspace with an Excel Reader and I want to change it to read a new version of the file. I can run the workspace with the new file and features are read in, but the resulting output contains blank values. How can I fix this?

7 years ago

bgerlach

asked in Data

Probelms with output Oracle to dgn V8 with object with two polygon geometries

We are using FME Workbench 2016. Reading a table with land parcels in Oracle Spatial and want to create a dgn V8 with them, the single polygons look right. Also the objects with two polygons where one is defined as hole are correct in the dgn. But the land parcels which where split in two objects by a road for example are divided into two different objects. How can I force the writer to create a single object with two polygons from one object in the database? The "features written" summary shows 20 objects written (database count, correct). Microstation tells me there are 24 elements on this level, because 4 obejcts are now split int two different polygon.

7 years ago

geospatiallover

asked in Data

Creating an ESRI Feature Layer using Python

I wonder if anyone has used the Python Caller transformer to create an ESRI feature layer using ArcPY or ArcRest to publish the feature layer in AGOL, Portal or ArcGIS server. I'd be interested to work together with anyone who has a use case for this. With Portal or AGOL writer I could create a feature service but I want my service to be rendered with the appropriate layer properties so all the user need to do is add the feature layer on a web map in Portal or AGOL. An appropriate SD file created from an MXD or lyr file would be necessary to store the layer properties.Per FME documentation: AGOL writer layer creation is not supported.

550

7 years ago

redgeographicsCelebrity

asked in Data

MySQL date/time field

Hi,I'm writing data to a MySQL (non-spatial) database and have some problems getting datetime fields filled. Checking a sample table in phpMyAdmin shows the date format to be ^Y-^m-^d ^H:^M:^S, e.g. 2017-02-28 13:09:00, so I've set up my TimeStamper to output that. But when I write to the database it fails every feature with a message saying it's an invalid format.If I enter the same value directly through phpMyAdmin it's accepted.Any idea what I'm doing wrong?

315

7 years ago

poncetaContributor

asked in Data

Bulk / auto connecting Reader to writer

Hi,Is it possible to autoconnect or bulk connect readers to writers?I could choose "copy from reader" option for attributes but I would be happy if I haven't to link my 139 tables by hand!If you have a trick to easy lowercase all schema and table names it would be be so great!

2580

7 years ago

jeroenContributor

asked in Data

Replace line with block reference

I am working on a dwg drawing containing all the traffic lines in a city and markings that are on the roads. There is a layer for each type of line or objects (Stop and yield markings for example). The problem with the DWG is that the lines are just drawn with a polyline and contain a custom linetype that gives it the look of shark's teeth but in fact are not single object. The end result should visually be the same but instead of a polyline all teeth's should be block references. I use an free autocad pluguin mea+ to replace these lines with block references but this is quite a time consuming job in autocad.Command: mea+Measure with Points/Blocks/Lines/Selection ? <P>: bBlock to insert to Measure path: blok_5010Scale for Blocks, or Graphic for symbol scaled to drawing <1>: 1Blocks rotation, or Aligned with path or Relative angle to path [angle/A/R] <A>:Layer for Blocks, or Current, or Same as selected path <Current>: BLOK_5010Enter length of segment: 1Standard

@username links not always working in forum posts

Hi, can you have a look at this forum-related issue and see if there's anything to be done?https://knowledge.safe.com/questions/40222/why.htmlThree issues:@username not always clickable@xxx does not always produce a dropboxTyping @ sometimes marks the text as a heading rather than inserting "@"

7 years ago

robertdbuckley

asked in Data

Can I use FME to combine 2 las files classifying las_01 as ground and las_02 as surface?

I have been given 2 las files. One for ground points, and one for Surface points. I would like to combine the files into one in order to utilize the lidar classes for presentation purposes.

810

7 years ago

danilo_fmeEvangelist

asked in Data

Get a screenshot from Web

Hello Team,I`m try to take a screenshot from a Webpage with FME, but i didn`t find a transformer that make this.The website: http://www.ipmet.unesp.br/index2.php?menu_esq1=&abre;=tempo/boletimdotempo.htmlScreen that i want:Thanks in Advance,

730

7 years ago

lifalin2016Contributor

asked in Data

Support for other packages formats than ZIP ?

Hi,Does FME support direct reading from other package formats apart from ZIP ?Cheers

110

7 years ago

ngoormanContributor

asked in Data

Reading WFS fails in FME 2016, works in FME 2015

Hi all,I have a workspace that uses a FeatureReader to pull data from a WFS. This works perfectly well in FME 2015.1 32-bit (build 15575). However, in FME 2016.1 32-bit (build 16609), the same FeatureReader fails with the following message:2017-02-24 11:32:16| 3.3| 0.0|ERROR |<ows:ExceptionReport xmlns:xs="http://www.w3.org/2001/XMLSchema=" xmlns:ows="http://www.opengis.net/ows/1.1=" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance=" version="2.0.0=" xsi:schemaLocation="http://www.opengis.net/ows/1.1 http://geodata.nationaalgeoregister.nl/schemas/ows/1.1.0/owsAll.xsd="> <ows:Exception exceptionCode="NoApplicableCode="> <ows:ExceptionText>org.eclipse.emf.common.util.BasicEList$BasicIndexOutOfBoundsException: index=0, size=0index=0, size=0</ows:ExceptionText> </ows:Exception></ows:ExceptionReport>2017-02-24 11:32:16| 3.3| 0.0|ERROR |Received error report: ExceptionReport2017-02-24 11:32:16| 3.3| 0.0|ERROR |The XML Module halted on err

7 years ago

fransknibbe

asked in Data

IfcSpace to 3D geometry in PostGIS

Hello,I am trying out how IfcSpace elements in Building Information Models can be transformed to 3D geometry in PostGIS. I have made a simple building model in Revit in which a few spaces are defined. The model is exported to an IFC file. When I open the IFC file in an IFC viewer (Solibri) I see the spaces and they can be drawn on screen as 3D geometries. So somehow it is possible to derive 3D geometries from the IFC file. However, if I do a (default) translation from the IFC file to PostGIS, I see no geometry for the spaces being created. All space have the same geometry value (in WKT): GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(GEOMETRYCOLLECTION EMPTY)).Is it possible to transform IfcSpaces to 3D geometries or even 2D geometries in FME?

How can a Reader starts after Writer is finish

I have a question. I make a Projekt in FME Desktop and I want that a one of the Datareaders starts after a writer has finished his work. Is this possible? I need this, because the writer updated a table from the Reader

1210

7 years ago

annette2Contributor

asked in Data

FeatureReader with Oracle Spatial Object - can't specify geometry

Hi,I am trying to query 40 Oracle Spatial tables within a bounding area using the FeatureReader where each table has multiple geometries but not all geometries have spatial indexes. Unfortunately only the geometries I am going to query have the indexes so I can't use the multiple geometries option. Adding the additional indexes is a lot of work for the complete electric and gas databases.It seems that with the FeatureReader transformer you cannot use Oracle Spatial Object and also specify the geometry column. Is this still correct or have I missed something? I'm using version 2015.0 as our FME Server is 2015.0 but I've also checked in version 2016.I see this post in 2013 but this is a lot of work as I have 40 tables with multiple geometries and I need information such as the oracle_orientation. I think I will have to resort to the WorkspaceRunner and somehow pass the AOI geometry into the second workspace as described here.Thanks,Annette

340

7 years ago

lifalin2016Contributor

asked in Data

Reading generic XML with variable content ?

Hi,How can I best accomplish reading a generic (any) XML file without specifying any initial root tags etc. ?I.e. return the whole XML document as a single fragment.Do I need to create some special XRS or xfMap templates, or can it be accomplished with the simpler Feature Paths ?Cheers

7 years ago

jeandenis

asked in Data

Insert function as value to Postgresql instead of SQLExecutor

Greetings!I would like to set an attribute of my feature as the value returned by a pl/pgsql function. Currently, I use the SQLExecutor for every feature. It's much slower than using the pl/pgsql function in the INSERT.The expected result would be that FME produce the following insert statement.INSERT INTO my_table VALUES (17, 'abc', MY_FUNCTION(17));I'm using fme build 16716 with postgreql version 9.5.Kind regards,Jean-Denis

How to insert into multiple table and manage key relationship?

Hello,I have a non spatial data set in Excel format.For each row i have to split the data into two tables.First I need to enter some of the attributes in the "Property" table and then into "Contact" table."Contact" table contains the primary key of Property in "PropertyId" column as Foreign key.To insert the data successfully I need to have the id of the row inserted in Property Table and the store it in the Contact table.Is there a way to achieve this functionality with FME Desktop?Thank in advance.

Error &-character when reading kml-file

Hello all,Last year i posted a question here on reading a descripton of a kml-file. This is a new question with the same background: reading a kml-file that contains data from an app (BuitenBeter) that people can use to inform the city about all kinds of things in public space. Some of these kml-files, like the one attached, have a &-character in the kml-description that results in an error: XML Parser error: 'Error in input dataset:'file...MOR 020816-140816.kml' line:1 column:58047 message:expected entity name for reference'. The script continues with the next file, but this file is now only partially read. I get the same (kind of) error when using the XML and KML reader and using FME versions 2014 en 2016. The error refers to a &-character that can be found in some descriptions. Till now i replaced this &-character manually, but now i'm working on a automatic script for which it is important to get a 'real' solution to this problem.So, does an

Hello,I execute query on my postgresdb to get result as a json: description is here http://rextester.com/ZULI42144It looks nice but now I would like to convert it to xml. I decided to use fme to query postgres just like in example and now I have noe idea how to convert the result to xml and write it to file.Also talking about json which I also need (I need result in JSON and XML format) what I achieved is that I simply executed postgres query end then wrote results using simple text writer so I suppose that fme doesnt really know that the query result is a JSON :)Structure and content of the database is as described here:http://rextester.com/ZULI42144and there is sql that is used in below sqlExecutorThis is prototype of my workspace that I have right now and the question is how to format nice xml from this list exploder (if its possible).And here is output of the logs. Of course in the result xml I would like to have structure ike <person>...<car>...<wheel>...</whe

1908

7 years ago

raimondContributor

asked in Data

ORA-12592 and ORA-03135

The translation is running and writing records to Oracle. But suddenly i get an Oracle error ORA-12592 or ORA-03135 and the translation stops.The database is online.What can cause this problem.

150

7 years ago

sigtillContributor

asked in Data

RECORD streaming KMZ-file

You can use FME Server to stream a KMZ-file to a Google Earth instance. However, can you also do the reverse? Ie get FME Desktop or FME Server to Record data from a KMZ-file-stream?

7 years ago

robyn_studts

asked in Data

Draw lines between points

I have an object that has that has two Point styles. I can translate point styles into cells in Microstation but I would like to generate a line that will go between the two cells. To be honest I am not sure where to even start. Any help would be appriciated

3650

7 years ago

Page 206 / 274

Badge winners

deepakkumar7250has earned the badge Student (Grey)
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

Show all badges

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