Data

Hello FME! I have some data in the Esri shapefile format that consist of rivers and lakes, using data from Kartverket.Originally they were in the SOSI format, used by Kartverket. What I've done is that I've taken the polygons and the polygonlines and converted them to the Esri shapefile format using QGIS. What happens after I add them to my workspace and let them combine with the DEM, is that they won't drape, and they also seem to remove/hide some land from the DEM if it's on the same level (or below it)I looked at the example from Bowen island, but it required some additional data.Workspace:http://i.imgur.com/6wwtHgr.pngThe world with lakes and rivers:http://i.imgur.com/u7FiZ1h.pngWithout:http://i.imgur.com/rAma8dN.jpg

Hi All,I have a Workbench and running it in 2014, it work perfectly reading from AGOLbut since i've converted it 2016.1 it fails reading. There no option anymore for the datasetBoth instances options are set use system proxy.

Hi,I apologize for the previous post on reducing the ECW linked with dysfunction of my PC. I would reduce the size of an ECW file 10GB composed from images in 24-bit to 8-bit.  Would you have a solution?Bests regards,

Hello,  I'm using the AutoCAD Real DWG reader to read in a dwg which contains an XREF.The xref, (dwg) is in the same folder as the main dwg and resolves when opened in AutoCAD.The "Read External References" param in the workspace is set to Yes.When the features enter the workspace the xref has an autocad_xref_status of unresolved.I use the "Explode Blocks into Entities" param so I can output to DWF and toggling this param has no effect on the xref.I've changed the path options on the xref in the main dwg; none of which makes a difference.Looking for ideas on how to overcome this limitation.Thank you in advance!Brek

I have a polygon shape file containing a few dozens of rows. How can I split the shape file into many shape files, each containing only one row?

I have tried PoinOnRasterExtractor but this does not work. I have tried to use the PointCloud transformers but still no luck. I must be missing something but can't see it.

I would like to add Layers to my Geocortex Essential Web Map, via a Geojson in FME. What Writer should I use to connect and configure?

I'm trying to write to different columns using the XLSX writer. I want my first group of features to be written in the first column, second set of features written in the 2nd column, etc...I think this should be possible using the writer's "Format Parameters > Sheet Settings > Row ID Attribute" and "Format Parameters > Start Position > Start Column".I'm having trouble dynamically assigning the former. I think I can use the Count function here, but I'm not sure how to reference the feature's (only) attribute's name to use as the domain name for the count.

I have a 3D building model done in Revit. My objective is to export it in a cityGML format with a LOD 2 and LOD 4. I wish to have only one workbench that can generate either the LOD2 or the LOD4. I am using the BIM to GIS Advanced Tutorial workbench. It work great for my LOD 4. To achieve the LOD 2, I disable some of the writer and it work great, except that my external walls have holes for the windows and doors, or in LOD2 we wish to have the walls plain.If I export the revit file in IFC format, in the reader parameter, I have the option to omit the openings but if I export in rvz format there is not such option in the reader parameter.The BIM to GIS Advanced Tutorial workbench does not work if I used a IFC format as reader, so is it possible in the rvz format to overcome the opening generated by the windows and doors?

HiI have set of Details filled in the excel.i have to connect the Excel in the dgn. for example In my Excel door no was 15 it contains 32 details. in my dgn also the level door no was 15.i have to connect like this,in ArcGIS term like Join and Relates..Advance in Thanks

I have photos attached to a feature type in AGOL and I need to extract those photos. When I read that feature type in FME I don't see where I can expose those attachments. I am only able to view and write the feature type attributes. Is there a way to exposed the attachments to export the photos as .jpg?

Hello All FME Users,I have a workspace and the KML generate a attribute above the icon ( i dont want this schow this attribute ):My Workspace has a transformer KMLPropertySetter.Attached my template file.Thanks in Advance, 

Does anyone know what I need to do to read microsoft access db on fmecloud?I am getting the error message below, do I need to upload a DLL to the plugin folder? thanks in advance! Creating reader for format: Microsoft Access 45 INFORM 0.0 0.2 Today at 00:02:22 Trying to find a DYNAMIC plugin for reader named `MDB_ADO' 46 LD_LIBRARY_PATH is '/opt/fme-engine-2016/plugins:/opt/fme-engine-2016/fmecore:/data/fmeserver/Server/lib/fmeutil/fmecore:/data/fmeserver/Server/fme/fmecore:/usr/lib/oracle/11.2/client64/lib' Could not load module '/opt/fme-engine-2016/plugins/fme_ado.so' : /opt/fme-engine-2016/plugins/fme_ado.so: cannot open shared object file: No such file or directory Could not load module '/opt/fme-engine-2016/plugins/fme.so' : /opt/fme-engine-2016/plugins/fme.so: cannot open shared object file: No such file or directory Could not load module '/opt/fme-engine-2016/plugins/mdb_ado.so' : /opt/fme-engine-2016/plugins/mdb_ado.so: cannot open shar

Hello all,I have a workspace that generate a KML file with Folder and Subfolder. The problem is doenst write nothing points inside the Subfolder.Thanks all :)

I am using the Esri ArcGIS Online (AGOL) Feature Service writer and can connect to ArcGIS Online and see existing feature services. However, when I try to write a new feature service I get an error: User folder does not exist. I have copied the folder name from the existing folder names that the writer shows. How do I write a new feature service to AGOL using FME?Thanks

Does anybody know if it is possible to trigger a SQL Server SSIS package from an FME workspace?I have FME Professional Edition but not the version that can write directly into Microsoft SQL databases so I was hoping that a workaround might be to carry out the required transformations using FME, output the results to a file and then have SSIS pick up the file and import it into the database. It's a long way round but I haven't got a hope of getting budget approval for and upgraded version of FME (that would make life far too easy!)I'm not a python programmer but was thinking that maybe the Shutdown Python Script might be of help here?Many thanks

I'm using a SqlExecutor deleting some data in a Oracle database.FME_SQL_DELIMITER ;--feuille 1DELETE FROM G_ADT_AGRI.EXP_INVEST WHERE OBJECTID = @Value(OBJECTID);/*--feuille 2DELETE FROM G_ADT_AGRI.FON_BATI WHERE OBJECTID = @Value(OBJECTID);*/As you can see I commented the "feuille2" part. But I have this error message : An error occurred while accessing a table result for feature type `QueryFactory_SQLExecute'; message was `Execution of statement `/*--feuille 2DELETE FROM G_ADT_AGRI.FON_BATI WHERE OBJECTID = 699' did not succeed; error was `ORA-01742: comment not terminated properlyAlthough I use the right comment syntax. What did I miss?

Hi,I have several workbenches which read an FGDB, do a little transforming and renaming, then insert the data in several Oracle tables (one table per fetaureclass, 15 in total). Before the data is written, the tables must be emptied. The trick is that the user is not allowed the privilege to use truncate (if you give an Oracle user the privilege to truncate, that user can also drop tables - which is not allowed). I have a procedure which allows me to truncate, using a different user, but it looks like I would need to call that procedure 15 times in the "SQL statementto execute before translation", instead of adding it to the format parameters of every featureclass. Is that correct? Not really what I was hoping for, but if it needs to be done it needs to be done :-)

My current employer is converting from using Microstation to AutoCAD and I was wondering if anybody can give me some advice.  I'm looking at many DGN files to convert to DWG and i'm concerned all the cell's in Microstation will get dropped in the process.  I'm not sure how the conversion process will convert the cells data into blocks?  Are their certain library's in AutoCAD that need to be prebuilt?  Any assistance would be greatly appreciated.  

Hi FME'ler,I have a CSV-Reader which is optionalWhen starting the workbench and leaving this reader blank it fails:Does anyone know about that issue?Thanks in advance, MariaFME Desktop: 2016.1.0.1 (20160516 - Build 16494 - WIN32)

Hello! I have a very large kml (~100MB) published by Land Information New Zealand with thousands of tracks included in it. What I am looking to do, is to break that up into individual kml or gpx files. Is this something FME can do?

Hi,I have dgn file which cells as shown belowEach circle and number will comprise one cellI'm converting dgn file to dwg, where I'm facing problem in defining block name...Im getting the block name as shown below...when I have activated Use the Block Name to Create Blocks to yes then block name is right but the text sting value is wrong and coming same to all the textscan anyone help in this regard...Thank youPratap

The danish social security number are build up like (ddmmyy-xxxx) where xxxx is a unique code. I have a dataset from a xlsx-file, where the danish social security number are like (ddmmyyxxxx) AND if the date startes wtih 01, 02 ect, then it cut the zero of. I need to make FME read the xlsx-file and change the danish social security number to this format (010180-1234) and write it to my PostGIS-DB.I hope someone can help me with that.Best regards, Jacob ArpeKalundborg Municipalty

I couldn't find an answer in the help, so I'll ask here:I'm using a WorkspaceRunner to call a sub-project. And now I'd like to all save the project as .fme files before handing it on. But how does it work with WorkspaceRunner and .fme files? When configuring the WorkspaceRunner, it seems to be ok with a linked .fme file, but the parameters are not displayed in order to configure them. Is there a way to call and configure .fme projects within WorkspaceRunner? Or do I have to stick with .fmw for the sup-project?

I have been testing out the featurewriter transformer to handle data updates, however I have noticed that it is much slower than the equivalent standalone writer. For example, I am trying to write 80000 records to a SQL Server Spatial database table using the featurewriter. This task takes just over a minute (1:27) with the SQL Server Spatial Writer and over 10 minutes with the featurewriter transformer. The parameters are identical with the exception of those that you are not able to set with the transformer (bulk insert, tranaction interval, timeout, etc.). Is this just a flaw of the featurewriter or are there ways to improve the performance of this transformer that I have not implemented?Thanks