Data

So I have a collection of 50 Tiff files (historical aerial images). Metadata exists in a separate file, and I get to choose - CSV, XML (FGDC), or KML for the Metadata (I have the metadata in each of the formats.)Metadata includes: Raster Filename, Lat/Lon of image centers, Lat/Lon of each image corner, as well as some more specifics on the image collection. My question is- how do I combine the metadata with the raster files and write out to GeoTiff?I tried FeatureMerge and the data inspector shows what I expect to see after the merge- raster files that have a feature table. When I go to write the files, this "feature table" (metadata information from CSV, in this case) disappears.What am I doing wrong here?Thanks,Andrew

Hello,I'm struggling with an integration problem.I've published a workbench in FME server that must be called from an external application.The standard URL of the published service is like this:http://11.111.111.11:8080/fmedatastreaming/sample/FindAddressCandidates.fmw?param1=AAA &f;=json&maxLocations;=&searchExtent;=&category;=admin&POI;=fme123&outFields;=&forStorage;=&outSR;=while the external application can only call the service using the following URL (without ".fmw" extension)http://11.111.111.11:8080/fmedatastreaming/sample/FindAddressCandidates?param1=AAAIs that possible?Thanks in advanceRoberto

FME(R) 2018.0.1.0 (20180518 - Build 18310 - WIN64)If you set reader parameters and then change filename (as workbench is published to server) all of the ranges and other parameters are lost and workbench fails. For example setting read at row 2 to skip headers fails.

Hello,I am new-ish to FME and primarily used model builder for previous needs which may show in how this model was created.So I am reading from .sde, changing some field names among other things and outputting the data to both a kmz and to individual shapefiles to a zipped folder. Not all of the feature classes have NFID within their table so I am using this parameter not only for the output file names, but also to select the line with the specified NFID and then buffer to select surrounding features.I created this to run for one project at a time using a parameter NFID which is basically a project name/number to select the correct data and to name the output folder and kmz file. I want to expand this further and have it run through ideally a list of NFIDs and ultimately read from a good sheet and run based on those values when project status is updated in the table but that will be the next step once I can get this to reset and run for each NFID entered. Current Process: input projec

I have an oracle .dmp file from FRAMME data and I have no way of reading the data. Can anyone help me with this?

I am looking to write to word doc using the new wordStyler transformer, the images with their header, the problem is I am getting all header together then images. Attached the WS as referenceThanks

i have a line of 1500 mts, and i could trim it in different parts (the same longitude), and now i calculate the statisticscalculator sumary the vertex of each line (first and last number point), to know what is the value of the last poiny of each line. if i know what is it, what can i do to search in each line by these value, because each line have diferents point.if some one can help me, thanks for all :)

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