Data

Is there a way I can use the Attribute transformers to read the exif data from a JPEG and record it into a text file or spreadsheet?

Hi All, I am using ESRI Geo-database (10.4) Writer that updates a feature class in a geo-database (hosted on SQL Server). I have business requirement where if there is an error during writing there are no records committed. I found a property on writer: “Commit Transactions at the the end of the write” and set it to yes. During one of the runs, there was an error while writing, I was expecting that original state of feature class would be maintained but that didn’t happen. I am not sure what I am missing here. Are there any change required on geodatabase side for this. Appreciate any feedback.Thanks Jay 

Hi,Yesterday I started a Workspace which is taking a lot of time to process. About 24 hours up to now. I didn't save the workspace. I'd like to inspect the log file to see if I could find a potential problem and also see the time spent on each operation. Is the log file saved somewhere. Thanks,Simon

Good morning FME'rsDoes anybody know about a clever way to create relationships between tables while writing to an access database?

Hi FME'er,I have CSV data that is stored in a table in Oracle. The data is created using a stored procedure and is stored in a single field with one row per line. I would like to read and parse this data as a CSV file into FME for further processing. I figured I would start by aggregating the field (attribute) into a single row but don't know where to go from there. I can't use the AttributeSplitter because it uses " qualifiers around data that has commas.  Many Thanks,David

Hello all,I uploaded an IMDF file of for a building to Online IMDF Validator and received a validation report. But I found something wrong that some warnings were confusing because every Unit feature must has an unique ID.(below table) But it showed me that their ID were none.I appreciate any guidance!Thank you!Feature Type | ID | Category | Level | Validation Error unitNonestructure01ca9f36-6b0e-48ab-92c0-43af7fdb417cWarning|Display-point not within Unit.unitNonestructure01ca9f36-6b0e-48ab-92c0-43af7fdb417cWarning|Display-point not within Unit.unitNonestructure2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonestructure2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonewalkway2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonestructure2110f506-1b2b-4679-8bd8-cef2257861f4Warning|Display-point not within Unit.unitNonestructure3cb84699-b393-4bcf-ad15-06fb37fcaa55Warning|Display-point not

We have an Oracle RAC cluster with 8 threads each for two nodes. It appears that the Oracle driver (non-spatial) runs out of threads on the first node, but never falls over to the second node.Is there a way to configure the FME workflow to do this, or perhaps the driver itself? We have intermittent failures during our overnight process that magically "fix" themselves the next time this workflow runs. And after a lot of testing and trial-and-error, we came to the conclusion that the 8 threads on the first node are probably filled by other processes, and FME gets denied access because it never goes over to the second node. The error we get (not exact wording) is that the data source is unavailable.Has anyone experiences this and has a solution or a hint at what might help?Thanks!

Hi folks,I am quite new to 3D Data-Modelling with FME... Now I must convert an e57-dataset into TrimbleSketchup. Uhhh, have no idea how to... Just adding the e57 reader and an skp-writer doesn't really work...Can anyone give me a hint about the neccessary steps?Thanks in advance!! :-)

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?