[SL] Re: Bulk load of parts
- From: "Roy W. Pennington" <archdist@xxxxxxx>
- To: sql-ledger-users@xxxxxxxxxxxxxx
- Date: Thu, 15 May 2003 13:57:36 +0000
Here's a link to a post made by Bill Faust.
//www.freelists.org/archives/sql-ledger-users/01-2003/msg00300.html
It includes a perl script for importing parts.
Dieter also a Quickbooks import script on the SL web site
(I made my own scripts based on the ideas in these. I can post those if you
want to take a look)
Cheers,
Roy
On May 15, 2003 03:43 pm, you wrote:
> No, I don't think so. I presume the sequence should fill this out
> automatically anyway. I haven't tested this though, when I imported my
> data I decided to use a perl script that parsed the text file used
> some regexp and did the inserts using DBI.
>
>
> >
> > I'm in the middle of this right now myself but haven't
> > gone online to see if I have the sequence problem
> >
> > I'm using pgadminII to load a few thousand parts
> > dumped from Informix - customers & vendors next
> >
> > my csv format is:
> >
> > part #, description, unit, cost , acct1, acct2, acct3
> >
> > it looks like pgadmin will fill in any fields
> > automatically - would I need to include the ID column
> > in my csv?
> >
> > --- Alejandro Imass <ait@xxxxxxxxx> wrote:
> > >
> > >
> > >
> > > Hmmm. Your imput is quite valuable for our friend
> > > but there is a small
> > > mistake.
> > >
> > > If you take a look at the sequence it's just on for
> > > all of SL. If you
> > > look at the column definition you will see that is
> > > auto. Include the
> > > id column in the insert and leave the valur null and
> > > it will be filled
> > > for you automagically.
> > >
> > >
> > >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > The New Yahoo! Search - Faster. Easier. Bingo.
> > http://search.yahoo.com
> >
> >
> >
>
> --
> Alejandro Imass
>
>
--
Roy W. Pennington
Arch Distributors of Canada
Other related posts:
