Updating Database

[acemang]

Updating Database
To update my database I use easy populate.
But in table easy populate creates there is no variable for the medium image and I need this.
Im missing something here? Can I put that variable in easy populate? If yes, How?

Acemang.

[doug]

I would suggest contacting the developer who wrote the Easy populate contrib for assistance.

For the record I simply use Excel and save as csv and use that.

[acemang]

Can you teach me how do you use the csv?

Thanks for Help.

[doug]

I mean <filename>.csv not CVS (concurrent version system) used by many open source development teams including osC.

With .csv it is simply a comma separated value file you can save them from excel by changing the format when saving...

[Petter]

Acemang,

There is a contribution called 'Mo Pics Modification v1.1 for OsCommerce 2.2'

The contrib is accompanied by a text-file with instructiones for changing the structure of the table, here's a part of this file:
+==========+
// Each of these lines go into the MySQL Database. You must add them one at a time using PHPMyAdmin

ALTER TABLE `catalog`.`products` ADD `products_subimage1` VARCHAR(64) AFTER `products_bimage`
ALTER TABLE `catalog`.`products` ADD `products_bsubimage1` VARCHAR(64) AFTER `products_subimage1`
ALTER TABLE `catalog`.`products` ADD `products_subimage2` VARCHAR(64) AFTER `products_bsubimage1`
etc...
+==========+

I love this instruction, as the 'standard' instructions usually says:
+==========+
drop table if exists *****;
create table ***** (
etc...
+==========+

...which really s***s if there are values inside this table...

Now, you should be able to put together a SQL-query based on the above code (far above mind you) to change your DB.

Hope you figure it out, good luck!

PS! Backup, backup and backup!