Best Answers

Bulk copy failed on table 'tv.vagnat_framtida' using delimiter ':'. Error was 'ERROR:  invalid byte sequence for encoding "UTF8": 0xc3 0x3aCONTEXT:  COPY vagnat_framtida, line 33This error kept me busy for some hours exploring character encoding in shapefiles, FME and PostGIS. Which did not help. Not until I did some data digging and found the error.The data in a shapefile apparently comes from a qualified geodata store, and some long text fields have been truncated in the conversion to shape, leaving what appears to be incomplete character codes. And this causes PostGIS problems. The error message comes from deep within PostGIS. I have tried to cut a few bytes from the string with SubstringExtractor, but then the whole string became HEX. Very strange. Since it is invalid data, there seems to be no way of catching these characters with any of the FME string tools. And the error appears only in the Postgis writer, not before so it cannot be logged.Basically, I am looking for suggestions

I am trying to set up a database connection to my Snowflake 30-day free trial account. The connection parameters are shown below. When I test the connection, it takes a long time (about 5 minutes), and then get a Read timeout error as shown below. I have no problem login to Snowflake web console using https://IN17188.us-east-2.aws.snowflakecomputing.com. I use the account "IN17188.us-east-2.aws" in the FME database connection Account Name parameter. I use FME Desktop 2021.1.1. Anybody experienced this issue? I just try to follow the FME - Snowflake tutorial - https://www.safe.com/training/recorded/connect-data-even-geospatial-snowflake/ net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver encountered communication error. Message: Exception encountered for HTTP request: Connect to IN17188.us-east-2.aws.snowflakecomputing.com:443 [IN17188.us-east-2.aws.snowflakecomputing.com/3.20.44.68, IN17188.us-east-2.aws.snowflakecomputing.com/13.58.248.132, IN17188.us-east-2.aws.s

Can'i catch the contraints oracle with the FeatureWriter? I need to test the integrity of oracle and catch the exception and do something if an error occure.Execution of statement `UPDATE "MYTABLE" SET "STATUT_PRP_R" = :"STATUT_PRP_R" WHERE "OBJECTID" = :"OBJECTID"' did not succeed; error was `ORA-02290: violation de contraintes (PRP_AQU_BORNEINCENDIE_P_CHK) de vérification'. (serverType=`...

Hello FME Community,I have a shapefile that contains an ID column. the ID must be unique, but I have data records that have come twice.Only ID is the same and other columns are different.with DuplicateFilter I filter Duplicate. so I get features that came twice. I would like to know that which feature with which feature have the same ID.Thanks in advance for your help.

I know the possibilities of headers, italics and bold in creating the workspace app, however I was thinking it would be also nice to give some text different colors. I was trying the markup code from the following stackoverflow link, however the text didn't appear in color on the workspace app :(. So I was wondering whether it's possible to style text in color in the workspace app.  I tried the following methods:<span style="color:blue">some *blue* text</span>.$\\color{color-code}{your-text-here}$ 

Hello,I have a point dataset and I want to make an algorithm that operates like this:(1) Select a point;(2) Remove all surrounding points within a distance, entered as a fixed parameter (eventually this can be done using a bufferer + spatial filter);(3) Store the first initial point in a new dataset and repeat the process for the remaining dataset from step (2) to obtain a second point that will be stored with the first one and so onThe final result is to obtain a point dataset where no distance below a threshold exist ALONG WITH preserving the maximum number possible of pointsThank you very much in advance ! 

As the title implies, I have a workspace where two different workflows have to write to the same CSV but different sheets. How do I go about doing that? I've attempted to use fme_feature_type as CSV File Name but that resulted into 2 separate CSV files as depicted by the image attached  

Hi! I'm desperately trying to find a way to identify the impact of disabling a specific network on the surrounding networks. So far by using the NetworkTopologyCalculator, I've been able to isolate all my water networks, separated by water valves. But here is an example of what I'm trying to do:If I have to replace the water pipe on the network A, I will close the water valves to isolate it. The impact would logically be that there would be no water reaching networks B-C-D-E. Is there any way for me to dynamically identify this in FME?Thanks in advance for your help!

Hello all I have a question regarding readers when used with possible empty directories and resulting error messages. In a FME workbench, a CSV reader reads all CSV files within a directory and then processes them. If one or more CSV files are present in the defined folder, the Workbench works perfectly. However, if there are no CSV files in the folder at the time of execution, an ERROR is issued:ERROR |CSV reader: Failed to open file '\\\\Auto-Import\\**\\*.csv' for reading. Please ensure that the file exists and you have sufficient privileges to read it. With the FME Desktop version 2019.2 that we are currently still using, I was able to set the Workbench to continue running even if an error occurred. However, this is certainly not the most ideal solution. Especially it is difficult to detect actual error messages in the log files.The Workbench is automatically executed every hour by the task scheduler. Another problem is that the CSV Reader is part of a Workbench that is sup

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-contact__section bs-contact__sec

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 do get the time, temperature, hr and cad, but not <power>.I expect it has something to with the fac

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. 

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.

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 empty workspace.I also found that when executing WorkspaceRunner.py without going through fme.exe i get the following error:FMEWorkspaceRunner: Error in dialog creation duri

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

Hi everybody, I have 6 values which are standing for colour values for making maps. So each number is standing for a colour. The values are always the same and the numbers are 59, 63, 70, 72, 76 and 77. I have a lot of polygone ESRI shapefiles which are showing the administration of each country (OSM Data for example the states of India, which is the first administration level of India). To have the same style in each map for printing, I would like to use the colour values (59, 63, etc.) for every administration of each country. So each shapefile has a attribute field which is called "colour value". Now the tricky part is: the polygons (so the states of India) should have always one of the values, but the direct neighbour state should have always another value. Otherwise the colour of the states are the same of maybe two of them, which are neighbour states, and you can't see directly the difference on the map after colouring. I put some picture in the attachment, where y

Hi, I have lots of large raster datasets that I want to resample and save as PNG. The problem is that their rotation is wrong, and trying to modify the angle according to the image properties gives incorrect result. The images are oblique images.The raster in geotiff format read into FME:Doing no rotation gives this result in the final png: The image after rotating it.  RasterPropertyExtractor gives _rotation_x=222.30258951435636 and _rotation_y=223.52422211966618. None of these values give the desired result with a straight image. Does anyone have any suggestions? Or is there a simpler way of doing this? Reading the image and disregarding the rotation?

Hello , i would like to combine different values from different attributes then add them in one cell and write string text +value of specific attribute 1 then add new line and write string text + value of other specific attribute .How could I achieve it ?thanks in advance FME 2021

We have some automatic data-updates on an ESRI File Geodatabase. I also want to update some parts of the metadata also automatically as part of the update procedure. I want to change Edition, Publication date, Revision date and dataset ID. I succeeded getting the right information to insert in the XML updater, but the XML updater doesn't seem to do anything in the metadata. I don't see any result. Could anybody help me out? I added the workspace to this question.  Addition 9/12/2022:I just discovered that, if I fill out these fields manually in ArcGIS Pro, that this information is not found in the metadata that is read by FME. This is what's filled out and seen in ArcGIS Pro:I used the mehod with the XML Formatter to see what's in the metadata, and this gives the log attached. You'll see the information shown in ArcGIS Pro, can not be found in the XML read by FME.Exporting the metadata out of ArcGIS Pro to XML, contains other (and right) information: <identificat

Using PointOnAreaOverlayer, I would like to know how to extract polygon IDs and assign them to corresponding points that are within each polygon.

Happy New Year all. Can anyone please how can I change a date column (dd/mm/yyyy) from string to date time format within a workbench. The column is originally coming from a CSV file but after reading in FME, its getting converted into string. I want to apply test filter to get values within a certain date period but because the date is in string, I cannot do it. Do you have any idea how to resolve the issue? Thanks in advance.

I must use the http caller transformer to obtain the token value from the rest end point.However, I am unable to connect via FME. postman returns valid output. I get a notice that reads "invalid clientid or secret," but when I use the identical parameters, Postman returns the response body. Why is FME unable to make it happen?I made numerous adjustments but in vain. kindly assist

What language does the text editor in the AttributeManager Transformer use? is it SQL, Python, both, or ?

Hi,I'm trying to extract XML from the attached file. I'm using an XMLFormatter before hand which extracts the loggerId I need to match to a database table.I can extract the XML using the fragmenter, but unless I use the 'Merge Attributes from Input Feature' the loggerID is not carried through. If I do this. FME managed to burn through 700GB of my hard drive and then fails due to lack of memory.Any idea how I can carry through my original XML attributes through to the fragments without having to do this?