Article Details
Id:14211
Product:finPOWER Connect
Type:NEW
Version:3.00.03
Opened:08/11/2016
Closed:08/11/2016
Released:01/12/2016
Job: J018273

File and Folder handling; improved smart tag substitutions and UAC help

When defining a default File Name you may now use the following Smart Tags:

  • [AppFolder] - This will be replaced by the Application Folder.
  • [DbFolder] - This will be replaced by the Database Folder - for MS Access databases, or AppFolder otherwise.
  • [DocumentFolder] - This will be replaced by the User's Document Folder.
  • [ExportFolder] - This will be replaced by the User's Export Data Folder.
  • [TemplateFolder] - This will be replaced by the User's Template Folder.
  • [YMD] - This will be replaced by the current date, e.g. 20160630.
  • [YMDHM] - This will be replaced by the current date and time, e.g. 201606301520.
  • [YMDHMS] - This will be replaced by the current date and time, e.g. 20160630152010.
  • [HM] - This will be replaced by the current time, e.g. 1520.
  • [HMS] - This will be replaced by the current time including seconds, e.g. 152010.
  • [SEQ] - This will be replaced by a sequence number. This will start at 1 and be incremented until a unique file name is found.

This applies to most places a default File Name can be entered, including:

  • Bank Account Export Service
  • Global Settings, GL Export page
  • Process, Export General Ledger
  • Report, Data Export File Name
  • Comprehensive Credit Report Export,
  • Tax Certificate Export
  • Annual Investment Income Report (Australia) and Quarterly TFN/ABN Report (Australia).

Also enhanced is the message given when the file is located in the protected "Program Files" folder - this now includes a help button which takes the user to TSB1027.

Note, this functionality is wrapped in a new function found at finBL.GetFileNameResolved(fileName As String, Optional baseFolder As String = "", Optional [date] As Date = Nothing). This function returns a String value with the fully qualified and resolved File Name including Folder.