FME Form

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!

Hi all, I am generating a workspace for a client. A requirement is that output data should be in EPSG:29902. The writers have been defined to use 29902 as the output coordinate system. However, when I open the datasets in QGIS or Arc, the data is reporting as coordinate system EPSG:29903. Is there a way to correct this behaviour? Attached is a simple workbench with a creator transformer and a writer set to use 29902. But the output generated is 29903. Many thanks

I have a list of hyperlinks in Excel that lead to PDF's held in a website. Can FME iterate through this list and download the documents to a folder? Thanks in advance. Sean

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.

I'm extracting some data from a DB that stores values for time periods against a date in a comma separated list (above). I've used a cloner to create the time period for the date. Any idea how I split the csv list (presumably using an AttributeSplitter) and append the value to the desired timestamp? Any help appreciated!Thanks    

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 have an issue where I have text that contains braces that are inputted into an XMLTemplater through a SubTemplate (and also through ROOT). Since I don't want the XMLTemplater to parse the text, it is referenced as @Value(text) and not {fme:get-attribute("text")}. Still I get an issue as if FME expects a function. The log tells me: "context item": undeclared variableFor this issue I prefer not to escape the braces in my text, which of course would be a workaround. 

Hi Everyone, I need your help to solve a problem. I have many no. of points that are not in order if we look at them spatially and in many places, there is a significant gap considering its distribution. I have tried Sort and then Line builder transformer in FME but the output was generated based on the layer drawing order. Another issue is line builder does not consider the gap within point distribution and connects all points to generate a single polyline. Looking for a solution to convert points to separate lines based on their spatial sequence. The attached below screenshot could make you clear about the issue I am talking about.   

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

Hi, I have a jp2000 file and a j2w file with the georeferencing, but I would like to have the georeferencing at the jp2000 header. Is there any way to do that? Thanks!

If I do not explode, I loose the 3d surface and the geometry is shown as point.

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?

Need to understand how to avoid error "Table is already locked" while doing transforming data into ArcGIS enterprise nonversioned geodatabase on SDE.DEFAULT version when someone is connected through either ArcGIS Pro or feature services. When close the ArcGIS Pro session, FME transformation works fine. When schedule the FME transformation using FME Server, users must not to be disconnected before transferring the scheduled workbench. Please advise.

I am trying to parse an SLD file (which is XML) and generate a CSV output based on the rules within it. The following is a sample of the SLD structure <?xml version="1.0" encoding="ISO-8859-1"?><StyledLayerDescriptor version="1.0.0" xmlns="http://www.opengis.net/sld" xmlns:ogc="http://www.opengis.net/ogc"xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://www.opengis.net/sld http

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 have geotiff tiles and some need te be partially blurred, because of military terrains.  I mainly use the rasterresampler to resample the pixels in those area's to 3 meters and then resample them back to their original pixel dimensions.  The problem as you can see in the picture is on the edge.   The black edge is 1,12 meters, so the resampler doesn't have the space to make another 3x3 cell there, so he doesn't.  How can I solve this? I had the idea to make the geotiff tiles canvas bigger (see picture), let it resample and then clip it back with the bounding box of the original tile.But I don't know how to make the canvas bigger.    @Takash

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 co

Hi, I'm new to MongoDB, and I'd like to use FME to import data into it. Can someone please provide me with an example that shows how to set up the connection, specifically the connection Name, Connection Type, Protocol, Host, Port, Database Name, Name and Value parameters? Harry

Hi,I want to read with FME the data from a database oracle.I can connect FME to the database but I am not able to read the linear objects. I use the ORACLE_SPATIAL reader. I have the following message : “Error - Cannot have NULL value for 'z coordinate'” Do I have to parametrize FME to be able to read the null value of Z ?Find attached the text.log oracle_spatial.zipThanks,

Hi all,I am trying to convert fbx file to FME AR. I am getting the error below."FME-AR_FBX' of type Directory, expected a dataset of type Regular file"I tried to deaggregate to see if it works workout but no luck. 

Im having trouble configuring a JSON Reader to pull data from a REST API (JSON formated). The problem is that in order to successfully call a query to the REST API (via a URI), there first needs to be sent an authorisation request as separate formatted URI sent ahead that contains a UserID code and a 'Secret' code (ie password) within the URI. The JSON reader has a single web address field (which works well for other applications). To solve this particular problem there would have to be two URIs sent - one to send the Authorisation request and generate a session ID (with the authorisation held in cookies or similar), followed another to submit the data query. I tried the 'Network authorisation' entering the userID and secret into the respective field without success. Have also tried the HTTPCaller and JSON transformers. I dont know enough about FME or API calls to configure this properly, so wondering if there is some advanced use o

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--------------------

Hi All, I have a complex polygon with smaller polyons within a bigger polygon, multiparts and lots of overlap issues. I want to be able to desegregate, remove multiparts and be able to select each polygons individually. Any thoughts will be helpful.