FME Form

Working with crossborder maps that get their data from two different datasets. There are many ways to approach this, and I am toying with the idea to convert the attributes and their values from dataset A to the standard of dataset B. The benefit would be easier downstream processing. A simple example:Dataset A: attribute ‘Lakes’, value ‘yes’Dataset B: attribute ‘water’, value ‘1’Then do some FME-magic to convert everything from A to the standard of B, ie ‘lakes’ → ‘water’ and ‘yes’ → ‘1’I imagine that the only reasonably fast way to set this up  would be by utilizing an external lookup table, csv or similar. How would one go about to change both the attribute and values from an external lookup table? I would like to keep it dynamic and easily editable, so preferably avoiding the AttributeValueMapper. 

Hello,I was wondering if someone here could give some guidance to a problem we are experiencing.We our trying to connect FME to BigQuery but regardless if it is the reader or writer we are unable to connect using Web Connection.For the Web Connection settings we use or own accounts which have access to BigQuery. In fact when we connect directly to BigQuery we are able to see the project, datasets and tables and we are able to run queries on them.But when trying to establish the connection from FME using Web Connection we get the following error: BigQuery Connection ErrorAny help on how to solve the issue or to even find out what exactly is wrong would be appreciated.Thanks in advance.RZ.-

I have a table of data that I’m trying to map. The locations are essentially polygons with their bounding streets entered as attributes:I have street data and have been able to create polygons using AreaBuilder, but am stuck on trying to add all of the streets back as searchable/joinable attributes rather than items in a list.I’ve tried the ListExploder and gotten a stack of polygons, each one with one street’s attributes, but I aggregating isn’t quite getting me the results I’d expect. In a perfect world, I’d be able to run FeatureJoiner or something similar on every item in the list, but it only seems to allow one.Any advice is very much appreciated!

When python caller errors out.It does not show error line number. Message Type: fme::internal::_v0::py::ExceptionPython Exception <GEOSException>: LocateFailureException: Could not locate vertex.🟢06-Report (PythonFactory): PythonFactory failed to close properly

Hi All, I'm new to fme, I have a LAS/LAZ point cloud data and I want to convert it to cesium 3d tiles. how can i do that using FME 2022.1.3. Please Help. -Thanks Aseem

I have multiple .dwg files I am trying to convert to feature classes. However I would like to nest the resulting feature classes inside a feature dataset that has the same name as the input .dwg file. I have tried to change the Feature Dataset name to @Value(fme_basename) under Table Creation Parameters after previously exposing fme_basename:But running the workspace with the above displays this error in the logs:"Esri Geodatabase Writer: Creating feature dataset '@Value_fme_basename_'An error occurred while attempting to create a feature dataset. The error number from ArcObjects is: '-2147220654'. The error message from ArcObjects is: {The table name is invalid.}GEODATABASE_FILE writer: A fatal error has occurred. Check the logfile above for detailsA fatal error has occurred. Check the logfile above for details" When I remove @Value(fme_basename) and just write a regular string, it works. Thanks!

Hi I am trying to set up connection to an external SQL database (the supplier describes it as an ODBC connection). I am using the SQL non spatial reader. However, we have been told it needs to use SSL to connect. Is there an option in FME to use SSL for the connection please?

Hi I am compressing LAS to zLAS with ArcGIS Interoperability.One of files is huge - 2700 million points and 89331057kb Software stops to write fail in folder without any comment at written file size 25Gb (Error running translation). There are no problems with disk space and memory! FME_TMEP is configure properly in 4Tb SSD store. Computer have 64Gb RAM.I am do this translation twice, but result is same and file size is same.Is it ESRI limitation on zLAS size, or something else?Best regards,Arvid

Hello,I have built a workspace in Workbench 2022.2.4 that reads a specified shapefile (e.g. 10_18_24_line_review.shp) from a folder titled C:\New Shapefiles, performs some basic transformations (datetime stamping, attribute formatting, spatial relation, filtering, etc.) writes out two new resulting shapefiles (with naming conventions based on the new ‘_timestamp’ field) to a folder titled C:\Outputs, then moves the original shapefile being read into a C:\Completed folder using the FILECOPY writer.What I would like to do now is:Configure the workspace to read in any single zipped shapefile that I place in the “New Shapefiles” folder. Scilicet, the naming conventions of the zipped shapefiles I receive will not be consistently predictable, but only one will be in the “New Shapefiles” folder at a time.To clarify: my vision is to drag and drop a new zip of a shapefile (containing concomitant files [e.g. .dbf, .prj, .shp, and .shx]) into the empty C:\New Shapefiles folder, open my workspace

Hi,How can I expose the result (print), like attribute in python caller:         from_value = min_iten[0]['from']        to_value = min_iten[0]['to']        print(f"{from_value[:-10]}") Thank´s

I’m looking at an area of survey points that can be divided into east and west areas by grouping with an attribute value. I have used Hull Accumulator to draw polygons around a) the whole area (light purple) and b) the two subdivisions (darker purple). The point population remains the same overall, but I get different external boundaries in places, when I was expecting the same. Alpha = 0. What would be useful is any description about how the transformer makes its drawing choices. I also end up with a donut hole. Again, am trying to understand how this occurs, as I assumed the transformer would create an external boundary only.Many thanks 

Hi together We have a problem by writing mulriple cable data into a fgdb. The process runs once per cable and writes their information into a fgdb, the process is repeated for each cable, stored in a csv list. Now we have the problem, that the next cable in the list is overwriting the previous one in the fgdb, instead of getting appended. We assume, that the problem lies in the writer configuration, but we don’t find a solution to our problem. Is it possible to append data to existing data in a fgdb or do you have any ideas (like Python skripts, other transformers that could append the data of each run etc...)? Thanks for your support

Hi FME folks,Is it possible to sort the column names in the Table View in the Visual Preview alphabetically?It's frustrating to have to scroll all the way to the right to find a column that starts with an “a”... Thanks!

Helly everyone,I am working with data that consists of abrreviations/code items that are strung together in a single field which I am trying to convert to full text. For that I am using a string pair replacer which contains thousands of mapping pairs, but I have encountered a problem which I can’t seem to solve without knowing how exactly the String Pair replacer does its thing. The problem arises when multiple codes share letters. Here`s an example: I have the following pairs somewhere in my replacement pair string**gn green**bn browng gravelF mudSo F:**bn**gn should map to Mud:browngreen but whats happening is this: M:brown**gravelr.I figured that the transformer probably checks its list from start to finish and ordered my list by string length in hopes it would transform longer strings first. The order of replacement items definetely has a big impact on the result and I was succesful of ironing out most errors in doing that but this particular translation and a few others still dont

Bonjour, Je souhaiterais trouver un moyen d’orienter un ponctuel (des supports électriques) par rapport à l’orientation de leurs ligne.

We recently updated to 2024.1 (FME Form and Flow).We have some jobs, that run daily on FME Flow, that read features from an Oracle-db and write to a PostGIS-DB.I downloaded one of the workspaces to FME Form to change something. But in FMEForm I cannot connect to the Oracel-DB anymore. I get this error:Error connecting to Oracle database: message was `OCI_INVALID_HANDLE'. (serverType=`ORACLE_NONSPATIAL', serverName=`xy', userName=`xy', password=`***', dbname=`')I uploaded the workspace again to FME Flow and there it ran successfully.Any ideas, what could be the problem? Thanks in advance.Vera

Not sure why this is possible, but in the FGDB Writer it is possible to create a coded domain into unlimited coded domain.No idea what is the point of being able to do this, because in ArcGIS this is not supported at all. Well, maybe there is something new I missed from ESRI. But yet I can’t see in ArcGIS Pro the SECOND_CD I created.Anyone could tell me what is the purpose of doing this ? What am I missing?I’m on FME 2024.1.Thanks!

Hi,I have a workspace that uses some RasterToPolygonCoercer, but the performance is very low.I need to improve the performance. I'm trying to convert some clouds detected in my raster image into polygons.How can I improve that? Thank´s   

I am new to FME Workbench and I am using the latest 2024.1 version.When I tested to add CSV to ESRI ArcGIS Portal as a new point feature layer, it succeeded to create a new feature service in portal but failed to insert CSV data into the newly created feature service with following error message: “ArcGIS Portal Feature Service Writer: UPSERT failed for feature service 'Sample_Test': Append job failure: 'Operation rolled back.'”Then I have to re-run my workbench again, and this time it will insert all CSV data into the portal feature service without any issue.BTW, I am using “Create If Needed” as Feature Service Handling parameter.Could someone help me out to make this workbench adding CSV data to ArcGIS Portal in one process? Thanks.   

Hey,There is one blog on support.safe.com on working with esri shapefile data. There is a scenario and below explained the workspace attached to it.I am not getting how the Shapefile is created in below scenario. The shapefile was already given in the template file.Below is the link of the article - https://support.safe.com/hc/en-us/articles/25407430413837-Tutorial-Getting-Started-with-FME-DesktopHow the esri shapefile used in the reader is created? Thanks in advance

Hi,I understand that the Raster Expression Evaluator transformer doesn't work properly, only in the new version 2024.2.I would like to know how I can proceed with my workspace, as I want to keep only the raster pixels with values greater than 0.3. How can I solve this? Please find my sample attached: https://drive.google.com/file/d/1Yil9aZj5mkiTQi7lbvDJfFejWKQE4YTl/view?usp=sharing Thank´s

Hi,  I have an excel spread sheet that i have to read and load into a database table. The structure of the excel sheet is different from that on the database. Sample screen shot of the excel spread sheet is seen below. Columns J-S are county names, and the values associated with it are the cost for each county.I need the 10 county column names loaded as values into COUNTY_CD column in the database and its associated county cost value loaded into database column COST_PER_SQFT. So, for every row in the excel spread sheet I will have 10 rows in the database and each row represents data for each county. The database columns and the values to be loaded should like belowI had looked into several post that does transpose of columns, pivot tables etc, but I couldn’t find a solution that works for me. Any help is much appreciated!  Thank you,lsugumar.

So, in the context of pipelines we run camera inspections registering different damages and features along the pipeline. We have registered pipelines by ID in a larger gis database. I already have a script running that reads the information and returns all the registerd freatures in the camera inspections and draws it in a arcgis. The issue is that sometimes the lines have bends even with the same ID. making it hard to create new points at the specified distance. So what i need is something that creates a point at a specific length from the starting point ID, that takes into account the geometric changes of the line.   in the example picture under, i want to draw a point at the POI. I have the distance(70m) from start. But there does not seem to be obvious functionality for this in FME. Any ideas?   

Hi!Is it possible to create (writers etc)  a Data Pump Script (DPS) file for store in Oracle in FME Form ?

Hi folks, I think this very useful article on the WorkspaceRunner could use some love:https://knowledge.safe.com/articles/1469/batch-processing-using-the-workspacerunner-1.html"Article created with FME Desktop 2013"I believe FME has evolved somewhat since those screenshots were made :-)