Transformers

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 failed Reproject: Failed to reproject these attribute pairs: autocad_alignment_x / autocad_alignment_y EsriReprojector_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, however PCG94 is not on there, only PCG20

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.

I can link pictures with data. Can you please suggest how it can be done? Thanks

Hello everybody, because of specific demand I have to use JSON templater -> TXT writer workflow. But, when I need to export values true/false as boolean data type, JSON templater still put me there quotation marks for values true/false - so result is "True" or "False". Please, has anybody idea, how to figure it out to write bool values without quotation marks? Thank You so much! Lubo

Hi All I am trying to convert a grey-scale raster (TIFF file) to one where the pixel colour is based on a scale of the Band 0 value that is specified for each pixel, where green is used as the lowest value and then scales to red for the highest value. The only transformer that I found where I can set the colour is the GradedColorizer. I first used the RasterCellCoercer to get to the Ban 0 value (_band{0}.value) for each pixel and then uses in the the GradedColoriser. Once this transformer finishes its operations on the data, it gets sent to an ImageRasteriser to recreate a raster, which is then sent to a TIFF writer. The workbench file is attached here: . A test image can be found here: . The workbench however fails at the ImageRasteriser, stating INVALID_VECTOR_GEOMETRY_COLOR as reason. I must add that my understanding on raster bands are rather limited. I have also tried other transformers to keep the image as an image, and work with the Alpha band, but this seems to require more kno

Could I convert open street map to dgn file with the same color as maps . I would like to extract only one polygon from OSM to dgn file with the same color as map . How could I achieve that ? Fme 2018 Thanks in advance

input file : GeoTIFF (Geo-referenced Tagged Image File Format) writer DGN File i have checked it before in inspector ,i have shown output and i have written it to pdf ,i got output as i want but when i have written it to dgn writer ,i got as shown as image above.no output could someone tell me the reason ,how could i convert geotiff to DGN ? Thanks for help FME 2018

Trying to convert hundreds of dwg files to dxf, can this be done in FME ?

I am trying to add solid colours to elements in a 3D model. Each element in the 3D model has an attribute where I have stored the hex code for the colour of that given element. I can't seem to get the colour to work - I have tried using the the apearance Styler followed by the appearance setter but it quite often says that the colour codes are invalid - or if they are valid nothing changes