General

I've few shape files in zipped format that are to be read in FeatureReader transformer. Tried setting 'fme_basename' attribute in additional attributes to be exposed but it's blank. Any thoughts please? Thanks!  

Hi I've right clicked on a table in the sqlcreator and chosen 'Script as select' and done a very trivial where clause. the problem is the columns are all varchar200 and not dates .. what have I missed?

 Expected Generated  

I'm trying to clip some DSM's in geotiff format to a specific boundary. These geotiffs are elevation grids so they aren't multiple bands, instead they are just filled with elevation values.  I'm currently reading them in as geotiff's and trying to clip using the clipper transform however I keep running into a problem. The first is that I'm getting two outputs because the geotiff extends into another clippee section. See below:My last issue, which is a bit minor is that the exported TIFF headers don't say that the raster is filled with elevation grid data. I have to confirm when importing into any other software. See below:  Any help or advice is much appreciated.

Hi folks,It's the first Question of the Week on the new community, and it's all very exciting. If you want to see more of this type of content, don't forget to click the Follow button in the top right of the screen.Today we're looking at a common issue: whether a loop is necessary in a workspace. Question of the WeekIn this question, @hlouie​ asks:Q) [I'm] Trying to find a way of creating multiple records from a range by interval some way of looping, adding 100, create new, looping until max. A) Herman mentions "looping", but the thing is, that's not necessary in this case. Many users who are used to scripting and algorithms often look to a loop as the first solution for a problem, and I can

We've never seen this issue happen before and we have multiple jobs on Desktop and Server using FMEServerEmailGenerators without issue. For some reason I cannot determine the 2 most recent FME Desktop 2019.2 jobs (They are not running on FMEServer) keep sending 2 emails to each recipient every time they execute. I've looked at the email addresses and there are no duplicated email addresses. Has anyone else encountered this issue?

Hello, How can i get the attachments from a AGOL layer reader? Would like to add that to the Emailer transformer, to get that in the attachments from a Email.

I have some FME Workbenches that run frequently (i.e. every minute) and the logs are always working great if I find an error or need to check up on a specific run. I run the workbenches through task scheduler. The log file just keeps growing, and will only refresh if I delete the log file. This is taking up literally gigabytes of space.  I'd like to set the maximum file size for the log file - for example, one MB. That way I can see all recent log files (i.e. logs from the last few days) but I don't have to keep any of the really old logs, and they can get removed automatically as new logs come through. I know you can set the "max features to record" for a log, but I don't see anything about limiting the actual log file. From what I've seen so far, changing the max features to record doesn'

Trying to find a way of creating multiple records from a range by interval some way of looping, adding 100, create new, looping until max. Create starting record at 3700 = Record 1Add 100 to Record 1 for 3800 = Record 2Add 100 to Record 2 for 3900 = Record 3Add 100 to Record 3 for 4000 = Record 4Add 100 to Record 4 for 4100 = Stop, don't create record because greater than max number Input / 1 Record FieldValue = 3700-4000Output / 4 Records FieldValue = 3700, FieldValue = 3800, FieldValue = 3900, FieldValue = 4000

I wonder if there is a slack/discord or other platform that users can social, ask questions and get help?

HiI keep getting this error while my workbench in FME Server is trying to get to a zipped file geodatabase.748Unable to connect to the File Geodatabase at 'C:/ProgramData/Safe Software/FME Server///resources/data//_Automatiseringar/DATA_GEOPIPE_GEOPARK.gdb.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: {}747Installed ArcGIS version is '10.7.1'746An ArcGIS license is already checked out. The product checked out is 'Advanced'745Opening the Geodatabase reader744Notice - Performing envelope query on the `GEODATABASE_FILE' reader, post-filtering spatial predicate in FME743Performing query against GEODATABASE_FILE dataset `C:/ProgramData/Safe Software/FME Server///resources/data//_Automatiseringar/DATA_GEOPIPE_GEOPARK.gdb.zip' 

Hello there I have data with attribute name : provider_id ,the user will upload this data via a published workspace, but I need to make sure the user upload only data with a range of provider_id in the work space I am reading the fme_server user,  then filter authorized provider_id value , now how can make sure the provider_id values in the data is in the range from that excel sheet  

how to convert GeoTiff to Shapefile

Hi All,I am trying to convert the KML file to shape file format using the generate workspace option and getting error . Also i am not sure how i can extract specif information from the KML .I am attaching the KML file here . from this KML i want to extract the folder name which is nothing but the feature id and route 1 and 2 geometry with there descriptions. can somebody suggest how i can do this ?

I use FME 2019.1 to read and manipulate features in a versioned Oracle ArcSDE geodatabase. I recently discovered that FME appears to have made a duplicate of one of my versions with test edits. See the screenshot of the duplicate version names. I have not used FME to write data back to ArcSDE, particularly not with this version. The original version (username JACOLLINS) is protected and still has test edits intact, but the FME_SERVICE version is public and has no edits (nothing returned in ArcMap version changes tool).  Does anyone have an idea as to how this duplication occurred? Thanks!

Hi,I'm trying to make a connection from FME desktop with our ArcGIS Portal using Oauth2.0 application to read FeatureServer from portal. I can get to connect the App from Portal side to FME desktop using webservices manager. the connection is then established. but when I try to read featureserver using reader I get this error. is anyone knows a solution or workaround for this.Error: Python Exception <HTTPError>: 403 Client Error: ModSecurity Action for url( hier is our portal URL)I get same error if I use user name and password. Bet regardsSaman Aziz. 

Hello everyone,please, Im thinking about the most simple way, how to test text string to contain any letter combinations?E.g. I have got some codes - 1B3DDD386MND, 1B3DDD386CDL etc. and I have separately Excel file, where are allowed and forbidden letter combinations. CDL is forbidden string combination, so I need to detect this combination. In Excel, there are thousands of these combinations, so its highly time demanding to put all this combinations to tester transformer with CONTAINS condition.Any tips how to solve it highly effective? Thanks a lot!Lubo

Hello, I have integrated a custom script into a PythonCreator. The PythonCreator executes the code and accomplishes what it is supposed to do, but at the end I get an error message and I'm unsure how to get rid of it. Please see attached screen shot. Any assistance would be greatly appreciated. Thank you!

I am trying to restrict licence on a floating licence server to a certain machine and i did as instructed in here:http://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Desktop_Admin_Guide/FMEInstallation/Restricting_Licenses_to_Users_or_Groups.htmand create a safe.opt in the same folder as safe.exe in the FlexServer folder with the safe.opt content as :RESERVE 1 professional HOST_GROUP groupA HOST_GROUP groupA GIS-TEST2i thought the problem was that i need to restart the server but still not working even though in the log file it clearly says :(safe) Using options file: "C:\\Program Files\\FlexServer\\safe.opt"

Hello and welcome to the second installment of What’s Up Wednesday. I’ll be taking over this weekly post from Mark in hopes of incorporating new or updated articles in addition to FME tips, new builds, upcoming webinars, and anything else that might be of interest.  FME Build NewsFME 2020.1.1.1 (b20614) was released with some fixes which include: Added support for ArcGIS Pro 2.6 PythonSnowflake now allows "." character in table names as qualifierFeatureReader, SQLExecutor: Added null handling when merging attributesFixed FME Server display for some published parameters including the Geometry type FME 2020.2 is available as a beta, be sure to give it a test run!

Hi, I am new to FME. In this ticket I want to share whatever I know. My company purchased 5 FME floating licenses. At the time of purchase, we shared serial number of the machine. And now license file is on that machine. ( I am calling this machine as a server for license). Inside company all FME users are fetching this license with the help of server IP address (server means machine which serial number was shared with a safe source at the time of purchase). Due to COVID-19, all are working from home. Now server machine is at my place. Now others are trying to access my machine for the FME license purpose, but it is not working. Can you please suggest some solution? Note :- we are using VPN for other application purpose.

Hi,  I have an Excel Spreadsheet which is on SharePoint Online which I would like to read the contents of using FME Desktop.  I am already able to use the Microsoft Sharepoint List Reader for reading in the metadata for the particular excel spreadsheet. To do this I created a WebConnection by creating a new connection using the "Microsoft Sharepoint Online (Template) ' and changing the [TENANT] parameter in the 'URL' under the 'Authorization Parameters' settings. I saw that recently Safe released the SharePointOnlineConnector transformer and it sounds like it is just what I need to be able to read the actual contents of the Excel File.  However, when I went to look for the site which contains the Excel Spreadsheet, it wasn't in the list of 'Sites' under 'Download Options' in the SharePointOnlineConnector. A lot of other sites from my company were listed so the connection seems to

Can FME can generate runtime geodatabases? Is this different to a FGDB?

I have a Excel with 290 Rows and i want to Split that Excel at row 42 into different Pages. Result would be 42 Rows at Page 1. Next 42 Rows Page 2 and so on.I thought i could do it with a loop like count till 42 and then count again and filter by <= 42 but its not working.

Hi, I would like to make a map with arcpy in a FME template, how can I achieve it and which transformer should I use?😀