FME Form

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 indi

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

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)    return

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

I will soon have two sets of (hopefully) identical data to check against each other, sat in FGDB's. There are quite a lot of records (thousands, if not tens of) and I'm looking for differences in any attribute between the two versions of the same record.  I can see this taking a long time, and note there are different options within FME, including Matcher, CRCcalculator, etc. What is likely to be the most efficient method?

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

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?

How can I assign a unique identifier to all areas that intesect each other?

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 f

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?

that should be in separate fields are in the same cell. So, how do I remove peoples job titles that are sharing the name field and place them in a field of their own and is their a standard FME practice that will target duplicate entries into Excel sheets? Any help would be greatly appreciated.