Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 7,087 Posts
  • 26,094 Replies
7087 Posts
D
debashish
asked in Data
FME is giving error while importing data into SmallWorld from shape files.

The error says "SmallworldWriter Error: Object unset does not understand message field()with arguments: :fme_feature_type".Steps I have followed:-1- Opening a smallworld image.2- Making the alternative writable.3- TICS server was running on 30000 port.4- Mapped the reader to shape files, the writer configuration was given as local host & 30000 port. But the object & attributes got mapped to the writer directly from reader.It's easier to export data from smallworld, because the reader identifies the dataset & lists the objects. I am not sure about the the writer though.I am new to FME, please help me.

390
erik_jan
Contributor
M
murray901
asked in Data
Shape column is not showing from oracle spatial table in both reader and writer

HiI am trying to transfer data from Oracle sde database from one server to other with same environment. But when i add reader and writer these get other columns but miss shape column.Please experts guide me.

580
erik_jan
Contributor
ponceta
Contributor
poncetaContributor
asked in Data
Is it possible to write 3D Geometries with the PostGIS Writer on newer versions of FME?

Hi!We're stuck on a 3D geom linestringz import into a postgis 2.0 database. Seems not possible on FME 2014, right?Is it possible on newer versions?Working around with sql executer.

140
ponceta
Contributor
K
khk
asked in Data
copy external files based on result names

Hi, I want to copy files based on workspace result values. Example: a, b, c builders are applied for tenders of xyz road construction. All 3 companies tenders are integrated into one document and named as xyz road (its same as fme workspace result road names)so when fme workspace result record contains xyz road, then pickup "xyz road" excel/pdf tender files and copy them into a specified folder path (or create new folder and copy files). Any guidance on how to check the result road names with external files present in a directory (Lookup tables?)? is it possible in an easy way to automate it ? How can i compare result and copy respective files into a specified folder. Any guidance is helpful.Thanks,khk

226
K
L
lucmegens
asked in Data
How can I convert a gml attribute in xml read with feature paths to geometry

I have an xml with feature bag_LVC:Pand with this structure (example): <bag_LVC:Pand>  <bag_LVC:identificatie>0003100000117485</bag_LVC:identificatie>  <bag_LVC:aanduidingRecordInactief>N</bag_LVC:aanduidingRecordInactief>  <bag_LVC:aanduidingRecordCorrectie>0</bag_LVC:aanduidingRecordCorrectie>  <bag_LVC:officieel>N</bag_LVC:officieel>  <bag_LVC:pandGeometrie>  <gml:Polygon srsName="urn:ogc:def:crs:EPSG::28992">  <gml:exterior>  <gml:LinearRing>  <gml:posList srsDimension="3" count="17">254059.737 593504.637 0.0 254059.227 593500.0 0.0 254059.216 593499.899 0.0 254058.242 593500.0 0.0 254057.914 593500.034 0.0 254057.893 593500.0 0.0 254057.807 593499.863 0.0 254052.074 593490.692 0.0 254052.182 593490.639 0.0 254058.138 593490.002 0.0 254057.932 593488.165 0.0 254074.487 593486.413 0.0 254075.981 593500.0 0.0 254076.265 593502.583 0.0 254076.561 593502.55 0.0 254

330
erik_jan
Contributor
J
jtalero71
asked in Data
Synchronizing GIS and CAD (DGN) with FME -- can it be done?

I am a newcomer to using FME products. I have been reading several documents relating to my question. However, I would like to have an answer directly from your staff.We are a two shop software (Bentley Product) MS – used by our designer. GIS – used as an asset management tool.At this time we are also maintaining our assets data in MS as well as in GIS. The purpose for this practice is that our designers are able to consume the historical data while designing a project from our MS asset registry data repository. This process is becoming a lot more Painstaking an enormous amount of work for our MS and GIS staff as well as major duplication of effort. My goal is to be able to maintain one assets data repository (GIS) and have our designer consume this data in the MS environment thru a conversation/extract tool from GIS to DGN. At the same time, thru transformation, be able to maintain and display the feature Standard developed by our designing staff with the collaboration of Bentl

90
C
W
wlkt106
asked in Data
??????KML?2D???3D???????????

??FME???2D?shape?????????????KML?3D??????????????1.??2d?KML?????????????????cad???cad??????? 2.????????KML????????????????? 3.??????3dForce?KMLpropertySetter??????3dKML???????????????KML?????2d???????   ??????????????????????????   ????????????????????????cad????????????????fme????????? https://knowledge.safe.com/articles/18762/basic-3d-kml.html

60
W
M
mercedes
asked in Data
How can I Force Upper Case attribute names when writing to Oracle DB in FME 2016?

I try to follow this instructions https://knowledge.safe.com/content/kbentry/109/forcing-upper-case-attribute-names-when-writing-to.html but it seems that it is for FME 2015 and the metafiles are different.

150
M
J
jamiefinney
asked in Data
change input data (same file structure)

Hi i've only just started using FME (2016) so this is likely a very simple problem. i've created a workspace that takes a series of MI tab files, and re-maps some attributes to a writer. it works fine. now that its finished i want to run the same tool again with different data (same structures). what is the best way of doing this?i've tried right clicking on the reader > edit 'NAME [MAPINFO]' parameters and changing the data there and that doesn't seem to work when i run the tool. nether does reader menu > update feature types.Data_1 Col_A Col_C Data_2 Col_C Col_B Data_3 Col_B Col_A  Output Col_A Col_B Col_C

70
takashi
Celebrity
J
jphillip
asked in Data
Shape (latitude and longitude) identification

Converting a shape file to a MySql table and all is working with the extraction of each attributes except i can not identify the latitude and longitude values that represent the point geometry. Can any one help me with how I identify and split out the coordinates in a shape file. thanks

120
takashi
Celebrity
A
anshulmantri25
asked in Data
ESRI personel Geodatabase(mdb) file to ArcSDE

hi,I am working on CAD to geodatabase: for which I will have .mdb(esri pgdb) as output, can I check how do I create a modal to push this mdb file into ArcSde, such that every time I run this modal it will append the new data. This will help me convert the data for different areas and migrate them in ARCSDE.Appreciate your suggestion ThanksAnshul

80
A
D
dewan
asked in Data
Read and Split XML

Hi,Although, I have worked with transformers but I am fully new to XMLs.I have an XML input file, but, unlike other XMLs, when I open this xml in notepad++, its as good as a text file only. Its not parsed ad segmented. Although, I tried some transformers, but didn't work. Once these XMLs are written, I would like to split it in 50 attributes in each file. Anyone with the solution !!

1760
deanatsafe
Safer
franco69
Contributor
franco69Contributor
asked in Data
excel sheet writer

How can i manipulate a Excel spreadsheet when i want to write exactly 500 features each sheet?GreetzFranco

210
franco69
Contributor
mapper
Contributor
mapperContributor
asked in Data
sde30 reader available but writer greyed out?

I have access to the sde30 reader but it is greyed out in the list of availible writers. I found this article https://knowledge.safe.com/articles/358/arcsde-lib...but I don't understand why the reader is available but not the writer, seems like the reader would need the sdk and dlls as well as the writer.

170
mark2atsafe
Safer
C
ccoleman
asked in Data
Automate workspace deployment with FME Server

As a developer I want to automate the deployment of fme workspaces So that I can deploy fme code alongside the rest of my solution  Given that I have one or more fmw files that have been developed using FME desktop as part of a wider solution When I run my silent install/automated deployment Then there is an FME server workspace for each source fmw file and the workspaces are in the correct target repositories and these are available to the solution through the rest api  On install, the default workspaces of fme server 2014 SP3 are installed using a script (configureDemoWorkspaces.bat) that calls out to java and a class (WorkspaceServiceInstaller) which uses an xml file (serviceWorkspaces.defs) to control which services to create - Is the WorkspaceServiceInstaller java class documented anywhere?

160
jpvo
Contributor
A
adik
asked in Data
Oracle Spatial Object to GML problem with 2 geometry

Hi,I have Oracle table with 2 geometry in 2 columns (B_ETYKIETA_GEOMETRIA, B_ETYKIETA_ODNOSNIK). I need to transform it to GML with geometry columns (geometriaKarto, odnosnik) but in my process FME chosen only one geometry table B_ETYKIETA_GEOMETRIA. How can I choose and transform geometry from B_ETYKIETA_GEOMERIA to geometriaKarto and B_ETYKIETA_ODNOSNIK to odnosnik?

90
erik_jan
Contributor
bubblebeb
Contributor
bubblebebContributor
asked in Data
What versions of PostGIS / Postgres does FME desktop support?

I am trying to write to several PostGIS databases. I can write to the version 9.3 with no trouble but cant to 9.4 or 9.5. I am trying to rule out incompatibility between FME and Postgis before I reinstall the PostGIS databases.

250
fmelizard
Safer
L
longhornfan
asked in Data
How to determine my FME Server email address

I'm still pretty new at FME Server. How do you determine the FME Server email address to send email data to with attachments? I'm at a loss to figure that out.

400
david_r
Celebrity
S
sbaktzg
asked in Data
Shape writer creates shape_polygonzm by default

Hi,  I would like to use the ESRI Shape Writer in the dynamic mode. It works but it writes the shapefile by default with shape_polygon z and m.   I tried to change the settings in the configure dynamic schema parameters to 1. fixed Shape_polygon --> same result 2. First feature defines geometry Type (the geometry type is 2D) --> same result    Roger mentioned the same issue the 22. January: http://fmepedia.safe.com/CommunityAnswers?id=906a0000000cuXjAAI  I use FME(R) 2014 SP2 (20140528 - Build 14336 - WIN32)  Any idea?

60
juanmahere
Supporter
B
bishoyghft
asked in Data
FME automatically replaces the xlink.href statement with the original reference in GML.

I have a simple GML file with one building in it. When i run the file in FME to simply write it again without any operation somehting very strange happens. FME replaces the xlink.href statements in the data with the original data form the reference which already includes a gml:id and that duplicates the IDs in the file. for example:Original data:<gml:MultiSurface> <gml:surfaceMember xlink:href="#p_r_2"></gml:surfaceMember> </gml:MultiSurface>.........<gml:Polygon gml:id="p_r_2">  <gml:exterior>    <gml:LinearRing> <gml:posList>2.00 0.00 3.00 2.00 2.00 3.00 1.00 2.00 3.50</gml:posList>    </gml:LinearRing>  </gml:exterior></gml:Polygon>Will become this:<gml:MultiSurface>    <gml:surfaceMember> <gml:Polygon gml:id="p_r_2">   <gml:exterior>     <gml:LinearRing> <gml:posList>2.00 0.00 3.00 2.00 2.00 3.00 1.00 2.00 3.50</gml:posList>     </gml:LinearRing>   </gml:exte

420
B
M
markschuring
asked in Data
When converting DWG to DGN, rotation cells is wrong, solution?

HelloI want to convert a DWG file to DGN. A celllibrary is attached and a correct seedfile. All lines and texts are converted correctly and the unrotated blocks are converted to the right cell as well. The rotated blocks are converted to cells and rotated in the DGN but the rotation totally wrong. I cannot see what the problem is. Units, Settings, I really don't know. Does someone have a solution? Thx for reading and/or answering!Mark

210
erik_jan
Contributor
M
mariselvam
asked in Data
How to convert 3ds file to citygml?

I have .3ds file, I want to convert in to that file into citygml file.If possible please share workspace

250
M
sunsilk11
Contributor
sunsilk11Contributor
asked in Data
merge multiple file geodatabase tables

Hi I have a large number of file geodatabases with one feature class in each.I would like to merge all the feature classes and save in one single file geodatabase.Any suggestions what's the best way to achieve this?

2290
erik_jan
Contributor
A
anete
asked in Data
How can I extract CityGML feature type ids.

Hi folks,I have a CityGML file with many buildings. These buildings have buildingParts with unique gml_ids. I need to access these buildingPart ids in an automatic way, so later I can use them as gml_parent_ids. Can somebody please suggest me a way how to automatically extract gml_id from CityGML feature type. Please and thanks!

100
davideagle
Contributor
K
kmeinert
asked in Data
XML Newbie - Help!

I don't deal with writing XML very often (ever, really), so I'm struggling to do something and of course they need it yesterday. The vendor needs an export from my Esri database in XML format and I think the only thing I am missing is that my XML file (using the XML Writer) is writing "elements" instead of "attributes", so they say they can't import it. I can't for the life of me figure out what I need to do to achieve this without going down a very deep hole and learning XML in the next five minutes... Is there a setting I'm not understanding, or is it really that complicated? I don't need geometry, they just want to fill a table with my data.

177
K

Badge Winners

  • Student (Bronze)
    marionmahothas earned the badge Student (Bronze)
  • FME Form Basic Training
    dezuviriamhas earned the badge FME Form Basic Training
  • Welcome Back
    dwade10has earned the badge Welcome Back
  • Integrate Data with the FME Platform Training
    johnrochehas earned the badge Integrate Data with the FME Platform Training
  • Student (Grey)
    westerbrinkhas earned the badge Student (Grey)
Show all badges

Community Stats

31,800
Posts
120,793
Replies
39,417
Members

Latest FME

Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.