Transformers

I am in the process of converting a large Excel file to separate JSON documents for each column in the Excel, keeping a common ID column that each JSON document must contain. The hard way of doing things is using an AttributeKeeper to preserve the common ID column that I need and the specific column that I want to make a JSON document for, with a separate writer for each JSON document. Is there an easier way to do this, similar to a Fanout but instead of grouping by rows of similar feature types I can do it by column?

I have several polygons in my workspace and I want to consecutively clip a subset against each other (see attachment). Of course I can do that all manually but if the input changes, then the workspace has to be adapted each time. I thought of using the aggregator to have the features on "first level" with a list of all features of the second level. Next step could be a custom transformer with a loop. Do you have any other suggestions? I am also not to deep into custom transformers and looping, so any advice is welcomed ;-)

I want to make sure that I have the same number of records in each group. What transformer to use? btw I want to preserve each record's attributes values as I want to write the records to a db later on.

Hi Everyone I have come across an ifc file where the Feature Reader does not find all IfcSpaces when reading a file.  Both ifc Viewers DeSite and Solibri manages to read the files, but the Feature reader loads maybe only a third of the objects. My suspicion is that there has been some post editing of the Ifc file by some third party software or created with a plugin EDM? EDM Software:https://jotneit.no/express-data-manager-edm Example of Ifc FileStructurehttps://essxnce.wordpress.com/2019/07/31/190731-searching-how-to-make-ifc-file-from-non-ifc-file/ If someone know how to read there files with success, please give me a shout out! If not, I imagine this needs to become a feature request to be able to read EDM IfcFiles? RegardsFred 

I need to convert dwg to pdf and one of the line styles is "- x - x - x - x". I can create different dash line but not sure I can add x in between dashes. I hear there are possibilities of either converting it to raster when writing or keep the vector form. I would love to get some idea on how to do both. Thank you!

Hello, I have a lot of big scripts a lot of test criteria. Is there a way to import test criteria for a tester? I know the import function for the AttributeFilter but that doesn't fulfill my needs.

I'm running JSON Fragmenter to break out an array, and, in the process, it indexes each row of that ID. Is there a way to retroactively put the last JSON Index value of each ID's array into every row associated with that ID? I'm trying to calculate a percentage of where each row is compared to its total. (JSON index [8] of ID XXXX is in the first 2.34% of ID XXXX's total JSON Index.) Thanks, in advance!

I am trying to write a fanout of a large pdf using bookmark data that was merged from a csv file. The fanout works, but the output files give me either blank pages or very blurry/unreadable images. The source file contains many jpegs and was created using BlueBeam. I am able to see raster images using RasterConsumer (filtering to single pages), but the end result is unusable. Here is my workspace with annotations:Surely this is possible?Thanks,@lorenrouth​    Update:After looking at the data from the GeoSpatial PDF Reader, the issue appears to be the file has multiple formats on the same page. How do I deal with a pdf that has text, image, raster, spatial and vector data all on one page?!?!? If I send spatial data only to the writer, it leaves out an important raster image. If I include the raster, it is output with an unreadable black background and blurry text. If I print the pdf as an image, it looks fine, but there is no text or metadata associated with it, making it impossibl

We have to update email address and phone number employee information in a REST available application from LDAP/AD and want to use FME. With the LDAP reader being in Technology Preview stage we are a little concerned about moving down this path and may have to use a .net application instead. Is there a timeline for when the LDAP/AD reader will be ready? Thanks, Simon

I want to split my shape file to 6 parts. The count is aprox 600000. How to do this using if condition. Pls guide me

I have a layer representing building polygons and another layer showing garden polygons; what I need is to create one merged polygon representing a building and a garden. This is based upon whether the building polygon touches/abuts (borders) a garden polygon, however this must be a 1:1 relationship so if there is more than one garden that the building abuts, then it must choose the garden polygon it has the longest edge with. I have tried to use the NeighborFinder and Dissolver, but it does not seem to work between the two polygon layers. Any ideas are welcome. Thank you.

We use the ProjReprojector to reproject data (FME 2020.1.0.1), using a wkt string. For the UK, a special datum shift grid is specified in the wkt2 string, yet the resulting raster is not located correctly when reprojecting to EPSG:3857. I'm wondering if this issue is related to FME, parameters in the wkt2 string or my (limited) knowledge in this area.  When reading the raster, FME reports a crs of _FME_0. I can manually set this to "OSGB-GPS-2015-OSTN15" using a coordinate system setter, yet I prefer to perform the reprojection based on the wkt2 string. Can somebody please assist in how to do this with FME? Attached zip file contains the raster data, the wkt string, a document with the current (and expected) location.

Hi, I have two shape files. One containing roads and one containing the grade of the condition of the road based of an inspection. The shape files share two attributes, starting point of the road and ending point of the road. I would like to add an attribute in the road shape file, which is the grade from the other shape file. Not every road has been graded, but I would like to add the grade as a new attribute for those that have a grade. So, if there is a matching starting and ending point in both shape files, which means that it is the same road, the grade should be printed as a new attribute in the road shape file. I hope this makes sense. Thanks a lot in advance! :)  

Here are the BADNEWS errors, these I haven't seen before. Could someone help me out in the right direction where they are coming from or does someone know a solution? 2021-12-09 14:46:38|  4.0| 0.0|ERROR |BADNEWS: An error occurred while fetching from query `SELECT OWNER, TABLE_NAME FROM ALL_OBJECT_TABLES WHERE OWNER IN ('GBIBASIS','PUBLIC') AND TABLE_NAME = 'GB_MECH_LEIDING'' : OCI_NO_DATA2021-12-09 14:46:38|  4.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\dbwrap\\ocistmt.cpp:663) class StatusInfo *__cdecl STFDB_OCIStatement::fetch(unsigned long,unsigned long &)2021-12-09 14:46:38|  4.0| 0.0|WARN |Exception Name: stk::ex::Throwable -------------------------- 2021-12-09 14:46:40|  6.0| 0.0|ERROR |BADNEWS: Cannot convert null string into an integer2021-12-09 14:46:40|  6.0| 0.0|WARN |(C:\\code\\fme\\foundation\\framework\\util\\stf\\stfutil.cpp:348) class StatusInfo *__cdecl STF_stringToUInt(const class ObsoleteString &,unsigned long

Hi all, I'm trying to map fields to match a SQL table where some need to be Null and others are Not Null. As far as I can see, I've done this correctly in the 2 NullAttributeMapper Transformers (attached screenshots). Basically I need some to be Null, and others to be Not Null. These have been separated in the screenshots below by 2 NullAttributeMappers. I've attached the error as well, as this is proving to be quite tricky. Any help is appreciated.

I'm trying to get my head around this: I've been given a png image in a polar stereographic projection, a set of coordinates of its extents in LL84 and this PROJ4 string:+proj=stere +lat_0=90 +lat_ts=60 +lon_0=10 +a=6370040 +b=6370040+no_defs +y_0=3609144.7242655749 +x_0=542962.16692185635And the challenge to georeference the image. Problem is I can't use the RasterGeoreferencer with the extents because in LL84 they don't form a rectangle. Any other pure-FME solutions I can try?  

What are FeatureReader/Writer vs Reader/Writer advantages/disadvantages

Here is another simple-yet-not question: I am working with a large pdf and want to populate pdf_document_info_metadata attribute values for every feature.  I have tried: FeatureMerger, Joiner, Aggregator, AttributeValueMapper, NullAttributeMapper, AttributeManager (trying to use Adjacent Feature) etc. This should not be that hard, but I'm at a loss. Any ideas? Thanks,@lorenrouth​ 

Hi, I'm still fairly new to this tooling ecosystem. I have "inherited" a workbench and have made some changes to it. At some point, one AttributeManager started to appear in the "Incomplete Transformers" section of the Navigator. It's missing the attribute called "subcontractista": What I don't understand is, this attribute is being consumed in the preceding custom transformer as well as in the other branch that leads from it. I mean, in the following image, the green transformer is parametrized by this attribute and in the Tester that is hooked to the output, this attribute is visible under the FME Feature Attributes tab.There is no other AtrributeRemover or AttributeManager that might affect the presence of the attribute "subcontractista". In fact, I'm quite positive that I haven't changed that part. 

Hello,How extract the geoJSON geometry from the attached complex JSON file?The data model is a new one. So the supplementary attributes before "horizontalProjection" are right. The goal is to display the shape of thousands other surfaces for verification.Here is the code :Thanks for any information that could help.

Dear users, I have a string attribute stored in a field for >150k point features including addresses, numbers, and sometimes additives. Three examples of addresses:  Maria van Reedestraat 9-BSEduard Künnekehof 1Bucheliusstraat 11-BS What I would like to have, is a new attribute indicating only the street name (= everything before the last space) and a new attribute only having the street number plus additive, which matches everything after the last space.  I have found some tips regarding regular expressions, but I haven't found a way out yet.  Any help would be appreciated! Thanks in advance, Martin

I'm trying to load data from an Excel sheet which has spaces in it's name using the Generic Feature Reader. I've got the reader set up to read a dataset based on attribute values (derived from parameters), and to read the feature type directly from a parameter value. The above works perfectly regardless of the dataset name, but I can't get it to work when the 'sheet_name' parameter value contains spaces. I've tried the following;Using an attribute value for 'sheet_name' instead of a parameter value. This doesn't work eitherUsing an Excel reader rather than the Generic one. This doesn't work Any ideas or help much appreciated. In case it's of relevance, I'm using FME Desktop 2021.1.0.1 Matt

Road is aggregated based on Road ID, that I have in the table as well. So for example I want to create point in X meters ( X value from table) . Snipper is not working for this task. Any solution for this?Thank you 

I would like to apply an Excel macro to an Excel document which I have just written using FME Desktop 2020.2. Python Interpreter used is 3.7.This can be done using the library xlwings according to this post. According to the FME documentation I installed xlwings in the folder: C:\Users\<name>\Documents\FME\Plugins\Python Next step I tried to import xlwings using Python StartUp script in FME Desktop.import sys, six, numpy, xlwingsUnfortunately I got this error: Python Exception <ModuleNotFoundError>: No module named 'pywintypes' Is there an easy way to solve this? In case the answer is no, I will switch to another library which can apply a macro to Excel output. 

Hey! I have a bunch of polygons (in 3D) that I want to create break lines between. My idea was to use Intersector but it does not create the break lines for some reason. I have attached my workspace. To clarify, the green lines in this image is the result I'm looking for.