PDA

View Full Version : Sorting products alphabetically


Lordlister
10-Sep-2003, 02:11 PM
I have many products.sections that I would like sorted alphabetically, is there any way this can be done? (Preferably with having to cut and paste everything one at a time)

Also, I have a disk with all the pictures on it, however they are all very large file sizes, is there any way of resizing them all, again without having to do it one at a time. Perhaps someone knows of a piece of software that will do this?

printerbase
10-Sep-2003, 02:26 PM
For batch resizing of files have a look at www.irfanview.com I haven't tried it but it is supposed to be quite good. You could also use Macromedia Fireworks.

As for sorting this is something I would also like to see, the ability to sort sections alphabetically or by product price.

Peter

Lordlister
10-Sep-2003, 03:16 PM
Thanks Peter, thats just the ticket, I have downloaded a copy and it works fine. Must confess I wasn't really expecting an answer to the image question, I just put it up on the off chance.

Lets hope Actinic create in a sort patch.

Jan
10-Sep-2003, 03:23 PM
To reorder items in Actinic you have to drag and drop them in the parent section. However the order is determined by a field called 'Product Sequence' in the product table so you could write a program (in something like VB or C++) to reorder the items in alphabetical order quite easily.

Regards,

Lordlister
10-Sep-2003, 03:43 PM
Thanks Jan, good idea. Would you know which file I am looking for and where it may be located?

Jan
10-Sep-2003, 03:51 PM
Originally posted by Lordlister
Thanks Jan, good idea. Would you know which file I am looking for and where it may be located?

The database is called ActinicCatalog.mdb and it is an access database, you will find it in your site directory, the table is called products. Take a backup before you do anything just in case.

Regards,