Data Management
Logical Office is a relational database which comes “out of the box” with a business model suitable for any small business and fully integrating to Ms-Office. The supported database is SQL which is an industry standard, avoiding any worrying “lock-in” of data or the problems of proprietary systems. External SQL databases can be linked to provide on-demand or scheduled updates avoiding the tiresome and error-prone work maintaining two databases. Relationships are built-in so that you see all relationships e.g. all employees for an organisation, or all companies for which an individual is a director, or all companies supported by an IT technician – or any other relationships you require. Clicking on a relationship will take you straight to the related account. This easy navigation save time searching. You can define your own relationships. File maintenance is available for the standard system e.g.
- Users
- Document templates
- User actions
- Relationship types
- Currencies
- Relationship types
- Mailing categories and groups
- Promotions
- Products
- Diary resources and types
- Events
The standard system can be further customised by adding:
- Data screens, each containing up to 32 fields
- Data fields of any type – dates, numbers, amounts, text, drop-down selections etc
- Workflows
Custom screens and fields can be created in seconds. New fields are immediately available on all screens, are included in searches, and come with automatically generated merge codes. Account data includes links to external databases, portal references, and marketing profiles. Data can be imported by using:
- The standard import for organisations and individuals
- The eCommand processor – an advanced data mapping program allowing import of any data.
Financial transaction data can be exported direct to Excel for importing into other accounting software, or analysing in Excel. Events can be exported direct to Excel for further manipulation or analysis, or just to get a copy.