FME Form

I have some workbenches that take a over a hour to run and I'd like to get the command line arguments to create a batch script without having to run the workbench

Hi All, more or less the same as this query, but checking if anyone has any suggestions on a solution for downloading emails received to an account monitored by fme server? The email & content is used as a topic/trigger to start a workspace, i now need to also download a local copy of the email itself (eml,msg file). Is there a way to do this though fme?

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

Hi everyone,I have a script with a reader that connects to an ArcGIS Enterprise database through a connection file.  My question is: Is the connection file information embedded in the script itself, so if I move the script to another location, that do not necessarily have access to the connection file, will it still work? Or is there a way to make sure that my script works whether it has access to the connection file or not? Thanks 🙂

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.

FME 2022 Build22153: Calculating the value of an attribute fails, In the screenshot below, I wanted to calculate the “BuildingPercent” attribute field by dividing “BuildingArea” field on “BoundaryArea” field but appears not to work. It doesn’t perform the calculation. What could be the issue here? The data and the workbench are attached    

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.

We just updated to 2022.1 and now I'm getting an error when using the Tester.That's what I did:I  used a Creator and created an attribute "attr1" with the value 5 in an AttributeManager.Now I add a Tester with "attr1 = 5" then I get this error: Tester (TestFactory): The clause 'TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>attr1<closeparen>,Tester) = 5 ENCODED }' within 'FACTORY_DEF * TestFactory FACTORY_NAME Tester INPUT FEATURE_TYPE AttributeManager_OUTPUT TEST { @EvaluateExpression(FDIV,STRING_ENCODED,<at>Value<openparen>attr1<closeparen>,Tester) = 5 ENCODED } BOOLEAN_OPERATOR OR COMPOSITE_TEST_EXPR <Unused> FEATURE_TABLE_SHIM_SUPPORT Yes PRESERVE_FEATURE_ORDER PER_OUTPUT_PORT OUTPUT PASSED FEATURE_TYPE Tester_PASSED OUTPUT FAILED FEATURE_TYPE Tester_FAILED' is incorrect.  TEST must look like: TEST <value> <operator> <value> [ENCODED]

Hi all,  I am trying to remove some keywords based on the value of another column.   What I am hoping to achieve: Removing Oxley & Victoria in Column A Can anyone please provide some assistance.  Thanks

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, Can anyone recommend a workflow to have measures generated across line multiparts with measure formed based on the order that the multiparts are stacked in the geometry. The measuregenerator is rejecting multipart line geometry items. I have valid multpart lines (roads with gaps) for which i need to run a measure across the gap (but not including the gap in the measure). If not possible using current FME transformers, could i please submit this as a feature request to enable multipart measuregenerator. With thanks.

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

Hi, Are GDAL raster processing tools available in QGIS also accessible from FME Desktop on the same machine? If yes, does someone have an example script of how to call and run such a tool from the GDAL library. In QGIS I would for instance use the tool itself with the following command line for generating contour polygons:gdal_contour -b 1 -p -amin minimum -amax maximum -i 50.0 -snodata -999999994.0 -f "ESRI Shapefile" <input path> <output path>How would the code need to look like for example in a PythonCaller on a typical Windows machine with both FMEDesktop and QGIS installed on it? Thank you! Best regards, Olivier   

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

Hi, I have a feature point with X and Y coordinates Attributs filled by using the CoordinateExtractor. I would like to know the adress of the point. So I have prepared an attribut called ADRESS. How can I extract the adress from X and Y coordinates?Thank you

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 ?