List of Contributions

Ben Crerar

Contact Details

My Content

1 to 20 of 36 total

RE: Scheduling Queries on Weekdays Only

Posted By Ben Crerar 08-01-2022 19:39
Found In Egroup: Automate \ view thread
Hi Benjamin,  I should have stated I want to be able to do this on the Server, not Local.  Thanks ------------------------------ Ben Woodside Energy Ltd ben.crerar@woodside.com.au ------------------------------

Scheduling Queries on Weekdays Only

Posted By Ben Crerar 07-31-2022 22:32
Found In Egroup: Automate \ view thread
Hi All,  I want to schedule three queries but only want them to run on weekdays only, is this is possible or do I have to schedule the same query for each workday I want it to run?  Thanks  Ben ------------------------------ Ben Woodside Energy Ltd ben.crerar@woodside.com.au ---------- ...

RE: Cross-link Scripts with Studio 20.1

Posted By Ben Crerar 02-18-2022 00:59
Found In Egroup: Automate \ view thread
Thanks Sigrid I have submitted a feature request #69719 It would be good to see this progressed ​as it seems a bit silly to restrict features based on the licencing. Thanks for your help. ------------------------------ Ben Woodside Energy Ltd ben.crerar@woodside.com.au ------------- ...

Cross-link Scripts with Studio 20.1

Posted By Ben Crerar 02-17-2022 01:51
Found In Egroup: Automate \ view thread
Hi Community,  I have a use case to cross link scripts to run a Transaction script first to upload data and then run a Query script to download the data.  According to this article here this is possible in Studio 20.1 which is the version we have; https://docs.winshuttle.com/studio-en-20-1-on ...

Deleting Scheduled Files

Posted By Ben Crerar 12-07-2021 01:44
Found In Egroup: Automate \ view thread
Hi Team,  How can I delete a file from an old scheduled run so I can use the same file name for a new schedule run?  Currently I get an error "File already exists on the server. Please change file name".  I can't find any option to delete the file in the Evolve environment. Thanks  Ben ...

RE: ME31K Service agreement

Posted By Ben Crerar 11-15-2021 19:47
Found In Egroup: Automate \ view thread
Hi Sami,  Sounds like you may have to look at a nested loop. The script will get pretty complex if you are going to create the OA header data and then start adding in lines with subgroups underneath it.  For our use case we might have 10 sub groups with thousands of service lines for each subgroup, ...

RE: ME31K Service agreement

Posted By Ben Crerar 11-15-2021 01:54
Found In Library: Automate

RE: ME31K Service agreement

Posted By Ben Crerar 11-15-2021 01:54
Found In Egroup: Automate \ view thread
Hi Sami,  Do you mean where you can have subgroups sitting below the main screen line items?   I have created the script attached for ME32K which will add Services to a OA Subgroup but you need to have the Outline Agreement header data, line item and Subgroups already created.  Thanks -- ...

RE: Sustainability of the Excel template opening in read only mode

Posted By Ben Crerar 11-15-2021 01:47
Found In Egroup: Automate \ view thread
Hi Sigrid,  I don't have a source, it's just the behavior I've noted when loading from an Excel that has a pivot table.    To fully explain what we are trying to achieve we use Power BI to refresh a data source and then use a function in Power BI called Analyze in Excel to organise the data into ...

Sustainability of the Excel template opening in read only mode

Posted By Ben Crerar 11-12-2021 00:43
Found In Egroup: Automate \ view thread
Hi All,  I am using a pivot table in Excel to organise my data into the format I need for a particular script . As pivot tables are classed as unsupported objects, how sustainable is this going to be over time?  I will be running this script everyday, will it be ok? Or is Winshuttle and the Excel ...

RE: Excel Add-In asking me to save the data file

Posted By Ben Crerar 11-12-2021 00:37
Found In Egroup: Automate \ view thread
Thanks Henri, this fix worked. ------------------------------ Ben Woodside Energy Ltd ben.crerar@woodside.com.au ------------------------------

Excel Add-In asking me to save the data file

Posted By Ben Crerar 10-26-2021 02:02
Found In Egroup: Automate \ view thread
Hi Team,  When trying to run a transaction script using the Excel Add-In I keep being asked to save the data file. If I save the data file I continue to get asked to save it again and again and can't run the script.  Is there a way around this? Thanks ------------------------------ Ben ...

Transaction Server Scheduling

Posted By Ben Crerar 10-20-2021 03:23
Found In Egroup: Automate \ view thread
Hi all,  I am looking to use the server scheduling functionality for a transaction. What's not clear to me is if I set up the schedule, does the server read from the same data template and data template file path on the scheduled intervals?  https://docs.winshuttle.com/studio-en-20-0-online- ...

AC02 Create Service Master Missing authorization error

Posted By Ben Crerar 06-30-2021 04:13
Found In Egroup: Automate \ view thread
Hi Community, When trying to create a script for AC02 to create service masters I keep getting an error; Missing authorization: Create Service Has this got something to do with my Winshuttle authorizations or something else? I can create Service Masters in the transaction normally. ...

Query to SharePoint List

Posted By Ben Crerar 05-13-2021 22:31
Found In Egroup: Automate \ view thread
Hi Team,  We are running Studio 20.1 and have read through the help article about how you can map your query to a SharePoint list however I don't seem to have that option.  Is there a preference that needs to be changed in Studio Manager so we can do this?  Thanks   ------------------------------ ...

RE: ME21N for Account Assigned Services

Posted By Ben Crerar 11-20-2020 02:13
Found In Egroup: Automate \ view thread
Hi Andrew, Are you able to share your script? ------------------------------ Ben Woodside Energy Ltd ben.crerar@woodside.com.au ------------------------------

RE: ME22N cursor field error

Posted By Ben Crerar 10-21-2020 02:37
Found In Egroup: Automate \ view thread
Hi Suthagar,  I've found for simple changes it easier to use the older transaction ME22 and not the Enjoy transaction ME22N. ------------------------------ Ben Woodside Energy Ltd ben.crerar@woodside.com.au ------------------------------

Header and Data lines when looping

Posted By Ben Crerar 10-04-2020 21:38
Found In Egroup: Automate \ view thread
Hi Team,  We use a ME21N and ME41 script, the first line of the script contains the header and the first line of data, the proceeding data lines only contain the data line information, the header cells are blank.  It's always been my understanding that when using loops the proceeding data lines can't ...

RE: Winshuttle Studio Connect logon macro

Posted By Ben Crerar 06-28-2020 21:04
Found In Egroup: Automate \ view thread
Hi Tom, Yeah forgot about the log on, not sure how you would get around that with a Macro. Would be keen to know if you do come up with a solution. Ben

RE: Winshuttle Studio Connect logon macro

Posted By Ben Crerar 06-26-2020 02:51
Found In Egroup: Automate \ view thread
Hi Tom, There is an add in for Excel so you can run the script directly from Excel without opening up Studio, you just need to ensure you have the same bit versions of Excel and Studio. I'm having great success with 64 bit at the moment. You could script the macro to run through the process ...