After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 760630 - Apply improvements in invoice import to Customer importer.
Apply improvements in invoice import to Customer importer.
Status: RESOLVED OBSOLETE
Product: GnuCash
Classification: Other
Component: Import - CSV
git-maint
Other All
: Normal minor
: ---
Assigned To: Mike Evans
gnucash-import-maint
Depends on:
Blocks:
 
 
Reported: 2016-01-14 16:16 UTC by Mike Evans
Modified: 2018-06-29 23:46 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Mike Evans 2016-01-14 16:16:06 UTC 
Apply the changes in Bug 756469 and Bug 760617 to the customer-vendor importer.
Comment 1 Mike Evans 2016-09-20 13:17:53 UTC 
Add Bug 756416 and bug 759674 to the list.
Comment 2 Uttam 2016-09-22 12:12:30 UTC 
Dear Mike,

Thank you for your note.  Here is the information.  I beg caution as I am new to all this.

Sage outputs 5 address fields and puts the telephone number in front etc. I modified it in LibreCalc as:

ID / Company Name / Contact/ Address 1 - 4 / Tel No

"CompanyA","Special Client","","Upper Creek Avenue","Dover","Kent","ZZ1 9XX",""
"CompanyB","New Prospect 1",""Old Grain Store","The Farm","Kent","ZZ1 9YY","07888 789012"

Line one is imported and the second is rejected.  I do not know if Sage does not supply the null value, or if importing it into LibreOffice to reorganise the columns of data strips them out.

If the code is easy to fix, then well and good,  If not, as this is a one-off process, I suggest that a small note in the documentation will suffice.  Perhaps something suggesting the csv file is opened in a text editor in order to check a null value appears at the end of each entry, assuming of course what I am saying is correct!

As a newbie I merely offer this suggestion by way of thanks for the good stuff you all are doing.

Best regards, Uttam
Comment 3 John Ralls 2018-06-29 23:46:25 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=760630. Please continue processing the bug there and please update any external references or bookmarks.