Data

I would like to ask FME experts to point me any documents/code samples... for FME and IBM datastage integrations.  By searching the Web, I only fould a presentation by your boss did a few years ago. It doesn't have too much technical details.   Your help is very much appreciated.  George Shi Lead, Canada GIS team, IHS global GIS Calgary, Alberta  

I have this workspace: read LAS ->PointCloudCoercer->RasterDEMGenerator  I also have read into the workspace a raster (ECW)  In the parameters of the RasterDEMGenerator, I have defined the resolution of the output as: Output DEM X Cell Spacing: $(SourceDataset_ECW) Output DEM Y Cell Spacing: $(SourceDataset_ECW)  This fails with the error: RasterDEMGenerator(SurfaceModelFactory): Fail to process the SAMPLE_SPACING clause because it contains an invalid entry or it contains an invalid number of entries.  The ECW file is very much not corrputed, and reads fine in Data Inpector.  How should I be referencing  the properties of an already existing raster with the RasterDEMGenerator?  The overall goal here is of course to output a raster from a point cloud that has the exact resolution of an already existing raster and is also "snapped" to it.     

Hi, can anyone help me?  When I'm logged in as admin I see the options to view or download the logfiles after running a transformation in the web user interface, but not as other users. I guess it has to be some security setting I have to give for example to the role fmeuser, but I can't seem to find the right one.  Does anyone know?  Thanks, Tomas    

I have a workspace that reads from a File Geodatabase (FGDB), cleans up some attribution and then writes the updates back to the FGDB.  The problem is that I am getting ArcObject errors for some of the features.  All the features are lines.  One of the errors says that "Closed polylines are not allowed" and the other says that "The connected feature does not exist".  I am stumped by this as it is reading and writing to the same data set.  In looking at the feature(s) in an inspector the closed attribute says no.  For the other error... well how could it read something that doesn't exist.  I have successfully updated single and multiple records in this FGDB.  In comparing a feature that updated and a feature that did not update in the inspector I can see no difference.  This FGDB is a copy of a data set from our LGIM and does contain a network.  Any suggestions on how to handle this is much appreciated.

Hi everyone,  I'm trying to take some complex 3D shapes and use them to clip a lidar pointcloud. Here's an example of the shape:    I need all the points that lie inside those cylinders places into a seperate las file. The 3D shapes are stored as a series of polygons with height attributes in a shapefile, I've been using the 3DForcer, then extruding them, then using the geometry coercer and aggregator, finally then feeding them through the clipper.    The problem is the clipper seems to clip everything above and below the largest polygon, as if it were 2D. Below is the result, as you can see it's clipping points outside the yellow cylnders which is what I don't want.    Are my shapefiles not truely 3D when I'm feeding them into the clipper? Should I not be aggregating them? I'm trying to clip trees out fo a forest, so whatever I do has to be batch processed 20,000 times.  Thanks a bunch!  -EAYREY

Hi all,  I'm just trying to create a workbench which is able to write proper CityGML with CityObjectGroups, but unfortunately I can't find anything about that feature type in any documentation or post on this site. There is just one little sentence on the "What's new 2012" page that this feature type was added, so I think it should be possible to write CityObjectGroups and I just don't know how.  My solution so far is, to create an new writer feature type which is called "CityObjectGroup" and every cityobject that should be written also goes to this feature type. I guess all these GroupMember need to receive the citygml_feature_role attribute with the value "groupMember" so I already did that. But what to do next? Nothing really worked so far. Maybe someone of you already has some experiences on this topic? Any help would be appreciated. Thanks!  Jens

Hi all,  I am wondering if any one has experienced an issue with fields being populated with out making connections. The green arrow is not signifying  a connection and we are definitly not making any physical connections and we offten have intigers showing up in fields that should be charactors even if they were a connection made. Tahnks Pat

Hi,  Using FME I want to copy a set of files in 1 directory to a different and then add a new file extension (whilst retaining the old).  I have created a workflow which works by reading all files within a directory, I then use the AttributeExposer, FilenamePartExtractor and StringConcatenator to obtain the details of existing filename and also create the new name. I then use a fanout on the text writer to output to the new directory. The problem is that I think it is inefficient as the contents of the files are being read in and then processed, when this only needs to be completed at file level and not contents level.  The input files are essentially text files from a mainframe, and named as user id and mainframe report output number, i.e.  asd0122.012 asd0122.013 asd0122.014  I am keen to retain the existing 'extension' as this provide information of report request order and therefore want to produce the following  asd0122.012.txt asd0122.013.txt asd0122.014.txt  I imagine th

Hi.  I'm trying to get my FME workbench to read an excel spreadsheet that is automatically generated and has an asterisk in the column header of two columns. It reads this and displays it in the drop down list of attributes, but when I connect an inspector straight to the reader (I'm trying to get it to ignore a title line)  It wont read any of the columns with asterisks. They're not empty theyre just not there.  Does anyone know why this is or if there's a workaround?  I've tried creating a copy of the file, deleting the asterisks, pointing to that, then adding them back in but of course the workbench then cant find the columns. Since its an automattically produces xls file, I can't edit it manually everytime so what I need is for the FME workbench to ignore the title line and read all of the attributes as they are.  Thanks

Hi,  I have a workspace that reads features from Oracle, does some processing, and then uploads back to Oracle.  I'd like to name the feature that is written back to be the same as that which was read but with the date appended.  Is this something that possible?  Thanks for your help

Hi,  I have a table in Excel as in Fig. how to arrayed all numbers in the second row? 

I have a versioned ArcSDE annotation feature class in prod SDE database. It is to be updated from an unversioned annotation feature class in the staging SDE database. The staging annotation feature class will be built from scratch each month. The staging and the prod have the same attributes. The production is versioned because it is slightly edited and also archieved in ArcSDE. I can't think of a way to do this update in FME. I can use fme_db_operation and "Write Mode = UPDATE", but there is no common update key fields between the staging annotation class and the production annotation class. I tried using "TEXTSTRING", but it does not seem to work.

Hi all,  Just upgrading to the pro edition, and what a edition! :) Using the WFS reader to update a table in our local database (postGIS). So far so good. I want to run the workspace as a batch updating the table every night, which means I want to delete the content of the table before updating it. Somehow this dosen´t seem to work. I tried to google the answer, setting the parameter in the postGIS writer to UPDATE. Not working. Something I´ve missed?  I´m using FME 2014 SP1  Christian  Link to Workspace screenshot:  https://dl.dropboxusercontent.com/u/8365323/WFS%20%E2%86%92%20POSTGIS.png 

Hi,  I'm currently using the new ArcGIS Online Feature Service writer. It does write something, but the problem is that it doesn't create a Feature Service but it writes a (downloadable) shapefile on ArcGIS Online. From the webinar http://www.safe.com/webinars/how-to-leverage-arcgis-online-with-fme/ (http://www.safe.com/webinars/how-to-leverage-arcgis-online-with-fme/" target="_blank), I was under the impression that this should actually work: it seems to create an actual feature service there. I am writing to ArcGIS Online as a Publisher. According to ESRI's documentation, this user type should have privileges to create a feature service. Does anyone have any suggestions about this?  Thanks, Sander

Hi Everyone,       I just recently upgraded from FME Desktop (32bit, windows7) 2014beta to 2014 SP1Beta (build 14277).  I have a few translations that are run daily and they use the Google Fusion Table (non spatial) reader to take in records and then add records.  I know this translation was run after we upgraded and it worked, then about a day or two later the log entries stop (in the fusion tables) and today I get a report that the translation is failing.       I tried resetting the reader and writers (as this has helped in the past with fusion tables), but I get to the point of refreshing the token (goes fine) and then I go to the 'Table List' [...] icon and it cannot establish connection to get the table list... this repeats no matter how many times I press it.   This is after token successfully refreshed:   Then I try to get table list:   Show Log:   I have tried this on another system with FME 2013 and I also get an HTTP error, but I am not sure if this is due to the fusi

Hi, i have dgn with text  28 362 49 5036 in one layer, and i need to get four layer, so number 28 goes to layer 1, nuber 362 goes to layer 2, number goes to layer 3, and number 5036 goes to layer 4. Have any idea? TNx  

Hi everyone,  I have an issue with a DGN writer where it's not outputting text.  I have generated text using the LabelPointReplacer which successfully outputs the Visualiser however, when I write to a DGN it doesn't write out.    The workspace uses a few tricks to get a work-compliant file.  I've taken the company DGN seed file, attached in the levels I want and made this file the seed file for the DGN writer.  I've used an AttributeCreator to get the data to write out to the correct DGN level and then the DGNStyler to colour by level (also set line weight and style by level).  I should add that when a cell I've called into the workspace via another DGNStyler passes through the process above, it plots, but the text does not.    I have a feeling I need to expose something text related on the Writer or perhaps FME is generating a font that isn't in the writer seed file, but not sure where to look.  Any help appreciated as always.  Cheers!  Amit

Hello,  I´ve a little problem.  I have latitude and longitude coordinates in decimal degrees but i need them with decimal values in EPSG:32717 (UTM-WGS84 17S) for x and y. x=667876.12 and y = 1234564.345 for example  How can i do this?  Thank You

Hi, Is there a way that I can get hold of and use the results from calling a stored procedure in a SQL Executor?  My procedure seems to run fine, but I haven't been able to get anything out of the Result output port of the SQLExecutor.  The stored proc queries a mapping table and returns either an existing id or a newly-created one (or an error).  My SQL looks something like this:  declare   ID number;   STATUS number;   ERRMSG varchar2(128); begin   schema.get_new_id(@Value(obj_id),'@Value(table_name)',ID,STATUS,ERRMSG); end;  Again, it seems to run fine, but I would like to use the output variables ID and STATUS on the feature farther along in the workflow (e.g. to set an attribute value).  Any assistance is appreciated. Thanks! 

Hi all, A lot of work has been done in FME 2014 to improve the handling of null values in attributes in the various Database formats. We are now ready to have customers test this functionality and let us know of any issues that they run into. Full details of the new functionality and the formats which support it are available here http://fmepedia.safe.com/articles/FAQ/Does-FME-support-nulls.    If you are interested in testing this new functionality the latest FME 2014 beta is available for download from http://www.safe.com/beta.     We are interested in any feedback you may have when running existing workspaces in FME 2014, e.g. any changes in behaviour due to the addition of the null attributes. And then any comments on the new options within some of the transfomers which have been modified for FME 2014.   Please send any comments to support via our webpage at http://www.safe.com/supportrequest. We look forward to hearing back from you.   Kind regards, Robyn Rennie www.safe.com/

Hello,  my problem is to read a CSV file without field names. You can find the images mentioned in the error description in the folder "Screenshots" .  It read and process the file " Importbeispiel_100_Adressen.csv " successfully. I use the parameters as shown in the screenshots "csv_parameter_1.jpg" and  "promt_and_run_1.jpg". The expected result ("_target_url") is correct:  "http://fvs72.lgb.local/gdigeokoder/RestService/GeokodiereAdresse?key=zgnsjf&str=Milmersdorfer%20Chaussee&hn=25&hne=&plz=17268&ort=Ahrensdorf&ot=&srs=EPSG:25833"  If I want to read the file "Importbeispiel_100_Adressen_oue.csv" (see "promt_and_run_2.jpg") it does not work. The "_target_url" can not be properly generated:  "http://fvs72.lgb.local/gdigeokoder/RestService/GeokodiereAdresse?key=zgnsjf&str=&hn=&hne=&plz=&ort=&ot=&srs=EPSG:25833"  I suspect the probl

I have a 4 band TIFF image (RGBa), where the "a" band is the near infrared band.  I need to create an RGB image from this where the "a" band is mapped to the Red channel, the Red band is mapped to the Green channel, and the Green band is mapped to the Blue channel.  This would create a "false colour" RGB image that enhances the vegetation.  I'm pretty sure this can be done but I don't have much experience with Rasters and FME.  Any help would be appreciated on which transformers to use. thanks 

There has to be a way, but I can NOT find it. But I have over 500 transformers in my workbench and need to search for readers and writers that appear in the catalog tree on the left. How do i go about doing this? When I do a normal search it just highlights the catalog tree??

I'm unable to use an Esri Geodatabase (ArcSDE Geodb) reader to connect to a SQL Server SDE database. The error I receive is:  Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147215997'. The error message from ArcObjects is: {Version not found ["STATE\\CW0157".sde:DEFAULT]} Please ensure the connection parameters are correct (server=`myhost', instance=`sde:sqlserver:myhost\\myinstance', user=`STATE\\cw0157', password=`***', database=`NHD', version=`sde:DEFAULT')  I can successfully connect with these parameters in ArcGIS Desktop and can even use the Microsoft SQL Server Spatial Reader to connect (but connecting this way isn't ideal because of other issues).  Any idea if this is an FME issue or SQL Server issue?  Thanks, Michael

Sorry if it's a simple question, but is it possible to specify that a Mapinfo file written from FME is 'read only' in the parameters?  Thanks in advance