On Tue, Oct 9, 2012 at 8:54 AM, Bill Appelbe <[email protected]> wrote:
> Hi
> 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?
Easiest way to do this is to create a temp table matching your csv format,
populate, and then select into parts and possibly makemodel, partsvendor,
partstax, and partscustomer.
Take a look at these tables first, but the main fields of parts to pay
attention to are the *accno_id fields.
For a stock item, you should make sure that income_accno_id,
inventory_accno_id, and expense_accno_id are all properly populated. The
rest is probably relatively self-explanatory, but if you have questions
feel free to ask.
Best Wishes,
Chris Travers
------------------------------------------------------------------------------
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!
http://p.sf.net/sfu/newrelic-dev2dev
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
