Re: [mv] An automation problem

[jojo@buchonline.net]

******    message to minivend-users from jojo@buchonline.net     ******

On 11 Aug, rattan mann wrote:
> ******    message to minivend-users from "rattan mann" <rattanmann@hotmail.com>     ******
> 
> Dear sirs,
> 
> I am writing this letter from a small company in Norway because the people 
> who configured our minivend have all left long ago without leaving their 
> addresses behind.So people like me who have just a few weeks "experience" 
> with minivend are left to tackle this problem.
> 
> We are using minivend version 4.04.
> 
> When our company receives an order via e-mail we have to create
> invoice(faktura) and address form (adresse lapp) manually.This has led to
> a great backlog of unfulfilled orders and so we want this process
> to be automated.For this we have come up with the following suggestion:
> 
> Instead of writing a report (minivend/ourminivend/etc/report)to a text
> file we write this report to the database from where this process can be
> automated.We use MySql database.
> 
> This implies creating a table called orders with fields like ordredato,
> ordrenummer,lead source etc.in MySql and inserting the following code in 
> etc/report:
> 
> [tag]
> [set import_status]
> [import table=orders type=LINE continue=NOTES]
> [scratch order_text]
> [/tag]
> 
> But when we use this we always get the error that the orders table does not 
> exist.
> 
> I request anybody who can help to write to me so that I can give more
> details if necessary.
> 
> Tons of thanks in advance.

Have a look at .../simple/pages/query! There are two html files!
Have a look at the table "transactions"! All the processed orders are
there, if the setting of the catalog.cfg is right!

Regarding the error...have you create a table? Have you a file like
orders.mysql or so?

Joachim


-- 
Hans-Joachim Leidinger
buch online                 jojo@buchonline.net
Munscheidstr. 14            FAX: +49 209 1671449
45886 Gelsenkirchen         FAX: 0209 1671449

-
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