Importing customers, vendors and products

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Importing customers, vendors and products

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

Reply | Threaded
Open this post in threaded view
|

Re: Importing customers, vendors and products

Derek Atkins
Hi,

ecomin <[hidden email]> 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,

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

--
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available
_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: Importing customers, vendors and products

Robert Smits
On April 4, 2013 09:33:11 am Derek Atkins wrote:

> Hi,
>
> ecomin <[hidden email]> 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...

--
Bob Smits <[hidden email]>
"Microsoft is not the answer. Microsoft is the question. NO is the
answer."   - Erik Naggum

_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
Reply | Threaded
Open this post in threaded view
|

Re: 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 <[hidden email]>
To: [hidden email]
Date: Fri 21 Jun 2013 05:42:45 PM PDT

> On April 4, 2013 09:33:11 am Derek Atkins wrote:
>> Hi,
>>
>> ecomin <[hidden email]> 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-----
_______________________________________________
gnucash-user mailing list
[hidden email]
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.