Bug 502573

Summary:	Woob import
Product:	[Applications] skrooge	Reporter:	forum <forum>
Component:	general	Assignee:	Stephane MANKOWSKI <stephane>
Status:	RESOLVED FIXED
Severity:	normal
Priority:	NOR
Version First Reported In:	25.1.0
Target Milestone:	25.1.0
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:
Sentry Crash Report:

Description forum@guicar.fr 2025-04-08 17:21:53 UTC

Dear Stephane,
Ir was quite mandatory for me to upgrade from woob bank 3.5 to 3.7 as Fortuneo made a large modification to there web site .
I 'm using Skrooge version 2.28 on Ubuntu 20.04.2 (focal)

When i tried to import I have the following message
 [ERR-8]: Nombre de colonnes non valable en ligne 2. Attendu 7. Trouvé 6.

Like in my previous try sometime ago https://bugs.kde.org/show_bug.cgi?id=487729 but not with 3.7
You told me 2.33 will solve but i didn't find this version neither a new Skrooge version for my Ubuntu version.

So i installed version 25.1 thru flatpak but got (despite my preference is classical .deb install)

[ERR-5]: The following command line failed with code 1:
'/app/share/skrooge/skrooge-woob.py  --woob_option "" --filter "" --output "/tmp/skrooge-pFnKZP/skrooge_backend.csv"'

using import command is woob(,2025-02-01);woob_coming(,2025-02-01) inside skrooge parameters

Any help will be appreciated.

Regards,
JPierre

Comment 1 Stephane MANKOWSKI 2025-04-08 18:25:29 UTC

Hi,

You can try this:
- Search org.kde.skrooge-import-backend-woob.desktop in you system 
- Replace the line:
X-SKROOGE-csvcolumns=date2|date1|mode|comment|payee|amount
by
X-SKROOGE-csvcolumns=|date2|date1|mode|comment|payee|amount

Regards

Comment 2 forum@guicar.fr 2025-04-08 18:50:27 UTC

Thank you for your quick input. I have made the change but i still have the issue.
Regards

Comment 3 forum@guicar.fr 2025-04-09 16:21:25 UTC

Hi,
I have installed skrooge 2.30 using snap but i got this error
 PYTHONIOENCODING=utf_8 woob bank ls  -q -f csv -s id,label,balance 2>/dev/null |grep -v "If --auto-update" | grep -E "id;label;balance|"
If I launch the command in a terminal it's work. So the application seems not able to access to my local directories like /home/jpm/.local/bin/woob
may be because Skrooge snap environment is closed and "path" is not available.
Regards,

Comment 4 Stephane MANKOWSKI 2025-04-09 19:18:10 UTC

(In reply to forum@guicar.fr from comment #2)
> Thank you for your quick input. I have made the change but i still have the
> issue.
> Regards

This should work. Are you sure you modified the version installed ? You must have done it as root.

Comment 5 Stephane MANKOWSKI 2025-04-09 19:24:32 UTC

(In reply to forum@guicar.fr from comment #3)
> Hi,
> I have installed skrooge 2.30 using snap but i got this error
>  PYTHONIOENCODING=utf_8 woob bank ls  -q -f csv -s id,label,balance
> 2>/dev/null |grep -v "If --auto-update" | grep -E "id;label;balance|"
> If I launch the command in a terminal it's work. So the application seems
> not able to access to my local directories like /home/jpm/.local/bin/woob
> may be because Skrooge snap environment is closed and "path" is not
> available.
> Regards,

This is not an issue of Skrooge but an issue of the snap packaging. To be honest, I don't know very well snap and don't know how to fix that.

Comment 6 forum@guicar.fr 2025-04-09 20:35:00 UTC

(In reply to Stephane MANKOWSKI from comment #4)
> (In reply to forum@guicar.fr from comment #2)
> > Thank you for your quick input. I have made the change but i still have the
> > issue.
> > Regards
> 
> This should work. Are you sure you modified the version installed ? You must
> have done it as root.

So here are commands and results:
sudo updatedb
sudo locate org.kde.skrooge-import-backend-woob.desktop
/usr/share/kservices5/org.kde.skrooge-import-backend-woob.desktop
/var/lib/flatpak/app/org.kde.skrooge/x86_64/master/20579d72dec472682d77ba903881c623811a80678ecc52da2c6168ec6e1fc18c/files/share/kservices5/org.kde.skrooge-import-backend-woob.desktop

cat /usr/share/kservices5/org.kde.skrooge-import-backend-woob.desktop | grep "X-SKROOGE-csvcolumns"
X-SKROOGE-csvcolumns=|date2|date1|mode|comment|payee|amount

cat /var/lib/flatpak/app/org.kde.skrooge/x86_64/master/20579d72dec472682d77ba903881c623811a80678ecc52da2c6168ec6e1fc18c/files/share/kservices5/org.kde.skrooge-import-backend-woob.desktop | grep "X-SKROOGE-csvcolumns"
X-SKROOGE-csvcolumns=|date2|date1|mode|comment|payee|amount

I didn't find any other files

Comment 7 forum@guicar.fr 2025-04-10 12:11:15 UTC

(In reply to Stephane MANKOWSKI from comment #5)
> (In reply to forum@guicar.fr from comment #3)
> > Hi,
> > I have installed skrooge 2.30 using snap but i got this error
> >  PYTHONIOENCODING=utf_8 woob bank ls  -q -f csv -s id,label,balance
> > 2>/dev/null |grep -v "If --auto-update" | grep -E "id;label;balance|"
> > If I launch the command in a terminal it's work. So the application seems
> > not able to access to my local directories like /home/jpm/.local/bin/woob
> > may be because Skrooge snap environment is closed and "path" is not
> > available.
> > Regards,
> 
> This is not an issue of Skrooge but an issue of the snap packaging. To be
> honest, I don't know very well snap and don't know how to fix that.

Thank you
My wishes is to find a Skrooge version compatible with Ubuntu 20.04.2 (focal) and woob 3.7

Comment 8 forum@guicar.fr 2025-04-11 06:04:19 UTC

(In reply to forum@guicar.fr from comment #2)
> Thank you for your quick input. I have made the change but i still have the
> issue.
> Regards

I've reinstalled skrooge 2.28 from http://ppa.launchpad.net/s-mankowski/ppa-kf5/ubuntu as it was initially done and now it's works with woob 3.7 !!!