[Kbarcode] solved: product in random order as serial number advancing

[john c. <jwc...@gm...>]

i believe i have found the solution.  it appears the primary sort field for
printing is the "group" column, followed by the "article_no" column of the
csv used to import print quantities, even though it displays in preview as
sorted from the file.  i have not tried to leave out the "group" column, i
just replaced that information with data that kept the list in the same
order.

i will experiment further as time permits but this just makes KBarcode all
the more functional for my everyday needs.

thanks for a easy to use and straight forward product.
john

---------- Forwarded message ----------
From: john clayton <jwc...@gm...>
Date: Mon, May 11, 2009 at 7:33 PM
Subject: product in random order as serial number advancing
To: kba...@li...


I am using ver 2.0.7 3.5.10 "release 21.9" openSUSE 11.1

i am able to import my csv file into MySQL and create barcode labels with no
problem.  i encounter a problem when i try to create labels for my cartons
using the serial number function so that the carton number will be printed
out (carton XX of 381).

I use the correct label file, i pull style data from the SQL table and i
import qtys using a csv file.  the goods show up in the order and quantities
that i need in the final preview window.  i then begin the serial number
sequence at 000001 and increment by one each time.  i then print to a pdf
file using cups so that i may review it an pass it on to different users to
print.  the styles seem to have been shuffled when the file is created.  the
size/style run stays together but the styles are not in the order that i
have imported them and viewed them earlier.  when imported, i have made sure
the styles are in the same sequence that they have been imported into the
SQL table but they do not print out that way so styles out of sequence for
the batch printing is not the issue.

if you need me to send a file, i am happy to do that but as a pdf, even my
small file is 3.1mb

are there any queries that i can use to keep everything in the correct
order? (please keep them simple, i'm not good with queries).  this is for
sequences of up to 2600 cartons so this would make life much easier.

thanks
john
jwc...@gm...