ErosOlmi
09-10-2006, 17:06
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
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