Transformers

I have an an attribute in my table that is type 'string', and I am trying to work out how to associate a code to each of these different attribute types so this code can be used in the next transformer. See screenshot, for example I have added red text, so for POTHOLES, I need to feed the integer 70 into my HTTP caller, for SEAL OVERLAY I need to use the code 105 in my HTTP caller and so on... I am unsure how to set these codes for each of my unique values. I was about to create a new HTTP caller for each of my different attributes and hard code the variable, but I know that would be a terrible idea as I should be able to code this better.  Have I explained this well enough to understand? I'm having a hard time describing it! 

I'm new to FME and I've found a couple different coordinate systems that will produce different results. Primarily I will use Reprojection to US48-DUKE before any of these tools but I'm not sure what the community would say and maybe have a better answer? Thanks!

I am trying to ETL an LRS-enabled routes layer currently stored in a Geomedia database into a ESRI format that is consistent with typical LRS operations like dynamic segmentation.  The issue is that the fundamental data models that handle measure values within a calibrated route network are different in the two software packages.  In Geomedia, routes are segmented into a series of features (or rows), all of which share a common routeID, and all of which have (as exposed attributes) begin_measure and end_measure. Unlike in the ESRI world, the measure values are not stored in the vertices but in the attributes.  Question is... how do I use FME to efficiently move measure values from attributes of lines in Geomedia data into m values within vertices of lines in ArcGIS data?  Thanks in advance... Adam

Hello, How can I utilize a User Parameter in the SQL To Run After Write? I have a User Parameter (Text Value) with a default value of parcels@DateTimeFormat(@DateTimeNow(),%Y%m%d)  The parameter works when setting the table name for the new table in the DB and the table is properly created: But when the user parameter is used in the SQL To Run After Write, it causes an error. Is that because the value of the User Parameter contains formatters? This line in the SQL:UPDATE '$(ImportTableName)'(I've tried with and without the quotes surrounding the parameter, btw) evaluates to this in the console (and the SQL):UPDATE 'parcels@DateTimeFormat(@D

Hi, I have a ground geometry like this:So this is an aggregate feature, based on faces! Now I will resolve this into a polygon like this: it is not working with Aggregation based on building_id of the buildings! Than I have an aggregate feature like in the first picture  Is this kind of transformation possible? 

Dear Community, I want to read few CCTV inspection reports for pipe inspection which contains details about City, asset number, Inspection info from CCTV report, pipe information from CCTV inspection, defect information etc. in different line. I want to read this pdf in FME and convert those details in the table format. May I have a detail tutorial to understand ...how we can do this process in FME? 

I'm parameterizing the first portion of a dataset path name inside a feature writer dataset parameter to allow easier transition from our development environment to production. I've created the following published parameter.The published parameter's Configuration parameter is set to display name = 'dev', value = ""//myhost.org/Scheduled on FME Server/DEV/dev_start_stop_report_data/"" When the dataset parameter in the feature writer transformer is set as shown below, the writer is unable to find the directory. The error below is returned$(report_data_path)sa_output\start_stop_report.xlsxERROR |Excel Writer: Failed to save changes to the spreadsheet '""\myhost.org\Scheduled on FME\Server\dev_start_stop_report_data\""sa_output\start_stop_report_.xlsx'. Check that you have write p

FME Desktop 2022 Build 22311: The “issue locations” generated from the “geometry validator” fails to be written in an esri feature class, As per the screenshot, the “issue locations” generated from the “geometry validator” fails to be written in an esri feature class What could be the issue here? The data is attached      

I'm trying to read raster data from postGIS using the 'PostGIS Raster' FeatureReader and keep getting an error about band metadata. However, I can load in the same raster data OK via a select statement in a SQLExecutor transformer. The rasters in question only have one band, but I don't imagine that should be an issue.  As the data returned via the SQLExecutor look fine, I'm assuming that there is nothing wrong with the data in postGIS, but the error is making me question that... The error I'm getting is;2022-03-30 15:46:00|  0.2| 0.0|ERROR |Error executing SQL command  ('SELECT ST_BandMetaData("rast",1), to_char(ST_BandNoDataValue("rast",1),'9.9999999999999999EEEE') FROM "schema"."table" WHERE "pk_index" = '1'') :'ERROR: table-function protocol for value-per-call mode was not followed CON

Hello, I would like to ask about converting a vegetation model from .skp to Citygml, but in the end it cannot be displayed in layers like buildings, do I need to set an extended ADE, I tried to select the feature type output of buildings such as wall surface, but Can not output successfully. What I want to ask is how to output a CITYGML vegetation model that can be displayed in layers

I have a polygon and I want to know the angle α  , β  , γ of each line.With the PointPropertyExtractor I get the Eula Angle if I set it beforehand with the PointPropertySetter and then rotate the object.Is there a possibility to find the angular inclination of the line to α , β , γ differently? PolylineAnalyzer, HorizontalAngle and TopologyBuilder have not helped me so far.   

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,

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 ad

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? 

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

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'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:Pol

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')

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": &

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?

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 st

 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.