[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: entering a large number of parts

On 09/10/12 16:54, Bill Appelbe wrote:
I am wondering if there is a way to enter a large number (several thousand) of stock items (parts)
I can get the stock list in a csv format, what fields in the database would I need to populate if I was to do it directly?
Or is there another smarter way?


Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!

Ledger-smb-users mailing list
You can load CVS files using pdadmin, pgpadmin or other such tools directly into Postgres. I don't know if the user guide has been updated, but there was enough info in there to work out the fields and their order. I wrote a C program to put the CSV columns in the right order with blanks or default values where required, but I suppose a spreadsheet could be used. Test it on a dummy dbase though!