Creating and organizing workspaces. How to use Workbench.
Recently active
When I use a PythonCaller (on build 16673) to set the feature type by callingfeature.setFeatureType('something')it actually doesn't seem to do anything, because when I connect a FeatureTypeFilter transformer to the PythonCaller and filter on 'something', nothing comes out of that port. I discovered that it only works if I do:feature.setAttribute(fmeobjects.kFMEFeatureTypeAttr, 'something')Where kFMEFeatureTypeAttr resolves to the string 'fme_feature_type'. But then what is the point of the setFeatureType() method? Is this method actually not implemented, perhaps?
Hi,A simple question:Is the index range in an FMEObjects FMEAggregate geometry parts list 0-based or 1-based ?The documentation doesn't say anything about this either way.It's for code in a PythonCaller.Cheers Lars I.
Hi,I'm having difficulties with the following problem:I'm having X polygons (with unique ID)(lets assume 1000 polygons) and Y points inside those polygons. First I do colorsetter so see which polygons are disconnected. So I have X polygons with an attribute _color (with 5 different possible values). Then I use spatial overlay to know which points are inside a certain polygon and in the end I'm using a statistics calculator to count the amount of points inside the polygon. As end result I have X polygons with as attributes: unique ID, _color and count of points.Now I want to split these X polygons into Z groups (public parameter, let's assume 10), but in a way that these 10 groups contain sort or less the same amount of points.Does anyone has some ideas to group them on an average? I don't mind the amount of polygons in a group. ex group 1 can contain only 1 polygon (as it contains a lot of points) while rest of the group can contain 11 polygons.ThanksVAT
Hey guys I am trying to figure out how to clean up some data before using the google geocoder transformer. Is there anyway to drop text from my address column that is messing up the geocoder, i.e. apt or suite number?I was thinking some kind of string splitter or something, but not sure. I have attached a screengrab below, thanks!
Hi!As the topic tells, I'm wondering if it's possible to write dgn file with xattributes?I have dgn file with building information in it as xattributes. Im trying to write it through fme back to dgn file with all the same features.Just to see if its possible. And there is some projects where it might make my working bit faster.Regards,Aki
Hi, I'm trying to use a featureReader to read a spatial table, however I need to link to a non-spatial table in the same connection to complete some filtering within the where clause. However it seems that the featureReader only allows either/or rather than both types. The reason for using the featureReader is i'm told its quicker.My question is can you use the featureReader with spatial and non spatial tables (oracle) within one? if not what would be the best way to accomplish this?
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.