Using readers and writers to extract and load data.
Recently active
Hello, From what I am able to tell, FME is a very powerful spatial data extraction tool. But I have some specific use cases I am trying to decide if FME is a software that can be of use to me for extracting features out of Lidar data. A perfect example of my needs would be to use FME on lidar data taken of, say, along a street where we need to extract the edge of curb lines. Another example would be to detect changes over time, say i have a lidar dataset of a hillside taken in at two different times throughout the year. Would one be able to use FME to detect changes over time between the two datasets? Any help would be greatly appreciated on the matter! Thank you all for reading my post.
Hello! I have to add texture from a single .bmp file for more objects( roof buildings grouped by a common code) The target format is Openflight (.flt). I'm blocked in this procedure, please help me!!! For other details see the previous post named "add texture to polygons" In other words i can obtain for each object one texture file and i need a single texture file for a group of objects. Thanks!
Hi. I am using a SpatialFilter transformer to join two Oracle tables, and routing the result set to an Inspector and to a KML Writer. The Inspector is correctly showing all wanted attributes from both tables (I am using AttributeKeepers to filter to only wanted attributes). The KML Writer, however, is only showing the attributes for the parent table. In the KML Writer, under Dynamic Properties, I am selecting both source schemas, so I'm unsure why the Writer is only showing the attributes from the parent schema. Is there a way I can make the KML Writer show the attributes from both schemas (preferably without using an external .csv as I don't know whether I will have access to external files within a production mode). Thanks very much. JR
Good morning. I am trying to join two Oracle tables, TableA and TableB, to output a KML file that contains attributes from both tables. I am able to do this presently by using a temporary table created within Oracle and then simply reading this table within FME and then using the KML writer to output the KML. On production, I will not be allowed to use temporary tables, so I will need to handle the join within FME. In Oracle, my join condition to create the temporary table is very simple: a.state = b.state. How would I accomplish this join between TableA and TableB and keep the attributes a.col1, a.col2, a.col3, b.col1 in my output KML? I have tried various methods, but all without success. I am always only able, when I view the KML, to see attributes a.col1, a.col2, a.col3 or b.col1--never all in the same KML. Thanks very much. JR
Hello, l have win7 64bits machine, a 32bits microsoft office pack a 32bits fme (before l've desinstalled the 64bits fme) already installed on my machine (ie Article Number: 000002381) : - .NET Framework v4 - SQL Native Client 2008 or greater - Microsoft System CLR Types 2012 and when l try to read a ms access database, l have the message below quite similar to what l can find on internet but not exactly the same, and any solutions work. the last solution l see is to reinstall win7 on my machine.. what is not so funny but maybe better indead then triying to make that ms access reader read my access database thanks for your advices --------- Trying to find a DYNAMIC plugin for reader named `MDB_ADO' FME API version of module 'MDB_ADO' matches current internal version (3.7 20121025) Trying to find a DYNAMIC plugin for reader named `MDB_ADO' FME API version of module 'MDB_ADO' matches current internal version (3.7 20121025) MS Access Reader:
I have an existing workspace that creates a pdf and inserts a logo by reading a png file and then using a rastergeoreferencer to place that on the page (using page units). I now want to expand this workspace to create multiple pdfs using the fanout on the dataset. However using the fanout means the raster ends up in a pdf file of it's own due to not having the relevant attribute set. I cannot just set the attribute as it needs to go in each pdf output. Any bright ideas?
Hi, got an unexpected problem when re-building my FME 2013 workspace for FME 2012. DWG reader fails in the rebuilt workspace. FME 2012 Workbench error message: AutoCAD Reader: An error occurred for dataset 'AYAA-GE42C_2 dwg.dwg', in function AutoCAD2004Reader::open: 'Not that kind of class' FME 2013 reads the file without problem. Help would be highly appreciated Thanks
Hi Guys, from a source .dgn file i read postal codes from TAGs into a destination .xls file. I want to fill these postal codes in the .xls file automatically in a Attribute filter and Attribute Creators should been created where an attribute is create which have this postal code. so when in the Excel file is an postal code 20000, i want to fil automatically a attribute filter which filter a named cell with 20000 and an attribute creator will be set after the filter where an attribute postal code is filled with 20000. Can I handle this in one workbench? Greetz and Cheers Franco
Dear FME experts, I’m getting quite desperate about a problem I still can’t solve. The input format is shape which contains areas. We use FME desktop (2013 SP1) to correct a great number of these geometries. The workbench contains AreaOnAreaOverlayers / Dissolvers etc. At the end we check the geometries with the GeometryValidator where we test all issues. 4 geometries are repaired. The output is shape again. Until here everything is fine. After this we use SPIT to load the shapes in PostGIS. Running isValid in PostGIS returns a lot of errors. Self intersections. Our workaround is to repair geometry in ArcGIS which solves the self intersections. (a lot of them!) Then we load the shape again in FME, run the feautures through the GeometryValidator with all checks. 16 geometries are getting repaired. Now we can successfully load the shapes in PostGIS. The isValid function returns nothing now. I would love to skip the repair geometry cycle in ArcGIS. My latest guess is i
Hey all. I wrote an FME Workbench file that reads data from two ArcSDE Geodatabase layers residing on an Oracle database, does some processing, and then writes the resultant output to a new ArcSDE Geodatabase layer on that Oracle database. When I run the Workbench file from my PC, it takes about one minute with no issues. I have published it to our FME Server and when I run the jobs, they never finish. I even let it run overnight earlier in the week and cancelled it the next morning, as it was still running 15 hours later. I have tried a number of things to identify where the issue is. If I disable the final link connecting to the writer transformer, the job completes and takes about 1 minute, just like on my PC. But the moment I enable the link to that writer, it goes back to never finishing. I also disabled all of the transformers and just connected the writer directly to one of the readers, and it finished successfully. This got me thinking that maybe the machine that is r
Hi, I'm working with (and constrained to) FME 2011. I'm using ArcSDE30 writer to load images into an ArcSDE 10.0 raster catalog which we then apply the arcGIS Server 10.1 temporal slider toolbar onto allowing us to animate a set of rainfall radar images. We're using FME to extract and load the images, which works fine. My problem is how can I get FME to delete those images that are know longer required? It appears that the arcsde raster catalog writer doesn't have the usual fme_db_operation capability which I was planning on using to send features to 'insert' or 'delete'. It does have a truncate option, but that doesn't appear to work either. Any Ideas? Incidentally, why doesn't the arcsde geodb writer handle rastercats? maybe it does in 2013? I haven't checked yet. (however ultimetely we're looking at deploying this on to server 2011, and it'll take us a while to upgrade from this server version - unfortunetaly)
I am trying to open the Manitoba Highway Conditions KML and getting an error: XML Parser error: 'Error in input dataset:'file:///C:/Users/lawiebe/AppData/Local/Temp/FME_OGCKML_KMZ_1363808830240_7172/Manitoba Highway Conditions.kml' line:1 column:425975 message:invalid byte 'l' at position 2 of a 2-byte sequence' At that location in the file there is a coordinate: -96.79388,50.18568,94 the 5 of ,50 is character 425975 in the file... doe not look like an invalid character, that is why I am wondering if there may be a line length limit? The KML opens in ArcGIS Desktop, Server and Google Earth. I have tried FMW Workbench, Universal Viewer, Data Inspector 2011,2012,2013 and all have the issue. The file can be accessed at: http://roaddata.gov.mb.ca/map/gearth/kmz/manitobahighwayconditions_e_kmz.kmz Thanks, Larry
I'm trying to put rasters into a local raster catalog. The writerer only gives me the option to write to a SDE raster catalog, any way to do this other then calling ArcPy?
Hello All. I would like to know if is possible to write geometries from MapInfo and AutoCAD to Oracle Locator and not Oracle Spatial. If yes, how can I do that? Thanks in Advance. Fernando Ferreira
Hello Just as info for those who may run into this. I had a customer complaint that ArcMap does not recognize the coordinate system from a GeoTiff file I created with FME. Well after lots of going here and there, trying out new GeoTiff writer options and the like the solution was very simple. ArcGIS 9.3.1 does not recognize the coordinate system in the GeoTiff ArcGIS 10.0 can read and use it without any problem. Michael
Hello Today I want to get rid of some repeated pain in workbench I'm going through, by telling it here. Thanks to steady development there are always added new options to writers. This by itself is very welcome. Right now I need to utilize a new option in GeoTiff writer which is labelled: "Write Esri-Compatible Coordinate System" (not documented in FME 2012 SP4 btw) What I have: I have a workspace which is used as a writer-adapter in the FUSION Data Service application we build on top of FME. Besides other such adapters used for all kinds of different formats, this one is specialized on Raster data handling. This writer-adapter contains 5 different writers (Tiff,GeoTiff,JPeg,JPEG2000,PNG). All of them are set up in a way so they use the same published parameters for as many settings as possible. These parameters then are used in the calling skript. Attribute fanout is used to control the resulting filename. Now my pain starts: 1) I cannot utilize new writer settin
I've got a CSV file that came from a flood modellnig package. I want to geocode and map the water levels at each point (calculation cell centroid) at a series of time slots. My problem is this: the file has 1 row for each time slot and 1 column for each calculation cell centroid (about 500,000 columns in all). When I created a CSV reader for this file FME 2013 just sat for hour after hour and never got as far as displaying the reader on my workbench. Presumably it couldn't cope with trying to generate the schema/list of attributes. Any ideas for processing this file? The only thing I can think of is writing a utility to transpose the file first. Thanks, Ian
Hi, I have a problem running an FME task (fmw) as an FME commandline scheduled task on Windows 2008 R2 (64bit). Background: 1. FME 32bit installed 2. Oracle Client 32 bit installed 3. Oracle client BIN folder n PATH 4. TNS_ADMIN environmental variable set to point to folder containing tnsnames.ora The problem: I created a scheduled task that runs fme.exe with my workbench file (fmw) as command line parameter. The task is set to use the SYSTEM account to run the task (this is because we cannot use a local or domain account as out policy doesn't allow password saving). When running the task in this configuration I get the "Oracle client libraries could not be loaded." error. When running exactly the same task using my user account it works. What works: 1. Running FME task via workbench. 2. Running the task via commandline (command prompt). 3. Running the scheduled task under my user account (when logged in). 4. As a sanity check I have
Looks like FMEServer 2013 does a Postgis query by default with the owner "public" before using the login specified in the fmw?? The error raised is causing me problems in my application NOTE: All my data is not in the public schema Log: Error executing SQL command ('select * from "public"."hafa_acoa_02_poly" limit 0'): 'ERROR: relation "public.hafa_acoa_02_poly" does not exist No spatial column was found for 'public.hafa_acoa_02_poly'. This is most likely a PostgreSQL table with no spatial data. No geometry will be read. If spatial data is not present, please try using the PostgreSQL reader instead PostGIS geometry type unknown or empty (). Setting PostGIS geometry to 'postgis_none' Error executing SQL command ('select * from "public"."hafa_acoa_02_poly" where false limit 0'): 'ERROR: relation "public.hafa_acoa_02_poly" does not exist SQL query on table 'public.ha
Hi, I adopted the example of a Catalog and Repository from: http://fmepedia.safe.com/articles/Samples_and_Demos/Integration-example-for-OGC-CSW-Data-Catalog-And-Repository-with-FME-Server to build a workbench that reads in files, guesses the format, gets, the bounds and dataset names and writes this metadata to an XML-Template and copies the original files to a definied directory. Works fine on my Computer and on our (windows-based) test server but fails to run on the Linux based Server of our partners. In order to identify the error, I have created a workbench that just copies the files. This runs well on the Linux server - so it isn't a permission problem. But as soon as I add the XML-templater the workbench will stop with an error on the Linux-based FME Server. Here is what the log says: 2013-03-09 22:48:52| 0.7| 0.0|INFORM|FME API version of module 'XMLTemplaterFactory' matches current internal version (3.7 20121025) 2013-03-09 22:48:52| 0.7| 0.0|WARN |XMLTemplater(XMLTem
Hi, another CityGML question! is there a possibility to write CityGML 2.0.0 already? I'm trying to model the buildings at LoD0, as lod0FootPrint, but this citygml_lod_name is not valid! "The 'lod20FootPrint' citygml_lod_name trait is invalid for 'Building' features, the geometry will be ignored, valid values are {lod1MultiSurface, lod1Solid, lod1TerrainIntersection, lod2MultiCurve, lod2MultiSurface, lod2Solid, lod2TerrainIntersection, lod3MultiCurve, lod3MultiSurface, lod3Solid, lod3TerrainIntersection, lod4MultiCurve, lod4MultiSurface, lod4Solid, lod4TerrainIntersection}." Can I add this possibility manually, or should I wait for a new (updated) cityGMLwriter? (next question I will ask, will be concerning the modelling of tunnels and bridges ;)) with kind regards, Ine De Cubber
Hi, For some reason the formats my workspace arent being recognised by the generic reader on FME Server. They are when I run it in desktop. Do I need to do something else on FME Server? Thanks, Owen
Hi there, I have a line feature class in an SDE database that changes daily. I need to compare this feature class with the newer shapefile and add the changes to the SDE feature class. Currently, I have a reader for the SDE feature class, a reader for the shape file, they go through the change detector transform, and then I have a writer to the same SDE feature class. However, the change detector is not detecting any duplicates, even when I test with the exact same file (so all output should be unchanged). This works correctly if I have two readers that are both shapefiles, or two readers that both read from an SDE feature class. Any ideas why it won't detect duplicates with a combination? Thank you.
I have 2 shapefiles (points). How can i copy the attributevalue from shape 1 to shape 2 if the points have the same geometry. Example if point A from shape 1 and point B from shape 2 have the same X,Y and i want to copy an attributevalue from point B point A
Hi, I am importing the shapefile from fme to smallworld, In my shape file i have 169 records but only 10 records are importing. In this process i am getting the error :: Error :Primitive a polygon.all_intersections failed status 1376267(0,21,11) Too many intersections How can i resolve this problem please help me and suggest me the solution as early as possible. Thanks in advance.