General

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"i thought the problem was with the name of the machine (which i got from running "lmutil lmstat -a -c safe.lic" while it was connected) so i tried again using the IP instead but still not working

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! Rest API NewsRest V1 and V2 Deprecation: As of 2020.0 the REST API V1 has been removed from FME Server. REST V2 has also been deprecated and is no longer being worked on.  FME Community NewsThere is still a couple of weeks left to work on your FME Hackathon projects! The deadline is August 31st, 2020 at 11:59 pm (PDT).

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 be ok. I am assuming it must be some sort of permissions

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?😀

I would like to replace any negative raster cell values with their positive equivalent either using abs(value) or another other means. Is this possible with a transformer, can I obtain the cell value and use rastercellvaluereplacer?Thank you for your help

I would like to write a feature class from an enterprise geodatabase to ActiveMQ. What is the best way to convert the feature class to JSON and write the JSON to ActiveMQ?

Hi, I would like to merge a cluster of polygons up to a maximum size. For example I have 1000 polygons and I would like to merge each with their neighbours up to a maximum size of 72,000,000m2. Is this possible? ThanksB

How can I add a map image to an email.I have a lat long coordinate. I do not have a google maps api key so google maps is out of the question. Any tips would be really appreciated.

Recently text selection in the Text Editor is highlighting characters in a bizarre manner. This happens when I am on a laptop that has multiple monitors attached.It selects text fine if I am using FME on my laptop screen but when FME is being used on one of the larger monitors, characters disappear whilst highlighting several characters.  Whereas when I select it on laptop screen it looks like this. How it should be. It also opens up like this without selecting anything

The documentation for Mapbox MBTiles MVT writer says the tiles are generated in WebMercator (EPSG:3857). Does this mean that you have to reproject first or the writer does this for you?

My httpcaller results in a response body that is made up like a csv: lat,long,timea,b,ca,b,ca,b,c I want the response body to be in seperate columns (lat, long etc..). I tried attributesplitter (both with , and carriage return as delimter)> listexploder > atributrenamer (attr_@Value(_element_index)). But I can not get it to work (it just makes a new column attr_@Value(_element_index)).  

Hi, I have a series of forms to mass produce using an Excel template that has been provided. The template contains checkboxes which require to be checked but I am unsure how to use FME to A) read in the template WITH the checkboxes and B) write out using the template with certain checkboxes 'checked'. If anyone can share any wisdom on this it will be greatly appreciated.

Found an idea which is not an idea and wanted to flag it but then I get "Error: Access not granted: Idea Flag".

Is there a way to extract the hyperlinks from a pdf using the pdf reader. At the moment I can see the text but not the underlying hyperlink. Thank you for the help in advance.

I am trying to convert numerous ellipses into arcs. I cannot find a way to do this. I know I can convert them to polylines using ArcStroker, but we want to keep them as arcs. I am trying 2D ArcReplacer. The drawing I have has 100's of ellipses, but FME seems to only read three of them. I used the geometry filter to filter them out. I also exposed the "AutoCAD_entity" format attribute and did a tester to set that to autocad_ellipse. In both cases it only filtered out three objects, when I know there are over 200.  I am new to AutoCAD (we just switched over from Bentley), so I am not as familiar with the DWG formats and quirks. Any info would be greatly appreciated.

I am trying to accomplish a similar task as Calculating Nearest Distance Left/Right Between Parallel Linear Features https://community.safe.com/s/question/0D54Q000080hDBYSA2/calculating-nearest-distance-leftright-between-parallel-linear-features  and not sure if left right is the correct approachI created a shapefile and my end goal, what i am trying to do for each line, find out if there is a single line to the left and right that is parallel, or nearly parallelfor the time being, i'm trying the use the left right transformer but here is my output Would the left right transformer be the correct one to use? is there a way to check parallel vs crossing?

Hi community, I could use some help.I'm reading an xml, doing some geometric and attribute manipulation before writing out to OGCgeopackage format. I'm having trouble with the writer truncating the attribute values. My understanding is that by default, FME takes the character width from the reader however this seems to be too short for my final values so I've switched over the attribute definition from automatic to manual in the writer and increased the width. It seems to be ignoring this and coming up with a lot of warnings. Anyone know how to fix? Images attached.

Hi, I notice since we have upgraded to 2020.1, when i try to access fme options, desktop teminates without warning or errorTested it on Windows 1809 and 2004, have not tried Windows 7. So i am not sure if it is a bug? On the same PC, i have FME 2019.2 installed - FME options works fine 

Is there any way to rename attribute from  Proper Case to Underscore with BulkAttributeRenamer? Here is a few examples OrgNameComment -> Org_Name_CommentTaxRegNumber -> Tax_Reg_Number  Ideas? ThanksYarko

Hi, how is my community account linked to my webinar subscriptions? Maybe by the e-mail address? Thanks

I have a MapInfo dataset of polylines where each polyline is composed of many sections (this is the MapInfo term). I want to convert to a clean polyline with only one section. What transformer can I use? I only want to combine the sections within each polyline, not between polylines.

I have successfully used readers that point to download links for datasets in the past. I have a situation I am up against now where using this method does not work. I have two different links I am trying to read from: Link 1:http://gis.co.slope.nd.us/This link takes you to a map viewer with a button that allows you to download either a geopackage or a shapefile of the dataset. However, when I try to right click on the download button, there is not an option to copy the URL of the button itself, so I am not able to use a reader to download then process the data. Link 2https://adams.offroadsoftware.com/php/downloadShape.php?isbnai=4e57016981c3155bb6834af1ce0389aed3460eb0343d94d01e8379a88138b68e When I click this link it downloads a zipped geopackage without taking me to a web page. Similarly, I cannot get a reader to successfully read this link. Does anyone have any advice/tips/solutions for either of the above two items? Thank you in advance!