Transformers

Hello, I have a response from one of the APIs I'm using that is formatted as the following example:{ "measurements": { "timestamps": [ 1504377563, 1504378166, 1504378372 ], "waterGround_mm": [ -5032, -5030, -5031 ], "waterNAP_mm": [ -7532, -7530, -7531 ], "validity": [ null, null, 1 ] }}Now, I can flatten this using FME to the following lists:_timestamps{0}: 1504377563_timestamps{1}: 1504378166_timestamps{2}: 1504378372_waterGround_mm{0}: -5032_waterGround_mm{1}: -5030_waterGround_mm{2}: -5031_waterNAP_mm{0}: -7532_waterNAP_mm{1}: -7530_waterNAP_mm{2}: -7531_validity{0}: <null>_validity{1}: <null>_validity{2}: 1Now my idea would be to rename these lists somehow to _list{}.measurement, _list{}.waterGround_mm and so on, and then use the ListExploder to explode _list{} to features. Sadly I can't find a way to properly rename _measurement{} to _list{}.measurement. Also, just trying to explode _measurements{} takes a long time with 30.000 records. Is this the proper way to go ab

Is it possible to set the Cache-Control header using the S3Connector? When I set Cache-Control in the Metadata it changes it to x-amz-meta-cache-control, which supposedly doesn't influence cache control on client requests. My Content-Type metadata changes are working. Is that a bug or expected behaviour? Via Cloudberry   

I current have a workspace reader that reads all of fmw files in a selected folder and use the WriterFeatureTypes to find all names writers in each fmw file being read.But when I run it, it produces errors and warning messages that aren't relevant to the writer (screenshot below).Since I only wish to know the names of the layers that the writers in each fmw file writes to, is there a way to avoid reading other information about the file such as the transformers to remove getting these errors/warnings and improve the runtime?

The data lod-2 is available for public download from the servers of the bavarian Opengeodata platform at: <https://geodaten.bayern.de/opengeodata/OpenDataDetail.html?pn=lod2> here is the direct link to a 2x2 km square that is downloaded as citygml: <https://download1.bayernwolke.de/a/lod2/citygml/704_5322.gml> I have a whole workflow for processing that data, which stopped working without any changes to the workspace. Then i realized that i can not even read the data into a brand new workspace with the same basic error message being shown:'http://repository.gdi-de.org/schemas/adv/citygml/1.0/cityGMLBaseLoD2.xsd' mapped to 'C:\\Users\\mutzh\\AppData\\Local\\Temp\\FME_XSD_CACHE\\fmexsd_1696954419928_14896.xml'Parsing schema document 'C:\\Users\\mutzh\\AppData\\Local\\Temp\\FME_XSD_CACHE\\fmexsd_1696954419928_14896.xml' ...XML Parser error: 'Error at file: 'http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd' line: 126 column: 22 message: unable t

Hello FME Community, I am using a 'StringConcatenator' and a 'Text Writer' to create a text file. I intend to add two separate texts as the header and footer.  Is there a way to add these texts without duplication? 

Hey everyone. I have 3 road datasets I am working with. One point, one line and one polygon. I need to join these three datasets. The point data is set so that each point is about 100m from one another. I can manage to merge all the data but now I need to create a perpendicular line through my points to create segments of my road data.

I have some data in text files that may contain both points and lines. Each line contains a code and either a sub-code or a coordinate set: 05 1          2302     6826513.392   548235.740  257.374            05 31         2302     6826704.339   548284.671  275.511            09 91 05 1          2302     6826513.392   548235.740  257.374            05 2          2302     6826518.762   548233.548  257.950            05 3          2302     6826525.326   548234.694  258.184            05 4          2302     6826532.691   548235.254  258.606            09 99The first column is the first code, '05' is always followed by a coordinate, '09' is always followed by a sub-code: '09 91' defines start of a line, '09 99' defines end of a line. So the short example above contains two points and a polyline with four vertices. Any suggestions on how I can turn this text file into two points and a polyline?I have a python script that can handle the parsing, but I was wondering if there is a better way to

I am trying to add the following WMS in FME Desktop:http://gis.rijeka.hr/geoserver/At/wms?service=WMS&version=1.1.0&request=%20GetCapabilities&srs=EPSG:3765&format=image%2Fpng I have no problems loading this map service in ArcGIS Pro but can't seem to get it to load in FME Workbench or Data Inspector. The WMS contains two layers, I have tried adding them individually as well. Not sure what I am doing wrong. Any assistance here would be great.

I want to read from a csv file and put the contents in an SQL database table. The issue is that there are duplicate lines in the CSV file, so I want to select distinct into the SQL table to remove duplicate rows. Is there a slick way to do this, or do I need to read the csv into a temporary SQL Table holding the duplicates, and re-read the data out of that table using perform sql executor transform into its final destination? .

FINAL UPDATETurns out the problem was that the hatch fill in my block is incompatible with colors for some reason. Having a standalone circle for a block was ok. What I ended up doing was typing • via Text and then saving that as a block and now my CAD looks like a proper point layer.  2nd UpdateI added my template file to my writer parameters and I am now able to generate blocks for my individual points, but I can't seem to get the colors from my attributes to stick to my blocks.UPDATE This is my current workflow, but it still doesn't seem to produce a cad file with data inside all.  **Original Post below**I have a point layer in an Esri GDB file I'm using workbench to convert to DWG AutoCAD data while maintaining color data. I have no issues with lines and polygonal layers but my understanding is that CAD uses blocks while Esri uses points. I tried a direct conversion where I just had a reader with my GDB and a writer with my DWG and the end result was a file with the poi

I'm reading a feature layer from ArcGIS Online containing about 20 layers into FME, each one with proper domains and field aliases. Unfortunately, it is not possible to: first, resolve domains without including only code output attributes, and second, there is no option to "resolve" Attribute names using aliases. I'm then trying to find a time-efficient way to solve this by using AttributeRenamer. I'm currently importing an Excel schema that contains only two columns for Input and Output Attribute and the list of attributes I want to keep from the reader output. In the Import Wizard, I deselect "Sorted" (img 1) to keep the original order of attributes and then I set the "If Input Attribute Is Missing" to "Remove Output Attribute" (img 2). What I'm experiencing is that imported attributes from the schema are still alphabetically sorted despite the "Sorted" box being deselected (img 4) and second, when I run the transform

I have a workspace that inputs property polygons and bounding boxes from an oracle database and it feeds into a WMS feature reader to obtain a raster image. It then overlays property boundary as a redline on top of the image. How do I maintain constant height and width of the image without stretching it? The WMS I am reading from does not have scale hint, nor does it have scale denominator in its implementation.

Why are inputs or parameters the "\\" is getting changed to "backslash" when using FME Form 2023.1.0.0? Seeing it happen on Workspace Runner for log file as well as database name on database joiner. How wide spread is this issue? Previous version was 2021.2.0.1

Hi I have a LAS dataset that contain small pointcloud one for each signpost along a street. Mi goal is to extract the 3d coordinates of the controid of each small pointcloud.I tried with 3dbuffer but no results thx Francesco

Hi I have a GDB file with feature layers from ArcGIS Pro in it that I would like to use workbench to convert to CAD while maintaining the symbology colors. I have extracted the colors of the symbology in hex code format *(E.g. #ffffff) into the attribute tables of the layers. I added my GDB in as a Reader, added in an AttributeFilter, link the field that my symbology is dependent on back in ArcGIS, then added in a DWGStyler to every single possible option in that field in AttributeFilter. I set the color of DWGStyler to be the field containing the hexcode, and then added in my output vis writer and connected everything. But no matter what I try, the CAD file doesn't register any of that at all.As you can see, none of the hex colors seemed to have gotten into my CAD file.

I just started with the FME AR app available in Google Play and deployed it on my Samsung A73 5g mobile phone. This supports ARCore and the Depth API. I also granted permissions to use Camera, Location and Notifications. I made use of the sample fmear file available at the FME site and tried opening that in the app. As the tutorial says, I should be able to see the sample AR content even without me having to be present at the true location of the assets in Canada. At the time of opening, I pointed the phone to the floor after which it displayed a message Searching for planes. This was followed by a display of an array of points on the floor on my house with a message Pick a plane for model elevation with a green circle like icon spinning. After i touched the points displayed on the screen, i saw a push buton like icon and a small box with a label Hydrant.  Pls refer to attached image. Am i missing something? Second, i made use of the FME Workbench and copied the table structue of the

Hi, I'm running a large workbench that I can't seem to troubleshoot as I'm getting the following on the log as per below. It runs fine on different smaller test batches, but upon running on the actual dataset it seems to crash or stop. Is there a way to override if there is a single file that is breaking the process? Log below. Thanks for the assistance (happy to include more files if need be). ListExploder (ElementFactory): Processed 7927 elementsCreating reader for format: Autodesk AutoCAD DWG/DXFTrying to find a DYNAMIC plugin for reader named `ACAD'ACAD_1 Reader: Using rich geometry.AutoCAD Reader: Successfully opened file xyz etc....AutoCAD Reader: Renamed attribute 'Sign Type' to 'Sign_Type' to remove the following invalid characters '<>/\\&$|:!~ ()"@'Error running translation. 

Hi Everyone, I have this KML and I cannot seem to figure out how to convert to shapefile without losing the data in html description field. Ideally, I want these to be parsed to attributes. Any help would be appreciated.

Hi,Is it possible to halt the normal data flow (preferably with a transformer), and ensure that a certain transformer receives and processes one feature at a time before the next feature is provided to it ? Some sort of "semaphore" or "street light" functionality ?I have a custom transformer that works perfectly, but its logic is only valid on a single feature.Plan B is to redo the logic, but if the above is possible, it would be much simpler.Cheers. Lars

I have a HttpCaller that reads different kinds of information depending on the user input and therefore the attribute column names are all the time different. With the JSONFlattener you can import the column names that you want to expose, but ideally I would like to expose them dynamically. I was wondering if something like that is possible.

I have an excel containing 3 columns with name of Belgian commune in 3 format : one with dash (ex Saint-Nicolas), one its regex counterpart (\\bSaint-Nicolas\\b), and one without dash (Saint Nicolas). My goal is to replace, in a feature layer, the attribute with the dash by the one without the dash. So, for this, I am using a conditional replacement in attributeManager, but it fails ( @ReplaceString(@Value(attributeToReplace),@Value(xls_regex),@Value(xls_FinalName),caseSensitive=TRUE). It seems that it doesn't recognize that the attribute fulfill the condition. But, if I put my condition manually, one commune at a time (attributeToReplace Contains \\bSaint-Nicolas\\b, etc.), it does work ! What am I missing here ?

I want to tile cache images and write them to the folder by Mapbox structure with PNG files.I have tried using WebMapTiler to tile cache images and found it different from Mapbox structure.I tried also Writer Mapbox Vector Tile (MVT) Tileset to write them and i found that the folder structure was correct (Level-Row-Colum) but its file is pbf formatHow do I create tiling cache images with the same structure above when I use Writer Mapbox Vector Tile (MVT) Tileset in order to write PNG files instead pbf files?Pls, help me! ... 🙂

I am calculating angle between two points using the geographical neighbor finder. This returns an angle which starts from East and goes counter clockwise. To map to geographic coordinates I use the formula 90 - angle, if angle < 0 then angle +360 This is resulting in a set of angles which when visually inspected appear to be shifted clockwise. In Washington and on the West coast, this shift ranged from 50-70 degrees. on the east coast, it ranged from 20-40. Louisiana sat right in the middle at 40 degrees. These shifts seem reminiscent of the transforms between magnetic north and true north.  Is there a way that I can derive angles from the geographical neighbor finder so that they line up with angles expected through inspection? Thank you.

I have a Geospatial PDF file, I want to convert it to Raster (Geotif) but I can't put any text into the Raster output. I use the TextStroker transformer before connecting it to ImageRasterizer Transformer but it always error, I also tried some way to run the TextStroker transformer but I have just received only one message "Error running translation".Anybody help me! ..... I'm using FME 2023 version