Authoring

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 t

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

Hi everyone,An inquiry concerning the FME Forms(Formerly FME Desktop) supported SMB (Server Message Block) version was sent to me by an infrastructure technician. Since the word was unfamiliar to me at the time in FME, I started looking it up in our community as well, but I was unable to discover any information.At last, I retrieved the SMB2-enabled version from the FME Forms installation server and distributed it to them. Are there specific details available regarding the FME desktop supporting version?I'd like to share this here in order to gain some clarification on this, and others who are in a similar circumstance might find it beneficial.🙏🏼Explore, Learn and Share it with all.. 

 Hello,I have installed a fresh install of FME Form 2023.2.2 on a Ubuntu VM with Azure. When running workspaces on FME Form 2023.2.2 with workbench, everything runs smooth. I have imported a manual license to the licensing assistant.However, I am trying to also install some python packages on this Linux VM. So we can transfer this to our Kubernetes Environment which also runs on Linux. We cannot install these packages on a Windows Machine cause they won't work on the Linux.Script: sudo /opt/fme-form-2023/fme fme -m pip install pandas --system --target /home/adminnordend/.fme/Plugins/Python/python310 After running this command we get the following Error: FME license system failure: FME is not licensed for this machine. Please launch FME Licensing Assistant to install a license. If you require more assistance, please send the following information to your local Safe Software Partner or codes@safe.com. Your registration key is 3-246-191-769. P

Hello everyone!New to FME here. I have a question regarding merging different geometry types into a single SHP. For example, for my scripts, I am converting over many features from a source DWG into a SHP. It seems to work correctly within FME Workbench where all features seem to be passed through into the SHP, but when I uploaded it onto FME Server to run on a nightly basis to update the resulting SHP, it states: Is there an alternate workflow/transformer to implement that would ensure that different geometry types would be merged into the SHP? For example, I would want line, area and arc geometries to be merged into the final LANE WIDENING SHP. 

HiI collected some data with mobile mapping system and I classified the point cloud now I would like to extract the upper profile of the facades (red line in the picture) I tried to extract the maximun z but I doesn’t workcan you help please ?thx Francesco

i have a problem to find the driver for FME data Inspector 2023.1i have install the ODBC drivers 

Hi - I’m wondering if anyone has tried to read a filegeodb straight from s3 with a featurereader.  The S3 connector documentation implies this might be possible - but I could not get it to work.  I had to have the gdb directory local on my machine for it to work.  Has anyone else run into this?  It would be cool if it did work, since I don’t like having these file geodbs local.  I can work around it if not.  

HiI have some rows that need to be appended to a database table and some rows which need to be deleted then replacedI am using a feature writer and  can delete rows by setting the feature operation to Delete and the in Row Selection, the Columns (Im sure it used to be called math columns) is just set to the primary key of the table. That way it appears to delete all the rows. I presume this is correct.I then want to append the revised values to the table. How do I add another feature writer to do this?I presume the alternative (better method?) is to use update. If I wanted to update every field, would I just set Columns in Row Selection just to the primary key and the all other columns would update? Would this still work if some of attributes are null?Many thanks    

Is Azure Communication Services (ACS) supported in FME?

I posted this Thursday, but apparently it hasn’t been ported to the new system, so here goes again: I have a job that harvest a number of data layers via WFS. As of late, the job has been throwing an error, when reading a particularly large dataset.I've tried to retrieve the same dataset as an XML (GML) file using HttpCaller, and the resulting file is 452 Mb.The error says something about "message: comment or processing instruction expected", but it points to the end of the very last line of the data file, and the data file syntax seems ok.So I'm wondering whether I've hit a limitation in the WFS reader ? E.g. a limitation in downloaded file size ?For now, I've split the original FeatureReader fetching 5 layers at once, into 5 FeatureReaders each fetching a single layer. I'll see if that solves anything tomorrow.Using Desktop 2022.2.6 and Server 2022.2.6Cheers.Ps!It would have been nice to have had a checkbox "Rea

My work colleague is trying and failing to connect to Oracle Spatial.I suspect that her installation of FME is slightly broken and she lacks the access rights to the folder where FME connections are stored.When she goes to Tools | FME Options | Database Connections FME pops up an error message "Unable to retrieve database connections"And she is also unable to create a new database connection.If I knew the folder location, we could check if she has the proper access rights assigned by IT.Thanks,Nick