Data

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

I am writing to about 100 feature classes through an SDE writer and about 5 feature classes return the error:The error number from ArcObjects is: '-2147216072'. The error message from ArcObjects is: {Underlying DBMS error [ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column]}Looking on Oracle websites hasn't resulted in a solution: I hope someone here has a suggestion how to solve this.

I'd like to delete an element from my table in my Oracle database. I already saw the post https://knowledge.safe.com/questions/5205/delete-f...But it doesn't work.This is my sql query : FME_SQL_DELIMITER ; DELETE FROM G_ADT_AGRI.EXPLOITATION WHERE SIRET = 37969607300012I tried without the FME_SQL_DELIMITER, with the semicolon, with the number between quotes, but it doesn't work anyway.Please, give me some more ideas.Thanks

Hi all, i am creating a summary report of a larger workspace output in excel. I use 3 stats calculators and a sampler to output what i want to excel. Currently the outputs are going to individual sheets in my output xls file. I would like them on one sheet. Can this be achieved? I have tried the "named ranges", "starting columns" etc etc. When i try and name my "Sheet Name" on the writer the same as another is appends 00 to it because it clashes? Any help appreciated or is this not possible ? Thanks Steve

I have a GDB with a road in it (themes are: road signs, traffic lights etc.). I have new measurements from the road in Shape (containing existing and new features). I have two GDB writers per theme: one to update the existing features, one to insert the new. The readers point to the same file and the writers point to the same copy of it.After a while the Writers become '<not set>' in the Navigator pane:Along with some translation warnings:Geodatabase Error (-2147024894): The system cannot find the file specified.Could not open File Geodatabase dataset `D:\\Data\\N207\\EXPORT_BUDATA_20160202_164111.gdb' for readingThe issue is resoved when the writer is deleted and loaded again but after a while the issue returns.FME version is 2016.1, 32 bit.@nielsgerrits

I have an excel file of points which are resurveyed with updated Coordinates.Now i want to update my existing arcsde geodatabase. How can i update only coordinates in FME.

There seems to be only 2 posts on here about writing to PostgreSQL bytea, and in both cases, @NatalieAtSafe has said there's a known performance issue. How about for reading? Can FME read a table column in this format? If so, how do you do that? (The data I have stored is a dwg file.)ref: https://knowledge.safe.com/answers/28700/view.html

Hi there,I have 4 FME workbench files on Win2008 server and execute those workbench files using a batfile.I can run the batfile without getting any errors but USER2 cannot run this bat file.User2 get following error.## Start translation ##  FME 2015.1.3.0 (20151105 - Build 15570 - WIN32)  FME Desktop Oracle Edition (floating)  Permanent License.  Machine host name is: WBV-GCS-P0011 Operating System: Microsoft Windows Server 2008 R2 Server 4.0, Enterprise Editio n 64-bit Service Pack 1 (Build 7601)  Copyright (c) 1994 - 2015, Safe Software Inc.  Safe Software Inc. Error connecting to Oracle database: message was `ORA-12154: TNS:could not resol ve the connect identifier specified'. (serverType=`ORACLE8i', serverName=`vmesde v<at>gisap.world', userName=`', password=`***', dbname=`') Program TerminatingTranslation FAILED. ## End translation Closure_GB_NI ##User2 is Administrator to this sever and can connect to Oracle Database using sqlplus. But User2 ca

I am a new FME user. We have a GIS layer/table with SRIDs in 8307. I am trying to #1. Trying to make a copy of this 8307 layer as such into an Oracle Spatial DB#2. Trying to reproject to another coordinate system