Creating and organizing workspaces. How to use Workbench.
Recently active
I am using two HTML Report Generator and then combining both with HTML Layouter, after the HTML Layouter using Logger, i am not able to see "fme_basename" value hence my writer is not able to use "fme_basename" value in Fanout Expression.Attaching screenshot for more clarity.
How and why are these created when they aren't visible? Like:Type Count fme_feature_type 0 fme_geometry 0 fme_type 0 QA_Camera pos. 0 QA_Clock position of obs. 0 QA_Comments 0 QA_CP value 0 QA_Date of Observation 100 QA_Depth extra points 0! Resend regardsandre
Hi Tia,I try to follow your post about "Sharing Published Parameters', then at step 3 Add the Writers, I cannot find where to "Set the CSV File Definition", did I missing something? Thank you and sorry to ask basic question.
Hello,The problem is, I have a shutdown python script but I need the value of an output parameter, there's any way to know the value of that parameter "Division" with python?
Hey guys,When I run a workspace with the question mark so I am prompted for published parameters I get my usual list, but I cant select a private parameter as an optionHowever if I edit the published parameter value, I can set it to a private parameter as default.Why cant I select this at runtime?Cheers,James
Hi, I am facing a problem with the FeatureWriter Transformer using ESRI Geodatabase ArcSDE GeoDB or File GeoDB. It seems unable to use dynamic schema definitions whenever I use the 'Use Existing' or 'Truncate Existing' modes for Table handling. With the following workbench, I have one fatal error like the following: "Geodatabase Writer: Feature Class or Table 'd_y_n' must exists when Table Handling is set to 'Use Existing'.". I am using FME 20180430 build 18305 under MS Windows 7 64 bits. Here is the workbench (features are read from a FeatureReader):Here is the featureWriter configuration: I really want to be sure that the table structure is left untouched by FME, that's why I am using 'Use Existing' or 'Truncate Existing' mode. If I use 'Create If Needed', it does work! If I use any other Writer than ESRI Geodatabase (like shape, GPKG, GeoJSON), there is no problem and data are correctly written with 'Use E
I'm new to fme can anyone explain how to perform batch translation in cmd,on the fly.
I have data in projection defined as 3 degree polynomial transformations to and from EPSG:2172.x' = e0 + y e4 + x e1 + yy e7 + yx e5 + xx e2 + yyy e9 + yyx e8 + yxx e6 + xxx e3y' = d0 + y d4 + x d1 + yy d7 + yx d5 + xx d2 + yyy d9 + yyx d8 + yxx d6 + xxx d3I know this ex and dx coefficients to and from EPSG:2172Is it possible to define such custom projection type in FME Desktop ?
I have .fme file it’s opening in FME Translator but when i am trying to open in FME workbench having problem I need to edit can any one help me how can I edited the same I have uploaded file please help me out
Hi,I have a table which is using numbered attributes such as the following (this is a fictitious simplified example): Id Description LanguageCode0 NotationAlphabet0 NameText0 LanguageCode1 NotationAlphabet1 NameText1 LanguageCode2 NotationAlphabet2 NameText2 1 Park1 FRE Latin Parc Vert DUT Latin Groenpark ENG Latin Green Park 2 Park2 FRE Latin Parc Rouge DUT Latin Roodpark ENG Latin Red ParkIn the above situation each park has 3 names, one for each language (FRE, DUT or ENG)And I need to re-organize it in such a way that it looks like the following: Id Description LanguageCode NotationAlphabet NameText 1 Park1 FRE Latin Parc Vert 1 Park1 DUT Latin Groenpark 1 Park1 ENG Latin Green Park 2 Park2 FRE Latin Parc Rouge 2 Park2 DUT Latin Roodpark 2 Park2 ENG Latin Red ParkI have tried to achieve
Contexte : appel d'un workbench par une commande batch.Question : est-il possible de passer en paramètre la projection souhaitée pour les fichiers de sortie ? Est-il possible d'utiliser un paramètre dans un workbench pour spécifier la projection de sortie ?
Hi, I'm running a modified version of Dmitri Bagh's LAS to DEM template (https://hub.safe.com/templates/las-to-dem), as I am generating hillsides (and other LAS based rasters) from approximately 2700 LAS files. While this works great when feeding one LAS file at a time in, when batching the process using the Batch Deploy wizard, it becomes very inefficient.The workspace by default will load all 2700 potential surrounding LAS files to the tile I'm working on, buffer, select only the data it needs, and then run. When batching it, it will load the 2700 LAS files to memory each iteration. This iterates 2700 times. Not the best method to do this.Is there any way to run this in such a fashion that it only loads the LAS dataset once, then loops through the dataset one LAS tile at a time, and processes that? I've tried modifying this to use the WorkspaceRunner (and take advantage of parallel processing), but everything I've tried runs into it reloading the whole dataset e
Hello. I created a user parameter to select the separator in the CSV reader. I linked the user parameter to the separator field in the CSV reader and it works. But I do not know how to write TAB as a separator into user parameter. I tried \\t, ^I, <control>, <u0009> and so on. Can someone tell me?
Hi,Background: I want to retrieve the File name of several files in a Folder. A have a Workspace that work, but it is way too slow. At the moment I´m using a FeatureReader to fetch a new "path_rootname" or "fme_basename". I´m sure there´s a couple of more clever ways to achieve this. Finding the Folder isn´t an issue, but I don´t know how to fetch the File names in any other way. A got a tip to try use "Published Parameters", without any luck. I have checked Guides from FME, but I can´t get my head around how to use "Published Parameters". Probably just need a gentle push in the right direction.Please see attached Files. How the workspace look today & what it produces:Regards,//Daniel
I have written a script that extracts information from a DB using python. I want this to be a published parameter list. For instance: FeatureType: Bus, Car And when run after 10 minutes it might be: FeatureType: Car, Train Depending on how this database looks like. Is it possible to use a scripted parameter for this. Or use a startup python script tp generate a published parameter? If I am correct the STartup pythonscript gets executed BEFORE the published parameters?
I have created a workbench that loops through an odata/json url using nextlink. I then placed a tester to stop running after the url returns no value. My problem is that this starts over after it runs the full data-set and repeats never stopping. A 700 feature table ran over the weekend had 70,000 and still counting.
I was wondering if it is possible to access the content of a workbenchs log file in a Shutdown Python script on FME Server and email the content.I have a central workbench calling several other workbenches to perform analysis. I want to parse the finished log-file to get warnings, errors and information about features identified and written. The final statement if the run was successful is unfortunately not enough. The parsed data should be send as text in an email.Until now I was testing locally with success, but the same workbench at a 2018 server fails with FME_END_PYTHON failure.import fme import smtplib from email.mime.text import MIMEText from email.mime.multipart import MIMEMultipart from email.utils import COMMASPACE, formatdate def send_email(send_from, send_to, subject, text, server='*****'): '''send email with analysis results''' assert isinstance(send_to, list) outer = MIMEMultipart() outer['From'] = send_from outer['To
I have another newbie question please.I am reading the input data (ID, NAME1, NAME2) in the example below and creating the new attributes FIRST and LAST.The value of the new "FIRST" attribute is set (to NAME1) when reading the first row for a particular ID. However, the new "LAST" attribute is set (to NAME2) when processing the row associated with the last entry of a particular ID.How do I backfill the value of the "LAST" attribute so that is available for the first row of an ID? (I need this in order to satisfy the required output format).I am aware of the look ahead (and behind) feature in AttributeManager/Creator. However the number of rows to look ahead is not known when reading the input data. In the example below it is 2 then 4 but it could be anything between 0 .. 100+.Example:IDNAME1NAME2FIRSTLAST1aAAAGEFAAA1aGEFCX2CX23yXCRBX4XCR3yBX4GXO3yGXOADL3yADLDARDAR
Hi all,I'm trying to troubleshoot a scheduling anomaly which resulted in jobs that were scheduled to run early this morning.What has happened is there are several jobs which have repeated on their own instead of just executing once at the scheduled time and stopping when complete. This resulted in one job notifying (Slack bot and email) that it wrote multiple times(3) to a postgres log table that it updated 1 record, but in fact the record is not duplicated in the table, so the result (the distinct count) ends up being correct after further inspection. However, the notifications that I have set up in the workspaces are not reflecting the output correctly.I suspect what might be happening is that the set(batch) of 23 tasks(workspaces), which perform the same process on 23 tables in a postGIS db are overrunning and interfering with each other. The tables all reside under one schema in the database, and each workspace will read in a master(staging) db and the current production db wit
I have a workspace with a workspace runner. For testing, I used the 'append to logfile' option, but turned it off again later. But in the "child workbench" all entries still get appended to the logfile, even though the 'append'-box in the workbench-options is not checked. How can I get FME to stop appending to the logfile?Thanks, Vera
Hallo! I want to set a global variable in an subtemplate which i can get from another subtemplate, is there any function possible ? Its like a gett- and sett-function.Thanks for answers.
I am using a featureReader and dynamically writing to a writer.The problem is "BuildingExtent" needs to be replaced to "BuildingFootPrint". This is because the featureclasses are differnt for only that featureclass.Any solution to replace them?
Hallo fme-community i hope you can help me again. I working for an template which should generate a OpenDRIVE structure. I take the data of streets from OSM and wanna try to fill some information into my structure. The workflow is like .I have just rly much questions because i have rly hard problems with fme to work as i want (first try with it). My template looks like And in this template i wanna try to change my subtemplate "GEOMETRY" to calculate the length and some other attributes from one note to the next one.The problem is i just give my template the lanes as you can see in the workflow that i give my subtemplate 3 lines. And if i run this i get this as result.My first question is now how can i split this 3 incoming lines up in 3 roads that i get the first 3 nodes in the first road (marked as 1) and the next 4 nodes into the next road (marked as 2) and so on. I tried it with an if sentence but it doesn't works so i deleted it. The split between the roads work but n
I am a beginner FME user having trouble with using a lookup table. I would appreciate your help.I will need to perform two lookups (there are plenty of examples here using a single lookup).The primary dataset has a structure like this:SEQID1ID21FTYCOM2PRDDCYThe lookup table provides a name for each ID:IDNAMECOMCommodoreDCYDiscoveryFTYFtypePRDPradoCORCorollaFALFalconI would like to perform the two lookups for each row of the primary dataset in order to achieve the result:SEQID1NAME1ID2NAME21FTYFtypeCOMCommodore2PRDPradoDCYDiscoveryThe above examples are simplified. Both the primary dataset and the lookup table contain thousands of rows.Any ideas please? [Did I mention I'm a beginner? :) ]
We are looking to review the possibility of using FME for a BIM to asset management to SCADA. Passing meter readings and outages to the model and any related work orders.Allowing to use FME as the front end, consolidating the data from th third party system.Instead of performing these tasks ourselves, we are looking to engage experts to perform this task. The work would expect to be handled remotely