• From: Netherlands
  • Registered: 04/28/2009
  • Posts: 80

Topic: What data is stored in these tables

I don't know if this topic is in the right place, but let's give it a try.

I would like to find out what data is stored in the tables below:
(I might update this message as i'm digging trough the database)

For now only one table:
0_sys_types Filled with English data, present in the empty and demo database

  • Registered: 12/25/2007
  • Posts: 2,448

Re: What data is stored in these tables

Those are types of transactions used by FrontAccounting you should translate type_name  leaving other fields intact.
Janusz

3 Reply by jackel7007 (edited by jackel7007 05/19/2009 09:54:53 pm)

  • From: Netherlands
  • Registered: 04/28/2009
  • Posts: 80

Re: What data is stored in these tables

Alright, clear.
Can you tell me in which screen in FA those names are found?

Maybe you guys can try to change it in this way, that those names are replaced to the PO file. In this way they are translated in other languages, and it doesn't require any database / SQL editing.

  • Registered: 12/25/2007
  • Posts: 2,448

Re: What data is stored in these tables

Not all data can be included in source (e.g. names in chart of accounts), so sql file have to be translated in some places as well if you wish to have all names localized.
Janusz

  • From: Netherlands
  • Registered: 04/28/2009
  • Posts: 80

Re: What data is stored in these tables

jackel7007 wrote:

Can you tell me in which screen in FA those names are found?

I mean, in which menu item or screen do those names appear when using fa?

  • Registered: 12/25/2007
  • Posts: 2,448

Re: What data is stored in these tables

They are used in Forms Setup (forms_setup.php).
Janusz

  • From: Netherlands
  • Registered: 04/28/2009
  • Posts: 80

Re: What data is stored in these tables

Well, those are already translated trough the PO files.
So I think there is no need to translate them in the database

  • Registered: 12/25/2007
  • Posts: 2,448

Re: What data is stored in these tables

No, those strings are fetched from database, so when not translated they are displayed in english.
Janusz