sql-ledger-users

[SL] CSV files and importing

[Jeff R. <Jef...@te...>]

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 Roberts
JR Electronics

Re: [SL] CSV files and importing

[Jerome J. A. <jer...@bo...>]

Hi Jeff,

Some time ago, I had to deal with .DBF files and I used the Perl modules 
in this link:  http://search.cpan.org/search?query=DBF&mode=all

There are more than one option so just try which one fits your need.  
You might have to write a short script to do this.

jerome

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 Roberts
>JR Electronics
>
>-------------------------------------------------------------------------
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel and you'll get the chance to share your
>opinions on IT & business topics through brief surveys - and earn cash
>http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>_______________________________________________
>sql-ledger-users mailing list
>sql...@li...
>https://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>
>  
>

Re: [SL] CSV files and importing

[Dr E. L. <el...@li...>]

http://dbf.berlios.de has/had a nice little program that translates DBF
files into PostgreSQL tables directly. One could then do a SELECT INTO
perhaps?

el


on 1/4/07 7:07 PM Jerome J. Auza said the following:
> Hi Jeff,
> 
> Some time ago, I had to deal with .DBF files and I used the Perl modules 
> in this link:  http://search.cpan.org/search?query=DBF&mode=all
> 
> There are more than one option so just try which one fits your need.  
> You might have to write a short script to do this.
> 
> jerome
> 
> 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?

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

Re: [SL] CSV files and importing

[Dirk E. S. <ds...@ca...>]

> 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 give=
s
> 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?


You can convert with OpenOffice from dbf to csv and import with=20
phppgadmin: http://phppgadmin.sourceforge.net/ - Worked for me.

--=20
Dirk Enrique Seiffert - Lintec S.A.
Ed. Torre del Reloj - Of. 401
Plaza de los Coches, Centro
Cartagena - Colombia
http://www.lintecsa.com