Creating and organizing workspaces. How to use Workbench.
Recently active
HiWe are trying to provide a service where a user can click a map and then get back information on all the planning constraints at this location. I can do this using an address search but people may want information for a piece of land without an address.I'm sure FME can do this but can't work out how!
Hi,I have used the FilenamePartExtractor many times with good results. It is very helpful to be able to pass the root folder of the data to other transformers. I have a similar requirement for a workspace, however in this example I wish to use the folder above the root folder as they attribute. For example, if I am reading the Source data from this pathC:\\WINNT\\Profiles\\user\\Desktop\\roads.shpI wish to use the 'user' folder to fanout the Writer to create an output folder 'user'. I will then fanout by fme_basename to create the roads.shp within that 'user' folder.In this instance the FilenamePartExtractor does not work as it it does not cater for anything above the Folder Name/_dirname = 'Desktop' Can someone help me out to extract the 'user' component of the file path so it can be used as an Attribute Value for Fanout?ThanksAndrew
I haven't seen a solution to this problem anywhere despite the fact that the question has been told several times. Scenario: 1 reader and 1 writer. In published parameters you can choose one or many destinations (used by the writer). If one destination is chosen it's pretty straight forward but how do we do when several destinations is choosen? I want to copy all features from the reader to every destination that is selected in the published parameter. I.e. I want to loop the FME-script as many times as there are destinations selected. It sounds simple but not for me, please help me out on this one.
Folks,I have reviewed the questions with similar key words and try as I might I can't get a result. I suspect syntax or upside-down logic is the issue. I have been using conditional syntax all over my workspace so I know the basics.It's a classic output value after testing another field. However the test is a little backward.If Type IN "AB","BC","CD" NO OUTPUT Else OUTPUT sizeSo my criteria is rejection criteria rather than acceptance criteria. The issue is it seems to be getting completely ignored. I have reduce the IN to a single known Type and still no result.I have modified the syntax to include\\not include double quotes, single quotes, no quotes, taking care to remove white spaces, brackets ()Perhaps I'm using the wrong transformer in the wrong place.Advice appreciated.
I combine many feature types to create input for the geodatawarehouse. some feature types have attributes with same names but different meanings. eg: feature type "house" with attributes like "windows", "doors", "number" and feature type "street" with "name" and "number". For to detect the origin-featuretype of the attribute, I'd like to rename them like house.number house.windows house.doors street.name street.number. How can I acchieve this without renaming every Attribute "by Hand"? Thanks in advance. Frauke
I suspect that I am missing some simple setting here. But simple as it might be, I cant find a solution. I have set up a workspace that imports a bunch of shape files and runs various transformers on them. Among these are Attribute Managers for some of the files, where I add a couple of new attributes. But for some reason these new attributes do not get written to the exported shape files. When I Inspect the last step with the same data that is feed the Dynamic Writer everything looks fine. Is there some setting I have missed or do I need an additional step, with a extra transformer, to write the new schema?
I have a collection of lines and I need to first select those within X distance of each other, and then merge into one feature if the headings are the same (within a specified threshold) and they are of the same type (specified attribute).The result will be one line representing a grouping of features that are of the same type and heading in roughly the same direction.Does anyone have any ideas on how to approach this?So in the image below, step one would be to find the groupings of lines within x distance and heading in the same direction.After this selection I want to group them into one feature based on a specific attribute. in the image below, these lines are grouped according to a specified attribute.The end result would be this, one line representing all of the merged lines heading in the same direction and grouped by a specific attribute.
FME 2017.0 (17271) on Windows Server 2008 R2 Standard.I'm using PointOnAreaOverlayer to add 3 attributes from a polygon layer (non-overlapping polygons) to a point layer. The polygons are coming from ArcSDE (SQL Server) and the point data comes from SQL Server with geometry in the Geometry data type. The 3 attribute columns already exist in the point layer and I'm using fme_db_operation to UPDATE them in the Writer. Between the PointOnAreaOverlayer and Writer I'm using AttributeManager to assign the polygon attribute values to the appropriate SQL Server table attributes.If I don't use any parallel processing in the PointOnAreaOverlayer, the translation works and takes about an hour per million points. However, if I group by one of the point layer fields (4 distinct values) and use Aggressive parallel processing, it cuts that time to 40 minutes per million points, but the polygon attributes do not get added to the point data. When I inspect the output from AttributeM
Hi,I would like to access the metadata for a LiveLink directory in order to obtain a list of all sub-directories and files contained within this directory.Does anyone have any ideas on how to do achieve this?I have FME Desktop 2016 and 2017.Thanks,
I would like to have the attribute values in my source data compared to values in an external look up table and changed based on the values in the look up table and then have the new values populated in a different database. For example. Read the Type Column find the value UNKNOWN look at the look up table and change UNKNOWN to UNK and send to destination database.
On a machine with 2 cores, if I start 2 separate instances of FME Desktop from the Start menu, and run a Workspace in each, does this use parallel processing i.e. does each copy of FME Desktop use a separate core?
This is part technical(possibly) but primarily visual.I have a complex workspace where the same source tables are used for writing multiple output features.To achieve this I've just been been running multiple connectors to from one reader to multiple writers.The workspace is getting a bit hard to trace and present to others.I just noticed I can have curved or straight connectors and there's a way to duplicate readers.My question is what are the best ways to make your workspace neat?It it common to duplicate readers and if so are they treated as a single entity when perfroming the translation?
Folks,I have a series of points in one MI table and intersecting lines in another table in a telco network. I need to test each point and get all of the intersecting lines. The result being the ID of the point in one field and a comma delimited list of the IDs of all the intersecting polylines.For other work in this task I've been successfully using SpatialFilters that work well for 1:1 but 1:N where the N's need to be aggregated into a single result seems to be evading me.I don't need a spatial result for this process.Your advice appreciated.
I would like to process/transform individual files (shape) on a dynamic workspace. I have managed to setup dynamic input/export of the files from folders and have some global transformations. All that works fine. But I also want to apply additional transformations to some of the individual files. In order to do this I need to break out the files from the "flow", do the transformations and then join them back again. How do I do this? Specifically the separating and merging. I found references to a feature called Fanout, but this seems to have been replaced?
Not sure if I am doing something wrong, or if it is a bug. I am trying to use Creator + FeatureReader (intersect) to read Planet Data. It might be I havent sent in the right coordinate system? Or something else? Have anyone else tried Planet Data + FeatureReader?
Hi, I'm using a WorkspaceRunner on a workspace that normally starts reading an excel sheet at line 10. When the WorkspaceRunner is applied, it reads all the lines, as though there were no "Start Row" set. To fix this, I tried to set the "Start Row" as a parameter and have the WorkspaceRunner pass that, but this still does not work.
I recently just upgraded to the newest beta version and noticed that some of my FME Hub transformers were stated as "incomplete". I looked at the parameters and couldn't tell why it wasn't working anymore. I then rolled back to the latest release version and had the same issues as well. Is there an easy way to trouble shoot why some functionality would break? I just ended up rolling back to a previous version that works correctly for the time being.The transformers that are giving me issues are the RegexAttributeSplitter and AttributeConcatenator.
I'm afraid that there could be a potential bug here: Updating CSV Writers in FME 2017The attached GIF movie shows a repro workspace created with FME 2017.0.0.1 build 17271. Changing MITAB to ESRISHAPE is OK, but changing ESRISAPE to MITAB causes crash.
Hey Folks,how do you set an output attribute in a custom transformer. I could always just use an attributecreator after and set attribute a to the output field. but would rather handle it in my custom transformer.Attribute A = 1 before transformerAttribute CustomOutputValue = 2 after transformerAttribute A = 1 After transformerbut I want Attribute A = 2 after transformer.note - the numbers in above example are simplified.Thanks,Doug
Hi,Occasionally I need to convert multiple input sources to multiple outputs. I of course use the "generate" option for this to get started.But if I later find, that the many individual connections each need a new (and identical) transformer inserted (e.g. AttributeCreator), how do I do that in an easy way (i.e. without having to add the transformer manually to each connection which is tedious even with copy'n'paste) ?2016 inserts a single transformer on one of multiple selected connection, whereas 2017 collects all selected connections as joint inputs to a single transformer. So someone has been looking into this.Another similar situation:I again have a lot of auto-generated SQL Server output feature types, and want to change the table handling in each from the default "Create If necessary" to "Drop and Create", and also want to change the attribute handling to "Automatic" on each.How do I do that without having to do it manually many ti
I want to automate the closing of FME Quick Translator when I run a .fme file. I have a .fme file that is triggered by windows scheduler to run a .fme file. This obviously opens Quick Translator and runs the routine. At the end of the routine the quick translator stays open. Is there a way I can set the .fme file to close quick translator once the routine has finished successfully?Many thanksSeb
Hi, I am fairly new to FME. I currently have 286 old gdb that consist of 15 feature classes, they needs to be updated to a new gdb. Some of the updates includes: changing a point to polygon, merging feature classes, changing fields name, and also mapping value for subtype. I have already figure out how to update an individual gdb.I was wondering if it is possible to batch process, and update all of the gdb. Right now, I am playing around with batch deploy, but I can't seem to figure out where to start. Can you please help me out? It would be very much appreciated :-)Thanks,Vincent