Authoring

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 all I 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].attrib1 Object1.list1[0].list2[0].Attr1 Object1.list1[0].list2[0].Attr2 Object1.list1[0].list2[1].Attr1 Object1.list1[0].list2[1].Attr2 Object1.list1[1].attrib1 Object1.list1[1].list2[0].Attr1 Object1.list1[1].list2[0].Attr2 Object1.list1[1].list2[1].Attr1 Object1.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 : value1 I 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 2021 I am passing a ArcGIS portal login (including domain) as a user parameter e.g. username@sss.co.uk When I try to get the value in pythonCaller portalAdmin = str(FME_MacroValues['ArcGIS_Portal_UserName']).strip() It is coming as username<at>sss.co.uk I 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. Program Terminating But the system is license

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. It seems to work when I run it and examine the SHP in the FGDB that I have created, but many warnings appear once the scripts are loaded up onto FME Server. Any tips would be appreciated - thank you!

Hi I 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 work can you help please ? thx Francesco

i have a problem to find the driver for FME data Inspector 2023.1 i 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.

Hi I have some rows that need to be appended to a database table and some rows which need to be deleted then replaced I 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.6 Cheers. Ps! It would have been nice to have had a checkbox "Read layers individually" and keep the complete layer list, instead

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

I have two sets of address data that I'm trying to match up using the CRCDetector as described here https://community.safe.com/s/article/creating-a-unique-identifier-crccalculator. Geometry isn't a concern so there are only the 3 fields to match up but I'm getting different CRC values for things that should be the same. Some of the algorithms will give a handful of matches but no more that a couple of dozen (out of about 12,000). I've checked for trailing white spaces. What else is making it think these things are different? Thanks

Calendar to activate in Arcmap, selecting the date highlights all the objects corresponding to the selected date. Calendar tool to activate on demand.

G'day, My workspace generates several rows of data, then goes through a statistics calculator so I can count the total rows of data. This total row is calculated so that I can email the user a summary of what has been done during the run process. What I am finding is that I am unable to use this fmt_acc.total_count figure unless I connect the Summary output through to the HTMLReportGenerator. When I connect this to the generator it ends up creating an additional row in my report with all NULL values, which is not ideal, so I disconnected it. I then use an emailer to send a copy of this HTMLReport, and in my email subject I would like to say "XX Number of Features Found, full list attached", where XX is the fmt_acc.total_count. Unless I connect this summary, the emailer has no access to this data. Can anyone think of a way I can include this fmt_acc.total_count in my emailer, without adding a dummy row in my HTML report?

When I migrating a workspace from FME 2019 to FME 2023, the FMEServerJobSubmitter in FME 2019 version returns _status feature attribute which helps me debug if the job is suceeded or failed. However, when I opened it in FME 2023, there is NO _status attribute returned after the workspace runs. FME 2019: FME 2023: How can I get the _status attribute back in FME 2023? or is there any other way to get an attribute value similar to _status to info the user if the run is succeeded or failed? Thanks for the help!

I can see from the translation log after running with the GUI that there is a plugin imported that allows the readers to operate. How can I incorporate this plugin while running with command line interface? Here is the output from command line: fme "C:\FME\my.fmw" --BlockNameLookup "C:\FME\BlockNameLookup.csv" --DWG_InputFile "C:\FME\my.dwg" --DWG_MetaData_File "C:\FME\my.dwg" --DB_Input_CSV "C:\FME\my.csv" --PostGIS_DB_Connection "DEFAULT_NO_CONNECTION" --FEATURE_TYPES "" --FME_LAUNCH_VIEWER_APP "YES" FME 2023.1.1.1 (20231011 - Build 23636 - WIN64) FME Form Fixed (node locked-crc) Permanent License. Machine host name is: mymachine Operating System: Microsoft Windows Server 2022 64-bit (Build 20348) Copyright (c) 1994 - 2023, Safe Software Inc. Safe Software Inc. Translation FAILED with 1 error(s) and 3 warning(s) (0 feature(s) output) Module 'acad/ACAD' is unavailable for use with this FME editionProgram Terminating Translation FAILED. The command line attempt was run with the 'Comman