Creating and organizing workspaces. How to use Workbench.
Recently active
We don't have FME Server but we need for to be able to call a workbench to run remotely from machines that may not have FME Desktop installed.I've been playing with WMI as below. It successfully calls notepad and arcgis pro however fme.exe will startup but disappear from the process list before the workbench executes. If i copy/paste my cmdline onto the servers command prompt the workbench executes fine.import wmiimport osSW_SHOWMINIMIZED = 1server = 'DC3FMEDESKTOP'username = r'TFS' + os.sep + 'richardw-admin'print usernamepassword = 'password'c = wmi.WMI(server,user=username,password=password)startup = c.Win32_ProcessStartup.new (ShowWindow=SW_SHOWMINIMIZED)cmdline = "fme.exe S:\GIS\ESRIData\Scripts\FME\Server\\testremote.fmw \ --SourceDataset_FILEGDB \"S:\GIS\ESRIData\Authoritative\Climate_and_Environment\Meteorology.gdb\""#cmdline = "fme.exe"#cmdline = "C:\Program Files\ArcGIS\Pro\\bin\ArcGISPro.exe"print cmdline# pid, result = c.Win32_Process.Create (# CommandLine="notepad.
Hello, I have a correct fmw (footprint-1xls.jpg) that read the 4 coordinates from a xls and generate a footprint with 4 vertex (reader, vertex creator.line builder, line closer and geometry coercer). My questions are:- I dont know why the writer can not be a kml, it should be a shape, but also is ok for me- I would like to make the process for many xls in the same folder, obtaining many shapes with 4 coordintes each one. I have test with workapace runner but it does not work correctly (workspRunner). Many thanks, I appreciate your support ;-)
I obtain features from an WFS using the WFS Reader within a FME 2015 Workspace on FME Server. From time to time the job hangs and blocks the Server Engine for hours, while usually the run is successfully done after 2 minutes or so. I suppose that the WFS connection gets lost or so.Is there a smart way to have FME Server cancel a job after a certain amount of time (timeout function) in order to prevent such jobs from blocking a whole engine? Either any parameter in the server / engine configuration or a smart kind of routine within the workspace (i tried a timestamp and compare bevor / after routine, this however does not prevent the workspace from hanging)?
Hi,I know that you can set new attribute names and new attribute values using a list attributes as such:attribute{0}.nameattribute{0}.fme_data_typeBut how do I set the value of this new attribute?Is it something like:attribute{0}.value?Thanks
Hi All,We are converting Oracle spatial(SDO Geometry) to ESRI SDE (ST Geometry) using FME. In my data, some feature classes having VARCHAR2(2000) attribute columns. Those feature classes I am not able to process. Once I change VARCHAR2(2000) to NCLOB it worked for me. But i need to completed process with VARCHAR2(2000) only. Could anyone can help on this?
I have a tester that lets a shape through when name equals London area, this is fine, but when I add in a user parameter nothing is going through the tester. The only thin I can see is that the user parameter is adding speech marks to the beginning and end of the text string, hence it is not being found. I have imported all of the options from the name field in the shape file.Any ideas how to solve this?
I'm posting this here rather than on the regular forums, since I'm not sure how Safe feels about publicly posting performance benchmarks.Having seen the recent webinar introducing FME 2018 and the sometimes amazing performance improvement over FME 2017, I thought I'd make a simple test case to see for myself.I wanted the test case to be as simple as possible but still reflect a pretty common use case that had several possible solutions, so I settled on checking if an attribute value is null, and if yes map it to some other (default) value.Possible ways to do this includeNullAttributeMapper, maybe the most obvious choiceTester + AttributeCreator, the "old-timer" wayAttributeCreator with conditional testing, somewhat more creativeHere are my findings, all timings are given as mean CPU time in seconds on my mid-range laptop using one million features.FME 2017FME 2018Percent changeNullAttributeMapper62s61s-1.6Tester + AttributeCreator73s49s-32.8AttributeCreator w/cond
The PythonCreator has been improved in FME 2017.1. The 'input' method has been added and the user can choose creating features before any reader via the 'input' method, creating features after any reader via the 'close' method.It's a good enhancement, but I noticed that the runtime order of the Creators on the 'close' method cannot be controlled. That is, PythonCreators don't appear in the Creators Run After Readers table in the Creator Runtime Order dialog.See also the attached demo: (FME 2017.1.2)import fmeobjectsclass FeatureCreator1(object): def __init__(self): pass def input(self,feature): newFeature = fmeobjects.FMEFeature() newFeature.setAttribute('_method', 'input') self.pyoutput(newFeature) def close(self): newFeature = fmeobjects.FMEFeature() newFeature.setAttribute('_method', 'close') self.pyoutput(newFeature)In addition, if the source dataset was empty (i.e. the reader feature type outputs no features), the order of
Hi, the problem is, that I can't manipulate the directory to output filename in FME Desktop for FME Server, like using ${FME-MF_DIR}. It's also not working if I use an own parameter.On FME Server there is always the file path of FME Desktop. It's only possible to manipulate the workspace file on FME Server by hand.Is this a bug in transformer HttpCaller or do you know another way to define an FME Server directory for output filename?I am using FME(R) 2017.1.2.0 (20171213 - Build 17722 - WIN64) and FME Server 2017.1.2 - Build 17722 - win64 Best regards,Matthias
I use PythonCaller to call ArcPy in my workspace, because the ArcPy can only be called by 32 bit FME, so I want to judge whether FME is 32 bit when workspace running.I am now using $(FME_HOME) according to the installation directory FME to judge it, I would like to ask whether there is a better way.
I am trying to write a KML with thumbnails of photos linked to specific point locations. I have managed to create the balloon containing the information I want, but I can't get the pin to appear. I've interrogated the resultant KML and have noticed that a point isn't being created as per the sample code from Google. If I add this information in with the correct coordinates, the pins show up as per the options I have set within the workbench.I have attached some screenshots of the parameters I'm using, any suggestions?Thanks
Hello,I am trying to connect a Oracle DB to FME but even if I did everything from this link it is not working.Does anybody have any idea what could be the problem?
Hi all,I would like to know the pro and cons of using a jobsubmitter instead of a httpcaller in terms of efficiency, parrallelism, ... and vice-versa.Thanks
Hi @mark_1spatialI'm using Template.DWG file to define the Linetype for the ROUTE feature, i will need to increase the width of the ROUTE based on the NO_OF_WAYS Attribute(Below is the table mapping). Please let me know how i could achieve this in FME Desktop 2016. In attached file i should have the ROUTE feature width to be increased to 0.8mm so that the 5 cables(4 Low Voltage Cables-Orange color, 1 High Voltage cable-Red color) should be shown as going inside the ROUTE. NO_OF_WAYS Width (meters on the ground) 1 0.3 2,3 0.55 4,5 0.8 6,7 1.05 8 1.3 Any help would be much appreciated. Regards, Anil Kumar K B
Hi FME’ers,Registration for FME World Tour 2018 is now open! With events happening in over 75 cities, join us on our biggest tour of FME events yet! Explore the data environments and learn how to navigate them with ease as we equip you with the latest innovations in FME 2018.Need some more reasons to attend? Meet other FME users and experts in your communityAsk your burning data questions in person Take home fun swag!This year, Safe-hosted events will be charging a small fee ($25). This will allow us to work with a more accurate attendance which will help decrease the number of no-shows and reduce our carbon footprint. To further support this initiative and minimize food and material waste at each event, 100% of the cost will be donated to a local food bank in that city.To register at an event near you, visit the FME World 2018 Schedule.We also know that FME users do amazing work, so why not show it off? Get recognized for your work by presenting at an FME World Tour event. Here are a
Voting is now open! This question is closed for submissions, but you can vote for your favourites! Voting is open until Monday Dec 18th at 12:00pm PST.What is the 12 Days of FME Hackathon?Recently at Safe we had an internal event where the FME Experts had the opportunity to spend a couple of days away from their normal jobs, and build whatever they like with FME. We named this event ‘Demo Daze’, and you can find out what we got up to in this blog post.So, inspired by Demo Daze, we decided to extend the opportunity to our FME community, for the chance to win a one-of-a-kind, holiday inspired, FME prize pack.There will also be reputation points and a Knowledge Center badge up for grabs - 100 points for the winner and 20 points for each contestant.We’re giving FME users 12 days to work on and submit a project and share it with the rest of the community. Perhaps you’ll build something holiday inspired, give the 2018 beta a whirl or put that home licence to good use!To enter the 12 Days of
I have a points with attribute name 'home_number'.1. 15a2. 15b3. 15c4. 7a5. 7bPoints 1-3 are in the first polygon, points 4-5 in the second polygon. I would like to get the common value of the attribute from the points, so that the first polygon is given the value 15 and the second polygon is given the value 7.It is possible? Please help me.
Hi All,I have added two list as input tables to InlineQuerier and have problem with where clause in it.In Outputs if I create a select query base on one table it works, but I want to use where clause in that query, and after adding any sort of where clause even easy one like (where field = "value"), it is not returning anything.I want to find records in one list which are not in the other list, with query like this:SELECT "name","type","fme_feature_content" from Table1Where "name" in (Select "name" From Table2)Appreciate for any help.
I'm trying to set up a parameter for the output file path for a geodatabase writer, but having problems with using the "Choice with Alias parameter" type. When I try to set up something like this: Value: \\\\server\\sharename\\examplefolder\\Output.gdb Display Name: Testing When it comes to runtime the path of the geodatabase is passed to the writer like this... <backslash><backslash>server<backslash>sharename<backslash>examplefolder<backslash>Output.gdb ...which causes the translation to fail. Using a 'Choice' parameter for the path works fine but using an alias would be helpful for this particular job. From this FME Evangellist article here it seems like this should work but perhaps I'm missing something. Using FME 2012 SP3 Thanks.
I have attempted to configure Job Routing in FME Server 2017 in the config file but it is not working?
Currently we have an FME Script for that refreshes 1 ESRI Geodatabase to another (i.e. a direct copy). The problem is when there's an error on just one feature class, the entire workspace fails. Is there a way to bypass any errors and continue with the translation. We want to use a simpler way i.e. not validate all of the fields whenever there's an error encountered (i.e. not use the Tester / AttributeValidator). Can anyone please suggest of the most efficient way to do this?
Hi all,I'm working on a project to automate transformation of more than 50 layers. Just wondering is there any way I can get the list of attributes and types from each layer and compare it with another list to make sure it has fields and fields have types I'm expecting?
I am having an issue with my 2017 FME Desktop performing very slowly. The issue is not with running a workspace or reading data but rather with editing the workspace itself. There is a significant delay when adding a reader and editing a transformer. The slowness of FME has almost made the software unusable.Things I have tried: Purge temporary files (Tools > Purge Temporary Files). Start a blank ws and copy ols ws content to it Delete all FME TEMP location filesAny suggestions on how to gain performance in FME?
Scrape a web page showing road closures from X street to y Street, a point of closure from start to end.