Data

Hello,  With help from this community I was able to round the x,y,z coordinates of a pointcloud (see->Rounding IFMEPointCloud XYZ components) and it seems to work when I click on individual points they have 3 digital numbers (=precision). However, when I write them with the Pointcloudxyz writer to a .xyz file the precision is not correct. This topic has been discussed here: https://community.safe.com/s/bridea/a0r4Q00000HbrBDQAZ/point-cloud-writer-support-precision-control. Is there already a solution in place ?  I also tried the pointcloudtopointcoercer-> coordinate extractor -> csv writer but the first transformer is already taking a long time to run so it would not be an efficient solution. Thank you!

I use FME 2019.1.3.1 with ArcGIS Desktop 10.8.1 (also have Background Geoprocessing Tools installed) and I have encountered a problem when reading a specific table in an ArcGIS Geodatabase. The Geodatabase is stored in a MS SQL Server database. This have worked well for a long time but for the last days, I got this error:2021-05-06 11:20:22|   1.6|  0.0|ERROR |Column 34 is 2021-05-06 11:20:22|   1.6|  0.0|ERROR |Error while performing SE_stream_query. Specified where clause is '"Column1"=28310'.:SDE_ERROR_CODE(-66) Invalid parameter value passed to function2021-05-06 11:20:23|   1.6|  0.0|ERROR |A fatal error has occurred. Check the logfile above for details2021-05-06 11:20:23|   1.6|  0.0|ERROR |2021-05-06 11:20:23|   1.6|  0.0|ERROR |A fatal error has occurred. Check the logfile above for detailsNothing has changed in the workspace since last time it runs successfully so I guess that there is something in the database. I can read other tables in the same database without any problems

How to convert .las file to .fbx using FME Desktop?

Hello everyone,my current project is to generate a citygml model from CAD data, point cloud and DTM. The building model has LoD0 and LoD1 ready, I'm working on LoD2 now. I followed some tutorials and the OGC documentation in CityGML, however, the representation of the buildings is not coming out correctly. Here are some steps that I followed and can be seen in the wokspace print: - I separated the solids on surfaces (deaggregator), storing the gml_id of the original solid (parent_id); - identified the surfaces that were shared by two buildings; - removed the geometry of the original solids (geometryRemover); - In solids, I created the list with the IDs of the surfaces that composes the solids "citygml_bounded_By. {} Xlink_href" (matcher); - For solids, I set LoD name = LoD2Solid and Feature Role = cityObjectMember; - I separated the surfaces in Roof, Walls and Ground by normal (PlanarityFilter); - And for surfaces, I set LoD name = LoD2multiSurface and Feature Role = Boun

Hi everyone, I'm testing the B360 Connector. I can log in okay, but when I click on Hub, it searches for a while but then finds nothing. There are definitely projects in our B360 instance. See screenshot below, can anyone help? Cheers.

I have a workbench that reads features from a table from Microsoft SQL Server Non-Spatial and writes (Feature Operation: Update) into the same table. I have read and write permissions, reading is working fine but writing gets the following error message:Microsoft SQL Server Non-Spatial Writer: Connection failed. <connectionstring>. Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. ' Failed to open writer Failed to open writer f_22(CreationFactory): Failed to open writer I've tried several things, but none of them is working. I've read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and this https://knowledge.safe.com/questions/39002/connection-issues-to-ms-sql.html Our settings in SQL Server: 'Named Pipes' is Disabled and 'TCP/IP' is Enabled. We can enable 'Named Pipes', but the server service then needs a restart (we don't want to restart

Hello,After migrating to FME 2022.2 (desktop and server), I get errors on each workspace that uses Oracle Spatial FeatureReader with a spatial filter:I tried these workspaces on FME 2022.0 and everything works fine...I don't really feel like reinstalling another version of FME Server, so any solutions/workarounds are welcome :)(Using spatial SQL queries instead of FeatureReader is not an option)

simple question: Why does reading this netcdf fail with any (combination of)setting(s)? It works fine in Qgis https://www.ncei.noaa.gov/data/international-comprehensive-ocean-atmosphere/v3/archive/nrt/ICOADS_R3.0.0_1750-07.nc

Does FME supports reading / writing to CityGML 3.0 version?

I have been using this transformer for quite some time and have been living with the pain.i have done some more testing with it and discovered that if i don't use recurse there is a significant performance gain with a giant functionality loss!it can take anywhere from 5 minutes to HOURS to get a response from the initial read in dektop. slightly better in server however i am ussually not waiting on it at that point (if i need it to work i publish to server and walk away) it may be tomorrow before it completes.are there any workarounds. i have considered trying to use a system caller to just do a dir and get really bad data back and rebuild it from that. 

Does anyone know if the newest version of FME still supports QUADRI- and QMS-files? I tried to add a QUADRI-file as a reader, but I get the following error message:  "Failed to obtain any schemas from reader 'GDMMAPPERQUADRI' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading." 

Hi,I am trying to insert a watermark disclaimer into construction PDF's as part of a distribution workspace that is an part of a FME Server App.The key part of the workspace is that pdf's are filecopied into a zipped folder before being distributed, these pdf's range in size (napkin to Arch D, to legal letter, whatever was scanned), but the disclaimer can be in the same spot (ie. bottom left hand corner, 150x, 150y). The PDF writers limitation is that it can only write to certain page sizes, which is an issue, so inserting a text disclaimer is not feasible.The filecopy maintains the page size/pdf quality, but I am at a loss for adding a watermark/overlay/text.FME Desktop 2021.0FME Server FME Server 2021.0.1 Thanks!

I am reading all JPGs contained in a location (including subfolders) and manipulating the attributes. Then, using the filecopy writer, I am moving them to a new location. I am having a hard time getting them to move with the name I am defining in the Text Editor. The original name is retained every time. Does anyone have some advice for me?

I have been investigating replacing my use of SQLite Spatial (GDAL) with the new (FME 2022) SpatiaLite Native format.Previously I used to be able to start a workspace with a SQL Creator with a statement like:SELECT id, column, geometryFROM table With a script like that, the old SQLite Spatial (GDAL) format SQLCreator would read the geometry correctly from a database created by a SQLite Spatial writer. However, I can't get the same to work with a SpatiaLite Native SQLCreator selecting from a database created by a SpatiaLite Native writer. Instead of reading the geometry of each feature, it reads a blank string attribute called geometry.Is selecting a geometry with a SQL statement no longer supported? I can probably replace this sort of use with Readers, but would prefer to not.Thanks.

HiSituationWe have a quite simple FME Workbench, loading CSV data from an URL, and writing it's data to a MSSQL database. The workbench works fine, writes all data and terminates with "Translation was successful". ProblemSometimes (actually mostly) the workbench doesn't stop right after it logs "Translation was successful", as it's supposed to do. Everything's done, all records have been inserted, but the workbench keeps running. Sometimes it takes 5min or 10min, sometimes it takes days until the workbench stops.The screenshot shows the situation. In this case it was a time lag of 5 min. FactsFME 2018.1MSSQL 2016; it's on the same machineWith PostgreSQL or Oracle we never experienced the same issue Any ideas or hints?Regards, Tobias

I need to run approx 10K zipped LAS ASPRS files and generate an xyz file with 5 m grid using ground values. Looking for a workflow to do this.

Hi all, I've been tasked with trying to connect to a Sharepoint list and have the appropriate security (read-only) applied to the sites and file/lists. When I try to read in the Sharepoint URL with FME, I am presented with errors, be it for Web Auth, Basic, NTLM or Kerberos. I've attached screenshots of the errors. Any help is appreciated. I do also have another URL which is formatted as "https://<site>.sharepoint.com/sites/<subsite>/_api/web/lists" which I have tried as well, but to no avail

I have a sql server table that I do not own but have full permission on.I can setup a GEODATABASE_SDE Reader and read it no problem the table qualifier is "abc\\username" When I try to setup a writer for it the Table Qualifier gets set to _abc_username_ When I try to write to it I get an error message statingGeodatabase Writer: Feature Class or Table '_abc_username_.table_nm' must exist when Table Handling is set to 'Use Existing' Unfortunately using FME2018.

I have a writer that creates a CSV file to a folder on my computer. How do I write this CSV file to AGOL (ArcGIS Online account)? I already understand how to write data to an AGOL Feature Service. I need to create a CSV file to my AGOL account. I plan to update this CSV file every night (via the Task Scheduler) and share it with others. I'm using FME Desktop (not FME Server). Thanks.

I'm a bit surprised I haven't found this answered already - maybe I'm just not seeing it. When using the ArcGIS Online Feature Service writer - is it possible to define the layer ids, or layer order that will be used when creating a new feature service? I want to help ensure that the new layer ids match previous ids. Since the writer can't add new layers to an existing service, I need to delete the existing service first. Do I need to ensure the different layers are passed to the writer in the preferred order? Thanks!

Hi, I have two LAS files of same area. One is the classified data and another is unclassiffied data. I want to copy the classification from the classigied LiDAR data to Unclassified LiDAR data. Any help is greatly appreciated. Regards, Krishna

In the documentation I see that Appearances are planned for a future release. Just wondering if this is already on a timeline somewhere: https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/cityjson/quick_facts_cityjson.htm @deanatsafe​ - perhaps you're the one to ask?

I`m trying to make a strange raster, due to a specific software demanding exactly that format.  It seems to be a GeoTIFF with 1 rasterband (UINT8) that has palettes with 3 values (RGB). See below for more information. I have managed to create the 1 channel TIF with the correct value, however I struggle to add the palette, and add the correct value for each palette to each pixel. Since FME can read the file correctly, I assume it can also create such a file, however I am stuck after examining all the RasterPalette* Transformers.  Any raster-wizards out there? 

I successfully can read/write Esri Arc SDE (Geodatabase) with FME 2021.2.6 64-Bit and ArcGIS 10.8.2 + Esri BG Geoprocessing installed. So far so good. If however ArcGIS Server 10.9.1 is also installed in the same enviroment, problems arise and an error message appears, that "BG Geoprocessing is missing" and needs to be installed. What is the issue here ? How can it be solved ?It seems only uninstalling ArcGIS Server 10.9.1 solves the problem, but I need ArcGIS Server for other reasons/applications. B.T.W.: ArcGIS Server 10.9.1 is the corresponding version to ArcGIS 10.8.2, in case you wonder about the version mix ;-) Thanks for any clue about this Michael  

Also When I am trying to use Civil 3D and CAD Entities. I am getting reader error "BADNEWS: BADNEWS: No geometry mapping entry found for 'autocad_wipeout' in metafile 'C:\\Program Files\\FME_2022_1\\metafile\\CIVIL3D.fmf'. Please visit http://www.safe.com/support"