60
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 221
Updating a Database via a Simple Web Form:
o
A manager, employee, customer, or supplier can provide information (for
example, complete a registration for an event or provide order status information)
using a simple web form (no web application required).
o
A Submit button triggers an email with the form information to your email server.
o
Visual CUT captures the email into the EMAIL_CAPTURE table
o
A Crystal report using that table inside Visual CUT uses After_Burst_SQL to
update another database table (for example, inserting the information into a
REGISTRATION table.
Collecting Customer Feedback & Updating a Database via Email Links:
o
You can use Visual CUT to burst Customer Satisfaction survey emails when a
purchase, course, visit, RFQ, event, or tech support case is closed.
o
Inside the HTML email message you embed 5 mailto hyperlinks corresponding to
ratings of: Poor, Fair, Good, Very Good, and Excellent.
o
This allows the customer to simply click on one of these links to trigger an email
back to you with the appropriate ratings.
o
Visual CUT captures the email into the EMAIL_CAPTURE table.
o
A Crystal report using that table inside Visual CUT uses After_Burst_SQL to
insert feedback records into a CUSTOMER_FEEDBACK table.
Importing Data from Email Attachment into a Database Table:
o
Email with excel file attachment is captured and Visual CUT extracts the
attachment to a specified folder.
o
1st Crystal report reads records from the Email_Capture table and bursts to a
dummy VC_Skip_Export.
o
After_Burst_Batch triggers a 2
nd
report that uses Excel as data source, but
redirects it (using Database_Path command line argument) to retrieve data from
the email attachment file.
o
Visual CUT exports the data from the Excel file via ODBC and appends it to a
specified table.
Requesting & Capturing Management Decisions Via Email:
o
Imagine you have a PO table with Purchase Order records that are first inserted
with a status of ‘Requested’.
o
You can use Visual CUT to burst and email to the manager in charge of each
department Approval Requests for these POs.
o
Attached to each emails you would provide a PDF file with detailed information
about the requested Purchase Orders.
