VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: lipes on May 20, 2012, 19:36:43 PM

Title: updating Virtuemart tables by .xls/.xlsx -> DB sql
Post by: lipes on May 20, 2012, 19:36:43 PM
Unfortunately the Table names of all Virtuemart 2 have a long name than the oldest VM1 version ("virtuemart" vs "vm")
for example "jos_virtuemart_shipmentmethod_shoppergroups" 43 characters

The Office Excel only permit the max of 31 characters length in the sheet name.. But dont know if OpenOffice or Libre office have same problem in length.
(http://img32.imageshack.us/img32/3554/officea.jpg)
This could be solved if the VM2 table name were more small (name) we could do a fast export (from excel in .xls or .xlsx format) and them upload that file into phpmyadmin
(http://img256.imageshack.us/img256/3513/xlsu.jpg)
without need to change UTF or convert into .CSV, etc ... like we need to do ... or need to install 3rd party modules to do that to...