Data

Hi,  I'm trying to convert mulitple ASCII grids to a single CSV file in the following format:  X, Y, Z, Z, Z, Z....etc.... where the Z is rainfall data over time.  I can capture the XYZ info, but I don't know how to write out multiple Z value attributes while keeping the XY as a constant into a single CSV file.  Any ideas on how to solve this are welcome.  Thanks Ricky (newbie!)

I am doing a simple convert from an AutoCAD 2011 dwg file to an ESRI 10.1 File Geodatabase.  I have an FME 2013 Workspace with the input data (DWG) linked to the output dataset (fGdb).  The Reader for CAD uses all defaults for Parameters and is generating a single merged feature type.  The Writer uses the File Geodatabase API and is set to produce Dynamic Schema. Projections are set to source (Nad27UTM15N) The transformation completes without errors. I then open ArcCatalog 10.1 to view the created Geodatabase and see all features are there.  Clicking on a feature to preview it is where the problems start.  Any attempt to Identify the feature will come back with nothing found.  Any attempt to zoom in causes the graphics to disappear.  The features do not display in ArcMAp either. Teir Attribute table contains the Shape and ObjectID fields only.  Can anyone point me in the right direction to resolve this problem??  [OS: details Win 7 x64, ArcGIS Desktop Advanced (ArcInfo) 10.1 build 3035

Hi,  I want to create a .dwg with clickable hyperlinks from a .shp file, however I can't see an attribute I can expose on the .dwg writer that can take the hyperlink attribute from the shp file.  Does anyone know is this is possible?  Also, bit of a secondary question (that may make the first one invalid!) , but could I write this straight to an interactive PDF?  (I know I can create it via (Acrobat / AutoCAD).  I'm not very familair with FME's PDF capability.  Thanks.

My workspace's goal is to import the contents ot two old Access databases into a new, differently structured Access database.  The new database has four fields that have forward slashes in the field names. These are being interpreted as underscores by FME.  When I run the workspace, I get an error indicating that my new database doesn't have the field `Esmt_ppty_lease Date' (the first field it runs across with an underscore I guess) -which of course it doesn't.  What's the simplest solution here?  I'd rather not have to rename the four fields in the new Access database as that has other implications.

Hi, Does anyone know what is the FME quivalent of the "Update" tool? Thanks. Pietro

Hi All,   Just wondering if anyone can help me out. I'm looking at pulling a single SDE layer and re-projecting it through FME workbench. I will be fanning the output dataset by province (BC,AB,SK) and each province will have 2 or 3 projections (LL27,LL83,UTM, etc...) .  I am trying to figure out the best way to approach this. The SDE layer is large so I know the processing time may suffer a bit. I was thinking about creating a batch process and looping through a .txt file containing a list of provinces & projections to run the workbench. The batch process looks like this:  BATCH FOR /F "tokens=1,2,3 delims=," %%A IN (reproject.txt) DO fme <workspacename>.fmw --<fme_projection> <projection> --<provincename> <province>  MY BASIC FME WORKBENCH FLOW: SDE > ATTRIBUTE FILTER >SOME OTHER TRANSFORMATIONS> STRING CONCATINATOR (create file name)>OUTPUT (shp)   Any suggestions and/or feedback would be greatly appreciated!   Thanks 

Howdy,  Is it possible to grab points from a miscellaneous database, associate them with a dwg block (ie symbol, by way of a template file) and then effectively expand those blocks into entities prior to rendering out to a pdf, or even as a raster. It's an easy enough exercise to do it in two steps using an intermediate dwg file but I can't see a way to do it in one.  Any assistance would be appreciated.

It would be very handy to have a restart fmeserver-services including attached databases as a button in the admin-interface of FMEServer. Instead of logging in to the server and doing it "manually" from there - as this computer might be "locked away" between firewalls and computers.  Similar to the "Restart router" that most internet-routers have in their admin-userface.

Hi, I have created a workbench to translate British OS Mastermap from gml to .tab which works fine and I have multiple MapInfo. Tab outputs.  I also have a combined topography. tab which has all the features present but some building features are above land features and vice versa I have tried sorting prior to and after testing and styling but I have not been able to place all building feature above land features, fairly new to FME so any suggestions would be greatly received.  Thanks in advance  M

I'm reading a file geodatabase and need to grab the feature class alias.  I don't see any way of doing this?

Hi!  I'm trying to set up a workspace with three Readers: TAB, MIF/MID and Shape. I've published a parameter, which contains the path to a zip file. The zip file could contain either TAB, MIF/MID or Shape files. If the zip file has only Shape files, the TAB Reader fails and gives an error. I would like FME to ignore failing readers. Setting up the parameter Ignore Failed Readers to Yes doesn't seem to have an effect.  BR, Lassi

Hi,   I am using ARCSDE geodatabase as inputs to the workbench, from the input tables I need to extract the coordinates(x,y) values for point features and for linear linear feature i need to extract every vertex id's of the element(line segment) along with x, y coordinates of each vertex and "from junction element id" & "to junction element id" of the element. To extract the geometry information FME takes lot of time. Time consumption is the major hurdle in this project. It is the chalenging issue to succed in our project. Please help us that how to increase performance.  Thanks in Advance, Seshu

  I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources.   I noticed two different fme_geometry values for same type of objects.   For the first one, i.e SDE 9.3, I have fme_geometry=fme_donut, but for the same features in FGDB 10.0 I have fme_geometry=fme_aggregate.   Is this a "problem" of converting ESRI data from 9.3 to 10.0 or how FME interprets geometry?   Because in case of fme_aggregate, FME is doing "additional" job of constructing donuts again:  Calculating inside points Determining uppermost containment Constructing donuts from xxx points    (Visible in log window)

Hi,  I have an existing multipolygon PostGIS table. The entry in the geometry_columns is multipolygon and there are constraints on the table (2d, multipolygon and SRS).  1. When trying to write some features from a shapefile reader, only the single part polygons are written to the table. The multipart polygons get following warning: Geometry might not be representable in requested form  The allowed geometries parameter in the writer is set to "postgis_multipolygon".  2. In QGIS I can open the table and view the single part polygons that are written to the table, but the geometry column of the features is empty.  Found some similar topics in the FME talk but these are not really solving my problem.  Any ideas?  Thx, Rob

I am using the Change Detector to compare changes between a feature class in SDE and a feature class in a personal geodatabase.  I am running into a problem with the output from the Change Detector transformer when using the personal geodatabase feature class.  I have tried to run this transformer comparing an SDE feature class with a shapefile and the output is what I would have expected.  With the personal geodatabase feature class however I receive incorrect results.  I am only comparing geometry changes and ignoring changes to attributes at the moment.    If anyone could provide any guidance on this matter, then I would really appreciate it.  Thank you!

Hello  As the title says I cannot access the tables in the oracle Spatial DB (10.2.0.4.0) with the add Reader command.  The strange thing is, that with the transformer "OracleQuerier" I have access to the tables in the DB. I suspect it is because with the transformer, i can choose which version of Oracle (9i/10g/11) i have. With the reader I cannot.  Do you have any ideas? Do you need more information about my specs? I use FME 2011 SP4 on WIN32  The connection parameters are correct as i can get a connection to the Oracle DB with SQL Manager, ArcMAP (with add sql layer) and AutoCAD MAP. And as I mentioned with the OracleQuerier as well.  Excuse my english Regards Bernard

Google has announced that the Google Fusion Tables SQL API is being deprecated and replaced by the Google Fusion Tables API v1.0. This will occur on or around 14 January 2013.  The main API change is the move to OAuth 2.0  This means that existing FME Google Fusion readers & writers will not be able to access your Google Fusion tables.  All new FME 2013 Versions (after build 13261) will support the new OAuth 2.0 authorisation.  If you have problems connecting to your Google Fusion tables please contact Safe support

Hi there  I have looked at the FME workbench help for the postgis writer and in the old FME talk group, but haven't found a clear answer to my issue...  How do i define the following using the postgis writer in FME Workbench 2012 SP3: - Database name - Schema name - Table name - Encoding  The same question when using fanout by attribute.

Hi All,  I have some problems when I try to convert OSM file to ArcGIS FileGeoDB. These problems are mainly due to invalid or duplicate field name in the OSM file.  When I convert the same OSM file to Shape File everything is fine.  So my question is when Shape File export can find and remove that kind of errors why  FileGeoDB (API /Arc Object) export cannot find and fix that kind of errors in the field name?  Can someone explain me a way to automatically find/fix these problems, rather than run the workbench until it fails and then fix them manually?  Is there something available in FME like ValidateFieldName in ArcGIS?  I am using FME 2012 64bit on Windowx 7 64bit.

Is XMLUpdater the best transformer to edit multiple waypoints in a .GPX file. I need to change hundreds of unique waypoint names in a .GPX file to a few names based on a alpha character in the those original way point names. For example:  <name>002C34</name> needs to become <name>C</name> or <name>003B33</name> become <name>B</name>

Hi, I’m trying to generate points from a text file, using Lat & Long values.  StringSearcher seems to be the right transformer but I’m having trouble figuring out the proper expression to use.  Any help would be appreciated.  The contents of the text file:   From: bcticket@telus.net Sent: Wednesday, January 09, 2013 12:58 PM To: GIS Subject: Request 2013021114   01/09/13  12:57:20 BC ONE CALL NOTICE OF INTENT TO EXCAVATE            REASON CODE: ROUTINE LOCATE     Ticket No: 2013021114         Sending to:SQUISH01         Code:SQUISH01                   Sequence:0002   Original Call Date: 01/09/2013             Time: 12:53:02       Op: 442 Transmit      Date: 01/09/2013             Time: 12:57:20       Op: 442 Work To Begin Date: 01/14/2013             Time: 12:53:00      Company     :HOMEOWNER Contact Name:Test                   Contact Phone:(111)111-1111                                             Cell    Phone:                         

I have a large NITF image (grey scale, with palette). In the course of a number of transofmrations (reprojection, etc.) it gets converted to an RGBA (the palette is resolved).    Now I want to save it as a PNG. I do not need all the RGB bands. I see that PNGRASTER has a grey scale, and also a pallette option.    Is there a transform to shrink the RGBA to a Grey Scale plus Alpha PNG image (and pallette might also be nice).    The goal is to get the disk size smaller. Just compressing at level 6 is resulting in a 400% explosion from the original NITF.   

I want to be able to see my Oracle columns in Workbench.  When I connect a shape reader to a transformer, I can see the source columns.  But  I can't see the Oracle columns the same way.  I could use the Attribute Connections window, but I'd like to use the visual tools.

We are currently onsite doing a translation. Smallworld 4.2 (with 422 translators)  with FME SERVER 2012  The translation uses FME.exe and it works with FME Desktop 2012, we tested the same with FME SERVER 2011. But this doesnt work with FME Server 2012. Is there some special setup? we didnt find any sworldswaf*.dll in FME Server directory. we renamed the Fmf file.  This is urgent.

Hi,  is there any way to write the DGN Priority using FME?  Regards, Hendrik