Data

I am trying to connect to AGOL but my token expires. I followed the method in https://community.safe.com/s/question/0D54Q000080hYdzSAE/how-do-i-reliably-connect-fme-server-201819-to-arcgis-online. It work s but then stops working Any suggestions to to fix this? Under File & Connections, I click web connection, then select connection and click manage web services On AGOL developer I selected  

Is there a way to extract Road (2d polygon) from an FBX? Or an FBX to DWG workflow?

I'm converting DWGs to DWGs, basically copying existing DWGs to new ones with a few extended entity attributes changing values. However, the data types on the output file are string representations, rather than the 32-bit integers that are read from the input drawing and recognized as integers throughout. How can I get the ACAD writer to output the values with the correct data type? I'm using a dynamic schema, with the schema source being the input drawing. Also, how do I know that the output drawing is truly a high fidelity copy of the input drawing? I'm following all the guidelines in the documentation about DWG-to-DWG settings, yet if data types are changing, I wonder what else might be changed/lost in the process, for example, external data links and line styles.

Dear FME Community, is there a way to extract a center point of a building in CityGML? So far I have only done it with the centerpoints of ground sufaces. But what if a complex building has multiple ground surfaces? Is there a way to treat the geometry of a building as one group? So instead of extracting the center point of one surface, extract it from the whole volume of a building. Do CityGML buildings have an individual id? I have attached a sample CityGML file. Thank you so much for your help!With kind regards Christian

Good day!  I am having difficulties getting FME to use Oracle readers and writers. I am using 64bit for both FME and Oracle instant client.  From the website, I followed the instructions for downloading an Oracle Instant Client, unzipping it to a directory and adding this to the front of my PATH environment. The options in the reader and writer gallery are still greyed-out however. I have been trawling the web for the past day or so and nothing I see helps (or makes sense to me!).   Any help would be appreciated   Rich L   

I have 2 shapefile files, each have about 13,000 features. I need to know what the minimum and maximum distance each feature of file 1 for example has in relation to file 2. How to do that?

Hi, Encountering Error 'The arc collinear feature error(ORA-13346: the coordinates defining an arc are collinear)'. while inserting data into Oracle spatial. Please advice.

When reading an Arcgis online feature layer I get this message. It has worked before and there are no problem with other feature layers: Python Exception <JSONDecodeError>: Expecting ',' delimiter: line 1 column 10367918 (char 10367917)

I'm trying to extract the Creation Date of an IFC file. It is usually located under IfcProject in viewers like Solibri, but I can't seem to find it.I want to read a folder containing a bunch of IFC files, and create a list of when the files were last created.

I'm writing features to a 12dXML file and I'm looking for some more documentation around the writer. All I found so far is the information here. I can see the reader creates the meta_data and project_attributes elements but it seems they can't be written properly. If I do create those as feature types in the writer, FME gives me below warnings and renames my output feature types. These outputs will then be interpreted as models instead (and will be contained in the model table as 'metadata' and 'projectattributes')TwelveDXML Writer: Warning, unsanitized name 'meta_data' will be renamed to 'metadata' following 12d Model naming rulesTwelveDXML Writer: Warning, unsanitized name 'project_attributes' will be renamed to 'projectattributes' following 12d Model naming rulesInterestingly, the project attributes and metadata I am writing into my project_attributes and meta_data feature classes will be contained in my written file, regardless. But still, I get models called 'projectattributes' an

The error number from ArcObjects is: '-2147220944'. The error message from ArcObjects is: {This version of the Geodatabase client is incompatible with the dataset and cannot open it. i am using an arcpro of 2.7.3 and fme 2020.2 64bit versions.

Trying to run the following SQL/DDL combination:SELECT setval('@Value(table_name)_$(Column_Name)_seq', (SELECT (coalesce(max("$(Column_Name)"),0) + 1) FROM "@Value(table_schema)"."@Value(table_name)"));ALTER TABLE "@Value(table_schema)"."@Value(table_name)"  ALTER COLUMN "$(Column_Name)" SET DEFAULT nextval('@Value(table_name)_$(Column_Name)_seq'::regclass);But the workspace freezes with a deadlock on ALTER TABLE.  Tried explicitly BEGINning a transaction before the first statement and COMMITting after the second, but that fails with "transaction already in progress" followed by "no transaction in progress".  Not even separating the two statements into different SQLExecutors helps. Thinking I'm going to need to split this into separate workspaces, or worst case scenario, doing some of it in standalone Python.  But wondering if anyone else has run into this and has better suggestions.

I'm experiencing a strange behaviour with the File Geodatabase writer (GEODATABASE_FILE). Everything works when I write to the database from the cache but I get and error when I try to run the complete workspace from the start (with or without caching).I tried so many scenarios, but I always get an error while running everything from the scratch.Here are the few screenshots showing successful scenario and a writing error.Does somebody have similar experience and what might be a solution to this?I'm using FME 2020.2.3.0 (build 20820) and have localy installed ArcGIS Pro 2.8.1Screenshots:1) run to this (from the cache to the database; last step of the workflow)2) success; features are written to the database3) rerun entire workflow4) error running transaction 

Here's a great workbench snippet that uploads a file geodatabase to AGOL, publishes it, updates the view to switch it to your new service, then deletes the old service.

Hi,i have installed the FME Server Version 2021.0.3 with Docker. I´ve imported my Workspace successfully , but it runs into lot of warnings and it failed. These warnings are consisting of a lot of files, which could not be found. Why these files are missing and how could i fix these warnings. best regardstim

Hi FME users! I have to read some ShapeFile from FTP. I use a FTPCaller to get all the files that I need, and then user a FeatureReader to read ShapeFile directly from FTP. I can get the geometry, but not the attributes...Do you know why if I read from FTP, no attributes are read but only geometry ?Thank you for your help!Francis M.

Wondering if anyone can help - I've got a file geodatabase with coded-domain values, which is being updated by my writer with additional values and coded domains, following the instructions here: https://community.safe.com/s/article/working-with-geodatabase-domainsScenario 2: Writing to a new table using an existing domain This works absolutely fine with a geodatabase, however if I try to create a zipped version of it I hit the following error. 2021-06-28 11:24:49| 8.5| 0.3|INFORM|Created and connected to the ArcGIS 10.0 File Geodatabase at 'C:\\Users\\*\\AppData\\Local\\Temp\\wbrun_******\\fmetmp_8\\_auto_zip_dataset_******\\geodatabasename.gdb'2021-06-28 11:24:49| 8.5| 0.0|INFORM|Fast deletes enabled2021-06-28 11:24:49| 8.5| 0.0|ERROR |The attribute definition used is invalid for the non-existent domain 'Suitability'. For a coded value domain the proper syntax is 'coded_domain(domain_name:field_type:name_1:value_1: ... name_n:value_n)'. For a range domain

Dear FME community,I would like to know, if it is possible to convert a simple .obj-file into a .dwg-file. dwg is the standard for Autodesk AutoCAD. AutoCAD is not able to open .obj files.  Originally I had gml/ cityGML and .xyz-files which I converted to . obj-files. If there is no way to convert .obj directly into .dwg, maybe it is possible to convert gml/ cityGML and xyz-files into .dwg-files. I would be very happy if you could give me any hints.Thank you very much in advance!  Christian

Fresh install of FME 2019.2. Installed ArcGIS Pro 2.8 in order to get the 64-bit geoprocessing for our .gdb files. Previous versions were 32-bit. Also have ArcGIS Desktop 10.8 installed (might be of importance). I get this far:  Reading table/feature class 'RecreationArea_A'FME Configuration: Source coordinate system for reader GEODATABASE_FILE_1[GEODATABASE_FILE] set to `_LL-WGS84_0' as read from input dataCoordinate System `_LL-WGS84_0' parameters: CS_NAME=`_LL-WGS84_0' DESC_NM=`WGS84 Lat/Longs' DT_NAME=`WGS84' ESRI_WKT=`GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]]' GROUP=`LL' MAP_SCL=`1' PROJ=`LL' QUAD=`1' SCL_RED=`1' UNIT=`DEGREE'Storing feature(s) to FME feature store file `C:\\temp\\wb-cache-!cip30_fgdb_new-WcyZHM\\Main_RecreationArea_A -1 403 -1 0 0e6998bf75e4d1127f4e8c9607ad

I use FME to get data from a database and have to write it to a text file with a fixed width. For example:Streetname (24 characters) number (5 characters) City (24 characters) postal code (6 characters)(+ like 25 more) StreetA        00011    CITYAA      1111ABStreetB        00021    CITYBA      1234AB I have tried to use the format fuction in the attribute manager but only got the format back like : 10s24s5s6sInput: @Format(24s,@Value(lokatie_straat))@Format(5s,@Value(lokatie_huisnummer))@Format(7s,@Value(lokatie_huisnummer_toevoeging))@Format(24s,@Value(lokatie_woonplaats))@Format(6s,@Value(lokatie_postcode)) How can I make a file with the above format? (I have no influence on the format used.)

I've got a scaler in my workbench, however I would like to use a tester transformer, and branch based on source IFC file units which are either millimeter or meter. Currently I cannot batch input as we are relying on the reader and the unit expression feedback from visual preview. If the visual preview can work this out - surely there is an attribute we can expose?  Any help appreciated.  Many thanks

Hi group.A workspace that worked previously is suddenly failing on certain data since the last run half a year ago.I'm running it in 2018.1, but originally it ran in 2016.1, so I tried to backport the workspace to 2017.1 and 2016.1 to see if that made any difference.I'm utilizing a small dataset of buffered counties, and stored the buffered and thinned and otherwise manipulated dataset in an FFS file for convinience and performance. This file works nicely in 2018.1 and 2017.1, but 2016.1 claims that it has a wrong header or something ??This error persisted even when I used 2016.1 to create a clone FFS from the original non-FFS dataset ?Can anyone shed any light on the pitfalls of using FFS as intermediate storage ?Cheers.

I am often using a new version of FME  (FME2013 Beta) and stores intermediate files as FFS. The problem is that I can not store in an older version FFS which I can open in FME2012, or even FME2011. So I have to save to shape or some other non-SAFE format. Any workaround?

Hello,I am looking to connect to the on-premises Projectwise.I have been able to identify the base URL in the form: https//myhost.com/I type the URL on the browser and asks for my credentials, as well for the project I want to log in.Now one of the tricks is, we are using Bentley IMS services, so I do not have a password, it recognises instantly my email address.So, my first superficial question is, are there any ideas on how to handle this? I do not need to specify a psw within Bentley, so how is this translated in the FME world to establish a connection? Thank you, George

I have an excel file that has named ranges. These named ranges do not seem to update when I change the data in the named ranges. Is there a way to solve this?