FME Form

I've created an excel sheet with a series of dataset names and different equations to run against them e.g. @Value(COV_LEVEL)-@Value(INV_LEVEL) Using fme_feature_type and FeatureMerger I am able to get my datasets and the required equations together. How do I tell FME that to use the content of my Feature Attribute as an equation and action it rather than as seeing it as a text string? thanks

I have some date with id-blocks, meaning there is a column where one and the same object is represented of several features, with different attribute values, but always with the same id for these features.How many features there are per object varies.I was thinking to build some 'decision-tree' in an AttributeManager to find the correct features of such an id-block to process further. Unfortunately, the AttributeManager is not a group-by transformer and I was wondering how can I group my data by id, and process the resulting group, before the next group is created and processed.

Hi Community! I would like to know how, if possible, I can move workspaces from one fme server to another using the rest api. The overall goal is to use the rest api to backup the contents of one fme server onto another. Has anyone done something like this in the past and if so what did you do? Cheers,John

I'm trying to do a spatial join between two AGOL layers, one is a strip map and the other is parcel data with owner info. I want to merge the two and create a table with the owner information and its respective page number.  I have been using the SpatialRelator tool; the parcel data are Requestors, the strip map pages are Suppliers, Spatial Predicates are intersects/touches/within, and merge attributes are checked with Merge Supplier as the Accumulation Mode and Supplier as Conflict Resolution. The SpatialRelator will create a table with all attributes merged but all of the supplier data is shown as "<missing>" (and it's definitely not missing in the AGOL layer). I have tried a few different combinations of this but I just can't seem to populate the entire table. Has anyone ever encountered this problem?/Does anyone have any ideas on a fix?

I have a MHWS and along the MHWS line the elevation from the DEM varies. I want to locate the 2metre elevation point relative to the MHWS Line. Could you please suggest an approach that would work to identify this and convert to a line

I normally run FME Desktop at the office, where I'm storing named connections and associated files on an office network share, in order to facilitate sharing these between the development and production desktop licenses.These files are backed up to my local drive every day.Now, when I'm trying to run FME offline, without access to the office network, FME refuses to access the named connection, and even bars me from reading from a local SQL database although all connection data is entered manually.This also happens after I change the references in under options to point to the local backup copies of the files in question.WTF?Why is FME refusing to work normally in this manner ?Version 2022.2.2

Has anyone else experienced this? I'm using FME 2022.2. If I pick an attribute from the arrow drop down menu, it inserts it in the DateTime Attributes field as @Value(CREATETIMESTAMP). When the transformer runs, it doesn't convert the value. But if I select the attribute from the 3 dots menu, it's fineIn the 3 dots menu chooser, there are sort of two sets of the attributes....

I'm having an error I have not been able to fix when attempting to read/write an annotation feature class from one SDE geodatabase to another. When writing the annotation feature class using INSERT and TRUNCATE in the writer, I get the following error: Invalid geometry type received for an annotation feature. Please split multi-part annotations using the SPLIT_MULTI_PART_ANNOS keyword on the reader to 'yes', or switch to classic geometry mode before attempting to write them to a GeodatabaseBoth annotation feature classes have been updated to an ArcGIS Pro 3.0 version, and they have matching schemas. I've made sure to "clean" the geometry in ArcGIS Pro (no geometry issues were found) but no luck. I'm using FME 2022.0.0.2 (Build 22343 - WIN64). I also followed the suggestion and changed the SPLIT_MULTI_PART_ANNOS keyword to 'yes'. Not sure what "switch to classic geometry mode" means... I'm able to read/write older versions (i.e. Arc

I have a lot of ZGF files to convert to shapefile format.  I tryed to use FME to do it, but it seems that some mistake is happen while the imput file is been reading, that cause the lost of Coordinate System. It seems thta the software used the plot coordinate instead of original file coordinate. The ZGF units was identified as 0.

I have tried all the ways I could think of to do this but cannot find anything on how to change a text field to an integer field like in ArcGIS Pro. Please help! This is what I have tried: @int(USER_Price)@int(@replace(@replace(USER_Price, "$", ""), ",", "")) I have also tried @Trim which produced a 3 digit result.

Hello.i have simple workflow to update Access MDB content.it starts with SQL creator to define the queries and end up with SQL Executor to write down all the attribute manipulations and the end.Works fine in workbench as it updates existing MDB file and therefore there is no Writer placed at the end. Im seeking an advice how to update this to be able to publish it to FME cloud so the Cloud returns the updated MDB file.as this MDB file is uploaded at the beginning, it still exists and being updated somewhere in the temp folder of the FME Cloud so it should be easy just to request it with some transformer at the end and provide it as a result. can you advice me what transformer can do it for me?

I created a workbench in an earlier version of FME workbench and then when I updated it to 2022.1 it eventually stopped working referencing an undefined macro 'OUTFIELDS' to a file that doesn't exist when the translation fails. I tried copy and pasting the workbench into a new workbench but that didn't work. I tried updating to 2022.2 but that also didn't work. I'm hoping someone here has had a similar issue and knows how to fix it. I am trying to avoid recreating the workbench from scratch because it is rather large

I am trying to simply export results with a Writer into a .shp. If I do not use a GeometryValidator most of the features are present in the final attribute table, but not shown in a ArcGIS map. If I use the GeometryValidator and then use both the good and the repaired features as inputs for the Writer, some results are missing from the final attribute table, but all the result in said table are also displayed in an ArcGIS map. The log gives following warning "Dropping heterogeneous aggregate feature for the SHAPEFILE Writer, due to feature type allowed geometries restriction". How do I solve this? Thank you!

Hello everybody, we have a problem with the Directory and File Pathnames Reader.There is an UNC-path: \\\\[server]\\X$\\[directory]\\[directory]\\[directory]. The user has access to the (last) directory and also rights to write. This has been checked. If we use this UNC-path with the Directory and File Pathnames Reader zero features will be read. There is no error, just zero features.It works (with same settings except the path) when the path/directory is connected as network drive. But this is undesired. Has anybody an idea how this with the blank UNC-path works? We are using the FME Desktop (and FME Server) version 2020.2.0.0  Thank you very much in advance! EDIT:it works with a blank path filter and when subfolders are excluded:But we also n

Hello,in the past it was possible to set the options to no and still choose a template. Is there a workaround here? Why is that no longer possible? I would like to use a template and every time the workflow writes that this is done to the same file and not all spreadsheets are removed. 

Can I have one more question? Is there a transformer within FME that could format CSV into plain text with formatting, see the attachment? Thank you very much

Does anyone have experience reading NEXRAD Level 3 data? They are compressed two times (.tar.gc) and there is no file extension when it is extracted.

Hi,after some time in a workflow I often get a problem that the "zoom to selected features" is greyed out. Also the highlighting of the feature is not displayed any more.  I try all, but only closing the program helps. Have anyone the same problem? The separat Data Inspector program don't have the problem.  I have the newest Version of FME 2021.1, old version have also the same problem.

Hi We are currently on FME Server 2021.2.2. There's a need to capture the login user ID for a server app and then insert into our database for logging purpose:Believe that's the FME_LOGGEDIN_USER parameter. Please advise whether it is possible to do so. Thanks.

I've got FME Desktop running under Linux. This works fine (after quite some steps), but now the Emailer does not work. It used to work with FME 2021 (on same Linux machine). But it does not work with FME 2022 anymore. The Emailer v 3.3.3 package is correctly installed, since it is listed in the package list using the command  sudo /opt/fme-desktop-2022/fme PACKAGE LIST.When running the workspace it mentions:2023-01-24 14:10:27|   0.5|  0.3|ERROR |Python Exception <ModuleNotFoundError>: No module named 'fmepy_emailer'2023-01-24 14:10:27|   0.5|  0.0|FATAL |PythonFactory failed to load python symbol `fmepy_emailer.Emailer'2023-01-24 14:10:27|   0.5|  0.0|FATAL |Factory proxy not initialized2023-01-24 14:10:27|   0.5|  0.0|FATAL |Emailer_transip_CALLER (PythonFactory): PythonFactory failed to process featureAny idea why this is happening? I tried to uninstall and reinstall the package, but without result. 

Hi,I have a workspace that needs to read data from a variable folder and write to that same folder. However the exact folder name is not given but rather depends on two parameters (BEKnr and Model) that are entered at the start of runing the workspace but also includes a part that is not exactly known and can vary (versionnumber, v*).To read the data I can easily use * for this variable but for the writer this is not working. For instance: I need data to be read from tis folder; G:\\Team_Hydrologie\\FEWS\\ATTRIBUTENTABEL\\11_Maas\\Dommel\\v2_FEWS. Using an attribute creator and feature reader referring to the location as: $(FME_MF_DIR)\\$(BEKnr)\\$(Model)\\v*_FEWS I get the reader to work.But to write to this same folder the use of the * doesn't work. (To be clear, there will always only be one folder that fits the criteria above, only one folder will have the _FEWS suffix. )How can I do this? Without the user having to indicate the exact folde

I was wondering what are the limit of the 'Compare and merge' feature included in FME 2022. I have a request to note all the changes made in the workspace and I want to find a way to list those changes. The problem is that I get an error: Unable to compare workspaces. (I have 800 transformer in it with multiple Custom Transformers). I know this is a bit unrealistic...Thank you

After upgrading our SDE on SQL Server to SDE 11.0 using ArcGIS Pro 3.0.3. FME workbench is not able to read feature types correctly from the database. When importing a feature type using a reader, FME cannot read any fields. Same thing is happening when using FeatureReader. Has this been tested that FME 2022 works with SDE 11.0?

Hi guys,  I tried using IDENTITY_INSERT on several tables of single SQL Server Non-Spatial writer. There is a error I'm getting that says I cann't do that. I now for the rule that SET IDENTITY INSERT can only be used on a single table per connectio, but I wonder if there is some way to make my 4 tables use this feature with a single writer? These tables aren't beeing populated at same time, so can I do something with SQLExecutor for example or no?

Hello. I am in need of dynamically moving data from one spatialite database to another.Both of these databases (.gigdb files) in this case use same schema. However in the example files I have attached one file (DTMK-2022_07_1.gigdb) has one more feature in feature type (table) a0100000321 than the other file. I would like to copy this extra feature to the second file, same table name. I have encountered several problems.Our company uses FME 2021.1.2 -> there the now obsolete spatialite writer does not allow me to create uppercase / camelcase attribute names, so even when manually creating attributes in the writer, it does not allow me to and then I lose them in the translation. Dynamic writing also converts them to lowercase and I get plenty of error messages saying that my schema does not match.Now my second problem: I am trying FME 2022, just released. When trying the new Spatialite writer, now I get correct attribute names, so that appears to