Creating and organizing workspaces. How to use Workbench.
Recently active
@david_r @takashi @erik_jan
Dear FME community,I have an attribute from an WFS which has values of more than 200 chars. I want to trim down the length of that attribute because my database only allows for a specific length. Is there a way to "cut" the attribute after a specific length so that it doesen't exeed for example 200 chars. The values after that can be ignored (only the first 200 signs should be taken).Many thanks for your help and kind regardsThomas
Hello,I've got a workspace. When i open this workspace i get a fault. So, I can't read the whole workbench. I am missing a few transformers. Is t possible to view this workbench in a way to see how it's bild?
Hello,I have a shapefile with approximately 200 tiles that contains an attribute value for each (e.g. 52A, 52B...). I am trying to output the data where each individual tile or attribute is applied with a SpatialFilter (contains and touches). The only way I know going about it is by using a Tester and changing the values manually each time I run the workspace. I know a loop can be applied to the workspace but I couldn't find any guidance or documentation on dealing with this. Thank you,
Hi, I would like to create a new custom FME function similar to current "UUID()" function. I have successfully built and tested the "CenterOfMass" C++ sample of the SDK "pluginbuilder" folder.But I have a few questions:The function only works when it is copied in the "plugins" folder. It does not run when it is copied in a "Shared FME transformer" folder. Can I configure it? It is an issue when we have not write-privileges in this folder.The new function is not recognized in the "Attribute Editor Form" as a valid function (Other functions provided by FME have blue color). Can I configure it? Also, I would like to define its syntax and parameters. Is it possible?Possibly related with last question, To successfully run the function I must write "@Evaluate(@MyUUID(...))", it does not run with only "@MyUUID()". What is wrong?Thanks in advance!Alvaro
I'm trying to store the sysdate to an oracle database table; i have already acquired the system date by Timestamper with format "FME Date/Time (^Y^m^d^H^M^S)" and setting my attribute. I get an error when the process is trying to wrtite this attribute to the oracle table. Do I need to use some transformer or oracle string conversion function ? (like to_date('@mysysdate', 'YYYYMMDD')thanks in advance
Whenever I set a workflow to 'Dynamic Schema' all the feature type names in the destination schema differ from the source schema. The geometry type name gets attached to the feature type name. Example: -Isohypsen ->Isohypsen_line-Schutzgebiete -> Schutzgebiete_polygonHow can I prevent this from happening? I want the feature type name unchanged (obviously)
Hi,I want to run a script several times. Every time the input data changes. I thought, this could nicely be done by triggering FME by means of a commandline batch. However, when i start the batch, only the dataset which is connected within the workbench is used. It seems, as if the sourcedatasets from the command lines are ignored. The parameters I have copied from the first lines in the log window. I have simplified the attached workbench to the key issue of importing and writing a shape file. Also attached you find the batch file and some data.Any ideas?
how would i alter a workspace to export files as they are finished rather than holding them all in memory / temp files until everything is processed?the input is about 200gb of Mapinfo files so this is taxing my system quite a bit. FME seems to not write anything until its completely gone through all the files.I have a feature reader that processes all the *.tab files in a folder and clips them where they intersect an input polygon it then saves the files into an identical folder / name structure.FME 2016 ESRI Edition - 16gb ram i7 4790k
I currently have a workspace that determines a file location, and then a workspace runner uses this as the source parameter for the 'child' workspace.If I run the child workbench in isolation, I can specify multiple file locations and both source files are read.e.g. "D:\\Folder1\\File1.gz","D:\\Folder2\\File2.gz"But if I try to use this as a parameter for the workspace runner, no output is read. Is there a different syntax I should be using within the workspace runner?
Morning All,Im trying to select the top two attribute names(calculated by largest values in attributes) of 6 attributes.. i have 6 attributes which contain a number (0-5), This number is then multiplied by a weighting (1-5)depending on the attribute. I do all this in an expression evaluator , ie attribute 1 x3, attribute 2x 5, attribute 3x 2, etc etc. My expression evaluator sums all these attributes to get a total score, excellent. I now need to know which 2 attributes (1-6 ) make up the largest portion of the total score.I have tried with listPopulator for the 6 attributes, then a listsorter, then attributecreator (@Value(_list{0}),@Value(_list{1})). This however returns the original attribute value, not the attribute name..... Any help/suggestions appreciated. thanks steve
I'm attempting to perform some transformations on an ESRI shapefile in FME and am running into some issues. The attributes within the shapefile are all in Spanish. When I export back out to ESRI shapefile, it is not retaining the shapefiles' originally encoded language properties, instead inserting incorrect special characters. Here is a view of the shapefile attributes table in ArcCatalog: Here is a view of the shapefile through FME Inspector: As you can see, FME does not seem to recognize Spanish characters. It hasn't been a problem for us when writing from shapefile directly into our Microsoft SQL database- we just updated user attribute types in the writer from varchar to nvarchar and it handled the character encoding issue perfectly. Shapefiles created in Spanish with ESRI and directly written to our SQL database using the method below retained their original character encoding.For another workflow, we needed to clip a large dataset (Highways covering all of Mexico) to
Dear Support Team, Require your assistance on the below issue. Unable to connect to the floating licence server. Suddenly i lost connection with FME Server. It is unable to established connection. Below error it is showing.Please advise if I am missing something. Or how would I resolve this issue. Thanks in advance for your help.
I received a text file that has descriptions about features as follows: ADD FUSE 9911 { PHASES =1; PORT_A = <123>; PORT_B = <234>; ATTRIBUTE[county] = "SEATTLE"; ATTRIBUTE[street] = "MAIN ST"; ATTRIBUTE[facility_id] = "1324"; ATTRIBUTE[feeder_id_1] = "FD1"; ATTRIBUTE[feeder_id_2] = "Null"; }; ADD 1p_conductor 125623 { ... }; Now, how to create individual features out of these? 1. I tried Aggregator: groupby - text_line_data Separator character: }; 2. Tried to loop text_line_data and break whenever "};" is encountered. But both didn't work. Is there a simple way to do this?
Dear all, Has anyone tried versioning FME workspaces with a versioning software such as TFS? If yes, how did it go? Did you experience any issue? Thanks in advance, Maryse
Hi all,Am I right or since FME2016, we cannot anymore create "Named Database Connections" using FME2015 naming convention?I remember that the connection name was automatically define as:user@server:port/databaseSo now on fresh install of FME2016, I cannot set my previous define named connections because chars : and / are no more allowed. So I need to adapt all my scripts or there is a magic trick somewhere?Thanks for any infos and best regards.Rémi
I have an issue where a dynamic workspace working with hundreds of data sets needs to be able to expose fields if they are DateTime. Due to the sheer number of datasets and fields I don't really wish to hard-code this into the workspace. I was hoping there was a way to expose fields when they are a particular datatype, in this case DateTime. The reason that I need to expose them is due to json not having the ability to write out DateTime fields correctly, they need to be converted to strings using the dateformatter. The workspace is dynamic and may open hundreds of datatypes depending on the parameters coming in. I don't want to have to hard code but I am thinking I might need to expose all the relevant fields within the FeatureReader, I am using FME 2015.1.The date formater works fine but the attributes must be exposed to be able to select them within the transformer. Thanks in advance!
Hello,I need to analyse a number of polygons which represent buildings, the data i need is the inner corner of every point and the length of every segment. I'm using the polylineanalyzer to get this data and this works as long as the polygon is a solitary object. If another polygon is adjacent to the one being examined it seems that the common lines are being kept out of the examination in the polylineanalyzer. The number of lines which flow out of the polylineanalyzer are less than the total number of polygonsegments.Has anyone an idea how to bypass this? best regards & thanks
I have selected certain features from a table based on a certain attribute value. From another table I have done a selection as well to get only one specific feature. Now I would like to add the attributes and their value of the feature of the second table to all the selected features of the first table. I can not use the Featuremerger because the features of both tables don't have any attributes in common.
So i have a workspace that - imports all ascii grid files in a directory - does a raster to point conversion (RasterCellCoercer) - offsets points by half cell size - so point at cell center rather than lower left corner (OffSetter) - adds XYZ attributes (AttributeCreator) - Finally writes to MapInfo Tab filesby default FME seems to import all my ascii files and hold everything in memory before committing the outputs. so my model is a RAM hog.How can i adapt the model so each ascii tile goes through the process one after another which should need significantly less RAM.
Hello, I hope someone can help me with this (i think simple) question. For my study I need to Data Interoperability extension in ArcGIS. The objective is to create a 5 kilometer or 5000 meters buffer around a cycle route in Europe. I must create this buffer with a spatial ETL tool in the FME workbench. In the workbench I cannot find where I can set the unit settings to meters or kilometers. Where can I set the unit settings to meter or Kilometer? Thanks in advance.
Does anyone know what are the Named Web Service Connectios: Google Ad ExchangeGoogle AdSenseGoogle CalendarGoogle DriveGoogle GmailMicrosoft OneDriveat http://blog.safe.com/2015/01/whats-great-fme-2015/... for?I cannot find any reader/writer or transformer. Or are they there for FME Server notification?
Hello,i am trying to dig the basics behind Looping with blocking transformers since I would like to use it in the future.My simple scenario:I've got a point that I buffer with various distances. The first distance is 10 m, and then, step by step, I increase the distance by 5 m (thus 10 , 15, 20, etc.). If the value reaches 100 m the process stops.If I enter the value 17 as the maximum number of iterations 1 features leaves the INCOMPLETE port, with the attribute BUFFERBREITE having the correct value 95 m. As of 18 or further beyond, the ports is empty. This seems to be correct since as of 18 the condition of 100 m is met.Some things I don't understand:1. Unlike with Looping throught non-blocking transformers the Output port "Passed" does not appear in the custom transformer (see pic. above "Tester"). There is only the INCOMPLETE Output.2. The Feature passing through the INCOMPLETE port carries the correct Attribute value BUFFERBREITE=95m. However, if I meas
Hi,Last week I uploaded a custom transformer to hub.safe.com (https://hub.safe.com/transformers/naturalsorter). The NaturalSorter allows you to sort features based on an attribute in a human way (1, 3a, 3b, 10 instead of 1, 10, 3a, 3b). I was wondering what the usual workflow is after a custom transformer is uploaded.It would be nice for example if other people could test it and provide feedback (even though I tested it myself). Is there an automatic way implemented for other users to test, validate and provide feedback? And if not, is it ok if I ask feedback in this way?Thanks for the answers!
I have several custom transformers where I need to temporarily expose the fme_feature_type. To keep workspaces that use them clean I would like to unexpose it, but only if it is not already exposed in the main canvas.Ie. if the main canvas has the fme_feature_type exposed, then it stays exposed after the custom transformer, if it's hidden, then it is still hidden after the custom transformer.