Importing Customers and Vendors from Sage Line 50

[Mike Evans]

On Tue, 20 Sep 2016 13:48:56 +0200
Uttam Chakravorty <uttam at uc4linux.co.uk> wrote:

> Dear Wm,
> 
> Thank you for the work you all are doing.  I found exporting the csv from Sage, reordering the data and importing it into Gnucash could be better.
> 
> I have fixed my problem and what I did I hope may help others.  It was hard to struggle past the discouraged stage and as I didn't know where the problem lay, I could not ask for help.
> 
> I suggest the issue is in how GnuCash's import tool parses the csv.  It works when there is a blank after the last entry.  I think I may be experiencing this issue because I am using very short entries that do not fill in all the options.
> 
> Perhaps this could be addressed in the code that imports the csv.  Whether it can or not is beyond me and therefore merely a suggestion.
> 
> Could you confirm if I am using this mailing list properly?
> 
> Best regards, Uttam

I have a bug open for general improvements to the customer/vendor importer, https://bugzilla.gnome.org/show_bug.cgi?id=760630 It may be useful to add your comments there. Also if you can add a sample failing import file, just a couple of lines will suffice, change the details to protect the innocent of course, that would be useful.  The importer was never intended to be compatible with sage (or other) output (perhaps it should be) and I've no access to Sage or a Windows computer to produce test output/input.

I've no idea when I ll get round to looking at the issue though, could be months or years.

Good to know you succeeded in the end though.

Don't forget to only reply to the list or use the bug report.

Mike Evans

-- 
PGP key:
http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xDB8F7CF1C67BBC0F