Creating and organizing workspaces. How to use Workbench.
Recently active
I have a XML that i want to take out 2 values, name and title. i have done it here;Now I have these attributes but now i dont know how i do to match layer title and layer name. I would just want 2 attributes one for name and one for titleI have worked on this for a while and Icant get any closer to the result i want.Attach the workspace.
A few days ago we cleaned our FME_TEMP env variable directory as we had ~80GB files sitting there. I am now unable to use the Batch Deploy option and get the following in the log;Starting translation...couldn't open "{E:/Local Processing/FME_Temp/FME_1480515564385_17256}": no such file or directory while executingopen $superBatchFileName "w" invoked from withinset superBatchFile [open $superBatchFileName "w"] (file "C:/Users/william.allen/AppData/Local/Temp/5/fme-batch-deploy-f14892.tcl" line 14)Purging temporary files does not make a difference - nor does creating a blank file/folder.Do I have to change the Temp directory? Any idea how to avoid this - and keep the Temp folder size down?
I have a lake dataset which I have aggregated and dissolved which has almost given me the right results. However as you will see from the results I have Lake Okataina and Lake Okataina/Te Moana i kataina a Te Rangitakaroro. Lake Okataina is larger than Lake Okataina/Te Moana ... however once I aggregated and dissolved I get Lake Okataina. How do I merge the LakeName so that I keep the whole name and not just Lake Okataina. I've tried tweaking a few of the dissolver parameters but this doesn't seem to have given me the result I want.Cheers,Sarah
Hi there,I'm using FME Desktop & Server 2016.1 with Esri ArcDesktop 10.3.1. The workbench is reading oracle spatial data and writing it into Esri File geodatabases.In the Shutdown Python Script, I would like to find all the objects in the workbench to determine which are Feature Types, get there Feature Class/Table name and associated writer's destination path & file name.Once I have this information, I can use Esri's arcpy module (I have already worked out how to import this) to create indexes, etc. on the feature classes.Thanks
Hello,I have hundreds of excel books to read one sheet of (they each have only one sheet) then write the data to a database table. I thought this would be simple using batch deploy, I then realized the excel sheet names are different and in the basic way I set up my batch deploy it expects a specific excel sheet name. Is there any way for FME to simply read any excel sheet in an excel book at run time? All the excel sheets have the same column structure.To be clear:Excel book= A xlsx fileExcel Sheet= A tab of a excel file Thanks
I am trying to see where there might be a log of what occurred in a sub workspace called by workspaceRunner.I have FME server running workspace (A) and as part of that process workspace (B) is called.The only detail I can see is that workspace (B) was called successfully, however I would like to see the type of detail showing in the job log for workspace (A)The Log simply says90 INFORM 0.0 0.4 Today at 12:27:00 WorkspaceRunner_2: {C:/Program Files/FMEServer/Server/fme/fme} {//Workspace/datagovau - AFS_LIC_.fmw} 2>@1 91 INFORM 0.0 0.4 Today at 13:24:46 WorkspaceRunner_2: Successfully ran workspace \\\\Workspace\\datagovau - AFS_LIC_.fmw
I've got a shape file and a GDB feature class derived from that. 2 featureReaders with the same settings pointing at the 2 datasets, the shape file reader outputs a schema feature the GDB reader does not.Anyone know what's going on here? FME Desktop 2016.0
I have run the below query successfully on a spatial database in a standalone workspace:st_intersects(st_setsrid(st_geomfromtext('$(poly)'), 27700), geom)The poly parameter brings in the relevant wkt.When I run this query with the paramater passed through a master workspace it treats '$poly' as a string rather than a parameter. If i remove the single quotes the wkt comes through as expected, however the single quotes are part of the spatial query so the sql fails.Has anyone got any advice on how to get around this problem?Many Thanks,
Hi,I've always been struggling to wrap my head around how embedded custom transformers actually stitch into the general workflow. So this might very well be a no-brainer.If I want a transformer to have two dataflow (two input clauses), one with points/node and another with lines, and want the custom transformer to take certain point/node "names" to transfer to the line features into pre-existing attributes on it, how is this achieved ?I have "exposed" the three attributes (with seems common across all inputs !?), but I'm unsure whether the assigned values within the custom transformer ever make it out of it.Please enlighten me of the proper how-to :-)CheersLars I.
Had a hard time trying to let FME run out of memory, so I thought it would be faster to just ask around. My guess is no, right? Since it usually says "Warning: not all FMESessions that were created were destroyed before shutdown. This may cause instability" in the log...
Does FME Server use any of VB6/ASP/Web-plugins?
Hi,I am transforming a AutoCAD .DWG file containing lines, polygons, points and texts to a spatialite database. The translation is relatively easy, but i would like to output some internal fme attributes on top of the autocad attributes. With internal attributes, i mean the typical 'fme_color', 'fme_basename' or 'fme_feature_type' attributes that are visible inside FME Workbench and Inspector, but disappear when writing to a spatialite sl3 file. I also tried using an attribute exposer and creating new attributes that get the value of each internal attribute. None of these worked out. Does anyone have a suggestion how I can still use these internal attributes?
Hi all,I have a dgn file (let's say old_dgn) which is linked to an oracle database (let's say table_dgn).Because some centroids are missing, I created a new dgn file (let's say new_dgn) that contains all the existing features of the old file and also the new centroides.Now I would like to write a workspace that will:(1) detect the centroids without linkage with the oracle table table_dgn(2) create the linkage in case some centroids were found in step (1). This means update also the oracle table table_dgn.The oracle table table_dgn has a column mslink which corresponds to mslink1 of the file new_dgn.Any suggestions?
How do I specify a specific installation or version of FME to use in my batch file? This Knowledge Center article explains the syntax and use-cases, but 'fme' always gives me a version of FME I don't want! https://knowledge.safe.com/articles/1384/fme-batch-processing-methods-1.html
I have an address point with street name and street type fields likeName TypeMain streetPlesantavenueand so on. Also i have table with street coded values likeCodeNameType2345Main street4588PlesantavenueWhat i need to do is for each addreess point find name and type from second table and paste code value to the point attribute. What is the best way for this?
Is there a way to control the processing order so that the first part of processing, which creates a backup file, completes before the second part of processing starts. I don't want the second part to start processing on the file before the backup of that file can be created.
Hi,I am trying to re-use a python script (saved as .py file), so that i do not have to edit all my workspaces that contain this script in a private parameter.I tried to follow the steps in https://knowledge.safe.com/articles/976/how-can-i-modularize-my-python-code.htmlwhereby I included a couple of codes within the python startup script something like below:when I try referring the SetReader module in a private parameter, I get an error that says 'ImportError: No module named SetReader'Can I please get some help regarding re-using python scripts ?Thanks very muchimport sys sys.path.append(r'\\fmeserver\Functions') import SetReader
Hi,Im doing some test with elasticsearch and FME writer. I have a very simple workbench that reads (with directory reader) a folder with geojson files, read them with feature reader and dinamically writes to elasticsearch using the elasticsearch writer. The wb works pretty much ok on looping and sending all the jsons to elastic (on different types inside the same index), however it seems that the geometry field is lost when I write it to ES (although present in the geojson"features" : [ { "type" : "Feature", "geometry" : { "type" : "Point", "coordinates" : [ -0.8275947, 38.05902 ] }, "properties" : { "uwwCode" : "ES10030240001000E", "uwwName" : "BENEJUZAR", "uwwNUTS" : "ES521", "fme_basename" : "EDAR_Q2011", "SHAPE_GEOMETRY"
Basically, I am adding a 50m buffer to a facility point (first reader) then using a spatial filter to see where population points (second reader) fall within that buffer With those population points I caluclate the sum for overall population in the buffer and then run through a tester to see if it is greater than a value. If it fails it loops back to Expression Evaluator and adds 50m to the buffer. However it is looping the future population points originally selected within the buffer and creating new buffers for ALL OF THEM. NOT what I want.I created a Custom Transformer from Expression Evaluator through to Tester, then added a LOOP from the tester fail back to Expression Evaluator. The is the ONLY point I want to build a buffer around. It does not pass through after the first LOOP. What I would like to do is when the test fails, add another 50m to the buffer each time to that facility until the test passes. This is difficult when it only goes through the analysis once.Curren
I have to add unique attributes for fields like Tender Number, Project Number etc to all the feature in the database. The whole database having more than 100 features. Which transformer can help me the best. Now I am using AttributeManager, which for different sessions and different Tender set database i have to change the entire attributes in the AttributeManager.
Hi,I am trying add attribute value as prefix to joined attributes, but I have not succeeded. @bo had quite similar problem Add parameter as prefix... I have created attributes at main.Then I expose those attributes at custom transformerBut I cant get prefix when I add JoinerGoal is to have 1_REGISTRATIONDATE, 1_FORMERPARCELLOCUNITID and 2_REGISTRATIONDATE, 2_FORMERPARCELLOCUNITID on the second round and so on.
Currently I have:A polygon layer with a population attributeA point file containing facility locations. Facility A has a catchment area of x amount of people. What tools can I utilize that will allow me to create a catchment of those polygons that bring a sum of x? Which tool will work best for this scenario?Thanks very much,Justin
Hi,Simple question, there is Line feature that are multiple segments with direction (Blue and orange lines), each having individual Id. I would like to count the no. of black line touching per segment.Let me know if any further info is needed.Must be simple but, I'm stuck.Thanks in Advance,Sani.
I have existing FME scripts that run fine. I edit one, could be just a transformer or anything, and some, not all, of the sources and destinations sometimes change into published parameters. When I then have these scripts run, manually or through a scheduled task dos batch file, it won't run without the inputs. I don't want these to be published parameters, but they revert to them sometimes.