Re: Importing inventory via CSV

[Bill Appelbe <..hidden..>]

Hi

if you look at the parts table first, note the *accno_id fields.

You also may need the makemodel, partstax, partscustomer and partsvendor tables, depending on your usage.

Set up your CSV files to look like the tables you want to populate.

There are several ways of doing this, you could use the Linux application pgAdminIII to copy and paste in the data. (right click on the table and select import)

You could use SQL to import - someting like:
>copy parts from '~/tableFile.csv' using DELIMITERS ',';

Or you could set up a perl script to do the same.

Bill

On Thu, Jan 1, 2015 at 8: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

------------------------------------------------------------------------------
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