Best Answers

Hi. I would like to ask. I have three parts under one ID ( UUID_departure ) where each part has a different ID ( UUID_departureLeg ) and each of these three parts has different values. I need to combine under one UUID_departure these 3 parts of UUID_departureLeg with the data of each individual part. It doesn't work properly for me when using FeatureMerger, when using Aggregator it only writes the first value to me. Could someone help me with this? Thanks a lot

Basically, I have a workbench that produces a CSV that I want to use in other workbenches and get a result. But There doesn't seem to be a trigger that works for me in this idea. Here is how the automation would look: How can I trigger an automation from the result of the first workbench?How can I transfer the resulting dataset into the automation after the trigger? Thank you,Kevin

I have a flow as pictured below. I have only three collumns in my StatisticsCalculator. I have year, month, amount. What I want is to create a sum(amount) per year, month. When I run this flow it generates way to mcuh data. I was expecting 12 rows pre year but there is way more and the data is duplicate, giving 28 rows per month. What am I doing wrong?

Hello, I have to update DATE value in XML file and I use XMLUpdater transformer. It works perfect if it is only one date value.I have problems updating date field for coleListValue="publication" in the situation that shows the following example:            <CI_Citation>                <date>                  <CI_Date>                     <date><gco:Date>2006-07-01</gco:Date></date>                     <dateType<CI_DateTypeCode codeList="myCodelists.xml" codeListValue="creation"/></dateType>                  </CI_Date>               </date>                <date>                  <CI_Date>                     <date><gco:Date>2014-07-11</gco:Date></date>                     <dateType><CI_DateTypeCode codeList="myCodelists.xml" codeListValue="revision"/></dateType>                  </CI_Date>               </date>                <date>                

Hi all,I'm looking for a specific FME version: FME(R) 2019.2.3.1 (20200212 - Build 19823 - WIN64) I'm not able to find it in the past versions section: https://www.safe.com/support/downloads/#past-versions Is it still available somewhere?Thanks 

Our team are trying to create a workbench which will be used to answer user data requests. The workbench should provide a packaged export from our Oracle database, including a schema definition, metadata and various file type(s).  I'm trying to make this as simple as possible by using parameters for the user to input, including table name and spit out folder at the end however I'm stuck when trying to create a parameter for the table name we want to download using the Esri Geodatabase (ArcSDE Geodb) Reader.  I've actually managed to work around this for the metadata by setting a default table, using the merge feature type option and using a wildcard, then setting a parameter from that. However when I try this with features although I get the geometry I get an empty attribute table.  Anyone have any experience of this or potential better solutions?

Forgive me for what is likely a very simple answer to this question, but I'm still rather new to FME. I'm wanting to use a defined User Parameter (Type - Text) which will then inform my AttributeFilter transformer (where the user parameter directly corresponds to a specific field of the dataset being read by the AttributeFilter transformer). However, when I set the transformer parameters as per the screenshot below, I don't then get the expected output, i.e. the dataset filtered for that specific value. Is there something I'm missing? Thankyou for taking the time to read this post. 

Hi everyone, I am trying to get the value of the first table (that only has one row with info about xmin, xmax, ymin etc.) into the 2nd table. The second table has more rows and my wish is to have all the rows in table to get the same value for e.g. xmin from the first table. However in the 2nd table only the first row gets the value of the first table, while I want to have all the rows the same value for that column. Does anyone how that might be achieved? In case my question is not clear, just let me know.

After .obj files had converted to cesium 3d tiles, buildings created transparently. When I looked behind building, I saw another building. I dont want it. I want that these buildings are opaque. Is there any way for this?Thanks!

The input looks like this:The result must look like this:

Hi!I would like to export my datas (only attributes) on a jpeg file.I would like to create a sort of table like on excel, with blacks border and dimentionnate the columns in order to not truncate the datas. And then export an jpeg file.I used ExcelStyler and an JPEG writer, but it failed because it's not an raster format. So I tried with ImageRasterizer but I don't succeed. I'm not use to manipulate raster format. So could you give me advices to suceed?Thanks !

Does anyone has a good example for this script? I copied the script from here and filled out some of the parameters. Not a coder. Hope someone can help me out https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop/Workbench/Startup_and_Shutdown_Python_Scripts.htm import smtplibfrom email.MIMEMultipart import MIMEMultipartfrom email.MIMEBase import MIMEBasefrom email.MIMEText import MIMETextfrom email.Utils import COMMASPACE, formatdatefrom email import Encodersimport osimport fme# FME variables.status = fme.statuserrorMsg = fme.failureMessagelogFile = fme.logFileName # E-mail message values.subject = "FME Translation FAILURE"to = "receiver@domain.com"sender = "Your FME script <sender@domain.com>"text = "FME translation failed with error message: " + errorMsg + "\r\n\r\nSee attached logfile for details." # Credentials.AUTHREQUIRED = 0username = "smtp.user@domain.com"password = "smtppassword"smtpServer = "smtp.server.com" # Create and return a message with a logfile a

Hey everyone, I am trying to write a file to a temporary filepath in my PythonCaller script and I thought that using the TempPathnameCreator transformer might save me some time coding something which is a basic function in FME. Unfortunately if I try to write the file to the location I get a python error that says that the location does not exist. I have used the OS python package to test if the temporary path is valid and it is not. Am I using the TempPathnameCreator incorrectly and is it logical that my PythonCaller is unable to write to the temporary location?

Hi I need to post requests to SOAP to retrieve some information about Planning cases back in XML and I have read the article: https://community.safe.com/s/article/working-with-soap-services Our process is more complicated as I need to log in and out of SOAP at the start/end of the process.  I created steps in a TestCase in SOAPUI and it worked and I have set up a workbench with the following transformers: CreatorXML Templater (for login)HPPTCaller (for login - cookies enabled)XML Templater (to Get data)HTTPCaller (to Get data)XML Templater (to logoff)HTTPCaller (to logoff) While this worked for retrieving one planning case I actually need to retrieve information on multiple cases but cannot get this to work. I tried two things: 1) I created a spreadsheet with multiple planning case references in, read this into FME (replacing the Creator) and changed the value in XMLTemplater to use the attribute value (using fme:get-attribute), instead of a hardcoded value.This appeared to be attempti

Hi friends, I would like to filter roads (Name) that passes through more than 2 suburbs (Suburb). I do not see a straight solution in Tester. Can anyone please give me a clue to about this issue? best regards,FS

Hi all, I will create trees[citygml] based on point geometry. On the internet I found this tutorial: https://hub.safe.com/publishers/con-terra/templates/citygml-create-solitaryvegetationobject-with-implicit-representation Unfortunately *SKP format is not supported for my fme version. So I have tried it with obj models. But this doesnt work for me! I got this rejection code: INVALID_SHARED_ITEM(SharedItemIDSetter). How can I solve this problem? Workflow:

I've got a set of polygons from a PostGis DB and want to write them to DGN. On one level, I've got the polygons and on another level, named label, I want to put out a text string from an attribute. Some of the polygons have more than one entry here, which leads to stacked texts - I've used a centerpoint replacer, labelpointreplacer and dgnstyler. I guess when only having two or three entries, I could solve the problem by subtracting a fixed value from "igds_insertion_y", but I don't know how many entries will be there in advance and already encountered some cases where a polygon had 40 to 50 entries I have to write one below the other.

I have a series of PDF documents that contain a map that came from the ArcGIS Map Series tools (over 2000 in all). I am reading each of the PDF's in and converting to BMP and saving the images to a local drive so I can use the images in a HTML report.  Rather than store the images locally, I was wondering if there was a way to convert the images to base64 and save the base64 as an attribute and then just use that attribute in the HTML document? Is this possible? Any suggestions would be very much appreciated.

I have simple workbench, which pulls data from Oracle Spatial and writes the data into Postgres Dynamic Writer. The workbench when ran, throws the following error,"Esri Geodatabase Writer: Feature Type Definition 'd_y_n' was requested, but not defined. Please visit https://www.safe.com/supportGEODATABASE_SDE writer: A fatal error has occurred. Check the logfile above for detailsFeatureReader (QueryFactory): A fatal error has occurred. Check the logfile above for details"The attribute manager is used to match the name of the fme_feature_type_name and the dynamic writer featureclass name ,The dynamic writer has the following parameters as shown in the image, I couldn't figure out what mistake am I making here. Could any one please help ? Thanks in advance.  

Hi there, can anyone please help me how can I filter some record that have a particular word. For example, I would like to filter all the road name starts with 'The ' (e.g. The Meadow but not like 'Theodor road'. If I use contains/begins with in the tester, it gives me all that have string part 'The'. I never used Regex editor. A good response will be highly appreciated. Thanks in advance.

Hi ,Recently we have upgraded our FME Desktop version from FME 2021 to FME 2022. Since then to Fetch data from Esri ArcGIS Portal Feature Service (Reader) is very low. Even to fetch around 10k records it takes about 10 mins, However in FME 2021 it was working very well and it takes about only few seconds only to fetch the same size of records. Is this a known issue with FME 2022?

I have a DWG file I'd like to read into FME to extract certain information from. When I add the file in a Reader and choose to read Individual Feature Types, I get >100 different Feature Types, but almost all of these are empty (ie have no features in them when I run everything). Is there a way to easily select and delete these empty Readers, or alternatively to tell FME to only add those which have features in them in the first place? I have tried using the PURGE command in AutoCAD to clear any layers with no features in prior to reading the file in FME, but this doesn't seem to have done anything - I have very little CAD experience so it could definitely be that I've done this incorrectly.

With the help of the following request url in the Httpcaller, it was possible to get a returned xml output with information about one feature. However instead of retrieving information about one feature, ideally I would like to retrieve metadata of all the items from ArcGIS Online. Does anyone might have an idea how that can be achieved? This url gets me metadata of one feature.https://<companyname>.maps.arcgis.com/sharing/rest/content/items/<Item Id>/info/iteminfo.xml 

I'm trying to add a esri sde geodatabase reader to a workbench without an sde connection file. I have an example workbench I got from someone else, (but who left the company) with a geodatabase reader where I can just fill in the user credentials and server instance, and then it will read the database.  So in te example above a new connection file is not needed. However, if I try to add a new reader I can only add one when I provide it with a sde connection file. Can someone tell me how to get parameters like in the picture with an esri sde geodatabase reader?

Hi all,  Does anyone know the expected release date of FME Desktop and Server 2022.1?  We are planning our next upgrade from 2021.1 and I want to assign the upgrade to a quarter in our Life Cycle Management planning.  I don't want to risk that the software is not available.  Thanks, Annette