Data

I have got a set of polygons as result of my FME processes which I want to write to DGN and Excel (they carry different attributes like area, the country they are situated in etc.). When writing to DGN, the polygons get an igds_element_id I would like to use to identify the polygons in the Excel document as well, so that an user who opens the DGN and the Excel document is able to connect the polyon in Microstation with the respective row in Excel. Is it possible to control the creation of igds_element_ids before writing to DGN (like it is with fme_text_string -> igds_test_string), or do I have to generate an additional ID (is it possible to pass it to DGN?!) respectively merge the igds_element_ids with a second Workbench to my Excel rows after writing th DGN? I'm a little lost at the moment when it comes to find a solution fot this 😵

I've been trying to run a simple test, where I read in a 12D XML file, then write the same data back out. The 12D file is read in successfully, with all expected data and attribution, but when writing back out, there is an issue with the geometry of the included TIN. The TIN feature is written, but is missing all of it's geometry parts. The image below shows the TIN from the read input file:This image shows the same data when output to a new 12D XML file:The vertex pool exists, but with no parts. Anyone have any ideas why this may be happening?

I tried FTPCaller using the full path to the file I want but I am unsure of authentication as it seems undocumented. I am unable to use username and password and must use SSH key files. Setting to ssh-agent seemed like the way to go but how do you choose your key file? I am publishing to Cloud anyways so I thought I would look at what was there and seems there is upload capability for sftp using a subscriber and ftp watcher (no sftp). Am I missing something?

I can see it in the reader parameters (Version From Historical Date and Time), however none of the attributes stick out as the correct one to expose.

Hi all.I'm trying to expand an existing workflow, that outputs Shapes and TABs (and FFSs) just fine with an option to output GeoPackages as well. This does not go well.I'm using dynamic schemas, and merges the relevant schema information onto each feature. Then I use FeatureWriter with "Schema from schema feature" to output the data to a file, to be attached to an email. I normally use ZIP, but in this case I just want to use GPKG.The first problem is, that the writer ignores the request for dynamic schema, and attempts to output any and all exposed attributes.The second problem is that each attributes gets the data type TEXT(200).Is there a trick to have FeatureWriter outputting a Geopackage with dynamic schema ?Cheers.

Hello,i tried to read a mesh model in the format .osgb, but it doesnt work.The osgb-files are made with the SURE Software.As information it says "OSG Reader: Ignoring unsupported node".Regards Isabell 

Hi, are there any plans for implementation of the following raster formats in FME: • USDZ • 3dsMAX • PLN (ArchiCAD) • 3dm (Rhino) • C4d best regards Thomas

Is there a way to read SAS tables without the Stat/Transfer application?

I have two arcgis online feature layers (jobsites and trees) that are in a 1:M relationship. On the trees reader, I've set where clause as "EditDate" >= CURRENT_TIMESTAMP() - 7. The resulting features in this reader have the globalid attribute found in the jobsites layer. I would like to read just jobsites with globalids found in the trees reader. How do I create a dynamic where clause for the jobsites useing a unique list of globalids from the trees layer? So far I've used Listbuilder, DuplicateFilter, ListConcatenator, and StringReplacer to get a list of unique globalid's - '{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}','{28F268A5-7390-4FFC-9EF6-C522D1237ECE}' The first issue is how do I make the string sa

I am tyring to insert into a PostgreSQL table where i have a primary key defined as serial (auto increment).   I want the database to increment this field and not have to supply the value from FME.  FME keeps failing due to the Null constraint on the field.   I have tried suppling 'DEFAULT' and 'NEXTVALUE('Seq_name'") as a string to attempt to fake it however both complain that an integer is expected and not text.    I am using FME 2011.  Any suggestions?

I have a jp2 and jpw file. Reading the jp2 results in the data inspector showing the resulting data in the wrong location. How can I fix the location? I've tried setting the coordinate system on the reader but that doesn't fix it. I know the j2w file holds information about the location of the jp2 but I don't know how to read it along with the jp2. I know I'm likely missing something simple so I appreciate the help.

I've created a workflow to update, delete, and insert new records to an hosted feature service. The delete and update have been throwing log errors like:ArcGIS Online Feature Service Writer: 'updateResults' error for a feature in 'Job_Line'. The error code from the server was '1019' and the message was: 'The specified feature could not be updated or does not exist.' In the reader, I'm making sure to include arcgisonline_globalid and arcgisonline_objectid in the format attributes window. These appear in the Joined output for the FeatureJoiner (for updates) and the the Deleted output of ChangeDetector (for deletes). I'm really scratching my head as to how to the OBJECTID's can be incorrect in the writer when the reader is the same online source. The parameters for the Writer have Use GlobalID = No and Preserve GlobalIDs=No.For the layer, parameters are set to Writer Mode =

FME Desktop 2020: How to concatenate based on a particular field when working with “AreaOnAreaOvelay” tool? When performing the “AreaOnAreaOvelay” tool, I wanted to create a field at which the values of the “autocad_color” field are concatenated as per the screenshot below. How this can be accomplished?           

Hi. I need to convert V7 dgn file to work in V8 Microstation. I don't know how to do it. Im new to the FME. If someone could give me instructions on what buttons to push? :D

I receive an empty shapefile from our client and if I don't add any features, have to rename it.Since FME is feature based it won't write to a new shapefile if empty. The shapefile can also not contain a null feature so the NoFeatureTester or a null Creator is not an option.I'm currently on FME version 2019.2.1 How can I write empty shapefiles?

Hi! I'm trying to get the effing per-cell formatting to work in Excel but I'm not succeeding. My excel output doesn't come out with a yellow background. Please check my screen dumps and help me figure out why!

I am setting up a brand new installation of FME Server 2021.2.0.1 and I can't authorize any ArcGIS Online connections. It gives FME Server OAuth Service Failed. It doesn't matter which user I try to authenticate. This works in my other 2019.1 server, so I know these connections should work.

Hi everyone,  I have a workbench that downloads a extent from a bigger database by Esri (by using a Esri feature server reader) and writes it to a file Geodatabase that we host on a server. Our arcGIS users use a layerfile in ArcGIS pro that uses the file GDB as source.  I use windows task scheduler to run a batch script that starts the FME workbench every month (at mightnight, when no users are logged in).  For some reason the file geodb still has locks active during that time, which cause the overwrite database function in the FME writer to fail.  Is there a way to update the file GDB while the locks are active, or a other way this problem can be solved?

Hi, does anyone have any experience with the following error: - "Unable to connect to the File Geodatabase at '------'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147220893'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for details" We have recently just started receiving the error on all workbenches that are reading feature classes from a .fgdb. The error is inconsistent between what database it happens on and when (i.e. re-running workbench multiple times in a row, it may read a few times without issue). We have alot of automated processes that should run in the background that are now failing.We are using FME 2018.1 via ArcGIS Pro Data Interoperability and have recently had a company wide roll out of windows 10 laptops.

Hi, newish user here trying to figure out dwg to shp conversions. I've got the attached DWG file that has 31 feature types that I need to convert to SHP. But when I run the attached workbench it's projected to 0,0 what am I doing wrong? Thanks

FME 2020: How to label the output in the graphic part based on particular field? For example, in the screenshot below, I wanted to label the polygon based on the “parcelnumber” field but couldn’t figure out how to perform this  

I want to create dwg's with object data with FME. The problem I run into is that the names for the layers and the object data table end up being the same, which makes the data hard to use in Autocad Map 3D. I have attached an example workspace to illustrate my problem. What I would like to achieve in this setup would be for the output file to be identical to the input. For this example I start with a dwg with one object data table Vegetation and two layers, Bos_groen and Ruw gras_groen. I read this, do nothing else, and write it to a new dwg. My end result has both polygons in the right respective layer, but their attributes in two different object data tables, with the names from the layer.  My problem is illustrated in two screenshots. In my sourcefile Object data table and and layer are distinct values, Vegetation and Ruw gras_groen respectively.

FME 2020: How to filter dwg file based on hatches and Areas (polylines)? I couldn’t figure out how to filter dwg file based on hatches and Areas (polylines).   

FME 2020: How to filter dwg file based on lines and polylines? I couldn’t figure out how to filter dwg file based on lines and polylines