03333 445950
 |
 |
 |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Choosing the right tools for the job
There are a several options for importing and exporting Data to and from Sage 50, each has its strengths and weaknesses.
Choosing the right tool for the job in the first place can save a lot of time and energy down the road.
Here are some tables to help you establish which product suits your requirement best or you can use our wizard
| Sage V16 - | Sage V17 + | Custom Import Solution | |
| Import Sources | |||
| csv | Yes | Yes | Yes |
| xls | No | Yes | Yes |
| headed csv | No | No | Yes |
| xml | No | No | Yes |
| psv | No | No | Yes |
| any ODBC data source | No | No | Yes |
| Import Locations | |||
| Mapped Drive or UNC Path | Yes | Yes | Yes |
| FTP Server | No | No | Yes |
| WWW Server | No | No | Yes |
| POP3 Mail | No | No | Yes |
| Run Method | |||
| User Interactive GUI | Yes | Yes | Yes |
| Command Line | No | No | Yes |
| Scheduled Task | No | No | Yes |
| Run from external application | No | No | Yes |
| Run Requirements | |||
| Other users can access during import | No | No | Yes |
| Run options | |||
| Archiving of imports | No | No | Yes |
| Results | |||
| Notification of results via email | No | No | Yes |
| Results file in html | No | No | Yes |
| User definable results file | No | No | Yes |
| Export | |||
| csv | Yes* | Yes* | Yes |
| xml | No | No | Yes |
| xls | Yes* | Yes* | Yes |
| No | No | Yes | |
| user defined | No | No | Yes |
| Transform | |||
| Alter data during import | No | No | Yes |
| Capitalisation | No | No | Yes |
| Lookup Values from other sources | No | No | Yes |
| Manipulation with Regular Expressions | No | No | Yes |
| Substitute values | No | No | Yes |
| Costs | |||
| Additional Licence Costs | £0 | £0 | £255 |
| Additional customising | |||
| Headed csv import | 0 | ||
| Standard imports (as per old Sage defaults) | foc | ||
| Custom work to meet customer requirement | £30-£300-£1000** |
*To do this the user would need to manually send data to excel or run a report to file
** Our import solution is very customisable, most people use our customising service, you give us a brief and we write the customisation for you. Even the most complex customisations cost less than £1000, most of our work is under £300 and very simple customisations can start from £30. This is is an approved Sage third party developed product that supports Sage V7 to V17, upgrade eligibility is £80 per year and is included for the first year, thereafter it is optional.
