Best Answers

While Converting Fbx to VRML (*.wrl) format, the coordinates are swapping. Why?

FBX is EPSG:2326 coordinate system. VRML (*.wrl) converted is (Y and Z coordinate swapped)

533

arthur_bazinContributor

FME 2022 prepare statement in SQL Executor.

This is not a real question, it's more an assesment. In FME 2022, it seams that every query run with SQL Executor/Creator is run as a prepared statement (see here for more information on PostgreSQL https://www.postgresql.org/docs/current/sql-prepare.html). The problem is that only certain query can be prepared, not every one...Some of my queries can not work anymore like every "CREATE" queries that can not be prepared into PostgreSQL. Is there a way to disable this behaviour ? For me it's a critical problem because some times we need the queries to be run as we write them, not like the database want to redefine them.

2967

choppib

How do I force a device to release a floating licence?

We have one floating licence and it is now stuck on an old laptop and won't release it. Can I force it to release either from the device or from the licence server?

6585

Writing with dataset and feature type fanout with a dynamic schema

bruceharoldSupporter

asked in Data

Hi, see the attached, I'm reading MVT Tileset and want to fan out the output file GDB dataset on zoom level and fanout the feature types too on fme_feature_type, I get an error saying the schema doesn't have the correct element, but it does! All help appreciated. The fmw is self contained, it downloads MVT tilesets (not too big).The error at write time is:ERROR |Esri Geodatabase Writer: Feature Type Definition 'bl' was requested, but not defined. Please visit https://www.safe.com/support

2222

vxn43Supporter

IMAP email set up for an Automation

I have a Fault Tolerant installation of FME Flow that includes a load balancer. I need to use IMAP email protocol to receive emails from FME Flow. I have created an automation and want it to send an email if succeeds. In the Automations screen - Email Details, I choose Actions - Send an email. I then see the SMTP parameters, but nowhere found is IMAP protocol parameters. How do I access IMAP protocol parameters if I want to Send an email?

1843

mzuerContributor

String (dash) replacement in AttributeManager using ReplaceString

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

5553

vxn43Supporter

Lettered Path vs UNC Path and Access Database

I have a workspace where the Reader reads an Access database using a lettered drive path (K:\\projects\\databases\\access.mdb) The Writer writes to the same database using the same lettered drive path. When I publish this workspace to FME Flow without uploading/selecting files, the Database Path under Published Parameters is empty. But, when I change the database paths in my workspace to a UNC path (\\\\gisserver1\\projects\\databases\\access.mdb), I publish the workspace (without uploading/selecting files) and I see the UNC path to the Access Database populated in Published Parameters - Database Path. If my workspace reads from a lettered drive path and the database is Microsoft Access, when I publish the workspace, do I need to upload/select files? This would upload the Access database to FME Server.

2302

mr_fmeEnthusiast

Extract value from text

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

1682

vxn43Supporter

Move workspaces to a different repository in FME Server

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?

1712

datamanContributor

Read CSV File and split the content into lines and columns

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!

6087

vxn43Supporter

Notifying when an automation has completed its run or not

I have created an Automation in FME Server. It is triggered by a Schedule and runs a single workspace. What is the best way to have an email automatically sent to me notifying that the automation has finished running and succeeded or the automation did not succeed. In FME Server, I see under Automations - Notifications (Classic). But I am not clear on exactly how to set up the email notification. Here is what I have done so far, and it does not seem to be sending me an email after the automation has run. Any suggestions?

1383

vxn43Supporter

Using workspace with disabled connector and transformer in an Automation

I need to publish a workspace into FME Server that has a disabled connector and disabled transformer. In FME Desktop 2021, the workspace can run successfully with these disabled. If I publish this workspace to FME Server 2021 and create/run an Automation, will FME Server recognize the disabled connector and transformer and not run them?

181

pabloolivaresmSupporter

Dissolve and keep max attribut value

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

484

nedwatermanContributor

Connect to API with OAuth credentials

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"

4158

lgrieContributor

Costum Transformer and FME versioning

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.

292

dstonenew

AGOL date format - convert to 'normal'

HiFairly new to FME!I have connected to my AGOL account and downloaded the data through the AGOL reader. I wish to change the date format from the AGOL default yyyymmddhhmmss.sssss to something more sensible i.e dd/mm/yyyy hh:mm:ss I have tried using the DateTimeConverter to output but whatever combination I try the Attribute (Survey_Date) stays the same. Any help or advice would be great

Error while running rastermosaicker.

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

411

mzuerContributor

Set to lower case all attributes that start with a given prefix

Dear all, Very simple question (sorry if it sounds naive, I am newbie to FME) : I would like to set to uppercase all attributes that start with a given prefix (or that match a given pattern). Is it possible to do that with the BulkAttributeRenamer ? Or what would be the ''cleanest'' way to do that without using custom transformers ? (NB : I know I could achieve this with a custom transformer (for example, inspired by this question), but I would like to avoid this kind of solution as then I face the tricky issue of having attributes that need to be dynamically exposed and I would like to avoid also the complicated things with schema mapping and so on...) I would be very grateful if you could share how you would implement that 😀 Thanks in advance for any suggestion

How to apply attribute alias to all features using the existing attribute name

Using the AttributeManager, i understand that i could create a new attribute_alias for each attribute i want to update. However, since there are hundreds of attributes and they all need to be named the same as the existing attribute name - except in TitleCase without underscores > I wonder if there is an easy way to do this?

323

Can an existing python library be updated on FME Flow hosted?

stalknechtContributor

asked in Flow Hosted

I'v been succesfull in loading additional python site-packages on FME flow hosted.Now I have a site-package that needs a newer verion of numpy then the one that's allready in the standard installation.Can I upgrade numpy on the FME Flow hosted environment?

Combining the output of PATH and PDF readers

What I want: I want to read a list of pdf files and write metadata of these files to a postgresql database. The attributes I want to export are number of pages, file name, file path and file id (which I create through the UUIDGenerator). I start with a PATH reader to find all pdf files from this folder through all the subfolders. The problem is I also want to add the number of pages of each pdf file to the output table and I don't think I can find this with the PATH reader. Therefore I included a PDF reader and have found the number of pages of each pdf. Now the problem is - how do I combine the output of these two readers? I have tried to use Featurejoiner and Featuremerger but both of these requires a common attribute to join on. But I can't find a format attribute in the two readers that is unique. Is there a way to index the attribute tables of each reader? Or is there some much easier way to perform this action? I have included a screenshot of my workspace until now.

XMLXQueryExtractor query

Been trying to get this working for a while, but I have to surrender... My XML:<?xml version="1.0" encoding="UTF-16"?><Surface name="Zone 101_01.01_A_020!" desc="" xmlns="http://www.landxml.org/schema/LandXML-1.2"> <SourceData/> <Definition surfType="TIN" area2DSurf="234921.542328654672" area3DSurf="238197.012906672346" elevMax="11.943587904916" elevMin="-3.839199295337"> <Pnts> <P id="2">214609.472108227172 150506.362479594914 5.162708941504</P> </Pnts> </Definition></Surface>The attribute I need is "Zone 101_01.01_A_020!". Queries I tried:/Surface/@name/string()for $c in /Surfacereturn data($c/@name)/Surface/@nameWhen I test in online extractors, it does work. When I remove the namespace it starts to work, but why?I'm using FME Desktop 2021.2.6Can someone please help?

OData reader with "$filter" parameter?

I'm new here and need to filter data from a Odata feed. The feed contains open data so no need for credentials. When I add an Odata reader and paste below URL, I can choose several feeds. The main one is named: TypedDataSethttps://opendata.cbs.nl/ODataFeed/odata/82062NEDThe direct link to main Odata feed is: https://opendata.cbs.nl/ODataFeed/odata/82062NED/TypedDataSetIt contains data from 2012 tot 2023 April. I only need data from 2022 and higher. I found some tips for filtering like placing?$filter=Perioden gt 2021MM12 but this doesn't work. I think I'm almost there and only need to figure out the right syntax. Can anyone help me?Thanks in advanced!Cheers Richard

2109

moostang88

Merge shapefiles with different UTM coordinates into a single LL84 shapefile

I have several shapefiles in different UTM coordinate system. I want to:a. reproject each of them into LL84b. Then merge the re-projected feature into a single shapefile I need help in a. Merge features after reprojecting them.b. Find a better way to do it than the way I am trying to do it (see image below). As you can see, I am stuck and I do not know how to do the last part.

1146

poncetaContributor

Is the GeometryFilter altering the data or the way the data is presented to the writer?

I have a dynamic workflow that writes spatial data from a MS SQL Server to a postgis database. Since my inital data is not always restrictive on geometry types, I want to ensure that Geometry types are well defined in my destination database. I had an issue with mixed lines and multilines that I solved using an aggregator (destination geometry (multilinestring) ) but I had some geometry collections creating some issues when writing data so I added a GeometryFilter. Visually no feature is filtered (only lines) and the writing is doing great. Removing this filter will make the writing fail. My question is then : Is the GeometryFilter altering the data or the way the data is presented to the writer?

382