FME Form

Is it possible in the MongoDB reader to have a JSON Query similar to {"_id" : { "gte" : { "$date" : "@DateTimeFormat(@DateTimeAdd(@DateTimeNow(local),-P7D),%Y-%m-%dT%H:%M:00.000)Z" } } }I have tried putting the entirety into a User Parameter, but the date section does not get calculated before being sent to MongoDB, leading to a warning being of the following.MONGODB3 reader: Feature Type Parametr 'mongodb_query_document' has invalid value '{"_id" : { "gte" : { "$date" : "@DateTimeFormat(@DateTimeAdd(@DateTimeNow(local)' for feature type

Hi, I have 2 lines and they have real elevation value (z value). I want to add lines which exaclty middle of 2 lines. Also the new line should has actual z value . ( average z of 2 lines). How can I do?

My FME Workspace opens without any issues, but when I try to run it I get an error stating the log file cannot be opened.. It specifies a directory I do not have access to – what can I do??

My workbench consists of a ArcGIS online Feature Service Reader and Excel file that are the original and revised parts in the ChangeDetector. Then the Updated, Inserted, Deleted and Unchanged go to the same ArcGIS online Feature Service Writer now. This works perfectly fine and updates my ArcGIS Online Feature Service. The automation in FME Server also works if I change the excel in the Workbench.  My goal is that others can upload an Excel via an Workspace Server App and then see the change in ArcGIS online. If I use the upload function in the Workspace App and try to upload the updated Excel file it doesn't update the ArcGIS online feature service.  Is it not working because I'm using a localhost? I am trying to update from my server as well so I thought that should not be a problem. Or do I have to do it a whole different way in the workbench?

I know this question has been asked in many various forms, and I know the key is to correctly define the relationship between the feature and its attachment prior to writing, but we're struggling. I've attached a snapshot of a demo workspace. Any help is appreciated.  Thanks!

New workspace >> add Creator >> add VariableSetter >> define a variable name and a value >> add VariableRetriever >> connect Setter to Retriever.>> Run --> I get warning about Retriever being used without corresponding Setter. This doesn't make sense, they are clearly connected.Question 2: why does the Setter output use the name of the Creator (_creator_instance) and not the name I defined in the settings?      

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 informationFailed to obtain any schemas fr

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 the surfaces in Roof, Walls and Ground by normal (PlanarityFilter); - And for surfaces, I set LoD name = LoD2multiSurface and Feature Role = Boun

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 transformed to an external fmx file but I can't define input user parameters of that fmx with the variable YEAR. What should I do to fix this so that the expression @Variable(YEAR)

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 group 2 etc).Am I under the wrong assumption on how the group by should work for the custom transformer? Or am I overlooking something? Also noticed that I can't assign a attribute anymore to the group by parameter:

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 logfile above for details7247 2022-12-09 05:03:02| 7.6| 0.0|ERROR |