FME Form

When attempting to load in a VRT Raster, created with GDALBUILDVRT that is in Int8 Format, FME says it is invalid. I am licensed to use the VRT format. I am using FME 2021. I am using the correct VRT Raster format when loading it into my workspace. It seems rather strange that FME would not support VRTs in Int8 formats. I am using GDAL 3.7.1-1 to create my Raster VRT's. Either using the commandline tool directly or manually creating VRT's in QGIS results in the same error.  GEOTIFF writer: Setting feature type level option 'geotiff_compression_method' to value 'deflate' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option 'geotiff_jpeg_compression_level' to value '25' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option 'geotiff_deflate_compression_level' to value '6' for feature type 'changedetect'GEOTIFF writer: Setting feature type level option &#39

When using the AzureEventHubsCOnnector to receive in stream mode, the documentation states "Stream: The connector continues to receive messages indefinitely. The translation needs to be terminated in order to stop reception." Am i missing something here? how do you send a termination to it? In python this is straightforward...

I have a FME workbench open. Then I open a pdf in Adobe Acrobat Reader, and zoom in. Then I return to my FME script, I can not add any transformer to my script anymore. There is only a tiny box instead of the usual dropdown list. It is a bug. I tested it several times to make sure it is an issue. I am using FME 2022.1.

Dear All, in the attribute "id" I have strings that have the following format411d8e4d-2de6-0f5b-e100-00000a4c0a0dI would like to remove the dash in an AttributeManager (I know, I could do it with StringReplacer). I've tried the following formula :@ReplaceString(@Value(id), "-", ""))but it does not work (id remain unchanged), whereas the formula with FindString here below gives the expected result (8).@FindString(@Value(id),"-") Why the FindString is working but not ReplaceString ? What am I doing wrong ?I was also able to do it in the regular expression-way, @ReplaceRegularExpression(@Value(id),"\-","") but I don't understand how ReplaceString works. Has anyone an explanation ?Thanks in advance

Here's a simple table creation process with FeatureReader and FeatureWriterFor a value list table.The structure is the same and provided from the source tableAutomatic Attribute definition-> The primary key is not set CREATE TABLE IF NOT EXISTS eau_potable.vl_polygones(    id integer,    name character varying(200) COLLATE pg_catalog."default",    color character varying(20) COLLATE pg_catalog."default",    active boolean,    CONSTRAINT vl_polygones_pkey PRIMARY KEY (id))Manual Attribute definition (only manipulation is uncheck the automatic to manual) -> The primary key is set successfulyCREATE TABLE IF NOT EXISTS eau_potable.vl_polygones(    id integer NOT NULL DEFAULT nextval('eau_potable.vl_polygones_id_seq'::regclass),    name character varying(200) COLLATE pg_catalog."default",    color character varying(20) COLLATE pg_catalog."default",    active boolean,    CONSTRAINT vl_polygones_pkey PRIMARY KEY (id))This would be a nice thing to fix because I think everythink is known 

Hi, After creating a simple Geopackage (one Table named '01004nnu') with the OGCGEOPACKAGE Writer with FME Desktop, I want to UPDATE Attributes in this Geopackage with a second workspace using the SQLExecutor. Error message:"OGCGEOPACKAGE reader: In ExecuteSQL(): sqlite3_step(UPDATE '01004nnu' SET col1 = '1' WHERE col1 = '8'):  attempt to write a readonly database" The Geopackage ist not used by another process. SELECT Statements do work with the SQLExecutor.     

This might be an easy one but i could not find a way around it, I have two files File A (lines with geometry) and File B CSV file(lines without geometry). Both files have ID,START,END columns as shown below. So i was wondering how can i merge them on ID as the first key and also specify the range of the start value as the second key, (any other approach is welcomed)so what i expect is the first two values of FileB be given geometry from the first value of file A, and the third value of FileB be given geometry from the second value from FileA.Thanks ,Keller.

Say I have data like the following;sequence_path (string: UTF-8): 1.2.3.4As a result I wanted to fetch the parent from this sequence_path (i.e. '1.2.3'). In order to do so I wanted to do the following;Use a reverse search to find the position of the last '.' in the string, Fetch the (Left) substring up to the position of this last '.' To perform the first step, I thought to use the FindString() string function (with a negative startIndex). So, at first I thought that @FindString(@Value(sequence_path),.,-1) could be used. However, that returned '-1' (not found). However, somewhat unexpectedly at first, I noticed that '@FindString(@Value(sequence_path),.,-2) ' did return the desired value. Upon second reading of the String Functions documentation: "If startIdx is a negative integer, FindString() returns the index in str starting at startIdx from the end of string , then matching strToFind going forward (from left to right)." I now notice that the search is still from left to right (forwa

Hello, I wish to write to a specific version in a versioned feature dataset, by default the arcgis portal feature service writer writes to the SDE version aka the main/base version. Where can I configure which version the writer will write to?  Thanks.

Hi, How can I to extract Layer and CODIGO attributes from file below: <html xmlns:fo="http://www.w3.org/1999/XSL/Format" xmlns:msxsl="urn:schemas-microsoft-com:xslt"> <head> <META http-equiv="Content-Type" content="text/html"> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body style="margin:0px 0px 0px 0px;overflow:auto;background:#FFFFFF;"> <table style="font-family:Arial.Verdana.Times;font-size:12px;text-align:left;width:100%;border-collapse:collapse;padding:3px 3px 3px 3px"> <tr style="text-align:center;font-weight:bold;background:#9CBCE2"> <td>232400481803401</td> </tr> <tr> <td> <table style="font-family:Arial.Verdana.Times;font-size:12px;text-align:left;width:100%;border-spacing:0px; padding:3px 3px 3px 3px"> <tr> <td>Layer</td> <td>232400481803

I have 2 workspaces in the Workspaces - Test Repository. I want to move them to a different folder. In the Test Repository, I checked the box to the left of the workspace name, and under Actions there is no option to move a workspace to a different folder. What is the best way to achieve this? 

Hey there,I have to download several CSV Files from a website. I do it with the HTTPCALLER Transformer. It works perfect. I get ALL the data (several columns and lines) in one "cell":I need the informations in lines and columns, so that I can manipulate the data. I have tried with Pythoncaller, ListExploder, AttributeCreator,... but it doesn't work.Do you have any idea, how can I get that? I think the problem is the configuration of the HTTPCALLER or of the other Transformers but I have tried a lot of things and nothing works. Many thanks in advance! 

I've got a grid of polygons, each square is equal in size but has an attribute stored against it with a numeric value. I want to group grid squares together based on a sum of that attribute, but that sum needs to be as close to an upper limit as possible. So for example in the picture below all 'like' coloured grid squares are collected into groups where their attribute sum does not exceed 60,000. As close to 60,000 as possible would also be acceptable. I can't have disparate geographic groups, it has to be one block of squares, albeit that block doesn't have to be completely uniform.When I started looking into this I thought, this must have a "name", an existing algorithm and "I bet there's already a custom transformer"... Well, I haven't found anything yet. Can anyone help put me out of my misery? This feels like a loop might be required, but the issue is the proximity, the grid squares might need to be pre-sorted geographically first?

I have two POST API calls to the Microsoft Graph API in my workspace. The workspace functions as intended on desktop ,but when I upload it to FME Server the POST call on the second HTTPCaller will fail saying that there was no token provided (message below).  "message":"Access token is empty.","innerError" How can it work on one POST call and not the other when its using the same Web Connection? Also why is it functioning fine on desktop and not FME Server?  Thanks

Hi Darren. I'm a new user of FME and am interested in your 2014 post about translating to DWG as 1km grid squares. Do you have anything you could share that would help. I see in the post you say you got it working. ThanksChris DickinsonNorth Yorkshire County Council

PDF to SHP with Text embodied in pdf

Hi,I am trying to put query where clause in feature reader. the reader data is from esri Portal Feature Serice. I would like to put bounding envelop into where clause. I am not sure what is the clause should be. I would not like to query them all then do intersect. i would only like to query everything in the box I defined. the clause i am using somehting like:geometryType=esriGeometryEnvelope&geometry=1.6407885025300004E7,-4272238.302200001,1.6703666006300002E7,-4088621.626699999. it didn't workI would like to know:where clause support extent clasueif so what is the correct the clause structure. Thank you very much.

The error message shown is "XML Parser error: 'unable to open primary document entity '\\1_Src\\Bag\\Inspire_data_NLD\\9999STA*.zip''Failed to obtain any schemas from reader 'GML' from 1 datasets. This may be due to invalid datasets or format accessibility issues due to licensing, dependencies, or module loading. "

In FME Desktop* I'm upgrading attribute transformers to latest version. The most significant change seems to be that now attribute types are specified. In the case of SQL Server and `varchar()` varchar takes a a width parameter. FME appears to be suggesting values based on the input stream from a cached run, which is very helpful. However I don't know for sure the present input stream represents the possible range in the source.  In this example we see AttributeManager showing wide variety of specific integers in varchar() width: 80, 7, 969, 95, 43. What do these numbers represent? Are the exact measurements of current input? Are they padded a little bit for insurance? Do they take into account if the input is high UTF-8, and thus need 2-spaces to encode 1 character? Most importantly from work productivity perspective: is there something I can do to adjust all these numbers by X percent or value instead of clicking each and every one of these values and then typing a number acr

Ok, I've been all around the Interwebs, SAFE Forums, Reddit, etc... I'm stuck with what seems to me a simple problem. I have a bunch of photos taken with a DJI Mini2 and I want to creat a mosaic with FME (without any third party apps or program). My photo all have x,y coordinates because I can create a point cloud with ArcMap (raster to point) and every point land in the right place.  Now in FME... I've tried lots of transformers and the results is always the same; all the photos are in the ocean and on top of eachothers. Isn't that what "RasterMoasicker" should do??? ArcMAp 10.4.1 (but have access to ArcGIS Pro)FME 2021 32/64 bits SO... I'm sure it's doable in FME... Can you guys help me? Thanks in advance! :-)

Hi all I have buildings polygones with height attribut. when the height was calculated some of buildings were cutted in two. So now, I would like to dissolve those buildings and keep the max height of both. I can dissolve easily because they share an identificator, but I dont know how to keep the maximal height of both.  Thanks you all

Hmm, I am struggling with this for a day now and I tried the tutorials, but it seems I am doing something wrong.So, basically I have an xml file out of which I want to put certain elements into an Excel output. But here is the issue.I want those outputs in a certain order - and no matter what I do, FME will always write the columns into alphabetical order. Which just will not do for this application. The transformation is a simple one: But somehow I always end up with the same output.As You can see, I already renamed the attributes with the numbers, trying to sort it that way, but no matter what I do, the output then looks like this:(Also with those weird widths for those columns) Can this be somehow changed? Thanks so much in advance.

I am upgrading from FME Desktop 2016 to 2021.2. I am facing a issue with my FME script, getting error as "SCHEMA_DATASET" not found. I don't want to supply data set sometimes so haven't fixed it's value. In my script I have only one schema reader and it is causing issue as I see I can't give null dataset to it.I have tried enabling "Ignore Failed Readers" to yes and "Rejected Feature Handling" to continue translation.Any help would be appreciated

Our supplier has changed their API and are now using OAuth. I'm struggling to connect, mostly because they are very unhelpful about what is needed in the Header and Body to access the credentials API I have been given this information:access token URL https://ashridgeidentityserver.azurewebsites.net/connect/token OAuth 2 with Client CredentialsClient ID : AG_WaternetAPIClientClient Secret : **********Client Scope : AG_DatabaseAPI And a screenshot from their POSTMAN service. Can anyone help me set up the HTTP Caller? I have added the client secret to a Bearer Token thus far but just get "bad request"  

Hello,I have an error when trying to use a costum transformer : FME Flow version : 2020.2.1FME Form version : 2020.2.4Error : The custom transformer was created with a newer version of FME Workbench All jobs created under the more recent version work perfectly on FME Flow.There is just the transformer who causes this problem.Could anyone explain to me why this happens ?@david_r​ or @Hans van der Maarel​ ?Thanks a lot.