Transformers

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 these other scripts as

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.     

We have a workspace that retrieves data from 40+ tables in on and off-site databases and writes the results to tables in an on-site Oracle database. The workspace consists of SQLexecutors and SQLcreators which read the data using ODBC, and Oracle non-spatial writers which write to the local tables. To help with data verification, for each table written to in the local database I want to write a row to a data verification table with the tablename and the number of rows written. I've tried using Counters and Samplers attached to each reader to get the number of rows written, and can route those to a writer to write to the data verification table, but can't seem to get the table name exposed. The attributeexposer and exploders expose the column names but not the table names. And I was hoping there may be a more efficient way of doing this than by attaching individual counters and samplers. Basically, I want the Features Written Summary from the workspace log written to the data ve

Hi, I have a single point cloud which has contains both points with colour and points without. Does anyone know how I can split it so that I can separate the two types of points? I have a script to turn the intensity component into black and white colour values but I don't want apply it to points that actually have colour information already. Does anyone have any ideas? Possibly there is some expression for the PointCloudExpressionEvaluator I could do? But I can't think what.  Any help would be appreciated

I'm having trouble using AttributeSplitter to split everything with a semicolon as delimiter, EXPCEPT skip seimcolon's that are within parentheses. Please help! Thanks! Example 1424462 (EXT: 1488296; 1491537); 1428106; 1436651; 1436653 What I need is:1424462 (EXT: 1488296; 1491537)142810614366511436653 

Hi altruist, I am trying to fetch data through API for the first time through GET method. However, I am getting error message each time with a code 401 (unauthorized access). Can you kindly tell me from the first image, whether I have correctly put information in the HTTPcaller transformer? I mean the access is really unauthorized or need to other parameter values? I have used the site owner provided credentials to get the request URL. A help will be really appreciated.

Hello. There is an interesting problem, but I can't solve it. I really need your help.1. I have an image footprint. This geometry (polygon)2 . I have an image from a drone. I know the area of interest on the raster. But the area of interest in the local coordinates of the raster , for example, the size of the raster is 80x100 pixels and the area of interest is set to Row and Column 11,13;11,64;25,64;25,133. how to create a zone of interest with a distortion in the geometry, based on this data ?

I have an XML attribute containing metadata of a large number of tables. For each table I want to search through the metadata and extract the table name, all of its attributes, and the attribute descriptions. Each table has a varying number of attributes. Once I have the values want to print them clearly on a Word document where the table name is at the top of the page with all of the attributes listed below.

i have a feature in the sde db that is 1.7M records, the data i am trying to select has a field i want the user to select from. the 1.7M records data set does not have that field so i want to select them spatially, which i am doing now, without all 1.7M records having to be read by the workbench. 1000 or so records to select takes about an hour due to the workbench reading all the records before the spatial selection happens. is there any way to pass my buffer results from the users selection to the reader in the envelope section of the reader before all the record are read?

Creating and enclosed polygon of the point data. Hi, I have a pole data connected to houses. I wanted to create an enclosed polygon with the pole and all its corresponding demand points. Can some one help. Attached is the requirement

Hello, i have problems to write data with the Esri ArcGIS Portal Feature Service Writer.The writer is not able to write the date-values into the date-type-attribute. I've did research in the internet and tried a lot of different date-formats but nothing is working.I've also created a hosted feature layer in Portal for ArcGIS to see how the dates are written when i add features. I cloned that date-format in the workspace but this also failed. Is anyone out there who successfully wrote date-data with the Esri ArcGIS Portal Feature Service Writer or has an approach to solve the problem? I'm using Workbench 2020.2.0.0 (20201027 - Build 20787 - WIN64). Thank you very much! Greetings!

I need something like 3*bottle = bottle;bottle;bollte. First table is what I have and second what I need. 

I have created a 3D object that used as a geometry instance and placed at a set of point coordinates. My input was a citygml exported from an original sketchup model and a shapefile file for the points. I created a final citygml file combining those two with the instanced geometries. When I upload it to cesium ion as the citygml it works perfectly fine and cesium creates the tiles for me.  Since I need the 3D Tile to use in my application, I then also tried to transform this citygml into a 3D Tile with FME. I simply used the 3D Tile writer. It works without errors and I also can upload it in Cesium ion and I don't get an error. However, when I try to use this 3D Tile in my Stories on Cesium Ion, I cannot see anything. My 3D objects do not show up.  Does anyone have an idea what the problem might be? The citygml that I created seems to be perfectly fine and usable in cesium but the 3D Tile that I create with FME does not show anything in Cesium.  I would really appreciate some help

Hi, I am new to FME. I would like to concatenate two columns into one by simply putting the names of the title of columns together in the text editor in attribute manager. It is always successful in 2018 but keep failing in 2022. The two columns are ordinary character type of data without any special characters like * or / etc. Thank you for the help!!!

Hey community! How can I create DWG blocks with related attributes? I need to create topographic point blocks with various attributes, such as point number, point type and other attributes Thanks

I have an excel file, it has a sheet with quotes inside its name:I created a workspace that includes a  feature reader with the following configuration: and use an Attribute Creator transformer to pass the correct information about the file path and sheet name:When I run the workspace, I receive :Opening the GENERIC Reader on dataset `C:\Temp\problematic_excel.xlsx'Excel Reader: Output cell formulas: 'false'Excel Reader: Output cell formatting: 'false'Excel Reader: Output cell comments: 'false'Excel Reader: Force full datetime values: 'false'Excel Reader: Opening dataset 'C:\Temp\problematic_excel.xlsx'...Excel Reader: Reading sheet ''OSVAT-42"''...Excel Reader: Internal error: Could not find any sheets to readCreating reader for format: Generic (Any Format)Trying to find a DYNAMIC plugin for reader named `GENERIC'FME API version of module 'GENERIC' matches current internal version (3.8 20210203)Generic Reader: No valid reader name specified, guessing reader name from dataset 'C:\Temp\

Hi Guys,for sure someone has aked this before but i didnt find an article.....it is a very simple questioni have to handle with a lot of excel sheets i have to select always the first sheet in any excel file.....but sometimes they have different namesso how can i select the first one.... Greetz and Cheers Franco

I want to delete the input data in my script with the help of the Featurereade and the hub FileDeleter , but only when all features have been beforehand wrtitten to an export map in the FeatureWriter (see image below). So I don't want featurereader and the FileDeleter already running when not yet all files have been exported . I was wondering how that can be achieved in FME desktop? In case my question is a bit vague, just let know.