Transformers

I have some obj files of building and I want to add different locations to each obj file .please help me to get the way to do it.

I have 50+ tables i want to setup a migration jobb for between MSSQL and PG.Fastest way to set this up is using the "Generate workspace" functionalities. However using this, the table qualifier is set to dbo, default schema for MSSQL . In PG i am not using the same table qualifier name though, so I want to set to use X table qualifier for all the table to be written to PG, but it does not look like that is possible? Do i need to set it for each table manually?Same goes for table name. I want to make it lowercase and remove any special characters automatically if possible.

I have a cylinder that I created using a 3D Bufferer around a 3D Line. How can I convert this cylinder into a cuboid ? Thx. The image helps to understand what I mean.

The same geotiff is placed differently in QGIS (3.22) and FME (2022). QGIS is placing it correctly, or at least as intended by the publisher, and shows a cellsize of 2x2m. FME is setting the cellspacing at 0.1x0.1m. Can somebody explain the difference in interpretation? And possibly how to fix it in FME - in general, not via georeferencer?The original file can be accessed here: https://drive.google.com/file/d/1b9Euqly7DPwwYzEvLNqWj1JgxAGbTBqI/view?usp=sharing/Mathias

I have a huge dataset and I want to make writers based on type. Some types have only 1 samples, some have 100, and I would need to remove all empty sample-columns from all writers. There are over 100 types, so manual work is out of question. I have tried to use NullAttributeMapper and set all values to missing, but how to drop them before writer?

I have noticed this crop up in a few different workbenches since upgrading to a new patched version of data interop 2021.1.2.0 (20210903 - Build 21627 - WIN64). The only solution so far is to run/cache the workbench in sections. Have tried re-installing. Plenty of storage available in the temp directory. The fatal error occurs after saving the cache to the temp directory (but not every time): "Saving spatial index into file...""Finished saving spatial index into file...""2022-02-15 20:43:31| 56.5| 0.1|ERROR |A fatal error has occurred. Check the logfile above for details" It should say "Stored ### features(s) to FME feature store file...." instead of the error message. Anyone else encountering this?

This topic has neen discussed before, but im at a loss. I cant understand why, if an attribute exists in a shapefile, its not added to the list of attributes. I can though, see them in the preview, under the list of available columns.The issue comes, when I am trying to validate the attribute, it dosent exist!, I use the attribute exposer, but all the attributes are blank.Please any help appreciated PS: I have found a work around, If I load individual bulk loads for each dataset type (30) I can load all the ATtributes correctly. This is not ideal, as I now have 30 readers instead of one..

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(@DateTimeNow(),%Y%m%d%H%M)'How can I use this parameter in the SQL? Alternatively, how can I utilize a name that is generated at workspace runtime for the table name and subsequently reference it in the SQL?

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 permission to the file, it has no password protection and is not opened by another application. Error message is 'No such file or directory.'There may be a better way to go about it, but I'm attempting to use a str

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 CONTEXT: SQL function "st_bandmetadata" statement 1' Any thoughts or help much appreci

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, but are wondering if anyone her

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

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

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