Lost password?    Lost username?    Register

CSV Improved - News

Tuesday, 16 March 2010 12:17
PDFPrintE-mail

Often when we import files we run into errors that the file is not being read correctly. Where to start looking for the cause of the issue and how to solve this?

Checkpoints

Follow these checkpoints to make sure that you have the basics right.

  1. Up-to-date Available Fields
    The list of available fields should be up-to-date before importing starts. If the field list is not up-to-date the import may fail due to missing fields. To update the list of available fields go to Maintenance -> Select Update Available Fields -> Click continue
  2. A clean CSV file
    A CSV file should not have any extra characters in any place. A good CSV file may look like this:
    "product_sku","product_name"

    A bad CSV file may look like this:
    "product_sku,product_name"  <-- The " at the beginning and end of the line are wrong
    or
    product_sku,product_name, <-- The trailing comma is wrong
  3. Delimiters
    The template must use the same delimiters as your file has. The type of delimiters does not matter. To know what delimiters your file uses look at your file with Notepad for example.
    Some examples of delimiters are:

    Sample Field delimiter Text enclosure
    "product_sku","product_name" , "
    ~product_sku~^~product_name~ ^ ~
    product_sku|product_name |
  4. Encoding
    The file must always be encoded in UTF-8 format. No other encoding is supported. See this video on how to save your file as UTF-8 using Notepad2.

  5. Field names
    Use only fieldnames that are available for the type of import you are doing. To see which fieldnames are available go to CSVI VirtueMart ---> Available Fields and filter on the type of import you want to do. It is not possible to use any other name.

  6. Field data
    Make sure the data is properly formatted according to the specifications on the Available Fields list.

  7. Check the debug information
    The debug report shows every step CSVI VirtueMart takes when importing the file. See the How to collect debug information on how to get your debug report. Check the debug information for anything that might be going wrong.

After having checked these checkpoints your import should be running smoothly. Check out also this presentation on how to prepare your CSV file.

 
Wednesday, 10 March 2010 21:46
PDFPrintE-mail

A simple presentation to show you the key points to look for when preparing your CSV file for import. This presentation deals with the issues regarding:

  • Field names
  • Field data
  • Delimiters
  • Encoding
  • Line endings
This presentation is available to everyone and can be downloaded from the download section.
 
Wednesday, 10 March 2010 19:44
PDFPrintE-mail

Today a new instruction video has been released. This video will show the following steps using CSVI VirtueMart 2.x:

  • Create an export template
  • Add fields to an export template
  • Export data using the export template
  • Open the exported file in a spreadsheet
  • Create an import template
  • Import data using the import template
  • View the imported data in VirtueMart

Have a look at the video if you are not sure about how to create templates, export data and import data. A basic export and import is explained step by step, nothing fancy. The video is made keeping in mind the most simple approach of using CSVI VirtueMart.

The video is available for users with an active subscription from the download section.

 
Monday, 08 March 2010 10:59
PDFPrintE-mail

Today a maintenance release of CSVI VirtueMart is available. The most notable fix being the missing files for the order item import and export Embarassed. A few minor fixes have been done also including the failed installation on Joomla 1.5.1.0. However I cannot say enough times it is important to keep your Joomla installation up-to-date.
   
Wednesday, 03 March 2010 10:57
PDFPrintE-mail

The flexibility of Excel with CSV files is quite limited, so limited even that you cannot use your own field delimiter, text enclosure and encoding when opening a CSV file.

Read more: Excel and CSV

 
Wednesday, 24 February 2010 22:55
PDFPrintE-mail

Today another release of CSVI VirtueMart has been brought to you with some magnificent features. Apart from the already long list of features a few more have been added.

What features have been added:

  • Order import
    The long awaited order import is finally here. Streamline your order status updates with automatic order import and export.
  • Order items import
    Update and add items to your orders
  • Backup VirtueMart database
    With a single click you can now backup all your VirtueMart tables into a single zip file. In case you need to recover, you can use this file in PhpMyAdmin to reload your full VirtueMart setup.
  • Import encrypted passwords
    When importing users, you can now also import already encrypted Joomla passwords. No need anymore for generating new passwords.
  • Order payment method for export
    Export orders based on the payment method your customers have used
  • and more .... see the changelog for full details

An updated CSVI VirtueMart Handbook is also available to accompany this release. Make sure you get your copy so you have all the latest details.

As of this release translations are no longer installed due to lack of participating translators and the files were too outdated. A section in the forum will be made available where people can make translations available. The latest translations will be placed there soon.

This release is available for all users with a subscription and can is now available for download.

   

More Articles...

Page 1 of 2

  • «
  •  Start 
  •  Prev 
  •  1 
  •  2 
  •  Next 
  •  End 
  • »

Latest Products

CSVI JoomFish 3 year subscription
CSVI JoomFish 3 year subscription
€95.20

CSVI JoomFish 2 year subscription
CSVI JoomFish 2 year subscription
€65.45

CSVI JoomFish 1 year subscription
CSVI JoomFish 1 year subscription
€35.70

VmCategoryModule
VmCategoryModule
€17.85

CSVI SOBI 3 year subscription
CSVI SOBI 3 year subscription
€95.20

Other users say...

Atul Kumar said:
It took me some time to understand how CSV Improved works, but once understood everything worked flawlessly. Excellent product and highly recommended for every virtuemart store.

Di Lyons said:
I love this product. I have bought 3 or 4 licences so far for my customers. I loaded over 7,000 products with category depths up to 7 in just a few hours. The support is excellent as well! Thanks Roland.

Di Lyons said:
I have purchased both the CSVI and Menu products from Roland and they work exactly as indicated and the additional support is brilliant. Roland is the number 1 Joomla Extension reseller to deal with. Well done guys. Build more stuff for us. Thanks Roland!

© JoomingDales

Partners


    Recommended sites by CSV Improved.com
    • redCOMPONENT
      redCOMPONENT brings you a large collection of free components, modules and plugins for Joomla 1.5.
    • Joomingdales
      Joomingdales the place to be for great free extensions for both Joomla and VirtueMart.
Hosting is kindly provided by redHOST.