FME Form

This would be simple to do in Excel, but I can't figure it out on FME. The problem is I need to transpose or pivot rows to colums, as in example (I have formatted and calculated the totals to first box):I have tried with AttributePivoter and AttributeCreator/Aggregator, but it doesn't work. Any help would be appreciated, I've tried to google, but with no luck. I have also tried to pivot the unprocessed data and calculate it there.

Hi, Yesterday I came across the situation where I wanted to split a text file into several portions. For 'new lines', the file contained both single Line Feeds (i.e. LF or \\n) as Carriage Return - Line Feed (i.e. CRLF or \\r\\n) combinations. Thus both the Unix End Of Line (EOL) methodology and the Windows EOL methodology were present. I used the StringSearcher to match relevant parts of the text file, and then wanted to use (concurrent) all_matches{}.startIndex to fetch the relevant portions of the file. However, I found out that when I then use the found startIndex in e.g. the SubstringExtractor, it doesn't doesn't return the same (starting) characters as found in the match. Digging a bit deeper, it seems that the StringSearcher all_matches{}.startIndex seems to skip counting CR (\\r). I'm guessing it identifies CRLF (\\r\\n) as an individual character c.q. index? See the screenshot below for a demo workspace il

How can I maintain my Z values in my featuresclass using surface draper while replacing the vertices that lack a Z value using the surface provided?

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.  

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?

Hello!  I'm trying to implement Otsu's method of image thresholding on an incoming raster, using the PythonCaller transformer.  I  have the following code block in the PythonCaller parameters, although my Python isn't great, so there may well be issues with it:import fmeimport fmeobjectsimport numpy as npclass OtsuThreshold(object):    def __init__(self):        pass    def input(self, feature):        #implement Otsu thresholding in native Python with numpy        #get the image from the feature        image = feature.getAttribute('image')        #compute the histogram of the image, then find the peak of the histogram         hist = np.histogram(image, bins=256, range=(0, 256))                maxVal = np.max(hist[0])        maxLoc = np.argmax(hist[0])        #perform Otsu thresholding        T = maxLoc        thresh = np.where(image > T, 255, 0)

How to convert .las file to .fbx using FME Desktop?

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 mosai

This is probably very trivial topic but I cannot get the correct result from this: @ReplaceString(@Value(ATTRIBUTE),,,.) So idea would be to change e.g input value 1,6 to 1.6. Or should I change some FME attribute value to have decimal separator as . instead of , ? EDIT:I get it working by this workaround. Maybe there's is some fancier solution

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