Unable to import csv-file from splitwise in NC 27

[Matsched]

NC Version: 27.0
Cospend Version 1.5.10

If i try to import a exported .csv-File from SplitWise i get:
Fehler beim Importieren der Projektdatei: Malformed CSV, impossible to find the column names
(Error while importing the project data)

This is the format from splitwise:

Datum,Beschreibung,Kategorie,Kosten,Währung,Name1,Name2
2023-06-22,Lebensmitteleinkauf REWE,Lebensmittel,2,EUR,-1,1

How i can change it to import it correctly to Cospend?
Can you fix this?

kind regards

[k-jell]

Maybe have a look here:
https://gitlab.com/eneiluj/cospend-nc/-/merge_requests/152

It only works if Splitwise account language is set to English (column names are localized)

Not sure if this is still the case, but it seems like it was, when the feature was implemented.

Edit:
It is: #159 (comment)

[Jolg42]

It happened to me too, my account was set to French, so I switched it to English.

The language can be changed here
https://secure.splitwise.com/account/settings

[Jolg42]

The code is here after a quick search

cospend-nc/lib/Service/ProjectService.php

Line 5178 in ebfd417

public function importSWProject(string $path, string $userId): array {

Especially these lines are assuming the columns are in English

cospend-nc/lib/Service/ProjectService.php

Lines 5201 to 5205 in ebfd417

	if (!array_key_exists('Date', $columns)
	|| !array_key_exists('Description', $columns)
	|| !array_key_exists('Category', $columns)
	|| !array_key_exists('Cost', $columns)
	|| !array_key_exists('Currency', $columns)

cospend-nc/lib/Service/ProjectService.php

Line 5250 in ebfd417

if (array_key_exists('Category', $columns)

cospend-nc/lib/Service/ProjectService.php

Line 5250 in ebfd417

if (array_key_exists('Category', $columns)

[Jolg42]

I created a small PR to improve the error message #238