Creating and organizing workspaces. How to use Workbench.
Recently active
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
Hi ppl, In a workspace I have several published parameters all have the same type (choice), when prompting the translation, some of the parameters have a extra button to select attributes (which is not ncessary) and some do not. Anybody an idea on how to make the extra button go away? what is causing this difference? Cheers, Itay
Hi, i have one fme flowchart and, in that flux, i have a lot of repeated transformers . So, the problem is: is there a way of change the parameter of all transformer at the same time, or i have to change one by one? Thanks !
Hi, If I define a published parameter for a custom transformer, a menu button always appears in side of the parameter input box. I want to hide or disable the menu button; the interface like Copy Number Attribute of the Cloner is what I want. Is there a way? Thanks in advance. Takashi
I have an FME workspace I run monthly. It compares old data with current data. The old data is usually last month's data with the date stamp as part of the name. Because the feature type changes each time, I want to be prompted to select it. I can't simply use feature types to read because new feature types are being added to the file geodatabase each month (i.e. - it's not a static list). I need FME to read all the feature types in the file geodatabase at runtime and then prompt me to select one. Is there a way to do so? (Win7 64-bit, FME 2014, Build 14230, 32-bit). Thanks, Aaron Albuquerque, NM
I have installed FME Server 2014 and would like to set up the data distribution html / js / css files as in the demo at http://demos.fmeserver.com/datadistribution-googlemaps/index.html. However, I can't find the web root of the FME Server Web Application Server. Where is it, such that when I go to: http://myhost:8080/fmeserver/datadistribution.html ...I wil find that datadistribution.html page? Thanks
Hello all , I am trying to read all the file paths from a text file which is going to be the source file paths for the dynamic reader . I am using below private variable to generate the source reader's path # Get the file from a published parameter ListFile = (FME_MacroValues['Config_File']) f = open(ListFile,'r') featureTypes = '' # Read the file and add each line to the featureTypes Variable featureTypes = f.read() f.close() #Return this list to the parameter return featureTypes And I am publishing it to FME Server . When I run the job I am getting error saying it cannot read "C:\\temp1 C:\\temp2 C:\\temp3" . Any suggestions ???