Authoring

I have a column of data with a 10-digit alphanumeric value.  I need to keep those values and in a new column return just the last 5 characters of that columnI thought it would be as simple as creating a new column in the attribute manager and then in the attribute column I put in the string function @Right(NODE_NUM, 5)I have tried at least 4 or 5 different formatting methods, using quotes “ “ or extra parentheses while writing out the string function, but I am lost.  I use this exact same string function in MapInfo all the time and it works like a charm.  But when I put in these values in just inserts “e_num” into each row as e_num are the last from characters of NODE_NUM.What am I doing wrong?results inThanks in advance

Hi Community, I am working on developing a workbench which is basically reading Data from ESRI Enterprise Database and Writing to another DB. I am using ArcGIS Pro Version 3, FME Desktop Version 2022 and FME Flow Version 2023. I am able to connect and read data using FME Desktop But the published workspace while reading the data it is showing error “779 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 780 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 781 2024-3-19 11:07:16 | Performing query against GEODATABASE_SDE dataset `' 782 2024-3-19 11:07:16 | Creating reader for format: Esri Geodatabase (ArcSDE Geodb) 783 2024-3-19 11:07:16 | Trying to find a DYNAMIC plugin for reader named `GEODATABASE_SDE' 784 2024-3-19 11:07:16 | Opening the Esri Geodatabase reader 785 2024-3-19 11:07:16 | An ArcGIS license is already checked out. The product checked out is 'Advanced' 786 2024-3-19 11:07:16 | Ins

Hi I’m using FME Workbench 2019.2 to read a DGN-file and then transform that to an SVG-file.This is working quite fine but we have seen that the texts are slightly offset. I did some investigations and figured out that if I could move the text-features to the coordinate value that their attribute igds_insertion_x and igds_insertion_y pointed to then was the text more accurate placed in the SVG-file.So I used an Affiner to move the text features to coordinate (igds_insertion_x,igds_insertion_y). But the strange thing is that after the Affiner is executed then is the values fme_text_size, igsd_text_size, fme_rotation,igds_rotation changed. The inspector  below shows the same text before and after the Affiner.  Am I doing something wrong here or is this a bug? RegardsNils

Hi, I have this problem on FME qnd I don’t know how to fix it : Microsoft Excel Reader: Connection failed. Connection string `Provider=Microsoft.ACE.OLEDB.12.0;Data Source=DictionnaireVariables_ITV.xls;Extended Properties="Excel 8.0;IMEX=1;HDR=YES"'. Provider error `(-2147467259) Erreur non sp\xE9cifi\xE9e'Can you help me please ?

FME friends,As you know, the Transformer Gallery in FME Workbench is the window that exists in the lower left hand corner of Workbench, and gives you access to transformers.However, now that most people are using Quick Add instead, we are considering removing the Transformer Gallery from Workbench completely.Obviously, with a big change like this, we want to first get your feedback on how this might affect you.So please:Visit this page to find out more information and to cast a vote in our poll of users. Add your comments to the thread below (but do check out the other page first).I closed the poll. The results are 66% to remove the gallery, 33% to keep it. I’ll let you know what the product managers decide and will share any updates I get.You can still leave a comment below to let us know what functionality you would miss by the gallery being removed.Thanks for your feedback.Mark

Is there a way in Form to find out the active FME Flow Connection when running a workspace?I thought it might be a (hidden) parameter somewhere, but I can’t find it immediately, and it doesn’t seem to appear in the logs either.I was wondering if I could use it to determine which environment I’m working in, setting up a development parameter is an easy workaround but might be useful one day to know/log the active flow connection anyways

Running into issues while running a workspacef_85 (HTTPFactory): [4]: HTTP transfer error: SSL connect errorf_85 (HTTPFactory): [4]: Please ensure that your network connection is properly set upf_85 (HTTPFactory): [4]: No proxy settings have been entered.  If you require a proxy to access external URLs, please ensure the appropriate information has been enteredf_85 (HTTPFactory): An error occurred while accessing the URL 'https://static.inaturalist.org/photos/355260564/medium.jpg'The below feature caused the translation to be terminated 

Hi how can create a perpendicular line that connect point to line, I mean I need to connect red points to blue line with a perpendicluar line  thxFrancesco  

Hello FME community, I have a workspace which I always run with quick translator. Since my user parameters are never going to be changed, is there a way that I can simply double-click on this file and it runs with quick translator without the need to click OK or press Enter to confirm the user parameters? 

I’m on 2022.2 and using a StatisticsCalculator with a Group By (based on the name of a CSV) to get statistics (min, max, mean) on a handful of attributes.  It works great for all but 1 attribute (Specific_Gravity) and I can’t figure out why.  The attribute type (64 bit real) is the same between Specific_Gravity and Temperature_F so I’m not sure why one works and the other doesn’t.  The kicker is that I can get Mean values for Specific_Gravity but not Min or Max.Do I have the transformer configured incorrectly, is it a data type issue, or something else??Screenshot of transformer with results: 

I have a dataset of features that I'm trying to insert in a Postgres (pg14) database. That data has a number of text columns that together make up a "report name" plus a timestamp. The name and timestamp together make up the primary key of that dataset. There are also some more columns that contain the actual data. The table I'm inserting this in currently has 800 million rows, and I'm inserting in batches of around 50k rows about a hundred times a day, so keeping indexes small is important. Given the above situation, the text columns from the "report name" have been put into a separate "dataset_reports" table" (~60k rows); with the timestamp and actual data being stored separately (with a foreign index) in their own heavily partitionned "dataset_reports_data" (~800M rows) table. In order to insert data in that table, I need to upsert dataset_reports with all the unique report names in my feature set in a first pass, then get the FK value for all these reports and then I can insert the

We have FME 2022 with floating lic, with 2 editions, Database, and ESRI.   Would like to install FME Form 2024.0 along side FME 2022.  I know at some point Safe did away with Lic Editions, any idea if we can use the same  FME 2022 lic file and make it also work for FME Form 2024 ?  .

I have a workspace in FME Form 2021. It includes an Automation Writer. This writer writes keys from FME Form to my Automation in FME Flow 2021,  Given this is the 1st time I have pushed FME Attributes into an Automation as Keys, just being curious, I clicked on the “View Written Data” icon in the Automation Writer. It gave some errors and a new windows opened with red in the parameter boxes. It would seem wise to disable this icon when a Automation Writer is chosen. Are there any plans to do this? This does not impact my workspace or Automation. It just seems a bit annoying, unless I am missing something? See my screenshots for a better illustration of what I see happening:  

Hi when I try to setup the coordinate system for my reader to EPSG7792 the Arcgis data interoperability doesn’t have  Can you support please ? thx Francesco  

Our company has a new credit card. So, I have to change it in the billing in FME Hosted. But there no place to do this. As far as I know i'm the admin, so should have all the rights.Does someone have an idea?

Is it possible to read field aliases from an ArcGIS Feature Layer? I see there is a way to do this if connected to an Esri File Geodatabase, but the data I am working with is service based. I am currently using a FeatureReader connected to ArcGIS Enterprise.Thanks in advance!Sasha

Hi allI need support please I’m not expert in sqlite db and I understood that there is a column called rowid I create a sqlite db but when I open this db in sqlreader I see that the values present in the rowid column start from 1 my reques is I need that the values present in the rowid colums must be equal to the values present in the Id column. thx for support  

Hi,I am trying to copy files within a work flow using the feature writer transformer. i dont want to use the writer as i want to carry on processing down stream of this action.in the filecopy writer i can set the destination folder as below. however i cant see out to populate the parameter's in the feature writer, or its not clear. Anyone else managed to get this working?Thanks,Andy  

So I’ve worked with JSON in fme quite a lot, and I’ve even used the JSON syntax highlighting when trying to delve into it. What I did NOT realise though was that the JSON Syntax will automatically format the JSON for you - no need to use a JSONFormatter to help you read it.Probably this was know to others already but for me this was a nice surprise

My workbench creates a number of excel spreadsheets. Sometimes it fails due to users having one of the spreadsheets open when the workbench runs during the night. Though that spreadsheet cannot be updated due to the lock, it would be very useful to still be able to update the other spreadsheets rather than the entire workbench stopping completely.Can a writer error be bypassed or ignored?

Rebooted my computer, no crashes, no issues, upon reboot, FME Workbench throwing this error and not starting.  Any suggestions to fix the issue?

Is there a way, similar to AttributeExposer, I can import the columns from a CSV file and use that to identify what columns to keep? I’m reading a number of CSV files into a workspace with different attributes for 3 different file types and there are over 300+ columns. A picklist approach is a bit cumbersome.

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. So far this is what I’ve tried:    def input(self, feature):        first_list = feature.getAttribute(

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 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 ?