Authoring

Hello World of Safe,as you see in the picture I uploaded, I want to summarize all the rows with the same value in the column "paaranzahl". Is that possible?Best regards, Felix

Hi thereI'm wondering if there is a way to start the same FME-workspace within a loop (input different parameters) and to ensure that the next iteration waits for the translation of the previous one to complete?I have a Python programm that basically looks like this:fcList = ['A', 'B'] # List of feature classesfor fc in fcList: process = subprocess.Popen(fme.exe workspace --featureClass 'fc') process.wait()  The purpose of my FME workspace is to write some data into a database. The Python program starts this workspace with feature class 'A' in the first iteration. However, as soon as FME is initialized and starts the actual translation, the process seems to be done for Python and it begins with the second iteration. This causes the initialized workspace to stop and to re-inizialize with feature class 'B'. In the end, there is only the final class 'B' in my database.I have also tried for fc in fcList: log = subprocess.check_output(fme.exe Workspace --featureClass 'fc') while "TRANSLATIO

Hello world of Safe!A few transformers create objects with the following attribute tables 'Table 1' and 'Table 2'. The attribute 'ID' describes where A is B. I want to combine these tables like you see it in the picture under 'Goal'. First I thought I could merge them with the FeatureMerger, but after that the output just shows the four rows with the ids which exists in both tables.Important: The ids in Table 1 exist in Table 2 in every case. It is not a coincidence!Thank you for answers!Best regards,Felix

We have problems using 64-bit FME (2016.1) to read/write ArcSDE-base. There is ArcGIS 10.4.1 installed with 64-bit background geoprocessing (I can see the bin64 folder) that according to this article should be enough to access ESRI world via GEODATABASE_SDE reader. However when trying to connect with the SDE-base either with existing reader (that works with 32-bit FME) or new one, I got fatal error: Please ensure the connection parameters are correct (server=`Etaklevitus1', instance=`sde:postgresql:Etaklevitus1,5432', user=`levituum_admin', password=`***', database=`levituum', version=`SDE.DEFAULT') Is there somewhere I should look at?Best regards,Raivo AllaEstonian Land Board

Hi,I've added a Python script to be run in a workspace after the translation finishes. I.e. the "FME_END_PYTHON_ENC" tag in the FME file.I can see that it hasn't been run (by other means), but I can't find neither the above tag nor keywords from the script mentioned anywhere in the translation log file.How can I determine if the shutdown script has been run or not (if I can't determine it by other means) ?If it errs, I would like to see some error messages, so I can correct it.Cheers Lars I.

Hi,My current FME workbench uses an AttributeFilter to create separate output ports for distinct attribute values. Each of these output ports then connect to the same 'series of transformers'.Base on the input file that is passed to the Reader, the name and count of the attribute values is bound to change and I would import the attribute values in AttributeFilter everytime to take care of this change and then add or delete the 'series of transformers' according to the output ports of the AttributeFilter.In order to find an automated way to the above, I know I have to somehow loop through each of the Attribute values and pass it to the series of transformers repeatedly. The first thing I did is to create a custom transformer that takes care of the series of transformers and have also added a loop to it.Can someone suggest what could be the way that the attribute values could be fed to the custom transformer and also tell the workbench when to stop.Thank you !(Can python

I need something like this: if the value is NULL or non-existent, then name field as "UNKNOW", else where bring the values assigned to it.How can I tell FME to separate the NULL and empty cells from the numbered ones?For example:feature 1 has attribute ‘someattr’ == blank, then attribute ‘someoutput’ = UNKNOWfeature 2 has attribute ‘someattr’ with a value, then attribute ‘someoutput’ = the value from ‘someattr’ attribute

I have a date attribute in the format %Y%m%d%H%M%S. I want to use everything in 2016, so how can I create a wildcard similar to 2016% ?

Hi I’m currently using the workspace ‘Write Microsoft Word (.docx) with FME’ to produce a report which highlights errors with in the data.What I would like to know is how using this workspace can I create a single word document with multiple tables? Each table will be showing different attribute errors depending on its output from a single workspace.ThanksAndy

Hi Friends,The problem is distance marker's preserve behavior. I have 14 lakhs features. But distance marker waits till last feature to come. after 9 lakh fme gives memory issue and comes out. I dont know why Distance marker to wait. because this is not group function. it can send the each features points as soon as it completes each feature. and write immediately. if the distance marker will preserve the incoming features, then definitely memory issue will come. how can i do that ?

I am trying to create a workspace that when run will pull the current date into python (either as start up script or python caller) and then pass that date out as a published parameter in FME. I have the following in python:import datetime today = datetime.datetime.now() #print str(today) print today.strftime("%Y%m%d")This gives me the date (for today) as 20161103I want to pass that out as a Published or Private Parameter [Start_Date] to be read in a transformer later in the process.I will also need to be able to calculate a date two weeks away and pass that as [End_Date].

I have a work space setup with multiple reader types. One reader will read values from an HTML table to populate attributes within the work space. On rare occasions when reading the HTML table, there will be an empty value from which I currently have the work space set to terminate with a message stating that a certain value was not found.Is there a way to prompt the user for that certain missing value if not found in the HTML table, instead of just terminating the session like I have it set to now? I know user parameters have to be set before the work space is run, just wanted an idea of how to combat this situation.FME Desktop 2017 Beta 

Hey all, I have a point dataset with over a million points. However, I am trying to aggregate them based on their flight number. The thing is some of the points have the same flight number in different counties, so I dont want to use a hullaccumulator because that would take in to account empty areas or areas with other flights present. I have tried transformers like the neighborhood aggregator, I am just unsure how to go about this.I just dont want ArcMap to have to draw over a million points every time I pan to a different area. Any ideas? I have attached an image of what I mean. thanks in advance!

I am new to FME and I love it but I'm stuck on something that I thought should be easy. I want to convert DGN or DWG to Shapefile. I want to produce shapefiles for Point, Line and Polygon. Most importantly I want to retain what we would call attributes in GIS. This is information such as Entity, Level, Layer, Color, Linetype, Elevation per feature. These are visible in ArcGIS if you view as CAD but when I convert using FME workbench these are not carried through. If I look at the CAD in FME inspector I see many attributes but not the ones I need that I can see within ArcGIS. Can anyone help?

I have a set of features in a table that in my example is classed into two types by area - Big and Small. Each feature has a numeric value for the area. In my hypothetical example I need to decide on a sensible number to use to make the decision between small and big area types. I therefore want to choose a value for the area and then check to see how many features below that are correctly classified as Small, how many are correctly classified as Big, and how many are incorrectly classified. I want to be able to loop through a set of values for the area and write out to a table how many are correctly and incorrectly classified for each iteration.I have created a workbench that does exactly what I want it to do for a single value for the area. However, when I attempt to create a loop, nothing seems to be happening inside the loop. I have used statistics calculators to get a count for each classification decision which I believe are blocking transformers and therefore FME creates a sep

I have a few hundred ortho-jpgs, but i want to be able to read only the ones that intersects or are within a polygon.The jpg's are georeferenced and the DWG too and botha re set to the same coordinate system and both show up at the right positions in the inspector when opened individually.This method worked for me using .las point clouds on the same spot, but I cant seem to manage to get the jpg's I want.Is there something wrong with the settings? Thank you in advance,Robin

Hi,I would like to create an output folder based on the input file.I created a user variable <output_folder> and I'm trying to determine the value  using a python script.Below is the error that I'm getting using this workspace INCLUDE -- failed to evaluate Python script `def ParamFunc():  import fmeobject  def output_folder(feature):  feature = FME_MacroValues['featuretypes']  string='C:\Users\Administrateur\Documents\oracle_spatial\tmp'  if feature[10:]=='roads'     output_folder=string+'\shape'  else     output_folder=string+'\mapinfo'  return str(output_folder)value = ParamFunc()macroName = 'output_folder'if value == None:  return { macroName : '' }else:  return { macroName : str(value) }'Program TerminatingTranslation FAILED.  File "<string>", line 5    feature = FME_MacroValues['featuretypes']          ^IndentationError: expected an indented blockThanks

Hi All,I have an excel file with header-1 names and header-2 names. I have used AttributeSplitter and made list for both like header-1_list and header-2_list for each record. Now I want to aggregate the values like mentioned below...If 1 record in excel containsheader-1_list contains 0,1,2 valuesheader-2_list contains A,B,C,D,E valuesOutput should be 15 records which contains 0-A,0-B,0-C,0-D,0-E,1-A,1-B,1-C,1-D,1-E,2-A,2-B,2-C,2-D,2-E as values.(I have attached sample excel file and my progress work bench to this message for better understanding)Thank you in advancePratap 

How does this get remedied?I rebooted my workstation and still get this message...How do I get going again, please?

My format attributes are exposed from the source up to my destination feature class but these format attributes are not written on my FGDB. I can tell which of these formats have values from my inspector. Should I map these format attributes with an AttributeCreator or AttributManager so that they will be written?

Hi!I want to load a Web Map Service into my workbench with the FeatureReader. It works almost perfectly, but I want to use a bbox as a geographic filter for my WMS. The problem is that you can't insert a bbox in the WMS parameters of the reader. Is there a possibility to specify a bounding box?Best Regards,Felix

Dear all. I completed the configuration of a Directory Watch subscription. I spent time trying to check with the Topic Monitoring without success (i.e. no results on the monitoring page). Searching the community here, I found an answer to a topic where an expert suggested to look the subscription log. I did and I found the service working properly. I know that the important thing is that the subscription is now working but I'm interested to know, if possible, the reason why the monitoring page seems not work properly. TIa Roberto   

I have linear spatial data that consists of types (A, B, C, ... J, K) as well as condition (1, 2, 3, 4, 5). I am tasked with creating a list of total length of each type split by condition, ie Length of A1 = 100m, Length of A2 = 30m, ... Length of K5 = 200m.Is there a way I can create a function that splits the input into condition and then measures it without grouping all the output data? Currently I am splitting the data into types, then splitting each type into condition, then performing measurements, which results in dozens of identical functions being run. It seems that this can be streamlined, but I am somewhat new to FME and I am unsure how to approach this.I'm currently exporting the resulting data into excel, if that helps.Thanks in advance!