Transformers

HiI want to apply a transformation to all the files contained in the root folder "Vuelo84" (see attached image ). Those files are in their subfolders. I know how to load all of them in the reader, but I would like that the transformed files would be located in their own new subfolders, created by the FME itself at the same processing time. Is it possible? Thanks!

I am using Directory and filepath name read and then FilePropertyExtractor to build a table with all files of a specific file type. I then use time stamper to create the file name. subsequently the workspace is run a second time and the previous file (using sorter and sampler) is pulled into feature reader and then to the ChangeDetector.I can't seem to add a uuid because it recreates a new one each time i run it. So i can't use that as an update key.So right now i am using the unix path as an update key and i get all features as updated. (when there are no changes)If i set the check attr types and encodings to yes i get all of the original as deleted and all the revised as inserted.I just read that the order makes a big difference in the CDor. So i rearranged a bit and added sorters. Then I had to reformat my date modified attribute. and i think that might be it.I would take any suggestions anyone has to make this better. It is going to have ot run over an entire network (which

I'm reading a PostGIS database layer that is formatted as 'Text'. PostGIS treats this as basically an unlimited-width VARCHAR field. However, the FME PostGIS Reader truncates this field's input to 80 characters, and I can't get it to change to accommodate more characters.

Hi,I would like to change the results of a GeoJSON writer when there's no attributes that pass my transformers. For example, when I got what its like in the left picture, I got a reply from my GeoJSON writer like so : { "type" : "FeatureCollection", "name" : "aspvhn_Strct_sur", "features" : [ { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ -73.8119918787, 45.6095554592 ] }, "properties" : { "idstruct" : null, "producteur" : "MTQ" } }.But, when its like the right picture, I got nothing from the GeoJSON writer. What I want is that when I got no attribute that pass my transformers, i'll still have an answer that looks like what you see as above but with space instead of nothing at all. Thanks.

Hello. I have textured CityGML files that I want to reproject. When I use EsriReprojector transformer, the result is successful, however, the written CityGML files lost textures. Appearance parts completely lost in my output files. How can I keep texture?

I request the MVT files with these urls. (behind password)https://maps-ver.lantmateriet.se/vt/fastighetsindelning/v1/wmts/1.0.0/fastighetsindelning/default/3006/10/1500/1600.mvt (then /1501/1600.mvt etc.) Generated files in Drive link (https://drive.google.com/drive/folders/16XT71TQnF-bQFYHZ2zv87PR22a7_EJB3?usp=sharing Style information: https://maps-ver.lantmateriet.se/vt/fastighetsindelning/v1/wmts?request=GetCapabilities&version=1.0.0&service=wmts From provider Tilematrixset is 3006 (SWEREF99 TM).  I generate workspace and select all four MVT files with the following settings and press run.The generated GeoJSON files have the information stacked on top of each other on the same coordinates which are incorrect. Not sure what to do.

Bonjour. J'ai un attribut au format numérique et je souhaite le transformer au format date ? Commentaire faire ? Exemple la valeur numérique est 2017 et je veux la valeur au format date 01/01/2017. Merci pour votre aide

Hello, I'm stuck on trying to transform attributes in a DWG to a GDB , and am encountering a projection error. This is specifically for the DWG's annotation/text - the line and area geometry is successful. The projection is from Perth Coastal Grid 1994 (PCG94) projection to WGS1984 Web Mercator Auxillary Sphere (EPSG:3857). The error messages are below: Reprojector: Reprojection failedReproject: Failed to reproject these attribute pairs: autocad_alignment_x / autocad_alignment_yEsriReprojector_4: Reproject: Could not reproject the geometry of the preceding feature: Reprojector: Could not reproject feature from `_FME_1' to `_SPHERICAL_MERCATOR_0'. Coordinates out of range  I've separated out the line/area and text geometries to test the success of each. I've tried using the 2DForcer to no avail. I've also tried using a Tester to filter out potential 'problem' annotation layers but every single one is getting caught. I'm aware of Csmapprojector, ho

Hello guys,This is my first FME script I am trying to convert new JEPGS in a folder to PDF  how do I do that ? what transformers and how to is et my readers and writer to be taking all the new JPEGs and converting them into PDFs with the same names ?

I'm reading in an excel file to extract an interest percentage. Due to the format I receive the file in, I'm using a substring extractor to remove the % sign and then dividing the number by 100 to get in the proper format. It looks like between the excel file and the arithmetic editor, the number is being rounded up. Anyone know how to prevent this? Screenshots of original excel and inspector results provided. The number in the screenshots I'm focusing on is 98.517% changing to 98.520 - 0.98520.

Hey there,What effect does the parameter 'Ignore Nulls' in SQLExecutor have?Or in other words: What happens when the SQL statement doesn't give a result? In my workspace these features are not going through the Result-output. In fact, they get lost :-(.I know I can do several workarounds, e.g. merge the output with the initiator via an unique attribute or modify my SQL statement (which will be something like 'select nvl(min(ATTR),'doe') from ...'), but I expected the parameter 'Ignore Nulls' might give me the non-resulting features with a NULL-value in the result. -Maria (using FME 2021.0)

Hi all, I've created a workflow in the workbench to extract historical data and store in a database. The JSON Reader contains date at the end of the URL For this time being, I have to manually change the date and then run the workflow. This is quite tiring as the duration for the historical data is long.  Do you guys have any idea or is there any other method or transformer to automatically change the date in the JSON Reader before running the workflow.

Hi,​I am hoping someone in the community can help me with the issue I am experiencing during ArcGIS Indoors to IMDF transformation. Openings features, which are part of the Details FC in my ArcGIS indoors information model, are not being picked up during the FME transformation process - meaning the output does not contain openings.geojson file at all.​FME transformation phase that extracts the openings from Details features seems to be passing as expected. Feature geometry checks are also passed, but then the FeatureTypeFilter leaves them Unfiltered.The reason for this might be in the fact that assigned IMDF category for these features is set as pedestrian (which I understand is one of the allowed IMDF subcategories for Openings).  I would appreciate if anyone can offer some assistance. Thanks

Hello I'm tryng to run a workspace in FME Server but this error is show during translation: XML Parser error: 'Error in input dataset:'/mnt/efs/fs1/resources/data/Products_LEDE/PCP/Netherlands/NLD_201G0_PCP/1_Src/BAG/Inspire_data_NLD/9999NUM08112020.zip' line:1 column:57 message:invalid byte '�' at position 2 of a 3-byte sequence'The XML Module halted on error, see the logfile for details I have run the workspace locally to check if the file was damaged or something similar, but it ran correctly with no issues.... Does anyone know how to solve this issue, please? I need your help

I have installed the JDBC driver and we are using Apache Hive Kerberos security connection. Can you please help me with the documentation that how to connect with Hive Kerberos security .FME VERSION: ME(R) 2021.0.2.0 (20210429 - Build 21321 - WIN64)

I am trying to work out how to translate a SHP to a DGN, using an attribute in the SHP file to become the Z-value in the DGN

Hi,I need some help. I would like to create a certain imaginery polygon (Search envelope​) from a private website (coordinates) to my fme workbench. To put you guys in context, we are calling a website from the FME by writing coordinates details on the website. In our workbench, we got a Readers who contains a lot of road structures in a entire territory. Furthermore, the time of the calling from the FME Workbench to the website is 20s. I want to reduce this time by create this type of 'search envelope' to save some time by create some sort of a polygon near the road structures who are inside the Coordinates. Can someone help me with this problem? Thank you!

Hello FME Community! I'm having trouble transforming a datetime to incorporate ​a UTC offset. Using the DateTimeConverter, any time I try to use the Timezone shortcuts (%z or %Ez), it tells me "Output Formatting Error: format flag '%z' is not supported for input type 'datetime' in the Preview Data window. I've read the transformer specifics and date/time terminology, etc. I've also tried using a DateTimeCalculator to use @TimeZoneSet but can't figure out the syntax there either. I've attached two screenshots - the first is what I want to resolve the datetime format to (but had no UTC offset) and the second is when I use the Timezone UTC offset shortcut.  I'm sure I'm missing something in the syntax - can someone help? Thanks!

I'm assuming it's either Dijkstra's or A*, but would like to know for definite! Cheers in advance!

This is my workspace, it adds elevation to lake polygons and river lines from a DEM. Lakes are calculated by clipping the raster and getting median elevation, meanwhile river lines are draped onto a surface. Most of the time my data does not contain any lines, but the SurfaceDraper still creates a surface, which can take a while - is there a way to improve performance by preventing the SurfaceDraper from doing anything unless it receives at least one DrapeFeature?

I am trying to read XML data from the following URL, which is for the food standards data in the UK. Whatever method i use to read this data i just get errors. Can anyone tell me how to extract this data correctly... https://ratings.food.gov.uk/OpenDataFiles/FHRS131en-GB.xml 

Has anybody attempted a nearest neighbour with breaklines/obstacles? It's not as simple as creating zones and assigning an ID to to use as a group-by in the NeighborFinder. Consider a lake where the distance has to go around the lakeshore instead of as the crow flies.

I try to tranform the cityGML to CityGrid XML. The CityGML have surface of roof, wall and texture - when I try to tranform to CityGrid XML - just a roof is ok about geometry and texture. But when I tranform a roof+wall of the building - the texture is wrong in almost building.

Hello,  I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database. I have tried to find an example online doing something similar but I had no luck. I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it.  Thank you very much.

Hi there!The attribute is composed of concatenated values.When I test if the concatenated values work as a regex, it succeeds:But when I try and use the created attribute, it doesn't match. I would love your input, please.