Data

I found some documentation for import psycopg2 but when I try to include this in a startup python script on FME workbench 2014 sp2 it says that there is no module named psycopg2.  I am trying to read/write to a postgres db, more specifically i want to set a value based on a previous feature.  I believe that you cannot iterate features in a python caller.

I am trying to update some old workbenches we have.  Looking at our shapefile writers, we would like to use the 'spatial index' functionality that is available in FME 2013.  I am looking for an efficient way of adding a new shapefile writer and then coping over the attributes and other properties from the old shapefile writer.    Is there a non-manual way of doing this?   Thank you for your time,   Julia

I have a workbench set up where I create a Feature Class inside a file geodatabase. the next step is to create the metadata and load it into the same Feature Class. This all works fine.  I'm doing the exact same thing with a zipped file geodatabase and it's giving me errors.  Attempting to create table 'XXXXXXX' with 'geodb_type' set to 'geodb_metadata'. FME features of 'geodb_metadata' can only be written to existing tables. If intending to write metadata, please ensure the table already exists.  If intending to create a new table, ensure the 'geodb_type' is set to a valid table type. A fatal error has occurred. Check the logfile above for details I've checked all my parameters and they are the same between my zipped and non-zipped file geodatabase.  Any idea why?  Thanks

Hi there,  I have some solids (GTYPE 3008) in Oracle and simply want to write them out to a DGN v8 file, but I can't seem to get anything except decomposed line strings as an output, am I missing something here?  Surely this is supported, if I write to a DWG instead no problems, but DGN just isn't producing the goods...

Hi,  Does anyone know whether it is possible to write UTF-8 data to Sqlite spatial?  You get the option to specify encoding when using the Spatialite writer but not the Sqlite spatial writer?  Any ideas?  Thanks

(easy ? and I shoud know this)...When I create the workbench on my desktop I write to c:\\somepath but when I publish I want it to write to d:\\someother path. How do I set the path in workbench?   Both workbench and Server are 2014. The workbench extracts data from oracle and writes shapefiles.

In the FME Workspace it is possible to fill the properties to describe the workspace: Name, Usage, History, Legal, Category, Description....  Is it usefull to fill them out?  I ask because the most example workspaces from the safe-software webpage do not use them! The most workspaces use an annotation in the workspace.  Is it possible to bring the content from the properties into an annotation automatically?  What is your best practice to use or not to use the workspace properties?  

Hi all,  When writing to a GML my srs is set to srsName="EPSG:31370" as my data is actually in this coordinate system. But I want to have an URL in stead of this "EPSG:31370".  Any suggestions on how to do this?  Regards, Rob

Hi I'm trying to use FME to get shapefile to Postgres (postgis) but there is no option in the writer to choose point, or line, etc. .. What I get in postgis geom type geometry and not geom type point or lines, etc...  any help will be appreciated... thanks

Using generate workspace in FME Desktop. Using Oracle/SDE as reader source, and file geodatabase as writer target.  I want to copy feature datasets and features from sde to file geodatabase.  Because some feature classes have multipolygon and polygon features , a geometry filter is automatically put in and splits to 2 newly named feature classes. Even if template is used it does this.   Is there anyway to turn this automatic geometry filter off, so the copy happens just like ArcCatalog, 1 for 1?

Dear All  Converting CAD to shpae , it works only with the CAD that intially used to build the Workbench , when we upload another CAD with different schema , not output prodcued .  Thanks,

Article 000002244 seems to provide the solution I am looking for (using python script to specify feature types), but I'm unclear about setting the path for each microstation file that I am loading. I can create a list of the files I want to load to the reader, but there are multiple paths. I am creating the list by iterating through a directory and subdirectories and searching for files with microstation file extension. I'm not sure where to include the path information for each file?

Hi, I want to use the FMX GoogleGeocoder but when I open it in workbench It say that my "AttributeCreator" doesn't have the right version (in FME 2013) and if I try it in FME 2012, It says my HTTP fetcher is not right too. I need to build back the attributcreator for the "GG_FullAddress". Any Idea how is the syntax? thanks

I am having a bit of a frustrating experience with the CenterlineReplacer that I am hoping someone can help with.  Desired Outcome:   Centerline the entire length of the polygon "tiles." The length is a user-parameter and will determin the length of the line. By having the centerline "clipped" inside the polygon I am losing the correct length.  Background:  I have a number of 'tiles' (ie polygons) that I want to essentially spit in half and keep the centerline. Sounds like a job for the CenterlineReplacer.  However, whenever I run the transformer I get 3 undesirable results. First, it does not split the entire lengh. It essentially starts partway down the middle. Second, one of the centerlines always "snaps" to the corner of one polygon.  Third, the line directions vary. I would like all line directions in the same orientation. Note, I have a proc

Hi All, I need to retrieve a path of writer to remove this writer file from its directory to another one. I couldn't retrive the writer path using Shutdown Python Script.  Example :     src_file = "c://temp/file1.csv"      dst_file = feature.getAttribute("fme_basename")  ??            shutil.move(src_file, dst_file)      I can't retrive feature into my script !   Any idea? Thanks an advance.  Farfar

Hi all, I need to move my Reader file (toto.shp.zip)  from its location to another directory after traitment. I think the best way to do it is into Shutdown python script. But i can't find the code to do it. Could some one to help me?   Thanks an advance.  Farfar

Our organization is exploring the use of FME cloud to push data out to Google Maps Engine(GME).  We currently have 2 FME Desktop 2014 licenses which we use to load data into GME.  We run change detection to incrementally update features in GME from our on site SQL Server 2012 database.  This is crucial as we have to pay for storage with GME and need to minimize update size to reduce costs.  I would like to publish our workspaces to FME Cloud but am trying to figure out the workflow for such a thing before investing in it.  Would our data need to be published as a shared resource in FME Cloud everytime we'd like the workspaces to run?  Is it possible to direct those workspaces to our database without punching a hole in the firewall?  Or is there a way to run change detection locally and then upload the new data to FME Cloud and have workspaces run only when things have been added, updated and/or deleted?

Hi,  We are trying to create a 3D PDF file out of a OBJ file for a masterplan.  Its a large file and we are running out of memory when making the write.   This is becasue the 3D PDF writer is only available in the 32bit version.  Are there any tricks to get FME to manage the memory better in this type of workflow?  Thanks,  Greg

 On the GML reader if I leave the FEATURE_TYPES value blank I can read all feature types into a single merged feature type without having to name them in teh workbench.  I'm trying to recreate this with an ESRI File Geodatabase reader. In this case I only get features back if I have explicitly named them in the FEATURE_TYPES parameter. How can I specify FEATURE_TYPES with a wildcard so that it will read all feature classes in my geodatabase?  

Hi Can you use a Case Changer on an unexploded list. So all values within that list are put to the same case so it makes it easier for ListSearcher queries to work (or can I do something in the ListSearcher to make this happen)  DL

For FME 2011 ESRI Shapefile Writer, what is the maximum column name length?

My tasks to do with FME looks like this: - Start the workspace and choose a shapefile.(The schema is not known before) - Write the feature type with all attributes to a Filegeodatabase.  I can create a workspace with shapefile reader and dynamic fgd writer and a published parameter to get the input from the user. But my problem is the reader which needs some predefined features.  If i select a shape file I get the following "unexpected Input" error: "some features were read that did not match a reader feature type...."  Is there a way to define the feature at runtime out of the input? Something like a dynamic schema reader?  Cheers

I've written some .net code that will run a workbench I've created in FME 2014  using:      IFMEOSession fmeoSession = FMEObjects.CreateSession();      IFMEOWorkspaceRunner fmeoWorkspaceRunner = fmeoSession.CreateWorkspaceRunner();      fmeoWorkspaceRunner.RunWithParameters This works in a standalone .net application.  I need to extend the program so that it also makes use of some ArcObjects code before calling FME. I'm using ArcGIS 10.2.1. The Arcobjects code also works in isolation.  The problem comes when trying to integrate the two. It seems that after running the ArcObjects code a call to FMEObjects.CreateSession() will return an error message 'Session could not be created.  Registry mapping to FME core DLL could not be found.'  I've also tried running this on a machine with the ESRI Data Interoperability extension installed and in this case I get a succ

Hi,  I have pointcloud xyz-files that I want to write to Esri ASCII Grid-format. I use a RasterDEMGenerator in the process with Interpolation method: Planar. It is 2 meters between the points so I use X/Y cell spacing 2 meters. But when I look at the resulting files it is a gap between them with no data (see image). How can I connect them togheter?    If I process the two pointcloud-files at the same time then they will merge into one single perfectly shaped ascii-file. But the problem is that I have 234 pointcloud-files with each 1,5 million points, and I have tried to merge them into a single ascii-file. It took about 80 hours for FME to process them, but still FME didn't manage to give me a resulting file because of some strange error.  Any suggestions please?  Cheers 

I presume I can't write a .lyr file since no such writer exists (is this an ESRI restriction?).  Is there any hack that would allow for setting colours based on attributes and then write this information to some other type of file that can later be used by a GIS to color a .shp automatically?