Authoring

Is there a way to specify the sheet name when you open an Excel spreadsheet using the FMEUniversalReader in Python code? I am assuming that there is a parameter that you can add to the open() method, but I have looked at the documentation for the open() method and the parameters are not described.  Thanks

Hi,  is it possible to create dynamic parameters for a FME reader? I am writing a FME reader and it would be great if you guys can give my some advice implementing the following idea. The reader parameters include some server information. Once the user enters this information, a connection is established to the server (as background job) and a list of layers (of a CityGML scene/file stored on the server) is given back from the server. This list appears in some way in the reader parameter window and the user can select multiple layers. All this should happened before the parameter window is closed. How can I do that?  If this is not possible: Can a run a (python) script before the user clicks the parameter button (inside the "Add reader" window)? Then, I could use the script to fetch the layer list from the server (using  hard-coded server information) and provide the layer list as static information once the parameter window appears. Again, how can I do that?  Thanks for your

Hi,  I'm interested if inspector has some impact on conversion time? If I have many inspectors in testing and debugging process, how does this affects time needed for conversion to be done?  Thanks!

Is there a way to send multiple emails in the "Email to" box of the subscription? I tried the format that Outlook uses, that is, each email is separated by a semi-colon:  email1@email.com;email2@email.com;email3@email.com  However, no emails get sent.   Thanks

Hi all, I have the data in a table similar to that:   I have been asked to create something like the table below:   Basically, I am grouping by Site, Name, Feature, Subfeature, then counting Y or N for each group, concatenating the years and summing the count.  Does anyone know how to do this? By only using the aggregator I get something like that but it is not exactly but I need:   Any ideas how can I get Count_Dead_N and Count_Dead_Y.  Thanks!

On FME Server we keep getting this type of warning when the workspace makes a connection tothe DB and looks like right before the select statement happens.  Oracle Reader: Column 'DEVICEID' specified on Feature Type but does not exist in table 'S5FFFFF.XXXXXXX_XXXXX_INFO_V' and will be ignored  The view is being read and it does this for each column in the view.  FME workspace does read the view and processes the data.   Any insight on how to make the warning go away would be great.

Hi,  I was wondering if there is a way to make FME use more CPU? I have workflow with GML Reader and Multiple SQL Server Non-Spatial Writers. Multiple writers are there because I need to insert into identity columns in four different tables parts of transformed GML data. Here FME is reading GML and writing it into SQL Server by using 10-13% of CPU. How can I make it use e.g. 70-80%? Memory occupied bu FME is also 500-700MB.  How does this work?

I have a series of overlapping polygons and overlapping las files. Each las file belongs to a unique region that corresponds with a polygon. I would like to clip each las file to the extents of the associated polygon. The polygons contain a unique ID identifying the region while the las files are organized in individual folders identifying the region.  To date I have been running the clipping tranformer on each set of las files belonging to one particular region and manually iterating through all the regions one at a time. How would I go about batching this process? Ideally I would like to read the unique ID in the clipping polygon and use that to point to the associated set of clippee las files in a folder.

I have a network of lines which I want to convert into a polygon region showing the extent of all the lines.  Effectively a bounding polygon.   Does anyone know if it is possible and if so how?  Many thanks Seb

Hello, would anyone have an idea how to reconstruct an original elevation model if only slope-grid and aspect-grid are available? I am looking for a smarter way than this tideous:  1. split the overall aspect to x and y aspect 2. calculate the subsequent x and y slope 3. make an iterative sum over the rows, thus reaching the z values 4. cross-check / average with the same method over the columns 5. calibrate an z-offset at known point 6. make a grid

Hi,  I have 15-20 feature types that have values of the same type and they can be repetitive (e.g. FeatureType1: 1, 2, 3, 5, 4; FeatureType2: 1, 6, 8, 3, 5 and so on). These features are tables from SQL Server with relationships (because of that there are repeating values). I need to change all values of certain (different) attributes in all features to some other set (number sequence that starts from specific number). So, all primary and foreign keys from ex tables need to be mapped to some range. Confusing, I know, but I will try with example too.  Some example of data: Parcel1: oid=224 Parcel2: oid=266 Parcel3: oid=214 Building1: oid=844, parcel=224 Building2: oid=415, parcel=266 Building3: oid=332, parcel=214 Building4: oid=711, parcel=214  Here I need to get parcel oids (e.g.) 21-23, building oids 24-27 and building parcels 21-23, respective to original attributes. New values could start from any number (set as parameter) and there must not be any skippings. It doesn't need to

Hello everybody !  I think the transformer pointconnector don't work normal. I try to connect point from 2 tables which have the same fid. But the transformer can't accept this and there is no error visible on log.  i tried a sorter to classifiy fid in the same order befor transformer but no way.    Also i tried to make same type and same encoding (utf-8) of  fid in both table but no way too.  I checked the correspondance of fid and nothing wrong.  Thanks for Help.

Hi,  This might be a quite simple querry, but I am sure not sure about the solution. When a Wb is made on v2014, some of the connectors are not visible when we see it in the v2015. This creates a lot of confusions and dilemas when batch or workspace runner is used and we don't need to overview each and every Wb. Is there any possible way by which we can check the version in which the Wb is made.  -Shivam

I have an address table where each address point is classified into 1 of about 500 classification codes. I need to reclassify / condense this into just 10 codes: 1 = Code R% = Residential 2 = Code C% = Commercial 3 = Code CE% = Educational 4 = Code CX% = Emergency Services ...etc., where % is a wildcard character  I have tried a couple of transformers, but most don't support wildcards, so the 'best' option so far I have come up with is 10 pairs of Tester+AttributeCreator transformers in sequence. My feeling is that there may be an easier way. Is there?  (Note: I am aware of the overlap in codes. The second line classes all lines starting with C as Commercial, but then the third line reclassifies those starting with CE as Educational)

Hi, I have a workspace whcih I would like to open in my FME 2015. The worksapce was made in an older version and comes out blank if i klick yes to continue in the warning pop up. How can i open my workspace? /Caroline  

I have a list of features, and I want to output a permutation of all combinations of two and two list members to a csv file. Example: Feature 1 List{0} = 11 List{1} = 22 List{3} = 33 Feature 2 List{0} = 44 List{1} = 55 ....more features  Should produce this csv-file: 11, 22 11, 33 22, 11 22, 33 33, 11 33, 22 44, 55    Remark: This is feature 2 55, 44 ....  The lists seem to be fine, I can use AttributeExposer and output single items. So my challenge is to output the combinations while not knowing before rruntime how many list members there are (will most often be 2, and generally less than 4).  I have been experimenting with listExploder to give me one line per list member, but it leaves me with the combination problem. I'm new to FME, so a suggestion of appropriate transformers would be appreciated. Thank,s. Regards Erik 

In FME workbench, How can I validate READER feature type user attributes name, type and width with the predefined values.  for ex in Arcgis(arcobjects) , i do this by creating a predefined list of fieldnames . i loop through predefined list to check if the fieldname exist ,if yes then  i will read type,width,precion,length using pfeatlyr.FeatureClass.Fields.Field[j].Type,  pfeatlyr.FeatureClass.Fields.Field[j].Length pfeatlyr.FeatureClass.Fields.Field[j].Name  similarly how can i achieve this in FME

I'm setting up a workflow to download data from the police.uk API and eventually I want to set it up to run every few months or so to get updated data. I'm using the street-crimes method to feed in a lng/lat string and get all crimes inside the polygon the coords generate. https://data.police.uk/docs/method/crime-street/  This initial bit is working well so far.  The method outputs a single months data and what I want to do is get the httpfetcher transformer to send multiple requests to get several months worth of data.  I don't mind it rerunning this each time as the police may update older crimes so getting updates would be fine.    My thought was that I could build a list with each month I want to request data for and feed that into the target url httpfetcher.  I don't really know if that would work and I haven't really worked with lists yet so I'm not really sure how to create one.    Any thoughts on this approach and any tips on creating the list of months

Hello, ?is it possible to set the "Sampling Amount" parameter of the transformer "Sampler" from an incoming attribute? I understand this value could theoretically change per row of data, but it would simplify our process greatly. Thanks! Using FME 2015.1

I made a custom transformer and exported it to the network. Next I made a new version of the transformer. When I open the transformer for edit, FME asks which version do I want to edit. This is okay.  However, when I add the the transformer to an FME script, it puts in the latest version. What if the FME user wants to use a previous version? Is there a way?  Thanks

I am interested in using parallel processing in a workspace and I understand that the Group By parameter must be uswed. If using a transformer that has two input feature classes such a Clipper or AreaOnAreaOverlayer is it required that the field used, in this case Value, in the Group By parameter be in the attribute table of each feature class? So in order to use parallel processing with the Clipper transformer both the clipper and the clippee would need to have the field Value along with the corresponding attributes to work correctly. Is that correct?

Hi all, has anybody done any work on 1D clustering or segmentation of features based on an attribute?  ie if you had the following attribute values 1,1,3,4,4,4,6,7,8,8 and wanted to divide them into 4 groups there are several algorithms: equal interval:  [1,1],[3,4,4,4],[6],[7,8,8] quantiles: [1,1,3],[4,4,4],[6,7],[8,8] jenks optimization: [1,1],[3,4,4,4],[6,7],[8,8] etc.  I'm particularly interested in jenks optimization or kernel density estimation

I have put a GUI Directives script in my Python start up script that prompts the user to choose a feature. I store the choice in the fme.macroValues dictionary.  Next I want to take that choice and pass it to Python scripted parameters to retrieve settings from a json file. This works when I use the FME built in parameters, but when I use the GUI Directives method I get the error that the Python scripted parameter does not have the fme.macroValues value. Looks like the Python scripted parameters fire BEFORE the GUI Directives, even though the latter is in the startup script. Is there any way to force the start up script to fire before the Python scripted parameters?  Thanks

Hello, I saved some information and coordinates to a PostgreSQL-DB from a php-form. beside this process the website will send an email to the fme server 2015 to start a workbench which perform some clipping with the coordinates and also save some more information to the postgresql. finaly the workbench send me an email for success. Thats the plan.  I didn't understand how to configure the fme server to start the workbench after receiving the email? Thanks for any advice. Lencer

HI there,  I've been running this workbench of my colleague for 2 weeks now and seems to be taking forever to finish. The command dialog box (becase its being called out from python using os.system, very crude method at the moment) is still up and updating but like in a very painfully slow manner. I've checked the temp file and one file is still being updated,  FME_OBJC_SpatialMultiGrids_MasterGrids_.........._1  I dont want to end it because it might waste some data that has been created. Im just not sure why its so slow.  Any tips will be appreciated.  Regards, Chris