Integration

This question relates to another question / post regarding Oracle SDO_GEOM data types. We have both ST_GEOM & SDO_GEOM data type fields in our Oracle database schemas that we want to replicate to a Snowflake data warehouse.

HiAfter our server was upgraded to fme flow, the jobs that run together with ESRI services (gdb, sde) do not run, and this error is given: Unable to perform any licensing related tasks. Please check your Esri ArcGIS Compatibility workspace parameter, found in Navigator -> Workspace Parameters -> Translation. This 64-bit version of FME requires ArcGIS Desktop along with 64-bit Background Geoprocessing; ArcGIS Pro; or ArcGIS Enterprise. Refer to this this article http://fme.ly/qua for more details Of course, in the previous version of the server, everything worked smoothly,And also when I run the same jobs on the server's machine, along with fme form, everything works fine.There is ArcGIS Pro with a license, and full access for all users.I would appreciate your urgent help!Thank you!

I want to replicate oracle tables with SDO_GEOM data types to a Snowflake data warehouse without any transformations before. Just a straight up replication of the complete table, including the SDO_GEOM data field. Can Safe FME do that?

I have followed the steps at https://community.safe.com/s/article/How-to-create-an-FME-Web-Connection-for-Esri-ArcGIS-Portal-Feature-Service-OAuth-2-0?t=1688516897087 for FME Form only.  After I am presented with the authentication challenge and log in with our portal administrator account I receive: "unable to retrieve access token""Request to update access token failed. HTTP Error: HTTP/1.1. 500 Internal Server Error

Hello, FME Desktop users and educators, I hope you are all doing well. Today, I'd like to discuss a pressing issue I've encountered with FME Desktop while using it alongside classroom management software for teaching and geospatial data processing. It seems that there are compatibility challenges between FME Desktop and certain classroom management platforms, and I'm eager to hear your insights and experiences on this matter. As a geospatial instructor and avid FME Desktop user, this software plays a vital role in my classes for data integration and transformation. However, since incorporating classroom management software into my teaching methods, I've come across the following issues with FME Desktop: Screen Sharing Glitches: Attempting to share the FME Desktop interface during live classes or collaborative data processing sessions often leads to screen sharing glitches and freezes. These interruptions disrupt the flow of the lesson and hinder students' ability to

Our salesforce writer credentials need to be updated as a workspace is moved between environments, there doesn't seem to be any easy way of verifying that the values copied and pasted are correct without running the workspace Any suggestions?

Hi all,I have succesfully transformed IfcDoor-entities into (shapeless) dwg-blocks with the extracted information being written into the dwg-block. Now I would like to rotate the block parallel to the respective door. But I do not konw how to retrieve this information. I thought I could derive the rotation / orientation information from the footprint (identifiy the longest line-segment of the edgecurve), but I dont know how to do that either. Can anyone give advice on this matter?thx in advance!

Hi,I am trying to put query where clause in feature reader. the reader data is from esri Portal Feature Serice. I would like to put bounding envelop into where clause. I am not sure what is the clause should be. I would not like to query them all then do intersect. i would only like to query everything in the box I defined. the clause i am using somehting like:geometryType=esriGeometryEnvelope&geometry=1.6407885025300004E7,-4272238.302200001,1.6703666006300002E7,-4088621.626699999. it didn't workI would like to know:where clause support extent clasueif so what is the correct the clause structure. Thank you very much.

I am trying to connect the odata Equipment API for SAP Hana https://api.sap.com/api/OP_API_EQUIPMENT/overviewbut i am getting authorisation errors - HTTP/1.1 401 UnauthorizedHere are the paremeters as i have set themAt this stage i am just trying to connect and get a token.I am using a HTTP caller as we will be using the odata services to create adn update Equipment and Functionla locations in SAP as an integration between our ESRi Utility Netowrk model and SAP. I have attached the log file.I have successfully connected to and run the get call from postman on the same computer and successfully connected to movebank as per the http caller tutorial.Does anyone have any ideas on what i am missing? doen this before successfully? Thanks  

Hi All, Just wondering if anyone might be able to spot something I am trying to troubleshoot. I have tried all things I could track down forum-wise. I am stuck connecting to ArcGIS Portal 10.61. I used to be able to but after an upgrade to Pro 3.0 (not necessarily the case but happened around the same time) I have not been able to connect. I can connect to ArcGIS Portal 10.91 fine. This is using the Reader and the Hub Portal reader/transformers. I get the following when attempting a connect via get token or via web service. I downgraded to Pro 2.9 just in case but no luck. Running latest pre-2023 version of Form. Any pointers would be greatly appreciated. Thanks All!c.Connection attempt using get token Using Python interpreter from `C:\Program Files\FME\fmepython310\python310.dll' with PYTHONHOME `C:\Program Files\FME\fmepython310'Python version 3.10 loaded successfullyArcGIS Portal Feature Service Reader: Logging into 'https://arcgis02.trca.local/portal/' as user 'gisportal'Python Exc

I am trying to set up my anaconda environments in FME, using the custom interpeter function. As interpeter I selected the .dll file (C:\\(...)\\anaconda2\\envs\\gdal\\python27.dll). This succeeds in recognizing Python and having a basic setup. However, my packages are not included. Trying to import geopandas, which works fine in my Anaconda editor, results in the following error in FME:Python Exception : No module named geopandas 2018-12-04 12:50:20| 0.5| 0.0|ERROR |Error executing string `importfmeimportfmeobjectsprinthelloPieterimportossys#sys.path.appendrC:UsersfvzfAppDataLocalContinuumanaconda2envsgdalpython.exeimportgeopandasasgpd#fromrasterstatsimportzonal_statsprinthelloPieter#TemplateFunctioninterface:#Whenusingthisfunctionmakesureitsnameissetasthevalueof#theClassorFunctiontoProcessFeaturestransformerparameterdefprocessFeaturefeature:printhelloPieter#TemplateClassInterface:#Whenusingthisclassmakesureitsnameissetasthevalueof#theClassorFunctiontoProcessFeaturestransformerparamete

Good morning from Vienna!This might be quite an easy task for advanced fme-users, but I have not too much experience working with fme. I have a task to read ifc-files and use the ifc-space information and location for write to dwg-files. I have one autocad-block as a template to be placed into the center of each room. So my idea is to derive the centerpoint of the footprint of each room and use those xy-coordinates for the autocadblock-x and -y. I just can't find a way how to merge both datastreams... FeatureMerger-Transfomer? but what data can I join the two streams on?Thx for your help!

ArcGIS Portal Feature Service Writer: Writer configured to use Global IDs, but this is not supported by the Feature ServiceARCGISPORTALFEATURES writer: A fatal error has occurred. Check the logfile above for detailsFeatureJoiner_3 (FeatureJoinerFactory): A fatal error has occurred. Check the logfile above for detailsFeatureJoiner_3 (FeatureJoinerFactory): ARCGISPORTALFEATURES writer: A fatal error has occurred. Check the logfile above for details

Hi, I am trying to make the FME KafkaConnector working. I first tested this connector to produce to a local Kafka server without SSL and authentication. That all works fine.  Now I am trying to get it working on our company Kafka instance. This instance requires two-way SSL authentication, which means that I have client certificate, private key and password for the private key. I have configured the Kafka connector as in the screenshot below:  The advanced options are set to:  with this configuration, I get the following error message: This message is very non-descriptive; it could be anything. Also if I turn on further debug logging in FME, it doesn't give any more details about the cause of the error. As the FME Kafka connector is based on the Confluence Kafka Python library, I have downloaded and configured a producer using this library. The Python code is shown below: from confluent_kafka import Producer  p = Producer({    'security.protocol': 'SSL','bootstrap.servers': 'broker.str

Hi,Does someone have a workspace example how to collect all files in a folder for creating a ZIP-file to send to the Mailer-transformer?I am using FME Desktop 2022

We're getting some strange behaviour with FME Server 2022.2.4 running on Windows Server, wondering if anybody else has come across this or has any ideas of how to resolve.  We have a workspace which accepts an input text file and then does some processing on it. When running the workspace through the REST API, or through the FME Server interface, the file is first uploaded and then the workspace processes it. We are finding that the uploaded file does not get overwritten. i.e. First we upload file A - all works fine the first time. Then we rerun the workspace, uploading file B. File A does not get overwritten and the workspaces processes file A instead of file B. In this log file: C:\ProgramData\Safe Software\FME Server\resources\logs\tomcat\<machinename>\catalina.2023-06-19.logWe see the error below:19-Jun-2023 11:28:21.685 WARNING [http-nio-0.0.0.0-80-exec-8] COM.safe.web.upload.StoreManager$FileDesc.<init> null    org.apache.commons.io.FileExistsException: File element i

Currently trying to UPDATE isolated features within an existing Versioned sde table (ArcPro Only) using the Esri Geodatabase (ArcSDE Geodb) writer. Considerations: Schema has been Imported from DatasetTransaction Type has been set to: Versioned Edit SessionSuccessfully written to a TEST.gdbTable has been READ into workbench, joins and ETLs applied to data, then attempting to WRITE to same table back in SDEHave toggled Ignore Relationship Info to no availError Code:Error while updating feature in the table/feature class 'Addressing'. The error number from ArcObjects is: '-2147207389'. The error message from ArcObjects is: {}

Hello all, I was planning to do a small workshop on FME Data Express... While preparing this, I found shockingly little information on the specific parameters I could use to interact with some specific phone-app functionality. This ... was the most informative post, noting 'We are still working on our documentation.' two years ago. How do I make the app ask for a QR-code?Can I somehow consume a picture?I seem to be able to get the location of the device with a specially named text-parameter. Are there more of those? Please, give this app some tender love and care in the documentation. Give it a technical blog-post and some example workspaces one can upload to ones own server as a startingpoint.. Martin

I'm using HTTP Caller for geocoding adresses, but somehow I'm getting randomly lot of 400 responses - e.g. 2 of 12 calls are succesfull. If I copy paste the URL from error log to browser I'll get the result correctly.I'll share the worspace template temporarily including the API key of Geoapify. I don't know why I'm getting 400 (bad request).

Hello , I am working on migrate the data from arcmap to utility network and I have read some articles that FME can help in data migration .could someone explain me ,which ideas and steps should I consider to success in converting data from arcmap to Esri electric utility network Thanks in advance FME 2021  

I have an API Key from MaintainX but I'm trying to get pass the first stage of Authentication with Bearer Tokenhttps://api.getmaintainx.com/v1/docs

Hi there, Until a few days ago we had a working SharePointOnline Connector in FME which uploaded a .dwg file every day. After updating to FME Workbench 2022.2 that stopped working. A saw in the webservices options that the Tenant-ID was replaced with the string 'common' so I reverted this to our setttings. I used this YouTube-video for implementing the right settings inside FME. I can test the webconnection which is succesfull. But encounter a number of error messages. See below. I've also been troubleshooting together with IT to make sure that all proxy/FireWall settings are correct but nothing has changed there.Thusfar I've encountered the following error-messages:   As of now FME also stopped opening the webservices settings menu. It just shows the blue windows loading circle. Hopefully some of you recognize these errors and point me in the right direction for a solution. Thanks in advance! best regards, Jaap 

Has anyone tried using FME to connect CityWorks to Kronos time keeping? We'd like to have the time codes sent directly to Kronos instead of having someone manually enter them in.

Hopefully this doesn't ramble too much... I've been tasked by my Organization to standardize our development processes and implement clean, repeatable deployment processes across all of our environments. This means storing all of our integration configurations in version control (git), and being able to use pipelines to auto deploy to any environment at will. Over the last 6 months, I've built a PowerShell module that:Deploys Workspaces (if they have changed against the server version)Registers ServicesDeploys/Updates TopicsDeploys/Updates SubscribersDeploys/Updates PublishersDeploys/Updates Schedules The process is getting much better, but still has a few dependencies:A "sandbox" FME server environment, where all of our work is deployed manuallyDevelopers create a "Project" on the Sandbox FME server and adds all the dependencies for their integrationA workspace is run that exports that Project into JSON format, along with all settings, parameters and op

I have a workflow that needs to run completely offline, where the customer wants to be able to navigate using a map, and then once at a given location, click on a feature on the map, and pull up a specific model in an AR environment to illustrate what the future conditions at that site would look like. The model would need to be geolocated/anchored for a simplified experience for the user.   It would be very easy to create a url within the mapping app to send to FME AR (to include the model name, even an insertion point, etc.) I am curious if FME AR supports a deep linking capability that many other mobile apps support. I cannot seem to find any documentation on this topic, so any insight is appreciated.