Data

I have a workbench which converts IFC to ESRI Multipatch, the original colours in IFC are reserved very well in the output Multipatch (as inspected in ArcGIS Pro)， however if I convert the multipatch to 3D object scene layer package, it seems the colours are gone. there are not many option for me to play in the I3S writer. I have checked the FME I3S factsheet which has mentioned Generic Color Support: No. Not sure if that's related, but any advice how to keep the colours of the output .slpk matches what's in the original IFC or multipatch? thanks

I am attempting to make a connection to an AGOL feature service through the ArcGIS Online Feature Service Reader and receive the above exception and error indicating invalid token. I just created the web connection using valid credentials so this shouldn't be a refresh token issue. I've tried creating multiple web connections for AGOL and get the same exception/error each time. Note: I am not the owner of the feature service however is is shared to my organization. The credentials I'm using to try to create the connection are admin credentials for my organization.  I have never attempted to connect to an AGOL feature service before so any help would be appreciated. I realize there are similar forum posts/questions but none seem to resolve my issue.

Why this is not working? 😕 I am using:2020.2.0.0 (20201027 - Build 20787 - WIN32)REALDWG reader/writerDWGStylerI want to: read DWG file with som "autocad_text" entities,change size of these entities,write it to new DWG file.My approach:I use REALDWG reader to read my dwg:I then use DWG styler to manipulate text sizeI then use REALDWG writer to generate new DWG fileResult:Inspecting generated file with AutoCad shows that size in not changed!Workspace and test file in attachment 

Hi folks, I'm trying to read a GPKG Layer from a rather extensive Geopackage which I use as an offline data exchange container. Said layer has a total of 228 objects, of which 47 have multipolygon geometry and the rest are tabular data.  The problem: While FME Data Inspector on its own reads the data correctly, the FME Workbench GPKG reader reads all features as type "geopackage_none" and omits geometries completely. I have not found any reader options to resolve this. What can be done do force FME to read all "geopackage_multipolygon" objects correctly? Splitting the data into separate tables is not an option, since I have to use a given data model. Thanks for any helpful advice!

Hi,  I have an issue when reading from an Oracle database.In my table a field is set to number(10,2) but when read with the Oracle Reader (Non-Spatial or Spatial Object), I get the attribute with the fme_data_type String. However, in the User Attribute tab of the reader parameters, I do see the oracle type numer(width,decimal) / 10 / 2. How come this can be ? Same behavior with the the FeatureReader.I am using FME 2020.2Context is : reading from Oracle DB, reading from Postgres DB and comparing both tables with same attributes with ChangeDetector to syncronize Oracle to Postgres.

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 say the following:GlobalID IN ('{28F268A5-7390-4FF

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 = Update (dont think this matters with fme_db_operations) and Trunca

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.I believe the issue is somehow related to the