News:

Support the VirtueMart project and become a member

Main Menu

Using SQL to Update Translations

Started by sohopros, February 25, 2022, 00:15:03 AM

Previous topic - Next topic

sohopros

We are getting ready to update translations (English, French, and Spanish) for Custom Fields for our products. Once we have set up the language variables and values, and updated the language .ini files, all of our products' (>1,000) configurations will need to be updated for all Custom Fields (11) and their default values (80).
We think this last step would be best performed via a sql query to the database, but are not familiar enough with the VM data tables to do it. When we view the website's database in phpmyadmin, we see the attached, but don't recognize any of the tables as associated with Virtuemart.

Can you tell us which are the VM tables?

Jörgen

You have more pages with tables, all VM tables start with _virtuemart_

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

GJC Web Design

use the pagination to see the later pages
GJC Web Design
VirtueMart and Joomla Developers - php developers https://www.gjcwebdesign.com
VM4 AusPost Shipping Plugin - e-go Shipping Plugin - VM4 Postcode Shipping Plugin - Radius Shipping Plugin - VM4 NZ Post Shipping Plugin - AusPost Estimator
Samport Payment Plugin - EcomMerchant Payment Plugin - ccBill payment Plugin
VM2 Product Lock Extension - VM2 Preconfig Adresses Extension - TaxCloud USA Taxes Plugin - Virtuemart  Product Review Component
https://extensions.joomla.org/profile/profile/details/67210
Contact for any VirtueMart or Joomla development & customisation

sohopros


"use the pagination to see the later pages
You have more pages with tables, all VM tables start with _virtuemart_"


Thanks for the help! I'll update if we have any other problems

Jörgen

Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.