Data

Does FME Workbench 2013 have the ability to handle oracle exceptions without terminating the entire transformation?  Currently, the transformation encounters an oracle exception (on insert) and stops.  I'd like to log that and continue with the loading from a geodatabase file to the table with a spatial column.  Any advice or direction would be helpful.   Thank you in advance.  -abe

I would like to be able to make the Field Names Row (not Start Row) property in the Microsoft Excel Reader Parameters dialog a User Parameter so that users will be able to specify a different header row if the format of the Excel file is not entirely consistent.  This will ultimately be a published translation in FME Server. Is this possible or is there no way to make a parameter in that dialog a User Parameter?  Can anyone suggest a possible work around?  Thanks.

I have two main drafting workspaces in Microstation; Civil and Survey. Each workspace has a specific set of levels that it uses. I need to map these levels to existing feature classes in a ESRI file geodatabase. There will be many reader files, but all will use the same level names. For example, design file XX01.dgn comes in and I set up a workspace to translate level names to the appropriate feature classes. Then design file XX02.dgn comes in and want to use the same workspace to translate the levels contained in XX02.dgn (which all have the same names as the levels in XX01.dgn) without having to connect each level name to the feature classes again. The drafting workspaces contain several hundreds of levels and I've already created  test FME workspaces for Civil and Survey features to make sure all level translate correctly. Is there any way to format an FME workspace such that for any reader/design file, map these level names to these feature classes using these transformers?

I am trying to write raster data to a postgis database.  I have a postgis spatial database and want to load raster to it. So far I have a PostGIS Raster Writer and have created the database in Postgis. When I run it I get the error message below in the log file.   2015-05-11 12:08:18| 1.4| 0.1|ERROR |POSTGIS_RASTER writer: This format cannot support palettes. Consider removing or resolving palettes that are attached to the raster   Any ideas on how I can load raster into Postgis would be appreciated.

Hi, I couldn’t figure out what’s going on with the ESRI file geodatabase writers, Here is a workbench that was set to use 2 writers ( Esri FilegeodatabaseAPI, and shape file). The translation was successfully finished (21 features was written to both writers). Now when I go to ArcMAP I found that the shape file is correctly generated with 21 features on it while the feature class that was stored inside the file geodatabase API is empty. What is the issue here ?       Here is the workbench and all of its related data, in the case of your intrested in testing this issue. http://www.mediafire.com/download/9rwdwe1tk5y9hj7/UMP.zip  Regards, Ahmad 

Hi everybody,  I have run scripts (.bat files)  with FME 2014 without  problems, but after the update to 2015 and make some changes in my workbenchs these  files don't work.  This message appear: "This FME edition does not recognize the 'RoutingFactory' factory. What means that? and how can i run my tasks?.  P.S My .bat files run 2014 workbenchs yet. How can update my .bat files to run 2015 workbenchs?  Thanks

Hi,  I've got a SDE30 TABLE with 1 attribute: the project name and the shape (a line).  I would like to handle every project as one feature (for many purpose).  So I did this.  Reader -> Aggregator (on the project field)  My problem is that I've got millions of lines of many thousand vertex each; it's big !  I would like to sort the reader so I can select "YES" in the aggregator "Input is Ordered by Group".  Any idea how I could do that ?  

I have a workspace that uses an XLSX writer and fans out by a given attribute that represents the names of waste collection rounds. The writer uses a template to specify the named range that data should be written to, and replicates that template across the numerous sheets it creates with the fanout.  What I'd like to do is specify the order of the sheets in the workbook so that they sort alphabetically, but as the workspace determines the sheets to be written (based on the round name attribute) I'm not sure how to specify this on the writer. Does anyone have any suggestions?

Hi, Could anyone know How to convert (rlc) image format to other format detected by ArcGIS?   Thank you, Rawan 

How to convert the feature classes stored in SQL Server database to file geodatabase,   I couldn’t figure out the best practice to convert the the feature classes stored in SQL Server database to file geodatabase.     Thank you   Best   Jamal

“Replacing” the results obtained from the workbench with the existing ones,   I wanted the outputs of the workbench to be replaced with the existing ones. This works fine if the “table handling” is set to be “truncate existing”.  However, if the “no existing” data is available, then the workbench fails to write the outputs.  Is there an option that can “replace” and “create” (if no existing data is available) the outputs?     Thank you   Best   Jamal 

Converting ESRI feature classes saved in file Geodatabase to shape files (in one folder),   I couldn’t figure out how to convert ESRI feature classes saved in file Geodatabase to shape files (in one folder)     The file geodatabase is saved here http://www.mediafire.com/download/6x08lo3h64o0pz8/H.gdb.zip   Thank you   Best   Jamal 

Hi all,  Is above question possible?  I try to use a parameterfetcher like this:  @Value($Iterationcountattirubte) but it is always missing, at each itereation.  Can this be done using python or tcl (like some GetMacroValue) or something. Or is it simply not possible?  The logger seems to report the count, so should it therefore not be accesible?

The need to add *.gdb before storing each CAD layer in single feature class in it,   I wanted to convert each single layer of AutoCAD into a single feature class stored in one geodatabase. The gdb destination is added to the workbench but with no use as it appears in the screenshot below. Is there a way to delete it from the workbench while still be able to store the feature classes in it?     Thank you   Best   Jamal

The need to creating *.gdb before converting dwg files to ESRI feature classes,   I couldn’t figure out if I need to create first *.gdb I order to be able to convert dwg files to feature classes stored in file geodatabase. Does this mean that I need to have ArcGIS, for example, installed in my machine to do so?     Thank you   Best   Jamal 

OK this has been asked before but the answers I've seen did not resolve the issue. Has anyone encountered this error message when running FME Server?  Unable to perform any licensing related tasks.  This is a 64-bit version of FME which requires a 64-bit version of ArcGIS Server  What makes this strange is they are both 64 bit versions. Is this an ArcGIS setup issue? Any help would be greatly appreciated.  Thanks! Tony

I need to build a list of new records that have the NEXT value for an alphanumeric primary key attribute. Thus, I need to fetch the largest value ( in the form 'ADR000xxxxxxx' where "xxxxxx' is a strictly ascending list of non-zero intergers) from one feature class and populate another (temporary) feature class starting with *that* value +1 .  Thus, let's say my ADDRESS feature class has the largetst MXADDRESSCODE = 'ADR000521327' And I need to create, for instance, 4 more records. So I need to fetch the above 'ADR000521327', add one to the first, making it 'ADR000521328' and continue with 'ADR000521329, 'ADR000521330, etc. in my temporary feature class named ADDR_WORK. I have looked at Sorter, ExpressionEvaluator, AttributeFilter, StringConcatenator, and others, but just can't seem to turn the corner on this one.  Thanks 

I'm trying to retrieve photos stored in a non-spatial SQL Server table in a varbinary(max) column, input37_bin:  The photos are JPEGs, and the varbinary column is recognised by FME as a field of type IMAGE. I connected a RasterReplacer to the attribute with JPEG format but get "not recognised as a supported file format" Any ideas greatly appreciated. Ian

In the workbench below, I wanted to collect the “Boundary” and “Buildings” layers in two feature classes in the same file geodatabase. What the workbench does is that it combines the “Boundary” and “Buildings” in the same feature class.      How this issue can be resolved?   Thank you   Best   Jamal 

 Hello All, FME workbench to transfer data from mdf “Enterprise geodatabase”  to gdb I am trying to develop a workbench that will be able to replace the existing data (FC,Tables,Datasets,…) in a File geodatabase “gdb” by the one coming from the mdf “Enterprise geodatabase”. Is this can be done using FME ? if yes how can I start ?   Regards, Ahmad  

I'm trying to setup a FME workbench process that will run daily which will read a series of text files from a network directory, and load it into a a database.   The header of the text file contains information about the sensor, including a georeference. The body of the file contains readings for every hour of the day. My aim is to create one database table containing the sensor information, and another table containing the readings, with the primary key being the sensor id.   SAMPLE FILE Filename: 55_22_20130626_2359.txt Sensor Id: 55.22  [SEQUENCE] REVISION=1.0 [DESCRIPTION] ID=55.22   DESCRIPTION=Bypass Loop, Central Tunnel                                        GEOREF=WGS84,-33.865977,151.205619 INTERVAL=60 QUANTUM=READINGS [55.22]:STARTS 20130626,00:00,40 20130626,01:00,37 20130626,02:00,27 20130626,03:00,19 20130626,04:00,16 20130626,05:00,29 20130626,06:00,30 20130626,07:00,19 20130626,08:00,24 20130626,09:00,26 20130626,10:00,33 20130626,11:00,34 20130626,12:00,42 20130626,13:0

Hi All,  I am tring to build a model that would delete all the existing tables, Feature classes and Relationship Classes in a SDE geodatabase and then copy new data from another geodatabase. is there a tool that i can use to delete the actual tables and not the records in those tables?  and a sub question, is there a way to create/update/delete domains in SDE?  thanks you!  

I have been asked to make a 3D model of some buildings for use in Sketchup I have Ordnance Survey building outlines with a height attribute and used the extrude transformer to make a model. The problem is that we need each building to be individually selectable/editable but the file i created merged them all into one thing. How can i extrude to individual buildings in one model?  Since I dont know how to do it in Sketchup so thought I would try in FME as it seems to have a lot of 3D tools (i tried using the fanout in the feature properties but this made a skp file for each building and they werent in the correct geographic location - we dont want this)

This is the second time I report this issue without any solution from FME safe, the issue here is in writing to “FileGeodatabaseArcObjects” after upgrading to ArcGIS 10.3. FME safe keeps saying that the FME 2015 is fully compatible with the ArcGIS 10.3, but in the realty it’s not, trying to use the ArcObjects writer fails to write geodatabases after upgrading to ArcGIS 10.3 while it used to succeed in ArcGIS 10.2.2., so each time I try to use the ArcObjects writer my workbench fails and shows the following massage.  “the Esri Product license used by this machine does not include licenses for the 'ArcInfo' licensing level Unable to perform licensing related tasks. Please ensure that ArcGIS is correctly installed A fatal error has occurred. Check the logfile above for details”  Knowing that my ESRI license type is Advanced, as well writing to a shapfile for the same workbench works will. So what is the issue here. Regards, Ahmad 

I'm reading a GIS (LINE) feature class from an SQL database and trying to output it to a Microstation v8 .dgn.The line style I want to output is a fence pattern.  This fence patter is not pre-defined in the DGNStyler.  I have set the linetype in the SEED file and set "by level" in the DGNStyler, but no luck?  This fence style is not one of the standard 7 dash,dash dot...styles.  I'm not sure if I can somehow import that specific style into FME in order to be able to assign it to the output via the DGN Styler, at the moment there is only numbers 0-7 and ByLevel to choose from in FME?.