Re: [mv] Exporting Orders into a Company form/database

[Ed LaFrance <edlafrance@printexusa.com>]

******    message to minivend-users from Ed LaFrance <edlafrance@printexusa.com>     ******

Greg -

The simple demo shows a decent example of how to write completed orders to 
a database - in that case, it is transactions.db.

If you take a look at yourcatalog/pages/etc/report.html (may not have .html 
extension), you will see the tags to write the completed order to the 
database near the top of the file:

         [tag flag write]transactions userdb[/tag][set name=import_results 
interpolate=1]
         [if session logged_in]
         [data
                 table=userdb
                 column=order_numbers
                 key="[data session username]"
                 value=" [value mv_order_number]"
                 append=1]
         [/if]
         Add main order [value mv_order_number] to transactions: [import 
table=transactions type=LINE    continue=NOTES]
         code: [value mv_order_number]
         store_id: __STORE_ID__
         order_number: [value mv_order_number]
         session: [data session id]
         username: [data session username]
         shipping: [shipping-desc] - [shipping]
         .
         .
         .
         [/import]

         [item-list] Added [item-code] to transactions: [import 
table=transactions type=LINE     continue=NOTES]
         code: [value mv_order_number]-[item-increment]
         store_id: __STORE_ID__
         order_number: [value mv_order_number]
         session: [data session id]
         username: [data session username]
         shipping: [item-code]
         nitems: [item-quantity]
         .
         .
         .
         [/import]
         [/item-list]
         [/set]

The code writes the order header and all line-items to the transactions 
file. The rest of the tags in the page format the "order report" , which 
you get in the form of an email, unless you have changed it.

You can export the transactions file to an ASCII file with:

         [tag export transactions transactions.asc][/tag]

This tag will be executed wherever it appears, so you could put in on an 
administration page, for example.

I hope this gives you a starting point.

- Ed LaFrance


At 04:19 PM 2/22/00 +0100, you wrote:
>******    message to minivend-users from "Greg Goble" 
><ggo@usia.co.at>     ******
>
>Version: minivend-3.14-3
>
>I've gotten this far just from the mail list and appreciate all the wisdom
>out there...
>
>However, I can't find any documentation that would help me export my
>orders/confirmations --typically
>received as an email-- into a database(inter office form) instead/or as
>well.
>
>Our firm has to take the orders received by email and then copy the data to
>an inter-office purchase
>order form. I'm hoping to eliminate this middle step by having the order
>generate not only an email to
>our office, but having the order info imported into an inter office form. I
>would think this is possible and
>would imagine a database such as excel might be the best bet.
>
>Is everyone else using just the email as the P.O. document?
>
>Thanks a mil. Greg
>
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list

Printex Marking Technologies
12113 Kirkham Rd.
Poway, CA  92064  U.S.A.
858-513-2418
800-982-1928
858-513-2419 FAX
http://www.printexusa.com

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list