General

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

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 h

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 t

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 2

Hi,i'm wondering if someone knows which mix of transformers i can use to 'align' (extend or trim) polygons along lines? I have polygons of road area and i have a line which is the separation between the road and the sidewalk . the point is that the polygon edge of the sidewalk is not align along the line and i'm looking for a way to do this for thousands of them. In Arcmap, the tool 'Align to shape' is the key to that but definitely not an option for thousands of areas...  thank you for reading this. Hope that someone will help me! Max

I have a transformer that Lists a set of companies in a database schema and then fires off a set of workflows. These end in 5 SQLExecutors which migrate the data into another database. I want to be able to run a final tidy up process after these are all finished. The input must come from the List_Company_Schema process, not the SQLExectors but it must wait for them to finish. How do I do this?

Hello to all. Help me example shema FME or give way the question regarding CityGML RasterRelief. I need to create a raster relief for the city, but at there is very little information that I can understand. I have raster GEOTIFF and how it transform to CityGML ?