Integration

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 PermeableSurface 11 -Surface 12 -The last column can only have values "Road", "Roof" or "Permeable"; but each of these can exist more than once (the maximum I ha

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 intact, so I am mystified about this warning. Assuming that an entity on layer V-SITE-EWAT- was triggering the warni

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.

I'm trying to write to an ArcGIS Portal Feature Service but I don't see it in the list of available services when setting up the writer. I don't own the layer but it is shared with the entire organization allowing write capabilities to all. It doesn't belong to any groups. Strangely, I can see layers in groups to which I don't even belong. I am connecting using a web connection that uses OAuth. Am I missing something? Bug? I'm using FME Desktop 2020.1.2.1 (Build 20624 WIN64).

I have two iPhone's and loaded the same model. The FME AR app on one iPhone shows the model with a lot of strange artifacts and the icon's are missing. What can could be the cause? Both version 1.6.0.

First lines of code: class TROPOMI(object):   # Installs geemap package   fme.exe python -m pip install geemap --target [x]    import fme   import fmeobjects   import ee   import geemap   import os 

I have a workspace that I've published out as a server app. This allows users to select an area on a map, select layers that they would like and exports it out to a CAD file that is then emailed to the user as an attachment. Part of the export is a clipped, georeferenced ortho image.  After the dwg is emailed and opened, the image does not show up. You can see a frame and basically a broken reference. I'm assuming that this is part of a CAD limitation in how images are managed, but figured I'd ask, in case someone has figured out how to do this. Is there a way to successfully include an image inside of a CAD drawing and email that drawing without losing the image? Hopefully this makes sense... Thanks! Eugene D.

I am attempting to use FME 2020.1 to update records in a feature service published to ArcGIS Online. I want to be able to set the symbology in ArcGIS Pro and initially create the feature service and symbology via ArcGIS Pro "Create Web Layer" operation. I am able to create the web layer and read with FME, but when I attempt to write to the existing feature layer (using mode INSERT and truncate YES), the translation says it is complete but no features are written in AGOL. UPDATEI seemed to have found the original issue.It appears that, when publishing the web layer from ArcGIS Pro, all feature layers that will be altered by FME need to have a template.I was getting warning 24041: Layer does not have a feature template set when analyzing the map document for publishing and ignoring it.I used the Create All Templates function to quickly add templates to all layers possible.I re-published this new layer with templates, and was successfully able to truncate and insert to the exist

To what extent are users using FME Server to both consume Web Services and Rest API's as well as a mechanism to create and expose Web Services and Rest API's for other software and platforms to consume.This is for both Spatial and Aspatial Data.