General

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 somethin

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

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

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

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"

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

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?

Hi, I am trying to make a simple WS (with only one transformer) to change the schema! Translation runs successfully but I dont see the final gdb . The error on the Inspector is showing that "failed to specify the feature index as constraints on the reader". What should I add and where? Both my reader and writer are File Geodb Open API.

I am creating a series of small jpeg files using a feature writer with each jpeg getting it's name from a unique value (myRLU_@Value(RLUOID)). I recently upgraded to 2022.1.1 from 2021.2 - things were working until I upgraded. I have 20 records coming into the FeatureWriter and 20 showing in the Summary port but no records passing through the output port.The FeatureWriter creates the jpgs but does not pass through the records to the testfilter transformer? Has anyone else had issues with this in 2022.1.1? Any ideas how to get this running again? Could this be helpful in diagnosing the issue: FeatureWriter_5: Bulk features are not supported because the expression contains a function call Afte

I want to use the same condition for each attribute, with the only variation being the attribute/field name of the attribute to which the condition applies.

I need to make a mapbook export (png/pdf) for different thematic maps with a large legend. For the boudingbox of the map I would like to insert a dynamic legend (filtered) based on the content in the bounding box.  

Hi, With FME I want to read a sde geodatabase. (feature class). For this I use the reader: “Esri Geodatabase (ArcSDE geodb)”. Until recently this worked. With ArcGis Pro an Attribute rule has been created for 1 field and since then the reader no longer works if the workspace is on FME server. If the workspace is run in FME desktop (not FME server) the reader will still work properly. The message I get when the workspace is running on FME server is: An error occurred while attempting to open the table, feature class or relationship class 'My_TABLE'. The error number from ArcObjects is: '-2147211773'. The error message from ArcObjects is: {The item does not have a definition.}  What could be the cause of this. FME server and FME Desktop are the same version. Greatings, Hans

I have a land cover raster with values that can be seen in ArcGIS Pro when looking at the raster's attribute table. When bringing this raster into FME using the "Esri Geodatabase (File Geodb Raster Dataset)" Reader, the raster is brought in with no attribute values (see screenshot). Looking for help with bringing the raster into FME so that the attribute records will be populated with the raster's values shown in the ArcGIS attribute table? A smaller example raster that was clipped from the larger raster can be found at http://robot.konturlabs.com/temp/rasters_temp.gdb.zip Thanks!