[Kexi] Importing databases ...

[Sebastian Sauer]

Hi David,

On Sunday 17 September 2006 06:55, David Love wrote:
> Firstly, thank you to Jaroslaw Stanick and Sebastian Sauer for their
> response to my original plea for assistance.  It is much appreciated.
>
> However, because of my absolute ignorance of how to do things in Linux
> I'm still a "very frustrated" geriatric :-)
>
> I downloaded 35251-copyCentre, as suggested.  Extracted it and then
> got lost.  I *thought* it would automatically be extracted to root but
> it wasn't but appears in my user account.  Taking a gamble, I opened
> Kexi and went to import (hoping that copyCentre would be active) only
> to find that it wasn't an import option.
>
> I am *completely and utterly* lost.  So can someone please advise me
> how to get this to work.  As I have stated, I am lost with Linux, so
> would appreciate advice in the form of:
>
> (a) Do this
> (b) and the do this
> (c) which installs 35251-copy Centre

1. Click on Tools=>Scripts Manager (located in the Tools-Menu which is 
displayed at the Mainmenu - the mainmenu is those File,Edit,...,Tools,Help 
menu at the top of the Kexi-dialog) on those Button at the buttom that 
displays a yellow star. Then the "HotNewStuff"-dialog shows up, where you are 
able to install the script-packages. Just choose there install and voila, the 
script-package is installed. If you don't like to do that via "HotNewStuff" 
rather then direct with the package you downloaded, please go to the same 
Tools=>Scripts Manager dialog and just choose there "Install", then select 
the package and install the package that way.

I guess that shows, that it's not that wise, that there are multiple 
import/install sections around in Kexi (for CSV, TSB, for Kexi-project files, 
for script-packages, ...).

> You should then
>
> (d) Open Kexi and
> (e) Do this
> (f) and This
> (g) and the database should be imported successfully

2. Then once the script is installed, go to Tools=>Scripts and click there on 
the "Copy Center" menuitem. Cause the CopyCenter-script uses PyQt, you may 
need to install PyQt before to use the script (if that's the case you will 
get an errordialog on the try to execute the script). To install PyQt;

3. depending on your distribution you need to;
debian; "apt-get install pyqt"
SuSE; install PyQt via YaST
gentoo; emerge pyqt
RedHat; ... /me don't know cause I never used RedHat
...

btw, since it doesn't sound as you are already using a Kexi-project: did you 
try to import the data with the in Kexi nativly included CSV/TSV-import?
1. File=>New (to create a new project first)
2. File=>Import=>Table Data From File (to import the actual csv-file into a 
Kexi table).

-- 
Sebastian Sauer aka dipesh[sebsauer]
http://www.dipe.org/public_key.asc
Fingerprint: 8F1E 219B 16E6 4EC7 29CC F408 E193 65E2 9134 2221
Coder in http://www.koffice.org && http://www.kmldonkey.org