Data

Hello everyone.I am storing dgn v8 files into postgis database and I am getting confused by igds_rotation attribute. I know what it represents, however the value itself is the part I do not understand. Browsing through documentation I get that "The rotation is measured in degrees counterclockwise up from horizontal" and"Range: -360.0..360.0" Which basically means (correct me if I am wrong) that counterclockwise rotation is [0,360] and clockwise rotation is [0, -360]. I need rotation to always be > 0, therefore I need to normalise the value.Now, I want to convert for example -60° to 300°, which is basically adding 360 to negative angle value.When I inspect the features, I see that the correct rotation behavior is when I add 180 to fme_rotation, not 360 which is not what I would expect.Can someone please explain why FME behaves this way (FME 2017.0). or am I just missing something? Thanks in advance,Radek

We have REVIT model file .rvt and we need to convert Multipatch (3d) .gdb file. Can you help me reagarding this conversion. if you have any demo video's conversion of .rvt to Multipatch .gdb file. So we need to open in ArcGis pro and share the 3D data in ArcGis web portal

Hi FME User!I have a workbench that goes very well on desktop but not on server.We are using FME 2017 (build 17722).The workbench make a query on a SQL database to find some table name and type (it's SDE).Then, I do another query on the same SQL database to check if there is any SDE Lock on the tables I got from the previous query.If I find an SDE Lock, the script stop. If there is no SDE Lock, then I use PythonCaller to delete or truncate or rename those table. To do that I use arcpy (the table are SDE feature Classes).As I said, on desktop, it's clean and perfect! But on server... no error message, just a FAILURE without explanation within the log file.If I disable the SQL Executor, FME Server do the job as my desktop.But as soon as I enable the SQL executor... it fails!I know i can make all this in python... but it was working in FME Server 2014... but no more in FME Server 2017...Any idea?

Hello,I’m getting an error that I don’t know how to handle.Working with dates in Oracle writer, it seems that something wrong happens that convert in NULL the date provided. The date field (CREATEDTIME) is non nullable, so the workflow ends with the following error:error was `ORA-01400: cannot insert NULL into ("CAD_OWNER"."MAPPIN"."CREATEDTIME")'The field is of type “TIMESTAMP(0) WITH TIME ZONE”. So, using sqlExecutor, it accepts value like'05-SEP-18 11:00:00.25 AM' and ends properly inserting the record.I tried to do the same, placing an attribute with the same format in the Oracle writer without success. Also other dateFormatter seems not to obtain good results. I only need to insert a DateTimeNow().Where I’m wrong?Thanks!Roberto

Hi, is there a way to query a csv before it's read into a workspace, something akin to being able to run a sql script on the oracle reader? I have a csv with 2 million+ records but only want to read in 6000 or so with a specific attribute value. I know I could run a tester but would rather not read them into the workspace.

I am very new to FME and was wondering if it's possible to convert las/laz files to kml directly. Apparently it's not a straightforward process and I'd appreciate any suggestions on what transformers to use, in what order, etc. Thank you very much in advance!

Hi FME experts,I have two Excel files. One has 4 worksheets and the other one has just 1 worksheet. I want to combine the two Excel files into a single file, basically copying the 1 worksheet in my second Excel file and paste it into the first Excel file while preserving the formatting on each worksheet (I can combine the two Excel files into one, but just couldn't preserve the formatting on the worksheet from the second Excel file). The desired result should be a single Excel file with 5 worksheets. And each of the worksheet should have its original sheet name and formatting.Here are the two sample Excel files if anybody wants to give it a shot.Thanks in advance!Henry

Hi, I am using a WFS reader and would like to change the credentials at a later stage. Is it possible to do this after the reader has been added, currently I don't see any method to do so.Thank you,Oliver

I am a FME beginner, trying to load timestamp before the year 1000 in a Vertica database, using JDBC driver.Using:@DateTimeParse(@Value(myDate), FME)an error raise: Table1_FeatureWriter_c058446b_6d16_48db_85ad_d913e88f07e526: '1' is out of range for 'year'. Range of 'year' is from '1000' to '9999' Table1_FeatureWriter_c058446b_6d16_48db_85ad_d913e88f07e526: Failed to evaluate expression '@DateTimeParse(00010101000000, FME)'. Result is set to null How to insert those dates?Many thanks, best regards.

Bonjour, j'ai bien lu l'article "How to setup an Oracle Instant Client for use with FME" mais la version 2017 de FME ne trouve pas le client Oracle alors que la 2014 toujours installé trouve bien le client Oracle. Que dois je faire ? Par ailleurs, le client Oracle fonctionne très bien avec d'autres logiciels.Merci--Hello, I read the article "How to setup an Oracle Instant Client for use with FME" but the 2017 version of FME does not find the Oracle client while the 2014 still installed finds the Oracle client. What should I do ? In addition, the Oracle client works very well with other software. Thank you

Hi,I have some old mapinfo files from approximately 1996. The log says it "Failed to obtain any schemas from reader 'MITAB' from 1 datasets". The files should be OK in that they were taken directly from a CD product. The CD did require registration, but the statistics agency no longer sells the CD or issues any registration numbers, so I can't access the data through the MBX on the CD as intended by the product.Does anyone know how I can see the data? I don't need any geography, I just need the data tables.I've attached some of the files.Thank you for any assistance!

I am trying to pull in a service from our organizational AGOL site (Enterprise Login), but cannot verify the connection.Where do I get this Client ID, Client Secret, Redirect URL information? And how to I input it into the web services? I can't change what's there by default and when I click the upload button, I get a window that's for FME Server, not AGOL. 

I am having issues with FME reading the Band Value incorrectly or applying a conversion.

I am trying to read some kml files that were exported from Avenza PDF maps. The KMLs contain Lines, Points, and Tracks. I am able to read the lines and points just fine but the tracks are not output from the reader. Is there some way of exposing the Tracks?

Has anybody written a workspace to grab the users, roles, access of FME Server to write out to an external location like SDE table or excel? Is it even possible?

I am trying to use the FME Cesium 3D Tiles Point Cloud / 3D Tiles writer to write a .PNTS file in a 3D Tileset for display in Cesium JS. I would just like to know, whether in FME it is possible to set per-point properties in the .PNTS file's batch table. How can I do this? I will be storing an attribute called 'importance' along with every point that is essentially just that: the importance of the point for the purposes of rendering in a browser. I want to show more important points close to the observer location when viewed in Cesium, and progressively lesser important points farther from the observer. As the batch table stored per-point metadata, I need a way to modify the information contained in the batch table of the .PNTS file. If there is also any other way of doing this without having to modify the batch table, I would appreciate if anyone can let me know. Thanks!

Hi I'm trying to use FME to create cesium 3D Tiles tileset of buildings, including attributes. In the specification of b3dm format, it's done using property named batchID, witch makes it possible to assign verticies to defined batchID and assign attributes to it. It makes it possible to have single model with many buildings to have good performance, and still have possibility to read properties of individual buildings. In my workspace i have properly defined buildings and i can see, that in the inspector thay are viewed correctly. Each building is separate from others, and has its own properties. However, after exporting to Cesium 3D Tiles, the models are combined and entire tile has properties from first object in tile. Are there any extra steps needed to make it work? Do i need to define batchID manually?

I'm trying to use an ArcGIS Server Feature Service reader to pull data from feature services on a Server running 10.3 and write to an SDE using the Esri Geodatabase ArcSDE Geodb writer. I have a workspace that was created in FME Workbench 2016, where it still runs fine. I'm trying to run it in Workbench 2018.1 and I am getting Python errors stating that one of the modules is missing an attribute:" Python Exception <AttributeError>: module 'html5lib.treebuilders' has no attribute '_base'Could not create Python Reader `ARCGISFEATURES' "I upgraded to Pro 2.2.1 and have the workspace set to use Pro 2.1/2.2 Python (3.6). I'm assuming that since I have 2018.1 and Pro 2.2.1, they should be compatible and all the Python libraries should be up to date. I've tried updating the reader, and I get the same error and it won't update. I've also tried digging into the Python files and finding that module, and it seems to have a "_ba

I want to write an ifc file where all objects get a guid from the source.In my source dataset (rooms) there is already a primary key (in guid format). I want to keep this key in the exported objects (IfcSpace). I have tried to set different attributes with this value (ifc_id, ifc_unique_id, GlobalId), but the ifc writer always generates a new guid for each object.How can I arrive to export an already existing guid for each object?

Hello All We are converting some City GML 3D models in Esri Shape format. During the process we receive an error message : DBF Writer: DBF file exceeds maximum size of 2 GBError running translation.Any solution is very much appriciated

HelloINSPIRE GML writer has a parameter to set "Maximum Decimal Places: ...." CityGML writer doesn't seem to have this setting.Is there a way to somehow limit the decimal places in the coordinates of CityGML output ?This is a requirement in Germany and I don't see how I can achieve this in an easy way ...ThanksMichael

My aim is to get a nice DEM out of my severeal xyz files. I was hoping to be able to generalize the files and save some time when running the RasterDEMgenerator . Any ideas for doing so? I have tried e.g PointCloudThinner and Generalizer but they dont seem to accept my input.

As soon as I try to fan out data to windows folders the KMLStyler no longer works. I expect the "Style" feature is no longer written to the KML file at all. I have no idea how to fix this. I have a simple example which works when I remove fan out. I fan out to a folder based on an attribute in a clipper and create a kml in that folder with the a name using fme_feature_type. Thanks in advance, Ian

I have a workflow that needs to bring data from an ESRI geodatabase, do some standard transforms, run a complex Excel model, and summarise in a final Excel output. Clearly FME will write to the model input sheet. But can I get FME to run the model as if it was a transformer, then pull the results out to the final summary? Thank you.

About possibility in FME Workbench to write in Microstation DGN XFM format, linear elements (polylines) with attributes for a dataset that have lines with elements but other format not supported by Microstation. I need to be able to see in Microstation Bentley Map the polylines and their attributes. Currently, I have the lines and their attributes in MS access format for Geomedia and ESRI and would be great to be able to export them in DGN with XFM attributes. DO you have any advise on that? Thank you! Lavinia