JoomlaVM

  • Increase font size
  • Default font size
  • Decrease font size
Home Virtuemart development How to Upload / import of customer details for Virtuemart?

How to Upload / import of customer details for Virtuemart?

  I had to migrate users from old e-shop into VirtueMart. After short research on web I found tool for import Joomla users (userport, author: Parvus) but no one for VM.
After another research I found tables which must be filled, but also with main problem: How to generate "user_info_id", solved by this function:
md5( date_format( date_add( sysdate( ) , INTERVAL FLOOR( 1 + ( RAND( ) *998 ) ) MICROSECOND ) , "%Y%m%d%H%i%s%f" )

My “quickly prepared” solution use several steps and tools described below:
1) Joomla component – userport
2) MS Excel tool for user import from any user list source
3) MS Access query – for extract new user only (not assigned to VM shopper groups)
4) MS Excel tool for bulk MySQL query

Author:Palo

 

VirtueMart Shopping Cart

VirtueMart
Your Cart is currently empty.

Newsletter


Newsflash

Virtuemart Upload Component

Upload Images and Files with your order in Virtuemart - VMUpload is a versatile plugin to the core application Virtuemart that allows for a customer to upload files to their order based on parameters established by the site administrator. it include a Joomla component and a Virtuemart patch.

Feature Summary

Font-end:

  • Upload and bind the files to a order
  • Ability to add more upload fields as needed
  • Secure client folder created as upload destination (folder name defined by username)
  • Create the thumbnail image automatically if the uploaded file is picture
  • Integrate with an image gallery for photos, show upload picture with lightbox
  • CSS friendly coding; Multi-language compatible (English native)

Back-end:

  • Check the uploaded files based on client orders
  • Download uploaded files from orders
  • Config number of maximum Files to upload
  • Config Maximum files size
  • Config upload file folder
  • Choice of acceptable file types
  • Creation of thumbnail image to defined size
  • Manage the uploaded files