Authoring

Hi,  I use the readerprompt widget [1] and pass all parameters to my reader using RUNTIME_MACROS (as described in the link). One of the returned values is a password (GUI type: password [2]), like:  "RUNTIME_MACROS,...<comma>USERNAME<comma>bob<comma>PASSWORD<comma>fme_decrypt<openparen>MDowfCN8I3xcG3GQ<solidus>TeRRUJUZ5LDPtdvpscbh7Nj9gG<solidus>INBkAGA+fkaDrNbhZtfa3rmkUUrCxKWaAFwiYsKgWJNl<solidus>0mRpxUuP+IT2c+Qhh26JEZtUWAmpuoaQCdQ3ykKWm2zaoAM5MBCGaGEuYe+6AS07<solidus>nLNRJwqp1jdwP1FgVCbXRvZtWfKjEZlNJYQ+EicVc6cv2DxCYJyTljvXwF8mKxenML6FKJiHARQCO8OMJidKKZQJP1SeYIhqB0YrtGw4cGV2ZquQKifvRjB2Tl6wBAWDmeCg+R1jvft1tR17SISyTDv77K+mV80w2aaUSgybbF7coM0BrQPcpehfjlW+YxV73+9mPMFXKQeznZ22T8MJor57O44p8U2NQCw35HiFBs0oVP9VkkY0D<solidus>WzGRevseyX1pIEWJSQSFwkJVhiyXavMDz5E5SEYgTZHfVeGBXCDuIEEbfRRkPU5yD2nw2ZAVimDRD7UQhEEY6PosGqU17He4y35WEfAggQ40+EKuupOQSZRsKotTTqlYGHJtX49ymuKqfyZzOAUSUzDMcj8gfDgzOCcuhw2sK3fJaMsz9ZV9+y<solidus>Vf7hyk9rwq4

Hi,is it possible to define the reader attribute names via commandline or via an external file?I have excelsheets where the column name is different e.g. somtimes they are called FMEA, von_km etc. The excel sheet is uploaded by users on a website. On the website they specify the worksheetname and the column name how they are called in their excel file. An other problem is that the they are not always in the same collumn position. Thank you for your help.

Hi all,  I'm very new to FME (today), but am trying to learn some bits and pieces. I followed the webinar on this video (https://www.youtube.com/watch?v=WoKIRD1RQ88)and managed to get it working well.  I'm trying to set up a very similar situation, with the exception being the webservice is soap-based. I have the XML template I used to check the webservice is returning results (through SoapUI), but I just don't know how to incorporate this into FME. I have tried using the SOAPSender, but I can't download it from the FME Store. I have downloaded the one at this link (http://fmestore.safe.com/transformers/SOAPSender.htm), but it's a little beyond my basic knowledge.  I've had a good look around but can't find much on this topic, is anyone able to guide me in the right direction? Any help is MUCH appreciated.  Kind regards.

Is there some kind of FME workbench checker? Just to be sure that the workbench comply to adjustable best practices? like if there are  - some bookmarks - some annotations - hide unused attributes - no single input ports ..... (What else? some lists about best practices?)   

How can i make fme to close all idle fme.exe that are still in memory after workspacerunner is done?Actually these fme.exe processes are idle also during workspacerunner. I don't know why fme keeps ignoring them but i would prefer to have them closed if they are not necessary (3 out of 8 fme.exe are actually working. the rest are 0% CPU / 0.3mb used and the PID is the same all the time)

I have to 'morf' estimated line-fragments between endpoints in a network. I know where the endpoints have to go, so making control-vertices and feeding those to the rubbersheeter exactly does the trick if I feed it one feature.Feeding it a whole lot of features and controlvertices makes a mess, as a lot of network-repairs are spatially grouped. With many FME transformers the group by (a unique identifier) solves such problems, but the rubbersheeter (and the AffineWarper) don't have this.Calculating the values for a scaler, ofsetter and rotator (= affiner) is quite a hassle giving the things I 'know' at the desired point in the workflow, while the rubbersheeter does this in a natural, smooth way.Does anyone have a neat solution for getting the effect of a group-by option in a RubberSheeter?Kind regards,Martin

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:I checked the thread below but it didn't do the trick.https://knowledge.safe.com/questions/24685/merge-list-on-index.htmlDoes anyone maybe have an idea on how to get it to work?Thanks a lot!

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 this intended be

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 the FME S

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 Parameter settings now have a Default Value set as per our choice on the first run:So I guess i have two questions:Why/How is the Default Value being set?Why does the choice pop up not appear on the second/subsequent running of the workflow?Thank you in advance....

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?