Database

[davime]

I have over 10,000 items to put into the database. Is there a way that they can be loaded from an MS Access database or a CVS file?

[HQ Secure]

I'm not an expert on this but just off the cuff if it were me I'd probly build a macro to preface the items the csv with proper sql then wham! Of couse you'd have to get you fields to line up.

 

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('24', 'insurance.gif', '0', '7', '2002-09-21 10:08:02', '2002-09-25 17:04:13');

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('29', 'Memberships.jpg', '0', '0', '2002-09-25 17:09:34', '2002-09-25 17:26:16');

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('25', '1.jpg', '0', '5', '2002-09-25 09:24:58', '2002-09-25 17:27:17');

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('26', 'cat.tube.beads.jpg', '0', '0', '2002-09-25 10:21:01', '2002-09-25 10:23:59');

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('27', 'cat.trillian.beads.jpg', '0', '0', '2002-09-25 10:49:58', NULL);

insert into categories (categories_id, categories_image, parent_id, sort_order, date_added, last_modified) values ('28', 'cat.barrel.rondell.beads.jpg', '0', '6', '2002-09-25 11:00:52', '2002-09-25 17:27:00');

[Guest]

I have over 10,000 items to put into the database. Is there a way that they can be loaded from an MS Access database or a CVS file?

 

as long as the field structure of your CSV file is resonably close to the OSCommerce structure, you should be able to home grow some sort of import script. I pull a database from a SCO box into a CSV file, and then use that to populate the oscommerce database.

 

Short answer is, it is very possible to import a csv file into oscommerce,

 

The long answer is, it isn't all that easy under the best of cirumstances.

 

You will end up using a bunch of "insert into ... from file ... " sql statements. The good news is that once it works, you can kinda forget about it until the database structure changes.

 

Ken Terrell

[djbazzer]

Hi,

 

I have used a free program called AccessDump to do this in the past which does all the work for you.

 

I do not remember where I downloaded it from, but a search of the Internet should turn it up.

 

Barry

[Guest]

you can do it via a spreadsheet, it is slow, and you are limited into how many at a time, but it can be done.

 

i use easy populate, one of my customers is populating with approximately 30000 items, either way you still have to key things in, to a certain extent