Importing customers, vendors and products

[Jonas Lippuner]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Robert,

I wrote a little program in C# with Mono that reads customers with
addresses from a CSV and adds them to GnuCash using the Python
bindings. Since I use the Python bindings, this currently only works
under Linux.

The program is fairly crude and has no user interface (everything is
controlled in the source code), but it got the job done for me (I had
to import a bunch of customers from a CSV file as a one-time task).

I'd be happy to share my code if anybody is interested, but be warned
that you need to be familiar with C# in order to be able to use it and
you need to get the Python bindings working...


Best,
Jonas


- -------- Original Message  --------
Subject: Re: Importing customers, vendors and products
From: Robert Smits <bob at rsmits.ca>
To: gnucash-user at gnucash.org
Date: Fri 21 Jun 2013 05:42:45 PM PDT

> On April 4, 2013 09:33:11 am Derek Atkins wrote:
>> Hi,
>> 
>> ecomin <ian at alnaturalhealth.com> writes:
>>> I am trying GNU Cash 2.4.12 on windows XP. I have imported my
>>> accounts files from Quick books via QIF>CSV. I now want to
>>> import all my customers, vendors, and products. The only thing
>>> I can find is how to do it on Linix.
>>> 
>>> Any help gratefully accepted.
>> 
>> First, GnuCash does not have Inventory support, so you couldn't
>> import "products".  Second, unfortunately there isn't an importer
>> for customer or vendors at this time.  There are some Python
>> scripts that may help with that, but we don't build the Python
>> bindings on Windows because, frankly, 99% (or more) of Windows
>> Users would never need or use them.
>> 
>> Sorry,
> 
> Is there some way to import customers? From a spreadsheet would be
> ideal...
> 

- -- 
My email is signed and I encrypt email on request.
To verify my signature or send me encrypted email,
get my public key: http://lippuner.ca/key
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQIcBAEBAgAGBQJRxPd2AAoJELH92qHy0gntIJsQAKq7+VjN+PLqaSGJs734yev4
O01rW2PT26e+n1OmZ8jPjIIHXJ6HcoqmSCqddRQviX1V0/OKQFiqj3inz1xA4bWW
BP2wg1nlYYUq3KmETaw6WNzgE9CRTEmufTuv/z0e/kSxJdXDAFItxQphqP/ekORo
FWSGhnvu0G5W+tsSQRmTx9QykRQnpLwlH6KrjMGLkvVrMkMnELsCR6v9aNOmjsZ9
iK+ltwnqVkFVyi3bbA6v8i9Gi0AaqjbCW/m1pj5iuAbxPptP8ZkuJxN2aSsUOHcH
D6wJKkhfv6hznJaualydQXJWyDOjwUdNRm1Lj5ILX7os2oCSwMQxshvVBBAUpEmN
zwKVq7xWBxFCo1pWnkwajndbZYV373wbty9jYBGPQq/KwYgeYRja0nYdBvdrrD+9
q4R/0qJwtWkYBt4cZH2ljANvz2DAHl0TBaajE34DG4B6K1veuPP4BxCjgaawjRpD
rgexM4f/a8BAv3XYKQL3HtaLwPyfZ+Fd91oKdyU/w6YTJgLMZYJvjJgUC+PzIxAq
x7bQYkmTxwf0zhG1bHe6ulg9Xfjh0SjCJhZCSVkRV8xqedvop0F5LTw04j/k3Oql
a14VircWFHLTfbYzit0tx24dqJ0M5wATYU8pYF8XAdKTgXesmu52n0fwUcuTBPvt
VzTBQwCHti5KVu7ZbznJ
=qfIM
-----END PGP SIGNATURE-----