FME Form

I have an FME-workbench which manipulates data originating from either Excel or Access. Since I want to use the same workbench for dozens of different Excel and/or Access-files and every file has multiple Features, I don't want to create a new Reader every time, but just indicate the path to the corresponding file.The data structure is given and supposed to be the same for every input file. However, sometimes that is not the case, i.e. some additional columns are added in one of the Excel Sheets . Now, I am interested in finding additional/missing columns, but that's where I start getting lost... I tried to compare the attributes of my desired Input file and the Example file (with the correct data structure) via Attribute Transposer and ChangeDetector, but it did not work dynamically as the Reader seems to remember and thus keep all the Attributes it has ever seen so far - and not only the attributes actually present in the desired input file. Please let me know if I should giv

Hi ! I have a folder containing about 20000 jpeg files and separately a list in csv format containing names of some jpeg files which I'll need. How can I import in FME only the jpeg files from the list and not all images in the folder ?Thank you.  

I am essentially looping through httpcaller results and need a way to pass a value from the last record returned in a loop, I dont know how many records will be returned. I was using the stats calc to get the max value but that is blocking the loop from running within the one workbench. Does anyone have any suggestions, thank you

Hi All,I have a workbench that reads a feature service from ArcGIS Online exposing the actual attachment attribute associated with each feature and then extracting the photos attached to it.I'm using RasteReplacer to convert the BLOB data to a JPEG and then writing it with a JPEG writer (with the option to save the EXIF data ticked).However, it doesn't look like the EXIF metadata is writing to the JPEG.I'm sure that the EXIF metadata does exist as I have an existing Python script that uses Arcpy to extract the JPEGs with EXIF out from a file geodatabase. But when I do it through the ArcGIS Online feature service reader, it doesn't seem to be retaining this information .Any help on this would be much appreciated.

Hi,I have a script where the user decide what file to add to one of the excel readers. The problem is that the information in the excelfile is new everytime and so are the columns as well. But the problem is that the reader wont update to new columns in the new excelfile. Somehow the first excelfile that is added to the reader is kind of "stuck" there until I remove the reader and add a new one with the new excelf file. But the problem is that this script is connected to a FME server app where the users will be choosing an excelfile in the app and not in the script. So I wont be able to re add a new excel reader everytime. Does anyone here have a solution for my problem? FME version: 2020.1

Within the two data sets there is the common field of subscriber address and address. However I believe there is an issue with the formatting as when I fuzzy matched the Subscriber address with the UPRN dataset the ratio was poor yet when manually checking the fuzzy match output they were mostly correct. Is there an extra step to reduce the issue of factors such as spacing and extra information such as "Nottinghamshire" through transformers? I hope the blurry images below help explain the formats Thank you for any help or advice!!

I have been developing a workbench to be used on different shapefiles via adding a new reader everytime, they would have slightly different attribute names beyond my control. The workbench is now ready to go, but when I have to update the right attribute in a transformer, FME seems to list ALL the attributes that have been handled with previous files with that workbench.. It's really annoying and also potentially generating failures. Is there a way to clear this? To only list the attributes within the readers? I have tried tool>purge temporary files, but it hasn't solved it.  

Hi,I would like to transpose attribute where the unique values in attr_names are columns and the rows are grouped correctly. What I mean is that the values has to be attached to correct feature (see attached picture).The attributes need to be grouped in one row as presented below in the picture with the colors on the side.  FME version: 2020.1

Hi all,I am using an excel file containing several tabs. Each tab corresponds with a feature type in my data. And each feature type/tab has its own specific set of attributes I would like to write to several formats.  Whenever changes are made to this excel file (changing names of attributes, adding attributes, adding tabs, etc.), it does not update automatically. Even if I set the parameter 'Scan Schema in Dynamic Workflow' to 'Yes'. Every time changes are made, I have to delete the workspace resource and add it as a new.  Anyone having similar problems? Or solutions to this problem?Thanks!

Hello!I'm having a near meltdown trying to figure out how to rework a process that I have and hope the community can help a bit. I'm working on a project that is determined a suitability analysis on which curbs are best suited for EV installation charging. By using the SpatialRelator, I am currently processing millions of feature lines (the curbs) and comparing each line to 20-30 different datasets (polygon areas that have been prepped with preconfigured parameters) to see which of them overlap. I then use a ListExploder to explore those relationships, and then a FeatureMerger that merges the different individual "scores" for each of those 20-30 datasets. Then I run it through an Aggregator to basically generate a total "score" from each of the datasets that intersects with a particular line feature, grouped by the line feature. For a smaller dataset, it works fine!However, trying to run 500,000 features using a WHERE clause lasted over (last I checked) 18

Since FME 2021.1 I get many python errors around None values: Python Exception <TypeError>: Attribute value cannot be None. Use setAttributeNullWithType() to set a null attribute value. Is anyone else having the same issues? It occurs with FME Desktop as well as FME Server

i have more than one input ,they are connecting in seperated input ports of pdf page formatter transformer but i have only one port output .how could i rearrange layer orders for each input .if i get all of them from only one output porti would like to show some layers down and others up  FME 2018

HI there,I have access to an API that returns flow data. The data is structured with a serial id (unique to each logger), ID (sequential, but only to each logger) and the data value (float).The API would run every 12 hours and just would return the last 12 hours of data with overlaps. The API creators have suggested that by fetching the max ID for each serial number in the existing data I should be able to return the data from the api that doesn't already exist. There is no provision in the API to pass these values as a parameter so will be using FME to achieve this.I could output the data from the api into a holding table and use a FeatureJoiner to the existing data so insert the new rows, but the static table will grow exponentially and I can see this becoming a huge problem in time.Is there a way to grab the max ID for each serial number from the static table, fire this against the holding table and grab only the new values which are greater than the max(ID) for each serial no

To know the process of Reading and Writing the data. (output to MS Excel)List of Formats where FME can support Read and Write the data.

I'm in a jam. Installed a transformer from FME hub and then after tweaking it was not able to revert back to the original. The original took on the definition(?) of the tweaked one. When I try to download it fresh, it gives me the tweaked one. I have a feeling it lives somewhere, but can't find it. How do you purge a bum transformer? I tried to delete the tweaked version and it crashed every time. No good. Any ideas? I can't be the only one. Thanks

Hi All, I have an FME workbench which read a feature layer from ArcGIS online and export the information into excel sheet, my workbench is running fine in the desktop without any error but when I published it to FME server some times it’s working and sometimes I got the following error “Python Exception <HTTPError>: 401 Client Error: Unauthorized for url: https://www.arcgis.com/sharing/rest/portals/self?” Please note that I include the AGOL connection when I published my fme, I created a new app for this workbench so my users could run it from their side I’m using FME 2019 Any Ideas? Cheers,Rawan

I am trying to connect to AGOL but my token expires. I followed the method in https://community.safe.com/s/question/0D54Q000080hYdzSAE/how-do-i-reliably-connect-fme-server-201819-to-arcgis-online. It work s but then stops working Any suggestions to to fix this? Under File & Connections, I click web connection, then select connection and click manage web services On AGOL developer I selected  

I have recently updated FME to version 2020.2.4.0 (20817) and I am now having trouble with the Esri ArcGIS Online feature service writer. When setting up the parameters for the writer I am unable to see any feature services which I do not own (screenshot 1). Previously I was able to find all organisation feature services. The Esri ArcGIS Online feature service reader has the ability to find both owned feature services and feature services shared to groups (screenshot 2), just not the writer.

i have a road network of 4 areas and it is categorized as external and internal road, The features has an attribute as number of lanes so i want a HTML or Excel file based on the total sum of lengths each lane has. Thanks in Advance

i would like to download DigitalAtlasNord Map ,is there free version to download this map to use in FME ?or which free source map will be similar to this map to download ?another question : i have Gis application bentley microstation,how could i use the map in bentley,do we have a method for that ?My target : i want to use the map in FME to get Cartographic output behind object in pdf file FME 2018Thanks for help   

I have a py script. It takes in 3 parameter,Input file gdbFeatureClass nameOutput file gdbWhat it does, is to copy the contends of the featureclass to the outputfile gdb and I would like to convert it to FME Can some help me with this conversion? Please remember it may be configured for any filegdb and any featureclass name so a static linking won't work. My initial findings is the use of "Generic" option of FeatureReader

Is there a way to extract Road (2d polygon) from an FBX? Or an FBX to DWG workflow?

I'm converting DWGs to DWGs, basically copying existing DWGs to new ones with a few extended entity attributes changing values. However, the data types on the output file are string representations, rather than the 32-bit integers that are read from the input drawing and recognized as integers throughout. How can I get the ACAD writer to output the values with the correct data type? I'm using a dynamic schema, with the schema source being the input drawing. Also, how do I know that the output drawing is truly a high fidelity copy of the input drawing? I'm following all the guidelines in the documentation about DWG-to-DWG settings, yet if data types are changing, I wonder what else might be changed/lost in the process, for example, external data links and line styles.

Each .DWG file has to haev the same file name as the source .LAS that it is converted from. what is the best way to set this up so it converts all of them one at a time without too much user input?

Despite the fact that the nad83 and wgs84 datums are supposedly identical, there are several ways to get from one to the other and they result in different placement. ESRI recommends this transformation: WGS_1984_(ITRF00)_To_NAD_1983FME appears to use this one: nad_1983_to_wgs_1984_1 I am using AttributeReprojector on a dataset with several coordinate systems. Is it possible to indicate a specific geographic transformation for nad83 to wgs84 when using this? Thank you, Randy McGregor