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

Re: Importing inventory via CSV

Hi Louis,


The only documentation available for the uploads is the code, I think. (I should make a write-up about the uploads in the FAQ or some other place, now that you mention it..)

Looking at [1], I found that the upload has 3 columns: part number, on-hand and the purchase price. Each uploaded file contains only a single date, if you use this format. If you have a large number of lots to upload, on different days, I would suggest to use the inventory_multi format, which has a leading 'date' column. This column contains the date for the transaction to be created.


The file should always have a single header row which contains the column headers. This row is being ignored.



Regards,


Erik.




[1]: https://github.com/ehuelsmann/LedgerSMB/blob/master/LedgerSMB/Scripts/import_csv.pm#L30

On Thu, Jan 1, 2015 at 9:45 PM, Louis <..hidden..> wrote:

Hey All,

Is the format for the inventory import csv documented somewhere? I've been
poking about for it but haven't stumbled upon it.


Louis

------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



--
Bye,

Erik.

http://efficito.com -- Hosted accounting and ERP.
Robust and Flexible. No vendor lock-in.
------------------------------------------------------------------------------
Dive into the World of Parallel Programming! The Go Parallel Website,
sponsored by Intel and developed in partnership with Slashdot Media, is your
hub for all things parallel software development, from weekly thought
leadership blogs to news, videos, case studies, tutorials and more. Take a
look and join the conversation now. http://goparallel.sourceforge.net
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users