Creating and organizing workspaces. How to use Workbench.
Recently active
Hello,I've written a Python script that performs some data extraction and saves the results to a dictionary. I now need to expose these keys and values as attributes to FME.My Python code is simply as follows:feature = fmeobjects.FMEFeature()for keys, values in row.items(): feature.setAttribute(keys, values)self.pyoutput(feature)The only issue is that both the length of the dictionary and names of the key value pairs will be changing on a very regular basis. This essentially means that I do not have any fixed names that I can expose.If possible, I'm looking for a solution such as assigning the attributes to a parameter and then passing this parameter to the 'Attributes to Expose' box within the Python Caller.Is anything like this possible?Thanks,Jamie
Hi, we are having a problem in running a workspace in FME Server.We has FME Server 2016.1.2.1. using FME Desktop we created a simple workflow that connects to a Oracle Geodatabase, reads a Feature Class, creates a new field and fill this new field with a value. We would like to save the result of the workflow in another Feature Class that already exists in the geodatabase. When running the workspace in FME Desktop, everything Works good and the results are successfully but when we published this workflow to FME Server and runs the workspace, FME Server runs the workspace but shows a message saying that 0 feature was written to the destination Feature Class. in the logs i can find the following messages: Features not written - verify feature type fanout/dynamic settings(Check that fanout/dynamic feature type attribute exists and has a value) We are new using FME and can not find the reason of this behavior, we already search in the documentation but did not find any information that can
Hi FME Community,I am using FME Workbench 2019.1, after successfully running a translation, click on the inspector icon, the whole workbench will crash. Tried to uninstall, reinstall still have this issue.Any idea how to fix this?Thanks.
Hi all, I have two source of data, one is introducing an ID code, the second one is a point cloud. After some processing on the point cloud data, I want to use the ID code (coded as a number) as an attribute to offset the point cloud in z. (I actually want to offset z using both the ID code and the Min value of the point cloud). The 'Aggregator ' is messing the point cloud. I also tried featutre merger with zero success. Digging into this issue, i found myself unable to do any attribute I don't find the way to add, merge or replace attributes of the point cloud (or a TIN based on a point cloud) with attributes imported from another data source. Thank you for your help! Jorge
From a workspace I have created an app in FME server 2019.Two of those parameters I do not want the user to see (I uncheck the "Show in app"-boxes in the app-config page), but I want to populate the parameters from outside the app. Is that possible? How?Thanks /Nisse@frro
Hello,I have a workbench that updates metadata by reading a file geodatabase with multiple feature classes. The multiple feature classes will change every time, i.e. in effect I want to update metadata for all feature classes in a file geodatabase based on excel provided for every feature class.I am reading the file geodatabase with directory and file path reader and then using feature readers for file geodabase and raster dataset. They need to be split as raster dataset has a separate reader.Then I am updating the metadata for each feature class based on input excel, which works fine.However, I cannot write the metadata back to the original file geodatabase feature classes using either feature writer in a dynamic way, i.e. write to all feature classes in the file geodatabase or with a dynamic file geodatabase writer.I am getting errors and I run out of options on how to do it.This is how I am reading:And this is how I am trying to write the updated metadata back to file geodatabase on
Hello everyone, I need help. I got excel with data that looks like this picture. So, I have two blocks in excel name "CR" and "M". I need to compare attribute "Ownerstag" from block "M" to attribute "Location" from block "CR" and if they are the same then I need to write values from attribute M (column J) from block "M" in attribute "Location" from block "CR". Thanks in advance.
Hello everyone, I have build a FME workflow to "convert" an Oracle DB to a PostGis DB.I have made some test with a small sample of the Oracle DB, everything went well (processing time less than 1 hour).But, when I try to run the same workflow to the whole Oralce DB, which last more than 1 hour, it fails. It seems that my company network/firewall is closing the connection after 1 hour long.I have contacted a network administrator and it will too complex to change this setting of 1 hour.So, is there a tool/transformer/option in FME desktop to keep the connection alive more than 1 hour ?
Hello,Within the user parameter, with a type of Choice with alias (Multiple), is it possible to retrieve the display name AND the value into an attribute?
I am running an AnchoredSnapper transformer to snap lines to vertexes. after the operation is complete all the lines previous attributes are intact, however when exported to a shapefile the attribute names and values are truncated to one character. I've tried the default attribute definitions as well as played around with the string type and mapped each individual attribute with no luck.
Hi Guys,I'm looking for a possibility to set published parameters of a workspace by running another workspace. My scenario is as follows: I've a set of workspaces with a lot of published parameters in a repository folderfor some users, these workspaces are copied from my repositors to user-foldersinside these user-folders the published parameters must be set to different values workspace.Copying the workspaces to the user-folders is done by a workspace to avoid interactive work. But I can't figure out if the second part of my task (definition of the published parameters) can also be addressed to any FME functionality, or if I have to do this manually. To be 100% clear at this point, usage of a batch-command or a Workspace Runner to set published parameters at runtime is no option in my case! I must be able to run the user workspaces in FME Workbench without any tweaking of the published parameters, except input/output path.
Hello, I make a Workspace to import CAD Data in Oracle Spatial. In my CAD file, i have some layer with accented character like 3.1 MP - A désaffecter. When FME read Autocad Writer i have the error : "ACAD reader: The encoded string is not a valid fme-wwjd string: '3.1 MP - A d\\xC3\\xA9saffecter'" In other workspace, I met same problem with parameters which contains accented character or with excel files with accented character. Can you help me? With FME 2018, i hadn't this problem. Thanks Bernard Dinon
How to set the attribute name to published/private parameter value in FME 2019.1 ? Is it possible to do ?Original post here:https://knowledge.safe.com/questions/2329/renaming-an-attribute-name-to-a-parameter-value.html
Since the upgrade to FME 2019.0 we're unable to run any workbench. All our workbenches make use of connections saved in a public or private key store file. But FME can't seem to find these files anymore. I checked the location of the files and they are still present. Also the rights on these folders seem to be ok.
Hi All,I have a Feature Reader, using an excel file, it work perfect, but when i enable feature caching it fails on the feature readeri don't know if this is a bug?
Hi guys,I have created an FME workbench that runs an output. This I have then automated by adding it into a batch file and run via a scheduler. I have an issue where a certain attribute I have to manually change in the attribute manager due to its revision.I was thinking of using the counter and also read this article https://knowledge.safe.com/articles/33899/change-detection-2.html but not sure how exactly the workbench wil detect the change of the new revision. The other option maybe having a popup box similar to counter that suggests you need to add the revision but unsure if this can be picked up in the .bat or via another method.Example - Currently it is, for example, it is: DG01 and then next weeks run it will be DG02 but that will have to be manually changed.
I am wanting to publish around 60 workbenches to FME Server 2019 to run sequentially as a single scheduled task, however cannot find any configuration in the interface which would allow me to do this.Ideally, I would want to be able to select the repository I publish the workbenches to and configure to run on one of our two engines of FME Server. This would save a lot of configuration time instead of having to create a unique schedule for every workbench.Can anyone suggest a solution or advise if this is possible? (Maybe an idea for a future release of server?)Thanks
I have line like Road and points are like housesi have fields like side and ID_T in picture highlighted blue apts having same ID_T because hooking same named edgeside field , if it hook right get R or else get L In above wrong is only single edge that highlighted red circle aptsI need to select which apts are hooking only one side
Hi, FME noob here (worked with FME 10yrs ago). I've noted before that I've inherited the project that includes administration of aroun 30 FME workbenches, that are scheduled to run using the Jenkins tasking server. I understand the reasoning to create a workbench for each feature class (esri) to be synced to AGOL, but I'm thinking of combining into one or few workbenches. The issue is, once one transformer fails, the rest is not executed. So I'm thinking if there is any 'transformer', or perhaps a wrapper that would allow me to catch the errors but still continue the workbench execution? Thank you
Hi there.The Geometry Replacer transformer in this workspace have the correct attributes (end_GRID_ID and start_GRID_ID), but FME is not transferring these over to the writer! Any tips?
I'm building a workflow that has error handling system in it. The idea is to send a message to the client about some specific error. To do that I've created a Custom Transformer that sends message. It would be very handy to extract the Transformer Name and send it as a Error Code. In that way I can avoid typing an Error Code as a parameter value. On the attached image you can see an example where ER000n are instances of the same Custom Transformer. I wonder is it possible to extract whatever was used as a Name of the transformer (ERR0006, ERR0007, etc.) form inside transformer? Extracted name will be a part of the Error Message that I'm sending to user. Thanks
Hi, we are seeing some odd behaviour in our FME Server 2015.1 instanceWe are running a 'runner' workbench, that uses 3 chained fmeserverjobsubmitter transfomers to call 3 'workers' and all are configured in 'sync' mode (i.e. wait for the job to finish)Occasionally the first worker (which can take just over an hour to run) is submitted twice. The timing of the second submission appears to be random and between 10-50 minutes.the driver workbench log shows no record of triggering this second job and appears to fail with the error(ServerJobSubmissionFactory): A connection error occurred with server "http://fme-server.prod/fmeserver"both the workers appear to complete successfully sometime after the runner has failed.Does anyone know what conditions might be causing this automatic resubmission of a job and, ideally, how to prevent it?I suspect that some component of FME Server is losing connectivity with the initial job, assuming failure, trying again and losing connectivity with the second
I have several custom transformers which perform different QA checks. They are designed to read in any data set with any number of tables and columns per table and perform checks for each table. Within this custom transformer, I run the data through an AttributeExploder and have the following: attr_name | attr_value. I do a few tricks to attach fme format attributes to each value | name pair to get the following: DatasetName | DatasetType | TableName | RecordName | RecordValue Below is a screenshot of an example of some data for just two tables: So what I want to do is split out the data into their original tables, pivot, and perform analysis on each one - simply find any rows with repeating data - ALL WITHIN THE CURRENT CUSTOM TRANSFORMER - without having to write to file and read in again etc.. For Example: TableNameMATRIX_IDMATRIX_DESCRIPTIONdbo.MATRIX6SPMDdbo.MATRIX4UNKNOWNdbo.MATRIX3BIOLOGICALdbo.MATRIX2SEDIMENTdbo.MATRIX1WATER Using a couple of Aggregators, I was able to get
I have a chain of WorkspaceRunners that I need to bring to FMEServer, but it should still be possible to run them in Workbench as well. So, I created a TestFilter where '$FME_JOB_ID' NOT has a value. If it does not have a value, a WorkspaceRunner is triggered. It fails with the message:Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'An error occurred during the batch file execution, 1 translation failed. The following error message was raised: #2 : Undefined macro `FME_JOB_ID' dereferenced in file `ReferencedWorkspace.fmw'The parameterFetcher in the 'ReferencedWorkspace.fmw' causes this error. The Workaround I made was to put a value 'N/A' in the 'FME_JOB_ID' of the ReferencedWorkspace (which also contains a TestFilter but with '$FME_JOB_ID' NOT has a value or = 'N/A'). So two questions:why do I get the Error message in the first place? The Main procedure does not require the 'N/A' value for the FME_JOB_ID. It seems that the WorkspaceRunner does not resolve
I have a workspace that runs using FME Desktop and the windows task scheduler. I would like it to send out an email notification upon successful completion that includes a total record count, a list of ID of all the records, and a timestamp.In my specific instances, I'm using a FeatureWriter to write lines of text to a number of text files that are named using fanout and a unique ID field. What I've come up with works but it feels clumsy. The screenshot below leaves out the actual FMW processing and starts with the Writer (bottom left) and another branch feeding in records.Maybe you agree - there has got to be a better (more out of the box) way to do this, right? If so, I'm all ears.Footnote: Most of my stuff runs in FME Server which utilizes notifications there (although not with the above type of summary), so I have never had to dig into bolting on things after your writer finishes up,