Transformers

Hi; I installed the FME Plug-in SDK for C ++. When compiling the sample solution, 2 files are missing. "fmeplugincapabilities.h" and "ipipe.h". Where are these files located?

Hi, is there a way to find the last OBJECTID in an ESRI FileGeoDatabase and return it? I can do this using SQLCreator > VariableSetter > VariableRetriever > Counter transformers for an Oracle Spatial Database but a FileGeoDatabase is not listed in the Reader Gallery within SQLCreator transformer. My knowledge of FME is pretty basic and would appreciate a 'how to' (if it's possible). Thank you

How to create a Polyline shapefile from CSV/excel data

I would like to know what would be the simplest step to transform the following source:  to the following  

Thank for the support

I have an Excel Reader and several transformers that follow. I would like the attributes to update when I select a new .xlsx file. Most attributes should be the same but on occasion a file is submitted with one of the column names a little bit different. I was hoping that I would just have to re-connect those. What I have been experiencing is that I have to Update the Reader and then my AttributeManager transformers have to be completely rebuilt. Example:First Run - Fieldnames are CITY, STATE, ZIPSecond Run - Fieldnames are MY CITY, STATE, ZIPCODE Is there an easy way to handle this?

I have been tasked with reviewing another person's FME workbench, which contains a Python start-up script. When I try and run this script (from a PythonCaller transformer) I am receiving the following error i.e. Python Exception <ModuleNotFoundError>: No module named 'fmeutilities' andERROR |Error executing string `#global scope variable definitions / initialisations. The script is trying to import the modules 'fmeutilities' and 'fmeoutput' amongst others, which cannot be found on the server that the workbench is running on. I'm not sure if these need to be added via a localised install of Python or not? I can find an fmeobjects module on my server i.e. in the C:\\Program Files\\FME\\fmeobjects\\python37 folder) but non of the other modules the script is trying to import. I am using FME Desktop v2021.1 and the workspace python compatibility setting is set to Python 2.7 and 3 (see attached screenshots for more information). If someone can assist and

I've played around in Python in an ArcGIS Pro Notebook and like to take that code into FME. Because of organizational reasons, I might not be able to import the modules I need. Is there a way to make the profiles with other transformers? or some other way in Python, maybe?Attached is the code I use in ArcGIS and the testdata used there. Further attached is an example of the profile.  The data is organized in drill cores consisting of multiple layers, the thickness is indicated with Laagdikte [mm], the sample data has 3 drill core with 6 layers each.  Any kind of help would be greatly appreciated! Thanks! Linda

I want this feature set to be processed per tracknumber. So first all the features with tracknumer 1 (2 features), then with tracknumer 2 (3 features), then trackunmer 3 (2 features).From each subset only one feature has to be selected, based on 2 rulesif all features have 'yes' in their decision attributes, select the one with the most recent dateif one of the features in the subset has a 'no' in one of the decision attributes, select (one of) the no fields, doesn't matter which one.The resulting featureset is seen in knipsel1.png I have tested a Matcher , but then I am stuck more or less. I put the subsets in a list in the Singlematch output port. If I use a Listexploder, I get all the features back in one set. I want to take each feature of the singlematch output port and process the Listelements in a seperate process (in a workspacerunner), but how do I feed one feature (with a list) to the workspacerunner?Other lines of thought are an Inlinequerier attached to

I have some strange behaviour with a Tester on a FME Server Parameter.In a workspace designed to run on server I test if $(FME_ENGINE) has a value. When this passes it initiates a subsection which I don't want to run when I develop the workspace locally.This worked fine in server 2016 but it fails in server 2019. Could reproduce this in a fresh 2019 workbench.FME server log returns:Tester (TestFactory): Tested 1 input feature(s) -- 0 feature(s) passed and 1 feature(s) failedIs this ment to work this way?

How can I convert a sketchup lod4 building model in cityGML format

This seems like a pretty basic question to ask but something we haven't encountered yet with FME Desktop. If we have two datasets and I only want to do a one way synchronization of the attribute values from a new polygon layer to an old polygon layer. How do I do that? I don't want to overwrite the geometry features in the old layer, but I do want to "calculate" the new attribute values over to the new layer. Will just changing the geometry in the writer dialog box from polygon to no_geom and selecting "UPDATE" as writer mode do the trick? It doesn't seem like it would be that simple.

The photo's has a border. I plan to crop these out after the scanning procedure. Any idea how to get this job done ?

Hello, I'm new to FME and want to work out which transformers can be used for this task. I need to query a text field held in a CSV file against a list of values (text) stored in a separate CSV. If these values are present I would like to add a value of '1' to a new field in the CSV. I'm sure this is very basic but would be grateful for any assistance!Chris

I am creating PDF documents with a series of responses, so I first create a multi-line attribute then I pass that through the PDFPageFormatter and onto a PDF writer. The problem is some of the responses run off the page. I am needing to restrict the width of the multi-line attribute using something like a word-wrap function. Any ideas?

I have a *DWG file. I want to convert it to GeoTIFF. I used tool from link: https://hub.safe.com/publishers/safe-lab/templates/converting-vector-data-to-raster#description. Even though it exports successfully, I don't see the GeoTIFF output.What step am I doing wrong?Please tell me. Thanks

I'm trying to use snapper to snap a line and an arc together using their end points, then a line combiner to combine them into 1 straight line. however it doesn't appear to be working. I can cheat and use a straight line instead, but I'd like to know the correct way of doing this, as I'd like to keep the data as accurate as possible. Also, if the door comes out as *untouched* in the snapper, the rest of the process works, however if it snaps to form the half semicircle then the co-ordinate extractor and vertex creator fail to create a line. Can anybody explain this to me?

I've created a new Output Attribute in AttributeManager and I want to populate this based on the results of a (rather lengthy) SQL query. However, the SQL will be looking at attribute values from the reader and not a database, which I think rules out SQLCreator and SQLExecutor.Does anybody have any suggestions as to how I might manage this?

Hi Guys, I have two feature classes in SDE and I want to append featureclass A to featureclass B and do a few additional its like dropping and recreating indexes and setting a value on newly appended data.I have this working but very very slowly, so i assume I have taken the wrong approach. ?I have an ESRI SDE r eader, connected to the fetaureclass A, and sets max features to read per feature type 3000000, I have Sql to run before read- which sets an attribute with date and time of now so I can track the records later.I then use coordinate setter and attribut manager and connect to a ESRI SDE writer, I have set this on Transact mode with 0 Transaction Number and 100000 Transaction and Features Per Transaction to be 100000 and Commit at end of Write to be NO . I drop indexes in Sql Before write and recreate them afer write .. potentially for faster loading. It is incredibly slow - around 100000 feature every half hour. (2.4 million rows to process) I can only assume this is not the way

Hi all,I have a Folder containing a series of CSV files with identical schema. I have created a Directory/Path reader to identify those CSV files. I have an attribute exposer to identify the identical schema from those CSV files. How can I pass the values of the respective attributes to my next transformer in my workbench?

Good morningI am using FME Desktop 2017 and have received this error when trying to write shapefiles using a workbench that was created in an earlier desktop version. The specific workbench runs on FME 32 bit as we are reading from an Access Database

Dear everyone, I have a workbench which we is using for data download purpose. This workbench is connected with an enterprise gdb (sql server) and reading feature classes and tables and we are downloading data in different format in need basis. So far, through "Published Parameter" we have been successfully downloaded data in csv2, XLSXW, GEODATABASE_FILE formats without doing any programming but when I added "TEXTLINE" writer format in Published Parameter then the download result is producing an empty text file. Please someone help me out from this problem. Thanking you With kinds RegardsMuqit

Hi, is it possible to control the table creation parameter from features when using a database writer? Like one can control the feature creation, removal or updating using an attribute fme_db_operation on the feature. I'm looking for some parameter fme_db_table_handling or so, but it does not seem to be documented?

I am using the Data Interoperability extension. I created 2 spatial ETL tools and added each to a model. When run manually, the tools and models run just fine but when I put them in a python script using the syntax referenced here: https://support.esri.com/en/technical-article/000012387 , I get this "Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instability" which I see that others have had in the past but typically using FME Server. Disabling log files and parallel processing are not really applicable to data interop or my workflow (which is what other's have done to resolve the warning). Can someone help me figure out how to destroy my FME Session using python? Thanks! -Tiffany

From the first image, you can see the selected object has 6 chairs, which is decided by the number of the visibility. But after translated it into MapInfo, all the options of the visibility (3,4,5,6,7,8) have been translated and overlapped each other. I want the number of chair on each object displayed on MapInfo are the same as displayed on CAD file. Anywhere I can adjust apart from Explode Blocks on FME? Help please! Thank you!!