Best Answers

Hello,I wish to generate a count of points within Polygons [PointOnAreaOverlayer] but I am unable to generate a count for some polygons because of fme_rejection_code: INVALID_POLYGON_GEOMETRY_TYPEThese Polygons are either Self Intersecting or Multi Polygons. I believe I need to resolve this before I can start counting points inside but Aggregator and Geometry Validator do not seem to fix the issue.Thanks. 

I am new to FME Desktop and experimenting with downloading a feature from a Map Service hosted on an ESRI ArcGIS server. Is there a way to enable the "return_true_curves=True" when downloading the feature to a local FGDB. I have everything working using a Reader pointed to the map service; however, FME is converting the true curves to simple curves when reading or writing the data. I am able to download the feature using a query and the ArcGIS REST API in python to get a feature with two point curves to a FGDB. Would like to do this directly in FME.

Hi how to avoid to repeat 3 days of data read after a translation failed? Seems the temporary folder run out of space. Can I swap the temporary location and restart the process from certain point instead of starting again from the begin? Alex

I am running a workspace that detects changes in data between an API and Web App and applies only updates to the Web App using a change detector transformer. I am sending a notification to a Slack Webhook but instead of a single HTTP request being made, it makes 1 request for each data record updated. What I Want:"Successfully updated 70 records". What is Happening:"Successfully updated 1 records"."Successfully updated 2 records".And so on till 70... Is there a transformer that will allow me to sum the number of updated records and only send a single HTTP request to the Slack Webhook? Workbench Screenshot: Thanks!

I've got a HTTPCaller in a loop that retrieves data page by page (I use offset and limit). I have a tester that tests whether 'has_last_page' is true. This all seems to works ok but the translation does not stop - it just keeps repeating the last URL even though all records have been returned.

This morning all of my FME workbenches failed to open and I get an exception breakpoint application error. It says (0x8000000003) occurred in the application at location 0x00007FFAB8D6293. The only option is to terminate the program. Any help would be appreciated. Thank You. 

Hi All, i have been banging my head against this for a while. Im trying to parse an api call response I get ( XML returned) . I have tried Flattening it. I have tried Fragmenting it, I have tried swearing at it. None of the things I have tried have worked. I don't really understand how this data is structured. Its nested I think, with something like tuples??? there is a Name, Number and Text for each attribute?? Any help or direction appreciated. Happy to learn. I'm trying to return the "number" value of NZTM 2000 Northing and NZTM 2000 Easting as attributes... Many Thanks for your suggestions.

I am running workbench an FME Server automation that is fired from a SQL Server insert trigger for a ArcGIS feature class that has editor tracking enabled. On the workbench I check previous records for the feature and only want the workbench to complete under specific conditions - it is writing an HTML file. I was considering using the NULL writer but the documentation indicates this should only be used for testing. Looking for the best way to accomplish this. I considered modifying the trigger but this is so involved and much easier and cleaner to do in FME... Any tips would be appreciated.Thanks!

Hello,I am trying to obtain Max OBJECTID value from a database and pass it into Variable Setter.The SQL Creator > Variable Setter is obtaining the correct value (just one record at present) but the Variable Retriever cannot obtain the value I think?I hope this is a simple step or order I am missing.Thanks in advance

I'm copying PDF files from a source folder to a destination folder. The destination folder is named with today's date (.../outgoing/October-11-2021/).I used the AttributeCreator to create and format the date attribute called "Date_today" and set filecopy_dest_dataset to "Date_today".This all works well, the PDF's are copied into the date folder, however, I also get another empty date folder created in the folder that the workbench is in.Fanout is off. Any ideas how I can stop this extra folder being created?

Hi all,I'm trying to download files (in this case zip files), which are in a parent folder on an ftp. The folder name changes once a week, when new updates are uploaded. I would like to automaticly download the updated files once a week, but it seems that the ftp caller has some limitations in that department - (asterix and subfolders). I have searched the forum for answers, but haven't really found a solution yet. I've seen suggestions using python caller and ftp caller combined, but I dont really do python :-) Any suggestions? Thanks

I am trying to generate a JSON message to update editing templates on an AGOL Feature Service. I've got most of it complete. I am having trouble with the last piece though.  Each Editing Template has a list of fields and defaults like this: I am trying to generate 27 unique editing templates based on unique pairs of 2 attributes. The portion of the JSON text I am struggling with is the ["types"]["templates"]["prototype"]["attributes"] section. I have the correct number of "types" (27). I have the correct fields and corresponding default values.  As you can see, I am getting an extra pair of "},{" between each field as compared to the example above. Almost like each row is it's own unique element. I am sending 594 features into the "EDITEMPLATEFIELDS" sub template and grouping the process by '_editTemplatePairs' attribute as these contain 27 unique field configurations for all 22 fields in the editin

Hello, Let's say i have an excel table containing multiple attributes and features, and I would like to output in an excel table a summary of the unique values for each attributes. Using duplicate filters I managed to get the results but they are ordered in rows in order of arrival instead of being nested for each attribute. Example with three attributes:ID ----- Name ------CityA1 -----Mark -------MoscowA2 ------Paul -------GlasgowA1 -----Joanna ---CapetownA3------ Paul -------Glasgow  Then in excel I get three columns but the results are spread in the order of arrival of results for each column unique values: Column A -- Column B -- Column CA1A2A3--------------Joanna--------------Paul--------------Mark --------------------------------Glasgow---------------------------------Moscow-------------------------------- Capetown Instead of having the results over various lines, I would like to get the unique values on top of each column. Is there a way to do so ? Maybe working with lists ?

Hello, I'm doing the unit "Publish your Self-Serve Workspace to the Web" as part of the training "Integrate Your Data with the FME Platform". That unit tells me to change the parameter "Destination Generic (Any Format) Folder" of the writer, to a location on the FME Server. If I change that parameter to the FME Server, and run the workspace locally, it seems to store the output in the same folder as the workspace. I would like to store it in a different local folder when running locally. That way, I can use the same workspace both locally and on the server. Is it possible for the workspace to detect if it's running locally? If so, then I can configure it to save to a specific local folder. If not, I can configure it to save to a specific FME Server folder. So far I've tried:Log File. Potentially the workspace could see if "FME_HOME is 'C:\\Program Files\\FME\\'", which implies that it's running locally.Workspace Parameters

I am new to FME and going through the unit "Quickly Create a Conversion Workflow " of "Integrate Your Data with the FME Platform". In that unit, we create a reader to a PostGIS database. My understanding is that what we see on the canvas is just the "feature types" of that database, aka individual tables. I thought that they would all connect to the same "reader" in the background. But when I added two new readers to the canvas (marked 2 and 3 in the image), they created brand-new readers in the navigator. Even in the case of reader 3, which has the exact same parameters as reader 1!Can you please suggest if there's any way to modify the feature type marked 3, to make it use the reader marked 1? When I open the feature type's properties, they are greyed out. The only options I see right now are:keep both readers and maintain "connection parameters" in both, orrecreate that feature type from reader 1 and manually configure it as

I have been given a huge spreadsheet containing countless series of identical columns that are duplicated many times, with a prefix in front of each that indicates some kind of property of the data. I now want to reformat these data so that the duplicate columns are replaced with unique columns and the attributes that were used to separate the columns become attributes in the data instead. Please see simplified attachment (and screenshot, below) which shows the "Current format" and "Desired format" sheets. CurrentDesired I've tried several things, none of which are giving me the results I want:Adding an AttributeCreator to create a separate, duplicated pipeline for each of the types (Apple, Banana, Orange, etc.) and then BulkAttributeRenamer on each to remove the prefix of the column based on the attribute I created. In theory, this should create a single "Tree Height", etc. column per pipeline that can then be merged back together and the remaining a

Hello, I’m looking for a way to classify (order) the lists within a list attribute. Essentially I need all lists that have a “phase” value of ‘R’ to be on listattribute{0}…all list values that have a “phase” value of ‘Y’ to be stored in listattribute{1}…and all list values that have a “phase” value of ‘B’ to be stored in listattribute{2}.  Using List Sorter, I am able to accomplish this as long as there is a list for all three phases. The data sometime has only 1 or 2 phase values (example: Y and B, but no R). If I sort the lists that only have two phase values, “Phase” = ‘Y’ ends up in listattribute{0}. How do a force a blank list value for ‘R’, so that ‘Y’ still gets stored in listattribute{1} and ‘B’ gets stored in listattribute{2}?.... listattribute{0} could remain blank  These lists need to be structured correctly so that I can run them through an XML Templater and have them placed in the correct spot in the XML. Update - I have attached the workspace and the xml template that cal

using FME Desktop, i have a workspace that looks at two databases and generates a csv with information from one database that is not found within the other database. i need to then send that csv file to someone via an email, however, the csv file contains 11k rows and the emailer is trying to send 11k emails. how do i send one email with the csv as an attachment?

It's quite possible I'm missing something rather obvious here. But I can't figure it out. Funny how when searching the web what I stumble upon is my own post from a year ago. What I have put together since is a workspace that reads CSV and spits out JSON. I've published this to FME Server (2020.2) and selected "Data Streaming" and "Job Submitter" as services. Now, I'm sending a CSV file from a web page to FME Server using some of the examples here, and effectively calling the workspace with a Javascript line like this:FMEServer.runWorkspaceWithData( repository, workspace, params, callbackFunction);This works great but all I've been able to do is hit the Download Service, so the service response contains a URL for a zip file. How do I switch this to Data Streaming ? I guess this might also turn this into a asynchronous? If so, is "runWorkspaceWithData" still the right way to do this?Currently my params look like this:var params = { filename : fileObj.name, files : [fileObj], params : []

Hi, fellow FME-lovers! I have an interesting problem that you can help me solve in an efficient way. I have many pipe segements as solids in an ifc-file, see example in Test2.ifc. The pipes are in 3D and can be connected in all directions. (I'm not sure about the fittings but for now don't mind them.). Now, I need to calculate length per segment and I started working no a complicated scripts (2D and algebra...) but there must be more of an FME-way. I'm thinking along the lines of creating a center line from pipe start to end... If you have any ideas I will gladly listen.  Bonus: what if segments are bent? Will this be handled in you solution? Peter

I am using Bufferer to create a 4 foot buffer around right-of-way polygons. The tool works for 99 percent of the areas but I am getting a few random missing polygons as shown in the screen-shots below. I did find if I change the Buffer Distance one area will generate correctly; however, the issue occurs somewhere else. Areas: Buffer with missing polygons:Any Ideas how to fix this. Buffer works fine in ArcGIS for the same features.

I have FME Desktop licensed on an air-gapped server but covid has changed my working patterns; so, for the 2 or 3 days I work from home I don't have access to my favourite software. Is there any way to borrow a license from my air-gapped server for use on a different network?

I have a workspace which uses input user credentials to do stuff. I also want the workspace to work during testing by using System environment variables. This is working great for things like DBNAME, HOST, PORT etc where the user inputs are strings (text user parameters). I can simply just enter in ${PORT} for example and FME will look for a set environment variable. Where I'm having trouble is with the password. I can't do the same thing for the password so I've created a simple scripted parameter which first checks if there is a user password set and if not try and see if there is an environment variable. In most cases it works well, however, I've discovered that some special cahrachters are getting encoded by FME - So something like @ becomes '<at>'. Does anyone know a way to 'decode' these encoded strings. Ideally it'd be done in the scripted parameter, however, if it has to be done in the workspace so be it.Short from using some kind of regex in a string replacer I'm a bit s

Hello,is it possible to run from fme system call (or python caller) and don't wait for the result?

Hi I have a lot of small geotif tiles. I need to mosaic them together as geotif in specific zones.  I tried the standard compression which is jpeg. The problem is that some zones are to large for the compression method. I get this error: "GEOTIFF writer: Failed to write the output file using JPEG compression. The raster is being written with a tile size of '29005' rows by '82874' columns, whereas the maximum number of rows or columns that JPEG compression can handle is 65500. Please reduce the tile size if writing a tiled file, or reduce the size of the raster" So I'm thinking I only need to change the compression method. I tried all the other compression methods and I always get the same warning: "GEOTIFF writer: Existing value for creation option 'INTERLEAVE' was 'BAND'. Overwriting with the new value 'PIXEL'GEOTIFF writer: Existing value for creation option 'COMPRESS' was 'NONE'. Overwriting with the new valu