FME Form

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 ve

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 ?

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.

if desktop support red hat centos stream? centos stop updating

A Program I use can't export a GDB but can export a folder with shapefiles. The problem is the names of the attributes are truncated for shapefiles upon Export. I would like to Set a feature reader to pull all .shp from a folder I set as a parameter. Then I would like to batch rename attributes of the features. But different feature classes have different attributes that may or may not be truncated. When I export my GBD I need to set up the new schema somehow. Any Ideas?  

I have a dateset of polygons which I know includes some anomalies such as self-intersecting and spikes. I'd like to identify these and if possible count the number of instances of each type in a report. I have tried following the FME guide on self-intersecting polygons but it does not seem to be working as I expected on my dataset. I'm not sure if its my setting in the GeometryValidator transformer or my base data that is at fault. Any guidance would be much appreciated. I'll include some images of the types of issues I'd like to identify along with the workbench I created and some sample data:  

Hi I've tried to use The Excel To PDF Writer but i have problemsafter some errors about phyton stuff i have installed pywin32 and pypiwin32  https://docs.safe.com/fme/2021.0/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Installing-Python-Packages.htm fme.exe python -m pip install pywin32 --target C:\\Users\\<username>\\Documents\\FME\\Plugins\\Pythonfme.exe python -m pip install pypiwin32 --target C:\\Users\\<username>\\Documents\\FME\\Plugins\\Python fme.exe python -m pip list it was successfully but again an error message  ExcelToPDFWriter_ConvertPDF (PythonFactory): Splitting bulk features into individual featuresPython Exception <ModuleNotFoundError>: No module named 'win32api'Error executing string `"""Converter from Excel (.xlsx) to PDF (.pdf).This module depends on the following modules:   - pywin32To install open an elevated command prompt and enter: pip3 install <module_name>.Heijmans18-04-18Rob BraggaarCan somebody m

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?

Draw connectors to point I have a polygon with a pole and demand points. I want to draw lines from pole point to demand points in that polygon as shown in the image. Any help please

i have an excel file with a GPS coordinates that i changed into points using vertexcreatori'm tying to build a line between those 500+ points, i used linebuild but instead of one line i got a lot of emif anyone knows how to fix it please tell me !it should look like this ( same excel file just sorted by Date attribute ) :

hello, i'm interested to know the usual process in reading/getting files from FTP caller.I did make FTP caller run, however, I don't know the next transformers to use to read the csv (not in a zip file) from the FTP server. I tried attribute splitter and list exploder, but didn't work. Can you share a sample workbench for the same case, please?Thanks!

FME Desktop v2021.1.1.0postgresql v11.13 We have an expiration date col that we default to a hard coded high value on INSERT using a trigger and function. The value of that timestamptz col is:9999-12-31 23:59:59.000 -0600 SQLCreator or SQLExecuter will not allow the selection or reference of that column. However, I can select or reference the col in DBeaver without issues. This statement produces this error in FME:select exp_ts from test_table;POSTGIS reader: An error occurred. FME will attempt to obtain more information on the error, but this may cause the translation to be terminatedPOSTGIS reader: An error occurred. Here is the information that FME was able to find on the errorPOSTGIS reader: stk::ex::bad_expected_access Workaround was to change the col to timestamp.Any ideas?       

Hello, I am trying to figure out a way to schedule an ArcGIS API for Python Script form FME environment. I want to be able to use FME environment as a replacement of Windows Scheduler. Appreciate any feedback.  Thanks  

Hello and welcome to What's Up Wednesday,Here are some stories about FME news for this week. Accelerating your FMEI've seen a few training courses recently labelled "accelerators", and obviously, the aim is to bring users up to speed with key technology in a short time. So did you know that there is an FME Accelerator training course?  If you're a long-term FME user, who's already taken several training courses, then this might not be for you. But... it would be very useful for that colleague of yours who has used FME a little bit, yet isn't aware of the full potential of FME. It's 90 minutes of pure inspiration to bring you up to speed with FME potential and functionality. Anyway, I mention this because we have some upcoming Accelerator courses and because our New Zealand/Australian partner, Locus, is now also offering the FME Accelerator.  That's great news for all your FME beginners outside of the Vancouver timezone limits. So check it out, and