General

Hiya, I'm very new to FME and have only used it once or twice. I have automated a google sheet to pull in data from Google Analytics using the Google Analytics add-on rather than connecting it via the API.  I have read in the google sheet as the reader and the writer would need to be the Microsoft Excel spreadsheet however when I'm using the attribute manager to tidy up everything for some reason it won't write out to the excel spreadsheet its just blank.  Am I using the wrong transformer?

Hi, I am trying to get a hyperlink when I click on a point map created by html report generator, using esri leaflet. I attach an image of what I got if I use the same hyperlink I have used in the table (correct hyperlinks). What would be a good approach? Thanks

I have a series of records - each is then replicated multiple times by date and then have andother column with either a value or null. each also has a unidue key based on the geom.not every date has a value and thus in null.what i need to search for is for each unique geom find the record that has the latest date with a value in the extra field.needs to return one record per unique idany help appreciated

 I want to define the location of my log file, and tried to set the path together in a File/Url type user parameter. One part of the name can contain letters e.g. ø, å, æ etc and I can see in the translation log they are returned as utf8 codecs (e.g. _00f8_).In earlier versions of FME Desktop was there the possibility to specifiy the character encoding, but it seems like somebody forgot to implement this in 2021.The definition of the path should be as such: C:Temp\$(WORKSPACE_NAME)_$(b_number)_$(municipality)_$(year).log, where 'municipality' can contain special characters. The other thing is of course, that as soon as $(WORKSPACE_NAME) is in the picture i am getting 'Undefined macro `WORKSPACE_NAME' dereferenced in file'. Last problem the log file does of course not exist at the point when I start the workspace. Do I have to create the logfile manually i a startup script?

Hello, I am currently exploring the capabilities of FME Server and I am trying to do a web map application that show the latest earthquakes using the USGS API: https://earthquake.usgs.gov/fdsnws/event/1/ I have already set up a workspace that gets the information and organize it spatially, so I may think that the next step is to publish that workspace to FME Server and schedule a job every minute or something (for example)  but now to visualize that changes in a web interface I have think that I will need send a JSON using a websocket sender transformer and configure my web app to get that websocket and utilize it to display the location of the earthquake? What do you think about that workflow? Do you ever try to do something similar? Please point me out in the right direction. Thanks.

i have cut specific image with clipper but when i use clipper inside ,i found it includes my target and also black parts around the image that i need to have .how could i cancel black parts ,and keep only my target image ?

install FME desktop allways failed,don't know reason​

Hey FME'ers,I just posted a video of how to create tooltips in an HTML report:https://youtu.be/O6gT58AnvuA Basically, I create an HTML table and one of the cells takes up too much space for reasonable viewing; so I turn its content into a tooltip to save space. The important part is the code, which you can't get from the video, so here it is. The content of the cell is created with an AttributeManager as:<span>Hover for more info!</span><div>@Value(attributeName)</div>Then there is some custom HTML to add to the top of the report. Use a Custom HTML option in the HTMLReportGenerator with this code:<style>div {  background-color: yellow;  padding: 20px;  display: none;  position:fixed;  top:80px;  right: 350px;}  span:ho

Hello,  i have question and problem with ShapeFile Reader.I have a lot of data with Numeric field N,12,6 (location_x, location_y, location_z). But separator is set with "," not "."FME is cutting my data.  Can somebody help mi with this issue? In previous version was parameter "Numeric Attribute Type Handling" but for now it's not accessable. QGiS is correctly reading numeric values. 

i have OSM (Openstreetmaps) in shape file and i have found at inspector that it has no color so i would like to color it and get cartographic output that includes suitable color for the map .but i am new in Fme and i am not sure which parmeter should i define at MAPnikRastersizer transformer .is there any method to download the map from openstreetmap ,including the suitable color as Google maps . also i would like to know ,how could i extract specific polygon from lots of polygons in OSM .FME 2018 Thanks in advance   

How to do when I want to create roof shape from dsm data (tiff image) and outline2D(shapefile)?I can only do LOD1. I want to know if I can use data such as slope to create LOD2?

I am using the Amazon s3 bucket modified listener to trigger a workspace and process data as soon as it enters our bucket. Some days ago we had to change the region settings and since then i am getting this error:2021-07-12T10:32:29Z | An error occurred: The authorization header is malformed; the region 'us-east-1' is wrong; expecting 'us-east-2' (Service: Amazon S3; Status Code: 400; Error Code: AuthorizationHeaderMalformed; Request ID: ********; S3 Extended Request ID: *****)The FME server version is 2020.1.3.2, i don't have access to the config files of the server. Is it possible to set the region of the listener manually somehow or a trick to solve the problem? I tried same connection on another instance of the FME server and i had no problems there.

I have followed the tutorial attached link to build a dashboard to report on 250,000 records in a html report. Unfortunately this is my only option since we don't have FME server 2020. I am spending far too long to work out a way to stop the html file crashing as it tries to load all 250,000 records in the table. I am trying to work out how to convert the table to an array or other in javascript but I believe htmlreportgenerator is not designed for this. If anyone has a solution I can insert in the custom html that would be great. <div id="myTable" >               <table class="table table-striped">                  <thead>                     <tr>                        <th>Document Number</th>                        <th>TASK ID</th>                        <th>Document Stage</th>                        <th>Document Version</th>

Hi all, I have two fields Lat and Long which are my geometry fields. From this is there a way to have two more fields that can show X & Y using this information in same table? Reason is when i publish lat and long to my arcgis map it seems to move by 5-10m from the actual point.

Hello,  I have an excel sheet with Lon Lat values and I'm trying to convert them to points and then place them on a map that is in EPSG3857, however, the points don't land where they should be. I write it to a shapefile. Any help would be much appreciated.  I've also tried the AttributeReprojector but what do I select for the Source Coordinate System if it's coming from Lon Lat values? I did not find GCS_WSG_1984.The LON values are displayed without the -, sample: 114.2563, how can I add a dash to makes it -114.2563? 

Hi, I do not understand what is happening here. For example, line 32 doesn't have the same ID, but its still passed. Why?

I have one input and only one output like below  there doesn't have any complication to run but i have nearly 1k+ repeated tasks.https://i.stack.imgur.com/vehJK.png

HiI have 2 feature class, I want to add the attributes from (the green polygons to the other feature class the red polygon) based on the location (Spatial join), is there any way to do this? 

Dear community, I've been scratching my head for a while and I know the solution should be a simple one but I can't seem to figure it out.  I have one source containing a lot of geometry. Each ID can have multiple polygon records. I have a list of specific IDs that I want to filter out. However the feature merger will only take the first record and leave out any 'duplicate'.  Short example: Project|Geometry|Ab1|1Ab1|2|Ac3|1|Ac3|2|Ac3|3|Ak1|1|Ak1|2| Desired result: Ac3 & Ak1Ac3|1|Ac3|2|Ac3|3|Ak1|1|Ak1|2| Is there an easy way to do this?  

create line between two points from two different shapefiles.i have common field (line Numbers) with some of same values, need to draw lines between if the values match with other shape file. like above figure need to draw like Yellow color lines.

I am trying to access an AGOL feature service from one of my clients. I thought the issue had to do with special characters in the group and feature service names, but I get the same error with that corrected. Creating reader for format: Esri ArcGIS Online (AGOL) Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISONLINEFEATURES'Loaded Python module `arcgisonlinefeatures' from file `C:\\Program Files\\FME\\python\\python37\\arcgisonlinefeatures\\__init__.pyc'Creating reader for format: Esri ArcGIS Online (AGOL) Feature ServiceTrying to find a PYTHON plugin for reader named `ARCGISONLINEFEATURES'Loaded Python module `arcgisonlinefeatures' from file `C:\\Program Files\\FME\\python\\python37\\arcgisonlinefeatures\\__init__.pyc'ArcGIS Online Feature Service Reader: Requesting portal informationArcGIS Online Feature Service Reader: Getting list of user content items in 'UNCC_Loca

Hi, I have an angular application which create files(eg:auto cad files). I need to view these files inside the application after generating . Is it possible to integrate FME inside an angular project? If Could you please provide documentation link of it.

Is it possible to split 1 polygon equally into 5 sub polygons based on point density and not area? For Example there is 100,000 points inside a polygon and I would like to split the polygon into 5 parts each part containing ~20,000 points (it doesn't need to be exactly 20,000 but the points need to be spatially in the same area).  

I am encountering the following error. Can anyone tell me how to fix it? 2020-10-22 10:24:56| 0.9| 0.4|ERROR |Python Exception <ImportError>: this version of pandas is incompatible with numpy < 1.15.4your numpy version is 1.15.1.Please upgrade numpy to >= 1.15.4 to use this pandas version

Where (what path) to place the *.fme-file file on FME Server for to use a custom coordinate system in workspaces?Thanks.