General

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. U

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

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)

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>

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

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 v

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:Excep

How to setup connection to Azure using MSSQL_AZURE which requires "Azure Active Directory Authentication" FME MSSQL_AZURE is lacking such option. We need "Azure Active Directory - Integrated" as Authentication

HiI have a travelling salesman use case, where a fleet of perhaps 2-4 vehicles need to reach a set of locations in a municipality. I have used the shortestpathfinder before, but not with multiple agents/vehicles. Is that possible (finding the optimal plan for, say, 3 vehicles for an address list)? I found https://engage.safe.com/blog/2016/11/fmeevangelist158/, but it doesn´t mention more than one vehicle.

Hello , i have many start node and several end nodes and network that I am using as input for shortest path finder .My problem : i have found the paths that I want from start to end . how could I remove the overlap parts of path ,because i have found that some paths uses the same network to reach different end nodes .there are intermediate points locates on the network ,so I would like to know the id of each point (from direction start node to end node ) . as example , the next point after start node has id 389 then next 490 then next 999 then …… i would like to know ( 389 connects to next 490 and 490 connects to 999 till reach the end of the path )fme 2021 thanks for help .  

Hi, I'm trying to create ECW mosaic from multiple ECW files. It's trying to mosaic 3693 ECW tiles. I have a floating licence for FME.  This is the workflow I'm running. Below are the errors I'm occurring: 2023-07-10 20:42:10|24575.6| 0.0|ERROR |ECW writer: Could not open compression task Output image size exceeds license2023-07-10 20:42:10|24575.6| 0.0|ERROR |ECW writer: Failed to write dataset. This may occur if you have insufficient privileges to write this file, or if insufficient disk space is available2023-07-10 20:43:13|24638.5| 62.9|ERROR |ECW writer: An error has occurred. Check the logfile above for details

Anyone help me out to extarct the data from this pdf please

As you can see, when I extract the data, it's showing me all "advrnum" with "td". but when I merger them so I get only one recoder of Advr 8  I need all rows.