News:

Looking for documentation? Take a look on our wiki

Main Menu

updating Virtuemart tables by .xls/.xlsx -> DB sql

Started by lipes, May 20, 2012, 19:36:43 PM

Previous topic - Next topic

lipes

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.

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

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...
VM V. online: J2.5.14 | VM 2.0.20a | SQL 5.1.70 | PHP 5.3.25