Transformers

I have a field with a code (number) and I would like to know if a feature haven't a number code in her line (maybe a message like "error" or other but with letters). Thanks for helping

Hi all, I've published a workspace to FME Server which updates some rows in Excel. When run on FME Workbench, the rows are correctly updating (using fme_db_operation = UPDATE) at the correct row number, which starts at row 10. I've set the row number by using a counter for xlsx_row_id with a Count Start set to 10. Weirdly, when published to FME Server, the workspace ignores the xlsx_row_id attribute and starts writing at row number 1 (even though it gets the correct column positions). Is this a bug in FME Server? Does anyone have a workaround? I've tried different options in the Start Position parameters of the FeatureWriter (both "Named Range Start Row" and "Start Row") but no success... Any advice gladly received, BI

Dear All , We have a line and we need to add an arrow to it , as shown below we need to add the blue line , it looks that we need to use 2d pointer adder but how to get the exact location from the end point and draw two lines

Vertex normals removed due to application of non-invertible matrix,Error running translation. when I try translate the 3d .obj model to 3dtiles,the error Appear，of course not all obj appear the error

Hi, I am new for using FME to create PostgreSQL database and having trouble updating schema or adding columns to the existing table. so to explain in detail: 1) I have different councils 3 waters pipe data which I want to add to my database2) I have already done extracting, and transforming of data but now I want to load data coming from different councils into a single PostgreSQL database3) So I am using FME writer format "PostgreSQL" and table (say Table1) definition as "Automatic" and ok till I have added the data from one council having 52 columns4) Now when I am trying to add data into same postgresql database table (Table1) from other council having 79 columns in it ... my database is not accepting data from those new columns came from new council 79-52= 27 columns into my existing database table Any comment or recommendation on this will be great!

My workflow regularly compares files stored at path X with prefix Y with files stored at path Z with prefix Y. I'd like to set up the workbench in such a way that I'd copy the workbench for a project and only have to edit the Y parameter for it to read in the required files, i.e. Read: $(Path_to_X)/($Prefix_Y)*.csvRead: $(Path_to_Z)/($Prefix_Y)*.csv Can this be done, and if so, how?Thanks!

Hi all,  I was wondering if somebody could advice me a good tool that can be used for good version control of FME Workbenches and FME Custom Transformers. Any suggestions? Preferable an open source tool.  There are some  tools available for this, but most of them offer also automated "merge" and "compare" functonalities and in my opionion  this doesn't work well on .fmw en .fmx files, therefore I prefer not to have this functionality.  In case there is a difference, the user should be the responsible to choose the local version or the version of the server to decide which one to keep. Also multi-user-editing of the same workspace is not something that works in an FME environment (yet). But I do have interest in the back up functionalities, the compare functionalities, have a single repository of the main workbenches, being capable of taken the models locally and run them locally,...  I experimented with GIT

Hi altruist, I am having an issue in after using AreaOnArea overlay operation. I have overlaid two polygon datasets and ideally the output should have attributes from layer when there is _overlap field have 2 and more. This is what happened for other overlay operations. However, in the following cases I do not see the attribute from one of the polygons after the overlay operations: This is the attributes before overlay:The overlay operations:After the overlay:Does anyone have idea why that may happen?

I'm currently exploring MapBox and their Tiling Service, which is currently in Beta and I'm trying to figure out how to create a line-delimited GeoJSON output so I can upload via their Tileset API.  The data/file needs to take the format as per the example below: Normal GeoJSON{    "type": "FeatureCollection",    "features": [        {            "type": "Feature",            "properties": {                "name": "Melbourne"            }, "geometry": {                "type": "Point",                "coordinates": [                    144.9584,                    -37.8173                ]            }        }, {            "type": "Feature",            "properties": {                "name": "Canberra"            }, "

I am trying to read the following URL (https://eprostor.gov.si/ods/atom?id=1&type=data) with a FeatureReader transformer so that it will download the zip file and process the data within. This works fine with many other URLs I have used in this way (e.g. https://services.cuzk.cz/gml/inspire/ad/epsg-4258/583723.zip), but not for this one.The error is:XML Parser error: 'Error in input dataset: 'https://eprostor.gov.si/ods/atom?id=11&type=data' line: 1 column: 11 message: invalid byte '�' at position 1 of a 1-byte sequence' I have attached an example workbench and associated csv containing a successful an

Hi. I need some advice please. I have a 5x data branch at the end of WS. Each branch contains a defined attribute, see note. This attribute is part of the DepartureLeg. Each departureLeg contains a startpoint and an endpoint, two points (it can be one of the variants of five branches ( airportstartpoint, navaidendpoint... etc. ) and each departureLeg is part of a Departure. Chronologically, it goes like this. A departure contains several departureLegs and each departureLeg has two points ( airportStartpoint, navaidStartpoint, navaidEndpoint, etc. ) This is how I need to group it, but I can't. I think I have all the ids I need.

Hi, I'm struggling reading geometry from an xml file. When looking at a part of the (0.7Gb) large xml, I can see it has coordinates that reference a location I do not expect:<gml:LineString srsName="urn:ogc:def:crs:EPSG::4258" gml:id="GEOMETRY_98ce8c1e-3676-4a60-b2a8-d7e63fe97d1d"><gml:posList srsDimension="3">51.77106873325691 5.459700336196274 49.41166353587596 3.2520665388839736 47.937498062913775 8.934025947231504 51.771400476701494 5.460105669526139 49.412014702926356 3.25205099130662 47.937476504785614 8.934700858000644 51.77170841095756 5.460502642204418 49.412240574188026 3.252040990938717 47.93746470527796 8.935070205423436 51.771910436397455 5.46090045825306 49.41302764854071 3.2520061426583493 47.9374374566226 8.935922993715176 51.77277383456701 5.462819713112839 ...</gml:posList></gml:LineString>The 3D coordinates seem to alternate, which might have something to do with a side view

The documentation for the IGDS (DGN) reader states that "Design files consist of a header, followed by a series of elements. The header contains global information including the transformation equation from design units to user coordinates, as well as the dimension of the elements in the file" . My question is how do I read only the header information - coordinates and dimensions etc. I have a large number of files and I just want to the header info from each one. I know how to run the batch processing part with the workspace runner but can't figure out how to set up the reader.

I am trying to solve the application allocation issue through FME. The scenario is I have a list of applications and a list of places with limited spaces.  My initial thought is to sort applications by date, every time, send only one application to the neighbour finder and then change the place's available spaces.  The issue that annoys me is it seems like two loops running parallel but also linked together. Not sure what's the best way to design this type of loop? My loop design seems like just creating an endless circle.Any guide would be much appreciated.

I have a dataset where polygon sometimes have a long and narrow part like in this image (upper narrow part of the highlighted polygon): I am looking for a way to cut polygons like this in two parts so that the small polygons becomes a separate shape.Any idea how to do this automatically? 

I have a dataset with 3 attributes (REF_ID, orde, DMdrempel) and one (DHMdrempel) has formatting (colouring) applied.There is a 1 to many relation between REF_ID and orde, a 1to1 between DHMdrempel and orde (although sometimes values of DHMdrempel can be identical).I want to create a pivottabel as this one but with the formatting applied:I apply an attributepivoter with parameters set as follows: group rows by REF_ID, group colums by orde and attribute to analyze is DHMdrempel.Because of automation purposes and because I don't know the (maximal) number of 'orde'/columns, I cannot use the attributeExposer (or at least I think I can't). I therefore use a Dynamic writer to create my excel file.But I want

I have an ETL doing one thing, running SystemCaller to run a python script. This works fine in Workbench but is not working on Server even though the log shows an EXITCODE of 0. Both desktop and server are windows 64 environments, FME 2019.0.1.If we log in to the server box and call the script from cmd, it works just fine. We tried logging in as the fme user account and it ran just fine as well. Its only when running on FME Server that we are having problems. I have tried referencing the python script from a directory drive and copied to the Server box, doesnt seem to matter. Some clues. The log for the job has an exitcode of 0. When running successfully on Workbench we can see in the log where SystemCaller executes the Python and it logs everything the script does. The log on Server executes the Python and moves on to the next Transformer (no log from the python script running).The Python script being ran must import other Python scripts. When I remove

The attribute values is from GitLab pipeline which is called in JSONFragmenter and stored in Attribute Keeper. Now need to pass these attribute value to an azure file storage connector.But the Azure Storage connector is not taking the Attribute values, only parameters are working.Able to pass the published parameters as well as the private parameters.Kindly help me with this.

Hi, I'm working with a mesh feature with around 200 vertices and edges.I saved it to my local PC in 3ds format.I guess the file size is too large than ordinary 3ds file(maybe 4~5 times bigger compared with almost the same file.)I found that 3ds writer in fme is using native fme entity rather than 3ds entity type.(similar question: https://community.safe.com/s/article/fme-creates-large-autocad-dxf-files)I couldn't find any parameters or methods to do the similar thing...Is there any way to reduce my 3ds file output? Thanks a lot. ​

I currently use this WHERE on my reader:[Last_Updated] < DATEADD(week,-1,GETDATE()) or [Last_Updated] IS NullI now have a need to use the items that are older than 1 week, then another need to process those items that are less than a week old. I have added a TestFilter, the NULL test is easy, it is the 1 week item that brings me unstuck. Is this possible to do?  Or do I need to add another step in my chain of processes? Thanks heaps.

Hi,I have several obj files for a city. I succeeded to convert these obj files into cesium 3D tiles. At the result of tiles, texture of models created darknessly. To solve this situation, I used AppearanceSetter, then set Shininess value. However, textures of models got lost. How do I set shininess value of my building with textures? I want to share created models by using AppearanceSetter:I want to share without AppearanceSetter:Its my workflow:Thanks for your interest.

I am using FME Server 2017.0.0.2When I start a job (jobsubmitter service) from the repository, it gets queued.But at the moment no job is running and an engine is available.When I go into the queue and resubmit the job, a new job gets executed running the same workspace without any issues.Has anybody seen this before?And if so, how to solve it?

Hi guys, I'm after a bit of help for creating FME Geometries with a Python Caller. The module I'm using is giving me an object in the following form (it should be a TIN)  [((x1, y1, z1), (x2, y2, z2), (xn, yn, zn)), ((next triangle)), ((last triangle))]  I want to have this as a multi polygon or TIN and my Python skills are fairly lacking. My first thought was to try and format it as WKT in FME but I figured there must be a more elegant way to do this in the Python script itself.  Any suggestions on the best approach here would be nice. The ideal output would be either a multi-polygon or Multi-Surface.

I have .csv file which includes time stamp, lat, lon, altitude and image name columns. I matched image name column on .csv file with image's fme_basename via feature merger transformer. And also, i can write as exif in JPEG file lat,lon,altitude. But i can not write timestamp as a exif on my JPEG image file. Could you help me in this situation?

We recently upgraded from FME Desktop and Server 2021.1 to 2022.1 and are now noticing about a 3' shift while using the Reprojector and CsmapReprojector. The shift is not present while using the ESRIReprojector and PROJReprojector. In this example scenario I've attached workspaces for both version and shapefile outputs of the coordinates. The workspace has not been modified and has been ran in each version to generate shapefiles for reference that contain the coordinate values that differ between the two. We are going from NSRS11.LL to TX83-CF. Is there anything specific that has changed in the newer version that I might be missing when handling certain reprojections? Both workspaces have reprojection engine set to FME.