Transformers

I am trying to create a workspace that writes AGOL features to AutoCAD Map format with object data attributes. Not having much success. :-(

Hi,since my last update of the workbench (2022.2.0.0 (20221103 - Build 22765 - WIN64)) the parameter editor of the attribute manager wont allow me anymore to edit directly in the pane next to my main window. I have to open a unneccessary pop-up window to continue editing. Other transformers (like the feature joiner) do not show this behavior (see screenshot). Any ideas how to enable direct editing again?All the best,Merlin  

Hi, I would like to force FME into treating my numbers as double before sending it to the feature writer transfomer. This allows me to make use of the automatic user attribute functionality, otherwise I would to manually define each attribute, which is cumbersome. For example:I have calculated the difference between reported and measured plot sizes. The result is stored in a colum as number, but it seems that FME interprets the number as string ... no matter if I use the @Evaluate() function or any other math function ... also string replacer cant change that. The result is always the same: i have to change the format in the feature writer, which I would like to avoid. main_plot_diff is left aligned, showing that FME interprets the data as string.  string replacer is powerless...  ... and the feature writer also interprets the data as string

Hi there,I have an excel file with approximately 4500 rows of data, which I am converting to HTML. I can write perfectly, but I also want to write a PDF from this information. Reading through previous questions I can see you can't write straight from the HTML Report Generator, so I have added a Table Adder transformer before this, but it creates a completely blank PDF. I have used a combination of PDFStyler and PDFPageFormatter but still keep getting blank PDFs. Any suggestions?Thanks, Katie

I have polylines that have Z coordinates on each vertex. The polylines represent water pipes and are below the ground surface ~1 meter. I have a LAS of the ground surface which can be converted to a raster to create a surface. The situation can occur where the polylines get above the ground surface in between the vertices due to variation in terrain and lack of vertices with X, Y, Z values in the polylines. How can I identify those locations and add an extra vertex so the polylines will stay below the ground surface?

i have dragged and dropped a LL27 shapefile on to Fme workbench 2020.2. Then I add a writer. Set the output dimension as 2D and coord system as TX-S. Running this is giving the error as above. The same workflow runs without errors in FME workbench 2017.1 In fact I do not have to set any dimension in 2017.1 The simple coordinate conversion from LL27 to TX-S runs normally.Wondering what I need to tweak out here in 2020.2 to get the same result 

Hello:)i'm trying to overly 2 rasters :1- orginal raster (orthophoto)2- bounding box of the original raster as a boundig box rectangle +100 offseti'm using rasterMosaicker , but the result only shows the rectangle and not the orthophotoi tried sorting - didn't help  see the attached workflow and parameters:the result that i'm getting in the inspector which is the correct one - black rectangle + orthophoto: result that i;m getting after the mosaicker (only the black rectangle):why i'm getting different result from the inspector ? the parameters for the mosaicker are:thanks

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

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

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!

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.  

Can you help me to find the solution?Thanks,

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?

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:

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

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)

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 |

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 th

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

We have a unique number 0 and 00 to identify paying customer.I set (0 and 00) in the AttributeFilter but both values end up on either 0 or 00 depending on wich one in the list comes first.What am i missing here? or should i set up a tester instead for each number or text value? /Tim