Integration

I have recently updated FME to version 2020.2.4.0 (20817) and I am now having trouble with the Esri ArcGIS Online feature service writer. When setting up the parameters for the writer I am unable to see any feature services which I do not own (screenshot 1). Previously I was able to find all organisation feature services. The Esri ArcGIS Online feature service reader has the ability to find both owned feature services and feature services shared to groups (screenshot 2), just not the writer.

I've connected to my ArcGIS Portal and can read a feature service. I want to add several where clauses to narrow down this read each time. Adding "objectid">0 returns records, adding "workerid"=88 returns records, but I can't figure out the syntax to apply both in the same where clause. When using the REST API directly its just where=ObjectID>0&workerid=88 and this returns multiple records. But in FME it returns 0 Any ideas how i can combine multiple conditions in my where clause?

When I have a @ symbol in a POST mutipart upload value  FME displays the below error when I run the work bench. This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins I have used a string replacer tranformer and encoded with %40 as a workaround in the past, but with the form email validation on CKAN it does not accept the %40 encoding and expects an @ symbol. Does anyone have any idea how to upload values with an @ symbol in the httpcaller?

Hi, In FME Workbench 2020.2.1 I'm trying to create a new web service from the service named "safe.google-sheets.Google Sheets" (Google Sheet API v.4), but, unlike other web services, seems not to be possible: this service isn't listed in the list of choices. Could it be a bug? Thanks!

The water utilities meter site addresses are in our billing system. This information is daily pulled into a MS SQL server table. I would like to use FME to take the MS SQL table address information and load this table into four feature classes that are in a dataset in a versioned water geometric network .sde database. This .sde database is reconciled and posted nightly. I have worked with versioning and how to best accomplish this. Any suggestions are welcome.

Hi all,According to the FME Server REST API documetnation the Databaseconnections API can be used to query a list of database connections and (hopefully) their parameters (data model values).In the REST API end point page I cannot find any end point that returns information on the database connections, is the Databaseconnections API one of those hidden end point? does anybody have any experience with this end point and can tell me if all the database connection model values are returned from it?Cheers,Itay

I've got a list of sewer subcatchments with an ID field and 12 numeric columns called area_absolute_1 to area_absolute_12. But only some of those 12 are used; the other columns are all zeroes.subcatchment_number area_absolute_1 area_absolute_2 area_absolute_3 area_absolute_4 area_absolute_5 area_absolute_6 area_absolute_7 area_absolute_8 area_absolute_9 area_absolute_10 area_absolute_11 area_absolute_121 0.439 0.277 0 0 0 0 0 0 0.054 1.54 0 02 0 0 0 0 0 0 0 0 0 0 0 03 0 0 0 0 0 0 0 0 0 0 0 04 0 0 0 0 0 0 0 0 0 0 0 05 0 0 0 0 0 0 0 0 0 0 0 06 0.228 0.334 0 0 0 0 0 0 0.026 0.172 0 0I also have a small lookup table that tells me which columns are in use, and what these columns represent:Surface Number Surface TypeSurface 1 RoadSurface 2 RoofSurface 3 -Surface 4 -Surface 5 -Surface 6 -Surface 7 -Surface 8 -Surface 9 RoadSurface 10 PermeableS

Hi,I'm trying to connect to an analysis service for this server:asazure://australiasoutheast.asazure.windows.net/jhausepaas001data type: Cube I connect successful via Excel and PowerBI but no luck with FME.Can someone please help. 

 Using IFC as reader and writer, but trying to add in unique room names or other features into the model.

Has the AR App been discontinued on Google Play? Cannot find it in the store?

 I have Parent objects that contain the object geometry. I have migrated them into the database. I have Child objects that in need to be migrated as well. The Child objects do not have geometry (nor do they need geometry) . I just need to migrate the Child object to the respective Child table in the SW database and link to the Parent object via the Parent Facility ID. Any insight is greatly appreciated.

Dear everybody,  I'm not quiet a FME-guy and neither very good in C#, however I need to combine those 2 now. :-). Have done some research on the internet, but can't really find an answer so maybe you guys know what to do. The problem is:  1) Some guy in my company made an FME-routine which I can run by going to the routine, right click, and then choose "run with quick translator", which opens up the necesarry window. 2) In autocad I've got some C# code which loads a palette, from which several dvb-files can be started.  What I want is to add the FME-routine to that palette. In other words, I need some c#-code for getting to the routine, right click on it, and chose 'run with quick translator'. Anyone who's more familiar with all this got any code for this? Or at least can give me some direction? Some help would really be appreciated.  Thanks!

I would like to get one single MSI package please.

Good morning to all. I hope that you are staying safe and doing well. Below is my problem.I am trying to capture the user log in(Username) and pass it to the process so that I can associate the data with a user downstream. For this I set my User name: FME_Security_User. I thought that this was simple, but when I run the process, regardless of the user, FME Server is passing the value of the process owner to the process instead of the actual user log in.Any thoughts? Advice? Thank you in advance

HiIam working on a script that should run on FME server. The user adds an excel file that contains coordinates (x column and y column) the problem is that the column names can change, therefore I need to let the user specify from a drop down list the (x - column) and the (y - column). Is this possible?  

I am writing XDATA out on line and point (no blocks) features in the AutoCAD Writer. In the Translation Log FME is dynamically creating layers and then throws the following warning right after noting creation of the "V-SITE-EWAT-" layer: "Dynamically creating layer `V-SITE-TANK' Dynamically creating layer `V-SITE-EWAT-' Further instances of this message will be suppressed Regapp on feature is not defined within template. Check that the Regapp name exists in the template, or remove extended entity list data ... Last line repeated 9 times ... Further instances of this message will be suppressed"   I am creating a new file with the writer (not using a template), and my understanding is that FME registers the XDATA under app name "ACAD."  Randomly checking a few entities in AutoCAD shows that the output data seem to have all of the XDATA i

Hello, a newbie to FME server. Hope I can get some help here. Here are questions. 1. Where is the Security (users, groups, etc) info stored in the FME server directory? 2. Is it possible to get this info from the REST endpoint?Thanks for your help,

Hi,  I'm using HTTPCaller to upload files to an online project management system. It all works great but the file names containing "öäå" are substituted with strange looking "?" symbols. Everything seems fine up until the HTTPCaller that does the multipart/form-data upload.   Is there a way to fix this in the workflow or is it more likely to be a problem on the upload site?   Thanks!

Revit to Cesium, what are the steps?

Hello  I am trying to add the ESRI web connection but there isn't a choice on my version of FME. I am not able to update to the latest version of software, is there a resource to reference?

Hi guys,I developed a solution for a client to prepare locators by using ArcPy module. In 32 bit it's working fine.But the client use a FME Server 2017 64 bit. I tested the solution with in 64 bit and now I have an issue with an ArcPy function.Python Exception <ExecuteError>: ERROR 001269: Compressing the service definition failed.Failed to execute (StageService).The function is arcpy.StageService_server. I did some research on web and the only solution I found it's to run it in 32 bit. But like I said before, the client uses FME Server 64 bit. Any one have a solution for this situation?Regard,Jean

I have noticed that there is a difference between Android and iPhones when zooming in on the map using the satellite view. Using an Android phone, I can zoom in further than on an iPhone. Is this expected behaviour?  Being that FME Data Express uses Google maps, I'm not sure if this is a iPhone/Google maps issue or a FME Data Express issue.

Hello, I have an Autocad Tool catalog file (ATC file) used by the AutoCAD design and documentation CAD software and am looking for help with reading this file using an FME transformer.The underlying structure of the file is in XML but I have not seen any XML-defined schema to be to read the file in FME.Looking for help in this area.

I am a GIS engineer who wants to learn how to access data via API. I have tested a bit and managed to connect to simple APIs. Now trying to connect to a Swagger API and can't get the token to connect to the API. I have received a key and can access via website if I enter code under Authorize. I want to connect to the API using FME, but do not know how to access the token code. Can anybody help me?

Screenshots for how I filled out the parameters below. I have my organization's custom URL listed for host, my username, password, and security token listed. When I try to populate the table list, I get the error seen below. I know my 'API Enabled' setting in salesforce is true. I also get this error text occasionally: "Failed to obtain any schemas from reader 'SALESFORCE' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more information" Is there some other setting or access problem I'm having on the salesforce side? I read through the documentation and there isn't anything glaringly wrong.