General

Hi, I have a MySQL database which I'm using the non-spatial MariaDB reader to get access to. Most fields are coming into FME Desktop ok, with the exception of a unique identifier field. The source data has a field called rg_key_id which is defined as char(21) in MySQL. A typical value in this field would be 'RG 022000001' But, when read FME is setting the datatype as fme_binary and I'm seeing '52472020303232303030303031' as the representation of 'RG 022000001' Can someone please point me at a resource, or help me understand, how I can either honour the source datatype or change the FME datatype so that it's no longer fme_binary. Here is the Feature Information showing the fme_binary encoding. Many thanks Brendon

When I publish my workspace to our FME Server, and run it it works. After a while, published before Christmas 2023 -> ran now again, FME Server return with the following error: ArcGIS Portal Feature Service Reader: Authorization error. See http://fme.ly/AGOL401Error for more info. FMEException: 928221: ArcGIS Portal Feature Service Reader: Encountered an unexpected error. The error code from the server was '498' and the message was: 'Invalid token.'. Details: '' Trying to fix the issue I attempted to re-authenticate the web connection. The issue is, when I click on the 'Authenticate' button, then I get a browser window where I can authenticate myself against our Enterprise Portal and the portal returns a token. In other applications such as Jupyter the token needs to be copied and handed over to the requesting application. This would be here FME Server. However, FME Server does not offer any place where to place the token. How can I authenticate my w

Hi all,I'm wirting a program and I thing is alos usefull for other: FME-Starter simplifies the opening of FMW files when installing several FME version. The program must first be associated with the .fmw file extension (Windows context menu, Open with). When opening FMW-files, it will check if there is an FME version installed that matches the last one saved.If yes, this workbench will be opened with this version. Otherwise a selection of all installed FME versions is displayed. If a hotkey is pressed when starting the program, the selection is also displayed. In the settings you can choise the hotkey between Shift or Control. On dircet opening the executable yout can choise the FME-version to run. In the settings you can choise a hotkey (Shift or Control) to run the actual version directly. With FMX-files (custom-transformer) the FME-Starter has the same behaviour with the difference that the file is opened for editing instead of installing it. The settings are accessible via the

Hello,I am abeginner with FME.I created a workplace test with a reader component PostgreSQL, a transformer component et a CSV Writer component.All it's works.I would like catch errors if there is un problem with de connexion to database or to write the csv file in a log file or send mail but there isn't a connection error like Talend to catch errors.How can I catch errors with writer or reader component?Thanks for your help

Hi FME lovers,I'm getting blocked when trying to access this website, via POST:https://lastkajen.trafikverket.se/api/Identity/Login Using HttpCaller from FME 2022.2, I have:But, no luck, a http_status_code = '400' is sent. On the other hand, I've had no issues using Postman:  I guess I'm not filling well the HttpCaller settings, right? Thanks!

I am doing an inventarisation of all our scripts. Each script has the workspace parameters completed. This information is ideal for the inventary. I have found a way to do this adding each .fmw script individually, but this is very time consuming so I am looking for a way to do so in bulk.  I tried to use Directory reader to initially find all the .fmw scripts in a particular path, and this works, however I do not find a way now from this list how to extract info from inside the various files. I tried the FeatureReader transformer as I used this before to extract DWG files in bulk, but that does not seem to work for .fmw files.

Hi,Is it possible to change the skins of FME 2016?I installed FME 2016 and I would like to return to the classic skins (FME 2015 or 2014).It is not ugly, but it is not my style.It would be cool to have several skins for FME :- FME in DOS- FME dark- FME pink- FME comicsI like to program XML or JavaScript into a black background, I think my eyes would like it for FME too.Thanks.

We recently downloaded the 2021.1 version of FME. All previous scripts run on 2020.1 without problems. Now however, I get a warning message "Excel Writer: Failed to refresh Pivot Tables and recalculate formulas. Note this is only possible on Windows with Excel installed" when exporting to an excel with the use of a template. I write my data in 1 tab, and that tab is used to make a pivot table in another tab. Because of this warning, the excels in my dataflow I have stay open and after 20-ish files the memory in my task manager is full, so the translation fails. We did not change the version of Excel, that should not be the problem. Anyone an idea what could be the problem?  

@We have 2020.1 Desktop/Server and are writing to an ESRI ArcGIS Portal Feature Service. It successfully reads and writes using the configured web connection based on the ArcGIS Portal (Template). Unlike ArcGIS Online, the writer doesn't seem to update@ the token and I have to go into the web connection settings and re-authenticate manually. We are connecting to a 10.7.1 Portal and it happens in both FME Desktop and Server. Our 10.7.1 Portal is currently only operating from 7am to 7pm and restarts nightly (Dev environment). I've noticed in the workbenches connecting to AGOL, that the token in updated automatically. But that doesn't appear to be happening in the Portal writer. Is it something I'm doing? Or is it the nightly restarts of Portal? Thanks 

I am running FME 2023.2 and have a dynamic workspace that is creating a File Geodatabase (FGDB) with a FeatureWriter, and I am running against ArcGIS Pro 3.2. Recently, I have wanted to access some annotation class properties in that GDB, but I find that I cannot access them. ArcGIS Pro says that the FGDB is version 10.0 and that I need to upgrade the FGDB to the latest version to activate those properties. I looked at the log for the last run that built the FGDB, and I see "Created and connected to the ArcGIS 10.0 File Geodatabase at '[Location]\\template_General_Prod.gdb'" I checked the FeatureReader geodatabase version parameter, and it is set to "Current." So, ArcGIS Pro is telling me that there is a later FGDB version than 10.0, while FME, though set to "Current," is creating a 10.0 version FGDB.  I am confused. Can FME only create a maximum 10.0 FGDB version, or is there actually no later FGDB version ... or is something else going on? 

I am trying to create a workspace to read the contents of an Excel file from SharePoint directly into memory to then operate on, rather than download the file to a temporary location first. I understand that I should be able to read files to memory by using the SharePointOnlineConnector with 'Action: Download' and 'Download as: Attribute' settings, and have had a degree of success with a simple text file that I'm using for test purposes.​The '_contents' attribute returns the full content of my text file, as below:However, I'm not sure how to deal with this attribute to make it usable after this point… ​I've tried passing the '_contents' attribute to a CSV FeatureReader as the 'Dataset', but this didn't work, as the reader tries to open a file at the location specified within that attribute. I guess I've already read the CSV file with the SharePointOnlineConnector, so now need to work with the attribute directly...​Reading an E

Welcome everyone, to the Twelve Days of FME Contest for 2020. A series of challenges will appear over the coming month. The links are below. You can enter any challenge, all challenges, or none at all (though then you won't win any prizes). And there are a lot of prizes! We're not sure exactly what they will be, but I can guarantee prizes for each challenge. So take a look at the current challenge and don't forget to follow this page so you receive new updates! Challenge 1The Puzzle of the Extra Partner (CLOSED)Challenge 2The Puzzle of the Holidaying Lizards (CLOSED)Challenge 3The Puzzle of the Hidden Twitter Message (CLOSED)Challenge 4The Puzzle of the FME Art Gallery (Part 1) (CLOSED)Challenge 5The Puzzle of the Viral FME (CLOSED)Challenge 6The Puzzle of Santa's Sleigh (CLOSED)Challenge 7The Puzzle of the Obscure Transformer (CLOSED)Challenge 8The Puzzle of Santa's Faulty Warehouse (CLOSED)Challenge 9The Puzzle of the FME Art Gallery (Part 2) (CLOSED)Challenge 10T

I'm try to translate fgdb to shp file But I got following errorBADNEWS: File C:\\Program Files\\FME\\metafile\\MULTI_WRITER.fmf could not be opened(C:\\code\\fme\\foundation\\framework\\control\\generiz.cpp:1658) class StatusInfo *__cdecl STFGenericizer::processMetafile(const class stk::ex::UString<0> &,const class stk::ex::UStringArray<0> *,const class stk::ex::UString<0> &,const class stk::ex::UString<0> &,const class stk::ex::UString<0> &,const class stk::ex::UString<0> &,class STFAttributeName &,class STFMetaMapper &,class STFObjectNameConstraints &,bool &,bool &,bool &,class stk::ex::UStringArray<0> &,class stk::ex::UString<0> &,class std::vector<class STFFeatureType,class std::allocator<class STFFeatureType> > &,class stk::ex::UStringArray<0> &,class stk::ex::UStringArray<0> &,class stk::ex::UString<0> &,class std::vector<struct

Hello, we have started using FME Desktop with a VPN connection. It takes about 20 -30 Minutes until the programm starts. It remains with the message "Initializing Start Window" the whole time. We have set a new environment Variable like one Post said but there are no changes after that.Has anyone any Idea how can we solve this problem? Thanks in advance!

Anybody tell me what I'm getting wrong here? Document Link path is valid. No errors in the FME log but attachment not found in the http response? 

Hi, I hope someone can help me with the following.I have a workspace app, lets call it "app1", which uses the file/URL parameter and the "User can Upload" setting in the Edit workspace apps enviroment to upload data. When I test the workspace, it correctly shows that the file is processed and ready for use. I have also have another workspace, let's call it "app2", which uses the exact same setting as app1 for the file/URL parameter and the workspace app. However, when testing the workspace app, it does not register the file upload Pressing upload file does not process or show a filename or percentages of completion. Browse resources and "drag and drop" produce the same result: no file upload. The tool behind the workspace app works, but will not do the designed tasks which need this parameter. I find it strange that the same setting work in one workspace app but not the other. Any experiences with such issues? Thanks in advance!

When I query the schedules using the REST API (...fmerest/v3/schedules?...) The json returned gives the specified user I changed it to but the userName value is the previous owner. Does this indicate that the job is running under the account of the previous owner? How can I make the userName show the new owner account?

I just upgraded my FME from 2021.2.4 to 2023.2 today. My emailer transformers are working fine on my workbench that were previously there. I went to add a new emailer to my upgraded workbench, but I cannot set the parameters, it's stuck at Generic SMTP and no connection settings are anywhere to be found, so no host/port/encryption settings. I removed all the emailers from my workbench, then removed the emailer transformer from my PC, then redownloaded it from FME hub, and still no dice. Any advice? Build is 23764

I am having a problem with the counter transformer in multiple workbenches on multiple machines: It ofthen does not start at the set value (ussually 0 or 1). For instance; The counter in the image is set to start at 0. However: When I run the workbench it starts at 577. I have no clue at al why it does that.  When I use featurecaching and I run the whole workbench one by one transformer it will start at 0. But ONLY when I manually start every single transformer before the counter. I have this on this machine and another computer in completely different workbenches. I use the counter to merge features. the workbench stops because it can not merge features based on wrong counts.  

I ran into this same error when building this dynamic workspace a year ago and writing to existing, unpopulated geodatabase (GDB) in File GDB format. The solution was to add my template File GDBs to the workspace as resources in the Schema Sources control in the FeatureWriter parameters. I have now modified the workspace to write optionally to Mobile GDB format through an additional FeatureWriter set for Mobile GDB format. I have the FeatureWriter set up identically to the File GDB version (which works fine), but I am getting that "Feature Type Definition 'ftype_name' was requested, but not defined" error. The following screenshot shows the parameter setup for the Mobile GDB FeatureWriter (FeatureWriter_8), and the Feature Information for the first feature to be written as it comes out of AttributeCreator_38. I am baffled. The Schema Sources items are correct; the fme_feature_type, fme_feature_type_name, and geodb_feature_dataset format attribute values are correct. T

Hi,  I'm struggling with a seemingly very simple task. I want to to check if a user parameter (Text) contains a value using a Tester. I assumed I could just use a Tester and test the $Parameter with the condition "Attribute has a value" but if I run the workspace with a test string it does not pass the test. The test works as expected if I use a "contains regex" condition instead but I don't understand why "contains a value" isn't working, when the input clearly contains one.

Hi, I am trying to use FME to create an Inspection in the Cityworks. How can I configure Answers for the Questions in FME? I believe I need to do that in the Additional Parameters Section but I cant figure out how to set it up. Can someone help please?

HiI am receiving this warning below - It worked fine in 2022.2.5. Since we have migrated - to 2023.1.x - this started to appearIt happens using GeoDatabase writer / and or FeatureWriter - using GeoDatabase : DB Version 10.9.1 on SQL ServerGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.action' to '_Update_0__action' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.attributeName' to '_Update_0__attributeName' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.originalValue' to '_Update_0__originalValue' based on format constraints for invalid characters, length, and caseGEODATABASE_SDE Writer: Renamed user attribute '_Update{0}.revisedValue' to '_Update_0__revisedValue' based on format constraints for invalid characters, length, and case    

I have a fairly simple problem but can't seem to figure it out. I need to copy one excel file to another folder and rename the copied file. I've tried using the PATH reader and the File Copy Writer but nothing seems to get copied. Any ideas?

I'm trying to read annotation feature class from ArcGIS file geodatabase. For further processing, I need to check 'Split Complex Annotation' and 'Split Multi-part Annotation' in the reader.The annotation in ArcMap looks like the above image. It's in vertical alignment: baseline, horizontal alignment: center.While after importing from FME reader, it becomes to:Any safer partner could explain how FME calculate the anchor point of spitted text? seems the anchor point set to right bottom corner. And will the split consider the ArcGIS alignment setting?