Skip to main content
  • EN

Data

Using readers and writers to extract and load data.

  • 7,090 Posts
  • 26,100 Replies
7090 Posts
M
mcv
asked in Data
Positional improvement - points and improved large scale

Hi all  I have large scale data and a copy of the same data that has been positionally improved.  I have the Point data associated with the original large scale data and would like to apply the point data to the positionally improved data so that the points remain within their polygons (ensuring that the improvement shift does not leave a point outside its original polygon).  With FME capable of all tasks, has anyone any ideas how I can use it to do this?  Much appreciated Colm

70
M
P
peterbaldwin
asked in Data
Writing to File Geodatabase without geometry type in name

Hello,  I've setup a workbench that has a generic reader writing to a file geodatabase with dynamic properties. In the output it keeps appending the geometry type to the feature class name e.g. xxxx_polygon. Can I stop it from doing this?  In the dynamic properties section if I set the schema source to the generic reader then I get this issue but if I set the schema source to a SDE reader for example then it doesn't put the feature type on the end.  I've tried editing the fme_basename and fme_feature_type properties to force the name to be the value of a user parameter but it still appends the geometry type without me asking it to.  Thanks,  Peter.

950
fmelizard
Safer
davideagle
Contributor
davideagleContributor
asked in Data
FME Store Access

Does anyone know (or can test) if when you only have access to the ESRI Data Interoperability Extension license...assuming you have ArcGIS 10.1, which gives you FME 2012 under the bonnet... can you access FME Store components like custom transformers? This is possible IF you have the ESRI Edition of FME Desktop if you extend ESRI, but I'm wondering if you can see the store or install downloaded FMX files if you have only bought the Data Interoperability Extension direct from ESRI?  Cheers, Dave

100
fmelizard
Safer
G
gerardo
asked in Data
writing metadata

Hi everybody.  I have checked the tutorials on how to write metadata  but am troubled. it seems like FME includes extra xml tags causing ArcCatalog  not to recognize the metadata. I have included the tags in the text below.  What am I doing wrong? any pointers?   -<fme:xml-tables xsi:schemaLocation="http://www.safe.com/xml/xmltables signs.xsd" > -<fme:NewFeatureType-table> -<fme:NewFeatureType>  <fme:geodb_metadata_string>  METADATA GOES HERE   </fme:NewFeatureType>  </fme:NewFeatureType-table>  </fme:xml-tables>

240
G
A
abe
asked in Data
Reader which is not listed among the formats

Can someone point me to know where I can find this reader format:  "geocode [FILEGDB]"  It is a reader that cannot be edited in an existing workspace.  When I try to recreate the same transformation in a new blank workspace...Im unable to find that reader format.  The reader should be reading a geodatabase file (but we are trying to not have to use ArcGis to consome the file).  Any advice or assistance would be appreciated.  -abe

50
david_r
Celebrity
paula
Contributor
paulaContributor
asked in Data
csv to xls

Hello everybody,  how can I convert a csv-file into a xls-file? How can I declare the delimiter?  Thanx

300
paula
Contributor
W
whatahitson
asked in Data
Can I copy the schema of an existing feature class

Hi,  I'm migrating data into a file geodatabase in which I currently have one feature class that is in my standard format. I want the data im mnigrating to this geodatabase to be stored in a number of feature classes with identical schema. Is there a way to either copy the feature class and change its name and contants each time, or copy its schema?  Thanks,  Chris

970
david_r
Celebrity
B
ben458
asked in Data
DXF 3D polyline as Polyline

Hello I have converted a shp file to dxf.  However, the dxf is natively a 3D polyline and i need it to simply be a polyline.  Is there a way of changing the writer to be a polyline?  I dont know of the difference apart from the 3D line may have a z value(?)  Many thanks Ben

120
fmelizard
Safer
W
whatahitson
asked in Data
load data into an existing feature class

Hi,  I'm trying do a simple task involving moving some data from one geodatabase to another, matching up the attributes that I want to keep. Ive selected a file geodatabase as the "writer" but I cannot find a way to specify the feature class that I want to add too so that FME can populate the fields. How can I input into a specific featureclass, rather than create one.  Thanks,  Chris

2660
fmelizard
Safer
mapnut
Contributor
mapnutContributor
asked in Data
Writing an empty Feature Class

Hi All,  I have a similar problem to one that was asked here at the end of last year...  I have the need to get FME to truncate all of the writers in a workbench regardless of the number of features being written to them.  Setting the properties of each Feature Type works perfectly except if there are NO features being passed to the writer...  I also have users out there with MXDs which reference all 18 of these SDE feature classes, so deleting them before (or as) the workbench starts is not an option - it has to be a truncate.  I have a Python guru looking at it at the moment, but it would be nice if someone on here has had a similar experience and can offer an alternate solution to cutting code.

490
fmelizard
Safer
A
adamp
asked in Data
Different size text from the same layer

I am importing Smallworld data and outputting DWG files. The strange issue I am running into is that the road name text for horizontal roads displays at a larger text height that the road name text for roads running North and South. All of the road labeling text is on the same layer as well. If there is other information you need me to provide please let me know. I am very new to FME.  Thanks Adam

100
A
owen
owen
asked in Data
order of fgdb fields

When creating a new file geodatabase feature class from an existing schema, native fields such as SHAPE_Length are appended to the end of the table, ie the last column.  Since it is possible to add new fields in arc, but not reorder them permanently, I am struggling to work out how to replicate a schema exactly where these fields are not at the end.  Any ideas?

130
owen
J
johan_lw
asked in Data
ArcSDE to SQLite

Hi! I have a problem with a transformation from an ArcSDE-database to a SQLite-database. When I go from the ArcSDE-database to shapefiles it is about 10 times faster compared  to if I go to the SQLite-database.  I have WRITER MODE: INSERT and I want to overwrite the database.   I am using FME2013 Esri edition.

100
david_r
Celebrity
jelle
Contributor
jelleContributor
asked in Data
Pass DGN list from WorkspeceRunner

Hi All,   I created a Workbench reading a set of DGN Files, set with a publisehd parameter. The parameter was created by right-clicking on the input field for the DGN files. For some reason, it has no type, and I can't pick another one. So far, so good.  I try to run this Workbench within a WorkspaceRunner, where I concatenate the filepaths, separated by a comma: D:\\MyDocuments\\National_Map\\Data\\LIM\\lim.dgn,D:\\MyDocuments\\National_Map\\Data\\LIM\\extra_dgn\\5_industrie.dgn  The WorkspaceRunner returns following error:    IGDS Reader could not open file D:\\MyDocuments\\National_Map\\Data\\LIM\\lim.dgn,D:\\MyDocuments\\National_Map\\Data\\LIM\\extra_dgn\\5_industrie.dgn for input Program Terminating   Translation FAILED.   However, when I copy-paste the string with the paths to the respective Workbench, it runs smoothly. So, the paths are correct, but I have the impression that the comma is not applied as separator when it is received from the WorkspaceRunner.    A

80
fmelizard
Safer
A
andrewn
asked in Data
Writers output filename for Raster Feature class same as input is not happening

Hi All, I have hit a wall, I cannot get FME to save the input's filename as the output’s filename. Input is: 291000-6996000_1m_DEM.xyz output is Raster feature class inside a ESRI geodatabase. I’m trying to get output’s Raster feature class name same as the input (note output filename can’t start with a number). I can change the original .xyz filenames to add a c in front, for example (if required). Also this all needs to go into 1 geodatabase as I have hundreds of large .xyz files. I managed to get the batch to work but it saved multiple geodatabases with the inputs name and with 1 raster inside each, all with the same name. In the workbench all I have is Reader, RasterDEMGenerator, Writer [GEODATABASE_FILE_RASTER_DATASET]  Cheers

70
takashi
Celebrity
P
patc
asked in Data
I need to go from EXCEL in address form TO KML

The excel sheet  has the address  with the St Num and Street Name are in 2 seperate colums.   How do I translate this in fme to kml

220
fmelizard
Safer
S
spatial_cowboy
asked in Data
How to allow multi geometry types in ESRI geodatabase reader

Hi All,  I have an ESRI SDE and a Geodatabase with polygons points and tables. Adding a reader with Merge Feature Type ticked seems to only allow "geodb_polygon" geometries. Seemingly no chance to add points or tables. Can I have multi Allowed Geometries and a Merged feature Type?

430
S
M
max
asked in Data
FME Server and SBS Plugin

To automated the running of my workspaces I have installed the FME Server. Basicly the purpose of the jobs is migrate smallworld to a newer smallworld version. However every time running through the FME Server, the message bellow appears:  Failure  This FME edition does not recognize the `SPATIALBIZ' reader. Please ensure that the current platform supports this reader, the reader name is spelled correctly, and that you have installed all required plug-ins   I can't understand why once my FME Desktop is licensed for SBS plugin correctely and ran the workspace manually with out any problem.  There is some thing to do on FME Server directory? (As test, based on this articlehttp://fmepedia.safe.com/articles/How_To/Installing-a-SpatialBiz-Smallworld-reader-writer-floating-license, I have copied the sbs.lic file and pasted into C:\\apps\\FMEServer\\Server\\fme\\licenses directory, however the error persists).  Could some one help me?

1170
david_r
Celebrity
J
james_websoft
asked in Data
Reciving URL from FME server

I would like the FME server to send me back a URL. I am trying to setup data sharing with a webmap, the system is processing features and reading coordinates but at the end a URL is not sent back. Any ideas or help would be useful.

80
david_r
Celebrity
B
brex
asked in Data
Writing an FME list attribute to ESRI Geodatabase file

Hi, I'm wondering how you "ESRI folks" represent an FME list attribute when you write to ESRI Geodatabase (preferably using the API without checking out an ArcObjects license) ? Also, same question goes for the SHAPE format?

640
jdh
Contributor
fme4fsj
Contributor
fme4fsjContributor
asked in Data
"Inspect" and "Open Containing Folder" greyed out

I'm running a Shape2Shape translation on FME Desktop win64 2013 sp3, and one of the three output datasets the options for "Inspect" and "Open Containing Folder" are greyed out.  I can open the datasets in Inspect outside FME with no problems and the other two datasets I built in the workspace are accessibe.   It doesn't really affect my process but I am just curious to see if anyone know why this might happen.  

40
david_r
Celebrity
R
robbie_botha
asked in Data
Text file values Reference

I have a source file with 800 000+ features all of which have unique ID’s. I have a list of 600 features that I need to isolate from my Source. Because it is so many features I was wondering what the steps would be and what transformer to use if I simply want to copy the 600 feature’s IDs to a text file/ different source file, and have a relevant transformer look at the values in the text file and extract the correct features from my Source.  Thanks in advance!

130
R
M
max
asked in Data
batch for smallworld

I am trying to create a batch file to run some workspace where migrate data from smallworld to a newer one version. Anyone knows how do I set the reader and the writer and parameters like server, service and alternative? Note: I am using the plugin SBS for this migration.  Thanks in Advance

80
M
R
rl
asked in Data
ECW to JP2

Getting a slight projection shift when performing this conversion operation. Just a straight reformatting conversion, and is not displaying correctly in PLSCAD...  ECW in... 2208900.00 16581180.00  JP2 out... 2208900.13 16581179.86  Thoughts? RL

230
R
M
mikesando
asked in Data
Extract separate attributes from one layer name? CAD

Reader is Autocad and writer is FGDB. What I am trying to do is extract separate attributes from one layer name. For example Layer name is 4_SDR_21_WATERMAIM and need the 4_ in "size" field SDR_21 in "material" field and WATERMAIN in "main_type" field? Can someone please point me in the right direction for the best way to accomplish this? Thank you

420
M

Badge Winners

Show all badges

Community Stats

31,808
Posts
120,815
Replies
39,431
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.