Category Archives: User Group Recap

User Group Presentation

Thanks for everyone who came to the User Group meeting yesterday! We had a great turnout and it appeared everyone had fun!

Jan briefly mentioned that the next meeting has been rescheduled to June 18th. There will be an invitation sent out around that time as well.

As promised, here is Kim’s presentation about ACL v10 changes as well as the Excel export script she was demonstrating. This can be used with the ACL sample files that come with ACL. The project is “ACL Demo”.

ACL v10 Changes

Writing to multiple tabs script:

SET SAFETY OFF

DELETE Workbook_Example2.xlsx OK
OPEN Metaphor_Trans_All
 EXPORT FIELDS CARDNUM  CREDLIM  CUSTNO  EXPDT  c_cMonth  c_cCMOY  FINCHG  MINPYMTDUE  NEWBAL  PASTDUEAMT  PMTDUEDT  PREVBAL  RATE  STMTDT  XLSX TO "Workbook_Example2" WORKSHEET Metaphor_Trans_All

OPEN Metaphor_Dept
 EXPORT FIELDS Dept  DeptDesc  XLSX TO "Workbook_Example2.xlsx" WORKSHEET Metaphor_Dept

SET SAFETY ON

July 2013 Meeting Resources

Hopefully everyone is taking advantage of this unseasonably cool St. Louis summer! A special thank you to Matt Adams of the Cardinals for the extra innings game winner last night. This morning’s coffee tastes a little better because of it.

As promised, here are the links to the ACL Connections 2013 presentations Jan briefly discussed at the beginning of our meeting:

ACL Connections Recap

ACL Connections 2013 – Resources

Joe has also been kind enough to provide her presentation on scripting data integrity verification:

Scripting Data Integrity Verification

Thanks again and we’ll see you at the next meeting!