Transformers

Hey.I need to count the number of characters in all text fields of my dataset.Any simple way to do this to avoid using multiple StringLengthCalculator ?

Searched for possible solutions here, but nothing yet. Have : col0 col1 col2 col3 col4 Region A BU02851 BU02852 BU02853 BU02854 Region Value A 50 55 40 10 Region Value B 7 11 4 15 Region Value C 60 70 10 25  Need : Region A Region Value C       BU02851 60       BU02852 70       BU02853 10       BU02854 25

Hello,I have two questions about the HorizontalAngleCalculator transformer. 1) I simply need the AutoCAD Angle property of a line as shown below. Is HorizontalAngleCalculator the best transformer to use?  Or, better yet...is there a way to expose this property in the reader?2)  The install message for the HorizontalAngleCalculator says it’s not not created by Safe Software, but rather by “safe-lab” implying Safe Software Lab which is kind of confusing. Can someone clarify what this means and whether the transformer is trust worthy?Thank you,Tyler

Hello,I am trying to create a workflow in order to transform a dwg to a cityGML file and later to import it into a 3D citygml database.I have tried to find an example online doing something similar but I had no luck.I wanted to ask if something like this is possible with FME and if there is an available example to get a first impression of how to implement it.

I have an FME workspace that sends me an email during certain error conditions. This works great on my remote laptop, but fails on my onsite desktop machine. The FME workspace needs to be run nightly on my desktop machine. This means that I won’t get the email (and won’t be notified of the error conditions). On my desktop machine, I get this error message: ERROR_DURING_PROCESSING<class 'requests.exceptions.SSLError'>: HTTPSConnectionPool(host='graph.microsoft.com', port=443): Max retries exceeded with url: /v1.0/me/sendMail (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1000)'))) The only difference I can think of is that my laptop use a VPN connection and my desktop machine is on the company network. I contacted someone in our IT department and they want to know the name of the certificate which I don’t know.Does anyone have ideas on how to r

Hi Community,I have a workspace with some python in to create a container within a blob storage account (something the blob storage connector was not able to do). The problem i’m having is that as soon as i use the blob storage connector in my workspace the package is installed in C:\Users\%username%\AppData\Roaming\Safe Software\FME. This then seems to force FME to use this directory in my python caller. The problem is i’m using newer python packages where BlockBlobService no longer exists and is replaced by BlobServiceClient so they stop working despite being installed as per the instructions for installing python libraries. Does anyone have any suggestions? 

Hi,I am trying to use the RasterObjectDetector for an object detection task using FME Form 2024, but translation fails and I get following error messages:-Library 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' was found but could not be loaded. Ensure that all the dependent modules exist for this library.-Could not load module 'C:\Program Files\FME\plugins/opencv/rasterobjectdetectfactory.dll' : 'The specified module could not be found'-Module 'opencv/rasterobjectdetectfactory' is unavailable for use with this FME editionI downloaded OpenCV 3.4.9 and added the installation location to the system path, as specified in the documentation of the transformer, but it is still not working. Does anyone know how to solve this?Thanks!

I'm using the ESRIReprojector transformer. When converting between NAD83 and NAD27, I get one option for Geographic Transformer. In ArcGIS, I get several options for Geographic Transformer. Is there any way to get the same multiple options in FME without recreating them? Thanks.

In my workbench I download ffs file from azure storage and assign the path in attribute _download_path then try to read the file from the same path using FFS reader but it’s not recognizing the path and in the error even showing wrong name like it’s replacing some characters like it’s considering the wrod gelöst as gelo?st. This word is in my filename.

Hi all, I am trying to convert a AGS File to a standard format to view such as Excel or Shape. I seen something like this online using leapfrog https://www.youtube.com/watch?v=OtyrYsx9teE but struggling to find a simple solution in doing this with FME. Any useful tips would be great.

Hi All,I have created a workflow that reads a few large GIS datasets in vector format across different areas. To avoid reading all the records in the dataset and reduce time I have used the FeatureReader transformer which is connected to the layers and an Area of Interest. The Spatial Filter option is ‘turned on’ as Boundary Boxes OGC-Intersect to read only those records within the Area of Interest. The problem is still takes ages to read,I have got a few FeatureReaders within the workflow and I was thinking to use only one FeatureReader (as all the data comes form the same GDB) to improve the performance, Any ideas to improve the performance of the workflow?

I have a SQLExecutor that inserts data child records for contract IDs. It does fine if it’s a one-to-one but if it’s one contract ID with many children, it only inserts one. Nowhere in my workbench does it group by the contract ID though. If there are 2 contracts and each has 2 children, there are 4 individual rows of data to insert. I managed to resolve the issue by adding a select statement after the insert to produce a result. I don’t understand why it’s behaving this way though. Note that I’m using a SQL Executor instead of a writer because of the need to set the audit user for each insert. Below is the sql statement I’m using. Why does the select statement at the end make it work?  FME_SQL_DELIMITER |EXEC sp_set_session_context 'AuditUser', 'SNOW Sync' |INSERT INTO CONTRACT_ASSOCIATE (CONTRACT_ASSOCIATE_ID, BA_ID, CONTRACT_ID, CONTRACT_

How to calculate the IRI between two points in FME if we know the distance and the slope?Thank you.

In FME 2018, I want to use a custom python interpreter, and a specific python virtual environment (conda environments).How can I do this?

Hi!  I am trying to convert an excel spread sheet (no spatial data involved, just plain data) into a pdf file with pagination based on a field in the spread sheet. Can somebody help me through the steps of this conversion? I have seen posts about using table adder, text adder, pdf styler, pdf page formatter etc. but I am trying to understand the high-level steps to start developing this process.I was hoping SAFE would have some webinar or tutorial on simple excel to pdf conversion, all I can find is extracting data from pdf and converting to excel.Any help is much appreciated.Thank you,LSugumar.

Hi,if a similar issue has already appeared on the forum, please redirect me.I'm trying to generate an automatic report in HtmlReportGenerator. I mainly use CustomHTML to prepare the exact shape of the data table. When I manually create a table and fill it with values from the flow, I have no values in output (the table displays empty records). What am I doing wrong?for example:     <tr>         <td>1</td>         <td><a href="https://geoportal.gov.pl">INDICATIVE LRT/BRT VARIANTS (SR CPK, SFP MODEL)</td>         <td>DATE</td>         <td>@Value(INDICATIVE_VARIANTS)</td>         <td>@Value(INDICATIVE_VARIANTS2)</td>         <td>NON</td>     </tr>

Hi, I'm looking for a list of special characters used in a text editor. Is there a description of their function? Are there any others available that are not listed in the window? For example, I use the MSWordStyler transformerThanksFilip

Is there a possibility to schedule the workbench on our local system rather than putting it on the server due to data confidentiality issues?

Hello,I have some data which shows if an event occured per month. Events 202301 202302 202303 202304 202305 202306 a 1 1 0 0 1 1 b 1 1 1 1 0 0 c 0 0 0 1 1 1 d 1 0 1 0 1 0  I want to count the events which occurred 3 or more times consecutively. So I want to get thisEvents More than 3 consecutive events?

Hi there, If I have been given a TIN and a point cloud, how can I find out which points are above the surface and which are below, without rasterizing the surface to retain maximum surface fidelity.Thanks,Marc

Hello,I am trying to transform a point cloud with ellipsoidal heights into orthomethic heights (DHHN2016) using the CsmapReprojector. The settings can be seen in the image. For the Geoid Height Grid I need a file in .gdc format. My target system is DHHN2016, for which I have the quasigeoid in various file formats (e.g. JPG, TIFF, GEM, TXT, GSF, GFF, GGF) but not in .gdc. Is there a website from which I can download the appropriate format or another way?Thank you very much.Translated with DeepL.com (free version)

Geometry type "CompoundCurve"Because of the given schemas the postgis writer has problems with the geometry "CompoundCurve". I want to convert this in the process into a normal line element, which can be read in the osm_line table with the geometry "linestring". Today my process in the Workbench crashes with an element with the geometry "CompoundCurve". Geometry type "Curvepolygon"The second problem is the geometry type "Curvepolygon". This is written correctly into the postgis table osm_polygon. But then I have to delete these objects manually in pg_admin, so that the generated data can be read by the application software. Is there a possibility in FME to convert the elements with the geometry type "Curvepolygon" into a normal polygon? With best thanks for your support! Erido

The PDF-reader seems to have disappeared from FME Form 2024 for Mac (silicon). It worked fine in the 2023 version. I took a look at the writer, and there is no dot under Read there either. Has this reader been removed for some reason? Or is this a bugg?  

Hi there,I have a small project where I've performed a join between two tables (Table1 and Table2) using the CityName field as a common identifier.However, I've noticed some minor inconsistencies in the city names between the two tables, resulting in 10 unjoined features.Is there a transformer or method available to manually specify that the X row from Table1 should be joined with the Y row from Table2?Regards   

Hi all,I’m using: FME(R) 2024.0.1.0 (20240328 - Build 24202 - WIN64)I do want to know if there is the possibility to use the HttpCaller to launch chunk of requests. My DELETE request: https://xyz.api.here.com/hub/spaces/@Value(space)/features/@Value(xyz_id)each request sends to that Hub the action to delete each Feature by its ID (xyz_id).I need to delete around 4M records, and running the workbench feature by feature, takes days.Is that possible to get it faster? Thanks for you help,Juanma