Transformers

How do I copy the data in the Table view and/or export to a spreadsheet

Hello guys.What i am trying to do is to get tiles from S2 on AWS inside FeatureReader. So far so good but i want to adjust the range of dates by incoming attributes from another input (eg. Excel table). Start date is a specific date minus 5 days, and end date is the same specific date + 10 days. Everything seems ok till i click OK on the FeatureReader. Then i got this screen:So in the end of the day i don't have the start/end date defined by the incoming attribute. Is this somehow possible because i don't want any manual inputs in this flow. Thanks and keep safe!

Hi everyone, A quick, probably very simple, question here. I'm working with different areas and I have calculated what percentage of a certain area belongs to a certain group. Now, the percentages all have a single row in the attribute table (see picture). I want all the percentages to be on a single row so I can have the percentages per area and make a pie chart with it. So it should be just one row for the GEBIED = Donzel 1Hopefully this makes sense. Thank you in advance for your help!Best regards,Esmee

Hi @daveatsafe et al, if I am using the Maximo Transformers in FME Workbench, what Reader or Writer do I use? For example, if I am reading from a ESRI FGDB and I get certain records with attributes from that read, and I wish to write them to a Maximo Asset, I understand that I must use the MaximoObjectUpdater. But what Writer do I use? Or, If I am reading from a Maximo Asset, I must use the MaximoObjectQuerier. But what Reader do I use? Thanks, Mark

I have made a workspace that downloads Dutch TOP100NL via links like these: http://geodata.nationaalgeoregister.nl/top100nl/extract/kaartbladen/TOP100NL_20W.zip?formaat=gmlI read the GML data with a FeatureReader and in the end I write it to a File Geodatabase. However after I ran my entire workspace I saw that I was missing some columns in my Attribute table.After searching for some time I found that the GML sometimes has multiple value's for the same attribute. As you can see in this screenshot we have two values for 'fysiekVoorkomen'. If this is the case in FME there are two curly brackets behind the attribute and in the end this attribute is not written to the File Geodatabase. This is not only the case with the attribute 'fysiekVoorkomen', but with a lot more attributes in my workspace. Here you see how the attribute is displayed (fysiek...omen{}).Apparently the curly brackets mean that the attribute consists of multiple elements (listelements). I would like to

Hello  I'm looking for inspiration to parse a tab delimited text file that defines features. Geometry can be Point (single row), or Line/Poly multiple rows with the order maintained in the file and also with a sequenece number if required.This is all fairly simple except the segments for Line/Poly can be a mix of straight lines and arc segments.Looking for ideas how to construct the geometry for Lines/Polys containing arcs? My current approach might be to build the geometry in an attribute value (FME OGC WKT doesn't support arcs) and use GeometryReplacerFurther suggestions appreciated - Thanks

I use the S57 reader to read a 000 file and have set the parameter "Action to Take on Update" to True so that the update files (001, 002 and so on) will be applied. When the reader apply an update I expect that the attribute UADT (Update application date) on the DSID object will be the date from the last update file. When I use the Inspector to watch the object the UADT has the same value as ISDT (which is the date when the 000 file is created). Is there an error or is there something I have to do to get the correct UADT?

Hello FME Community,I got a problem with polygones (Buildings), which intersect each other. The data is given as 2D Polygones (or maybe as 3D, but better would be, if I could solve the problem with the 2D Dataset). Each Polygone got an ID. Each polygone got the attribute "height". Some Buildings are so complex, that they are mapped as many polygones with the same ID.To review the situation: I got 2D polygones and some of them are intersecting each other. This could be in many ways, Sometimes 1 Polygone is just intersected by another, but there are many situations, in which the polygones are intersected by more then 1 polygone. It happend, that one polygone is with 100% of its Volumen in another one (100% overlapping). On top, in could happen, that the polygone is intersected by another polygone with the same ID and by polygones with another ID (so the grouped by doesnt work). The Goal: I Need to figure out the Volumen of each polygone without the intersections. The intersecte

I have some big ECW files 3-6gb each and they are clipped by the administrative boundaries (50polygons,1 shape file,attribute name is administrative unit name).Now the administrative boundaries has changed and updated and i want to use this new polygons as clipping feature where rasters should be clipped or merged(mosaic) by parts of neighbor raster based on the new boundary which they fall inside. What is the right workflow cause i dont want to do it one by one filtering the administrative units shape file one by one, i want that the rasters to be clipped inside the new boundary for every administrative unit(where all the units are inside one shapefile with the attribute as administrative unit name).And i am not sure if the ECW files are the recommended format for this process case i'v read that they are very slow.

It seems that the RasterExtensCoercer removes every attribute which name is prefixed with underscore, if you set Raster Extent or Data MBR Extents to the Extents Type parameter.See the attachment. (FME 2020.0.1)

Hi,I kindly need to know how to transform a file in .csv format into a file in .pxy format or a .txt format. Many thanks,Mamdouh

Heya, I'm having some trouble writing a two csv tables (share a relationship via a common ID in both tables) to a esri feature class and related table (linked via relationship class - global ID / parent globalID) which have a set pre-configured schema.Here are the steps i have taken and some screen shots of my process to load the csv data to the feature class schema (part 1/2).Part 1/2 - load geocoded main csv table data into esri feature class  The csv default for each field is read as a text field, thus the Esri reprojector is trying to pass all these text fields into a set schema. Do I need to include a schema mapper? If so, what does that table look like and in what format does it need to be in. Or, do I need to define all the fields in the CSV reader? The csv is being created correctly no problem and the data are same in the same projection and in the same region as I view them all in the preview with feature caching. The writer to write to Awhina Schema cannot be run - it&#39

Using TableAdder to create a table with more than 1 content-row results in the rows not being aligned.I have tried with and without different group-by options.Inside the tableAdder the error becomes obvious, less so to fix.Data for placing the boxes in the Y-axis depends on the _count variable, and so the boxes ends up being displaced a half-height for every iteration.Has there been updates to Counter without TableAdder being udated?I managed to get the output I wanted, by removing a counter transformer and changing the code for y-placement, but I am left wondering why the plug-n-play transformers are broken?

Hello there!I have a little problem with solving this issue.need to create a geometry (with creator) which should be used as an "selector" maybe via intersect or overlap of features.This features are comming from featureReader (ArcGis-Online Portal). They should be intersected (or overlapped or similar) with created geometry, and as a result should be plain Excel Data, that inhalts only interected features. The problem is, that in my result excel data are no features inside.It looks like the were no "intersection". No features in created geometry. (but they are there) . I tried it with intersection and also with overlapping .Not pretty sure what is the problem. Maybe I just do not see some setting? the result Excel is includedAny Ideas?Thanks 

Good morning. I've been facing all morning a FME crash that I do not understand. So far I have tested my workspace with two version: FME 2018.1 and FME 2020.0 both 32-bits. The process fails with both of them.My source data is a Personal Database (MDB) without spatial information. In one table I have data about "group layers" and in other about "layers".A group can contain layers and other groups. I must build a JSON with that info.To build the JSON with the groups, I have used the following JSONTempalter: ROOT contains:{    "version": "1",    "tipo": "3",    "servicios" : [            fme:process-features("GRUPO")        ]   }GRUPO contains:{    "Nombre_ES": fme:get-attribute("NOMBRE_ES"),    "Nombre_EN": fme:get-attribute("NOMBRE_EN"),    "grupos" : [        fme:process-features("SUBGRUPO", "PARENTID", fme:get-attribute("ID"))    ]}And SUBGRUPO contains:{    "Nombre_ES": fme:get-attribute("NOMBRE_ES"),    "Nombre_EN": fme:get-attribute("NOMBRE_EN"),    "grupos" : [        fme:process

I am trying to figure out how to insert empty lists into a JSON Templator as an empty bracket like this:"materials" : [],Currently, I can't only get it to look like this: "materials" : [ { "materialBridgeId" : null, "materialTypeName" : null, "materialName" : null, "quantity" : null, "tamsUnitOfMeasureId" : null, "tamsUnitOfMeasureName" : null, "tamsStockpileId" : null, "tamsStockpileName" : null, "isDerivedFromCirus" : null } ],Any thoughts on I can achieve the empty elements listed above?Thanks!Mark

I have a sorter, but I do not want it to sort if the first row in Field B has a value. I am guessing this will need a combination of transformers.

Hi,I have created a FME Desktop workspace that imports data into the MS SQL database which runs successfully as a scheduled task if I am logged in the server. But it fails when I'm off the server and gives me this kind of error message. (I got a blank SQL provider error)2020-05-07 22:00:21|  11.5|  0.0|INFORM|Microsoft SQL Server Non-Spatial Writer: Trying to connect using SQL Server 2012 Native Client...2020-05-07 22:00:22|  12.3|  0.8|ERROR |Microsoft SQL Server Non-Spatial Writer: Failed to connect using SQL Server 2012 Native Client. Provider error ''. Connection string 'Provider=SQLNCLI11;Data Source=;Initial Catalog=cadasdb_equalizer;User ID=;Password=********'2020-05-07 22:00:22|  12.3|  0.0|ERROR |Microsoft SQL Server Non-Spatial Writer: A suitable Microsoft SQL Server Native Client is not found. Install Microsoft SQL Server 2012 Native Client from http://www.microsoft.com/en-ca/download/details.aspx?id=29065 . Please expand 'Install Instructions' and download 'sqlncli.msi'2020

How do I expose (or what Format Attributes contains the info) the AutoCAD Map 3D Misc data "Annotative", "Block Unit" and "Unit Factor" so that it appears with the OD and other attributes I exposed on the Reader? Thanks.

Hi I cant seem to find a way to test files on filesize. It's not a format attribute or something you can import with the files... You can do it with python probably, but I'm not a programmer. (I tried and failed :) ) All I want is: TESTERfilesize > 1 183 000 bytes    

HiI would like to run this script that need Selenium using python callerAnyone can help me ? thx Francesco

Hello,  In my workspace, I use LenghtCalculator to have the "Distance" from line. I'd like to have three Numbers after .  I use Stringformatter on this attribute with Format String .3f but all value not have this setting.  Someone can help me to fix this?  I have also tried Attribute Manager with Math Opérator "ROund (Distance, 3). It's the same things.  Best Regards  

Hello,I have created a workspace to download attachments from Survey123 for ArcGIS which works perfectly, apart from one thing. Some of the attachments are stored in related tables and as a result don't pull have the sample ID field included and this is causing issues further down the workflow.I need to create a workflow that compares the parent ID field against the whole globalID column. If it finds a match, then it copies the sample ID field to the appropriate line and replaces the NULL field.Does anyone know how to do this? GlobalIDParentIDSampleID1234NULLSamp 14564NULLSamp 2548441234NULL54564844564NULL45848545NULLNULL

It seems FME supports reading Sketchup and colors - through attributes like RenderingOptions.GroundColorRGB . However it does not seem to write these attributes if you have an fme_color on an object. I have tried creating an RenderingOptions.GroundColorRGB = 0.59999999999999998,0.74117647058823533,0.56470588235294117 - however it does not seem to work. How do you set colors properly in FME for them to be displayed within Sketchup correctly?

 i have three lines intersected in the same point the intersected point and the three points known for me ,i want to make barrier at the third line at right side .so the third line will not be part of the network id by network topology builder .the point in the third line has special attribute and i can recognize it so i did buffer on this point but i found the line above this point connects to the another two lines and i do not want that . i want the whole third line seperated from this network id and it will connects to another network that third line connects to . each line has his own ID if i used topology builder ,it create extra intersected node but with id only one point above for the three line how could i solve that  Any suggestion ,thanks