Data

Hi All,  Quick question, I've some data in .gfo format. I understand a plugin is required to read this data in FME?  Has anyone managed to read .gfo data into FME? And if so, can anyone advise if this plugin is freely available or should I be better trying to request some onformation on it from Safe?  Google searches have proved futile so far!  Thanks, Tony

I have a dataset which consists of multiple Excel files. Each file has four worksheets. I want to merge one of the sheets from each workbook. The sheets all have the same schema, but the sheets don't share the same name. Some of them are named "Table" while other sheets have a name constructed by three digits followed by a place name; 102_Stockholm; 513_London...  Setting a regex in the merge filter properties of the reader is no problem. The problem is what to write in Feature Type Name? The Feature Type Name always semmes seems to works as a reducing filter. If set to "Table" I only get the sheets named "Table". I've tried to use some kind of wildcard (*, %) without any luck.  Regards, Daniel

Hi there,  I have an infuriating problem in that I have a DWG file that looks fine in it's origin, but when I load the DWG into FME 2013 SP3 several elements that compose a block lose their z value.  I can see the z values in the DWG but by the time FME reads it some of them have gone.  There are no warnings or errors it simply seems to lose the height, any thoughts appreciated...

I want to create a published user parameter to pick an existing ArcSDE version when using Prompt and Run.  I found this post (https://groups.google.com/forum/#!topic/fmetalk/uL_N9j9vDW4) from 2011 and sounds like there wasn't an easy way to create a user parameter and was hoping this has changed.  Essentially I want the "Choose SDE Version" dialog to open up and the user select the version they want.  The screenshot below shows the dialog I'm looking to use for the user parameter (note I removed some info from the graphic).  How do I create a user parameter to get the "Choose SDE Version" prompt?    

Hi every one, i'm facing a problem while i'm trying to import the .LAZ fiel to Postgres DB. Workbench is showing only 1 feature was written to the database, where as the input file is having more. Log is also not showing any error. The data should be imported to Postgres with the data type "pcpatch". Please help me in this regard. Thanks in advance.

Hi All,  I'm not Database Admin and I am getting some help with the SQL queries, but I'm updating a postgres database from values in a google spreadsheet. The values are stored as text in the spreadsheet and postgres but I'm having to use the "quote_literal" in the SQL below otherwise I get a text error when trying to write to the postgress database.    The issue is that it does still fail when I use the kind of text in the google doc illustrated in this nice cartoon.  Is there a transformer I need to use get FME/Postgres to treat it correctly or is this just a bug in the way FME is talking to Postgres?  I'm using the Google Spreadsheet Reader and the SQL Executer to do the work.     UPDATE function_program_data_function_structure SET text_data = quote_literal('@Value(fs_10_10_10_10)') WHERE level_id=@Value(id) AND flag_no='10' AND group_no='10' AND group_element_no='10' AND field_no='10'

Hi, I'm wondering if there's a way to expose the hyperlink values from hyperlink defined text from an Excel file?  The FME reader shows the values as varchar.  If possible, I'd like to convert the values through FME rather than doing in Excel first.     

I am wondering if it is possible to use FME and the DXF\\DWG writer to create an eningeering profile that has all the required labels, title block and annotation given an input DXF file? I've done some research and tried to create some work benchs after obtaining a template file that have yielded some limited results. Basically what I am wondering is it possible to go from this:    To this:    

Hi,  I need to read a SVG file but in FME, SVG  writer is present but no reader. Is there a way to read the SVG file. Any help would be appreciated.  Thanks

I have some polygon data (279719 records) in ESRI Geodatabase format. I want to load this data into PostGIS, and then view the data in a variety of GIS packages (ArcGIS, QGIS, web GIS) from the PostGIS database.  I know that the data has geometry problems because if I run the Geometry Checker tool in ArcGIS it reports 576 errors. This data displays fine in ArcMap from the Geodatabase despite the geometry errors (it also loads fine in QGIS).  So I load the data into PostGIS via a GeometryValidator in FME. I have experimented with a lot of the different combinations of Issues. For this testing phase, I load the data into 3 seperate PostGIS tables (passed, repaired and failed). I also load the data into an ESRI Geodatabase just to check if this loads correctly into ArcGIS.   The data in the Passed PostGIS table gives the following error when I open it in ArcMap:  "One or more layers failed to draw:  arc_test.basisdata_fkb.vann_f_fkb:  Linestring or poly boundary is self-intersecting&

Hi,  I'm new to FME so I hope I didn't miss a tutorial or a manual somewhere ;)  In a few words I'd like to export a CityGML to KML/Collada files in order to load these in GoogleEarth and other 3D clients. In details :  <= Input : A CityGML containing 300 buildings referencing textures. The general structure of my CityGML is :  <CityModel> <Building> <BuildingPart> <Appearance> <SurfaceDataMember>  ... </Appearance> <RoofSurface>  ...  <WallSurface>  ... </BuildingPart> </Building>  ... </CityModel>    => Output : Idealy I'd like to generate a collection of KMZ files containing KML + Collada + Textures. Each KMZ file would represent a portion (a tile) of the original CityGML file.    My question : Where to start ? :)    What I've already done :    1) I've been able to load my CityGML file in FME. A certain number of Feature Type were imported (Building, BuildingPart, WallSu

What's the best way to export a FGDB schema to Excel?  I want a sheet (tab) for each feature class with the attribute name, type, size, etc.  I've tried exporting the FGDB to XML and reading it in but am having trouble fannning out the feature classes to sheets correctly.  Is XML schema the way to do this?

Any one could know this problem?  It is fine for a polygon that consists of many polygons by using FME's GeometryValidator and inspector to view the polygon. However, when using FME to load it into SDO database, the following error occur, and no geometry inserted. ......... "An error occurred while converting feature information to an Oracle object in column `GEOMETRY' A fatal error has occurred. Check the logfile above for details This occurred while attempting to process the following feature: The following row was not written to Oracle table because of errors converting columns: GEOMETRY ......."

I have a workspace that I would like to share with others (who don't have FME) and was wondering whether it is possible to save / export the current workspace to an image file? I've managed this in a roundabout way but I had to print the workspace to a PDF, save the PDF out as an image and then crop it to size.  I then had the options to either distribute as an image or to re-PDF the cropped image. There must be an easier way I'm missing :)  

I am inserting records into an Oracle Spatial table with an existing spatial index. Does Oracle rebuild the spatial index automatically when I do this? If not, how would I rebuild the spatial index with FME?  Thanks

I am trying to expose user name in autocad and the date that I run FME workbench (todays Date).  Is there a way to do this?

Has anyone ever tried to read a Firebird database?  It's not in the list of supported formats, but I'm wondering if there's a way to still read it using something more generic?

Hi,  I'm trying to solve an issue in our office where users who have the "FME Extension for ArcGIS" installed on thier PCs are checking out FME licences every time they open a copy of ArcMap. (None of them are enabled) The licences are usually returned within a second or two, but occasionaly they get stuck, which causes us FME users issues as we only have 2 licences. (it also regularly interupts scheduled tasks and batch process).  A sample from the licence manager log file when I started ArcMap: 12:50:04 (safe) OUT: "FME" username@machinename  12:50:04 (safe) OUT: "esri" username@machinename  12:50:04 (safe) OUT: "national" username@machinename  12:50:04 (safe) IN: "national" username@machinename  12:50:04 (safe) OUT: "fmeobjects_reproject" username@machinename  12:50:04 (safe) IN: "fmeobjects_reproject" username@machinename  12:50:04 (safe) OUT: "basic_raster" username@machinename  12:50:04 (safe) IN:

Hello! I have parcels polygons into a databse and I want to determine what kind of geometric shape (square, triangle, rectangle, trapeze, other) each of those polygons have. i am using the circularitycalculator and after a use a testfilter to determine each shape by the shape value (square ~ 0.75, rectangle ~ 0.65, etc). Unfortunately, a lot of polygon have weird values, so my filter doesn't work well. Would you have a better idea? Thanks!!

Hello,  I've recently upgraded to FME Server 2014 but am having problems publishing or downloading workbenches using FME Workbench 2014. It works fine when I use FME Workbench 2013.  The problem is a permissions issue where it says:  Login failed (Not Authorized) - Ensure that username and password fields are correct, and that user has sufficient privileges.  I don't know what the issue is as even using administrator gives this error and like I said if I go back to FME Workbench 2013 it works fine with the same username.  Which logs would I need to look in to help with this?  Thanks,  Peter.

Hi community,  I have links (with token) here that give me the opportunity to have GTFS data into realtime. So I could have bus realtime position or alerts by exemple : https://developers.google.com/transit/gtfs-realtime/  Would you know a method to read this data into FME?  My goal would be to read this data and update the last position into ArcGIS via FME. If you would know a way to use the GTFS-realtime into ArcGIS, I would be interested too. Honestly I don't know what to to with those links...  thank you

Hello,  How to copy the contents of a file (File_m.csv) into another file (File_n.txt). Such that it does not overwrite but only appends to File_n.txt.  File_m.csv             File_n.txt                                   output expected:    File_n.txt A B C D E F            3 5 6 2 7 7                                                                 A B C D E F M N O P Q R           8 7 5 0 1 3                                                                 M N O P Q R                                                                                                                       3 5 6 2 7 7                                                                                                                       8 7 5 0 1 3  Regards.

Converting ESRI shape file to coverage,  I applied the tool “feature class to coverage” available in the ArcGIS to convert shape file to coverage but I got the error below:         How can the shape file be converted in FME to Coverage? The result is expected to take the following format:    Thank you  Best  Jamal

Hi,  Can anyone help me devise a method using FME to collapse a series of text records with no associate geometry, assuming that 2 values are equal and 2 values are contiguous. I have included some example data below, data is arrange such that the Animal and Colour values must match the preceding row and the preceding End value must match the Start value.  I have a very nasty script for excel which may be possibly be adapted, but I would really like to do this with FME.  I have tried to do some of this within a loop but got a bit lost. Could it be down using transformers or a Python script which can be included in a bench? Ideally any method needs to be adaptable as I would like to use it for other data sets with differing field names and more or less matches required.   Animal, Text Colour, Text Start, Int End, Int  Input Data Format  Animal,Colour,Start,End Dog,Blue,0,1 Dog,Blue,1,5 Dog,Blue,5,10 Dog,Red,31,35 Dog,Red,35,56 Cat,Purple,101,102 Cat,Purple,103,106 Cat,Purple,106,111  Re

HI,  I'm using the pdf2D writer in FME Workbecnh 2011 to create a bunch of maps.  I'd like to use the fanout feature on my pdf writer, however when i add a pdf_type of pdf_text to the writer it crashes fme.exe when the writer starts to open I think.  If i remove this pdf_type, by stroking the text then i can write the pdf with fanout, however if i drop the fanout i can write the pdf with text!  I'm not sure it's a bug in the writer as such as I can create a much simpler workbench and write text.  The bits i've dropped im my simple workbench that work are adding multiple pages, altering the page size to A4 portrait and landscape.  I'll keep plodding though the workbench until i break my simple  workbench and hopefully incover the problem, however i thought i'd ask here in case anyone has suffered a similar issue when writing pdf's? (in 2011 - as my server instance is still 2011)  Nick