General

Our Athena Connections are configured using a specific workgroup name (rather than the default primary one).Can I specify the workgroup name somewhere in the connection parameters?Below is the error I receive when trying to list the named queries for this connection.```AmazonAthenaConnector: An error occurred while listing named queries: 'FMEException: 936005: AmazonAthenaConnector: The requested AWS operation returned an error: 'An error occurred (AccessDeniedException) when calling the ListNamedQueries operation: User: arn:aws:iam::<nr>:user/testing is not authorized to perform: athena:ListNamedQueries on resource: arn:aws:athena:eu-west-1:<nr>:workgroup/primary because no identity-based policy allows the athena:ListNamedQueries action''```When I try to query with a specific query it (obviously) also fails, but with a more generic error:```AmazonAthenaConnector: The bucket 'pnh-raw-data-euw1-s3-factsheets-output' does not exist or can not be access

I have been trying this for a while and have been spending too much time on this. I saw, and downloaded, Dmitri's stopsigndetector workspace and had a go at it myself. I just have no way of getting it to work at all. Sometimes it seems to get a result (which never makes any sense), but running the same workspace again will then result in a crash. the problems I encounter:Sample preparer just doesn't work at all. Rejects incomming feauture without an error.sample generator. Sometimes works, sometimes doesn't. Sometimes gives the error 'invalid background description fie', a file the transformer generates itself..?instability: sometimes any of the 4 transformers (sample preparer, sample generator, trainer and detector) just crashes without an errorLack of documentation I tried the relative path trick, without it nothing works, but that didn't help. I downloaded Dimitri'workspace: Doesnt'work. Crashes on the samplepreparer, no error message.    

Hi everyone,  I am trying to create a set of new attributes with the Attribute Creator. I would like to use the "import" option to bring the attributes from a CSV file. However, the transformer reads the attribute values as a "text" and not as Arimethic function (See picture for clarification ). Any idea on how to change that quickly? Or any better idea to obtain the same result? I mean create the following attributes:  Name AttributeY1 =A1+B1Y2 =A2+B2Y3 =A3+B3Thanks in advance!. 

I am using a template (schema only) to create many feature classes. the template already has a feature extent created that is larger that desired.if i don't use a template fme calculates the feature extent correctly for all included features in a feature class. Is there a way to override and include this information in the fgdb writer parameters? 

Hello Everyone..I have an query regarding transpose for the attribute one feature elements are 25 as you can see in ID coumns ..Now my question is how can i transpose the column names to rows and their inforation related to the field..Please find the attached screenshot with the FME template with sample dataPlease provide how can i fix the issue Thank You

I m directly pushing data to AtcGIS portal and want I need is if source data have no data then ArcGIS also truncate the data and show me the NO data at the moment its showing me null values with object Id is there any way to show no data  

Assuming I successfully get FME to use an ArcGIS Pro license instead of a Desktop license -- a current problem -- I would like to know how to direct FME to use my cloned and currently active Python environment instead of the default (and unmodifiable) one that got installed with Pro. I have added several modules and site packages to the clone that I would like to use in FME. I read in another post (lost track of it) that FME might only be able to use the original Python environment installed with Pro. It was suggested that maybe adding the paths to the site-packages and bin directories in the clone to my system path environment variable would allow use of the clone. I have done that ... but alas, I still haven't gotten FME to use a Pro license. This brings up another question, though. On a colleagues machine where FME is using a Pro license, the workspace translation log only reports the version of Pro that is being used: there is no indication of which Python environment is

EDIT: so i need to find a way to use the 1 feature set (just the pink lines) find a pair of them. (maybe the fuzzyparallelfinder would work for this) split those pairs so i get only one of them then do this perpendicular line long enough to cross the other pair, spatialrelate that back to pair a, filter those and then calculate that length. any ideas on how to pair and split each parallel set? (see comments below for reasoning)I have row line features. I need to determine the distance between them (or easement width). I have been successful creating polygons out of these by using the fuzzyparallelfinder (custom) transformer. I also need the easement width attribute assigned to each line prior to making the polygons.the method for creating the polygons is pretty simple using the fuzzyparallelfinder and then using a snapper and areabuilder. But i get very unbelievable values if i use the statistics calculator as described in other posts. can anyone help with what i am missing?  

Hello, Is there a transfomer to know the direction a polyline was drawn (forward or backward) ? Thank you

I have a Python caller that eventually makes a dictionary Input: {1:a, 2:b, 3:c}Desired output: A representation of the code is below. I am not using the class. Just a simple function which coverts input list to dictionary. I also expose the key and value attributes. This is only representation because the actual code is quite complex. The code does what I want but I am having an issue writing them out as attributesimport fme, fmeobjects #Update connection propertiesdef processFeature(feature):        # Initialize values    list= feature.getAttribute('list')     #Code to make list to dictionary     #Output dictionary    for key,value in dict.items():        feature.setAttribute('key', key)        feature.setAttribute('value',value)    returnAny pointers would be extremely helpful!

Hello,How can I convert an ASCII file to xyz csv file please?Thank you

I am getting the following error (out of the blue, I might add. One run, everything humming along fine until "bam", next run, license/Python compatibility error):ERROR : FME initialized 'ArcGISDesktop', but the workspace Python compatibility setting is 'Esri ArcGIS Python 3.7+'. Please check the Python compatibility setting in the workspaceI have both ArcGIS Desktop (10.8.1) and ArcGIS Pro (2.9.1) installed, and I am using 64-bit FME Desktop Professional 2022.2. My dropdown list for the Python Compatibility parameter, however, does not include separate listings for ArcGIS Desktop vs. ArcGIS Pro, only for "Esri ArcGIS Python maj.min" . (1) Does "Esri ArcGIS" mean ArcGIS Desktop?; and (2) if so, what do I need to do to get ArcGIS Pro choices listed in the dropdown and to get FME to recognize and use my ArcGIS Pro license instead of my Desktop license?

Dear FME friends,Welcome to What's Up Wednesday. For reasons of space, this is an extract from the full version of this newsletter, which you can find here on LinkedIn. The Peak of Data Integration, 2023!Even though the last user conference ended not long ago (or perhaps because it ended not long ago), I'm really excited that we already have online details of next year's conference!  As previously announced, next year's conference is taking place in Bonn, Germany, in September 2023, hosted jointly with con terra. Yes, we're coming to Europe! So save the date for sure, but also start thinking about what story you would like to share, because the call for presentations is already open. Hexagons in FMEIn case you didn't know, there is an ongoing event called the #30DayMapChallenge. That's when you're encouraged to create a new map every day in November, each on a set topic. A recent topic was "Hexagons," and so I thought I'd use the H3Hexagona

I have two separated polygons. both of them have unique identifier which is written inside polygons. also, both of them have area_official, but it is written on the bigger polygon. s, I want to associate the area and smaller polygon together. What I do to make it work?

This is opened question to FME Community. FME workspaces are very individual. But I believe there is a way quite universal way to test it (FME Testing Framework, rTest, DatasetValidator, Test Custom Transformer). This topic is about data quality. It is crucial!. How do you test your data in FME?

I have a workspace that uses ESRI ArcGIS Python 3.9+ and works as intended on FME Desktop. When uploading to FME Server, I receive this error: A Python interpreter could not be loaded. Please ensure the workspace `Python Compatibility` is set to an available Python version. Based on this link, Using Python with FME Server (safe.com), I believe I need to upload the correct python module to the FME Server Resources directory (presumably a python module that was distributed with the install of ArcGIS Pro 3.0). Both the ESRI software and FME Server are installed on the same machine. I'm having trouble locating the correct files to upload to the Resources. Which files need to be uploaded, and where would I find them?

I'm trying to run an old project in Desktop 2020 and keep running up against the error "The Geodatabase ... is newer than the ArcGIS installed on this machine. As a result the Geodatabase cannot be opened"Log file shows it checks out a license from ArcGIS 10.6.1 but I have ArcGIS 10.8 installed, although there is a Desktop10.6 folder in ArcGIS/Program files as well.Can I 'force' FME to select a 10.8 ArcGIS license or is there another work around?

I want to convert the features from ArcSDE to a pdf. I have an autocad file that contains some blocks to assign to points that can use as a template. I also have an Excel file that contains the color and width of each Lines that can to be assigned to specific features. I would like to know how I can assign the Autocad file to my feature. In addition when I try to determine the values ​​of pdf_fill_color using Atribute Format, the color doesn't change at all. do you know where i can find color code? (DWG Styler doesn't help me because I have color of features as code in an excel file and I just need to link color to feature. 

Hi Experts, Which tool to use to mark green (ish) pixels in my tiffs? Is there anything available to help me to hunt pixels with the specific color range and mark it.Thank youj

I want to check my FME processes using the FMW reader. I noticed that when reading transformers, the value in the attribute field "custom_transformer_parent_name" is missing if the transformer is an "ExternalTransformer". Is this a bug? Most of the transformers where this error occurs are custom transformers I created myself.

Hello everyone! First time using and writting something in community. I apologize if this is not appropriate place to put this question and also if I'm not going to write it based on some rules. Anyhow: Long story short, I have FME workflow which is working how it should on Workbench. But when I publish it on FME server, for some reason it doesn't want to use all readers or writers are not working properly.  Readers:3 excel1 csv1 mdbWriters:1 excel Result from FME workbench: Result from FME server: As you can see, worksheets in results are different. I believe I did everything correct with setups in readers and writers (if needed, I can provide screenshots on how it looks like). Tried also to make new Readers/Writers. Tried to make different repository and put it there. Also weird warnings that appear after the workflow has been runned:  Again, I apologize if I missed the place to post this, or also if I didn't write this question correctly. Anyhow, looking forward on some

Hello,- What are the best settings to read a large XML-file (650Mb) on FME server?- Is there a better way to read this XML file? o XML flattener will hold with Optimizing Memory Usage o Shorter XML files (300Mb) run without any problems.thanks  I have the details placed in a document. thanks for your help

Hi,I need to transform the value of this column and a new column...the values are always the same.  Thank´s

I have some photomesh files that I would like to turn into 2d top down raster images. Is there a way I can accomplish that in FME while preserving the georeferencing. Most of my viewing software allows me to export a snapshot, but the geocoordinates are not preserved.Original data (obj)Desired output (geotiff) I can't just use the texture files because they are spaghetti.

How do I set up my writer to only update after column 3? Or is there a transformer that locks the columns to prevent them from clearing every time there is an update?