Transformers

I tried to change the data types from unit8 to unit64, but without success. When I convert to xlsx, all values are loaded, but I have another problem. Vertexcreator does not create values in decimal development correctly. Why the same data, but in csv it creates the vertexcreaotor correctly and in xlsx not? I would need to either solve the correct loading in csv so that I don't have a null value - here vertexcreator creates points correctly for me, or load the data from xlsx correctly and solve the correct addition of a point by vertexceator. Or does anyone else have an idea? Thanks a lot!!!

I am trying to do an update to a PostGres database based on whether or not the created key PID is present or not. If the created key PID is present for the row it updates the row with the new information if not it inserts it as new row. The problem is the test for the difference created a different stream and it won't let me have two writers writing to the same table. The table name gets a 00 appended to it and can not be changed to be the same as the other stream. This seems like I am missing something simple as database operations go but why will FME not let me set two different writers to the same database table to satisfy the two possible condiditions?

Situation: I have geometry in a local coördinate system and through the affineWarper and vertex creator I can transform it and move to the actual location in the coördinate system I prefer. The problem is that the affine warper needs 4 points and I only have two points of reference placed in an old analogue drawing. Is there a simple way using FME to create these extra two points for me? So far I've georeferenced the analogue drawing twice to get the coordinates I need. This is quite time consuming and I have a feeling there should be an easier way.

I find it REALLY difficult to use FME for feature change detection.I'm using an api to grab weather data and store it in a table. Occasionally the api might send an updated value for one of the records.So I might have STATION_NAME, DATETIME and VALUE from the api to match against the existing record.I can use the FEATURE_JOINER to join the STATION_NAME and DATETIME, but then need to update the value.Any idea what the best method is? I have tried the FEATURE_MERGER and CHANGE_DETECTOR, but neither seem to be simple to set up or understand...

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