Author Topic: VirtueMart - CSV Import / Export Utility Tutorial and Files  (Read 21979 times)

happyhallsy8

  • Beginner
  • *
  • Posts: 4
Hey guys... in my effort to find a utility for basic import and export function of product details features actual items ect. I came across alot of files and random articles anyhow... This here is the combined efforts of a couple hours work a great lot of programing from various people.

Tested On: Joomla 1.5.17 and VirtueMart 1.1.4
For those who like the free way ;)

Step 1: Grab the attached zip file on this post...
Step 2: Unzip
Step 3: Log into your joomla installation.
Step 4: Navigate to Extensions | Install/Uninstall
Step 5: Browse and Install the file com_simplecsv_1.2.2b.zip
Step 6: Once Installed Navigate to Components | SimpleCSV
Step 7: Select Export then Select all check boxes excluding these fields bellow

      product_thumb_image
      product_full_image
      product_url
      shopper_group_id

Step 8: Make your way up the top and click the save disk...
Step 9: Edit your file to your liking using CSV Edit ect.
      (NOTE!! EXCEL USERS MUST CONVERT THE CSV BY RUNNING THE INCLUDED MACRO)
      (Open CSV Delimiter Writer For Excel)
      (Navigate and select open CSV in EXCEL press CTRL+SHIFT+M)
      (c.txt is newly created import CSV)

Step 10: Navigate back to joomla and select the browse button down the bottom and upload your c.txt / export.csv either selecting import / update accordingly up the top, you may have to rename c.txt to .csv 6am no sleep you get the drift...
Step 11: Should result with joomla returning updated file success

Thanks Guys and have a good morning kudos on Roman Nagaev for Simple CSV and Erl Kiosterud for the EXCEL Macro

[attachment cleanup by admin]

QubeSys Technologies

  • Full Member
  • ***
  • Posts: 288
  • Joomla & Magento Services
Re: VirtueMart - CSV Import / Export Utility Tutorial and Files
« Reply #1 on: July 09, 2010, 23:12:00 pm »
ANyone tried this ?
Looks good. Is it working ?
Blissful!

alexround

  • Beginner
  • *
  • Posts: 1
Re: VirtueMart - CSV Import / Export Utility Tutorial and Files
« Reply #2 on: July 25, 2010, 01:05:27 am »
Something went wrong with my test; is step 9 necessary? When I have imported my export.csv file it gives me 0 of 0 result. Why?

austim

  • Beginner
  • *
  • Posts: 7
Re: VirtueMart - CSV Import / Export Utility Tutorial and Files
« Reply #3 on: August 25, 2010, 23:14:22 pm »
I dont know if this is the same as SimpleCSV. I am using simpleCSV to import the products and it is a lot faster than manual entry.

ANyone tried this ?
Looks good. Is it working ?

happyhallsy8

  • Beginner
  • *
  • Posts: 4
Re: VirtueMart - CSV Import / Export Utility Tutorial and Files
« Reply #4 on: January 21, 2011, 15:17:37 pm »
hey guys.. sorry for the late reply...

not sure if this still works with current versions but yes the macro is required with excel as the csv delimeter is different when saving as csv..

I've recently uploaded and installed CSVI and am having wonders using this utility well worth the 30E you pay :).


tazitiger

  • Beginner
  • *
  • Posts: 1
Re: VirtueMart - CSV Import / Export Utility Tutorial and Files
« Reply #5 on: April 07, 2014, 12:47:05 pm »
Hi, is there a version of this which will work in joomla 2.5 + virtuemart 2?