Authoring

Hi guys,Do you know how I can stop FME to display titles twice when writing out to excel work sheet. Se example below, I just want to display the title in first column and then just add the new month data after the previous month date without the title of the columns.Current_Data_timestamp G03-2016 6.330197Current_Date_timestamp G04-2016 6.742739

Hi there, Is there a way to attach a kml file in a tweet? I know that we can stream a geolocation but would attaching a file possible with FME Desktop?

When running a Datadownload internally - for instance from 32.1.10.32/fmeserver the Email with results contains http://32.1.10.32/fmedatadownload/results/FME_12494A5D_1464079512168_3204.zip When running a Datadownload from another external server to the servers external ip (for instance 82.111.12.101) it serves the Email with result: http://82.111.12.101/fmedatadownload/results/FME_12494A5D_1464079512168_3204.zip When looking at Manage - Administration - Services it gives the correct IP (31.1.10.32) - as they always want to use the internal IP - even though the process gets started through the external IP. I thought the Services tab in the webgui was the parameters used also when generating the e-mails? Any workaround to force the internal adress?

I have a workspace that I can run without error from the workbench, and I have a python script that also has run it in the past without issue. For some reason, now when I run the workspace via the script, it does not produce an error, but the output files it is writing (KMZ) are empty. I've double-checked all the parameters and they seem to be ok. There is an sde reader, which I did change to read a connection file, vs previously I entered in all the connection information. I'm not sure what's going wrong?

I receive data with standard attribute names but some of the attribute names can vary, is there a way of regardless of what the received attribute name is set it to a valueThe table below shows how I might receive data with 1 of 5 different names for LengthSo if attribute name is in received column set to the value in the required column Recievd attribute name Required attribute name LENGTH Length Length Length SEG_LENGTH Length Seg_Length Length Seg_Length Length

Hi,I'm trying to develop my own FME driver (Reader/Writer). In Reader, feature types are created in readSchema function and users can select some of them to use them in their workbench. But when the user run the workbench, I don't know how in the read function I can know which feature types were selected by user ?

HiI have a controller workspace with some DB paramaters. In it ther is one specific FMESJS amongs the others FMESJS. There are user parameters in the controller for DB user, service and password. The controller passes these to the FMESJS.The tnsnames.ora on the fme server has the proper entries for this service. When I run the controller on the server all FMESJS run OK with the supplied DB params, but this specific one. I got the error ORA-01005: null password given; logon deniedin one of the FeatureReaders in the targer workspace (one invoked by the FMESJS).The log is below1  INFORM  0.0  0.0  2016-05-19 14:17:05  FME 2015.1.0.3 (20150623 - Build 15485 - linux-x64)   2  INFORM  0.0  0.0  2016-05-19 14:17:05  FME_HOME is '/apps/fmeserver/Server/FMEEngineUpgrade.2015.1/'   3  INFORM  0.0  0.

Hi , I'm trying to generate a batch process to convert "n" DGN's to "n" differents GDB's. I know that with the workspaceRunner I could do it , but I don't know how to create different ouputs for any input , Any idea ???. Thanks in advanced for your help.Regards !!

Hello, is it possible to log directly to the windows event log?

Hi, I spent a little bit of time to list many Database Connection under FME Options/ Database Connections. There are now available to me in the workbench as Named Database Connections. I found the .data sqLight database and want to share it accross to save time for other users.When specifying the DefultPath I've got two issues:the select folder button doesn't allow me to select a folder but only a file (same for the shared FME folders)If I specify my new .data file it's not recognised after FME restart.Is there an stable way to share this connectionDatabase on a shared drive and use it as a centralised resource for all users, including FME server? My understanding of all this is that I can see only the named connections of my own personal user. If I edit the user attribute with FME the SQLlight DB .data file I can view all connections.Is there a way to view them all whatever user I am?FME version: 2015.1.2 bui

Hello Guys I have shape file with many district and each one have built area and planed area as value but no geometry to differentiate them we only have the district boundary ,is there a way we could have each area colored according to the their value taking the center of the district as center point same as pie chart.or embed pie chart in the polygonThanks

I am trying to create a DBF file. Even after setting Manual attribute definition, all the attribute names are forced to UpperCase instead of Mixed Case which I want. Please let me know if I am missing any parameter settings or if the answer of this issue is know.

Hi, has the dockable help window been removed from 2016.0? Cant seem to find it in the same place as 2015 and previous versions - this was a really handy feature

I want to mimic the process of joining another table to a featureclass and calculate an existing field based on the join table for selected records. Since I have several fields I want to update, I thought FME would be a good option.Does the process below look like the correct approach?Do indexes in the database help? Or is FME handling this in memory?

I'm working with a workbench which is supposed to check if several attribute values ( five attributes) exceeds a limit (each attribute has its own limit). I'm using an sqlexecutor to get the feature and one for getting the limits. If one of the values exceeds the limit I want to write the name of the attribute and value to a string variable. I've tried using a testfilter (5 testqueries) connected to an attributecreator and stringconcatenator, but this doesn't seem to work since I only have one feature on the testfilter input.Does anyone have a good solution for this?

I have a spatial relater transformer that is intersecting two feature classes. When I change the Input is Ordered by Group parameter to "No, the attached tester transformer (which is testing for the intersection) works correctly passes values of yes it does intersect or no it does not intersect. When I change the Input is Ordered by Group parameter to "Yes", the same tester passes all values as does not intersect.Both feature classes are intersected with the same grid feature class and the attribute names are the same, I also have two sorter transformers one for each feature class to ensure they are sorted in the same order.Any help would be appreciated! 

I’ve been trying to aggregate some GIS layers with a common attribute and running into all sorts of problems. I’m also new at this! For testing I’ve just been trying to aggregate one line layer (eventually lines and points) and I’m a little confused at my results.It’s merging only some features together, not all. I need them all merged together that have the same attribute, in this example FeederID. As mentioned eventually I will want lines and points together as one layer all grouped by FeederID.This is what I'm doing:This is what I'm getting:Am I doing some sort of rookie mistake here?

Hello all!I am excited that, in FME Desktop 2015, it is possible the control the order in which multiple creators run - and it is also possible to set the order in which readers are initiated. However, can I cross pollinate?  I have a workspace (image attached) that contains two separate processes. One process is initiated by a creator, then runs a custom transformer (the ControlTableCaller - also shown in attached image). The other process is initiated by an Oracle Spatial reader. I need to make sure that the Creator-initiated process ALWAYS completes before the reader starts reading.This is a small part of a larger process, so I would like to avoid placing these in separate workspaces if possible. Is there another way to control the order?Thank you!!Courtney

I'm trying to mimic the FeatureWriter available in FME 2016 in FME2015.1 since upgrading is not an option. I'm using a pythoncaller with FMEObjects to try and do this. As a basis I use the sample python scriptBaseLineWriter.py that came with the installation with FME. I start out by creating a unique filename for my GDB, then I a getting the schema from the feature, set the schema on the writer and write to the GDB. import fmeobjects from fmeobjects import FMEUniversalWriter from fmeobjects import FMEUniversalReader import random import os, sys# Get variables and create output name for temp fGDB folder = FME_MacroValues['FME_SHAREDRESOURCE_TEMP'] ext = '.gdb' current_files = os.listdir(folder)# Get a list of current FGDB's fgdbs = [] current_numbers = [] for curfile in current_files:  if curfile.endswith(ext):  fgdbs.append(curfile)

I have installed 32 bit FME Desktop and created a workspace where it transfers a feature class from one file gdb to another . I have made the source dataset path as published parameter . I published the workspace to server and when I run the service I am getting below error   Unable to perform any licensing related tasks.  This is a 64-bit version of FME which requires a 64-bit version of ArcGIS Server. Or download and install a 32 bit version of FME. Refer to this this article http://fme.ly/qua for more details    

So as the title says I have an ID field that goes from 1 to 6 and it repeats for the next set of Attributes, I wanted to use this to create an Aggregate field. to bring each set of attributes under their correct fields.

Hi,I'm new to FME and this should be an easy thing to do. I'm trying to work out the distance of buildings and waterbodies from a structure foundation using the neighbour finder and exporting to Excel. I've been able to work out the distances but I end up with the building distance and waterbody distance on 2 separate rows with 2 identical foundation references as shown below.I want to be able to combine the 2 distances (Building and Waterbody) onto single line with a single foundation reference like below. How can this be done?

I have a polygon layer that I want to use to clip some other map layers and write out the results to a series of GeoPDFs (one for each polygon).I’ve made a workspace that does it for individual polygons. From there I had hoped fanout would work to create individual files, however the Page Object in the PDFPageFormatter scales to the entire extent of the layer, not each individual polygon.Is there a way to pass the individual polygons through one at a time and have them trigger the rest of the workflow as they go? I have attempted variations using WorkspaceRunners or Looping in a custom transformer) but none of these seem to result in anything getting passed to the writer.

Hi,I am trying to use a websocketreceiver to take a feed. It connects and and provides details saying that it require authorization, which it does.Now the question is how? Is it something that should be sent in the preamble, or do I need to use a websocketsender to send it first. I have tried several ways but that maybe the input is wrong.Below is the input without the signature:{"version":1,"user":"interpret.co.nz","product":"com.metservice.blitzen","document":"{\\"bounds\\":[{\\"south\\":-53.0,\\"west\\":154.0,\\"height\\":24.0,\\"width\\":35.0}],\\"timeout\\":1460203200069}","expiryDate":"20160409T120000+0000"}We have it working in java, but we want to do it in FME, as we will be able to streamline the whole process into FME.Any help or ideas appreciated.Cheers,Todd

Hi,I have got a workspace which is reading from a big dataset of spatial data, and then runs a dissolve and aggregate before outputting into a postgis database. This process can take a very long time, and I wanted it to run in batches e.g. take the first 1000 unique objects and run the process on, and then the next 1000 etc...any ideas please?I have tried looking at some batch processing documentation but not sure this would help.thanks