Data

I try to make a setup of a script workbench and a runner workbench. The script consists of a postgis feature reader and a gdb writer. The schema of the postgis feature reader is defined as a user parameter, and so is the destination of the gdb writer. The runner consists of a Postgis reader that reads a table containing schemas and paths for the gdb, and a workspace runner that runs the script and defines the user parameter mentioned above using the schemas and paths from the PG table.  However i just this error when trying to read the table of the schema: "021-12-21 12:53:57|  0.1| 0.0|ERROR |Error executing SQL command ('select * from "FME_PostGIS_SCHEMA"."DF_Mast" where false limit 0'): 'ERROR: relation "FME_PostGIS_SCHEMA.DF_Mast" does not exist" So it just inserts the name of the user parameter rather than the actual schema it was support to insert.  I hope you can help.

FME Desktop 2020.0.0.0: What does “untouched” indicate for in the “geometry coercer” tool? For example, in the screenshot below, I got 3 features as “untouched”. What does this indicate for? The data is attached      

I am importing landxml file that has alignment(s) with stationing. I'd like to view the alignment(s) with stationing labels including tick marks in the Graphics window. Is this possible?

Hi,  After converting the tif to ecw, ecw always comes with a background. I don't see the background in FME inspector or ArcMap, but there is always a background in Smallworld. Is it a way to remove the background colour of the ecw?

I have an AIXM 5.1 file which clearly states at the beginning that the encoding of the file it is in UTF-8. However, when I use the AIXM 5.1 Reader suddenly all my attributes are in UTF-16LE which is not what I want. I could use the AttributeEncoder to change everything back to UTF-8, but that seems like a waste of time as my data was good to start with. Also is my geometry converted into XML and reading that will give errors as declaration inside the attribute is then UTF-16LE while I converted the attribute to UTF-8.

FME server get current logged in user from token

I have FME Small world Edition license on my system but I am unable to read the data as it shows below error. Please help me with this.

I've been given some data - 10 KMZ files which seem to comprise multiple named layers (so over 70 in total) with only occasional data in the Name field, which I want to convert to TAB format. I'm struggling with it - below are 3 views of the data - in Google Maps, in QGIS and in FME Data Inspector. I also attach one of the KMZ files here. I'd like to generate a workspace to produce 10 MapInfo tables of points, lines and polygons, to correspond with the KMZ files and named as the KMZ files, but with an attribute column populated with the layer names, for example, "J Garden Terrains" (in QGIS appears to be the Layer names) and a Name field for the occasional data that has. The only way I can see of converting the data at the moment is to click on each layer in QGIS and Save As a MapInfo table. I'm sure I must be able to do this in FME - I hope so! If anyone can help I'd be very grateful. Thanks, Jane

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:

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 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 =