Data

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. 

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 "prom

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

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(

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.basisd

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 :

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: