|
From: john c. <jwc...@gm...> - 2009-05-12 02:33:20
|
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... |