Author Topic: importing csv excel file directly.  (Read 1543 times)

chetanmadaan

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 291
importing csv excel file directly.
« on: July 17, 2009, 20:28:45 pm »
guys... i have got an database import kinda thing here.

i have got a Csv and have to import it directly to the databse.

the reason is there are around 1250 products and adding each one manually will be wastage of time.

so, if you have had experience with this. please help me out!

any advices would be great!

jenkinhill

  • UK Web Developer & Consultant
  • Global Moderator
  • Super Hero
  • *
  • Posts: 28194
  • Always on vacation
    • Jenkin Hill Internet
Re: importing csv excel file directly.
« Reply #1 on: July 18, 2009, 00:12:15 am »
If you work though the documentation ion http://www.csvimproved.com/csv-improved-documentation/ and apply it then all is easy.

You should use OpenOffice.org Calc to edit/prepare the CSV files for import.
Kelvyn

Jenkin Hill Internet,
Lowestoft, Suffolk, UK

Unsolicited PMs/emails will be ignored.

Please mention your VirtueMart, Joomla and PHP versions when asking a question in this forum

Currently using VirtueMart 3.8.9.10473 on Joomla 3.9.28 PHP 7.4.14

chetanmadaan

  • 3rd party VirtueMart Developer
  • Jr. Member
  • *
  • Posts: 291
Re: importing csv excel file directly.
« Reply #2 on: July 18, 2009, 00:34:11 am »
will try and for sure post feedback here.