Forums

Now that we have the ability to import a SugarCRM Language Pack, there is very little need to create something specific to SplendidCRM. I encourage you to use SplendidCRM to locate the deficiencies in the existing SugarCRM Portuguese Language Pack, but then to focus on updating the PHP version. The theory is to have one location for the master.

Another alternative is to create a XML Language Pack format and allow SplendidCRM to import and export this format. XML is far superior to PHP as a format to contain data.

Here are some database scripts that I wrote for the folks at HighWeb to help them determine the gaps in the PHP Portuguese - Brazilian Language Pack.

-- Count English terms
select count(*)
from TERMINOLOGY
where LANG = 'en-US'

-- Count Brazilian terms
select count(*)
from TERMINOLOGY
where LANG = 'pt-BR'

-- List the missing Brazilian terms
select TERMINOLOGY_ENGLISH.*
from TERMINOLOGY TERMINOLOGY_ENGLISH
left outer join TERMINOLOGY TERMINOLOGY_BRAZIL
on TERMINOLOGY_BRAZIL.NAME = TERMINOLOGY_ENGLISH.NAME
and (TERMINOLOGY_BRAZIL.MODULE_NAME = TERMINOLOGY_ENGLISH.MODULE_NAME or (TERMINOLOGY_BRAZIL.MODULE_NAME is null and TERMINOLOGY_ENGLISH.MODULE_NAME is null))
and (TERMINOLOGY_BRAZIL.LIST_NAME = TERMINOLOGY_ENGLISH.LIST_NAME or (TERMINOLOGY_BRAZIL.LIST_NAME is null and TERMINOLOGY_ENGLISH.LIST_NAME is null))
and (TERMINOLOGY_BRAZIL.LIST_ORDER = TERMINOLOGY_ENGLISH.LIST_ORDER or (TERMINOLOGY_BRAZIL.LIST_ORDER is null and TERMINOLOGY_ENGLISH.LIST_ORDER is null))
and TERMINOLOGY_BRAZIL.LANG = 'pt-BR'
where TERMINOLOGY_ENGLISH.LANG = 'en-US'
and TERMINOLOGY_BRAZIL.ID is null

-- Insert missing Brazilian terms using English values
/*
insert int TERMINOLOGY(LANG, NAME, MODULE_NAME, LIST_NAME, LIST_ORDER, DISPLAY_NAME)
select 'pt-BR'
, TERMINOLOGY_ENGLISH.NAME
, TERMINOLOGY_ENGLISH.MODULE_NAME
, TERMINOLOGY_ENGLISH.LIST_NAME
, TERMINOLOGY_ENGLISH.LIST_ORDER
, TERMINOLOGY_ENGLISH.DISPLAY_NAME
from TERMINOLOGY TERMINOLOGY_ENGLISH
left outer join TERMINOLOGY TERMINOLOGY_BRAZIL
on TERMINOLOGY_BRAZIL.NAME = TERMINOLOGY_ENGLISH.NAME
and (TERMINOLOGY_BRAZIL.MODULE_NAME = TERMINOLOGY_ENGLISH.MODULE_NAME or (TERMINOLOGY_BRAZIL.MODULE_NAME is null and TERMINOLOGY_ENGLISH.MODULE_NAME is null))
and (TERMINOLOGY_BRAZIL.LIST_NAME = TERMINOLOGY_ENGLISH.LIST_NAME or (TERMINOLOGY_BRAZIL.LIST_NAME is null and TERMINOLOGY_ENGLISH.LIST_NAME is null))
and (TERMINOLOGY_BRAZIL.LIST_ORDER = TERMINOLOGY_ENGLISH.LIST_ORDER or (TERMINOLOGY_BRAZIL.LIST_ORDER is null and TERMINOLOGY_ENGLISH.LIST_ORDER is null))
and TERMINOLOGY_BRAZIL.LANG = 'pt-BR'
where TERMINOLOGY_ENGLISH.LANG = 'en-US'
and TERMINOLOGY_BRAZIL.ID is null
*/