Transformers

Hi all,I'm trying to use the AmazonAthenaConnector but I'm not sure what the correct settings are. Firstly, what do I need to put in the Bucket / Path fields? Secondly - when I try adding values in these field and run the translation I'm getting the following error:  Invalid bucket name "all-product-athena-result/": Bucket name must match the regex "^[a-zA-Z0-9.\\-_]{1,255}$"Error encountered while calling method `input'AmazonAthenaConnector_2_CALLER (PythonFactory): PythonFactory failed to process feature Thanks,Ed  

Hi  i have values as example as below and would like to round upto 3 decimal evenly. 1968.741344 5977.675803 1968.93 5983.1  Am using above transformer to round up but it returns 1968.7415977.6761968.935983.1 AND i want  1968.741344 >>>>>>>> 1968.741 5977.675803 >>>>>5977.676 1968.93 >>>>>>> 1968.930 5983.1 >>>>>>. 5983.100

Hi all,i would like to concatenate values from 2 lists (maybe 3 later) from 2 fields. The values are in multiline. I can get values with attributesplitter and a listconcatenator but after that, i don't find the solution! After the 2 listconcatenator, I tried the featureMerger but It don't gives me the two new values -concatened and _concateneddate.If someone could help me, it would be very nice!Thank you!

FME workbech READER (raw excel file) TRANSFORMER WRITER ( Desired or Expected RESULTS) SETTING1st row is merged 2nd row id columns names I want the data to be inserted / updated from ROW 3 keeping the first 2 rows same.  Note : Everytime i run FME the number of ROW records will change so results should dynamicaly upated and NO APPEND . WRITER SETTINGS

Hi,Could I have some explanation why HTTPCaller does not bring any data from a simple GET from this website: https://www.puntopack.es/buscar-el-punto-pack-mas-cercano/?codePays=ES&codePostal=32005 Not sure if there are any parameters that I'd need to add.The REJECTED ERROR value: "HTTP/2 503"_fme_rejection_code: "NO_RESULT" Uploaded a screenshot of the HttpCaller.Many thanks in advance!J. 

Hi I noticed that the epsg code 7791 is missing in FME 2021.1.2.0. How can read the EPSG database to add it? https://epsg.org/home.html thx Francesco

I'm running a transformer created specifically for some middleware (CTGENIE) that was created for Frontier Communications. It is crashing during translation; the translation log reports that the job succeeded, but there was nothing that was written to the database. It also crashes FME when the transformer is present in the workspace and I try to save it. I have attached the log, but it doesn't seem to offer any clarity on how to get this to work. Best, Alex

Hi all, I have a situation where I want to dissolve adjacent tile polygons based on a count value. For the example below I would expect the total sum to be no more than 100. Less is fine. The less polygons I end up with the better, but optimization (doing several passes) to figure out the best possible result is not that important. It's sufficient to start from one corner and simply add until all polygons have been dissolved. Also there could be a situation where the polygon has a larger count (110 for example) than expected. In such a case it would be left single - as it is.So any ideas on the simplest approach in doing this? I expect some kind of loop function in needed. Not very familiar yet with those...Thanks for any advice!Attached is an example shape file to play with...

Hi all.I'm tasked with updating a table that contains 10+ geometry fields. I'm opening it as a non-geometric table, extracting one (of two) geometries, and reprojecting this to a variable projection, based on other field data and/or coordinate values.This all works well, but when I try to update the targeted geometry field in the database table, all hell breaks loose in FME.I've tried to use the formats "Microsoft SQL Server Binary", "OGC Well Known Binary", and even "OGC Well Known Text".I usually get an error message about mixing image and geometry field types, but now it just times out all the update commands.I've tried using a writer with "update", and the DatabaseUpdater, but both errs, so I've ended up with a SqlExecutor (with an UPDATE command), which unfortunately times out.

Hi.When reading multiple geometries from a single table, they're joined together in a single aggregate geometry collection.The individual geometries can be extracted by using a Deaggregator, with each separate geometry having its original field name as its "name". Writing multiple geometries back to the table requires the geometries to be aggregated, and a MultipleGeometrySetter set to Yes.If updating such multiple geometries, I assume that FME extracts each geometry from the aggregate, and updates the (geometry) field values designated by the individual "geometry name" as field name ?So, if I have a table with 3 geometry fields (A, B, and C), and want to use geometry A to update field C with a new geometry, should I create an aggregate with all 3 (original A and B + new C), or can I just include the new C value in the aggregate when updating ?Cheers.

Hi,I just added an end-sql statement to some workspaces, each with a comment on the preceding line. The comment is a T-SQL line comment on a separate line, i.e. with prepended "--" (two dashes).This fails, as it seems FME gobbles up the first dash before execution, rendering the complete statement invalid.If this WAD og a bug ?Is it possible to add comments as "/* ... */" instead, or would "--- ..." (i.e. 3+ dashes) work ? It also doesn't look like line-feeds in the statement are respected, so maybe line comments are a complete no-go ?CheersLars

Hi FME wizards, I am trying to do a datum transformation on multiple files in a nested folder structure and save the outputs using an identical name and folder structure, but in a new directory location. I've created a replica of the folder structure using DOS commands and trying to replace the existing root folder with a new one.  I'm reading the source files in from a CSV, then creating a new 'outpath' attribute in AttributeManager using the StringReplacer to replace the source root level directory, e.g. the part in bold C:\\Project\\CurrentDatum\\Model\\file.ext with C:\\Project\\NewDatum\\Model\\file.ext. The source and destination directory are Published User Parameters and I use the following in the text editor: @ReplaceString(@Value(_dirpath),$(Source_dir),$(Destination_dir)). When I view this as a new attribute, the directory appears correct. I've used similar logic in Python and it works great but not sure how to

I am trying to do what is described in the question with a dynamic Geojson writer set as shown in "screenshot_1,jpg". However I get an error (screenshot_2.jpg).  

The XML Templater fails when I give a conditional value in the root template. XMLTemplater_3: Invalid Test Expression: TEST<at>Value<openparen>template_root<closeparen>=1 I have attached a simple workspace, any ideas why the conditional check fails?Thanks

Hi all, I have an XMLUpdater setup in my workspace, but it's painfully slow. I'm trying to update XML documents with 10k+ updates in some cases, but it will hang and take forever to complete. On average it's applying approximately 1 "Update" feature per second, meaning 10k "Update" features is taking close to 4 hours (with caching on but it's also slow without cache). The XML has around 200k lines (10 MB file) so that's not helping. I have tried obvious steps such as removing unnecessary attributes and the geometry from the update feature, sorting the order first, and limiting the numbers of calculations/swaps that the XMLUpdater performs, but it still seems slower than it should be...  I'm applying a "Replace contents" update type, with XML path of the format "//Element1[@name=fme:get-attribute("_att1")]/Element2/@_att2". The only way I can

I have a workspace with an FBX input (file attached) which is essentially a cylinder with oval ends with a few transformations which then writes to GeoJSON. It has a CoordinateSystemSetter transformation applied set to EPSG:6677.When viewing the GeoJSON ouput via Cesium we noticed the cylinder is just slightly out from where it should display.We believe this is due to the origin point not being the center of the cylinder.I have applied the following to try and correct the issue which does look closer:Added a CenterPointExtractor transformer (_inside_[x or y])Added a BoundsExtractor transformerAdded a Affiner transformer which uses results from the above two transformers to attempt to center the point of origin (only interested in the x and y axis). The Affiner is set to:1 0 -(@Value(_xmax) - @Value(_inside_x))/20 1 (@Value(_ymax) - @Value(_inside_y))/2 Any thoughts on the above if I am doing it correctly and how t

I am trying to get the KMZ file from the Website and download it to my pc. When I tried to get the file from pc and run the featured reader, I got only two features.  and this when i nnot add on its

I've tried about every combination of Source coordinates I can but nothing is coming out right. If I leave it blank FME just copies the coordinates from the source and doesn't actually reproject anything. Do I need a custom coordinate system for the source?

I'm trying to migrate some python into FME that involves DataFrames as the end result.  Rather than trying to manually handle converting the DataFrame to attributes, I thought I could convert the dataframe to a csv in python memory first,  output it as a file on the feature, and then use a CSV reader in the workspace to parse the file.  I ran into issues with getting the csv out to an attribute, so if anyone knows of a way to do this I'd appreciate it. Below is a simplified version of my code (it involves Esri's ArcGIS API for Python), and then I'm using io.StringIO to handle the csv in memory, but I've never used that function before. When I run the workspace with this as a Python Creator, i get the error: Python Exception <TypeError>: Could not convert attribute value to a supported attribute type.Traceback (most recent call last): File "<string>", line 33, in input import fmeimport fmeobjects

Hello Community,I'm working on a project and i need to transform Data from Sqlite (Infraworks) to CityGML so i can then use it for a 3D GIS application.i'm open to all ideas on how i could achieve it or any information related to subject.Thanks,

I have read polygon features from esri file geodatabase. And then writing them to smallworld. The following errors are observed in translation log and the workbench session is terminated with a failure message. Smallworld Translator Error: The hole is not within a sw:pseudo_areaSmallworld Translator Error: Primitive sw:sector_rope:[1-1].sector failed status 1376267(0,21,11) Too many intersections Is there any way to identify these records before we pass on to writer? Or is there any setting we can choose or process so that FME will skip these kind of features and write log. Kindly help. ThanksSiva Bulusu

I want to convert DGN and extract certain features from the DGN file and then after doing operations on the extracted content of DGN I w again want to visualize. It would be great if anyone can help me with this.

I'm reading an Excel file using the Excel Reader. The reader works well for all fields except one. It consistently marks all the values in a particular numerical column 'Number of meters' (column G of each sheet) as missing. The file is open data but a copy has been attached for convenience: https://www.gov.uk/government/statistics/lower-and-middle-super-output-areas-gas-consumption

Hi!I have a lot of pictures and I would like to extract the date of creation.But when I use the Reader it's too long.So I tried with PathReader, but if I do that, the properties of the pictures are not avalables.Does someone knows how to do that?Thanks !!!