<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
<BR> <BR>
> Date: Fri, 7 Jan 2011 09:14:33 -0500<BR>> From: sam@westbranchresort.com<BR>> To: interchange-users@icdevgroup.org<BR>> Subject: Re: [ic] Add/update large number of products<BR>> <BR>> <BR>> <BR>> ----- Original Message -----<BR>> From: "DB" <DB@M-and-D.com><BR>> To: interchange-users@icdevgroup.org<BR>> Sent: Friday, January 7, 2011 9:01:45 AM<BR>> Subject: [ic] Add/update large number of products<BR>> <BR>> I often need to add or update many thousands of items at a time to my<BR>> products table. Mostly I use the Import feature from the admin area, but<BR>> if the file I'm importing is large enough I can run into server timeouts<BR>> before the upload completes. To solve this I've chopped the file into<BR>> several pieces, but that's kind of a pain. I've also added products<BR>> directly using mysql.<BR>> <BR>> Is there an easy way to tell the admin's Import feature to look for a<BR>> file that's local to the server? Is there a better way to handle this<BR>> that I've not tried?<BR>> <BR>> DB<BR>> <BR>> I would guess there are many ways of doing this I use a nice little program called Navicat allows me to do all kinds of updates direct to mysql/postgres its not free exactly but imo worth the money, another might be phpmyadmin same idea and free. This will make you better in touch with the db structure and help you move away from admin a little. I use admin gui for quick item changes and order information. But to each his/her own.<BR>> <BR>> -Sam<BR>> <BR>
<BR>
<BR>
I use dbs_update to update the database for years for the same reason you have. Just upload your database and import it with dbs_update. Thanks<BR>
<BR>
<BR>
Raymond<BR>
<BR>
<BR> </body>
</html>