+20I have these parameters for database Uploader transformer and I'd like to do the same thing on a python shutdown script so I don't need to have a parent and child workspace for capturing log information. Looking for some python samples to do this with SQL Server. Thanks.
Rather than using a shutdown script, why not replace the writers with FeatureWriters and connect the DatabaseUpdater to the Summary output port? You can use the DateTimeStamper and the DateTimeCalculator to calculate the duration.
+20Rather than using a shutdown script, why not replace the writers with FeatureWriters and connect the DatabaseUpdater to the Summary output port? You can use the DateTimeStamper and the DateTimeCalculator to calculate the duration.
I did not think hard enough. I have a Date time stamp as part of my shutdown script even if it's not necessary for what I wanted to do. Since I knew that the Session duration will only be logged upon completion of the workbench file, I insisted to get that the info come from the log file itself. Thanks, this comment answered a few other things that would complete my solution.
I did not think hard enough. I have a Date time stamp as part of my shutdown script even if it's not necessary for what I wanted to do. Since I knew that the Session duration will only be logged upon completion of the workbench file, I insisted to get that the info come from the log file itself. Thanks, this comment answered a few other things that would complete my solution.
Glad to hear and happy to be of help. The FeatureReader / FeatureWriter pair is exceptionally useful and allows you to easily implement a lot of common usage patterns within a single workspace, often with no coding (compared to using startup and shutdown scripts).
