Using readers and writers to extract and load data.
Recently active
I published an OData service from Composite Studio (from Composite Software). It is in ATOM format that FME Desktop 2013 supports. I can see the http URL in browser but can not access it in FME reader. It does not give an error message. The log file shows: Trying to find a PYTHON plugin for reader named `ODATA' Trying to find a PYTHON plugin for reader named `ODATA' OData Reader: Directive 'SERVICE_URL' has the value 'http://dalwcompd01.nexenusa.ad:9400/odata/TGS_LOGS' OData Reader: Directive 'USER_NAME' has the value '['admin', 'admin']' OData Reader: Connecting to service 'http://dalwcompd01.nexenusa.ad:9400/odata/TGS_LOGS/' OData Reader: Retrieving feed names from service 'http://dalwcompd01.nexenusa.ad:9400/odata/TGS_LOGS/' OData Reader: Reading schema data ... Merged 0 schema features read from 1 datasets into 0 resulting feature types UniversalReader -- readSchema resulted in 0 schema features being returne
WIth the release of FME 2014, I notice that the MFAL writer for MapInfo tab has desappeared. We now have the MapInfo TAB (MAPINFO) and the MapInfo TAB (MITAB). I have noticed that both writers are using MITAB. See this log: 2014-02-03 15:24:49| 0.3| 0.0|INFORM|Using MapInfo (MITAB) Native Writer $Revision: 113523 $ We have a problems using polygon data created with MITAB. When opened in MapInfo, the nodes of those polygons cannot be snapped and features are deleted when performing geometric operations such Erase or Split. We were always using MFAL writer because of those issues with MITAB. Why removing MFAL writer in FME 2014? Is Safe Software knowing such issues with MITAB? Thank you for info on this topic.
is there a way that i can fan out by feature type on the DGN(V8) writer without providing a 'Feature Type Name:'? I have a seed file which has layer 0,1,2,3 - 256 etc, these are stored as attributes called 'CAD_Layer', using desktop 2012
On several projects they have made the Excel-spreadsheets "non logical". So instead of having the spreadsheet like this: Is is saved as this: I have read the various FME + transpose + EXCEL posts (for instance http://fmepedia.safe.com/articles/How_To/Advanced-manipulation-of-Excel-tables-using-AttributeExploder) - however this will not give me access to the schema withouth running a workspace first - and then loading that file in a new workspace. So it would be very usefull to have a "read transposed" option on the EXCEL-reader. Or is there a workaround I havent found?
I would like to read datas from a WFS (Web Feature Service) which is served from a ArcGIS Server which is secured with secure token. How can I configure this?
I get the following error in my translation when I try to reproject on ESRI data interoperability from NAD 83 to NAD 27
Hello everyone, Would appreciate if anyone could give me a hint if this is possible to process multiple raster datasets within file geodatabase as single merged reader? I need to convert one gdb raster datasets into set of tiles within another gdb raster catalog and struggling with reading all of the input files at once. Is this possible? PS. This is my first post here so I hope I didn't break any posting rules. Cheers, Kim
I all, I got this error message while running a workspace which writes ESRI relationship classes: An error occurred while attempting to stop an edit session. The error number from ArcObjects is: '-2147220893'. The error message from ArcObjects is: {Workspace or data source is read only.} 1) I read SHP and write GDB both in and out zip files (if both dataset are not zipped it is OK). 2) I set up the FME_TEMP variable to C:\\temp to make sure I have write access 3) Why should I have write access problems to the _auto_zip_dataset on C:\\temp? 4) Is there a trick I don't know about? Thanks for your help. JP
Hi, I'm trying to create e00 files from MapInfo (all BNG prjection) and i'm coming across a couple of issues.... 1. warning message "Could not find an E00 mapping for datum of coordinate system `OSGB-7P'". Can anybodyexplain what the importance of this message is? 2. The resulting e00 files all have the file location held within the file (when opened up in Notepad, the first entry is "EXP 0 C:\\data\\...........", which i'd rather not have displayed to clients. Is it possible to exclude this text? 3. Using a clunky old MapInfo tool "ArcLink" i am able to avoid the issues above, but i'd much rather use FME for this translation. May thanks rich.
Hi, Is it possible to specify an existing output folder on Google Drive when writing to a Google Fusion table? It always ends up in the root folder (My Drive) for me. I would like to write the table to an existing shared folder to avoid having to share the table when it's written. /mats
Hi, I am using FME2014 and I am using this documentation : http://fmepedia.safe.com/articles/How_To/Working-with-Geodatabase-Subtypes-and-Domains At the step 3 of reading domain values in the documentation, I click on VIEW of the coded_domain (DIAMETER) and I have my list of coded domain values from my GDB. Exemple : http://fmepedia.safe.com/servlet/rtaImage?eid=ka1a0000000cwS9&feoid=00N30000007dMlC&refid=0EM30000000TpzI What I want to do is to export this list into something else like Excel. I have hundreds of coded domain values into my GDB, each of them connected to Feature Class. I would like to export the coded domain values (code and description for each of them) from all the FC I would choose to read into FME. You think it is possible? Thank you!
Hello, I'm doing a straigth-forward conversion of Oracle SDO_GEOMETRY from srid 294914 (old national coord.base) to srid 3067 (new national coord.base) using just Oracle reader and writer. Is there any way to reduce the number decimals in the output, at the moment converting from 3385034.91; 6678837.36 (east; north) produces 384911.612948413; 6676033.80278682 Best solution would be to have some parameter in the writer to round or cut to a desired number of decimals . I assume that using some transformer (like CoordinateRounder) between reader and writer would substantially increase the execution time ? Esko
Hi I have a huge set of Las files and I just want to pick out one or more of the files and cut out a pre-defined area. The area will be defined by the user, a published parameter. I do area on area overlay, the customer defined area over a square grid to catch one or more id numbers. Know I drop the geometry and just use the attribute in this part of the workbench. Couse I figured it would take longer time to do a spatial intersection in the next part of the workbench. I use the feature reader transformer and specify the feature type to read to the attribute above (Id number). I have defined the directory and dataset is set to *.las. I’m having problems though when I run the work bench it doesn’t fetch the Las files. The attribute is defined as 70875_7620 so I tried 70875_7620.las and no deferens. THe transformer runs when I use the spatial intersection mode that’s way I figured out it must be the attribute. Any Ideas? Tofia :)
Hi, I have started to use new writer format INSPIRE GML. I have also watched webinar on following subject recently. Since this is a first time I am working with mapping to INSPIRE schemas, I am a little bit dizzy with whole bunch of features and attributes. Still worst problem I have is with mapping geometry. I had to do a test with Hydro theme and featureType Crossing (geometry line). I used GeometryExtractor (GML 3.2.1. geometry encoding) for this purpose. Mapped '_geometry' to 'geometry' with AttributeCopier, but 'geometry' attribute is empty (missing) at the end. If i check the output values after GeometryExtractor with Inspector, there is a geometry value. So obviously I haven't mapped _geometry correctly with corresponding attribute on writer as Dean suggested in webinar (geometry attribute should be used for polygons only, correct?) I also mapped it with all possible xml_geometry datatype on writer, nothing. what do I do wrong?
Hello, I am wondering what coordinate system I should be using to convert a csv file of survey data to an ESRI shp file? The data looks like this: 135 5580767 458060.914 562.143 GF Columns 2,3,4 are Northing, Easting, Elevation. Any suggestions would be much appreciated. Cheers!
Hi, I've got an CSV file with 'hidden' XY in a column. It's like this: <gml:Point xmlns:gml="http://www.opengis.net/gml" srsName="urn:ogc:def:crs:EPSG::28992" srsDimension="2"><gml:pos>240664.000 488240.000</gml:pos></gml:Point> I want the two coordinates to be seperate columns in the new (point) shape. How do I do that? Thanks for any help!
Good morning to all I am running a process using schema mapper to load data into an existing feature class. The problem that I am seeing in the translation is that FME is generating extra attributes that are not part of the schema of the featureclass that I am When reviewing the log this is what I see: "Value of feature type parameter 'GEODB_OBJECT_ID_NAME' for table/feature class 'Bridge' has been changed from 'OBJECTID' to 'OBJECTID_1' as it conflicted with user field name. Value of feature type parameter 'GEODB_SHAPE_NAME' for table/feature class 'Bridge' has been changed from 'SHAPE' to 'SHAPE_1' as it conflicted with user field name." I added an attribute remover for the input files so that they didnt transfer over but I still get the OBJECT and OBJECT_1, SHAPE_Area1, SHAPE_Lenght1. Any thoughts?
Hi. How to make hatch patterns with 3 different colours. I use DWGStyler and a template file, but I can't find any option to set these.
I'm using FME desktop workstation and application server to write output kmzs to our client server. For some reason, kmz files exceeding 5 kB in size result in empty files with 1 kB file size, regardless of whether executing at the desktop or from the server. However when writing to a kml to the same client server or writing to the desktop, it works fine as usual. The user account used is able to write large files to the server location. The application log files show nothing unusual. There didn't appear to be a user permission issue. The service account looked fine. Where else should I look to troubleshoot?
how do i get FME to create the spatial index on a SQL Server SDE database -- documentation references GRID 0 - but there is no parameter for it in FME2014?
Hi: I have a layer with zoning, and a cadastre layer - the boundaries dont match up so i was trying to user a negative buffer to shrink the parcel a bit to eliminate most of the missmatches - but then i am getting too many null buffers. trying to do it with a spatial relator and a matcher and it is getting overly complicated. So time to rethink how i am doing it. What is the best way to copy the zoning text attribute from the zoning layer to a parcel layer on top of it - there are parcels with multiple zones? Thanks, Mike
Hello! This is serious failure I have here: after installing FME 2014 I cannot get my Oracle connection working properly. All the previous workspaces will crash if I try to save them over. I figured out that the problem starts even if I try to add "Oracle Spatial Object" type reader on the blank workspace, it crashes: It's weird that with 2014 beta I did not have that problem - I changed all my 30 or so workspaces, to use 2014 (2013 SP3 was our previous, still working with Oracle). But the database <null> support that came out with 2014 was a crucial benefit for us, so switching back would be really annoying. What could cause the FME 2014 to crash workspaces with Oracle Spatial reader? And, it is weird that using "Oracle Non-Spatial" reader is not causing crash... With regards, Raivo Alla Estonian Land Board
Hi, I have a feature class of polygons that I would like to convert to a text layer in the DGN file with one of the attributes as the text shown. I have played about with GeometryCoercer and tried changing the format attibutes (igds_type and igds_text_elements{}.igds_text_string) but cant get text to display in the place of polygons. Has anyone managed to do this?
Hello All, Just a quick query re the new GME Tables format. I've managed to connect successfully to our GME instance, list our projects, list our tables, and retrieve features. Unfortunately, the list of available tables seems to be limited to 100. Has anyone had any luck in working out how to retrieve tables beyond that first 100? I've tried manually entering the assetIds as a workaround, but with no success. Cheers, Keith
Before I proceed in my FME training I wanted to see if it is possible to create FME workspaces where it would require for it to ask for an input GIS file (Mapinfo TAB) and for it to run various processes (conversion, reprojection, renaming) based on where it is coming from. I would need this to be a reoccuring tool that I would run for different folders at different times. For example I have different folders that store different GIS files based on the specific geographic area it is in. I have many of these folders that I run the same processes at different times based on which area I happen to be working in that day. So I wanted to know if I could open an FME workspace and have it ask for an input file, then runs the process I set up for it to do based on the folder it is from? output file names would need to be custom to where its coming from everytime. I am basically trying to decide if I need to learn FME, or Mapbasic to create mbx tools. Or can FME do anything a programing la