Integration

I have a script that uses excel reader and writes into a SQL database. It works fine but one issue is that a field I'm trying to copy has a 'version number' such as 5.1.01 or 5.3 where 5.1.01 is coming out fine but 5.3 is appearing in the db as 5.29999999 as shown below The version column is set to 'Text' in the excel sheet. The excel reader is using the 'char' type as shown below The writer is set to use the 'nvarchar' type as shown below, which is the same as the type in the database 'nvarchar(255)' It appears somewhere in the process these values are being interpreted as a decimal or float but I haven't been able to work out how to fix this. I'm relatively new to FME so Its possible I may be missing something. Any help would be greatly appreciated.

Hi, I found the perfect python script for my needs on the net the other day. For the first time I wanted to use the pythoncaller. However the input for my caller is a matrix. I'm pretty sure my matrix is correct as well as the script i want to use. I don't have a clue how to match them. Any ideas? The script I want to use is this one: # Python program to find all # rectangles filled with 0 def findend(i,j,a,output,index): x = len(a) y = len(a[0]) # flag to check column edge case, # initializing with 0 flagc = 0 # flag to check row edge case, # initializing with 0 flagr = 0 for m in range(i,x): # loop breaks where first 1 encounters if a[m][j] == 1: flagr = 1 # set the flag break # pass because already processed if a[m][j] == 5: pass for n in range(j, y): # loop breaks where first 1 encounters if a[m][n] == 1: flagc = 1 # set the flag break # fill rectangle elements with any # number so that we can exclude # next time a[m][n] = 5 if flagr == 1: output[index].append( m-1) else: # when en

Hello, I am trying to setup my web service and a web connection for the Sharepoint online connector, and have downloaded the FME Hub package safe.microsoft-sharepoint-1.0.0.fpkg. I have successfully used the default values supplied with the package in my FME desktop environment, and have setup an FME process to use multiple actions from the sharepointonline connector - which will simplify my organisations workflow in this area greatly. However: I need to configure this to run on FME Server 2019.0 and have registered an app on azure for FME, and have my client ID and client secret. I have updated the URL parameters in the webservice setup in FME to point to the tenant endpoints e.g. https://login.microsoftonline.com/<my tenant ID>/oauth2/v2.0/authorize. I'm not sure what my redirect URI on the webservice setup page in FME is doing but I've set it to this: https://login.microsoftonline.com/<my tenant ID>/oauth2/v2.0/authorize Also, there is the ability to set a Redirect URI in the regist

I am trying to use the Microsoft Dynamics 365 web connection in FME. I am unsure what username and password need to be input. I was working with one of our administrators of the product and he provided me the organization, client id, client secret, and resource. But he thought that user name and password were no longer used to connect to a D365 API. I'm trying to connect to non-spatial data in Dynamics and then write data from it into postgres. We're going to use FME to convert lat/long columns to geometry and add a spatial index while the data is in-flight.

ArcFM autoupdater in not invoking ​on feature create event using fme. in start up python script initializing arcfm license. I could see arcfm system autoupdaters are working but custom AU which is assigned in feature on create is not firing. Please help

The WB reading fgdb from UNC path , I tried to read from local machine same error, read different data same error .

Hello, I am currently working with some scooter mds data and I am trying to find references to help with pagination. I would like to be able to call page one and use a json fragmenter to process and then go onto page 2, etc. Has anyone worked with something like this before or has some ideas? I'd love some input. The API has links in the json that have "first", "next", "last" that reference the corresponding page number. My thought was to keep referencing the "next" page url for processing until the last page: It looks a little like this: next: http://(scooter provider mds)trips?end_time=(date/time)&page=2&start_time=(date/time) http://(scooter provider mds)trips?end_time=(date/time)&page=3&start_time=(date/time)

Hi Guys, I have closed multipacth building models. What I would like to do is distinguish verticals (i.e walls) from horizontals (i.e roofs). I tried to deaggregate geometry and calculate the vertical area of features (hoping to identify walls) but instead of getting vertical, I have verticals with horizontal components (like L shape surfaces). I was wondering if anyone knows a better solution to this problem ? Regards, Engin

Hi all, We are currently going through a process of creating our GIS system and currently choosing between the Geocortex solution or Esri Portal. In regards to FME, is there solutions which they have a better link with? Is there anything which has concerns with or both solutions fine for FME to work with. The reason is we have huge amounts of FME workbenches but I notice both solutions have their own workflow systems. Also what solutions are used and prefered by users on here?

I am trying to set up a Spatial Data Warehouse within a geodatabase. How can I get FME to create and maintain a running-integer surrogate key for my feature classes and tables? The surrogate key is a replacement for the primary key that has to remain unique and should be in a running integer format for every new row inserted into a feature class (e.g. 1, 2, 3, 4, ... 101, 102, 103).

Hello, Situation: I have 2 cameras for crowdcontrol. Measures people (walking, cycling) going in/out a certain area. Those cameras generate a stream that I can access through FME. This stream is in this format: When the stream is complete (or the timewindow is reached) we get an EOS (End Of Stream) thus the WebSocket connection can be closed. Is that possible? Because when connection is still open it does not write the output to a Writer. Database/Plain text file/.... I can only see the output with a logger.

Does FME support connecting to Azure SQL Data Warehouse or Snowflake? We want to be able to connect to and move data from either (or both) of those data sources into postgresql.

If I am using the HTTPCaller to send large amounts of data to server, it adds a Expect: 100-continue in the header of the request. Our server doesn't know how to respond to that and is causing problems. Is there any way to configure the HTTPCaller to not add that header?

@Hello! I've issue that maybe you would know how to solve, description: I am using FME Server 2020 docker-compose version and I would like to automate its deployment to my purpose - by adding a script that is creating repository/publishing/running some .fmws on it by REST API. The script would be another docker in docker-compose file. Unfortunately, you have to change FME Server admin password just after the installation to do operation there, and I don't see any other way than doing it manually in the UI. I've tried doing it by REST API but I get: Authentication failed: Password needs to be changed and must be reset. Please login to the web interface to update your password Is there another way to manage this manual step in my deployment process? Another ideas how to automate such operation are welcome! Thank you for reading! 😎

Hi, End Goal: To have my FME server have a workspace where a user can draw a polygon shape, and FME provide a ZIP file containing all watermains within that polygon shape area. I have a workspace (attached) that reads an ArcGIS Online Feature Layer (water mains), and i am attempting to use a set of coordinates as GeoJSON to clip this selection and output the selected areas water mains. I have been using this tutorial as a guide - https://s3.amazonaws.com/gitbook/Server-Authoring-2020/ServerAuthoring3SelfServe/Exercise3.html - but I am unsure how to get the coordinate systems to match. I understand the two items (the user input and watermain feature layer) need to be in the same coordinate system in order for the clipper to work, and I have no idea how to achieve this with these two data sources. I created a parameter (similar to the screenshot) with a default which is surrounding our local city: If I use the Visual Preview to inspect the 'geometry replacer', which is using my manually

I'm a blockhead: How can I read DWG files within a ZIP-file? I'm getting errors like this: ERROR |AutoCAD Reader: Error opening file 'c:\\temp_fme\\FME_TempFileStore_1598434178785_2600\\ds_1598434178786_2600\\5120.0400-025_T03_[20190509] - V_1598434178787_2600\\*.dwg' during version check WARN |A fatal error has occurred. Check the logfile above for details ERROR |Failed to obtain any schemas from reader 'ACAD' 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 My main purpose is to read a folder, where several ZIP files are in which each contain one or more DWG files (directly or in subfolders). Any suggestions or hints?

I have a simple FME workbench published to our FME server that accepts a .bat file as the only published parameter. I cannot get the right syntax to get it working from a python request in a standalone python file. The end result will be running an FME server workbench from a QGIS python script tool within the QGIS desktop GUI. The idea is to use the speed of the server to get the results back to the user quicker than running it on their machine. The result from Python 3, using the example from the FME Server Website (changing fmerest/v2 to fmerest/v3 here: https://playground.fmeserver.com/python-request/): IDLE Console results: http://myserver:myport/fmerest/v3/transformations/commands/submit/DataProcessing/RunBatchFile.fmw Traceback (most recent call last): File "C:\GIS\Tools\ProjectSpecific\FME Run Workbench\Run Workbench from Python Request.py ", line 35, in <module> r = urllib.request.urlopen(req) File "C:\Users\aallan.BUROHAPPOLD\AppData\Local\Programs\Python\Python37x64\lib\urll

HI. I try connect unc path to resource in fme server (like: \\\\{nameserver}\\folder). And i start fme core by network service. But i have some errore, when created new resourse. "We couldn't find what you wanted " Network service have a permission to UNC. Do u know how i can connected?

Hi all, I am trying to use the following link to setup a json file and automated script to extract data. It is the first time I have attempted to do this and I have used the httpcaller and also tried the json reader to get an output. I am just trying to tackle this one step at a time and very eager to get my first API working. In terms of the link I used https://api.coronavirus.data.gov.uk/v1/data which I added to the httpcaller. It did pick this up and then i was not able to get anything from the attributexposer. Can anyone assist with what they would recommend as next steps? Link to dev guide - https://coronavirus.data.gov.uk/developers-guide

I have FME Desktop 2017 and ArcGIS 10.6.1 installed. I followed all the steps in the FME Integration Console, but I didn't get the desired result. What is the problem? Thank!

I installed Postgres and set up the data schema. The source of the data are from several external places including databases and hard drives. I need to copy certain fields from the database and save them in Postgres tables. What is the best workflow to do this? Any guidance and tutorials are welcome, thank you very much!

I am trying to convert Public Land Survey System (PLSS) township or section data (shapefile or file geodatabase feature class) into a DWG or DXF file for our cadastral lead using FME Workbench on Citrix. I generate a new workspace with Reader Format ESRI Shapefile (for example) and Writer Format Autodesk AutoCAD DWG/DXF. Both coordinate systems are NAD83 Idaho State Planes, East Zone, US Foot [EPSG #2241], so I set that for both Reader and Writer. I set Writer parameter to Extended Entity Data. When I bring output back into ArcMap or ArcPro, annotation table is empty and test dataset shows up off the coast of Nigeria. Our CAD person says same thing (that the dataset does not seem to have a coordinate system and no text attributes). Not sure what I am doing wrong.

In certain cases, a model has been revised or changed, while you have the FME AR app open. It would be great to be able to refresh/reload the file (same filename etc but with the latest changes), without having to send/download/upload. E.g. produce files directly to the cloud, and prompt the user that a newer version of your file has been detected (if you always get the files from e.g. Google Drive or similar).

Hello Safe Community! My name is Brandon Whitney and I am part of a partner organization, Cityworks. I am a technical trainer who specializes in such things as Cityworks APIs and SDKs, integration with other platforms, and anything code-based. I have been working with FME software for about a year now and am working with individuals both at Safe Software and Cityworks to develop training around using Cityworks with FME. Thank you all in advance for asking great questions and helping others with knowledge, insight, and experience.

I am trying to run webhooks on FME Server. The webhooks run successfully and I get status code 200 from the server but when I check the length of the data in the response it is 0, in this case 0. Is there a header I am missing? from urllib.request import urlopenfrom shutil import copyfileobj def runwebhook(runurl): response = urlopen(runurl) if response.getcode()==200: print("Success") return response def savefilestream(filepath,response): if exists(filepath): remove(filepath) if isinstance(response.read(),bytes)==True: with open(filepath,'wb') as f: data = len(response.read()) print(data) copyfileobj(response, f) f.close() print("File Saved Successfully") else: with open(filepath,'w') as f: f.write(str(response.read())) f.close() print("File Saved as text") def runwebhookwithheaders(runurl,hooktoken): runresponse = None headers = { 'Authorization':f"fmetoken token={hooktoken}", 'Accept': 'application/octet-stream', 'Content-Type': "application/octet-stream", 'accept-encoding': "gzip,