Topic Options
#39998 - 07/05/12 06:24 AM Quantity for a document with database file upload
Tom R. Offline
OL Newbie

Registered: 10/27/11
Posts: 20
Loc: France
Hello!

i have a document "carte de visite" that works like a charm, with a database file uploaded by user.

My issue is at the cart proceed : i cannot chose a quantity, cause she is defined by the number of entry in the DB.

So, if my client need 200ex of each entry, he has to duplicate them in his DB... not very easy.

I tried other way that works good : in the DB, i put a column named "quantity" where i fill a number.
I use this var to complete the field "number of copy" of the "page layout" in PSM.

My DB is like that (simplified):
Code:
nom       |prenom   |quantité
roche     |tom      |200
gallego   |gerald   |400   



It works in PSMW, the preview and the generated file/print give me 600 pieces of "cartes de visite".
But the quantity in the cart still 2. NOK for price obviously...

an idea?
Thanks!
Tom



Edited by Tom R. (07/05/12 07:11 AM)

Top
#40018 - 07/09/12 11:09 AM Re: Quantity for a document with database file upload [Re: Tom R.]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
Tom,

The quantity in the cart is the number of copies of the job that you have ordered, regardless of how many pages the job contains. By changing "number of copies" in the "page layout", you will add more pages to the document, but it is still one single document, and so, one single order. So in this case, you order 2 documents with 200 and 400 pages respectively, but it's still 2 documents and that's what the quantity displays.

If you want to be free to enter the quantity, perhaps you can go in the publication type's properties, under "Pricing and Ordering" and set the quantity to "free entry" to allow you to enter the quantity that you want.

Regards,
Raphaël Lalonde Lefebvre

Top
#40025 - 07/10/12 04:04 AM Re: Quantity for a document with database file upload [Re: Raphael Lalonde Lefebvre]
Tom R. Offline
OL Newbie

Registered: 10/27/11
Posts: 20
Loc: France
Hello Raphael,

Thx for the repply.
But It doesnt work.
Even if i check "Free Entry" the quantities message still "The quantity of this document is determined by the number of records in the database"

So, i reformulate :
i have a customer who frequently commands visits cards.
He has between 10 and 30 series of cards (same model) by order.
200/400ex for each serie.

What is the easiest way to do that?

Thx in advance,
Tom

Top
#40034 - 07/10/12 05:19 PM Re: Quantity for a document with database file upload [Re: Tom R.]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
Tom,

Looking into this, I will get back to you.

Regards,
Raphaël Lalonde Lefebvre

Top
#40078 - 07/13/12 10:19 AM Re: Quantity for a document with database file upload [Re: Raphael Lalonde Lefebvre]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 4953
Loc: Objectif Lune Montreal
Tom,

After checking with the developpers regarding this, it appears that what you are asking is currently not possible in PSMW 7.2. However, version 8 will have the option to use a database field as the value of the quantity, so it will be possible in version 8.

If everything goes well, I believe version 8 should be out sometime during the last quarter of the year. No official release dates yet though.

Regards,
Raphaël Lalonde Lefebvre

Top