> Erik wrote:
> Please find attached a replacement 'import_csv.pm' to be placed
> in lib/LedgerSMB/Scripts/.
Nice!!
In looking at the file, I see that "goods" has this listed after it.
[ qw/ partnumber description unit listprice sellprice lastcost
weight notes makemodel assembly alternate rop inventory_accno
income_accno expense_accno returns_accno bin bom image drawing
microfiche partsgroup avgcost taxaccnos / ]
I'm suspecting the "qw" is not part of the field list - correct?
So my CSV should have a header row, then on row 2 have "partnumber", then "description", etc on up to "taxaccnos"
Then, it appears I will also have to use the "inventory" script to
get "onhand" and "purchase_price" imported, correct?
What's a good way to figure out the values for "inventory_accno",
"income_accno", "expense_accno", and "taxaccnos"? By looking at
the "parts" table psql I see the first 3 - but I'm not sure about
"taxaccnos". Where do I find that?
> I've tested the script by uploading an "overhead" on 1.6.17. The
> version difference should matter little, because the import file
> hasn't seen much churn over the 1.6.x release cycle.
>
> There's no menu option, but here's how to upload goods (=parts
> that are not services and not overhead):
[snip]
The instructions look manageable. I don't have time to test it
tonight, but hope to give it a trial run really soon!
This is wonderful - thanks!
-- f
