Lost Password?

Shape5

up-down
linktree Shape 5  >  General Category  >  General Talk/Questions/Comments
linktree Topic: Transfering data to mysql
Pages: [1]
Print
Author Topic: Transfering data to mysql  (Read 420 times)
jc786
Sr. Member
****
Offline Offline

Posts: 22
« on: October 08, 2008, 01:19:35 PM »
Hi,
I have bought the eMercantalism template and as soon as i get it configured the next step is to think about transfering my existing data from an mssql database into mysql. I have played around a little with myphpadmin and can see that one way to do it is to copy and past my data into phpadmin tables directly 

The only problem is that i do not have access to the mssql  db but can download an excel file of the data.  Another problem i foresee is how to transfer the images. currently there are named according to my own unique product codes. I have no idea how to transfer the images.

Please advise how i should attempt the data Transfer. Any insight would be greatly appreciated.
Jc
Logged
jonahh
Administrator
*****
Offline Offline

Posts: 2124



WWW
« Reply #1 on: October 09, 2008, 12:22:16 PM »
Hey JC,

When you say data is this products on your site or content.  If its products VirtueMart actually has in import feature for this.
Logged
-Jonah
------------
Shape 5 Team
jc786
Sr. Member
****
Offline Offline

Posts: 22
« Reply #2 on: October 11, 2008, 03:59:23 PM »
hi Jonah,
My current site is an asp.net site using ms sql but i can download all my product data as an excell file. Hope that helps
jc
Logged
jonahh
Administrator
*****
Offline Offline

Posts: 2124



WWW
« Reply #3 on: October 13, 2008, 12:51:14 PM »
Yes, believe you can import this into VirtueMart then, should be through a CSV file.  Check out their forums and site for more details.
Logged
-Jonah
------------
Shape 5 Team
Pages: [1]
Print
linktree Shape 5  >  General Category  >  General Talk/Questions/Comments
linktree Topic: Transfering data to mysql
 « previous next »
Jump to: