Creating and organizing workspaces. How to use Workbench.
Recently active
I was recently was upgraded to Windows 10 on my 2 work machines. I previously ran FME build 18590 32 bit on my old WIndows 7 machines. When I got my new machines I exported my old Oracle database connection. I successfully imported it to one of my new machines, but the same connection gives me an error on the other machine. Any idea what could be wrong? A side note, when these machines were built by IT, they installed FME 2017, which I uninstalled and deleted all associated files on C drive before installing build 18590 32 bit. Obviously there is something preventing one of the new Windows 10 machines from connecting to Oracle. Below is a screenshot of the error message. Any idea what could be preventing this machine from connecting?Thanks,Dylan
A script created in FME 2015 is crashing in 2018 due to a Featurereader. I have tried to upgrade the transformer according to FME 2018 version. But the spatial filter options are different. There is no option called ENVELOPE INTERSECT. And I get the same rejection message, see text below. I have tried all possible spatial options but none corresponds to the envelope intersect. How do I handle this? <ows:ExceptionReport version="1.1.0=" language="en=" xmlns:ows="http://www.opengis.net/ows="><ows:Exception exceptionCode="NoApplicableCode="><ows:ExceptionText>The operation was attempted on an empty geometry.</ows:ExceptionText></ows:Exception></ows:ExceptionReport>Received error report: ExceptionReportThe XML Module halted on error, see the logfile for detailsA fatal error has occurred. Check the logfile above for details
Hi I have two workbenches that I want to run - the three output files from the first workbench are used in the second, albeit later on in the translation, so the first needs to complete before the second runs.I have created a new workbennch and added a workspace runner to run the first process and a second to run the second workbench (after first is successful). However, the first workspace runner needs an input and I have no idea what to use- all I want it to do is run the two existing workbenches one after the other. Can it not work like that? If not is there another way I can run the two, ensuring the first finishes before the second starts? Thanks
In Build 18590 32 bit I am getting the error retrieving connections message when attempting to establish web or database connections. I am on Windows 10 and this is a new install of FME but I had FME 2017 64 bit previously installed on this machine temporarily but never used it.
Hello!I have points and on each point is attached a list of value, separated with ";"point 1 : 1;4;5;6point 2 : 6;5;8;3;10;45...I would like to duplicate each point as many time as there are values and pick only one of the value.point 1 => 4 duplications = 4 pointsduplication 1 : value 1duplication 2 : value 4duplication 3 : value 5duplication 4 : value 6.point 2 => 6 duplications...I would like to do this because it doesn't exist the fonction "contains" on attributefilter so I need the exact value on the field to separate my data. Because otherwise I will have used Cloner and then tester, but there is no way to import a list on"right values" like on attributefilter and I have a lot of value to write.Sorry, maybe it's not very clear :) Thanks for your answer
The where clause woks perfectly in a sql Script but when I use it for a Reader if fails to filter the dataset.Am I missing some syntax?Has anyone got examples of where clause syntax for a Reader?
And i would like to know what version of oracle client should be installed for FME 2011 SP4( 20110829-Build 6538 -WIN 64)
I have two simple FME workbenches that I would like to combine into one/ or into a single process.The first workbench “PostProcessingPublishingFolderCreation.fmw” creates a new directory, sub directories and copies across two .pdf files contained in one of the sub directories. One of the sub directories is called “processed stereo imagery”.The second workbench “CopyJpegsAndDeleteUncompressed.fmw” copies some compressed tiffs to the newly created processed stereo imagery sub directory and deletes some uncompressed tiffs.I’ve investigated using a workspace runner, but ran in to trouble trying to provide one of the parameters/inputs for the second workbench as this had not yet been created, the new directory, and sub directories including “processed stereo imagery”.Essentially “PostProcessingPublishingFolderCreation.fmw” creates a new directory and sub directories, specifically a sub directly called “processed stereo imagery”. Then use the folder path for “processed stereo imagery” as an
Dear FME community.I try to aggregates lines to columns with same ID like that :In fact it's an intermediate result what I want, because in final result, I need to have this same aggregation with comparaison of different values (best value is A than B) :This is a link with a data test : Tank you for your help.
Hello!I recently upgraded to the new FME 2019.0 (yay!).This has had an interesting side-effect for running workspaces using the workspaceRunner for me. I have the following setup (I simplified the names for ease of explanation):Workspace 1 runs periodically and checks for changes in a datasetIt pushes the changes to workspace 2 using the workspaceRunnerWorkspace 2 receives a change, and it dynamically starts all workbenches within a folder (let's say 3 and 4)Workspace 2 starts workspace 3 and 4 using the SystemCaller, as it's near-impossible to use the workspaceRunner with a dynamic path AND parametersWorkspaces 3 and/or 4 start and do their workIn 2018.1 this worked fine, but since upgrading this setup has started spawning command line screens whenever a change occurs. This is royally annoying as it moves the focus from the screen I was working on, to these screens. They look like this:(These screens show the output for running FME from the command line).This only happens when
I am looking to see if there are ways to build your own custom translators in FME to convert precision agriculture machine data formats. For example, *.yld/*.fld files from Ag Leader, *.gsd/.gsy from John Deere to other outputs such as *.gdb, *.txt, etc.
hello,Currently i try to do a batch deploy an apply the same workbench on 89 file. When I use the "batch deploy", all the files are process but the files are saved under the same name which means that they are deleted as they go along, in the end I only have 1 file left instead of the 89 starting...The output file names are defined in relation to a number extracted from the input file name and stored in an attribute. I think that's where my concern comes from, but I don't know how to solve it.Example :Input files is name "trajectory0001.txt" and it have this constitution :In the FME I extract the filename and I keep the decimal part and I put it in new attribut (call "line").So I have these file in output.The output file is name 001.csv because I based the file name on the value of "line" attribut. My reader is may be wrongly defined so that it always takes the same file name but I'm not sure.I don't know how to solve my problem .
I am writing data to a JSON file to get it in proper JSON format for later use of a Web API using HTTPCaller.The "records" in the JSON file seems to be separated like this: "description" : "" } }, (is this CORRECT separation of JSON features?) { "json_featuretype" : "NewFeatureType", When reading the file later using FeatureReader, I get the expected number of "records". However, the resulting JSON textdata contains all the JSON data for all the records, every time a new record is read. This means, I get a lot of equal database records created in stead of individual records. Any ideas on how to get the right part of JSON data from each "reading"?
I am aware that 2018 FME added the ability to copy-paste between like transformers, however it does not appear that I am able to copy/paste between all like transformers. An example of where this functionality does npt exist is when trying to copy a row between an AttributeCreator and an Attribute Manager or AttributeRenamer and an Attribute Manager or vice-versa. Copying rows would be useful when cleaning up/simplifying my processes for efficiency gains.Digging into this a little bit, I found that when it comes to using conditional values for the new attributes I can for example copy the Conditional Values from the Attribute Creator... (See Edit note below)... While Conditional Values is positive functionality, in my opinion this is adding an unnecessary step, it should be simply.I have seen essentially this same Idea marked as Released so maybe I'm missing something? Is there another Idea floating around out there that did not get implemented yet?Examples of released Ideas includ
In FME2018 if a Workspace runner ran, then any inspectors would be shown in the Data Inspector. Here is an example of the FME2018 display where the Runner launches 3 target workspaces:The last tab presents the Workspace Runner's inspectors:In FME 2019, only the Workspace Runner inspectors generate a Data Inspector view:We use the Data Inspector views generated by target workspaces to spot check that objects at least lie within certain borders (e.g., county). I never realized the utility of this until it was gone.In the 2019 parcel runner. Below are more screen prints and log outputs.Cheers,PeteP.S. Dale saw this at the World Tour and told me to write it up...
I have a large polygon dataset on which I want to run an AreaOnAreaOverlayer. The transformer take a very long time to run because there are ~100,000 polygons and I don't have any way to group the polygons.It's occurred to me that I could enable parallel processing if I could group the polygons into subgroups that actually overlap each other. I can do this manually by lassoing the polygon groups by eye in ArcGIS and adding a unique value to a new field for each subgroup but I wondered if there was a clever way to automate this in FME?Below is the layer of polygons on which I want to run an AreaOnAreaOverlayer (I'm hoping to create a layer with no overlaps of all of the polygons intersected and attributed with a count of how many overlaps there are in each polygon)I imagine it will run faster if I can group them into layers that don't overlap at all, and then use that field in the "Group By" parameter. I'd be really grateful for any advice about any stage o
Hi, Having upgraded to FME Cloud 2019 I've noticed that when going to running a workbench, the auto-generated URL which used to be available in the advanced settings is no longer available. Has this moved elsewhere or has it been depreciated? Thanks
Hi all,My workspace is using the transformer FeatureWriter in SQL Server.I would like to recover the attribute Operador from my source data. The attribute Operador was simulated to be the transformer fme_basename.How can i extract it after the transformer?Attached my template file.ThanksDanilo de Lima
I'm running some jobs on the server than can take quite long. I use the REST api to get the status of the job, e.g. aborted, queued, in process, success... I also noticed a statusMessage field (e.g. "Translation was successful"). Can this be updated while running the script to provide more information for users?
I have lost the instructions for the FME Solar Powered plane. I was wondering if anyone had a copy of them as a pdf.
I have the following list as an example:Original list:mylist{0}.attr1 = a1mylist{0}.attr2 = a2mylist{0}.attr3 = a3mylist{1}.attr1 = b1mylist{1}.attr2 = b2mylist{1}.attr3 = b3mylist{2}.attr1 = c1mylist{2}.attr2 = c2mylist{2}.attr3 = c3mylist{3}.attr1 = d1mylist{3}.attr2 = d2mylist{3}.attr3 = d3mylist{4}.attr1 = e1mylist{4}.attr2 = e2mylist{4}.attr3 = e3 I want to regroup this list elements by recreating multiple lists by grouping the elements into 2 pairs while taking into account the previous element index as follows: New regrouping of elements:lstGroup1{0}.attr1 = a1lstGroup1{0}.attr2 = a2lstGroup1{0}.attr3 = a3lstGroup1{1}.attr1 = b1lstGroup1{1}.attr2 = b2lstGroup1{1}.attr3 = b3 lstGroup2{0}.attr1 = b1lstGroup2{0}.attr2 = b2lstGroup2{0}.attr3 = b3lstGroup2{1}.attr1 = c1lstGroup2{1}.attr2 = c2lstGroup2{1}.attr3 = c3 lstGroup3{0}.attr1 = c1lstGroup3{0}.attr2 = c2lstGroup3{0}.attr3 = c3lstGroup3{1}.attr1 = d1lstGroup3{1}.attr2 = d2lstGroup3{1}.attr3 = d3 lstGroup4{0}.attr1 = d1lstGroup4
Hello,I'm working on a project where we need to run a mean-shift algorithm on a very large raster dataset. We've been able to do it with the Orfeo Toolbox in QGIS, however we've had some pretty serious stability issues with QGIS itself, and therefore we would like to run the algorithm itself in FME Workbench instead. Does anyone know if it is possible to import the source code or a bat-file and run it as a transformer in FME? Or, does anyone know if there is a transformer that is capable of performing mean-shift algorithm on raster datasets?
I am looking for a way to close FME Workbench once a translation has completed. Is there an option somewhere for this, or possibly a shutdown script that could be used for this purpose?Ideally the solution would close only the current instance of FME Workbench, and leave other instances open.Thanks in advance
I need to change MicroStation Level names. I have tried using SchemeManager, AttributeManager and AttributeRenamer. All of which I can use a csv file to indicate which is the source and which is the destination level names. none of the transformers work. The output always writes the source level names not the destination level names.
I am stock…I am sure this is super simple but, I can seem to find an easy solution.I have two feature classes, one consist of 522 circles the other is a series of points (over 25000) of them. The points are in the circles and some of the circles overlap each other. Therefore, some points are in many circles…What I am trying to do here is to combine the attributes from the points to the attributes of the circles they intersect.The featureMerger does not work has the only relation between my two features are their location. I thought I solved it with PointOnArea but it only tell me how many point are in the circle…