The INI file

The ini file sets and reads data relevant to each workstation (seat)

In hub mode, this location is  read from the Hub Database

If you are not in hub mode and you specify an ini file in the parameter section of the windows shortcut, then the system will use that ini file (e.g. “DBW220. EXE s:\MyINI.INI”)

Otherwise, or if the ini file specified above does not exist, the system looks for DATABUILD.INI in the Databuild sub-folder in the local data folder (The exact location of this folder varies with the operating system (Vista, XP etc) and the current user.

If this file cannot be found, the system looks for the file DBW32ADO.INI in your windows folder  and if that exists, copies it as  DATABUILD.INI to the Databuild sub-folder in the local data folder. This is the location of the ini file in older systems.

If there is still no valid ini file, the system will create one in the Databuild sub-folder in the local data folder.

The current ini file is displayed in the About Databuild Screen

INI file contents

[Directories]

Last Access                Write Only: Date, time & User Name of last access

Common Database        Path & name of common database. Read only in hub mode

Windows Directory        Write Only: Location of Windows folder

Report Directory                Path to Crystal Report files

Data Directory                Default folder for data files

Document Directory        Default folder for documents

Program Directory         Write only. Used by install

System Files                Write only. Used by install

Version                        Write only. Current Version

Build                        Write only. Current Build

New Access Version        Access version of created databases (97/2000/2007)

Table Layout File                path of file that holds saved grid settings

Dialer Program                path of dialer program

Browser                        path of browser program

Processing Cursor                Indicates whether processing at client or server

Cheque Digits                Cheque numbers are padded with zeros up to this length

UDF Count                Number of User-definable fields (applies to all areas)

Bill Snapshot Directory        Folder where bill snapshots are saved

DBWFRONTEND Folder        path to DBWFrontEnd.exe if used

Help Directory                path to help folder

Translation File                path to translation file for non English systems

Logo File                        Default report Logos (if current company has no logo)

[SMS]

User Name

Password

Identifier

Originator

Server

[Last Access]

Current Job                Last Job used

Current Job (Accounts)        Last Job used in accounts modules       

Current Supplier                Last Supplier used       

Current CC                Last Cost Centre used

Default Price Level        Last Price Level used

Last User                        ID of Last User

Last Company                Number of last company accessed

Bank                        Number of last bank accessed

Quickstart CC                Last Cost Centre used in Quickstart module        

[Crystal]

Show Navigation        Show(1) or Hide(0) Navigation panel

Show Search                Show(1) or Hide(0) search panel

Hide Box                Show(0) or Hide(1) heading box

Printer Copies

Margin Left                in Twips

Margin Right                in Twips

Margin Top                in Twips

Margin Bottom                in Twips

Margin OverRide        0= retrieve margins from reports; 1= use above margins

[RTF]

Compression                Image compression %

Resolution                Image resolution compression

Table Grid Lines                Show (-1) or hide(0) grid lines

[Default]

Min Date                Minimum date system allows (default 1/01/1990)

GST Rate                Default rate for new companies

Bar Color                Sizing bar color (default dark blue)

Recipe Color                Fore Color of recipe items (default magenta)

Back Color                Background Color (default light grey)

GL Digits                General ledger account code digits after decimal point

Max Status Line                Max number of characters in upper status bar

Max File Size                Maximum length of text files used for error logs etc

RTF Save As                Default format for saving RTF documents

(1=txt 2=rtf 3=doc 4=pdf 5=htm)

Price Levels                Number of price levels allowed

Lock screen sizing        0= save screen and grid sizes on exit

Week Days Only        1= On due date calculations for payments, only allow week days

Check Duplicate Inv’s        Invoice checking: 0=no -1=yes

Reject 100% Complete        Invoice checking: 0=no -1=yes

Check Duplicate CC        Invoice checking: 0=no -1=yes

Check Duplicate Am’t        Invoice checking: 0=no -1=yes

Check Duplicate Ref’c        Invoice checking: 0=no -1=yes

Check Duplicate Job        Invoice checking: 0=no -1=yes

Check Duplicate Sup’r        Invoice checking: 0=no -1=yes

Language                

Country                        0=Australia, 1=NZ,2=UK

Build Translation File        0=no -1=yes. Builds a translation file as you move around system

                       You can then translate phrases into any language

Lock Transactions        0=no -1=yes. Only use if you are getting “unable to update errors”

Pay Deduction Chars        Default 50. Increase if you have incremented field length

Display From Tran’n        Determines initial transaction in Audit trail

Display Transaction Mode        1= show current month

                               2=show today’s

                               3= show from “Display from Transactio” number

Twin Supplier Ret’N        0=no -1=yes. Allows 2 retentions on each invoice/claim

Use Retention GL        0=no -1=yes. Posts retentions to different GL accounts

                       Rather than just debtors/creditors

[Quantities]

Option0 to Option31         0=sub group grid                  

1=view load                       

2=view lock                       

3=view price level                

4=autoreprice                     

5=autosave budgets                

6=line No                         

7=remove exploded recipes         

8=view suppliers                  

9= lock preferred supplier        

10 Zero prices to manual          

11=view budgets                   

12= block edit on logged orders   

13= show whole pf               

14=auto close                     

15=default qty                    

16=Insertion point (0,1,2)        

17=cc sort                        

18=default quantity                       

19=autohog                        

20= default PL for new items      

21=use area pricing               

22=explode zero qty recipes       

23=show subgroup                  

25=autosave mins                  

26=show live cc only              

27 prevent log on unlocked budgets

28= Line number increment         

29=view ordered column            

30=view overrun column            

31=view del ivery date column           

[Email]

Mode                        0=None, 1=MAPI,  2=SMTP, 3=Test

Timeout                in seconds

SMTP Server                SMTP only

SMTP Proxy                SMTP only

Return Email                Senders Email Address

SMTP Authorisation        SMTP only

User                        Name of sender

Password                SMTP only

Save to Job                -1= save emails in job document folders

CC Default                CC emails to this email address

Save Attachments        -1= save documents with emails rather than just document paths

[ODBC]

Allow ODBC                0= only allow MS Access databases. -1= allow SQL Server etc

Server Name                Name of SQL Server. Read only in hub mode

Provider                0=SQL Server, 1=MSDASQL, 2= MySQL. Read only in hub mode

Create Scripts                -1= Creates scripts to update/ create database

Suppress Testing        -1= turn off database testing on startup (speeds entry)

[Orders]

Default Price Level        Default Price Level in bills

Default Order Pr Level        Price level used if supplier has no price

Loads Per Order                Maximum load number in order

Loads in Budget                Items in loads greater than this do not affect budgets

Min Variation Load        These loads are reserved for variations

Max Variation Load        see above

Max Overrun Load        These loads are reserved for order overruns

PDF Delay                Delay (secs) to allow system to “catch up” when creating pdf orders

Normal Load Color        Color of normal bill items

Overrun Load Color        Color of overrun load items

Variation Load Color        Color of Variation load items

Over run cancel code        Cancelled orders are set to this overrun code

Over run ReOrder code        Reordered orders are credited to this overrun code

General Notes                Standard notes added to bottom of ALL orders

Reject Unauthorised        -1= Do not process unauthorised orders

Save Snapshot                -1= A snapshot of each order is saved

[Error Handling]

Suppressed                -1= Do not trap errors (system crashes on error)

Silent Running                Do not show errors to user

Write Log File                Write error information to a log file

Log File                        path of log file

[Settings]

{module Names)        Up to 40 numbers indicating sizing and selections

Different for each module

[Import/Export]

Various one off options cab be set to export to third party systems

[DXF]

Select Color                Color of selected lines

[Plan]

Plan Width                GTO: Default plan width (metres)

Plan Height                GTO: Default plan height (metres)

Default Plan                GTO: Picture to load onto jobs without plans

[Order Print]

Option0 to Option12        0= Log Orders

1= Use Supplier Defaults

2= Show Line Prices

3= Show Total Prices Only

4= Save Invoice Snapshots

5= Check Budgets

6= Print Supplier's reference

7= Print Our reference

8=not used

9= Use Manual Prices

10= Override Order Numbers

11= Include Pictures

12= Date = Today on log

[Front End]

Tender Preamble Nts        Standard note(s) used in Tender preamble        

Tender Follow Notes        Standard note(s) used in Tender follow on

Contract Preamble Nts        Standard note(s) used in Contract Preamble

Contract Follow Notes        Standard note(s) used in Contract follow on

Won Color                Color of Won Status Quotes

Lost Color                Color of Lost Status Quotes

Open Color                Color of Open Status Quotes

Alternative Color        Color of Alternative Status Quotes

Pending                Color of pending Actions

Completed                Color of Completed Actions

Not Applicable                Color of Not Applicable Actions

Current Quote                Last used quote code

Update Macro                Default macro in update module

UDF Supplier                Supplier when updating supplier UDFs