Re: [SL] CSV files and importing

[Gerardo R. <gre...@ti...>]

On Wednesday 03 January 2007 11:29, Jeff Roberts wrote:
> Hello People
>
> My name is Jeff and I've been playing with SQL-Ledger for a few years
> but have decided this year I'd get it fully running in my business
> (electronic repair). I've got it installed on a server running BSD 5.3
> with PgSql 7.4.5 and Apache 2.0, everything seems to be running OK and
> I've already entered all of my GL accounts in.
>
> My next step is to import my customers, vendors and inventory
> items(services).
>
> I downloaded the import script but it says that I must have my data in
> tab delineated fixed length format and I'm having trouble finding a
> program that will save in fixed length format. My current data is in
> .DBF format and I've tried Paradox and Star Office 6.0 but neither gives
> an option to save in a fixed length. My workstation computers are Linux
> so a solution from EMS is out of the question, any suggestions?

Jeff,

Hello.

You could use dbview to deal with dbf files. I have used it to read xbase 
files and it does a good work converting to csv format.

Personally I do not use BSD, but I can you could take a look to this link to a 
[http://www.freshports.org/databases/dbview/].

Good luck.

Gerardo Reynoso