Invoice Importer

[Mike Evans]

On Monday June 7 2010 17:17:10 Mike Evans wrote:
> On Sunday June 6 2010 22:40:17 Sebastian Held wrote:
> > Am Sonntag, 6. Juni 2010, 10:26:38 schrieb Mike Evans:
> > > On Saturday June 5 2010 22:29:19 Derek Atkins wrote:
> > > > Munroe Sollog <sollog at digiraticonsulting.com> writes:
> > > > > I would like to see what kind of interest there is for an invoice
> > > > > importer.  I see it on the Wish List page, but I don't see any
> > > > > discussion about it.  We use a web based invoicing system and would
> > > > > love to be able to import/dump invoices into GnuCash.  This would
> > > > > save a lot of time for the bookkeeper.  If our situation is
> > > > > uncommon then I fully understand this feature being
> > > > > ignored/postponed/niced. If we are not alone, what have other
> > > > > people done to solve this inconvenience?  We are currently
> > > > > entering the invoices in twice (once to GnuCash and once to our
> > > > > invoicing system).
> > > > 
> > > > I'd certainly be interested in seeing something that would pull in
> > > > items out of gnotime (Gnome Time Tracker) and build an invoice out of
> > > > it.  So yes, something to import invoices would be nice.
> > > > 
> > > > -derek
> > > 
> > > I track my clients billable time using a mysql based application and
> > > was hoping do this using the Python interface, so far though I've been
> > > unable to figure out how to get the python gnucash_business functions
> > > working.
> > 
> > I did some work on this topic already:
> > http://tellico.dyndns.org/drupal/node/1
> > 
> > I'm not sure, if the patch applies to the current development version.
> > But it may serve as a start point... I've no time to finish the patch.
> > 
> > best regards,
> > Sebastian
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > 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.
> 
> Sebastian
> 
> I have your patch compiling and running but I need to test the import, do
> have a test.csv for invoices, or an example of the format it expects?
> 
I now have it creating invoices and importing a limited number of columns but 
I have two queries.  What would be a suggested csv format that's likely to be 
compatible with sales software.  From a coding aspect I need to attach a new  
invoice to customer and I'm not sure how to do this yet, It's probably obvious 
but any clues are welcome.

Mike E


-- 
GPG Key: 1024D/050895C2
Keyserver: http://pgp.mit.edu/          
Search String: 0x050895C2