General

This is my first time using FME to update a database, I usually just write to another file.  I have connected to a specific table in the database (multimedia objects) and I've basically filtered and done a string replacer on some instances in a specific column (product_uri).  How do I now save these changes in the database? I just want to replace the 156 cells I string replaced and keep everything else as it was. 

Hello, I think the answer is easy but I don't know how to do. For each fme_basename value, I want to copy the B3 cell value to the B1 cell.Thank you !

I would like to input only 1,000,000 features at a time from a single 60,000,000 feature dataset (Parquet) to a workspacerunner. Can I use featurReader for this? I could select features based on attributes (dates or names) but I cant proces the data per tile or a spatial filter.

Hallo ,i have read an article about RMinimumSpanningTree . will be possible that someone provide me a sample workspace to understand it clearly . Thanks in advanceFME 2021

I have a workspace that outputs fewer features when run from Server than when it is run from Desktop. The log files are ~2700 lines long so finding out exactly where they differ from each other is quite hard. I would like to feed the log files to a diff & compare program like WinMerge but the number of inconsequential differences between log files are too high. Even after removing timestamps I'm still getting hundreds of differences. How to search/parse/transform/rewrite the log files so only the notable differences are apparent? For example it doesn't matter that the path of DLLs are in different locations (in this scenario, in others it will be). It also doesn't matter that hundreds of HttpCaller download requests differ by a few milliseconds and/or 1 byte. However it very much matters the total number of features written is 2654 instead of 2658. 

Hi, I have a question regarding the “create spatial index” option in the spatial database writer for Oracle.If you’re truncating an spatial table with an existing index. Do you still need the create index option on or is it redundant? And if not, is there any performance loss in keeping it on?

Hi, does anyone know the meaning of this error message I keep getting:An error occurred. Here is the information that FME was able to find on the error. Skipped 1491038/1512811 rows in column recordid.Does the problem lie with features number 1491038 until 1512811? Or any time comumn Recordid has value between 1491038-1512811? Or only feature 1491038 of 1512811 features. It's an error I keep getting and those exact numbers come up. The dataset I am trying to reed is a Parquet dataset. 

Hi, I have a workbench that processes data of X number of rows. At the conclusion I would like to send an email to summarise what was done. I would love something like: Hi Ben,  We have just updated the table with 32 new rows. Here is a summary of the data added: ASSET ID | NAME | DOB 150 | Ben | 02/02/1992 151 |Tony | 01/01/2001 .... .... 183 | Michelle | 03/03/1983I have added a statistics calculator to my workbench, this is currently able to give me the summary (total number of rows) to include in the opening sentence, but I am not sure how to add the 32 rows to the email, formatted as a table. I know this has to be such a simple task, I just cant work out how to do it! Thank you.    

Hello , i would like that each point to find the neighbor point .each point connects with other by a line .so I have a starting point ,i should find the neighbor point and the neighbor point find the next neighbor and so on .my problem : how to let each point to stop looking for the neighbour point if the next point is a starting point because some points are connecting to starting point FME 2021

Hi, what is the best way to avoid loading in a complete huge singel Parquet file (58 million records). My memory keeps running out. I have the option to split the data into smaller pieces with a Tester transformer selecting the data on date and then saving it to further process, and have done that with a child-parent workspace, and a tester + published parameter for the dates. But it still seems to go wrong due to memory problems. The process takes very long to save by date, especially loading in 58 million records before running the data through the tester. I would love tips on splitting up the data before loading in the complete 58 million records. or any other tips for dealing with Parquet files.  

I get the following error when I feed XML as an attribute from the XML updater. Reading in an XML file is no issue though.This FME edition does not recognize the `' function. Please ensure that the current platform supports this function, the function name is spelled correctly, and that you have installed all required plug-ins 

Hello , i am new with working with geospatial pdf files.I have Problem that geospatial pdf has no real coordinates .My pdf consist of lots of building ,i am asking if I provide one building with real coordinates manually Will be possible to change coordinates of all other building to real coordinates automatically .what should I do to change coordinates of pdf to real coordinates ,any ideas ?Thanks in advance .FME 2021

Hello ,How to open file has extension pfd or DGS format from power Factory DIGSilent ? The only exporting format from power factory is PFD or DGS ,There is no license or other option in power factory to export other formats .is there a method to open PFD or DGS file in FME and export the data from it ?FME 2021

Hello I'm creating a bespoke solution whereby the bottom of the page shows the Workspace App. The FME App will basically allow staff to submit comments. I've used an existing App for testing purposes which required the use of SSO (Azure). The Workspace App URL is simply enclosed within an iframe tag. <div class="embed-responsive embed-responsive-16by9">  <iframe class="embed-responsive-item" src="https://fme.mole-valley.gov.uk/fmeserver/apps/SubmitComments" allowfullscreen></iframe></div> The page shows both contents so all good.When I login as usual, it loops back to the log in page within the iframe.The Workspace App works as usual on its own. So I decided to create another Workspace App which does not require authentication. Used that instead for my iframe and everything works as expected. Any ideas / pointers?FME Server v2023.0.0.3 ThanksSameer

I'm querying a table with geometries (PostGIS) and the resulting geometry column when run through a GeomtryReplacer just ends up with an empty geometry. The encoding is Hex Encoded OGC Well Known Binary. If I copy the string (with copy paste) into an attribute creator then the geometry gets replaced.  The only differnce that I can see is that the string attribute from the SQLExcecutor is encoded as utf-16LE and the attributeCreator string is in UTF-8. It's kind of strange because another geometry column in the same database comes in as a utf-8 string.  It's an envelope. This is the string/geometry in question:01060000A0E86400000100000001030000800100000005000000333333335C021C41000000C052BF54410000000000A05C403333333354021C41000000C052BF54410000000000A05C403333333354021C41000000C052BF5441CDCCCCCCCCEC5C40333333335C021C41000000C052BF5441CDCCCCCCCCEC5C40333333335C021C41000000C052BF54410000000000A05C40I was previously casting the Geometry using AS_STBinary() and then replacing using using OC

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.

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

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?

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

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.

is there any way that Automatically Date and Timestamp When Data is changed

I am using FME Form (previously desktop)FME(R) 2019.2.3.2 (20200320 - Build 19825 - WIN64)I want to learn how to use a simple WFS readerThe provider is Geoscience Australiahttps://services.ga.gov.au/The WFS is National Local Government Area Council Officeshttps://services.ga.gov.au/gis/services/Australian_Coastal_Sediment_Compartments/MapServer/WFSServer?request=GetCapabilities&service=WFSThe URL I have set ishttps://services.ga.gov.au/gis/services/Local_Government_Area_Council_Offices/MapServer/WFSServerBut it does not workI get this error<ows:ExceptionReport xmlns:xs="http://www.w3.org/2001/XMLSchema=" xmlns:ows="http://www.opengis.net/ows=" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance=" xsi:schemaLocation="http://www.opengis.net/ows http://schemas.opengis.net/ows/1.1.0/owsExceptionReport.xsd=" version="1.1.0="><ows:Exception exceptionCode="InvalidParameterValue=" locator="outputFormat="> &l