Integration

Hi,Microsoft SQL Server Spatial reader connects successfully to a SQL Server entreprise geodatabase however it fails to retreive spatial data,throwing this error : Microsoft SQL Server Spatial Reader: Failed to load mssql_spatial_wrapper.dll. Cannot read/write curves and full globe and may orient geography incorrectly. Ensure Microsoft System CLR Types for SQL Server 2012 and Microsoft .NET Framework 4.5.2 (or higher) and are installedMicrosoft SQL Server Spatial Reader: Microsoft System CLR Types for SQL Server 2012 is available at http://www.microsoft.com/en-ca/download/details.aspx?id=29065. Please expand 'Install Instructions' and download 'SQLSysClrTypes.msi'Microsoft SQL Server Spatial Reader: If you have confirmed that Microsoft .NET Framework 4.5.2 (or higher) is no

When I select NTLM the workspace successfully runs on FME Desktop and FME Server with all features read as expected. When I select Kerberos, the workspace successfully runs on FME Desktop but not FME Server.  The following error is observed in FME Server: “ArcGIS Portal Feature Service Reader: Using authentication ‘Kerberos’ ”“ArcGIS Portal Feature Service Reader: Logging into ‘https://<my ArcGIS Portal host>/portal/’ as user ' ' ”"ArcGIS Portal Feature Service Reader: Could not log into https://<my ArcGIS Portal host>/portal/sharing/rest/generateToken as user ' '. Check your credentials and try again. The error code from the server was '400' and the message was: 'Unable to generate token. 'username' must be specified, 'password' must be specified." Idea

Hello class!In the attached PDF (in Dutch) I have an example of what I want to do exactly but the example was made with the PostMan program (but I can't follow the same steps in FME). Mainly the part of obtaining the Token (access authorization to the Melvin database). I would like to know how to authenticate Melvin API via FME? In this case with HTTPCaller transformer. I already have the Melvin account (username and password), but I don't know how to use this information in HTTPCaller. I have 3 requests, 2 Post and a Get: https://keycloak.ndwcloud.nu/auth/realms/ndw/protocol/openid-connect/token (POST) https://melvin.ndw.nu/melvinservice/rest/area/all (GET) 

Hello,I want to merge a jpg with a png over it.How can I replace this Paint.Net function (Merge Layer Down)?https://www.getpaint.net/doc/latest/LayersMenu.htmlThank you.

Below as a screenshot of the Revit project (what i am trying to export) followed by what i am able to convert and export into ArcMap. Missing room tags and door swings.

Using a RabbitMQConnector in Stream mode to continuously listen for change events. It is set to not Auto Acknowledge messages as we do not want that to happen until confirmation it is written to the database. Was thinking to use a FeatureWriter as it chains outputs after writing. Doing this with Transaction Type of None and it inserts/updates the features in real-time fine. But the output from the FeatureWriter seems to always be blocking. We ideally want to use that output to acknowledge the message in RabbitMQ. Would try a SQLExecutor but also need to write the shape to an ESRI geodatabase. Worst case can probably use a PythonCaller using arcpy. But would be nice to have a persistent connection with an actual writer. Any thoughts on how to do something like this while keeping a data steam going?  

Hello FME'ersWelcome to What's Up Wednesday FME User Conference NewsIf you're attending the upcoming conference, then you'll be happy to know you can now officially create your FME UC Profile & Personal Schedule online and in the mobile app!  Basically, you can see all of the sessions, mark which ones you'll be attending, browse the speaker list, look at event maps, and check out our sponsors. One event on the agenda is the FME Hackathon, 6pm-9pm on Thursday evening, and for which I'm now pleased to announce the themes:  Th

Hello I am using FME 2021.2 on an AWS machine and am connecting to an Oracle DB on-prem, but the connection is very slow. I currently have SQL Developer setup on the AWS machine and its connection to Oracle is as expected (fast). Issue:When I test the connection in FME it can take several minutes to recieve the pop-up saying 'successful connection'.I am using TNS and have setup the tnsnames.ora file I dont get any warnings or errors in the log When I use the same file for SQL Developer its response is very fastDoes anyone have any suggestions as to how to speed up that connection?

I try to retrieve Data from the Microsoft Intune MDM using OData. The OData FME Reader only supports Basic and NTLM Authentication thought and dhe OData REST API only supports OAuth so I had to resort to the HTTPCaller. This is similar to this Question I created a new Web-Service from the "Microsoft Azure Active Directory (Template)" template and extended the API Permissions in the Azure Portal for the Client App with the get_data_warehouse Permission. I already created it for the "Microsoft SharePoint Online" Web-Service (which works fine using the SharePoint Lists Reader).Authentication URL:

Hi.I'm exploring the possibility of making request to a secure server using FME.The webservices to be called require that the requests are accompanied by a company or function certificate. It will typically be stored in a certificate repository on the machine.I can make it work manually using HttpCaller with authentication = "Single Sign-On", but this prompts me for a certificate password every time, and the final script needs to run fully autonomously (on an FME Server).Any help is appreciated.Cheers.

Hello all, We are in the process of upgrading our software to 2021 from 2019 and I'm in the middle of UAT. I'm encountering an issue with the scripts that grab data from a Google Cloud Storage bucket using the GoogleCloudStorageConnector transformer. In 2021, when I try to reauthenticate my web connection to GCS I get this popup: I wasn't involved with the script design for the 2019 version (and my colleague who was is on vacation for another week). I did some research and found out that the stock settings for the GSC webservice need to be configured to match credentials in GSC. I created a OAuth 2.0 Client ID/Secret in the Credentials page in the GSC settings, and insert that information into the Client Information section in the GSC web service dialogue (my understanding based on documentatio

is there any way to get the data from https://www.cdc.gov/ecoli/2022/o157h7-08-22/epi.html  and This  https://www.cdc.gov/ecoli/2022/o157h7-08-22/map.html graph one or data table one ?

I have a file that has been converted from .ifc format to citygml format and I want to convert it to a shapefile. There is a problem with the coordinates and dimensions of the building. If the modeling is done, as shown in the following figure...Suggest me a set of solutions, please.?

Hi, We are creating an integration between Smallworld and FME Server. The Smallworld tool will call an FME workspace on our FME Server. The FME Server is hosted internally only and we are using built in authentication.  There is an option in FME Server to create a short lived session token via the api. I've set up a user that only has access to this repository that can be used to generate the token.  There is a second option in the Administrator interface to generate a fixed api token. When is this used? Is it more or less secure? The Smallworld developer notes that if you are using a user name and password to generate the short lived token then the risk is similar:'It seems to me that the API token with restrictions is more secure than username/password. Such a token is long and not recommended. It can be extracted from the Smallworld session and this applies for username/password.' For integration wi

Hello!I have trouble connecting to the Fme DataExpress app, I enter my login information, and the URL of our fme server, and it gives me this error: I would be happy to help if anyone knows the problem.Thanks!

I have merged the tables, it helped with the search but did not give me details about the specific table

Hi I am trying to merge about 15 sets containing information about green infrastructure in to one singular dissolved, multipart polygon. In ArcGIS I would use the Merge geoprocessing tool to all the the layers into one, select all the features and merge them. Finally I would do a dissolve. In FME I have fed all the input layers into a Dissolve transformer (dropping attibutes), fed the area output port to an aggregator. I am unsure what to do with remnants - I have fed Unused Areas from the remnants port to the Aggregator but not interior lines (I presume these are the dividing lines that have been removed in the dissolve?) - is this correct? Many thanks

It's a simple workflow: connect to AGOL, check for data, copy the new features to a service on internal Portal. But it's tripping me up every which way. I got the basic workflow going nicely, but it fails when I try running it via a batch file through Task Scheduler. Keeps returning an error message that it can't find the service. Same thing happened with Python which is why I'm trying FME now.I'm connecting to Portal using a OAuth2.0 web service connection but it doesn't seem to like working through Scheduler.So I thought I'd try a different authentication (tokens) and found a recently released 'ESRI Portal Token Getter' but there's no documentation to really help.Anyone have any success with it?

I am trying to build an API POST call using HTTPCaller for situations where there will be a dynamic number of parameters using the same name based on an aggregated list. In this instance, I have an attribute value called "fee id" which could have anywhere from 1-20+ items in the list (built using Aggregator) depending on how many charges were processed in a specific transaction. Each item on the list needs to be its own parameter (the values cannot be comma-separated), which is where I'm running into trouble. I can configure HTTPCaller manually to handle this, but that is only in my tests where I know ahead of time how many items will need to be processed.  I have been unable to find a way for FME/HTTPCaller to accommodate dynamically generating a query string parameter for each item in the list. Is this possi

I have a batch file which runs a WB nightly. It also write a log file which is great. But is there a "universal" way to control that the workbench ran successfully? Or do I have to make a script to scan the log file for key words? What key words would that be? Hopefully there is a better way?

I am trying to find a way to get the data from IFC file and import it to postGIS data. I tried to do it using a reader of IFC and a writer of postGIS, but then instead of saving 3D data - I get only 2D. When I tried changing the geometry type to geometryZ - I get "Error geometry type parsing" I tried to convert first to GML, and from GML to save to postGIS, but that also didn't work. I would appreciate some help hereThanks,Elyran  

Hello ! I use a SystemCaller in order to copy files.This files come from 2 differents folders and have to be copied from to different ways (command lines are differents) and - in addition- I want the user to choose if he wants to "copy/Y" or "Ycopy" the files.So I have 2 types of command lines from 2 publics parameters but they have the same values "Copie SANS sous-dossiers" and "Copie AVEC sous dossiers":AndSo when the user run the workbench he has 2 parameters to choose but they are named the same way:It is possible to link

Hello, we would like to connect a vpn connection in a workspace in order to transmit some data from our folders found on our own server to another distant server. Is this possible with FME Desktop? We use Forticlient as a remote access. Thanks!

Hi All, more or less the same as this query, but checking if anyone has any suggestions on a solution for downloading emails received to an account monitored by fme server? The email & content is used as a topic/trigger to start a workspace, i now need to also download a local copy of the email itself (eml,msg file). Is there a way to do this though fme?

Hi folks,I am getting some obscure errors (Dropbox API I assume) using the DropboxConnector with bigish files >300 mb.Looking at the error and the Dropbox community I am assuming FME is using the /2/files/upload endpoint which is limited to 300 mb. Can anyone confirm there is an upload size limit with the DropBoxConnector? Workaround?