Authoring

Hi,I have a couple of lists with dynamic size (e.g. _energyList, _powerList, _timeList, etc...). I would like to merge these lists together in order to get them prepared for inserting them into the MySQL database.At the moment, I get the lists merged together indeed but in a sequence, perhaps the snap shot below could make it clearer:And of course this is not what I'm trying to do. I need to get the _timeStamp and the _dataEnergy, etc... at the same row.One possibility could be, to use ListExploder to each of the lists and insert each one of the items into its relevant column in the database separately. But this doesn't seem to be the right approach.The goal at the end, is to create a list that is ready to be inserted into a database table that looks like the following:

Wanted to move from Physical to VM windows can FME supports? don't want to go for floating licenses as we are sure that only one user going to use

Hello,I have a workspace where polygons and points are combined using a NeighborFinder, creating a list of points close to my polygons. Depending on my inputs (various .csv files), these points have different existing attributes and many that are missing. My method for finding the highest value per polygon for all nearby points was to sort the resulting list of close candidates by descending value, and then use an AttributeCreator to extract the list{0}.attribute value to a proper attribute. I do this for about a dozen attributes, some of which are missing, depending on my input data.My problem occurs when the ListSorter gets to one of these missing attributes. My expectation was that the list{0}.attribute would simply pass on a null or missing value, but what happens instead is that the list is removed entirely, or at least all list elements seem to be. Inspecting my polygons immediately after the ListSorter shows that none of my polygons have a list value anymore. Is

I have a custom transformer that I wrote called "SequenceGenerator", and have been using it for almost 2 years. It resides in a shared folder on one of my servers so other staff can use it in their workbench files. I just upgraded to FME 2016.1 this afternoon and opened one of my workbenches that has this custom transformer in it (as a linked transformer, not embedded). Unfortunately, each instance is now pointing to the one from the FME Store (which is downloaded to my C:\\Users\\xxxx\\AppData\\Roaming\\Safe Software\\FME\\FME Store\\Transformers folder automatically). If I delete the downloaded one, as soon as I open this workbench again, it re-downloads it. This effectively blocks my own custom transformer.Do I need to start namespacing my custom transformers with a prefix or something to prevent this? How can I specify that custom transformers stored in either my \\My Documents\\FME\\Transformers or the configured shared network folder take precedence over

I have 2 shapes, both have the same primary key (ST123).The first shape has 2 attributes filled and 1 empty (height), the second shape has the primary key and Height-attribute filled.How can I load the height of shape 2 into the empty height-row of shape 1, based on the primary key: ST123 without adding the information into an extra row.Example:IDwidthheightSHAPE 1ST12310<NULL>SHAPE 2ST12315RESULT SHAPE 1ST1231015When I use the attributecopier/ attributemanager in FME then I get an extra row with in row 1 ST123 and the Width and in row 2 ST123 and the height.Thank you, Marlies

In FME Desktop, how can we send an email to the desired audience once the translation is successfully complete? Its possible in FME server, but can anyone help on this if its possible using FME desktop as well? And if yes, then how can we achieve it?

Hi folks. My first question on here so I hope I'm not being a bit dim. I'm relatively new to FME in general and certainly not a regular user.We are having a problem with a Published Parameter (something we are new to!).When we launch a workflow we would like a popup that asks us to choose a scale value from a list of options (250 & 800 in this case). We have done this with a User Parameter with these settings: (Note no Default Value is set)On launching the workflow, it does indeed popup and ask us for our choice - here we have chosen '250':We press OK and the workflow continues using that Parameter.However, Next time we press Run we do not get the pop up again. On inspection, the User Par

Is there a way to automatically remove the third dimensionI have an old program that I use sometimes and after conversions from dwg to .shp andafter that I still have to use an avenue-macro to continue the conversion to an 2d shapefile

Hi,Is it possible to define, inside a custom transformer, a published parameter corresponding to a named database connection ? The idea is to develop a generic custom transformer that manage metadata tables. This custom transformer must be able to work on differents database/schema. Thanks,Thibaut.

Hello FMEers,i'd like to define one published parameter which will use one of others. For example, I need to create statistical data by roles (parameter ROLES) xor by users (parameter USERS). If I choose by user, I want the ROLES parameter to be deactivated. After that I can choose which user... So, question: how can I achieve that.

I have a fairly large project in Workbench (FME 2016.1.1 Build 16609).I have the option "Run with Full Inspection" enabled, which has worked great for a while to inspect the features I want to visualize. However, when inspecting using this approach now - it takes the Data Inspector between 10-30 minutes to retrieve the data. It doesn't seem to matter if it is 10 features, or 2000. Data Inspector require a lot of time in both cases. There are probably around 100 'boxes' I can inspect, ranging from 20 000 features to 10 in them.I have tried upgrading to the newest build, and purged temporary files.Using the Inspector-transformer on the other hand, results in a an instant visualization of the features when the Workbench is completed.Is this simply because the amount of features stored as ffs has become too big? Or are there anything I can try to troubleshoot this issue? Memory use seems to be fine when looking at Performance tab.

Hi,I'm running two instances of FME on the same machine, one 64 bit (running with a long-running job), and one 32 bit running a small job.Whenever I enable "full inspection" in the 32 bit instance, the 64 bit instance immediatedly responds by turning full inspection on here as well, at least visually.Is there a "leakage" of settings between multiple instances of FME, even across the 32/64 divide ?Is this "leakage" real, or just an unwarranted display issue ?Cheers Lars I.

Add a prefix that is a constant to all values of a certain field (attribute). For example: Name, Age are 2 values of a field then they are to be replaced by Old_Name, Old_Age

Hi all,  I would like to update attributes bases on certain keywords. My reader consists of XML files, writing to an Access DB.I'd like to do the following:If in the column Official_name a certain keyword is detected I'd like to have the columns Category_main and Category_sub updated by various values.E.g. Official name is "B&B; FME City" - keyword B&B; is found and Category_main should be updated to Hotel/Motel, Category_sub is updated to "Bed & Breakfast & Guest Houses" Official_name Category_main Category_sub B&B; FME City Hotel/Motel Bed & Breakfast & Guest HousesMany thanks,  Ed

Hi everybody ,When I configure the Fanout output for a FME process like in the attached image , It generates me correctly the file , but without extension.Anybody knows how can I give the extension DGN to the output file ???.Thanks !!

Hi ,I have 2 input readers , a GDB an a DGN files , and 1 output DGN file , and I need to execute the process in a batch deploy , with a input directory and a output directory , but I don't know how can I do it if I have two inputs.With one input is easy , with a path reader sending any path input to a workspaceRunner , but with two diferent inputs ?? any idea ??.thanks for your help !!

Hi again ,I have the attached FME project ( Image ) , that execute another FME in batch. The problem is that I haven't writer in this FME project , because I don't need it for the batch process , but without writer I can't create the .bat (Batch deploy) of the diagram , is disabled.Any idea to put a writer that let me generate the batch deploy ???.Thanks in advanced for your help , is great !

I created a spatial ETL tool that essentially exports GIS features from an enterprise GIS to individual DWGs by fanning out on a attribute. The attribute is associated with a specific site id. Additionally, I leverage the joiner, test filter, and reprojector transformers to reproject the individual fan outs into the appropriate projected coordinate system. These associations are defined in a list, hence the use of the joiner and test filter. This works well, but some sites need to be combined. So, my thinking was to leverage a feature class that contained envelopes to define the output extents and the data output associated with these extents by intersecting the envelope feature class. Is this possible?

Hi again , Another question please. If I have two diferent readers , one is a GDB file , and the other is a DGN file , how can I generate the batch deploy ??? Actually only let me add one source dataset , the DGN or the GDB but not the two at the same time. Thanks in advanced for your help !!

In a custom transformer, I tried to use BulkAttributeRenamer to add one of the parameters as prefix to a selected set of attributes, see attached image. But it does not seem to do anything in 2016.1 version. Wonder if anyone has an workaround. Thanks!

Hi  I have a workflow where we are calling a custom arithmetic function (DoubleAsRaw64) to generate a new attribute value based on the old value - this happen in 20+ workplaces on many different attributes.   We currently do this by using the AttributeManager and: 1) Checking if the attribute value has a value 2) If it has a value then we do @Evaluate(@DoubleAsRaw64(@Value(NameOfAttribute)))  I would like to encapsulate this in an custom transformer where I would just have to check of the Attributes on a list - and the the transformer will then apply the DoubleAsRaw64 function on those attributes. This would create a cleaner workplace and minimize the risk for typo etc.  I have tried to create a super simple custom transformer with one Attribute List as a published parameter Attributes_to_Raw64. And a single ExpressionEvaluator set to overwrite the attributes in $(Attributes_to_Raw64) the Arithme

Hi Guys,is there a way to specify the name of the kml file that is created inside a kmz file? I'm writing 3D building models to kmz. It isn't a problem to define the name of the kmz itself, but inside the kmz (which is a zipped kml with the "models" folder containig the collada files) FME creates always a doc.kml.Thanks for helpingwhkarto

Hello,I'm looking for a help with a workspace runner. I will try to explain what I'm trying to achieve.1. I have a polygon and I want to find out what grid tiles this polygon intersects (step 1)2. I want to use each tile and intersect it with a polygon dataset, do some transformation in between and write the result as shp or tab file (step 2 main workspace)I found an example here: http://gis.stackexchange.com/questions/111020/how-to-batch-run-an-fme-workspace-on-a-feature-basisBasically, I want to take one feature from output of step 1, use the feature as an input for my main workspace (step 2), write the output and move onto another feature.Is this feasible, possible, doable? Thanks

Dear FME community,  we are currently using 5 licenses of FME Desktop and we have recently bought the FME Server to automate our geo processes further. I have a question regarding of what can be done with the server technology and if the use case we have in mind can principially be implemented.  Our road network is published via a Web Feature Service (WFS). I have a desktop workspace that adds attributes from an XML file to this road network of lines. The problem is, that the attributes are dynamic. What this means is, that initially I don't know which attributes are in the XML file. It could be only 10, or more than 100 (as an example) and the names are unknown.  We now want to create a website where the user has the ability to upload an XML file with an arbitrary number of attributes. In the background, the FME Server is supposed to map this file to our road network from the WFS and add the attributes. I imagine a site where the us

What does FME stand for? Okay, I know the answer, but do you?