General

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 Excel file from SharePoint seems to work the same way,

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 1 The Puzzle of the Extra Partner (CLOSED) Challenge 2 The Puzzle of the Holidaying Lizards (CLOSED) Challenge 3 The Puzzle of the Hidden Twitter Message (CLOSED) Challenge 4 The Puzzle of the FME Art Gallery (Part 1) (CLOSED) Challenge 5 The Puzzle of the Viral FME (CLOSED) Challenge 6 The Puzzle of Santa's Sleigh (CLOSED) Challenge 7 The Puzzle of the Obscure Transformer (CLOSED) Challenge 8 The Puzzle of Santa's Faulty Warehouse (CLOSED) Challenge 9 The Puzzle of the FME Art Gallery (Part 2) (CLOSED) Challenge 10 Th

I'm try to translate fgdb to shp file But I got following error BADNEWS: 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 std::pair<class STFAttributeName,class stk::ex::UString<0> >,class std::allocator<struct std::pair<class STFAttributeName,class stk::ex::UString<0> > >

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. The _out_dataset at

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?

Hi I am receiving this warning below - It worked fine in 2022.2.5. Since we have migrated - to 2023.1.x - this started to appear It happens using GeoDatabase writer / and or FeatureWriter - using GeoDatabase : DB Version 10.9.1 on SQL Server GEODATABASE_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 After playing around some more - looks like the issue is the FeatureWriter using an attribute as the output filename. When I change it to a "hard-coded" value, the records are available in the output port.

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

Hello, I have an editable view in PostGIS (PostgreSQL) and I'm trying to write in it with FME. For that, I've: Added my view from a PostGIS reader (to have its structure - and confirm it exists) Duplicated this view in a new PostGIS writer (to keep its structure) Set the table handling as `Use existing` Connected a worflow to end in my view But when I run the workspace, I'm facing this error: POSTGIS Writer: Table 'xxx.yyy' does not exist. Please check the Table Name specified, or modify the Table Handling value under Format Parameters So my question is: is it possible to write in an editable view? For the record, I can write in my view with another client (QGIS) with the same credentials. Thanks for any input. Rémi

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!

Question of the WeekThis question was asked in Live Chat this week, but to be fair it has come up several times from various users... Q) I've forgotten the password to the admin account on our FME Server. Is there a way to recover it? A) In short, no! But because the FME Server Support team has seen an increasing number of cases recently where a customer is unable to log in because of a forgotten password, I think it's worth outlining what the options are at this point, and how to avoid getting here in the first place!What's the Default Admin Password?Up until recent FMEs, the default administrator account used to be admin/admin. You can see why we felt that wasn't a good choice, because it's so easy to guess. So now - although the default is still admin/admin - you are forced to change it when logging in for the first time. The username remains admin, but the password becomes one of your own devising.I've Forgotten the Admin Password - Now What?So at a later date you forget the admin

Hi everybody, Do you know if Home licence of FME still available?