How to change the file type
Navigate to the Extras folder in the Dimensions Program Folder. This is usually C:\Program Files (x86)\Access Applications\Dimensions\Accounts\XXXX\Extras. Replace XXXX with the version number of the Dimensions application being used.
Locate the file called BacsFormats.ini and make a backup copy of it.
Save the backup in a safe location such as the desktop.
To edit, double-click the file. The file will open in notepad and will come off in two different ways depending on the Dimensions version:
The first will have a short amount of text, around 16 lines (earlier than v2.51a).
The second will have a large amount of text, around 40+ lines. (V2.51a or later).
Earlier than v2.51a
If the BacsFormats.ini file looks like the earlier version then there is a little work to do prior to changing the file.
Firstly, identify the number of the Bacs Format that is being used. Note: Dimensions stores the number in the BacsFormats.XML file which is in the same folder.
Open up the BacsFormats.XML file by double-clicking on it.
Search for the format using Ctrl+F. For example, I am looking for ‘RBS Bankline v3’.
Find the entry in the XML file and to the left of the name is the number of the format, for Example ‘18’. With this information, create an entry in the BACSFormats.ini file.
The comments are not required unless used for clarity so the minimum information needed is to enter the below in bold amongst the other number entries:
[18]
ExportCSVasTXT=Y
Save the file.
V2.51a or later
If the BacsFormats.ini file is from a later version, it will simply be a case of locating the line that relates to the chosen format and change the N to Y.
For example, search for the RBS Bankline in the comments or using Ctrl+F.
Change the N to Y as the comments suggest and save the file down.
The next time the user logs into Dimensions and run the BACS Export, the file will be created with a .TXT extension.