Best Answers

Hi. I've export table in XLSX writer and i want that excel sheet have the name of the table ( not the complete path of source). I know it's probably easy but i can't reach my goal.Thank you for help :)  

HiI need to add a field to a SQL table as the schema has changed. However, all the instructions indicate I need to drop the table. As there is data in there already, I cannot do this. Is there a way to add the column in FME, or should I just go into SQL Server Management Studio?

Edit: The DateTime did exist in the output in the "Time" attribute as a ISO8601 format.  Problem.I want to add starttime and endtime as attributes to the export. I have a working simple workspace that reads a JSON from: https://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=@Value(date_sub)&endtime=@Value(date)  where starttime (value) and endtime(value) are in the format "yyyy-mm-dd" and is created as FME parameters.  The string original looks like thishttps://earthquake.usgs.gov/fdsnws/event/1/query?format=geojson&starttime=yyyy-mm-dd&endtime=yyyy-mm-dd I am exposing the attributes I want with attribute exposer and it works at it should according to the documentation "GeoJSON Summary Format (usgs.gov)" The starttime and endtime attributes is the date window where I want to read the event data from USGS.  So I guess there is timedata from the earthquake event that stores the date when its monitored. That is the data and

HiIs there a way to have the AttributeRangeFilter create the Output port names in a new attribute that's called like '_attrRangeFilterOut' and the values being whatever the name of the output port is? So instead of having the AttributeRangeFilter followed by a bunch of AttributeCreators which basically sets the new attribute 'range' to the value that's similar to the output ports of the AttributeRangeFilter, is there a way to just have the AttributeRangeFilter do that for us?

Hi FME Community,I've recently been given quite a big task of migrating, renaming and sorting documents. I have naied the moving and renaming part by using a mix of FME and SystemCaller for Robocopy (as FME would output the PDF files as folders, for some reason). So, the moving is all good, but is there a way I can use FME (as I am quite constrained by my working environment, such as python being stock and FME version) to say - "if a file exists in folder A, but also exists in subfolder X, delete the file in folder A" I've tried with a DuplicateFilter, which gets a few, but misses others (attached screenshot). Been going mad with this one

Can somebody explain the process of how to add a Coordiante system to the FME Coordinate System Gallery. I have the .prj of the new one I would like to add, I do not know how to edit the "MyCoordSysDefs.fme" file in order to implement this.   

We are working with simple workflow of reading in data from a SQL Spatial Table reader, setting null attributes to missing , and writing out to fGDB/eGDB/Spatial table. Our end goal is to remove the fields that are empty but there are occasions when these fields may have values. When writing out the features after mapping all null to missing, the fields that are entirely missing still write out when writing to a fGDB/eGDB/Spatial table (they appear as null in the featureclass).  We are unsure if there is a way around this or if it's a limitation of the GDB format.  My only idea of bypassing this is writing out to another format that would remove the field (like JSON) and then reading back in using feature writer and feature reader. This is a poor solution so any other ideas are appreciated. 

Hi. I have a FGDB (esri) with coded value. I've tester for field (HorizontalAccuracy). This field must be in some value (Low, High, Medium).I use in for operator but it doesn't work. I've try so with coded value. Can you help me please, I use FME 2018, i don't have cachedvalue :(

I am using several ListConcatenator transformers in my workspace. I want to give them unique names, however, when I rename them and run the workbench, it fails and gives me an error. When renaming my transformers, I normally use an abbreviation for the transformer name followed by a colon ":" then some unique name. For some reason the ListConcatenator doesn't work when a colon ":" is in the transformer name.Example: I rename the ListConcatenator transformer to "LC: RunwayNameList" and it throws this error:2020-03-02 08:32:52| 2.2| 0.0|ERROR |@Tcl2 -- failed to evaluate expression `set LC:_RunwayNameList__separator [FME_DecodeText {<comma>}]; regsub -all "{}" [FME_DecodeText {_listAll<opencurly><closecurly>.RUNWAYNAME}] [FME_DecodeText {<opencurly><backslash>d+<closecurly>}] LC:_RunwayNameList__listPattern; set LC:_RunwayNameList__listPattern ^$LC:_RunwayNameList__listPattern$;' -- can't read "L

Hi all, I am running a workbench which I have scheduled in FME Server. The workbench when running from same location in desktop works fine. The issue seems to be with the sharepoint connector. I use this to download a specific file. When it tries to connect to it, I get the error below, any ideas what that might suggest for FME server?  2021-2-8 22:15:04 | Python Exception <ModuleNotFoundError>: No module named 'fmepy_microsoft_sharepoint'902021-2-8 22:15:04 | PythonFactory failed to load python symbol `fmepy_microsoft_sharepoint.connector.SharepointOnlineConnector'912021-2-8 22:15:04 | Factory proxy not initialized922021-2-8 22:15:04 | SharePointOnlineConnector_CALLER (PythonFactory): PythonFactory failed to process feature932021-2-8 22:15:04 | SharePointOnlineConnector_CALLER (PythonFactory): A fatal error has occurred. Check the logfile above for details

Hi I have a list of urls and want to download files from each of them. I am using the http caller and extractor to find links to pdf files on a webpage and then another http caller to download the file. The fist part works fine and when I inspect it I can see the urls to the pdf files. However, the second part does not work. FME rejects the features saying the url doesnt exist. I have tried it directly in a browser and it is entirely correct, the url doesnt exist. It only appears to exist whilst the original page is open. Is there a way to keep that page 'open' until the files have been downloaded and the it moves on to the next record? Many thanks

I'm in the process of migrating a number of workbenches/workspaces from 2018 to 2020. Many of these were created years ago in much older versions of FME. So I'm meticulously going through an updating all elements in the workbench, then running it in Desktop and finally publishing to Server 2020. Running into very few issues but I can't get Desktop 2020 to read zipped GDB using the GDB reader. Where it does so in 2018, it fails in 2020.  Unable to connect to the File Geodatabase at 'path..../GDBName.zip'. Make sure the correct filename was specified, and that the geodatabase wasn't saved with a newer version of ArcGIS than the one installed locally. The error number from ArcObjects is: '-2147024893'. The error message from ArcObjects is: {}A fatal error has occurred. Check the logfile above for detailsIt will read the GDB just fine if I manually unzip it in the same location. So it's not permissions or issues with a bad GDB. Anyway, I can come up with a workaround - just wondering if th

How can I write to the master database without adding unwanted duplicates? thanks

The image in the annex shows my workbench. This is the result that can be seen in ‘Passed from Tester_2’:NAME ; DBKOrganisation X1 ; 111Organisation X2 ; 222 This is the result that can be seen in ‘SQLCreator_3’:ID ; OWNER_ORG ; CLIENT_ORG ; MONITOR_ORG1 ; 111 ; 111 ; 3332 ; 222 ; 222 ; 2223 ; 333 ; 444 ; 5554 ; 333 ; 222 ; 3335 ; 444 ; 555 ; 111 I would like to use a transformer that uses the results from ‘Passed from Tester_2’ to check if one of these DBK values is present in the organisation columns of result ‘SQLCreator_3’.So I need the transformer to select ID 1, 2, 4 and 5. But not 3 as Organisation X1 and X2 is not present in one of the three organisation columns.  Can anyone explain to me how I can do this?Thanks in advance!

I'm having mixed results with ArcGIS Online connections on a new install of FME Server 2019.I can publish a workbench with a ArcGIS Online connection (publish the web connection also) and it will work on FME Server 2019 immediately. Then after a little while it will stop connecting an AGOL will start rejecting connections. I'm assuming the workbench generated a token and the token expired???Under my Web Connections on FME Server I have a ESRI ArcGIS Online connection which says:Esri ArcGIS Online Web Service has not been configured for Web authorization. Jobs will run with your published credentials but you will not be able to authorize or create new Esri ArcGIS Online Web Connections until Esri ArcGIS Online Web Service has been configured in "Manage Web Services". More Information I go through the process of making an application on ArcGIS Online getting the app id and the client secret and the redirect uri is prefilled with something like - urn:ietf:wg:oauth:2.0:

Dear FME community,I want to create 3D-tiles from city-gml-data. These tiles should be sved as OBJ-files. I like to create simple models of trees of coordinates. Since there are over 200000 coordinates, there will be over 200000 trees. Each tree will have a certain amount of polygons. So at the end there would be several million polygons in one file, if I were to save one OBJ-file. I decided to create over 200 tiles in order to have many smaller files. In order to create those files, I would like to use the "Workspace Runner"-Transformer.  So I have one workspace, that created the tiles. In this workspace I basically created tiles made out of point-clouds. Now I want to transform every pointcloud-file into meshes which sit on one tile. Each point in the point-cloud will be used to create the tree geometry. Since I have over 200 point-cloud files I want FME to send every singe point-cloud file into the workspace that creates the geometry out of the points. At the end I wish to

I have amended the FME_SHAREDRESOURCED_DATA directory to E:/FMEServerShare//resources/data/ which was previously set to the default location in ProgramData. In the workbench I have a HTTPCaller that drops the file downloaded to $(FME_SHAREDRESOURCE_DATA)\\Geodesys\\.... Checking the fmesharedresource.log file and I can see that the correct directory is being references; Tue-02-Feb-2021 12:29:26.743 PM  INFORM  main  408602 : Configured Shared Resource Type: FILE | Name: FME_SHAREDRESOURCE_DATA | Display Name: Data | Description: This shared resource is the Server data directory | Migratable: true | Directory: E:/FMEServerShare//resources/data/ However, and here's the really confusing part (for me). When I run the workbench on FMEServer, the log file displays `--FME_SHAREDRESOURCE_DATA' `C:/ProgramData/Safe Software/FME Server//resources/data/' I have restarted FMEServer using the restart functionality, I've also stopped FMServer, checked that all the services have stopp

I am looking to see if there is a method of setting a 'continuation' for counting features in FME.Essentially I have 300 features with a UID of a simple number (1,2,3 etc). I wanted to see if there was a way for when I add additional features into the mix, the UID would automatically populate continuing with the next available UID (i.e. 301)

Hello,I am a youth volunteer with a medieval boys camp. Since Covid hit, we have not been able to attend any camps for safety reasons. I have been given a DEM and an aerial image of the property where we hold the camp and I would like to build a Minecraft World to scale, so we could attend virtually. I found some info about how to use FME to translate the DEM into a Minecraft world, but I need help. Is there someone or some way that you could use your software to help us create this? I am an expert with Minecraft but as a 15-year old, I have no idea how to use FME. Thanks For Your Time, Kaleb McNeil

Just installed FME server and need to create new web connection.Where do I create new user name and password?

I have almost 100 subdirectories, each with shapefiles of the same names, eg:/dir1/FileA.shp/dir1/FileB.shp/dir2/FileA.shp/dir2/FileB.shp/dir99/FileA.shp/dir99/FileB.shp Not only are there almost 100 directories, there are also about 30 shapefiles in each.Is there a smart way to get an FME workbench to read all these subdirectories (they are all stored under a common "mother directory") and files, so that I can merge them into one Shapefile each? What I want is to merge all FileA.shp into one file, all FileB.shp, into another, and so on.

I'm getting "Provider error `(-2147467259) Could not use ''; file already in use.'" in the log when trying to read an MS Access mdb. This raises 2 questions:  1) it's a reader not writer, so why does it care if the file is in use? I have other applications that read mdb fine if it's already open. 2) The final status for the entire script is successful. I would expect the failure be noted at the end. I don't know how long we've been missing this error buried in the middle, and more importantly if we have corrupt data at the end as a result. 2021-2-5 14:21:29 | Creating reader for format: Microsoft Access2021-2-5 14:21:29 | Trying to find a DYNAMIC plugin for reader named `MDB_ADO'2021-2-5 14:21:29 | FME API version of module 'MDB_ADO' matches current internal version (3.8 20200115)2021-2-5 14:21:29 | Performing query against MDB_ADO dataset `\\\\server\\infosys\\xxx\\WR\\DB\\xxxResources.mdb'2021-2-5 14:21:29 | Microsoft Access R

Hello,I have recently installed FME Server 2019.2.3.2 (32 Bit) and have been using it without any issues up until this point. I modified a config property in the 'fmeServerConfig.txt' file and even since then, the manager doesn't want to load correctly. After that, I restored the config back to what I had it at before (when it was working) and restarted the FME Server Services, the machine, etc. Has anyone else ran into this issue before? Have added some screenshots below: Thank you  

See attached screenshot. I have a shapefile with Photo_Name attribute (175 features), I apply a tester on the shapefile to filter the features I need (109 features). How can I then select only the 109 required images from the 175 source images - the fme_basename of my images = the Photo_Name.

Assume I have an automation that starts with a directory watch to capture an updated zip file in a folder. The zip file name is passed as a parameter (File Path) to the 1st workspace. This workspace is followed by a second workspace, which needs to use the same zip file as a parameter. I can not figure out an easy way to feed the File Path (zip file path) to the second workspace as a parameter, other than writing it to a text file and let the 2nd workspace to read from the file. Any advice to make this easier and streamline? The FME server is 2020.1.3.