Transformers

I have a table with multiple rows. Each line has a number. The number is appended to the column name. After that, each line should be appended to the other. The picture shows the starting table and the target. I've researched a lot but found nothing. Does anyone know how it works?

Hi, I am trying to reduce texture resolution on a .obj model. This is what i have currently:The output at AppearanceSetter does not have any textures applied to it. I have tried connected AppearanceStyler to AppearanceSetter directly and it also does not work. So I am assuming that perhaps the way that I am setting the appearance is wrong. Images attached below shows before and afterI have attached the .fme workspace. The .obj can be found here: (due to size limit here) https://drive.google.com/file/d/1Cg6wNNzllzl0M7O6ifciswnPfC_0z57s/view?usp=sharing 

Hi there, I am connecting to Vicmap as a Service (VAAS), which is an ESRI ArcGIS Service Feature Service, which will allow me to bring in the state property data and push it straight into our SQL Database. This will replace a weekly download of MapInfo files which are pushed into SQL via automated procedures. The ESRI data is in Vicgrid GDA2020 (EPSG:7899) and I am trying to push it out to SQL as UTM55S GDA2020 (EPSG:7855). It doesn't matter which projection tool or coordinate system tool I use the data still outputs as Lat Long with an SRID of 7844. Is there a way I can do this? I thought perhaps I need to output to a different file format and then reproject that file and push into SQL, but I'd rather avoid an extra step if possible. Regards, Josh

I have a workspace where permit data is joined to GIS data through a series of joins. That data is then written into separate feature classes. The 3 datasets in order are as follows BIN Join, BBL Join, a spatial join using the Point On Area Overlayer transformer. After all of these joins happen I'm dumping any remaining unjoined records into a point feature class called Fallout Points. However all of the records from the spatial join are ending up in the Fallout Points layer. How do I exclude them (or delete them after)?

I have 1,000's of 1km asc files which are simply named 1.. 10,000 which I wish to merge in to 5km asc files, and appropriately name with the correct OS Tile Ref. I have managed to perform a spatial filter and added the OS tile ref. I now wish to filter so all 1km tiles within an identified 5km tile go forward for merging. Is there a way to automatically filter based upon the present OS tiles without creating the individual condition filters manually?  

We are trying to create geopdfs for different defined area having multiple devices , features in them. Adding labels to symbols using LabelPointReplacer Parameters and set the label scale that most of the area fits to it. But few areas are having labels that are overlapping with the symbols as shown below Is there a way to adjust the scale based on different areas.  

In some cases I like to create cumulative statistics using the StatisticsCalculator. I'm glad it's kept as a Advanced option in the StatisticsCalculator. However, it feels a bit odd that the StatisticsCalculator seems to require/expect attributes for 'Summary statistics'. I.e. if I only want to create cumulative statistics, the StatisticsCalculator shows an error (Red Cogwheel) indicating; 'Parameter 'Statistics to Calculate: ' must have a value'; Although it's possible to ignore the error and run the translation, or provide a dummy attribute to calculate regular 'summary statistics', it doesn't feel fully correct. It would be nice to also have the option to only create Cumulative Statistics. I guess that may be possible by (also) embedding the regular 'summary statistics' in a Checked ParameterGroup (and be default checked).

I have two enterprise geodatabases, each with an annotation feature class (annotation version 2.x) that I need to keep synchronized. Edits are made in the feature class in the source geodatabase, and (ideally) updated nightly to the feature class in the target geodatabase, using an automated FME workbench on FME server. The annotation feature class in the target geodatabase should have all of its features truncated and replaced by the annotation features in the source geodatabase feature class. This works great for a number of other feature classes (polygon, points, etc.), and it works fine with older versions of the annotation (Desktop version), but not for this annotation version. I'm testing this out locally, using ArcGIS Pro 3.0 and FME 2022.0.0.2 (Build 22343), and regardless of how I set up my workbench, I'm not able to read and write the annotation features between these two data sources. Currently, I'm getting the following error from FME Workbench: "An error

Hi, I've got a 3d model made of cubes (points extruded in 3 dimensions) and would like to export it as Cesium3dTiles. I did styling with AppearanceSetter and everything is okay except the cubes consist only of 6 squares that are colorised and they are not filled in the inside. Having these solids filled is important to generate cuts through this model. Any suggestion on how to get filled cubes?Regards,Maik

I already had a look at the following link and it helped me in the right direction, however I am still stuck. I use values from the boundingbox transformer for determining whether I need a portrait or a landscape layout. See image below how I have defined it. In case the length of the xdifference is bigger than the ydifference, then I would go for a landscape layout.Then I tried several ways to define the size:1) defining the values shown above in the attribute pdf_page_size in the attributecreator transformer. 2) Create a user parameter from above and use it in the pdf writer under parameters "Page Size (points)"3 Using a TestFilter in combination with two PDFPageFormattters don't work I get the following error  PDFPageFormatter (PDFLayoutFactory): Invalid page object '<at>Value<openparen>Grootte<closeparen><space>=<space>Portrait' parameters 'MINX;-260;MINY;1152;WIDTH;255;HEIGHT;39;FIXED_ASPECT;Yes;CLIPPING_ENABLED;No'.  All point positions must be a pos

I have a file with points and as an attribute I have the measurement with respect to the LRS. How to view the points on the map?

I am trying to use the string search command to extract the file names from a text string, Path attribute. by reverse searching the path string in order to establish the location of the last sub directory i.e. \\ @FindString(@Value(Path),\\,-0,caseSensitive=TRUE) The forward search works but I can't get the reverse (right to left) to work! using a negative startIdx  

When rerunning my entire workspace, the transformers don't run one by one. They run to where all the transformers are being used at once and it takes an astronomically long time. It's faster if I run each transformer individually. Is there a setting to make each transformer run one at a time when I rerun my entire workspace?

I have the lakhs of electric line features in FGDB , I want to find out the line features which are overshoot and correct those . Can you please help me with the FME workspace ?

Hi, I am using a FeatureWriter to create a Geopackage. Although I set the Spatial Column name as "SHAPE" it is changed to lowercase "shape" in the output. Can I prevent this behavior somehow or is there a workaround for this (e.g. renaming the spatial column with sqlite in a PythonCaller)?

Hello , i have read text file but I see only one column in FME Important data starting from fifth column fifth row include the name of each column | col1 |col2|col3|col4| col5|rest of columns include data like this |..0383004|Abcd…………|383903…..|Dhaka Gheny 2|………|I see in one column all data ,as what I explained above .i would like to get the data into excel file .i would like to export the name or number between | | so I need to have five columns and each column include the data that belongs to this column as text file  thanks in advance FME 2021   

Hi together, I am trying to add new geometries to an existing dataset, but always my new geometries got rejected. I was using the FeatureMerger, FeatureJoiner and Dissolver, but it will not work at all to add them as new elements.  Does anyone has a suggestion to me what to do? Thank you very much :)

I am trying to extract a PDF attachment from an ArcGIS Online feature layer and write it to another online program using the HTTPCaller. (I can do so with CSV attachments.) I can see the PDF is being read by FME Desktop (2020.1.2.1 - build 20624); it's in the arcgisonline_attachment{0}.data attribute but I'm not able to successfully write the PDF contents to the other program. Other forum posts indicate I should use the BinaryDecoder first but it won't decode using either option - Binary64 or HEX. I get an "Invalid Base64 character '%'" or "Invalid HEX character '%'" error. I tried using no decoder and writing the contents of the arcgisonline_attachment{0}.data attribute to the output location directly but get the following error: Received HTTP response header: 'HTTP/1.1 400 Bad Request: Invalid .pdf file.'. What do I need to get the contents of the PDF in the proper format so I can upload it?

I am automating a process of creating a Service Request on City works suing an Email (IMAP) topic and notification on FME Server. However, when email is received, my Workspace reads (JSON reader) it as an html instead of plain text and charset- utf=8; I have JSON extractors and HTTPO caller later in the Workspace and therefore due to this problem fails to create SR. I am attaching an image from the log file. Any feedback is much appreciated.

Happening in Parent just before Workspace RunnerExcerpt from log:WorkspaceRunner_2: Running FME Workspace E:\\supply\\Standard_Supply\\SQL_Server\\10km_Buffer_to_SQL_Supply/SQL_Server_County_10K_Buffer_Supply.fmw with command line:2023-07-25 16:30:02|  1.0| 0.0|INFORM|WorkspaceRunner_2: {C:/Program Files/FME2021/fme} E:/servername/Standard_Supply/SQL_Server/10km_Buffer_to_SQL__Supply/SQL_Server_County_10K_Buffer_Supply.fmw --INPUT_POLYGON E:<backslash>supply<backslash>Common_Dependencies<backslash>Esri_Shapefile<backslash>10k_Buffer_Local_Authorities<backslash>COUNTY.shp --QUARTER 2023Q3 --OUTPUT_COORD_SYS IRELAND-ITM --SQL_SERVER_BACKUP {\\<backslash><backslash>servername<backslash>e<dollar><backslash>SQLData<backslash>CountyCouncil<backslash>ITM<backslash>2023_Q3<backslash>COUNTY<backslash>2023Q3_COUNTY_ITM.bak} 16:30:05|  1.0| 0.0|WARN |WorkspaceRunner_2: Failed to run workspace E:/supply/Stand

I am trying to change the authentication from local to windows authentication in Cityworks. What changes do I need in HTTP Caller parameters? Is the chosing NTLM (username, password) under "Authentication" section enough or do I need to add something under "Header" or other parameters?

I'm trying to make a dynamic transformer that uses a feature writer to create a temporary file in some format (FFS, CSV, Parquet, doesn't matter) and I need to supply a schema line for the Feature Writer to accept the incoming features. Most readers won't supply one such line, and even though FME is keeps track of some sort of attribute type tag that AttributeMapper is now able to modify, and that AttributeValidator can check with the TYPE operator, there seems to be no way to either get the attribute type map from the features themselves (as shown when hovering the headers of the data inspector columns) or to get the attribute list from the feature type definition (as shown when inspecting a reader and checking the FEATURE_TYPE section of an FMW file). The only ways to get a schema line seem to be to use a SchemaScanner, a SchemaMapper, an AttributePivoter or a FeatureReader. SchemaScanner seems to be the reccomended option in a case like mine, although that does seem to r

Hello friendly FME Community! I'm trying to implement a GeoFencing service which will calculate the time spent by vehicles in particular areas. In short, I have a set of points (with timestamps) and set of polygons (geofences) against which I want to calculate how long these points were inside these polygons.  I did make a workspace which does this using SpatialFilter (which identifies if points were inside polygons) StatisticsCalculator which calculates min and max timestamps and DateTimeCalculator which calculates the interval between this min and max timestamps. The problem is that vehicle can move out of all polygons and then get back which will distort the calculation as the period that vehicle was outside the polygon will be included because last timestamp will be inside the polygon. Is there any trick or technique in FME which allows to follow up these gaps and exclude them from calculation described above? Thank you in advance for any suggestions!

I have a few AutoCAD drawing files (.dwg) that have a number of 2D and 3D lines and polylines. My goal is to extract all the vertices of each individual line so that I can store it within my GIS database (PostgreSQL). Additionally, I want to extract the layer name and a few other attributes.  Is there a way to extract this data and convert it into a Shape file (.shp) ?  Cheers

Hi. I aim to reproject the coordinate system EPSG:25832 to a metric coordinate system. Which destination system do you recommend?