FME Form

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

Today i use the datetimestamper to have my date in a string, but i want to convert to an attribute Thanks in advance and sorry for my bad english ! 🙂

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

Has anyone had any luck with Date/Time in the Chart Generator?

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? 

With the CAT reader, I'm loading a text file many small numbers, some of which are automatically converted to scientific numbers in the Visual Preview. These then become impossible to work because, for some reason, any transformations of the data are based on those scientific numbers rather that the decimal numbers. Is there a way to disable this automatic transformation from decimal to scientific numbers?

I run a process that reads out of ESRI modifies some data and writes it back into the layer. This worked in AGOL but now that we moved to OnPremise version of ArcGIS I can't get it to work. The only difference I can see after replacing the read and write nodes is that the Type field in the user attributes tab doesn't maintain its esriField Types and defaults to string.When writing back I get an error saying ObjectId is missing but this field is in the data set.

I have a child workspace accepting a where clause parameter:loggingUnit = 'LK107I' This works just fine standalone. But when I call the same workspace with a parent workspacerunnerusing an identical where clause my SQL Creator fails with rejected features. I can see in the logfile the parameter passed in is identical also?

Hello, I am reading some attributes from a database. Some are in string format, some in number (int, float etc.). I want to write these attributes to a json file.I noticed that all the attributes in string format are automatically output in quotation marks and the numbers without. In my case I have three attributes: district, lat and long. District is an int, lat and long are strings. How can I change lat and long so that their output is also without quotation marks like the district one (see image) ?

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

HiI need to extract the 1 2 3 4 5 td element inside class paginated_element in separate rowCan you hlep please ? I'm able to extract the entire class but not the single value thxFrancesco

I have been given the task of creating an e-mail function. It should send an email when another date is about to expire. For example, a customer receives an email when there are 14 days left on their current booking. But datetimecalculator does not work to calculate intervals of days when it comes from ESRI file geodatabase (is SDE in the original data) I suspect it is the format of the attribute that is incorrect but can't find how to change it to a working date. Is there anyone who can help me? Attaching my workbench and a file geodatabase as a zip file Best regardsJesper 

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 am getting some strange spikey artefacts from ContourGenerator. The dataset is a goverment isued DTM, pictured are some sea islands. The data is preprocessed with rastercellrounding and a notatasetter to ensure that the sea surface did not hold any data.  Settings as follows:First image elev 2.5 tolerance 5Second image elev 2.5 tolerance 0Third image is a close up of the the second (elev 2.5 tolerance 0) Any ideas on how to deal with this?     

(I have attached the dataset)I have survey points where each point is less than 2Metres from the next point per run, in a run i can have more than one section, as shown in the attached file, but all the points within this one run are still within a distance of less than 2M from each other. The difference in distance between runs is more than 2M. So it is evident when a new run starts and ends. If i had the attribute run within my dataset i would use the linebuilder and create lines from points.So what i am trying to achieve is to group the data per run. So far i have tried creating a new attribute in the Attribute creator transformer using conditional values but to no success. Anyone with an idea of how i can achieve this? Thanks,Keller.

Using Workbench 2022.2 and try to insert a TIF into an existing mosaic dataset and FME is returning the error: Unable to retrieve path to raster dataset from feature Yet, I can see the fully qualified path to the TIF in the incoming fme_dataset attribute from the geotiff reader?

What is the best way to download data from an Open Data ArcGIS Site that does not require a login?

Using an old version - 2019.1.3.1 with ArcGIS 2.7 compatability. In my script I have where: import fmeimport fmeobjects  if __name__ == "__main__":   # Script parameters   inputLayer = feature.get.Attribute('inputLayer')   outputLocation = feature.getAttribute('outputLocation')   outputName = feature.getAttribute('outputName')

I have roughly 12.000 features (points). Each feature has a list with 400 elements, which all have an X and Y attribute. I would like to remove the elements of which the distance between the point of the feature and the element attributes is bigger than a certain number.  Currently I'm first exploding the list, and then using a tester with the arithmetic expression(@sqrt(@pow(@XValue()-@Value(x_end),2) + @pow(@YValue()-@Value(y_end),2))).  The problem is that this way I first explode the list, which results in more than 4 million features! If I could eliminate them before exploding than I would only have roughly 200.000, which would improve performance.  

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