[prl]

Hello,

I'm a new user, trying things out as it were... I'd like to import a couple of DBF files and manipulate them via rekall.

I can't figure out ho to do this. From googling, it seems I need to use "Copier." Any hints?

Thanks,
Phil

[ajh]

I'm not convinced that you can import DBF files directly. Can you write them as delimited or fixed length text files? If so, use the Copier. Choose File as your from and the table you want to import to as your To

[ajh]

OK - my previous answer should get an award for the dumbest answer of the year. Of course Rekall support DBF, that's the native file format for the XBSQL interface!!!

Best way to use the file is to do the following:
- Put the DBF files into a directory somewhere
- Go into Rekall and create a new database in that directory (will create the RKL file), just hit Finish on the Wizard
- Once created, Create a new Server, name it whatever, type should be XBASE/XBSQL
- You should then find your DBF file are listed in the Tables list

Enjoy!!

[prl]

Not working yet... What am I missing? I did this:

1. mkdir ~/rekall
2. copy two .DBF files into ~/rekall
3. start rekall
4. click new database icon
- Database Connection Wizard appears
5. click Finish
- i.e. didn't use wizard
- Create Database Filesystem navigator window opens
6. Navigate to ~/rekall in the Create Database Filesystem window
7. Enter "foo" in Location field
8. Click Save button
- dialog windows are now all gone
- I've been returned to Rekall main window
- foo database is open
9. Left click on "Servers" in Objects list
- Word "Servers" highlights
10. click "New" button
- Focus moves to Server Settings' "Server" field
- Server field defaults to highlighted string ""
11. I replace highlighted string with "bar"
12. I hit TAB key
- focus moves to Type dropdown Box
13. I choose "Rekall XBase/XBSQL Driver"
14. I hit TAB key
- focus skips to "Show" checkbox (next to "Password" field)
15. Passwords are not applicable for my application, so I hit TAB key again
- focus skips to "Disabled" ckeckbox
16. I hit TAB key
- focus skips to "Auto Start" checkbox
17. I hit TAB key
- focus skips to "Advanced" button
18. I ignore "Advanced" button and hit TAB key again
- focus skips to "Save" button
19. I hit ENTER key
- dialog appears
* title "Create Ob#ject table - Rekall"
* text: "Database on server bar lacks a object table: create one?"
* "Yes" button is highlighted
20. I hit ENTER key
- dialog dosappears
- control is returned to main Rekall window
- "Server" Object remains highlighted
- "bar" has appeared under "!Files"
21. I left click "Tables" Object
- detail view switches
* fields: Server/Table/Field; Type; Size; Info
- there are three nodes/records displayed:
* ""
* "!Files"
* bar
22. I left click "+" next to the node with empty string for a name
- dialog appears
* title: Error
* text: Server "" not known
* "OK" button is highlighted
23. I hit ENTER key
- control is returned to main Rekall window
- "+" next to empty string node is now a "-"
24. I left click "+" next to the node with name "!Files"
- "+" turns into a "-"
25. I left click "+" next to the node with name "bar"
- "+" turns into a "-"
- three sub-nodes appear
* "Create new table"
* FAMILY
- Type: Table
- "+" prepends sub-node
* MEMBER
- Type: Table
- "+" prepends sub-node
26. I left click "+" next to FAMILY
- dialog appears
* title: Error
* text: Unable to get list of fields in table
* "OK" button is highlighted
* "Show Details >>" button also exists
27. I click "Show Details >>" button
- Detail text: Error opening file

After quitting the program, here is a directory listing with permissions, etc.:
$ ls -l ~/rekall
total 3928
-rw-r--r-- 1 me users 1112237 Sep 2 11:16 FAMILY.DBF
-rw-r--r-- 1 me users 2886307 Sep 2 11:16 MEMBER.DBF
-rw-r--r-- 1 me users 257 Sep 2 11:17 __RekallObjects.dbf
-rw-r--r-- 1 me users 512 Sep 2 11:17 __RekallObjects.dbt
-rw-r--r-- 1 me users 827 Sep 2 11:17 foo.rkl
-rw-r--r-- 1 me users 416 Sep 2 11:17 foo.rkl~

[ajh]

Hmm...have to say that I tried it on the Windows version. It's not something as simple as being case sensitive on Linux is it? I noticed that the Rekall created tables are .dbf files whereas your tables are .DBF

[prl]

Yikes, that was it! Thank you!

Well, I'm glad we uncovered that little bug. I'm off to try using Rekall, now!

Phil

[ajh]

Just tried it on Linux and it worked the same - but the file does need to have a lower case extension