FME Form

We recently moved some processes from Esri tools into FME. One of these has a slope calculation component. We expected to see minor differences between Esri/FME but instead we are seeing differences of up to 15 degrees difference.Further investigation showed that by default, Esri uses a planar based algorithm. FME (and QGIS) only use a geodesic based algorithm. Esri does also have the option of using geodesic. The original Esri process was using the default planar algorithm. When these are compared to the geodesic outputs (FME, Esri and QGIS) considerable differences are apparent. Comparing the three different geodesic outputs shows that the results are (almost) the same – as expected.This difference has considerable ramifications for the application using these slope values. Looking at Esri documentation, it does state the geodesic is ‘more accurate’, but this doesn’t explain the 15 degree differences we’re seeing.We have raised this question with Esri, but are wondering if anyone her

I want to create a workspace that checks input data for various criteria. For example: are there polygons smaller than a certain threshold. Ideally I would like an output in a textfile/PDF, that says "2 features have an area below X". I can calculate the area of the feautres and with a Test_Filter I can redirect the features not passing. What is the FME way to extract the count of those features and write it with a meaningful message to a report?

Dear community, I am fully out of ideas - we cannot successfully establish a sharepoint connection in order to make the List Reader work. I guess we tried everything and we followed the instruction here and the video here to the detail. The only thing that is really working - and that requires a super user with all possible admin rights - is the first option to replace the [TENANT] in the web service definition:The multitenant app our admins created for me comes along with all the rights as per tutorial - but no matter if I try the multitenant or the singletenant way of connecting, I always get this prompt which is basically telling that admin approval is necessary in order to access the resources of my organization:When we magically made it happen that the url got successfully tested (by simplifying the request URL) I am ending up with something like this when adding the SP List reader:Our local support at axmann.at cannot assist as well since this lies somewhere in the domain of admi

Goal: I am trying to standardize the raw CSV files. The output file columns should look like below.Date Time Level Temperature ElevationBackground Info: Each file might have multiple tabs. I need to only process the sheets that named as 20* (2011-2012-2019-2020 etc). Sometimes there is header information in A column in some of the sheets. Thus the table header starts at different row number.Issue: I am using FeatureReader to detect the schema dynamically. If the table starts with header information, the transformer reads the data as a new table. Thus it creates new column names which turns into a larger issue.Normally there are over 200 files with multiple tabs but I've prepared a sample data and included my workbench. Looking for help.

I'd like to combine headers from 2 lines in Excel to form 1 attribute name.Should result in feature with attributes ID, AAA_XXX and BBB_YYYI've looked at debbiatsafe solution at Bulk Rename Attributes with Original Name plus the First Row (safe.com) but that doesn't do it all the way.Need to have the features with the attribute names to continue working with in the workspace.Any hints on how to proceed? 

When I try to run the AWS DynamoDB reader in FME desktop i Get the error.ERROR |com.amazonaws.SdkClientException: Unable to execute HTTP request: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target I tried following what this question says:https://community.safe.com/s/question/0D54Q000080hbz0SAA/httpcallser-ca-certificate?t=1647334797980 Connecting to dynamo DB using same credentials using CMD workes fine and uploading Workspace to FME Server also runs fine. Only problem is on local Desktop version 2021.2. I have tried to add the certificate to Windows Certificate Store but no luck. Any ide what might help?

Hello everyone, I'm new to FME and i'm using FME desktop. I would like to know if it is possible run my workbench automatically without clicking the run button in fme?  Thanks in advance.Best regards, Gentjan

I have the same issue identified within this question but whilst using the PostGIS Raster transformer (https://community.safe.com/s/question/0D54Q00008p86kRSAQ/postgis-loading-default-values-being-overwritten-by-nulls-in-feature-writer) As suggested in the answer I downloaded the most recent Beta (FME(R) 2022.0.0.0 (20220323 - Build 22311 - WIN64) ) and gave it another try. Unfortunatley I still get an error when trying to write to my PostGIS raster table. The issue seems to be related to the columns with default values I am not trying to write to. FME seems to be attempting to write nulls to these columns.  Is the Advanced > Missing Attribute Behaviour functionality also going to be included within the raster writer or another way around this? Error message from log:  2022-03-29 09:36:45| 1.6| 0.0|ERROR |Bulk copy failed on table 'prime_data.paleodem' using delimiter ':'. Error was 'ERROR: null value in column "changedetect_date" of relation "pale

I'm working on a script someone else wrote. Is this stored SQL procedure going to be executed for once for each incoming feature, or once on the collection of features?  

Since we use FME 2021.2 I get many failed objects with the geometry validator, while with fme 2020 it did not yield any failed objects. Is there a substantial difference in the geometry validator between the 2020 and 2021 version?

Hi, I have a workspace that truncates an SDE geometry table and refills it. The workspace runs daily and sometimes there are no records to write. In that case the writer only has to truncate the table. I don't see an option truncate first or anything like that in a sde writer.How can I truncate a table while the writer is empty?  

Hi, I'am creating a citygml model (lod2) based on roof and ground with the help of BRepSolidBoundaryCreator.Now I have definded lod2MultiSurface as citygml_lod_name!I need in addition to lod2MultiSurfaces a lod2Solid Geometry for each building like this:<bldg:lod2Solid><gml:Solid gml:id="UUID_93353a82-d426-4090-8aa5-d852bcad8f35" srsDimension="3"><gml:exterior><gml:CompositeSurface gml:id="UUID_2a60da73-2d26-4f2a-a623-b9acc31661e2"><gml:surfaceMember><gml:Polygon gml:id="UUID_bf94ba8a-c9b1-41e3-b4a4-9f932cfc358f"><gml:exterior><gml:LinearRing gml:id="UUID_b8b135e2-705d-4255-8b2c-63b8558eaec6"><gml:posList>603363.9649999999 5792993.036 80.696 603363.8160000006 5793003.66 80.696 603357.9249999998 5792998.265 81.57 603363.9649999999 5792993.036 80.696</gml:posList></gml:LinearRing></gml:exterior></gml:Polygon></gml:surfaceMember><gml:surfaceMember><gml:Polygon gml:id="UUID_284c30a5-944c-4222-9ef0-

I have a very simple workbench that is taking a MapInfo file, reprojects it and sends it to an ArcSDE database in Oracle. For some of the MapInfo files it works fine but others only the objectid and shape attributes come across. The writer, drops and creates the table but does not create all fields in some cases.  Does anyone have any ideas why this might be the case? Regards Dean

hello,Is there a way of extracting data(maybe from loG) about start and end of workspace execution, as long as errors (if there are any?), in order to insert them in a table? thx,Nicu 

I am working on a script that uses the OpenIfcShell library to create IFC files as a workaround for the IFCWriter's gap in functionality.  So far so good:  I can create the basics of an IFC file using one feature.  Now the challenge is to scale up with a dataset that has many features and feature types.  Here is the code I have so far:import fmeimport fmeobjectsimport uuidimport timeimport calendarimport tempfileimport ifcopenshell class FeatureProcessor(object):     def __init__(self):        pass     def input(self, feature):                # Create FME Log File object name called logger        logger = fmeobjects.FMELogFile()         # Call logMessageString method to add custom text and set WARN severity level        logger.logMessageString("Testing the mud",1)                        ifc = ifcopenshell.file(schema='IFC4')                O = ifc.create_entity('IfcCartesianPoint', (0., 0., 0.))        X = ifc.create_entity('IfcDirection', (1., 0., 0.))        Y = ifc.create_entity('If

When I load my excel file I want the Day attribute to be read as type char so I can split it with string functions (Left/Right). The problem I have is that FME insists on reading the attribute as a 64bit real. I have tried removing the reader, purging the temporary files, saving the workspace, closing FME, and then add the reader again. But I keep having the same result. Are there any suggestions or is this standard for the Exel reader?

In my case, I have JSON object that contains table and it values in array. I am trying to extract each table object from JSON and insert it features(columns) array values into postgresql table based on table name. The json structure will change every time and it is dynamic. Input:{  {    "table": "Table1",    "key": "2343",    "features": [      {        "status": "Finished",        "id": "1234",        "kind": "Unknown",        "project_name": "XXXXXX"      }    ]  }  {    "table": "Table2",    "key": "2667190",    "features": [      {        "column1": "test",        "column2": "A",        "status": "Unknown",        }    ]  },} Expected output:

My database is >13.000 points from 6 different vessels. I need to create lines for each day, for each vessel. The lines have to be created in chronological order. I'm trying to group the dates after sorting, for then build the line using both datetime and vessel name parameters. I have converted date time format (ex 20210415165357, which is YYYYMMDDHHMMmm) to 2021-04-15 (YYYY-MM-DD). Any ideas how to solve this?

My workflow reads an SDE, carries out some transformations, and then writes to .xlsx using a feature writer and a template file. When I open the excel file and sort columns the sort function works the first few times but then it begins to only sort certain columns leading to mismatched data in the document. There doesn't seem to be any pattern as to which rows sort and which don't. Sometimes it is only the ObjectID column which will sort.

FME Desktop 2022 Build 22304: How to get an esri feature class generated in case the number of passed filtered features are zero (no features are filtered)? For example, in the screenshot below, no passed features are filtered as an output for the tester transformer. How to get this result reported in an esri feature class stored in file geodatabase? Currently, no feature class is generated in case no features are filtered    

Hi All, I'm try to find the best way to analyse the begin and end of line and check if this line is connected in the both vertices ( begin and end ). As you can see in image bellow, the line number 3 is connected in the begin and end of the line.And the others line are not.A DGN file is attached. Thanks in Advance,Danilo

Hi, I have a problem extracting data from my text file.The file looks like this:******************************************#Textlimiter=;#Decimalsign=.#ProvadmColumn1, Column2...ColumnX;"Value1";"Value2"...""ValueX";"Value3";""Value4"..."ValueY";#ProvdatColumnA, ColumnB...ColumnZ;"ValueXX","ValueYY"..."Value11";"ValueQQ","ValueRR"..."Value22";#End******************************The ProvAdm-section can contain one or more rowsThe ProvDat section can also conrtain one or more rows I want to read ProvAdm section into one table (SQL Server) and ProvDat into one table (SQL Server) but I dont reaaly understand how to find out where ProvAdm section ends (how many rows should be read) or where ProvData starts (where should I start reading) An additional dimension to the problem is that I need to read multiple files at one go... Perhaps my explanation is not complete b

 Hi !I'm having a problem while writing into a template file, see image of log error. In fact, out of about 20 translations, there is one with this problem arising while writing data. Can someone tell me if it's a bug with FME or about my parameters ? I doubt the problem with my parameters, because very often it works well while wring the Excel file.Please help ! Thank you.

Hi, I have lengths for two different types of cable and i need to see the difference and generate report. Calculating values using excel formula in a column. The formula returns TRUE and FALSE values in CSV output. I want to manipulate more to filter out TRUE and FALSE values and outputted as a separate CSV file. Its seems like difficult to do as my column in FME look like this: I would appreciate any help and suggestion to accomplish this task! Thank you,

I have some texts that I have read from DGN format ,texts are colored.I would like to aggregate the texts and be as one together .i have found that the colors converted to black and white .so my question , how could I aggregate the texts and still has the original color . Thanks in advance FME 2018