Data

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 '

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_Recre

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?

Hello,I'm generating a DEM file with the writer U.S. Geological Survey Digital Elevation Model (USGSDEM)However, whenever I click somewhere on the DEM raster that is generated, I obtain a round up value to 1 meter.Just before going into the writer, I have an inspector on my data and I do have floating point value for the elevation.Is there a way to force this writer to not do the round up and keep the value in floating point?  Thanks

With FME Desktop 2019 and newer, Postgres and Postgis support SSL, this mode has different options as shown below in the screenshot. By default: Value is set to Disable For Verify-CA and Verify-Full, options the root certificate needs to be stored when connecting to RDS instances.

New to FME and befuddled by the performance disparity of Oracle Non-Spatial reader over high-latency network links. Needless to say, I understand the benefits of having FME close to the data, but… I compared the performance of the Oracle Non-Spatial reader against a CSV export from Oracle SQL Developer of the same database view on various machines in various locations on our network. The size of the fetch was 46394 database rows with just 8 columns. From a desktop machine in the data centre close to the source Geodatabase:SQL Developer CSV Export:             8m16sFME Desktop Reader:                       10m11s From a remote desktop machine on VPN:SQL Developer CSV Export:             8m50sFME Desktop Reader:                       72m Remote FME Server:FME Server Reader:                           32m9s The most interesting fact is that the SQL Developer export suffered almost no

Hi All,I'm a bit behind the curve with JSON. Could somebody help describe the process to expose the three attributes in my simple file sample following: {'items': [{'att1': 'abc',  'att2': 'xyz',  'att3': 123}, {'att1': 'cde',  'att2': 'tuv',  'att3': 456}]} Notice that 'items' holds all the attributes.  I have successfully setup a reader to intake the JSON, but now need to expose the attributes att1, att2, and att3. I looked at several transformers, but the parameters are somewhat foreign to me. A detailed workflow would be much appreciated, since some of the JSON lingo is foreign to me. Thank you, TylerFME Workbench 2021.0

Hi,I read several WMS layers (from the same source) and each layer is written to a single layer in a pdf. For example, I read a WMS background map and write it as one layer, then I read a WMS line network and write it as one layer and this is where I have problems. In my line network layer, I want everything to be transparent, except of course the network itself. Can I create pdf with layers that are transparent for some values (white, no data...) by using a WMS source ? If not, is this a limitation of FME pdf writer or the pdf format itself ?I can't use the workaround by "pre-generating" the layers before writing them since the pdf would be huge.By the way, I am using FME 2013...Many thanksRickard

Hello, I would like to convert an IFC file to a geodatabase, with all properties. The transformer "Geometryfilter" is really good to convert the model to multipatch, but I can find how to get data set in the "IFCPROPERTYSINGLEVALUE" to my geodatabe, consequently the values present in this field are missing in the exported geodatabase.Thanks for your help!

I need to write anotations to a DGN file (v8). To generate the labels (anotations), I'm using LabelPointReplacer, followed by AttributeCreator, where I add specific igds attributes manually. Everything goes well with a single exception that I'm unable to resolve:  I set up igds_font attribute on each feature manually. If the input string is composed of basic alphanumeric characters, all goes as expected and correct font is used to write the feature. If non-standard diacritics (Czech) goes in, the igds_font is forced/overwritten to 1025 (Arial) in the writer. I was trying to add/alter multiple igds attributes, to specify Resource Font File, to play around with encoding of the incoming String and eventually went out of ideas what else to try. I'll appreciate any ideas. Thx.

Hi All, im trying to put a basemap under some vector linework output as a pdf.... Currently i use a http fetcher to get an esri basemap jpg, georeference image then use pdf formatter to try and combine the vector and raster.  it all works perfectly when sent to an inspector but when send to pdf i get nothing.... is there a simple workflow im missing somewhere ? similar to this https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_DataInspector/DataInspector/Background_Map.htm with the data inspectors basemap under my data. I just want a raster basemap underneath my outputs. I have read lots of posts around this but not found a solution that works for me.

I have an Ifc Model that I read in as multiple features using the IFCreader. Aftwerwards I am using the Esri Shapefile writer to output a single feature e.g. "IfcWall" to a shapefile.The translation is shown as successfull, however there is no file being written in the output directory...Could someone point me in the right direction of what I may be doing wrong?Are there transformations necessary between the reader and the writer?

It is supposed to be QuadrupleD, a DirectX library for Delphi and the suggestion is to use Direct Draw with Delphi to open???

Is there a plan to support ETL for semantically rich CAD models using the STEP ISO10303 AP 242 or the ISO 14306 JT file formats?  For our facilities, we develop BIMs and use IFC to extract, transform, and load geometry with associated metadata. However, we develop product models using CATIA and NX and are in need of extracting geometry and the metadata associated to that geometry. What methods do you recommend for extracting, transforming and loading these semantically rich CAD models?