- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
General

General

A read-only category for lost FME Form topics. We hope to move them shortly.

4,034 Posts
13,783 Replies

When you subscribe we will email you when there is a new topic in this category

4034 Posts

Recently active

Most replies Most views Newest first

stalknechtContributor

asked in General

After upgrading to FME desktop 2022.2.3.0 (20230131 - Build 22789 - WIN64) I cannot read any of the sde tables.

After upgrading to FME desktop 2022.2.3.0 (20230131 - Build 22789 - WIN64) I cannot read any of the sde tables on postgres (10) backend. The FME desktop 2021.2.3.0 (20220131 - Build 21812 - WIN64) version still works. I've played with the Esri Argis compatibility workspace parameter without any succes. The version of Arcmap is 10.6.1Here is a relevant part of the logging:Worker 8020 > Could not open the Enterprise Geodatabase. The error number from ArcObjects is: '-2147220952'. The error message from ArcObjects is: {The Product License has not been initialized.}Worker 8020 > Please ensure the connection parameters are correct (server=`localhost', instance=`sde:postgresql:localhost,5435', user=`sde', password=`***', database=`lais', version=`sde.DEFAULT')Worker 8020 > It could have failed to open because it contains ArcGIS Pro-only features, for example Arcade expressions. If this is the case, please install ArcGIS Pro or Pro-compatible ArcGI

What advantage does the FME server provide which can not be achieved through the FME desktop on a virtual machine?

Since the FME desktop workbench can be run through windows schedular on the VM. Hence what can be the excluding factor for the FME server? Appreciate your views on the same. Thanks

1 year ago

jasonclemis

asked in General

Has the Geocoder transformer been removed from FME Desktop 2021?

I noticed that when I went to add the Geocoder transformer to a workbench there no longer was a transformer called Geocoder. I am using it to connect to an ArcGIS Server Rest geocoding service. I saw a Geocoder ArcGIS Online transformer and other system specific Geocoder but not the original "Geocoder" transformer.

Create cityGML file from polygonz data

Dear community, I would like to create a cityGML file from a db, which structure I don´t know. I have found a table, where building parts like in the picture are saved as polygonz, but I can´t aggregate them into one solid. The _geometry field I got from an GeometryExtractor, because there was no possibility to see the geometry attribute in the FeatureReader. Is it possible to aggregate those faces into one solid?

Passing an array object as HTTPCaller query string

I am trying to access a JSON API by using a HTTPCaller and I am struggling with passing an array object as a Query String Parameter. The documentation for the 'extra' key I am trying to access looks like this. The code sample they give where you can see the 'extra' parameter as an array is here:{ "key": "xxxxx-xxxxx-xxxxx-xxxxx", "query": "High Street", "country": "gbr", "id": "town=Maidenhead", "extra": { "exclude_areas": [ "gbr_channel_islands", "gbr_northern_ireland", "usa_non_contiguous" ], "exclude_pobox": true, "best_match_only": true, "no_groupings": true }} How do I go about adding the extra array as a query string parameter when the API is expecting to be given an array? many thanks in advance

FME server app error: Unauthorized request by user due to lack of proper permissions for connection

I have a workspace with a sql connection which can be ran with "run workspace" tool on FME server. However when I published it as a FME Server App (No authentication required) and ran the app resulted in this error. From completed jobs in FME Server UI, the two runs have the same user. And the user has full access to and is the owner of the connection. What could be the issue?

1531

1 year ago

cniemanContributor

asked in General

How to read all shapefiles in a ZIP file regardless of how deep the directory structure

I would like to POST a zip file to a workspace in FME Server and read the shapefiles from it. The problem is that the shapefiles could be multiple directories deep. In workbench, I can use [**\\*.shp] as indicated here, but this is not retained on the FeatureReader dataset path when the zipfile is posted to the data streaming service in FME Server. Is there a way to achieve this?

How to change file name of downloaded file.

I am currently working on a workflow that downloads a file from ArcGIS Online and I am then uploading the attachment to Cityworks via the API. The file is downloaded with a general name and I'd like to change the name of the file before passing to the API. I have done some digging on this forum and I am not seeing a way to dynamically change the file name based on other attributes in the middle of a workflow. Would I have to build a custom transformer to do this? Any ideas or examples appreciated, thanks!

632

1 year ago

hwilsonParticipant

asked in General

Run multiple testers and update a field

Hello, I have a dataset in excel that I would like to simplify the data into a newly created status field. For example all records that are 1000 will be status A, all records that are 2000 will be status B, all records that are 3000 will be status C. I will then import the data into GIS to symbolize based on status. I am creating testers for each status type and then joining it all back together. I was wondering if there was a single transformer that I could put in all my criteria and have the status field updated. I think this should be fairly simple but not finding the right transformer. Thank you

1 year ago

jeaner

asked in General

Find non UID and nulls, calculate based on last highest UID in data and write to existing gdb.

I've looked all afternoon for the answer to this probably simple task. I am working with a feature class in a gdb. The feature class has a unique_id field that may may be populated with duplicate numbers or be null. I need to find all the dup ids or nulls, calculate them incrementally based on the last highest unique id while leaving the other records alone. I was able to put something together that seems to work when if I set the writer to overwrite existing gdb. Is there a way to do all of this and just update the existing gdb? I don't want to loose the other feature classes and tables in the gdb. I'm pretty new to FME!

1 year ago

wrijsContributor

asked in General

changes made to dgn file is not noticed by reader when running the workspace

I have a workspace which takes a dgn file(A) and matches it to another dgn file (B). dgn file (A) contains little changes everythime I have to run the workspace. These changes need to be braught to the second dgn file (B), and this workspace automatically (often succesfully) does that. However, if I have run this workspace once, and then changed something to the first dgn (A), the reader will not automatically load the new data in dgn file (A). I dont know how to fix this, obviously I dont want to delete the reader and put a new one back everytime a small change is made. Is there anyway to make the reader completely reload the data everytime I run the workspace?

We used to have the following 'Emailer' Transformer in our FME Desktop /Server 2021.2.2 and it worked fine: However after upgraded to 2022.2.3, we experienced the following Python Exception error for Emailer:Any idea how to fix that? Thanks.

335

1 year ago

mkastelijnsContributor

asked in General

We decided to install a newer version of Apache tomcat, because of issues with the current tomcat. We would like to know if one can safely use Tomcat version 9.0.68 with FME server 2021.1.

At our organization we have an extensive FME server installation with a lot of machines for the engines and cores. We have Apache tomcat 9.0.50 installed, but have a lot of issues with this version of tomcat in combination with fme server 2021.1. Our decision was to install a newer version, 9.0.68., recommended for fme server 2022.2. We succeeded to upgrade tomcat without deinstalling FME server. However we are interested if we can expect issues.with this version in the future. If you need more information please let me know.

Spatial Join: one to one

Hi,there are lots of qstns about one to many joins.I want to understand what transformer to use to achieve a one to one spatial join based on geometry? I have a line in GIS that I want to analyse to see if there a geometry join to a line in CAD. This works fine with the SpatialFilter if there is only one line. however when GIS and CAD has two lines in close proximity the SpatialFilter is creating a many to one join by joining the Two GIS lines to the same CAD line. How do I create the one to one join please? thanks in advance

242

1 year ago

riad.hamoudiContributor

asked in General

Merge more than 20 personnel geodatabases into a single one

I am currently working on a project where I need to combine more than 20 personnel geodatabases into a single one. The geodatabases have the same table field structure and also have attachments and relationships classes. I am using FME to perform this operation.I have difficulty in achieving this effectively. I have tried using the "Feautre Merge” and tool in FME, but it seems that this tool does not take attachments into account. Therefore, I am looking for an alternative solution to combine these geodatabases while retaining attachments.I am sure that there must be a solution to this, and I would like to know if anyone could help me find a suitable solution. If anyone has worked on a similar project or has in-depth knowledge of FME, I would be delighted to hear your advice and suggestions.

Hi All, I would like to clip a line with another line. I need to clip my lines in the part overlapping another line and export it to a separate layer.

I need to clip the road with a bridge, and in the section of the road, where the road overlaps the bridge, change its attributes. Thanks in advance for your response

1 year ago

mahmood631

asked in General

Reading CSV file via directory path and FeatureReader - Get Duplicate records.

Hello everyone, I used "featureReader" to read all CSV files from a specific directory via DirectoryPath and it works fine with me but I am surprised a little bit why I got duplicate data. For example, if I have 3 files, it counts the read 9. What is the best way to ready all CSV files fast and quickly? Do you advise to enable the cache files?

775

1 year ago

bhkContributor

asked in General

How to Make Sure a Python Caller ran First and Finish the job before Starting Other Part of Script

I have a disconnected Python Caller which is suppose to do some data cleaning in target dataset before Reading data from source and writing them into Target Can you please let me know how I can make a sequence here before reading the data from source to ran and do the job of Python Caller First? I tried to connect/put the Python caller before Reader but as you know where is no way to add it before reader , out of the box Thanks

How to solve intermittent runtime errors with FeatureWriter to Snowflake?

For my client we run a lot of translations on their FME server that write to Snowflake. For like 99% of the time that runs without any failures. However, occasionally we are getting the following run time error: "COM.safe.fme.jdbc.TranslationFailureException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver internal error: {0}." Unfortunately this is a rather non-descript error (I wonder what {0} is). Also this error only occurred after our upgrade from FME Server 2020 to 2022.2. Rerunning the exact same translation the next day so far did not result into this error. So, does anyone have an idea how to prevent this from happening? Frank

597

1 year ago

dbaldacchino1Contributor

asked in General

FME Beta 2023.0 - new conditional visibility of parameters broken?

I was excited about this new feature announced at FME UC 2022 and as soon as I saw the beta for 2023 dropped (and I also really want to test this on Server Apps), I downloaded to test. However it seems broken. The drop-down isn't revealing anything. Shouldn't it reveal one of the other parameters as input? Or am I missing something? Thanks.

4311

1 year ago

johntContributor

asked in General

ArcGIS Pro 2.6.10 Python clone and FME Desktop 2022.2.0.0

Hi,We have a python clone in ArcGIS Pro where we have pandas and psycopg2 installed. We have a standalone script that runs fine when run in IDLE (ArcGIS Pro). We want to integrate this into a workflow in FME (preferably without using system callers etc.).In my various testing of compatibility settings and in the main options (including setting the clone with the python home) I only ever have luck with psycopg2 as I think it installed in the FME libraries.Anyway, I believe the correct settings areMain Options/Translation:WS Params/Scripting/Python Comp: Python 3.6+I also explicitly set the Esri ArcGIS Comp to ArcGIS Pro too. When set like this I get the following error about the "encodings" module in the log:Any help would be greatly appreciated. I've not even got the bit about setting this up in FME Server! Regards John

64-bit Background Geoprocessing

Hi,Since this morning since FME Desktop 2022.0, I can no longer read or write to an ESRI geodatabe. All the FMEs in my company are concerned. The error message is : "Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility setting. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http:/ /fme.ly/qua for more details". ArcGis Desktop 2.9 is installed on my machine and the licenses are up to date.An idea?Thanks

Get Corner Coordinates of pixels with color

Hello, i need to georeference 800 maps.Every map is from a grid that is 1km x 1km.From the Scanning and the old paper it can be that the Map has a angle just like showing in the example picture below. Is it possible to get the coordinates of the 4 Red points and set them to the coordinates that the Picture should have from the grid? I know how to do it with the bounding box but i dont know how to deal with the transparency. or is there a better way to make the georeferencing of 800 picutres more easy?

1 year ago

tuolei111

asked in General

CAD hatches display completely different in FME. This is bug ?

This is the preview result in cad and fme

1 year ago

fme_can_do_itSupporter

asked in General

Can FME connects to Quickbase?

Hi, Does FME support Quickbase data reading and writing? Thank you,

181

1 year ago

Page 35 / 162

Badge winners

arxithas earned the badge Welcome Back
sahan969has earned the badge Welcome Back
bryanmayorhas earned the badge Welcome Back
n.dhas earned the badge Welcome Back
axel_ryhas earned the badge FME Flow Certified Professional

Show all badges

29,984: Posts

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.