Creating and organizing workspaces. How to use Workbench.
Recently active
Dear FME community.I would like to load files from my GDrive with the transformer GoogleDriveConnector.I'm ok for load 1 folder by 1 folder, but it is possible to load many folders with 1 transformer ?This is my configuration :Thank you very much.
Dear FME community. I need to make a process in a workbench.In this process I've to write few data in Postgres table and I've to read this data for continu the process.For this I thought to use a FeatureWriter and a FeatureWriter with a connection, but the problem is the FeatureReader read x time all the data of the table than the number of insertion in the table from FeatureWriter.Do you know how can I do that ?Thanks.
Is it possible to read in a table like the one below, and use FME to publish the event to a calendar in Microsoft Outlook or Exchange Server? EventDateStart TimeEnd TimeA Cool Event12/05/201811:00 AM1:00 PM
I am trying to use the MSWordStyler with the Content Type of List Item and keep receiving the following error:Microsoft Word Writer: Rejecting Feature. The msword_type value 'msword_bullet' is invalid. Please use a MSWordStyler prior to this writer to set the msword_type attribute I can successfully use the MSWordStyler with other content types and write to a word document though. It appears to only happen when using an existing MS Word template. FME Desktop 2018.1.0.3 64bit
Hi!I want to feed a series of workspaces into WorkSpaceRunner to be run in consecutive order. Most important is that the first one runs successfully to completion before the next one starts. Else the process should stop.They are all part of a weekly update routine, but I want to keep each workspace separate, in order to be able to run them separately at other times.I am not able to figure out how to use WorkspaceRunner for this, despite careful perusal of this forum. The part I do not understand is how to hold workspace 2 until nr 1 gives a go signal.Thanks, Mats.E
Building an xml with XMLTemplater transformer, some attributes are lists where some element may not exist.For example, I have contact information for 3 organizations and some may not have an individual name:contact{0}.CI_ResponsibleParty.organisationName.CharacterString contact{0}.CI_ResponsibleParty.individualName.CharacterString contact{0}.CI_ResponsibleParty.contactInfo.CI_Contact.phone.CI_Telephone.voice.CharacterString contact{1}.CI_ResponsibleParty.organisationName.CharacterString contact{1}.CI_ResponsibleParty.contactInfo.CI_Contact.phone.CI_Telephone.voice.CharacterString contact{2}.CI_ResponsibleParty.organisationName.CharacterString contact{2}.CI_ResponsibleParty.individualName.CharacterString contact{2}.CI_ResponsibleParty.contactInfo.CI_Contact.phone.CI_Telephone.voice.CharacterString To populate the xml with a contact block for each organization I do this:{ let $individualName := fme:get-list-attribute("contact{}.CI_ResponsibleParty.individualName.CharacterString"
Hello I just started learning FME. What I need to do is to find any difference in attributes between two versions of the same feature class. In details, I have a copy of a FGDB feature from one vendor and another copy from another vendor. I want to create FME workspace to be able to find any difference between these two versions and write the difference to a csv file. Both versions have the same schema and I am only interested in the attribute difference at this point. The feature class has a GlobalID which is unique in both versions. The output csv should be able to give info like new records from version 1, new records from version 2, attribute difference for Field 1 for record {aud1123ksfs34400}, and so on. Currently I have a python script for this purpose, but my new manager wants to use a FME job to automate this. What type of reader, transformer and writer I should use to achieve this purpose? Please help!
What controls the order that attribute names are listed when using feature.getAllAttributeNames ?
Hi,I have two tables and I need to merge based on BldNameTable 1:BldNameConstruction StatusldABCCompDEFblOngoingBCdbldPlanned Table 2: BldNameTypeABCResidentialDEFCommercialBCdIndustrial Is there any solution to achieve this task. Thanks is advance
Hello There I have a text file where we have to replace word1 and word 2 with the one on excel by the one on this table, each time the 2 words are replaced we create a text file, after that, we move to next row replace the word and create a file Any idea word1word2bobinmaryinloulaoutwebout Thanks
Howdy!Over the past several weeks I've been working on a child workspace to run from WorkspaceRunner, testing it out in WorkspaceRunner as the child progressed. However yesterday (?) it WorkspaceRunner seems to have stopped working. Is there a known bug related to this? Can someone tell me if I'm crazy or not?By "not working" I mean to say that one or two features (or none) might be sent to the WorkspaceRunner but they are not passed on to the child workspace, there is no output and no additional features are recieved by the WorkspaceRunner. Initially I thought that it was an issue with my child workspace, however after a whole lot of hours troubleshooting I went back and downloaded the example found here:https://knowledge.safe.com/articles/1469/batch-processing-using-the-workspacerunner-1.html I was surprised to find that working with the downloaded example it did not work either (I upgraded the transformers and it made no difference). I copy & pasted the translation logs progress
Hi, hopefully this is a simple one but it has me stuck. I am using a dynamic feature reader and would like to expose Format Attributes - in this case, fme_colour and fme_basename. Can someone please tell me where to find this. In the normal readers this is just a select all option under the format attributes tab.Many ThanksOliver
I have been using the PNGRASTER writer to do dataset fanout. But now I need to change this to a FeatureWriter, and I cannot find where on the form does one set the famout check box. The file names are comming in via a $RasterFileName attribute I created format "\\z\\x\\y.png" and the top level folder which these files should go into is $outDir (the raster files were created by running the WebMapTiler, so I don't want to lose the _num_tiles parameter, which I need to send . ThanksI.e. I want to reproduce this sort of effect:
Hello everyone, hope all are doing well. I have following published workflow in FME Server in which we have some parameters. This datadownload service activates through an web application, by login users can download the data in different data format . All the download history now we want to store in a database table. I saw our required information is inside the specific logfile. Can we implement some automated process thus when a job has been finished the respective informations regarding the "email of user", "Datetime", "Datatitle" and "Download Format" will be store inside a table? And this runs automatically, we dont want to run any process. A detail information is needed. PLease help us in this purpose. With kind regardsMuqit
Hi there! I am trying to aggregate features here on picture. Aggregation is necessary because I have to translate. scale and rotate these objects together as one object so they can fit inside certain rectangular (defined by ID). Thing is, every circle has different set off attributes and when i Aggregate them and later Deaggregate them I lose unique attributes and get only one attribute set that was set by Aggregator for all circles.
Hi,I got a FME work space (version 2017) published into Server and scheduled to run every half an hour.I have got an oracle connection parameters published into FME serverWithin the work space i've got several transformer for example SQL Creator,SQL Executer,DBJoiner and DatabaseUpdater - all of them are using the same oracle DB connection.But some of them are Persistent connection and some are not ( Actually i thought it won't make any difference in the process)But i am seeing the below warning messages in my FME Job log*****************************************************************************************************************WARN |Existing connection changed to 'persistent' mode (is connection closed after all clients release it) setting. The following connection is being requested in an inconsistent manner (serverType='ORACLE8i', serverName='***', userName='***', password='***', dbname='')0.0|WARN |Existing connectio
I have a workbench that runs a lot of geometry intersection tasks with many source datasets and writes the results in a database. I grouped the different tasks into Custom Transformers, and most of the source datasets go into only one Custom Transformer and are not needed anywhere else. My problem is that as soon as a group based transformer (Feature Mergers and Aggregators mainly) is reached in one of the custom transformers, more source data is loaded and the Workbench runs out of memory once the intersection tasks start. Is it possible to configure FME Workbench in a way to read only the data relevant to one custom transformer and force it to finish before loading more source data for another custom transformer?
When I schedule a .bat file that runs my FME workspace through windows task scheduler it returns a 0x2 error but when I run the .bat file manually it works fine.
Is there a way to globally remove all extra vertices from workbench connections?
We have noticed that many users have been asking for improved system health monitoring and reporting for FME Server. Many of the requests are driven by the need to respond to events in a timely manner. These events can range from Job and Core / Engine Failure to Publishing a Workspace to Tracking Logins.What FME Server event notifications are you or your organization most interested in?We would love to hear feedback! Please add your comments and use-cases or scenarios below, and consider using the "upvote" system or sub-comments to show support for other posts that you might be interested in.To get your ideas flowing, here are some examples I have gathered from the Knowledge Center and through a few technical supports cases:Notifications when...- FME Server Starts - Job Starts - Job Exceeds Time Limit - FME Server Job Queue is Empty - Repository Changes (Publish, Update, Delete) - License Expiry
I have installed fme server on a virtual machine and tested some heavy fme workspces, it took long time untill finished. around 20 hours.Then I installed the same version of fmeserver on a physical machine(server). (both machines have same configurations ( same CPU cores, same RAM memories etc.).I tested the heavy workspace on physical machine and the performance was way better. the whole process took 4 hours.my question is: is the physical machine better than virtual machine and why? they are both identical as configurations. Regards,Saman
Hello, I'm not able to figure out how to run child jobs using FMEServerJobSubmitter based on a list. What I have done is a "master" fme workspace which spawn "jobs" passing parameters to instances of another workspace. It's done based on list so there is a list - and if there are 10 elements in the list 10 jobs will be submitted to the server. It means 2 available engines will run the jobs and the rest will be queued. It's undesired situation, since this will run on a 6 engine FME server and the current solution will use all of the available engines. It's undesired because estimation of this job running on 1 engine is 10 days (it's large raster). So it would block all other jobs for quite amount of time - on 6 engines obviously it would take less time like 1-2 days, however it's still not acceptable. So the question - is it possible to limit the FMEServerJobSubmitter to be running only in 2 instances at once, so looping the list - taking 2 (
When using FME Workbench 2017.1 for connecting to FME server 2017.1 (purpose of downloading published workspaces), using the saved WEB Connection entry (user credentials of a local FME server user) – sometimes – the FME server without notice resets the User created token.FME server has LDAP and local FME authorisation.Why is this happening?
Hey guys, I'm having problems with the Workspace runner transformer and I'm completely stuck. I have a very simple workspace that I want to run a large number of files through. It consists of no more than a reader(which is set to merge feature types), a transformer, and a writer (which is set to dynamic schema). I have two published parameters, Source file and Destination. The runner workspace is equally simple, I use a file and Directory and file pathnames reader to read some files. In the WorkspaceRunner parameters I use "path_windows" as source and the path of a folder for destination. When I run this with the "Wait for job to complete" option set to No, things will run seemingly without error, but there is no output. When I set the option to Yes, I get the error "Failed to run workspace xxxx.fmw -- Trace was:FME2015.0 .... A fatal error has occurred. Check the logfile above for details" with no further clues of what went wrong. I have googled
I am trying to resize several thousand images that are stored as sde attachments. I am wondering if it is possible to do this without writing the images to disk. I can extract the full sized images to files using the attributefilewriter. Once I have the images extracted it is straight forward to resize them using the rasterresampler. Since I have so many images I would like to avoid writing them to disk before resizing but the output port of the attributefilewriter does not contain raster data so when I conect it to resampler I get an error.