- - Community Resources
Ideas
Product Updates
Events
Blog

Home
Forums
FME Form
Integration

Integration

Connecting FME to web services. Use of APIs. Mobile Apps.

1,048 Posts
3,674 Replies

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

1048 Posts

bingyParticipant

Can FME Write ArcGIS Enterprise Attachments

Hi Everyone, Looking for some assistance, I’m using FME 2023.1.0.0 trying to migrate some existing Survey-123 forms and data with attachments from ArcGIS On-Line to our new Enterprise portal.Our survey-123 form has a singular photos field for tracking a picture of the bus stop, it also has a repeatable photo’s field (table) where the inspector is able to take and attach multiple deficiency photos to the stop if one exists. In FME, I’m able to read in the AGOL feature service that hosts all of the survey information, I’m also able to write out the tabular information from the point layer to the new Enterprise feature layer that was created when I saved the Survey-123 form in Enterprise.The part that I’m currently struggling with is getting the singular photos to attach when writing the tabular information out to the Enterprise feature service so when I view the points in ArcGIS Pro, they appear in the attachments tab of the attributes editor like they currently do with my AGOL service.

732

15 hours ago

datatravelerParticipant

asked in Integration

Created my first ever workbench, but it seems very redundant, tried recreating it in a more streamlined way, but do not know what is best practice

Hi everyone,I am brand new to FME and created my first workbench. In a nut shell it does this:Brings in 6 different enterprise geodatabase feature classes using 6 ESRI Geodatabase (ArcSDE Geodb) readers Each reader is connected to a tester to only select ‘active’ values in a status field Because I selected ‘resolve domains’ in the reader, an additional field for every field that had a domain was created. It was suffixed with “_resolved”, so I used 6 bulk attribute renamer transformers to rename the fields without the ‘_resolved” I then did 6 attribute removers and removed any fields I did not need when it came to exporting (note, many of the fields between each feature class were the same, but there were some differences) Finally, I used 6 different feature writers to export each feature class into a single geodatabaseAs you can see, I repeated the process 6 different times for every reader/feature class that I had. I was thinking to myself while doing this, ‘this cannot be the right w

824

17 hours ago

stefanhContributor

asked in Integration

Microsft SQL Server Non Spatial fieldtype issue

I am having a simple workspace; just a reader and writer (see screenshot below).The FeatureReader reads from a Microsoft SQL Server Non-Spatial and the FeatureWriter writes to Microsoft SQL Server Non-Spatial. The datamodel in both databases is the same and in the target database the table already exists.When writing it to the database there are warnings about the field type. For example (see also screenshot below)Microsoft SQL Server Non-Spatial Writer: Attribute `.....' of feature type `.....' has specified type `varchar(1)', but existing database table field has type `varchar(2)'. Information may be lost during conversionIt seems to double all the varchars; and also getting messages about bigint vs numeric. The data is correctly written in target but I want to get rid of all the warnings. I have tried various thing with reading the schema from both the source and the target table. Also tried with 'normal' readers and writers. And also tried with JDBC reader and writer.Does anyone ha

242

1 day ago

ienesaglam60Contributor

asked in Integration

Coordinate System Edit

Hi,Some parameters of the coordinate system on the screen are not compatible with Türkiye. I know what the values are and I want to edit this file. Especially, it seems that just changing the delta x y z section in the datum parameters section will be enough. can you help?

406

4 days ago

ireenContributor

asked in Integration

Proxy-problem when using ArcGIS Portal Feature Service Reader (MalformedPacError)

We have a model where we use a ArcGIS Portal Feature Service Reader. On the FME Desktop machine, the model works fine for me but not for my colleague. On the FME Server, the same error pops up as my colleague gets. In the logs, there is the following message when the model fails (on Dekstop for my colleague and on the FME Server):511 2023-3-31 00:32:15 | ArcGIS Portal Feature Service Reader: Logging into 'https://URLarggisportal/' as user 'username'512 2023-3-31 00:32:15 | Python Exception <MalformedPacError>: Malformed PAC file (ReferenceError: identifier 'myIpAddressEx' undefined513 2023-3-31 00:32:15 | duk_js_var.c:1258514 2023-3-31 00:32:15 | FindProxyForURL src\\pyduktape.c:41515 2023-3-31 00:32:15 | eval src\\pyduktape.c:1 preventsyield) When I run the model myself on FE Desktop, I get this log and everything works fine: 2023-03-31 10:34:00| 117.4| 0.3|INFORM|ArcGIS Portal Feature Service Reader: Using proxy http://proxy.url:port/2023-03-31 10:34:00

381

4 days ago

marta.podsiadSupporter

asked in Integration

Create list of layers from online app

Hi,I’m wondering if it’s possible to create a list of layers included in an online application like Geoportal Map. I tried using the HTTP Caller, but I’m only getting general information about the webpage and no details about its content.Do you have any suggestions for extracting this data?

4 days ago

davidleeSupporter

asked in Integration

Using PythonCaller to convert PDF file to image

I want to read PDF files as images using OpenAI's Vision API to extract information. I realized that FME's PDF reader tool has issues with PDFs containing text created by digital signatures—it cannot read them either as text or as images. Therefore, I decided to use PythonCaller to create image files from the PDF files to ensure the data is complete. Below is my code: import pdf2imageimport fmeimport fmeobjectsimport osclass FeatureProcessor: def __init__(self): pass def input(self, feature): pdf_path = feature.getAttribute('path_windows') images = pdf2image.convert_from_path(pdf_path, dpi=300) for index, image in enumerate(images): image_feature = fmeobjects.FMEFeature() image_feature.setAttribute("page_number", index + 1) temp_dir = "D:/temp" if not os.path.exists(temp_dir): os.makedirs(temp_dir) image_name = f"{feature.getAttribute('path_rootname')}_{index + 1}.png"

533

5 days ago

mccuneeContributor

asked in Integration

FME does not know about coordinate system `EPSG:102003'

Full error;PROJ: proj_create_from_database: crs not foundMicrosoft SQL Server Spatial Reader: Failed to read coordinate system from SQL Server because FME does not know about coordinate system `EPSG:102003'I can use 102003 in the ProjReprojector tool, but, rather than assign _FME_0 as the CRS for this table, it leaves it as unknown, which means the reprojector tool fails, and 102003 doesn’t exist for me to use in the CRSSetter transformers. How do I set the CRS in feature reader when my desired CRS is not in the catalog (note to FME: this is also a request) I tried defining a custom projection here; demos-safe-software.fmecloud.com/fmedatastreaming/Coordsys/Start.fmw?&token=01655ff804fe3b23f29a7b65568c51e81cd09691but this workbench failed in translation / does not create .prj file I can use.

272

5 days ago

willydeveraContributor

asked in Integration

How to configure FME Form to work with Anaconda

Hi,Could you please provide an official documentation on how to configure FME Form to access the latest Python version from Anaconda distribution as well as its machine learning libraries. Admittedly, there are topics already posted in the community related to the subject; however nothing seems to work for me.BTW, I’m running FME(R) 2024.1.2.1 (20240906 - Build 24624 - WIN64) on Windows 11 EnterpriseThanks in advance,Willy de Vera

678

6 days ago

poonam21Contributor

asked in Integration

Python creator "outdated package" error

Hi folks, I’m trying to execute a python script using Python Creator. The flow is running as expected also with expected outcome, but its giving this error - I have checked the updates is FME package but still not working.Not getting why this error is occuring. If anyone has any idea about it, kindly help. Thanks in advance.

264

7 days ago

marronmContributor

asked in Integration

Unable to connect to Enterprise Portal: unable to retrieve access tokens

FME Desktop version: FME 2021.2I was trying to follow this article on How to Create an ArcGIS Enterprise Portal Web Connection (OAuth 2.0) (https://support.safe.com/hc/en-us/articles/25407772142733-How-to-Create-an-ArcGIS-Enterprise-Portal-Web-Connection-OAuth-2-0)It was going well until I tried to 'test' before moving on to Step 3 and I got the following error (see also attached):Unable to Retrieve access tokenRequest to update access token failed. HTTP Error HTTP/1.1 401 Unauthorized Does anyone know what this error in referring to?

503

7 days ago

john_gis4Contributor

posted in Integration

Views on recent FME price changes

I’m not sure if this is the right forum or category (I couldn’t select “general”), but as I’m sure you’re aware, Safe recently changed it’s pricing for FME, which includes annual maintenance pricing. We are a small consultancy business, long term Safe customer (10+ years) and have been FME advocates amongst our customers for many years. We have just received details of pricing for our annual maintenance in 2025 and for FME Form (previously FME Desktop Professional) for us this has increased by approximately 600%.The new maintenance price for FME Form is going to make it a lot more difficult to justify for a small business like ourselves.We were also previously lookng to expand our FME use by purchasing Flow, but the new pricing has also forced us to cancel those plans.We will also find it difficult to recommend FME to our customers, especially smaller ones, as the bar to entry in terms of pricing has been set so high.I have previously raised the issue of pricing with our reseller in th

3134

11 days ago

jobvdnoortContributor

asked in Integration

Can FME as app publisher in Microsoft be verified?

Hi all,I have been informed by our IT department about the requirement to ensure that the publisher of our Azure app is verified by Microsoft. You can find more information on the publisher verification process here: Publisher Verification Overview.Could anyone from the confirm if this verification process is already being arranged, or if there are any steps that we need to follow to initiate this process?

361

13 days ago

ienesaglam60Contributor

asked in Integration

Draw a dodecagon

I have coordinate list. I want to draw a dodecagon with a known radius.example

838

13 days ago

adamjParticipant

asked in Integration

FDO Install, change FME\Plugins Directory

I’ve installed a newer version of FME (2024.1.0.0) previously used it to convert MicroStation DGNs to a SDF file worked a treat (to be consumed by a MapGuide service), however this new version requires FDO be installed at C:\Program Files\FME\plugins\fdo ?I don’t have administrative rights on this PC and was wondering if there’s a way to override the directory FDO .dll would be searched for or if not simply dumping the latest FDO release in that directory is ok and would work? sorry the error is a little light on the details… I’ve tried the 32bit and 64bit FDO releases and added them to my PATH environment variable, but this doesn’t seem to work.Error: Failed to find FDO libraries in either of the default paths 'C:\Program Files\FME\plugins\fdo'. Additional software is required to use this format. Feature Data Objects (FDO) is available at https://www.osgeo.org/projects/fdo/SDF3 writer: An error has occurred. Check the logfile above for details CheersAdam

1322

14 days ago

hayley.lamContributor

asked in Integration

Sharepoint Online Connector - running from Flow does not read the current data?

Hi there, I have a workbench published to FME Flow. In the workbench I have a SharepointOnlineConnector which reads in an Excel Sharepoint spreadsheet, and downloads it to my shared data source in Flow server. The workbench runs successfully and the output (a table in ArcGIS Online) says it has updated, however the values are all old data. When I run the workbench manually from Form, the SharepointOnlineConnector reads the current data in the Excel. Any pointers on how to get Flow to read the current Excel Sharepoint?

181

20 days ago

ctmitchParticipant

asked in Integration

Reading/Executing Microsoft Access Queries

Hello! I'm working with one of our legacy systems built in Microsoft Access, and I need to extract data from a query. So far, the only method I’ve found involves using the system caller and command prompt. Are there any alternative ways to achieve this?I've tried using the system caller, but I’m encountering security issues with the runtime version. It appears that I need to set the location as trusted, but I can't do that with the runtime alone. We're aiming to avoid installing the full version of Access, so we're limited to using just the runtime.

211

20 days ago

ben09loreContributor

asked in Integration

Dynamically changing URL in reader

Hi,I have an URL that I’d like to read in, but it contains the current date and thus is being updated everyday. How may I change the URL within the reader so that it’s automatically up-to-date?I’ve tried define a user parameter as a URL but I don’t manage to make it dynamic there. I thought I could replace the date e.g. 2024-11-05 with @DateTimeFormat(@DateTimeNow(),%Y-%m-%d) in the Default Value URL but it doesn’t work.Any help appreciated!

262

28 days ago

syedh2993Contributor

asked in Integration

Error Handling in FME - Retry running workspace

Hi Team,I am new to FME and would appreciate if you could help me by giving some tips on Error handling in FME, Below is my scenario,My FME application reads the data from Database and writes to arcGIS Feature layer. Application overwrites the data to feature layer everytime it runs.If application fails for some reason, is there any transformer (or any other method) to retry running the workspace again or add some kind of Try/Catch mechanism?Below could be possible error scenarios in my application, 1) Error connecting to Database 2) Error occurred during transformation 3) Error occured writing to arcGIS Online Thank you in advance,Regards,Syed

492

1 month ago

louiseboyceParticipant

asked in Integration

Python FMEObjects Missing DLL files

Hi - I am hoping someone can help.Apologies in advance for the long message.I am using FME Workbench 2022.2.8.I am trying to set up a workspace that has three readers (using a SQL database that retrieves data from three separate tables) connected to a PythonCaller and then a feature writer (connected to the Python caller) that writes the data back into a SQL database.I need all the readers to have finished before the PythonCaller is executed as it uses all of them in the script.I initially tried to run this using the built in Translator Python3.9+ but every time I did It said no module named pandas.I attempted to configure my own python.exe that I have as part of anaconda navigator (2024.10.1).I created an environment called fme_env and set the Python version to 3.9.I was able to successfully set up all this, but I encountered the no module called FMEObjects error.I went into my FME installation path and there was a folder called fmeobjects and inside that there were several version bu

382

1 month ago

martinkochSupporter

asked in Integration

How to work around an ssl-verification error when using the ESRI Portal reader

Hello all,At a client I often fail to connect to their ESRI Portal, due to failing to verify SSL (see loggin below) on both FME Server and desktop.Proxy settings in FME don't change the behaviour (always uses proxy). The Chrome browser thinks the certificate is o.k. I can't disable ssl-verification in the Portal Reader, as suggested in the log, like it is possible to do in the HTTPCaller.. (see my idea for that). Inspired by this reported problem I exported the certificate from Chrome, and imported it in $FME_HOME\jre\lib\security\cacerts on desktop.. (analogue to these instructions for server, section .pfx certificate, as the problematic server has a .pfx certificate).This did not resolve the problem...Does anyone have any suggestions??? Kind regards,MartinArcGIS Portal Feature Service Reader: Using proxy http://proxy.####.intern:8080/ArcGIS Portal Feature Service Reader: Using authentication type 'NTLM'ArcGIS Portal Feature Service Reader: Logging into 'https://geoportaal.####.intern

2493

1 month ago

meijerContributor

asked in Integration

Esri portal Feature Service Upsert

Hi all,I’m working with a Feature Service containing approximately 1,000,000 sensors stored in a spatiotemporal big data store. I need to update 10,000 of these sensors based on their unique string ID, like sensors-0x21222.Currently, I'm using the FeatureWriter for the 'Esri ArcGIS Portal Feature Service' with the 'Use Global IDs' option enabled and 'Upsert' set as the 'Feature Operation' in the Feature Type. However, 'Upsert' requires a global ID.This approach feels very constrained, as it requires importing all 1 million records, merging them, and finding the global ID for each update.Is there a way to update a Feature Service using a primary key or unique field (such as upserting with a where clause) rather than relying on global IDs? This current method doesn’t seem ETL-friendly, as it requires importing parts of the dataset just to make updates.Thanks in advance for any guidance! Edit:Maybe I don't understand it. But for every featureservice/layer/featuretype I need to add, to fi

392

1 month ago

aharportContributor

asked in Integration

unable to create required workspace factories

I am trying to convert 15 dgns (approx. 50 MB) into 5 gdbs using a workbench. The conversion is aborted with the error shown in the jpg. If I deactivate a few readers (dgns), the run is completed without errors. Could this be a memory problem? Please help.

303

1 month ago

ryanwillshearObserver

asked in Integration

Dynamic AGOL login when using FME workspace as SpatialETL tool in ArcGIS Pro

I’ve been creating some workbenches that regularly update datasets on ArcGIS Online, but I’ve hit a small issue with the ArcGIS Online authentication within FME. It’s fine when I run the workbench, but if someone else runs the workspace they need to use their own AGOL account. I’ve added the workbench into an ArcGIS Pro toolbox as an ETL tool so it can be scheduled in Pro, so is there anyway to pass a persons ArcGIS Online account info from Pro to a FME workbench? Or force it to need a login prioir to running.

151

1 month ago

awrob_Contributor

asked in Integration

Databricks (JDBC) Reaer

Hi, I’m trying to connect using the ‘Databricks (JDBC) Reader’ but I’m receiving an error. I’ve attached a screenshot from the Error - Log Window. Any ideas?

534

1 month ago

Page 1 / 42

Badge winners

ulfmehas earned the badge Socializer (Ice Breaker)
ulfmehas earned the badge Conversationalist
gsrihas earned the badge 12 Days Participant (2024)
dolphin0518has earned the badge 12 Days Participant (2024)
ryanmacdonald66has earned the badge 12 Days Participant (2024)

Show all badges

30,229: 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.

A product of

Company Products Giving Back Careers Contact Privacy Feedback

Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.