FME Form

Hi,I have to carry out a project to produce and publish an interactive web map to disseminate data on traffic osbstructions and works in progress in Montreal.However, the data used can be downloaded in CSV format from the City of Montreal's open data portal, but also accessible via the API provided by the City's open data team, the link is as follows:https://donnees.montreal.ca/dataset/info-travaux/resource/cc41b532-f12d-40fb-9f55-eb58c9a2b12bWhat is the complete workflow process to retrieve data from CKAN Web Service API using FME Form?Attached is my incomplete workbench of my workflow that I tested using HttpCaller Transformer to test connection.Please provide me with some possible solutions.Regards, 

Hi, I've been working with a web connection to Sharepoint Online, created with help from this article:How to Create a SharePoint Web Connection for FME Form [Single Tenant]For SharepointOnlineConnector. It works for a time, but after a day or two there is a problem with refreshing my access token. This was the error message today:Updating access token for 'Microsoft SharePoint Online'Request to update access token failed. HTTP Error: HTTP/1.1 400 Bad RequestPython Exception <FMEWSException>: Type: 3, Number: 1, Message: Failed to get authorization header.If I reauthenticate my web connection It works again for a time.Any ideas what the problem may be?

Hi, I'm reading around 5 million rows from the 252 Excel files. I need to view the rows to delete many columns and edit values, but indexing the results is taking a long timeHow can I improve this? Thank´s

Hello,So I am having the time of my life with Italian WMS’s 👌 and some of them even have some table data queries connected to them. I would however like to get the table information for more than one feature at at time, instead of opening in PRO and click each polygon and collect. Knowing that FME does not support standard GetFeatureInfo yet then I’m speculating if someone has created some artful way of achieving this anyway (sure there are plenty of those).So far my idea is to fetch a center point for each of my respective polygons, do coordinate extraction and then add those values to a standard HTTP based GetFeatureInfo request with some FME string gymnastics. The WMS in question is this here:

I have a dataset of around 200,000 records (point geometry with approximately 10 attributes).I am using the Change detector transformer to update only those records that are updated and to add new records or to mark some as deleted records.I am using the Feature Writer transformer to write the data into an ESRI Enterprise geodatabase in MS SQL in Azure Cloud. Source data resides in the same geodatabase in Azure Cloud.!!! FME Server is installed on premise, not in Azure !!!When initializing the ETL by truncating the destination table and initial loading of the data, the 200,000 records are written in about 7 minutes.!!! There is an index on the attribute that is used as Primary Key and that attribute is indicated After the initialization, the time to perform the ETL is still low (5-8 minutes) if there are no updates on data, or if the

Translating using 2014 igds_text sixe 8 translates to Height and width 0.08 however translating using 2021 using the same parameters it translates to 0.00 and if it is a multi line text with 3 lines of text it translates to 0.03.  I did try other scaling sizes even up to 20 and the results were the same. Please advise  Since I need to do an upgrade and don't want to have to redo all of my text items I installed and tested FME 2017, 2018, 2019, and 2020.. It appears that the text change happened in release 2020. I can use the same FMW file that I created using 2014 and it works fine for 2017, and 2018.. I did have a glitch using 2019 but once it ran the data was correct. Starting in 2020 the text sizes were all messed up. I am hoping someone can advise me on what may have happened.

Hi all, We are trying to configure Azure AD SAML authentication for FME Server 2022.2 . We have used the express installation and then configured an IIS reverse proxy. We are getting the error in the attached image. Is Azure AD SAML authentication with an IIS reverse proxy supported? https://community.safe.com/s/article/Configuring-FME-Server-for-Azure-AD-SAML-authenticationhttps://community.safe.com/s/article/using-iis-and-arr-as-a-reverse-proxy

As the title says, I have two different point feature classes, and then a table in the geodatabase.  Point A has a unique field value that matches from the point to a record in the table and then, that record in the table has a unique value that matches to Point B. I want to use this “connection” and the vertexcreator transformer to create a line from Point A to Point B, for situations where they match, but I am stuck at the moment and can’t seem to connect the dots. Pun intended. 

I have an AttributeManager in a custom transformer (may be part of the problem but thought I would start simple with the AttributeManager) that has the following data (correct) on the input but the name of the attribute (not the attribute values) is assigned in the output.Input Attribute “Public_Water_System_ID” with correct values and output with wrong values:Settings in the AttributeManager is as follows:For data type I’ve tried buffer (default), varchar(20), and char(20). None of the other types seemed to make sense since the values are string.Perhaps a related problem is that this attribute (“Public_Water_System_ID”) is passed as a parameter into this custom transformer

I have been tasked with connecting to an FTP site, retrieving a csv file, parsing that file into multiple Excel worksheets within one workbook and then FTPing the Excel spreadsheet back to another FTP site.I have all the component pieces working, in 6 different workbenches, the download of the original csv file, the parsing and writing of the data for each Excel sheet and creation of the four individual worksheets and the upload to the destination FTP site.  However, I have been advised by the local FME Admin that the process should be housed in one FME workbench.  And in order to achieve that, instead of downloading a physical csv file, I should be downloading the data as an attribute so that all of the subsequent processes could be housed within one FME workbench and the attribute data shared by each subsequent process, leaving no artifacts at the conclusion of processing.I have created one FME workbench and copied all of the processes into it and made all the adjust

Wich versions FME desktop are compatible with pluggin Smallworld 4/5?

Hello,I have objects, that have a list with a number of different attributes. One of the attributes on that list is another list with a few attributes. Both lists contain 1 - n elements (if either one of the lists is empty, the object is not valid). So, a bit more visual: Object1.list1[0].attrib1Object1.list1[0].list2[0].Attr1Object1.list1[0].list2[0].Attr2Object1.list1[0].list2[1].Attr1Object1.list1[0].list2[1].Attr2Object1.list1[1].attrib1Object1.list1[1].list2[0].Attr1Object1.list1[1].list2[0].Attr2Object1.list1[1].list2[1].Attr1Object1.list1[1].list2[1].Attr2 And so on. What I want to do is check all list2.Attr1 for a certain value, then add list2.Attr2 as an attribute on Object1 (for easier processing and reporting). Due to a large volume of data it isn’t really feasible to use ListExploders (I’m already running into memory issues as it is), so I thought I’d try the Pythoncaller. S

Hi!I would like to change a value from a list based on the fme_attrib_info{}.field_name.For example I have :fme_attrib_info{0}.field_name : PROJ with fme_attrib_info{0}.field_value : value1I would like to do : If fme_attrib_info{x}.field_name = PROJ so change value1 by value2.I have a lot of attributes so I have to call the attribute by his name and not by the index manually.I thought to PythonCaller but maybe it exist a transformer for that. Thanks!

Hi I’m trying to combine some linear events with a routes geometry. The segmentation works fine. The only problem I have is that the from-to values are no longer correct in the new geometry. How can I update them?  

I am using SQL Executer but in the output port I am not getting the attribute exposed automatically. My SQL expression I am only counting the inputs so I cannot expose the attribute using “Populate Attribute from SQL”. I cannot use Attribute exposer every time I am using the SQL. Is there any other way to do this.

I have about 20,000 adresses and 10 locations of the same sort of destination (eg. a doctor). I have already a network.I'd like to calculate the shortest path between each adress and the nearest doctor over the network.Is there a way to utilize the shortestpathfinder for this?I tried the fromToBuilder to create from-to-lines. However, the fromToBuilder requires a join field for each from and to location. Which I would then have to create manually for each adress (and so create 200,000 paths; 20,000 * 10). The shortest path could then be recalculated after the shortestpathfinder to get the closest doctor for each house.Is there perhaps a more efficient way to do this? 

I am using FME(R) 2022.1.3.0 (20220928 - Build 22630)I noticed while working with ArcGIS Data (FileGeodatabase), that when I usethe “DatabaseJoiner” Transformer to join attributes with curly brackets inside its values, the curly brackets are gone after joining. e.g. Original Attribute value: {12C300A2-64C3-4494-A1E2-430CC5C5C7A9}joined value by DatabaseJoiner: 12C300A2-64C3-4494-A1E2-430CC5C5C7A9It this a known behaviour? Why would it get rid of the curly brackets? Anything to do against it?

Hello, i’m triying to insert / delete data in a table using Geodatabase connection in the writer but it shows this error message while insert : An error occurred while attempting to store a row into the table 'FCL_EQUIP'. The error number from ArcObjects is: '-2146232832'. The error message from ArcObjects is: {ArcGIS-error creating a new feature !(BaseUserSession::Application not initialized.)} and this while delete : Error while deleting feature in the table/feature class 'FCL_EQUIP. The error number from ArcObjects is: '-2147217402'. The error message from ArcObjects is: {}All edits made during the edit session were savedA fatal error has occurred. Check the logfile above for details

Today I cover a frequent issue: how to run FME from the command line, specifically with Windows Scheduler. Question of the WeekThis question was asked in Live Chat by a user with a problem with database connections and Windows Scheduler. Q) In my workspace I use a writer that connects to SQL Server via a SQL Server account. In Workbench, the workspace runs and data is inserted. But run through Windows Task Scheduler, it fails with SQL Server issues. I've set the username and password in the writer, but in the log file it appears to be not set! A) This type of issue appears quite often. In short: if a workspace works in Workbench, but fails in a different environment, it's 95% likely to be a permissions issue. Let's look at a few sticking points and - in particular - this scenario, which is harder because there's a database connection involved. 

Hello everyone!I am beginning this conversation with two goals in mind. First, I would like to share and discuss my new transformer OpenAIGeographicCreator, and second, we at Safe would like to see how a post of the new type, “Conversation” performs in the community. The idea is to have a way to expand conversations beyond simple “question-answer” style and have meaningful discussions among multiple participants about problems, solutions, functionality and everything FME related. Here, we could run our ideas by the whole FME community, get advice or inspiration and share our successes and even failures - together, we may be able to help.So, the story of this transformer began with @bruceharold’s idea here: 

Hi All,I’m working on a workflow to project a DWG from one coordinate system to another. The workflow works fine but am having issues to write autocad_oriented_arc into the DWG final output. I did some test to write it to GIS format and those autocad_oriented_arc write ok but for some reason can’t get them to work in DWG format,I’m sure that am missing some settings in the writer because the visual preview shows those arc fine, see below: I’m using the following:FME(R) 2023.1.2.0 (20231110 - Build 23641 - WIN64)Writer Autodesk AutoCAD DWG/DXF parameters as follows: Thanks!

Hi I am using FME Form 2021I am passing a ArcGIS portal login (including domain) as a user parametere.g. username@sss.co.uk When I try to get the value in pythonCallerportalAdmin = str(FME_MacroValues['ArcGIS_Portal_UserName']).strip() It is coming asusername<at>sss.co.ukI am unable to use this to login to my portal in pythonCaller. Any idea how to escape the @ sign ?

Five months ago, I created a small FME application that would login to a state controlled secured FTP server and download a file to a local drive.  Putty was used and files were generated for local use and for the state. That application was working fine, however, the agency that made the request was not able to approve the process in the interim.Now, five months later, when I run the application in FME, the login is rejected.If I use the exact same parameters to manually download the file with WINSCP I am able to login and download the file without a problem. Nothing has changed in the setup of the FME.In the attached image, I show the three transformers and their parameters that I used to download the file.  Five months ago it worked.  Now it does not.  Manually, it works.  Via FME it does not.I am not sure if this is problem in the FME, an issue with my local network security or an issue at the State ftp site.The error message is a

Hello FME community, I have an issue I'm working on and can't seem to figure out the solution. I have two Excel tables. One with different kinds of certifications and the score each is given.Certification Score Certification_A 1 Certification_B 5 Certification_C 7 The second one contains Applicants with fields defining the various certifications and links to said certification. One applicant can have multiple certifications. We need to determine for each applicant which is the highest scoring certification.Applicant_ID Certification_A Cerification_B Certification_C 1  

I’m trying to repeat the same process on each group of features that represent each door (every door consists of many features having the same value of door_id) . on the other hand , the process that i want to create is detecting that line on green for each door and drawing it using the LineBuilder  .So for exemple ,if in my input i have : 200 features , every 30 or 40 features share the same door_id value (so there are say 6 doors in total )my output : 6 features (each feature is that green line , with the attribute door_id)