FME Form

I want to remove all the extra pipe delimiters after the data. I would do it manually by I have over 10000 records. Please help.

It seems that any file with a # in the filename won't download when using the SharePoint online connector transformer. I want to download using the _fullpath method.  Simply --> if the filename is FOO_1 it works. If it's FOO#1 it doesn't. The rejection code is SHAREPOINT_ERROR , the URL it's trying to DL is:SharepointOnlineConnector: Error making request to https://graph.microsoft.com/v1.0//sites/ac[HIDDEN]%20November%20#4.jpg: The resource could not be found.Is there any way to get around this? I have tried the URL ENCODER and STRING REPLACER transformers to try and manually encode the # symbol but it doesn't like this. Presumably because it's trying to encode it "again"

I am trying to set up a hive connection and have followed the instructions in the docs.The issue is an error being thrown with a cryptic meaningCould not open client transport with JDBC...Invalid status 21Has anyone seen this before and have any pointers.  I've tried using generic jdbc driver and the one that shipped with HIVETrying to find a JAVA plugin for reader named `APACHE_HIVE'Hive Reader: Preloading JDBC Driver Class 'org.apache.hive.jdbc.HiveDriver'Hive Reader: Creating connection using connection string 'jdbc:hive2://x.y.z.a:10000:' and properties '{user=XXXXXXXX, password=************}' Hive Reader: Driver class 'org.apache.hive.jdbc.HiveDriver' is being loaded from '/C:/Users/XXXXXXXX/Documents/FME/Plugins/Java/hive-jdbc-3.1.3-standalone.jar'java.sql.SQLE

New to the API world. I am trying to use HTTPCaller to auto-attach a pdf file as a response.I managed to use HTTPCaller to get all requests and auto-generate a response. However, I am unsure how to physically upload the file through the POST method. Here is the link to the API document: Enquiries API (1100.com.au)My HTTPCaller parameters:I keep getting: "HTTPCaller_4 (HTTPFactory): [1]: HTTP transfer error: Stream error in the HTTP/2 framing layer" error code.

How could I extract only the string text before unknown digit numbers in specific column .but if the string start with digit numbers so keep the beginning numbers and remove other digit number at this value . or other method :i would like to remove any numbers at specific column and any letters and characters come after it . if the string start with digit numbers so keep the beginning numbers and remove other digit numbers at this column . my column includes :hghkdkfke 24a jdklfllfv 22-23 45jdkdkkf 22 ( djskkr) Target hghkdkfkejdklfllfv45jdkdkkf FME 2021Thanks in advance

Trying to automate some ArcGIS Server monitoring and am struggling to get a token using HTTP Caller. I think there may be a bug on the ESRI end (surprise!). But before I post on their forum, I wanted to pin the FME world. I'm making a POST to here:myserver.domain:6443/arcgis/admin/generateTokenwhich is the same place I go for manually obtaining a token. As query parameters I have:client : requestipf : json as Headers:Content-type : application/x-www-form-urlencoded Accept : text/plainI have tried both putting username/password in Body and Query. Neither works. If I grab a token manually and pass it in the HTTP Caller as parameter, I have no trouble making a connection to the same URL. Has anyone gotten this to work, or has a clue where I'm going off course? Thanks

In preparation for publishing and running a script on Fme Server, Iam writing the pathnames as follow in fme dekstop for the seed and cell files. The cell file is not red, while on the other hand the filename is not recognized for the seed file.I am not quite sure why that is the case. In the normal writer of v8 this doesn't occur, but then I face other problems in terms undefined macro. The problems don't occur when I use hard pathnames, but then they are not useful when I publish the script to FME server

Hi , I have this attribute extracted from an url ressource:<div class="bs-contact__image bs-fixed-size bs-asset--landscape" id="SP-MzI5ODA4MzUx"><div class="bs-fixed-size__raiser" style="padding-top:66.5625%;"><div class="[ js-bs-lazy-image-loading ] [ bs-fixed-size__content ]" data-noscript=""><noscript><div class="bs-contact__picture bs-fixed-size__content"><img alt="Foto:  / Rothe" class="bs-contact__picture__image" src="/leben/schule_bildung/schulportal/schulen/schulen/Abendgymnasium.JPG.scaled/7c140d3a1b0bf9ced7d5c55d4b3864ba.jpg"/></div></noscript></div></div><figcaption class="bs-asset__caption"><span class="bs-asset__caption__copyright">© Foto: / Rothe</span></figcaption></div> <div class="bs-contact__content"> <header class="bs-contact__header"> <h3 class="bs-contact__headline"> Abendgymnasium </h3> </header> <div class="bs-

Hi everyone, I want to use an API via the HTTPCaller. The authentication is done via an API token. Is there a way to securely store the API token like the username / password combination within a Web Connection? We place our created FME Workspaces in a git repo and don't want to put any authentication data there .  Thanks for your answers in advance. :-)Peter

It's been a while since I posted but I am doing something different and after spending some time looking in the forums for a solution, I thought I would just post it.  It's probably something simple, but I have limited experience with FME. I downloaded a GPX file from my bike computer and want to do some data processing on it, but when I view the file in FME Inspector, I am missing the "power" attribute which appears in the GPS as shown below.     <trkpt lat="43.7513380" lon="-80.5606200">    <ele>335.6</ele>    <time>2023-01-07T13:02:24Z</time>    <extensions>     <power>36</power>     <gpxtpx:TrackPointExtension>      <gpxtpx:atemp>20</gpxtpx:atemp>      <gpxtpx:hr>89</gpxtpx:hr>      <gpxtpx:cad>51</gpxtpx:cad>     </gpxtpx:TrackPointExtension>    </extensions>   </trkpt>

I used the 2021 fme workbench emailer. The version from 2021 was functional. It is currently not functioning in the 2022 version. It displays an error message that reads, "No module called Chardet." The 2022 version had to be deleted, and I had to return to the 2021 desktop.

Hi, It's not entirely clear whether this has been solved or not already. I'm using FME 2022.1. I have a portal feature service with has jpegs as attachments. I want to read the exif metadata from the blobs. jpeg_exif_gpslatitude jpeg_exif_gpslongitude jpeg_exif_gpsimgdirection If I use the RasterReplacer method I lose all exif metadata. 

I can read tables from salesforce without an issue so it's probably not a credentials problem. But I am trying to write a record from excel to a table in salesforce and I am getting a 400 error. The error messages are pretty vague, only that it fails to write and that the Create Job Must be a POST. Any idea what would cause this issue? Do I have too few fields in the table that would otherwise be required?  Received HTTP response header: 'HTTP/1.1 400 Bad Request' from [salesforce instance here]Salesforce: HTTP 400SALESFORCE writer: A fatal error has occurred. Check the logfile above for details... Last line repeated 2 times ...Translation FAILED with 5 error(s) and 1 warning(s) (1 feature(s) output)  <error xmlns="http://www.force.com/2009/06/asyncapi/dataload"

Building a data prep workspace. Have only got 2018 desktop, not Server. I have created a (long) list of feature class filepaths from network-located ESRI FGDB's. These feature classes mostly have differing attribute structures, and there are hundreds of possibles (although only a few dozen being updated at any one time).  Is it possible to use Filecopy writer to a) copy the entire feature class based on a filepath pushed into the writer, b) write it into a new FGDB in a Feature Dataset (name specified by a feature attribute) and c) (preferably) zip it up?  New structure would be : FGDB1.gdb feature_dataset1 feature_class3 + feature_class5 + ... (Eventually, this will go up to Azure blob storage, but there are some permissions obstacles at the moment, I think.)  If it is possible, any suggestions on how to configure the writer would be gratefully received.

In QGIS there is a tool to create channel networks across a LiDAR surface. Is there a similar tool or process in FME?

Hi,i tried to merge multiple lines into only one line, but the difficult is, that also connected lines on a course between start- and end-Point should be merged into the "one line"with linejoiner the lines were only merged until the next Connection.has anyone an idea?

Hello, I need to use a variable in INLINE QUERIERThis is valid SQL but I can't get it to run in FME. The print is just for testing. I would ultimately use the variable as a concatenation string. DECLARE @ccount as varchar(20) set @ccount = (select top 1(CYCLE) from CYCLE) print @ccount 

Hello!I connect our Esri Enterprise to my fme workbench and server with the help of the guide here.  But a very strange thing happens: after I close the file, for example at the end of a working day, the connection to the enterprise resets, and the same connection that worked yesterday, no longer works today.So the first time I did the whole process again, and the second time, it doesn't connect at all anymore.Anyone familiar with this problem?

Hello,I have a 2D set of points within which I want that no pair of points stay within a distance inferior to a threshold of my choice. The supplementary points have just to be deleted. How can I perform that? Thank you in advance.

Hello,I would like to create the Geojson output as shown below:{  "type": "FeatureCollection",  "name": "Example_Dataset",  "crs": {    "type": "name",    "properties": {      "name": "EPSG:28992"    }  },  "bbox": null,  "features": [    {      "type": "Feature",      "properties": {        "Name": "AO1",        "Begin K": "0",        "End K": "2.196"      },      "geometry": {        "type": "LineString",        "coordinates": [          [            143267.805,            559438.354,            1.944,            0          ],          [            143268.356,            559439.188,            1.987,            0.001          ],          [            143268.907,            559440.023,            2.029,            0.002          ],

I'm trying to use FME purley through Python and have successfully executed the "WorkspaceRunner.py" sample code, calling it via FME:fme.exe python fmeobjects/samples/Python/WorkspaceRunner/WorkspaceRunner.pyI have since tried to create my own program but which throws an exception that I would appreciate to get some guidance on. Here my code: import osimport sys os.add_dll_directory(r"C:\Program Files\FME")sys.path.append(r"C:\Program Files\FME\fmeobjects\python39") import fmeobjects runner = fmeobjects.FMEWorkspaceRunner()workspace = "testWorkSpace.fmw"runner.promptRun(workspace)Error message:fmeobjects.FMEException: FMEException: 1: Failure running workspace 'testWorkSpace.fmw'Importing the FME modules seems to work and I'm using the same interpreter as with the WorkspaceRunner.py sample. "testWorkSpace.fmw" is an emp

I am trying to access a SOAP service that is password protected. In Soapui I had to set the WSS-Type to PasswordText in order to get the result I wanted. How can I duplicate this in FME desktop?

Hi,I posted this earlier on the Package page, but I'll paste it here to be sure to get an answer.  So, I get this error while trying to authenticate with my Google account: Authorization Error Error 401: disabled_client Sign in with Google temporarily disabled for this app. This app has not been verified yet by Google in order to use Google Sign In. Learn more Request Details The content in this section has been provided by the app developer. This content has not been reviewed or verified by Google. If you’re the app developer, make sure that these request details comply with Google policies. access_type: offline approval_prompt: force response_type: code redirect_uri: urn:ietf:wg:oauth:2.0:oob client_id: ERASED.apps.googleusercontent.com scope: 

Hello everyone.I have a problem with writing an SDE database that sits on top of postgis DB.I manage to connect in the FME to the database both from the postgis / postgres readers and from the sde reader.I can read the data, the problem is that I can not write properly.I want to update the database, and no matter what I do, I do not see the changes in th database.It is divided into two parts:When I write directly to postgis, I have a lot of warnings, but I was told that Total Features Written 1As it should be.But in practice I do not see the changes in the database at all!And when I write down to sde, it gives me lots of Errors, but Total Features Written                            1 as it should be,but still no change in the DB.I tried every possible variation in feature operation, insert, update- and nothing changed.Only when I did an experiment with delete, it managed to delete the features for so

I have a road center line and private properties beside(left and right) to road center line.I want to find out the distance between the road centerline and private properties (perpendicular to the road centerline)both the sides(left and right) for every kilometer. Generate points along the road centerline for each kilometerCalculate perpendicular distance from a point to private property polygons(left and right)Add attribute left1=min distance (left property polygon and right1=min distance to private property right side