Problem:
a company shipping department is requested to send delivery notes data to external transportation company every time a shipment is performed.
Solution:
thinBasic script can be used to:
- execute a on the fly connection to data warehouse DB
- extract relevant data by delivery or by customer or whatever
- create output file in different formats: xml, txt, xls, ...
- attach file to an email
- send email to transporter
