Transformers

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.

I'm making a custom transformer and the users will select multiple choices from a published parameter list that contains a value with text that includes a parsable field name with other info. I've been working to parse that out into a comma delimited attribute, which I now have. In my reading of other questions surrounding this, it seems like this is not possible with truly dynamic transformers/workspaces, but in my case I have a known list of the names. What is the best way to expose attributes that are known in this way in a custom transformer or in general?Thanks!

Hello all. I'm trying to determine the best way to read the schema of an SDE geodatabase. My end goal is to read each table/feature class' attributes and properties (name, data type, length/precision) from a File Geodatabase and compare them to tables/feature classes from an SDE geodatabase. Most are the same but can differ slightly for a quarterly data load of 300+ tables/feature classes. I've managed to use the Schema (Any Format) Reader for the File Geodatabase, but if I use the same reader on the SDE geodatabase, it gives me an error: "An error occurred while attempting to retrieve the connection parameters from the connection file ''". It sort of looks like it can't find the connection file, even though a working .sde connection file is in the "Source Dataset" parameter, and there aren't many other parameter options available. Does anyone have thoughts on how to configure the Schema (Any Format) Reader

I have an idea of how I would write this in Python but being new to FME not quiet sure where I start here with the transformations.. For example: the Column will have an A, B, or C. If the column for any row has a "C" I want to to delete this full row. While it seems simple enough Python I'm not quite sure where to start with FME. Any help or helpful tips to point me in the right direction that would be great.

I am implementing a custom reprojector plugin which needs to access a parameter or attribute that an earlier transformer has created.  I am writing the plugin using the C++ SDK, but am having difficulty seeing how to access this information from the ReprojectEngineManager class to use it. Any tips to how to do this are appreciated!

Hi, I have a CSV file with 20 spatial points & I was able to convert the points into a line (using LineBuilder) but the line which is created is having a single feature to it. I have used Chopper Transformer to cut the line. It does the job for cutting the lines but all features get same as the first one feature.How I can separate the feature as well with the lines Please Help ..!

Hi,I've got a text file that has dates as parameters for a data pull that I would like to add to the actual data that was pulled after it has been manipulated to have only the items we are interested in.In this case, start and end dates for the ranges. I want to add those to two columns in the data that is being updated/appended to in an EGDB.I thought maybe global variables, but they can be SO finicky. Is there another way to attach these dates to each row in the table as it is being updated/appended?Thanks,Lorinda

Creating reader for format: GeoTIFF (Geo-referenced Tagged Image File Format)Trying to find a DYNAMIC plugin for reader named `GEOTIFF'Loaded module 'GEOTIFF' from file 'C:\\Program Files\\FME_2018\\plugins/gdal/GDAL.dll'FME API version of module 'GEOTIFF' matches current internal version (3.8 20180604)GEOTIFF reader: Opening file '//client/F$/DEM_LIDAR_2012-2020_1m/citywide/DEM_LIDAR_2012-2020_1m_citywide.tif'GEOTIFF reader: TIFFFetchDirectory://client/F$/DEM_LIDAR_2012-2020_1m/citywide/DEM_LIDAR_2012-2020_1m_citywide.tif: Can not read TIFF directory countGEOTIFF reader: TIFFReadDirectory:Failed to read directory at offset 8081121040GEOTIFF reader: Failed to open the dataset '//client/F$/DEM_LIDAR_2012-2020_1m/citywide/DEM_LIDAR_2012-2020_1m_citywide.tif'. Please ensure source data is valid and correct reader is selectedA fatal error has occurred. Check the logfile above for details

Add one field with values from existing attribute table to another existing attribute table. Can any one help me with this problem.

I have workbenchs published to FME server that lets an end user upload a file (KML, SHP, DWG, TAB) that will convert to (KML, SHP, DWG, TAB) plus re-project if the output coordinate is set.If the input file has a coordinate system everything works fine, but if a uploaded file is missing a coordinate system the workbench fails and the end user doesn't know why as they can't see the error logs.This is where I had the idea to give them a txt file saying, add an Input coordinate system. I don't want to make the input coordinate system required as the end user might not know or might enter it incorrectly (I'm trying to make it idiot proof as much as possible 😀 ). Now comes my issue. How do I test for all three conditions; Has coordinates = Converts dataHas no coordinates = Txt FileHas coordinates and no coordinates = Converts data and doesn't send txt file.So far I can only do the first two. There is possibly a

Sample figure shows the 36 points within a MAIN Polygon (purple color). Each have its respective the data point value and summing up comes to 666. With the sub-polygon it crosses these points and have its own total of the data points within it. Need to take of the sum of the sub-polygon from the overall total (main polygon - 666) and get the % of each result with respect to overall total of main polygon. See table

Hi, I am trying to merge two datasets, one being the primary dataset that has Levels and the second dataset that has Zones. Each level has all the zones associated to that the level. I would like to achieve a dataset that displays this merged dataset. I have created a small sample of the actual larger dataset below. I think the solution involves some sort of list handling but I have tried out several list transformers but so far haven’t been successful, I would like the desired outcome in columns as shown above and not in rows as I think can be achieved by exploding attributes. If this cannot be achieved using transformers, I am happy to use a python script inside the pythoncaller if someone doesn’t mind sharing a script. Appreciate any advice either way.  Thanks in advance.

I have a workbench which has a complex custom transformer added in which a python caller is present. I wanted to check what is happening in that python caller so I used some print statements. But I cannot find those print statements in logs that is being generated. How to get the log of a custom transformer in FME Desktop 2019.