[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Florian Lindner]

https://bugs.kde.org/show_bug.cgi?id=392165

Florian Lindner  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 Resolution|--- |INVALID

--- Comment #7 from Florian Lindner  ---
You are right, should have tried first.

Also, the csvimorterrc says:

MemoCol=13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30

Still, it's very confusing, because there no user feedback for multiple
selection.


I set this ticked to RESOLVED / INVALID. I also created a new bug report for
the missing feedback in the UI: https://bugs.kde.org/show_bug.cgi?id=392217

Thanks for your help!

-- 
You are receiving this mail because:
You are watching all bug changes.

[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Jack]

https://bugs.kde.org/show_bug.cgi?id=392165

--- Comment #6 from Jack  ---
Did you actually try, and finish the import?  It does work.

Once you click the dropdown and select a column number, that number is added to
the label on that dropdown.  The memo dropdown seems to be different (I don't
know if it's a regression - I'll have to test more, and possibly open a
separate bug if necessary) it seems only to show the last column selected, but
it does remember them all.  You do need to be careful that if you want any
field in the memo that is also needed for another field, be sure to select it
for the other field first, or else the program will make you select for both
fields again, as meme is the only case where a column can be used in more than
one field.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Florian Lindner]

https://bugs.kde.org/show_bug.cgi?id=392165

--- Comment #5 from Florian Lindner  ---
>> 1) are there three notes columns in every line in the file?  If so, good, 
>> and read on.  If not, then the different lines are of different lengths, and 
>> you would need to pre-process, in which case you could just combine them 
>> before importing. <<

It's a fixed number of cols for the notes field, yes.

>> 2) I am not able to test this myself now, but have you read the manual 
>> section:
https://docs.kde.org/stable4/en/extragear-office/kmymoney/details.impexp.csv.html#idm46317016032928
which does say you can select more than one column for the memo field?  Does it
not work, or did you just not try it yet? <<

Hadn't read it, I must admit. It says:

"It is possible to select more than one column for the Memo field, by
consecutive selections. Memo columns already selected are marked in the
drop-down with an asterisk (*). If you select multiple columns in this way,
their contents will be concatenated in the Memo field."

However, I see no way to select multiple cols. There is a dropdown field with
numbers 1 to N (N is number of cols). When I make consecutive selections, I see
no asterisk mark there, or anything else that marks the previous selection. I
can also mark the cols in the field, but there is no way to actually select
them as import source for a field. Using Ctrl key on the dropdown field also
does not help to make multiple selections.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Jack]

https://bugs.kde.org/show_bug.cgi?id=392165

--- Comment #4 from Jack  ---
Two questions:
1) are there three notes columns in every line in the file?  If so, good, and
read on.  If not, then the different lines are of different lengths, and you
would need to pre-process, in which case you could just combine them before
importing.
2) I am not able to test this myself now, but have you read the manual section:
https://docs.kde.org/stable4/en/extragear-office/kmymoney/details.impexp.csv.html#idm46317016032928
which does say you can select more than one column for the memo field?  Does it
not work, or did you just not try it yet?

-- 
You are receiving this mail because:
You are watching all bug changes.

[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Florian Lindner]

https://bugs.kde.org/show_bug.cgi?id=392165

--- Comment #3 from Florian Lindner  ---
EDIT:

A multi-line notes field of a transaction is split to multiple colums, one for
each line in the NOTES field. I want KMM to join all Notes-columns into the
Notes field of a KMM transaction record.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Florian Lindner]

https://bugs.kde.org/show_bug.cgi?id=392165

--- Comment #2 from Florian Lindner  ---
12345;Payer;1.000,00;Notes Field Line 1;Notes Field Line 2;Notes Field Line 3

this represents one transaction and is a single line, without any line breaks.
As you wrote, each line represents a single transaction.

A multi-line notes field of a transaction is split to multiple colums, one for
each line in the CSV field. I want KMM to join all Notes-columns into the Notes
field of a KMM transaction record.

To put with python, csv represents a list of cols of a single line from a CSV
file. The Notes colums are cls 3 to 5.

kmm_notes = "\n".join(csv[3:5])

You said, that KMM is capable of doing that. I just walked through the import
wizard again, but found no way to accomplish that.

Thanks!

-- 
You are receiving this mail because:
You are watching all bug changes.

[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Jack]

https://bugs.kde.org/show_bug.cgi?id=392165

--- Comment #1 from Jack  ---
Please clarify the example.  It is not clear which separators are literal and
which are intended to indicate line feeds.  The CSV importer IS capable of
combining columns into the memo field, but you are correct, each line in the
csv file is considered a separate transaction.  I do think it should be able to
handle line feeds within a single text field, as long as the whole column is
enclosed in quotes, but I have not tested that myself.

-- 
You are receiving this mail because:
You are watching all bug changes.

[kmymoney] [Bug 392165] Join multiple cells in one field when importing CSV

[Florian Lindner]

https://bugs.kde.org/show_bug.cgi?id=392165

Florian Lindner  changed:

   What|Removed |Added

 CC||florian.lind...@xgm.de

-- 
You are receiving this mail because:
You are watching all bug changes.