Transformers

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 att

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 workspacerunn

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 f

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

Suppose you have some kind of JSON as follows:{   "students" : [      {         "id" : "01",         "name" : "Tom",         "lastname" : "Price",         "hobbys" : [ "football", "hockey" ]      },      {         "id" : "02",         "name" : "Nick",         "lastname" : "Thameson",         "hobbys" : [ "reading", "gardening", "painting" ]      }   ]}and I would like to create a list attribute for only some specific content of the JSON. For example, lets say your only interested in only the name and lastname of the students. Then I would like to achieve a result like:students{0}.name = Tomstudents{0}.lastname = Pricestudents{1}.name = Nickstudents{1}.lastname = ThamesonIs there some easy way to achieve that?I am aware of the following transformers that can extract JSON data:JSONExtr

Greetings,I have a MS Excel Spreadsheet hosted in MS OneDive. Upon opening the spreadsheet, a MicroStrategy report runs via an Excel Plugin (it takes abut 5 minutes to finish) and refreshes the content of the spreadsheet. Once the spreadsheet's contents are refreshed, I would like to save the changes and close the spreadsheet.I do not think the Excel feature reader will work, as the act of opening the spreadsheet its self is what triggers the report. We cannot use the SystemCaller transformer to call the cmd prompt start function, as the file resides OneDrive. Even if we could get that to work, we would still have to save and close the spreadsheet.Ultimately, I would like to upload this workspace to FME server and have it run every morning.Any help would be appreciated.

Hi there, I'm struggling to build a proper GeoJSON file. Attached please find the source XML file which I'm trying to convert. These are all points and I would like to have the different fields as properties. I tried to aggregate the separate "latitude" and "longitude" attributes into a single "Coordinates" attribute by means of the AttributeManager but that didn't do the job. My "Coordinates" are always read as a feature property and not as a feature geometry. GeoJSON has a specific format ( see https://geojson.org/ ) and I don't know how to construct it with FME.  Of course, I'm using the XML Reader (Parameter set to: modu/moduEntity) and GeoJSON Writer. Any help would be much appreciated.Thanks in advance already.

I have a number of GPS tracking records that contain straight line segments i.e. noise arisen from loss of signal. I would like to remove lines > 1 km to improve visualising the data. The workbench would need to:Find straight line segments within each dataset > 1kmBreak/Split the line on the vertexDelete the line > 1kmThe lines that have been split at either end can remain as they are i.e. do not need to be merged or joined Please can someone briefly describe the workflow that I would need to create to achieve this?

I have a workspace that extracts users and attributes from Active Directory, at the OU level. I want to take this workspace and create a custom transformer as part of a larger workflow. Last time I copied these LDAP readers it completely broke everything and I had to fix them one-by-one. Is there any way to import a workspace as a custom transformer? This is just reading a bunch of LDAP data and spitting out a CSV. *Edited to reflect I'm trying to export/reuse connections, rather than transformers.