FME Form

This seems as though it ought to be really simple but I can't figure out how to do it.I have a number of text files which each define a polygon by listing the coordinates of its vertices. I'd like to build polygons from the coordinate lists.Usually I'd use the VertexCreator to build points/polygons but I can't figure out how to get it to iterate through a list of variable length.Some of the lists are also quite long (20+ coordinates) and it seems there should be an easier way than adding 20+ VertexCreators in series!

I have been trying to implement a similar solution to that posted by SAFE around HTML reporting and the java accordion feature as referenced in https://community.safe.com/s/article/how-to-customize-html-reports The different is that I am using the group by function in the HTML Report Generator The accordion is appearing as expected  but only ever second category is able to expand  I know this is not truly an FME issue but more likely a HTML formatting issue but just wondering if anyone has had success with using the accordion functionality with the group by option in the transformer. The transformer is set up as follows:and the results of each HTML report seem correct Any insights would be greatly appreciated. Thanks Dean

Hi,When I try to run a workspace on the FME server, I receive this error. On my machine, I have ArcMap and Pro installed with 64-bit background geoprocessing. I am also reading data from File Geodb using the Esri Geodatabase (File Geodb) readerArcGIS Enterprise 10.9.1 has been upgraded to ArcGIS Enterprise 11.0, and I am running FME Desktop 2022.0.1.0 and FME Server 2022.0.0.2. It is unclear why I am getting this error. Is it because we have upgraded ArcGIS Enterprise and are using FME Desktop 2022.0.1.0?  Thank you,

I am looking extract data from a csv file, (1) all open orders and (2) all closed orders within the last 90 days. Any recommendations. Thanks

Hi all, Trying to read in UK LiDAR composite data via a FeatureReader and spatial filtering - https://www.data.gov.uk/dataset/01b3ee39-da3f-47b6-83da-dc98e73a461f/lidar-composite-dtm-2022-1m I see there is an Esri ArcGIS Image Server Reader (https://docs.safe.com/fme/2021.1/html/FME_Desktop_Documentation/FME_ReadersWriters/arcgis_image_server/arcgis_image_server.htm) which should help facilitate this - but it is not available on 64 bit. Is there any update as to when this may be supported or a current workaround for 64bit? Thanks!Jack

I have been tasked with sorting out 100s of workbenches. In the majority of them the names of the transformers have been customised and should be in annotations rather than the actual transformer name, for easier readability. E.g. SQLExecutor is actually named Table_xxx or FeatureWriter is Named xxx_Output. I'd like to know if there is an easy way to just revert the names back to the original transformers names. I can't find a way myself, other than manually going through each one and changing it myself. EDIT: This is on FME Desktop 2022.1 Thanks!

I have the following XML:<?xml version="1.0" encoding="UTF-8"?><MyProblem> <Maat Name="MyName1" Description="LetsDoIt"> <Status_Maat Value="Open"/> </Maat> <Maat Name="MyName2"> <Status_Maat Value="Open"/> </Maat> <Procon Description="FinalCheck"/> <Precon Description="StopAndCheck"/> <Maat Name="MyName3" Description="LetsDoNothing"> <Status_Maat Value="Open"/> </Maat></MyProblem>I can extract the Maat with XMLXQueryExtrator by the following expression:/MyProblem/Maat Notepad++ XMLTools says the path to the Description is /MyProblem/Maat/@Description but this gives an error. And no results. What am I doing wrong?

After LineJoiner some lines are joining in the way of making self closing line geometry with start and the end point in the same spot.Is there the way to identify and repair such lines or maybe there is option in LineJoiner to avoid such situations?

Is there a way to read in the data and keep the address field in one column? Any help appreciated.

How to read/write ODS files? Thanks

I'm having a bit of trouble understanding how to extract data from this JSON file my client sent me. It came from Insomnia and I'd be really grateful if anyone could lend me a hand with this.

i use transformer Testfilter to filter type of mutation. Ultimately, I want to know how many mutations there are per type. For that I use StatisticsCalculator.This works fine, except when no value comes from TestFilter. How do I get the process to continue and StatisticsCalculator returns a value of 0?

I have have a set of polygons (actually they are buffers of a point) and I want to buffer these again to leave a ring - just keeping the buffer outside the original polygon. I can do this easily in arc/arcpy by using the buffer type "OUTSIDE_ONLY". How can I get the same effect using FME? I have created the buffers but when I use the clipper to clip one out of the other it clips all the overlapping buffers (which is what I expected) but I can't seem to figure out how to get the result I would like. I feel like I need to split each of the the buffer datasets so that it does the clip on each pair of polygons separately but - I'm new-ish to FME so.... Can't seem to find anything to help online either. This is what I have - the attribute managers are just to fill in an attribute so I can put the two buffers back together in one layer and be able to identify which polygon is which type.This is what I would like to end up with:Not this:

Hi I have installed GoogleCloudPubSubConnector from the hub but I am unable to use it since it keeps failing the test for web service authentication.https://hub.safe.com/publishers/safe/packages/google-cloud-pubsub I can't proceed further, I always receive this error message:Error 401: disabled_clientSign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In.  Does anybody encounter this before? Thank you 

Hi there, I'm running into an issue where an attribute that was initially numeric ('counts') is being converted to a character type after I sum 'counts' for each 'tree_type' per 'area_unit' using AttributePivoter (example left to right in image below). Note: These attributes/data are just an example. This is a problem as I'm trying to write the results as a shapefile, which won't work properly for analysis in ArcGIS Pro as it recognises these fields as text rather than integer. Here are more details about my process for summing counts of tree types by area unit.  Input = CSV and 'counts' is read in as UInt32. 1.) I used an AttributeExploder with exploding type set to List, Keep Attributes = Yes, and Keep Geometry = No (Geometry is added later).2.) AttributePivoter, Group Rows By: = 'area_unit', Group Columns By: = 'tree_type', Attributes To Analyze: = 'counts', Pivot Summary Statistic Types: = Sum, Row Group Su

I can't find a way to do what I want.I got a certain number of features. I want to find the max(date) on attribute date for those features, but I want the max(date) to be in relation to a condition on a value from an another attribute status.  So I want the max(date) to be calculated and returned first from feature where status = completedif no features have a status=completed then returned max(date) from the other features 1 20230330 completed2 20230329 completed3 20230331 running4 20230329 waitingwould returned max(date) from feature 1 : 20230330 1 20230330 waiting2 20230329 running3 20230331 running4 20230331 waitingwould returned max(date) from feature 3 or 4 since no value set to completed :20230331  

I am a newbee, I have a spreadsheet that I need to have the data sorted by closed status and date column based on a particular date. Thanks for any help to where I can start.

I am trying to summarize Google Calendar events from the text output of Google Calendar. The export breaks the Description attribute across multiple lines (kinda like a permanent word wrap). Do you know of any way to walk through a text file and put relevant text back together (anti-word wrap)? I realize there is a Google Calendar reader but we are having some issues with connecting using 2FA. I was hoping the text output would allow me to get around fighting with the Google connection. For example, I want to eventually get the DESCRIPTION into 1 line: DESCRIPTION:Training Document Rollout\\n\\n-::~:~::~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~::~:~::-\\nJoin with Google Meet: https://meet.google.com/we-m2dbz-xvc\\nOr dial: (US) +1 443-23471-4874 PIN:8were6975#\\nMore phone numbers: https://tel.meet/wje-mebz-xvc?pin=2freaag3037362148&hs=7\\n\\nLearn more about Meet at: https://support.google.com/a/users/answer/912345620\\n\\nPlease do not edit this sect

I have a database table with about 5 million objects. Each object has positions (lat, long in two fields). I want to read only the objects that lie within polygons (features read from a spatial source). Is it possible without reading all objects?

I'd like to buffer only one side of a line. According to the FMEpedia articles below, in FME 2012 and later the Bufferer transformer should have this as an option. I'm using FME 2013 sp4 (13547) and the transformer doesn't have it as an option. Am I missing something?  http://fmepedia.safe.com/articles/Samples_and_Demos/Buffer-On-Left-or-Right-Side-Only http://fmepedia.safe.com/articles/FAQ/Whats-Great-2012  I did find the MultiBufferer from the FME Store but I can't get it to output a polygon, just a line that is offset the distance I wish the buffer to be.  Michael

HiI need to extract from json the info reated to each run  "Name": "Run 1","Start Time UTC": "","Stop Time UTC": "","Duration (hh:mm:ss)": "",  I tried to use the json transformer but no success thx for help Francesco

Hi Everyone I am slightly bamboozled and wanted to know if someone knows where I am going wrong or if this is a potential bug.I have had used the FME Cloud and FME Server for loads of FME Server Apps, and havent come across this issue so far. I get the following warning after running a fme server app I am converting a .dwg file to an excel file.  If I use a feature_reader set for readings dwg:Autodesk AutoCAD DWG/DXFI get the warning, that the no output can be generated. But if I read an ifc and convert it to excel, all is well.  Is there maybe a problem reading dwgs? Why is there no output generated? The FME Server Jobs show that the job is completed without any errors. I have uploaded a .dwg and .ifc and the workspace regardsFred 

I have a custom transformer. One of the incoming attribute values contains a comma separated list of strings. As soon as the record passes through any subsequent transformer, the value is set to null. Here is the incoming data with WOTEMPALTEIDs as the value that's getting dropped.After passing through any transformer (AttributeManager in this example), WOTEMPLATEIDs values are dropped to null. The other values are unchanged.Thanks 

Is there a transformer that will convert a multilinestring to a linestring object? I'm trying to load road centrelines in an oracle spatial database, but the road centreline table in oracle uses GTYPE 2002 (line). Multilinestring is 2006, so I can't apply a spatial index. Any suggestions please?

Hi there,Slightly off the wall here, but has anyone created a workspace that can create Bingo cards? Ideally a 5x3 grid of random numbers between 1-90, but no repeating numbers...?Obviously, RandomNumberGenerator can give us a way to actually play the game...but I'm thinking whether FME can create the cards for users to play with..?Thanks!