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

--- Comment #4 from Guillaume Stamm <guillaume.st...@gmail.com> ---
by looking at the trace:

Skrooge execute this:
    boobank ls -q -f csv -s id,balance | grep -E "id|"

with result this: (some "xxx" has been added by myself)
    id;balance
    00020031401@creditmutuel;xxx5.81
    00020293601@creditmutuel;xxx5.55
    00033550540@creditmutuel;xxx9.02
    00033550560@creditmutuel;xxx5.16
    00033550565@creditmutuel;xxx55.56
    00037869560@creditmutuel;xxx5.87
    102780303400033550502@creditmutuel;xxx19.00
    57419614@ing;xxx6.00
    CC-40000167961@ing;xxx32.34
    LEO-10001356004@ing;xxx29.17
    TITRE-77800057098@ing;xxx11.97

then skrooge executes these commands (and some others)
    boobank -q -f csv history "CC-40000167961@ing" -s
rdate,type,raw,label,amount --condition "rdate>2000-01-01 OR date>2000-01-01 OR
rdate>2000-01-01 00:00:00 OR date>2000-01-01 00:00:00" -n 99999
    boobank -q -f csv history "LEO-10001356004@ing" -s
rdate,type,raw,label,amount --condition "rdate>2000-01-01 OR date>2000-01-01 OR
rdate>2000-01-01 00:00:00 OR date>2000-01-01 00:00:00" -n 99999
    boobank -q -f csv history "TITRE-77800057098@ing" -s
rdate,type,raw,label,amount --condition "rdate>2000-01-01 OR date>2000-01-01 OR
rdate>2000-01-01 00:00:00 OR date>2000-01-01 00:00:00" -n 99999

I think that my issue is linked to the nature of the last account that is a
"stock"
If I execute directly the boobank commands:
        boobank -q -f csv history "CC-40000167961@ing" -s
rdate,type,raw,label,amount --condition "rdate>2000-01-01 OR date>2000-01-01 OR
rdate>2000-01-01 00:00:00 OR date>2000-01-01 00:00:00" -n 3
    =>
        rdate;type;raw;label;amount
        2017-09-06;1;virement sepa recu ipeca prevoyance;ipeca prevoyance;6.90
        2017-09-07;2;prlv sepa amaline assurances : fr09zzz543921
++001ac13000375 de amaline assurances : ++001ac13000375 fr09zzz543921;amaline
assurances : fr09zzz543921 ++001ac13000375 de amaline assurances :
++001ac13000375 fr09zzz543921;-4.90
        2017-09-07;2;prlv sepa maif 79038 niort cedex : fr70zzz000884
00100003511673r de maif 79038 niort cedex : 00100003511673r fr70zzz000884;maif
79038 niort cedex : fr70zzz000884 00100003511673r de maif 79038 niort cedex :
00100003511673r fr70zzz000884;-173.33
this result looks good, but now
        boobank -q -f csv history "TITRE-77800057098@ing" -s
rdate,type,raw,label,amount --condition "rdate>2000-01-01 OR date>2000-01-01 OR
rdate>2000-01-01 00:00:00 OR date>2000-01-01 00:00:00" -n 3
    =>
        Not available;0;CISCO SYSTEMS COUPONS;CISCO SYSTEMS COUPONS;10.24
        Not available;0;ADVINI COUPONS;ADVINI COUPONS;24.26
        Not available;0;IBM COUPONS;IBM COUPONS;10.72
here the date is a problème

Hence the issue does not come from Skrooge, neither from weboob/boobank, but
from the bank itself
But to not block end user, I see 2 options:

1- add a feature allowing to select witch account, from a bank, you are
interested in
2- when the date can not be read, put a date in the futur or date of the day

in any case it is sad that actually all accounts of the import are "rollback"



for information the trace of the error is:
##        Input parameter [iSqlOrder]=[ANALYZE]
##        Input filename=file:///tmp/skrooge-GL8ofY/titre-77800057...@ing.csv
##        Input local filename=/tmp/skrooge-GL8ofY/titre-77800057...@ing.csv
##          [36m>virtual SKGError SKGImportPluginCsv::importFile()[39m
##            [37m>virtual SKGError SKGDocument::beginTransaction(const
QString&, int, const QDateTime&, bool)[39m
##            Input parameter [name]=[#INTERNAL#Import CSV file]  [nb step]=[3]
 [refresh]=[Y]
##            [37m<virtual SKGError SKGDocument::beginTransaction(const
QString&, int, const QDateTime&, bool)[39m[37m RC=[SUC-0][39m
##            [37m>virtual SKGError SKGDocument::sendMessage(const QString&,
SKGDocument::MessageType, const QString&)[39m
##              [31m>virtual int SKGDocument::getCurrentTransaction()
const[39m
##              [31m<virtual int SKGDocument::getCurrentTransaction()
const[39m
##              [31m>virtual SKGError SKGObjectBase::save(bool, bool)[39m
##              Input parameter [iSqlOrder]=[INSERT INTO doctransactionmsg
('t_type','rd_doctransaction_id','t_message') VALUES ('I','17649','Mapping
used: date|mode|comment|payee|amount')]
##                [32m>virtual SKGError SKGObjectBase::load()[39m
##                [32m<virtual SKGError SKGObjectBase::load()[39m[32m
RC=[SUC-0][39m
##              [31m<virtual SKGError SKGObjectBase::save(bool,
bool)[39m[31m RC=[SUC-0][39m
##            [37m<virtual SKGError SKGDocument::sendMessage(const QString&,
SKGDocument::MessageType, const QString&)[39m[37m RC=[SUC-0][39m
##            [37m>virtual int SKGImportPluginCsv::getCSVHeaderIndex()[39m
##            [37m<virtual int SKGImportPluginCsv::getCSVHeaderIndex()[39m
##            [37m>virtual QChar SKGImportPluginCsv::getCSVSeparator()[39m
##            [37m<virtual QChar SKGImportPluginCsv::getCSVSeparator()[39m
...
##            [37m>static QString SKGServices::getDateFormat(const
QStringList&)[39m
##            [37m<static QString SKGServices::getDateFormat(const
QStringList&)[39m
##            [37m>virtual SKGError SKGDocument::endTransaction(bool)[39m
##              [31m>virtual int SKGDocument::getCurrentTransaction()
const[39m
##              [31m<virtual int SKGDocument::getCurrentTransaction()
const[39m
##            [37m<virtual SKGError
SKGDocument::endTransaction(bool)[39m[37m RC=[SUC-0][39m
##          [36m<virtual SKGError SKGImportPluginCsv::importFile()[39m[31m
RC=[ERR-5]: Date format not supported[39m
...
##    [33m<virtual SKGError SKGImportExportManager::importFile()[39m[31m
RC=[ERR-5]: Date format not supported[39m
##    [33m>virtual SKGError
SKGImportExportManager::setDefaultAccount(SKGAccountObject*)[39m
##    [33m<virtual SKGError
SKGImportExportManager::setDefaultAccount(SKGAccountObject*)[39m[33m
RC=[SUC-0][39m
##    [33m>virtual SKGError
SKGImportExportManager::setDefaultUnit(SKGUnitObject*)[39m
##    [33m<virtual SKGError
SKGImportExportManager::setDefaultUnit(SKGUnitObject*)[39m[33m
RC=[SUC-0][39m
##    [33m>virtual SKGError SKGDocument::endTransaction(bool)[39m
##      [34m>virtual int SKGDocument::getCurrentTransaction() const[39m
##      [34m<virtual int SKGDocument::getCurrentTransaction() const[39m
##    Input parameter [iSqlOrder]=[ROLLBACK;]
##    Input parameter [iSqlOrder]=[delete from doctransaction where id=17649]
##    [33m<virtual SKGError SKGDocument::endTransaction(bool)[39m[33m
RC=[SUC-0][39m
##    [33m>static KMessageWidget* SKGMainPanel::displayErrorMessage(const
SKGError&, QAction*)[39m
##    [33m<static KMessageWidget* SKGMainPanel::displayErrorMessage(const
SKGError&, QAction*)[39m
##  [32m<SKGError SKGImportExportPlugin::importbackends()[39m[31m
RC=[ERR-5]: Date format not supported[39m
##  [32m>virtual SKGError SKGObjectBase::load()[39m
##  [32m<virtual SKGError SKGObjectBase::load()[39m[32m RC=[SUC-0][39m

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

Reply via email to