VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: sohopros on February 25, 2022, 00:15:03 AM

Title: Using SQL to Update Translations
Post by: sohopros on February 25, 2022, 00:15:03 AM
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?
Title: Re: Using SQL to Update Translations
Post by: Jörgen on February 25, 2022, 00:45:00 AM
You have more pages with tables, all VM tables start with _virtuemart_

Jörgen
Title: Re: Using SQL to Update Translations
Post by: GJC Web Design on February 25, 2022, 15:52:00 PM
use the pagination to see the later pages
Title: Re: Using SQL to Update Translations
Post by: sohopros on February 25, 2022, 20:01:59 PM

"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
Title: Re: Using SQL to Update Translations
Post by: Jörgen on February 25, 2022, 21:24:27 PM
You are welcome  8)

Jörgen