Best Answers

This is my first time using the SFTP External Action in an Automation. I have previously used the FTPCaller Transformer in FME Form, but sometimes it gives an SSH error. The SSH error has occurred 2x over the past 6 months. Safe Tech Support tells me it is a generic error for which they cannot find a fix.  Consequently, I am looking to use SFTP External Action in my Automation that previously used a FME Form workspace to upload to the SFTP.  Questions about the SFTP External Action Details in Automation:Source Path includes the path and the file name (myspreadsheet.xlsx); Is it ok to add the name of the source file in the Source Path? Destination Path includes the path and the file name (myspreadsheet.xlsx); Is it ok to add the name of the destination file in the Destination Path? Is it correct to assume that Destination Path is the same as the Transfer URL in the FTPCaller Parameters in FME Form? The SFTP site has a password, when I enter the password in Password (optional) and choose

Hello,I am creating buffer polygons for points, but I would like to loop through the newly created buffers and associate them with subsequent points that fall within the new buffer.If 2 points are next to each other, the first point would be buffered and the second point would be associated with that buffer.Thank you.

Hello,I have a API request working in postman, but cant get it to work via FME. If I could see the request headers/body, etc I would be able to debug the issue by comparing the working request vs the fme request.Does anyone have any ideas how I can see this?Thanks

I need to export data of an oracle database to XML, it’s data from an electricity network, so not highly structured or nested.I created a workbench using the xml-templater and got some results, so far so good.Are there any limitations using the XMLtemplater compared to the XSD-driven Writer?I don’t want to create the whole export and realize later, that I would have better chosen the XSD-driven Writer for XML.Also a little problem with XML templater:I created an Attribute Value using Attribute Manager, a simple number “0.4”.When I write this value using the XMLtemplater it gets written as “0.40000000000002” to the Textfile.What am I doing wrong?  

I have two spreadsheets. One is the original data; the other is data that has changed. The schemas are the same. The spreadsheet with the changes has 3 records. I need to add these 3 records into the original data (while deleting the original 3 records in the original data), thus updating the records in the original. What is the best way to do this using ChangeDetector?Currently, when I use ChangeDetector, the records from the changes spreadsheet are output to Inserted; The records from the original spreadsheet are output to Deleted. Deleted includes the 3 unchanged records that are in changes spreadsheet.  In the screenshot below the 95,392 in Deleted include the unchanged records that are in Changes. The transformer outputs the Original and Revised separately with no way for me to delete the 3 records in 95,392 and add the 3 changed records? 

Hey Folks.I’m trying to move files from one folder to another after execution but it’s not working properly.I have tried using filecopy writer by selecting move option, but copy is working properly but its not move.I have also created attributes - filecopy_source_dataset, filecopy_dest_dataset, filecopy_dest_filename. But I’m not getting what value should i give into these attributes.Kindly help. Thanks in advance

I need to connect to an api that requires a bearer token in the header for authentication.This token should be generated with a jwk. Example to request a token (there are public available examples from the service, so no secrets from my side):POST /op/v1/token HTTP/1.1Host: authenticatie.vlaanderen.beContent-Type: application/x-www-form-urlencoded grant_type=client_credentials& audience=8ed36a78-8443-11ec-b334-83e86b606670& audience=9e6a512c-8443-11ec-ae2c-8700eb2a0cde& scope=org_api_appread%20org_api_appwrite& client_assertion_type=urn%3Aietf%3Aparams%3Aoauth%3Aclient-assertion-type%3Ajwt-bearer& client_assertion=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiIyODM1ODgxNC01YzIwLTRjMTMtYmJmZi1kYjVkZDhjNGFlOTMiLCJzdWIiOiIyODM1ODgxNC01YzIwLTRjMTMtYmJmZi1kYjVkZDhjNGFlOTMiLCJhdWQiOiJodHRwczovL2F1dGhlbnRpY2F0aWUudmxhYW5kZXJlbi5iZS9vcCIsImV4cCI6MTU5MjIwODA2MCwianRpIjoiRGt6bmpzdTQzZHprZDN6amQ1IiwiaWF0IjoxNTkyMjA4MDAwfQ.3dPodaVhJ2d3cXWn0v2YGeZqs5XScJF2lm4MaweDnf4 the

Hi, I’m trying to connect using the ‘Databricks (JDBC) Reader’ but I’m receiving an error. I’ve attached a screenshot from the Error - Log Window. Any ideas? 

Hi FME users, I have only been using FME for a short while, so please bear with me if this question is very basic. I remember seeing in several example screenshots of the workbench having multiple tabs open rather than just the default "Start" and "Main" tabs. I can imagine it would be very usefull to be able to toggle between different workspaces in the same workbench but couldn't find how to do this. Could anyone please share any experience on this?

Hello,I was wondering if someone here could give some guidance to a problem we are experiencing.We our trying to connect FME to BigQuery but regardless if it is the reader or writer we are unable to connect using Web Connection.For the Web Connection settings we use or own accounts which have access to BigQuery. In fact when we connect directly to BigQuery we are able to see the project, datasets and tables and we are able to run queries on them.But when trying to establish the connection from FME using Web Connection we get the following error: BigQuery Connection ErrorAny help on how to solve the issue or to even find out what exactly is wrong would be appreciated.Thanks in advance.RZ.-

When python caller errors out.It does not show error line number. Message Type: fme::internal::_v0::py::ExceptionPython Exception <GEOSException>: LocateFailureException: Could not locate vertex.🟢06-Report (PythonFactory): PythonFactory failed to close properly

Hi,How can I expose the result (print), like attribute in python caller:         from_value = min_iten[0]['from']        to_value = min_iten[0]['to']        print(f"{from_value[:-10]}") Thank´s

I’m looking at an area of survey points that can be divided into east and west areas by grouping with an attribute value. I have used Hull Accumulator to draw polygons around a) the whole area (light purple) and b) the two subdivisions (darker purple). The point population remains the same overall, but I get different external boundaries in places, when I was expecting the same. Alpha = 0. What would be useful is any description about how the transformer makes its drawing choices. I also end up with a donut hole. Again, am trying to understand how this occurs, as I assumed the transformer would create an external boundary only.Many thanks 

Hi FME folks,Is it possible to sort the column names in the Table View in the Visual Preview alphabetically?It's frustrating to have to scroll all the way to the right to find a column that starts with an “a”... Thanks!

Helly everyone,I am working with data that consists of abrreviations/code items that are strung together in a single field which I am trying to convert to full text. For that I am using a string pair replacer which contains thousands of mapping pairs, but I have encountered a problem which I can’t seem to solve without knowing how exactly the String Pair replacer does its thing. The problem arises when multiple codes share letters. Here`s an example: I have the following pairs somewhere in my replacement pair string**gn green**bn browng gravelF mudSo F:**bn**gn should map to Mud:browngreen but whats happening is this: M:brown**gravelr.I figured that the transformer probably checks its list from start to finish and ordered my list by string length in hopes it would transform longer strings first. The order of replacement items definetely has a big impact on the result and I was succesful of ironing out most errors in doing that but this particular translation and a few others still dont

Bonjour, Je souhaiterais trouver un moyen d’orienter un ponctuel (des supports électriques) par rapport à l’orientation de leurs ligne.

Hi,I have a workspace that uses some RasterToPolygonCoercer, but the performance is very low.I need to improve the performance. I'm trying to convert some clouds detected in my raster image into polygons.How can I improve that? Thank´s   

Hi,I understand that the Raster Expression Evaluator transformer doesn't work properly, only in the new version 2024.2.I would like to know how I can proceed with my workspace, as I want to keep only the raster pixels with values greater than 0.3. How can I solve this? Please find my sample attached: https://drive.google.com/file/d/1Yil9aZj5mkiTQi7lbvDJfFejWKQE4YTl/view?usp=sharing Thank´s

Hi,  I have an excel spread sheet that i have to read and load into a database table. The structure of the excel sheet is different from that on the database. Sample screen shot of the excel spread sheet is seen below. Columns J-S are county names, and the values associated with it are the cost for each county.I need the 10 county column names loaded as values into COUNTY_CD column in the database and its associated county cost value loaded into database column COST_PER_SQFT. So, for every row in the excel spread sheet I will have 10 rows in the database and each row represents data for each county. The database columns and the values to be loaded should like belowI had looked into several post that does transpose of columns, pivot tables etc, but I couldn’t find a solution that works for me. Any help is much appreciated!  Thank you,lsugumar.

Hello,I have a set of pairs of points that each have a uniqueID_start and unique_end field. I am trying to extract all of the line segments between each pair of points. The tricky thing is that the pairs can be several line segments long, and have other pairs intersecting them:There could also be several points on a single spot, but corresponding to different pair sets.It’s a mess! Any help would be wonderful!

Hello FME Folks, I know that we can run multiple FME Desktop version on same Windows Machine with same licence.Can we do that with FME Server on different Windows Server machines?We have a SmallWorld DB incompatibility for our FME Server upgrade and EO SmallWorld upgrade will happen later.SO, we have to run two FME Server environment. Is that a red flag ? OK?Thanks,Vivek

Hi there,I have severale profiles, which fly somewhere in 3D space.The elevation always follows the z axis. The direction varies, but follows one direction in XY level.I started like this:BoundsExtractor get the bounds (aka rotation axis) GeometryRefiner do some geometry refining 3DRotator rotate around the axisResult:3D view2D viewred: rotation axisgrey/black: original geometrygreen: rotated geometryI expected the green geometries to be rotated around the axis, but instead they are rotated into 3d space 😵‍💫 I also tried to set the axis through the geometry (z = zmax-zmin), but with no success.Can somebody help?Cheers,Maria

I have a problem with parsing JSON which is the result of an HTTP call to get what I need. (See json files attached.)If I download the .json file and simply put it in a JSON reader with a query,filter for type:"Update Feature Attributes" and explode some of the lists, it gives me what I need:My problem is that I have loads of transactions to go through the same way, so I'd need to use an HTTPCaller. I've managed to get that far that with a JSONExtractor I can get "type", "ID" for example, but struggling to break down lists "attributesAfterChange" and "changedAttributesNames" - ListExploder doesn't recognise them as lists for some reason. Any ideas what should I do to get the list values/break down the arrays? Maybe it's very simple but I just cannot find a solution right now. NB: the attributes in these lists vary and not exclusive to what's in the attached json files, so somewhat making it a bit more complex...Any h

Hi,I have a dataset with 8 images. Look below at the images together: After using the Raster Mosaicker, the output is 1 image like this: What could I have done wrong in the transformer, or what else is necessary?Thanks.

Hello everybody,I found many discussions about this topic, but, I just want to renew this discussion. Is there any way, how to convert word (docx) file to PDF format in FME, please?Thank You so much for all tips!Lubo