[Kexi] kexi to scan for new tables

[Jarosław Staniek]

somekool at gmail.com said the following, On 2005-10-29 18:42:

> I think still now, all tables need to be registered in kexi's system table.
> I need to be able to add table by myself from outside kexi and being able to
> see and play with them in kexi. I'd like to know when is this gonna be
> available ? is it something that is already done ? planned soon or plan
> later ?

It's available since 0.9 version. Open Kexi (with cancelling the startup 
dialog) and use Tools->Migration in the menu. By selecting exisitng non-kexi 
project (mysql/postgresql/sqlite/msaccess database) you will be able to 
automatically copy all tables to a new project (mysql/postgresql/sqlite database).

> the other solution I guess would be for me to know exactly what operation I
> need to do to made my tables "kexi aware" I'm thinking adding the required
> rows in the system table myself. would that be a solution ? where could I
> get more info about that ?

Some people did that. THis is of course not a preferred way of importing data 
but it can be efficient because you can thus avoid data copying. Look at 
"system" Kexi tables in (with "kexi__" name prefix) saved in databases created 
with Kexi.
Knowledge about schema of these tables is documented in: 
http://websvn.kde.org/*checkout*/trunk/koffice/kexi/doc/dev/kexidb_issues.txt

You will need to alter kexi__objects and kexi__fields. That's all.
Sorry for incovenience; in the future this task you want to do by hand will be 
handled automatically. I guess it's not for 1.0 though due to time constraints.
See also:
http://www.kexi-project.org/wiki/wikiview/index.php?KexiFAQ#4._Project_&_Data_Migration

-- 
regards / pozdrawiam,
  Jaroslaw Staniek / OpenOffice Polska
  Kexi Developer:
      http://www.kexi-project.org | http://koffice.org/kexi
  KDE3, KDE4 libraries for developing MS Windows applications:
      http://wiki.kde.org/tiki-index.php?page=KDElibs+for+win32