Data

Hi, In the FME basic training I am trying to create a PostGIS connection for Exercise 4 'FME Hackathon' (page 430).The Hackathon PostGIS Database should be located at postgis.train.safe.com, but I cannot get a connect with it using the given parameters (below). I followed the steps Tools -> Database Connections -> Add Database Connection.Host: postgis.train.safe.com Port: 5432 Database: fmedata Username: fmedataIn the log window the following error appears:Error connecting to PostgreSQL database(host='postgis.train.safe.com', port='5432', dbname='fmedata', user='fmedata', password='***'): 'server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.'Isn't the server online or am I doing something wrong?My version is: FME Workbench 2017.1Thanks,Koen

I'm have the following error:An error occurred while attempting to open an insert cursor on the table 'SurveyedGeneralLawn'. The error number from ArcObjects is: '-2147216556'. The error message from ArcObjects is: {Objects in this class cannot be updated outside an edit session [GisGeoDbMaint.ASSET.SurveyedGeneralLawn]}It seems to be with a relationship class with attachment TABLE. When i remove the relationship it work fine. I only want to insert records into the feature class and the attachment table. I using an Arcpy truncate function as a startup script.I've looked at previous post regarding this matter, but it don't seem to work for me.Using FME 2014 - SP4Rudy

Can FME create a pg database tables with attribute names that have upper cases? I know that this is possible in postgres - column names are case-sensitive when double-quoted. But no matter which parameters of PostgreSQL writer I select (standard/dynamic writing, with checked or unchecked option to Lowe Case Attribute Names in Table Creation Parameter), FME keeps replacing double-quotes with underscores and output is always folded to lowercase.  Is it something that can be bypassed? 

Hi  I am setting up a job to update data in AGOL using FME Desktop 2020.2.3 I am aiming to have a single job which I will publish to our FME Server to refresh the data on schedule.  I have multiple Feature Services to update and am hoping to use a single Feature Writer to update them.  In my workspace I generate the Service ID and am passing through to the Feature Writer Feature Service constraint parameter. This works successfully when the Feature Writer only updates a single Feature Service however when I try multiple it cannot find the Feature Service, it seems to still connect to the first. The log shows that it maintains a connection to the first Feature Service and does not switch to the second. Are there any issues with this methodology? Suggestions for alternatives? Thanks

Hi,I would like to be able to read the name of the layers from AGOL that are shared with the same group. ArcGISOnlineConnector reads only the genaral name.

What does error message"expression: prevrealnode_->arcinfo_ != nullptr" means?

Which FME version is compatible with SQL Server 2022

Hello!I have a newly installed PostgreSQL database with a PostGIS extension enabled. Because of licencing consideration we want to migrate our oracle database to this database. We are using database side bussiness logic in our views, so i want to write directly to the views without success.We have Postgresql 12 AND postgresql 16 for compatibility testingEvery version of FME from 2018-2023 (mainly using 2018 because we have too many scripts to migrate all) I have tried most of the version combination with the same error every time. This is what im trying:Created the table definition with FMEBased on the created definition created a simple view but the workbench keep dropping this error: Invalid PostGIS metadata detected for table 'public.generated_np_node_view'. Attempting to correct and continuePOSTGIS Writer: Table 'public.generated_np_node_view' does not exist. The inserting with pgadmin or geoserver works fine, the inserting to directly to the table works fine but t

We have an authenticated WFS from Drone Deploy that has an API key. ArcGIS Online and ArcGIS Pro both have the ability to include the api_key in the request. Is it possible to include the custom request in the WFS Reader?  

I've seen lots of people over the community asking how to read AGOL attachments, but I'm curious to find out what FME users are doing with them once they've been read using FME.

If you execute the attached workspace... You get fme_text features with empty fme_text_string (but TextString has a value). Any suggestions? 

Hi everyone. I've a folder with JPEG. I have a XLSX file with the name of the JPEG name and the new name that i need. It's possible to remane the JPEG in Batch ? Thank for help.

I have a long workflow that transforms some DWG (for buildings), GeoTIFF (for terrain) and FBX (for trees) in 3D datasets (IFC, OBJ, FBX, glTF). The whole process takes a bit more than a day because it's on a quite huge input dataset. The output is fanned out based on a 500m x 500m grid.When I was testing my workflow on a smaller dataset, it worked fine on the four different file formats. Now that I tested it on a bigger dataset, it only works on the file based datasets (IFC and OBJ). The workflow is still able to write the first part (terrain) in the folder based datasets (FBX and glTF), but as soon as it starts writing the buildings in the all ready created fanned out folders, I get an Access Denied (that I didn't get when I was working on smaller datasets).Does anybody have any idea why ?

BonjourQuelqu’un peut-il m’aider à convertir en ecw ou jp2 le tif joint sur ce message.Je veux préserver la transparence.Dans l’ensemble, la transparence de mon test n’est pas préservée. RenommerRésultat.jpg en Résultat.jp2 pour voir le probleme (ouvert avec gqis 3.22)

Hi all, Something very strange happening just wondering if anyone has had the same issue. I have a process that both reads and writes ESRI Geodatabases. In recent weeks I have noticed that every time I try and read in a geodatabase I get an error "Workspace or Data Source is Read-Only". I have checked my permissions, I have checked I am the only user accessing and all is fine, and the error disappears if I copy the gdb locally - this error only occurs when reading across my work network between servers - but I 100% have the correct permissions for the task. To add to the complexity, the error only happens about 90% of the time but on the odd occasion all works as intended. Anyone any bright ideas? Cheers,Jack

Hi, I have a couple of queries, I will try my best to elaborate. I am transforming to DGN cell to CityGML.1) How do i ensure, that exterior rings are counter-clockwise, and interior rings are clockwise? I am using the Orientor Transformer, and setting Let-Hand-Rule, however, on surfaces, i still see (from using Inspector against the CityGML) that the polygon is right-hand rule.2) When viewing the resultant CityGML in Inspector, it is showing the wall surfaces rather strange..... some are rendered as exterior (solid) representation, some have the interior (dashed) representation.Does it matter that FME represents it in this way? or does it actually mean something? is it related to point1? These are shown as right hand rule (i want left hand rule).Thanks,Steve

I need to create a Minecraft world from the FME Workbench that is compatible with MinecraftEducation.It is possible to import a world but only in .mcworld format.I'm trying to update my workbench but it doesn't work.Help me please

Does FME support a connection to active directory with a group managed service account (gMSA)? Or are only regular accounts supported?

Hi, I need help and guidance. I have 2 questions. 1st. I've been using the GeometryValidator transformer and selected the OGC standard checks. When I run it, all my geometry fails. How can I check what is failing and how to fix it? If possible, please provide an example of how to fix it. 2nd. I've read the OGC Geopackage standard and found that there are some tables that need to be included in the Geopackage file, such as gpkg_spatial_ref_sys and gpkg_contents Table. Is there an automatic way in FME to create these tables, or do I need to do it manually? Hereby, I am attaching the file for your reference, tqvm all.

Hi,I'm trying to convert a DGN file wiht mixed geometries: most of them are read by FME; but not all. It seems like the geometrytype "smart solid/surfaces" isn't read by FME Desktop at all? Is it possible to read those geometrytypes? We really need them ;-)Added this message are pictures of the same file showed in MicroStation and in FME Desktop. Also added is the DGN file.

Hello everyone, I'm working on creating a Geopackage, and I've added a new table (feature type) to indicate the relationship between several other tables. How can I add features to this table without taking the original feature type or feature from the reader.

I have a dynamic workbench which reads KML and/or KMZ files (OGC/Google KML Reader with selected Multiple Files *.kml and *.kmz) do some translation and writes output features to Geodatabase.Workbench does all the translation and writes output Geodatabase, but when I run this workbench with only KML files (no KMZ files in input folder) I get an error message: KML: Cannot open dataset `G:\\path\\**\\*.kmz'KML: Error initializing readerWhen I run this workbench only with KMZ files (no KML files in input folder) I get an error message: KML: Cannot open dataset `G:\\path\\**\\*.kml'KML: Error initializing readerWhen I run this workbench with both KML and KMZ files in the input folder I don't get the error message. Can you give me some tips on how to work around this problem so that the error message does not show up in the log? Or can it show up as a warning rather than an error? It is confusing for the Workbench user when they get the error message, and the workbench actually

Hello everybody. The problem is the following. From a httpCaller and a featureReader I open a GTFS, but some attributes (stop_sequence in stopTimes.txt and end_date in calendar.txt) appear as missing. However, if I examine the downloaded zip with a text editor, the missing attributes appear with value, but if I open the downloaded with FME with a reader it doesn't...I tried attributeExposer, but it doesn't work. Any suggestions? Thank you so much! Pol 

When attempting to read features from Salesforce via FME Server (2021.2) the job fails after warning:WARN |MULTI_READER(MULTI_READER): Skipping to next ReaderERROR |A fatal error has occurred. Check the logfile above for details The workspace runs to completion on FME Desktop (2021.2) and reads data successfully. Troubleshooting hasn't provided any further information or progress. Is there a reason that the skipping occurs on FME Server?

Need Help I have been using FME Inspector to read an IFC file. Inside the IFC file, there are IfcGeographicElement features (DTM surface). My question is, why doesn't FME display the shape of the object?I noticed in the FME the number of vertices is zero, but when I opened it in Open IFC Viewer, I can see the IfcGeographicElement object, and there are vertex values 15515.Attached herewith are screenshots of both applications views.