[ic] Questions about product

[Sam Batschelet]

On Aug 19, 2012, at 7:06 PM, Derek Tracy wrote:

> Hello,
>  
> Is there a way to export my customers as well as orders to an excel spreadsheet? Is there a way to access the MySQL database? If so, could you please provide me with the steps on how to do so?
>  

Derek,
There are many ways to do what your asking.  I would first contact your web host and ask about the mysql access for you interchange catalog.  They should be able to give you the information that you need to access the database remotely.  Then you have a few options if you want to learn how to use mysql with shell commands perhaps getting a book on mysql or googling.  A good background in MySQL and SQL will go along way towards managing an interchange catalog.  Depending on the version of interchange your using take a look at the backup-database tag.  http://docs.icdevgroup.org/cgi-bin/online/tags/backup-database.html.  This may or may not work I have never tried it according to the docs it has been with interchange since 4.6.  And lastly but easiest (if it works) if you have a catalog with the admin ui checkout admin/gentable.html, customers are in userdb orders are in transactions and invoice lines are in orderline.  I would workout a proper backup/restore procedure before making any changes or uploads of course.  Hope that helps,

-Sam  

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.icdevgroup.org/pipermail/interchange-users/attachments/20120820/ffbcf0d2/attachment.html>