Transformers

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

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:JSONExtractorJSONFlattenerJSONFragmenter However, for the JSONExtractor I'm only familiar with the possibility to create attributes for (single) JSON objects or a specific JSON array element. Is there maybe some op

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.