Data from closed database mis system

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Horoldo - 26 Jul 2008 12:39 GMT

Does anyone know a way I can use a print driver to print from our MIS system
(EFI Printsmith) and populate sql tables? eg: print direct to a .txt or .xml
or using PrintForm .NET. The MIS has export features but only on a scheduled
basis. We want to send quotes, proofs and invoices as html via email but
there is no export feature when creating quotes or invoices. To send the
emails we are using iis on server 2003 and have written some .asp's to send
the emails based on the contact data from the quote in the MIS. We have only
installed sql express 2005, but will buy full sql if required.

Reply to this Message

TheSQLGuru - 26 Jul 2008 22:05 GMT

Several options quickly come to mind:

1) print to a flat file and write an application or import routine (bcp,
ssis, openquery, custom, etc) to access the file and insert data.

2) Write a program to receive the email and process it, extracting the data
from the html and again inserting to sql.

Signature

Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net

> Does anyone know a way I can use a print driver to print from our MIS
> system
[quoted text clipped - 9 lines]
> only
> installed sql express 2005, but will buy full sql if required.

Reply to this Message