Creating and organizing workspaces. How to use Workbench.
Recently active
Hi All, I want to terminate the entire workbench translation, if any feature passes through it. I have used the messagelogger and used "Error and Terminate" option but it is providing the message and continuing the other routed translation... I have also used "Terminator” and changed the "Terminator Redirector" to Inspection but result is same. Are there any transformers / other procedures or I have to change any settings to terminate the translation. Kindly suggest... Pratap
I have created a published parameter and set the default value to 'None' so that I can test if the user ran the translation with the prompt. The first time that the user runs the translation (if they didn't select a valid value for the parameter), the value is 'None' which causes the script to abort. However, when the user then chooses a valid value for the parameter and runs the translation, that value "sticks" with the script. When the user runs the translation again, the valid value is still there, not "None". I want to ensure that the user runs the translation with the prompt each time. Is there a way to "unstick" the value that the user has selected the previous time that they ran the script? Thanks
Custom transformer with loop
I have a client who is using an ESRI specific coordinate system that FME does not 'natively' support. Normally not an issue as the ability to add custom coordinate systems is well documented. However, as my workbench will be passed off to the client in-house and out of my control (won't easily be able to show them/help them build in the .db file), I am hoping to embed a more elegant solution. For instance, I am hoping to hard-code ESRI 102003 projected coordinate system into the workbench so that I do not need to use the ESRI reprojector (it's a blended home with both Mac and PC and OSX does not support the ESRIReprojector.) Basically, can I either a) embed the WKID of ESRI 102003 into the workbench or b) use a feature that will always be in the "correct" coordinate system, extract the coordinate system, and reproject the other features using that?
Hello, I wiould like to convert csv file which has Lat/long in atrributes to KML. I am adding point to KML using "2DpointAdder". It works fine if I have static source schema. But I have csv files with only Lat/long as common attributes and other attributes may vary. e.g. CSV 1 contains "Attr1,Attr2,Lat,Long" CSV 2 contains "Test1,Test2,Lat,Long" CSV3 may contain "Lat,Long,XYZ,ABC,DEF" What is the best way to convert these csv to KML? Cheers John
Dear All , We need to merge discounted boundaries , we tried dissolver but it only merge connected boundaries , to be presented as one feature with multiple boundaries . Thanks in advance
I am quite new to FME so forgive me if the solution to my problem is obvious. I have 29 libraries of DNC data in Vector Product Format that I need to convert. It seems to me that this shouldn't be too complicated, but the problem is that each library has different feature types, for example "gen18a\\grt" is specific to library 18. My initial tries have been with a powershell script (something that I'm also new at) that looks like this: Start-Process 'fme.exe' -ArgumentList '"C:\\Users\\mbu\\Documents\\My FME Workspaces\\DNC_conversion.fmw"', '--SourceDataset_VPF_DB C:\\Data\\DNC\\DNCDX012_025_Japan_North_Pacific\\DNC12\\DHT', '--FEATURE_TYPES "<All>"', '--FANOUT_DIRECTORY C:\\Data\\DNC_converted\\M6M\\DNC12_test' Obviously the FEATURE_TYPES line does not work, but it illustrates what I'm trying to do. The full list of feature types needs to be read and passed to the writer for each library. As I
Hello, My core runs on a windows server. My Fmeserver web app runs on linus server. For a sync datadowload service, I get my result with the correct URL and a good zip file. But wth the same wkb in async, I receive an email but tne URL is bad, I beleive {@getFileName(@zip(OutputLocation))} doesn't work. Has anybody he already had the problem Thank you Raphael
Hello, The published parameters can be provided to the workspace using the HTTP POST or GET method. Assuming the GET method is used, then the syntax for the published parameter URL parameters is as follows: http://hostname/<service>/<repository>/<workspace>?{ParameterName[=ParameterValue]&} but I'm not sure how to provide published params using POST. Could anybody give me an example of this? Cheers, john
Hi, since upgrading to FME 2014 I have been having trouble exposing attributes. For eg, when I expose FME_BASENAME in the reader, this does not carry through to all my transformers (eg. ContourGenerator). Does anyone know why this would be happening and how I can fix it? Thanks,
Hi, This scenario has come about quite a few times already, but I have not been able to figure it out. I have the following excel input data and want to produce the following output data. Please help me out using some Transformers. We are using FME Desktop 2013 SP2. Sample input data (Reader) First Name ¦ Surname ¦ Date ¦ Type John ¦ Smith ¦ 01/05/2000 ¦ A Joe ¦ Bloggs ¦ 01/01/2000 ¦ A Joe ¦ Bloggs ¦ 10/05/2010 ¦ B ¦ means a new field. Expected output data (Writer) First Name ¦ Surname ¦ Dates ¦ Types John ¦ Smith ¦ "01/05/2000" ¦ A Joe ¦ Bloggs ¦ "01/01/2000" , "10/05/2010" ¦ "A" , "B" Resulting Output. I basically want to group some attributes to make unique names and then concatenate the remaining none-grouped attributes in turn into new attributes. Also need to consider that in the real input data there could be more than 2 people with the same name. Thanks.
I need to find a way to group sets of polygons together geographicly where they overlay each other and then filter out all except the largest extent. I also want to retain the attributes for the largest extent as well. Below is a screenshot of the sample data I am using to develop the workspace. I have a total of around 27,000 features to run through this so it can't be done manually. This is a sample of the issue. I want the result to have the outer extent of the groups and, in this example, to have 2 features with the attibutes of the largest polygon in the group. Any ideas welcomed. It appears to be such a simple task but I can't seem to work it out.
Hello, My workspace importing into Smallwold was working, but now I am getting error message saying that the SW enumerator set doesn't have 'unset' as a value? Dose anyone know what this means and how to fix it?
Is there a way to read metadata in an Enterprise Geodatabase? I see that you can do it with geodatabases (http://docs.safe.com/fme/2013/html/FME_ReadersWriters/Default.htm#geodatabase/FEATURE_READ_MODE.htm) but I dont see that option in enterprise gdb. Thanks
Hi, I have SQL Server Non-Spatial writter with ~80 tables (features). How can I set to insert into identity column for all features and Key column, too? It is same column name for all features. Is there a way to do this, without setting to every feature separately? Thanks!
Hi, My workbench is published in FMEServer. At the end of workbench execution, i have to log the generated LOG file and FFS file complete path in database . I thought of doing it in shutdown script. But i do not know how to get their location. Any pointers will be highly helpful. Thanks. Subrat
Hi Folks, I'm having a bit of a moment. I know this is possible and have done it before, but can't remember how nor find out how from the docs. I have a text writer. I'd like to set its destination using an attribute. So: fme_writer_dest = "c\\:thisdir\\filename.txt" How do I do this? I don't want to use fanout due to its limitations for my scenario. Anyone know what the attribute name is? Thanks.
Hi, I have many attributes with len 13. Need to remove first 5 characters of each of them (these 5 can be different). E.g. att1=1001478577259 att2=1247833654578 and so on. need to get : att1=78577259 att2=33654578 How to do this without putting multiple SubstringExtractors?
I have created a string of feature types that I pass into the FeatureReader that looks like this: "'D:\\LiDAR and Such\\Las\\CoV_4900E_54590N_BE.las':'D:\\LiDAR and Such\\Las\\CoV_4900E_54580N_BE.las'" That is, each LAS file that I want the feature reader to read has the full path, enclosed in single quotes, and separated by a colon, as the documentation specifies. I have also tried it without the outer double quotes. In the Query Operation screen I select Query the feature types specified in the attribute below and select the correct attribute. However, nothing goes through the LAS or Other ports. I have tried putting in a relative path to the LAS files, but nothing works. What am I doing wrong? Thanks.
Hello, I am trying to disconnect users of SDE using python . When I use the below code arcpy.DisconnectUser(arcpy.env.workspace, "ALL") arcpy.env.workspace = r"C:\\Connections\\SDE.sde" I am getting an error Python Exception <TypeError>: Could not open SDE workspace. Has anybody encountered this error ? Any Ideas ?
Hello everyone, I have a set of polygons that I would like to chop into a grid, create points on each corner, and create an id for each point starting from the southwest corner of each 12x12 area. Each polygon gets divided into a 12 x 12 grid and the corner points of the grid would be something like PolygonA_0,0 at the southwest corner 0,2 0,2...0,12 all the way up to PolygonA_12,12 in the northeast corner. This would be the same for each larger polygon. It woul be just like a point grid created by the 2dGridCreator. So far I've use the Tiler to divide the polygons into the 12x12 grid and a TopologyBuilder to get the nodes, but I am a little stumped on how to get the IDs for the nodes. Does anyone have an idea on how to get these iIDs populated? Thank You Justin
Hi all, if i launch a workbench, it executes no problem but i see this error into log file when i checked "Log Debugging information" from Tools==> FME Options==> Runtime=>Log file Default". ERROR |BADNEWS: File C:\\Program Files\\FME\\metafile\\MULTI_WRITER.fmf could not be opened (tabrdr.cpp:997) ERROR |BADNEWS: File C:\\Program Files\\FME\\metafile\\PythonFactory.fmf could not be opened (tabrdr.cpp:997) ERROR |BADNEWS: File C:\\Program Files\\FME\\metafile\\QueryFactory.fmf could not be opened (tabrdr.cpp:997) What that means this error? Thanks an advance. FarFar
I have a problem where I am trying to load a specifically named .csv file into FME. Basic right!?!? The problem is that the dataset I am loading is broken up in subfolders. For example, I am opening “Folder A” with a hierarchy of “Subfolder A”, “Subfolder B”, “Subfolder C”, and so on. Within each subfolder is CSV file named “example.csv”. I need to batch grab “example.csv” out of each subfolder. I considered using “Merge Feature Type” option but I’m a little rusty on how to structure my *\\**.csv setup. I hope I’ve explained this well enough and would appreciate any direction on how to merge the CSV files (of a specific name) as a reader in the subfolders. *Note, in the meantime, I manually added the 100+ files as a stopgap but it’s not an elegant or sustainable solution. Thanks, Matt
Hi, When using 'Fanout by Attribute' on MS SQL Spatial Writer I can't seem to get it to write using the Database Username, it always writes out to dbo. Is there a tip or trick I may be missing? Thanks
What is the difference between static and dynamic schema when adding a writer to the workbench? Regards, Hani