FME Form

Depending on what sections of my FME workflow I run, the VariableRetriever returns with the expected value or returns empty. If I run with the large selection (in red), it does not work. If I run with the small selection (in blue), it does work. Can someone explain the VariableRetriever seemingly inconsistent behavior? See attached screenshots for details.  

Failed to open readerFailed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' readerFailed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFailed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more informationFailed to read schema features from dataset 'FME_SENTINEL_DATASET_FOR_DATABASE_LISTING' using the 'MSSQL_ADO' readerFailed to obtain any schemas from reader 'MSSQL_ADO' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. See logfile for more info

I have adress points representing persons and attributes for each point including a categorization into age intervals. I also have a polygon grid to which I want to sum up all persons in each age interval to each grid cell. My output should be the grid polygons with a sum for each age interval, like this:"grid ID" "age 0_5" "age_6-17" 1 12 56 2 23 109 3 4 13I've tried several solutions eg. with "point on area overlayer" combined with the "list summer" but havn't been able to make it work. I use the 'generate list on an ouput area' option but my resulting "sum_" from list summer returns only "0" for all rows. Do I miss something with the lists buidling? Or any other ideas how this can be done? Thanks 

Can you help me to find the solution?Thanks,

Specifying password on excel feature writer, for instance 'XXX_X', not possible to unprotect the sheet with same password.Excel edited is already protected with the same password. If protect sheet specs are not informed, excel becomes unprotected. Seems weird behavior...

I have a text that randomly has numerals and text for numbering. So the text can be: 20 trees will be planted of which ten will be oaks. I want to replace all numerals that are in text with numbers, so I get: 20 trees will be planted of which 10 will be oaks. I already have a csv (with the numbers as numerals and in text) which I could use to merge. I was thinking about putting every single word in the text in a list and the matching all words with the csv with a loop, but this will be very data heavy. Any suggestions to do this in a clean way?  

I like using the automatic feature definition in the writer - attributes are defined automatically based on input. Sometimes I wish I could influence the type and width (string length, field width) of the attribute within my workflow, to ensure the attribute is written out correctly. I know I can switch to manual feature definition and change it there but that makes things harder. I've tried a number of transformers but I could not find any that would influence how the automatic setting interprets the attribute. Does anyone know of a way to do this?

Hello everyone,my current project is to generate a citygml model from CAD data, point cloud and DTM. The building model has LoD0 and LoD1 ready, I'm working on LoD2 now. I followed some tutorials and the OGC documentation in CityGML, however, the representation of the buildings is not coming out correctly. Here are some steps that I followed and can be seen in the wokspace print: - I separated the solids on surfaces (deaggregator), storing the gml_id of the original solid (parent_id); - identified the surfaces that were shared by two buildings; - removed the geometry of the original solids (geometryRemover); - In solids, I created the list with the IDs of the surfaces that composes the solids "citygml_bounded_By. {} Xlink_href" (matcher); - For solids, I set LoD name = LoD2Solid and Feature Role = cityObjectMember; - I separated

I have several years of data and I would like to remove the overlapping between years and for that I' m trying to perform a clip using a custom transformer and a loop while groupping them using the variable YEAR as group by (see below).  For the first clip (i.e. the year 2000), I'm going to use data_Clippee of 2000 as input for clippee and data_Clipper of 2000 as input for clipper and this will give for the outside Output_Outside_2000.For the second clip (i.e. the year 2000), 'm going to use data_Clippee of 2001 and Output_Outside_2000 as input for clippee and data_Clipper of 2001 as input for clipper and this will give for the outside Output_Outside_2000.AT the end, I will have my last result that will be a union of data_Clipper of 2012 and Output_Outside_2011.   I have exported the customed transform

Hi, I'm having a customer transformer with a group by linked on an attribute:Every feature that enters the Custom transformer (it has 3 input ports) has a value for that attribute.I'm under the assumption that the custom transformer operates as follows:reads all features, process features with value A first, next switches to value B and as last value C.However in my workspace, the custom transformer processes all features in 1 go, regardless of the group settings:(I've added a logger in the beginning to indicate on which group it's working and it's logging all 3 a few seconds apart, while the CT needs to work a few minutes on group 1 and again a few minutes on g

Hello,  Just want to ask what is the specific condition in order for Create as Needed in the table handling be triggered? Thank you.

Hi I am looking for information on how to appropriately use the FME Command in a python loop using subprocess.popen to call the argument. I am struggling to find info on how to achieve this. I am getting syntax warnings in my command when I use subproces.popen. But if I past directly to the cmd prompt I dont have issues. So Im missing something. Any help is appreciated. Please ignore all my comments :P

Hello,I'm converting a ESRI gdb (of 21 layers) to shp with FME Desktop. Seventeen of the layers contain map objects - they're all good. But four layers do not contain map objects (2 x points, 2 x polys). For a very good reason, that I won't go into detail about here, I need to force at least one map object into those four empty shp datasets (a point into the point layers, a polygon into the polygon layers). The point can be in a random location, or one I specify. The polygons can be absolutely tiny. The values can be null. Is this possible within a FME workflow?

Whenever I run data to the ESRI feature service writer (update), it updates the data with the relevant fields correctly but for some reason geometries are now not appearing when viewing the data in ARCGIS. Has this happened to anyone else before? Screenshot below

Hi everyone, I'm testing the B360 Connector. I can log in okay, but when I click on Hub, it searches for a while but then finds nothing. There are definitely projects in our B360 instance. See screenshot below, can anyone help? Cheers.

Morning,I have a group of LiDAR point clouds which were classified in several classes.Unfortunately the client only wants the point clouds classified into 4 groups.How can I regroup several classes into the 4 classes I need? Example (class 1-2-3-4-5 to become class 1, class 6-7-8 to become class 2, 9-10-11 to become 3 etc etc)

Is there still fmeobjects package supporting python 2.7 in FME 2022.2?I need to run an FME workspace in ArcMap, which uses python 2.7 and realized there is no fmeobjects for Python 2 in the FME installation folder. Is there an alternative way to do the job?

FME 2022 Workbench is showing 'Error in Translation' after a successful Translation (See Screenshot). The Data Inspector window doesn't open after the translation. Is there a bug in FME 2022 causing this?What can I do to work around this issue?The log file is available on request.

Hi,  I am new to FME. I am having below error with one our jobs. I am not sure what is causing the issue because it is intermittent.Today it will throw an error the next day it is okay. *I have remove the structure of my table* 7239 Processing attribute 2 for LEAN or LEAN_AND_MEAN usage7240 Processed 2 elements with mode CLASSIC7241 Microsoft SQL Server Non-Spatial Writer: Query failed, possibly due to a malformed statement. Query Text `CREATE TABLE Projects.[Assets] Provider error `(-2147217900) CREATE TABLE permission denied in database 'TT'.'7242 Microsoft SQL Server Non-Spatial Writer: Failed to create the destination table for feature type `Projects.Assets'7243 A fatal error has occurred. Check the logfile above for details7244 ... Last line repeated 2 times ...7245 2022-12-09 05:03:02| 7.6| 0.0|ERROR |7246 A fatal error has occurred. Check the logf

I have two separate Route Feature Types and a bunch of Point and Line events. The Route features share a common alignment (on top of each other), but they have different measure values. For illustration purposes, think of them sort of like different units stored in the geometry measures, but without any sort of equation to be able to easily convert between the units. My plan was to overlay the Route sources to get a more granular set of lines with nodes wherever a node exists in either source, and with multiple measures named by the source it came from. Once I have that combined geometry, the event translation should be as simple as generating the dynamic segments based on the first route, dissolve the lines and read the second route measures from the feature, to get my translated event. In the example below, I rename the measures for each source before sending them in to the LineOnLineOverlayer but the output lines only have 1 of the 2 source measures. I also tried Intersector, but

Hi Community,I'm trying to convert MBTiles Raster format SQLite into ESRI File Geodatabase Raster. I have run the FME workbench from the above formats (default values) and it has created an output correctly, However the MBTiles contains much greater coverage that the resulting ESRI File. Am I missing some sort of parameter to ensure that all coverage is created rather than just a section of it? RegardsNZ

I've created a workbench in FME Database Edition 2022.1.3 that reads the existing metadata of a feature class in an ArcGIS Enterprise Geodatabase (SQL Server), and updates certain components of the metadata based on a table in another database where the feature class name matches the "Name" field in that table. This works for one feature class in the GDB at a time. Is there a way to iterate over all feature classes in the GDB and run the workbench against each one, one at a time? I've tried adding multiple feature classes as a Single merged feature type, and as individual feature types, and it is not updating the metadata as expected. It seems to update the metadata to the same values for all feature classes. thanks

I want to make sure objects resulting from the AreaOnAreaOverlayer are wider than 5 cm. For this I use a Tolerance value of 5 cm. In some situations however, it moves the border of objects more than that value (around 20 cm) where I would expect it would just create an object of 20 cm wide. I'm using FME 2021.1 build 21619. See the attached template for the data, the situation occurs near the red arrow:

I'd like to create a WB that is capable of QR code batch production to a PDF suitable for printing. The input would be a spreadsheet containing the QR codes (text) in a column. I have the QR Code Generator but not sure how to enable it to write multiple codes. Does anyone have experience with this or recommend a B build?

I have a workbench that reads features from a table from Microsoft SQL Server Non-Spatial and writes (Feature Operation: Update) into the same table. I have read and write permissions, reading is working fine but writing gets the following error message:Microsoft SQL Server Non-Spatial Writer: Connection failed. <connectionstring>. Provider error `(-2147467259) Named Pipes Provider: Could not open a connection to SQL Server [53]. ' Failed to open writer Failed to open writer f_22(CreationFactory): Failed to open writer I've tried several things, but none of them is working. I've read this https://knowledge.safe.com/articles/281/failed-to-connect-using-sql-server-2012-native-cli.html and this https://knowledge.safe.com/questions/39002/con