Differential D8535 Diff 21476 kmymoney/plugins/qif/import/mymoneyqifreader.cpp

Changeset View

Standalone View

View Options

kmymoney/plugins/qif/import/mymoneyqifreader.cpp

Context not available.
50// Project Headers 50​// Project Headers
51 51​
52#include "mymoneyfile.h" 52​#include "mymoneyfile.h"
53​#include "mymoneysecurity.h"
53#include "kmymoneyglobalsettings.h" 54​#include "kmymoneyglobalsettings.h"
54 55​
55#include "mymoneystatement.h" 56​#include "mymoneystatement.h"
Context not available.
69{ 70​{
70public: 71​public:
71 Private() : 72​ Private() :
72 accountType(MyMoneyAccount::Checkings), 73​ accountType(eMyMoney::Account::Checkings),
73 mapCategories(true) {} 74​ mapCategories(true) {}
74 75​
75 const QString accountTypeToQif(MyMoneyAccount::accountTypeE type) const; 76​ const QString accountTypeToQif(eMyMoney::Account type) const;
76 77​
77 /** 78​ /**
78 * finalize the current statement and add it to the statement list 79​ * finalize the current statement and add it to the statement list
Context not available.
113 114​
114 QString st_AccountName; 115​ QString st_AccountName;
115 QString st_AccountId; 116​ QString st_AccountId;
116 MyMoneyAccount::accountTypeE accountType; 117​ eMyMoney::Account accountType;
117 bool firstTransaction; 118​ bool firstTransaction;
118 bool mapCategories; 119​ bool mapCategories;
119 MyMoneyQifReader::QifEntryTypeE transactionType; 120​ MyMoneyQifReader::QifEntryTypeE transactionType;
Context not available.
139 st.m_eType = type; 140​ st.m_eType = type;
140} 141​}
141 142​
142const QString MyMoneyQifReader::Private::accountTypeToQif(MyMoneyAccount::accountTypeE type) const 143​const QString MyMoneyQifReader::Private::accountTypeToQif(eMyMoney::Account type) const
143{ 144​{
144 QString rc = "Bank"; 145​ QString rc = "Bank";
145 146​
146 switch (type) { 147​ switch (type) {
147 default: 148​ default:
148 break; 149​ break;
149 case MyMoneyAccount::Cash: 150​ case eMyMoney::Account::Cash:
150 rc = "Cash"; 151​ rc = "Cash";
151 break; 152​ break;
152 case MyMoneyAccount::CreditCard: 153​ case eMyMoney::Account::CreditCard:
153 rc = "CCard"; 154​ rc = "CCard";
154 break; 155​ break;
155 case MyMoneyAccount::Asset: 156​ case eMyMoney::Account::Asset:
156 rc = "Oth A"; 157​ rc = "Oth A";
157 break; 158​ break;
158 case MyMoneyAccount::Liability: 159​ case eMyMoney::Account::Liability:
159 rc = "Oth L"; 160​ rc = "Oth L";
160 break; 161​ break;
161 case MyMoneyAccount::Investment: 162​ case eMyMoney::Account::Investment:
162 rc = "Port"; 163​ rc = "Port";
163 break; 164​ break;
164 } 165​ }
Context not available.
498 499​
499 // exportable accounts 500​ // exportable accounts
500 if (line.toLower() == "ccard" || KMyMoneyGlobalSettings::qifCreditCard().toLower().contains(line.toLower())) { 501​ if (line.toLower() == "ccard" || KMyMoneyGlobalSettings::qifCreditCard().toLower().contains(line.toLower())) {
501 d->accountType = MyMoneyAccount::CreditCard; 502​ d->accountType = eMyMoney::Account::CreditCard;
502 d->firstTransaction = true; 503​ d->firstTransaction = true;
503 d->transactionType = m_entryType = EntryTransaction; 504​ d->transactionType = m_entryType = EntryTransaction;
504 505​
505 } else if (line.toLower() == "bank" || KMyMoneyGlobalSettings::qifBank().toLower().contains(line.toLower())) { 506​ } else if (line.toLower() == "bank" || KMyMoneyGlobalSettings::qifBank().toLower().contains(line.toLower())) {
506 d->accountType = MyMoneyAccount::Checkings; 507​ d->accountType = eMyMoney::Account::Checkings;
507 d->firstTransaction = true; 508​ d->firstTransaction = true;
508 d->transactionType = m_entryType = EntryTransaction; 509​ d->transactionType = m_entryType = EntryTransaction;
509 510​
510 } else if (line.toLower() == "cash" || KMyMoneyGlobalSettings::qifCash().toLower().contains(line.toLower())) { 511​ } else if (line.toLower() == "cash" || KMyMoneyGlobalSettings::qifCash().toLower().contains(line.toLower())) {
511 d->accountType = MyMoneyAccount::Cash; 512​ d->accountType = eMyMoney::Account::Cash;
512 d->firstTransaction = true; 513​ d->firstTransaction = true;
513 d->transactionType = m_entryType = EntryTransaction; 514​ d->transactionType = m_entryType = EntryTransaction;
514 515​
515 } else if (line.toLower() == "oth a" || KMyMoneyGlobalSettings::qifAsset().toLower().contains(line.toLower())) { 516​ } else if (line.toLower() == "oth a" || KMyMoneyGlobalSettings::qifAsset().toLower().contains(line.toLower())) {
516 d->accountType = MyMoneyAccount::Asset; 517​ d->accountType = eMyMoney::Account::Asset;
517 d->firstTransaction = true; 518​ d->firstTransaction = true;
518 d->transactionType = m_entryType = EntryTransaction; 519​ d->transactionType = m_entryType = EntryTransaction;
519 520​
520 } else if (line.toLower() == "oth l" || line.toLower() == i18nc("QIF tag for liability account", "Oth L").toLower()) { 521​ } else if (line.toLower() == "oth l" || line.toLower() == i18nc("QIF tag for liability account", "Oth L").toLower()) {
521 d->accountType = MyMoneyAccount::Liability; 522​ d->accountType = eMyMoney::Account::Liability;
522 d->firstTransaction = true; 523​ d->firstTransaction = true;
523 d->transactionType = m_entryType = EntryTransaction; 524​ d->transactionType = m_entryType = EntryTransaction;
524 525​
525 } else if (line.toLower() == "invst" || line.toLower() == i18nc("QIF tag for investment account", "Invst").toLower()) { 526​ } else if (line.toLower() == "invst" || line.toLower() == i18nc("QIF tag for investment account", "Invst").toLower()) {
526 d->accountType = MyMoneyAccount::Investment; 527​ d->accountType = eMyMoney::Account::Investment;
527 d->transactionType = m_entryType = EntryInvestmentTransaction; 528​ d->transactionType = m_entryType = EntryInvestmentTransaction;
528 529​
529 } else if (line.toLower() == "invoice" || KMyMoneyGlobalSettings::qifInvoice().toLower().contains(line.toLower())) { 530​ } else if (line.toLower() == "invoice" || KMyMoneyGlobalSettings::qifInvoice().toLower().contains(line.toLower())) {
Context not available.
700} 701​}
701 702​
702#if 0 703​#if 0
703void MyMoneyQifReader::processMSAccountEntry(const MyMoneyAccount::accountTypeE accountType) 704​void MyMoneyQifReader::processMSAccountEntry(const eMyMoney::Account accountType)
704{ 705​{
705 if (extractLine('P').toLower() == m_qifProfile.openingBalanceText().toLower()) { 706​ if (extractLine('P').toLower() == m_qifProfile.openingBalanceText().toLower()) {
706 m_account = MyMoneyAccount(); 707​ m_account = MyMoneyAccount();
Context not available.
829 // so also have to test that either the 'I' or 'E' was detected 830​ // so also have to test that either the 'I' or 'E' was detected
830 //and set up accounts accordingly. 831​ //and set up accounts accordingly.
831 if ((!extractLine('I').isEmpty()) || (m_extractedLine != -1)) { 832​ if ((!extractLine('I').isEmpty()) || (m_extractedLine != -1)) {
832 account.setAccountType(MyMoneyAccount::Income); 833​ account.setAccountType(eMyMoney::Account::Income);
833 parentAccount = file->income(); 834​ parentAccount = file->income();
834 } else if ((!extractLine('E').isEmpty()) || (m_extractedLine != -1)) { 835​ } else if ((!extractLine('E').isEmpty()) || (m_extractedLine != -1)) {
835 account.setAccountType(MyMoneyAccount::Expense); 836​ account.setAccountType(eMyMoney::Account::Expense);
836 parentAccount = file->expense(); 837​ parentAccount = file->expense();
837 } 838​ }
838 839​
Context not available.
891 continue; 892​ continue;
892 const MyMoneyAccount& existingAccount = file->subAccountByName(parentAccount, name); 893​ const MyMoneyAccount& existingAccount = file->subAccountByName(parentAccount, name);
893 if (!existingAccount.id().isEmpty()) { 894​ if (!existingAccount.id().isEmpty()) {
894 if (acc.accountType() != MyMoneyAccount::UnknownAccountType) { 895​ if (acc.accountType() != eMyMoney::Account::Unknown) {
895 if (acc.accountType() != existingAccount.accountType()) 896​ if (acc.accountType() != existingAccount.accountType())
896 continue; 897​ continue;
897 } 898​ }
Context not available.
919 // in case we found a reference to an investment account, we need 920​ // in case we found a reference to an investment account, we need
920 // to switch to the brokerage account instead. 921​ // to switch to the brokerage account instead.
921 MyMoneyAccount acc = MyMoneyFile::instance()->account(accountId); 922​ MyMoneyAccount acc = MyMoneyFile::instance()->account(accountId);
922 if (useBrokerage && (acc.accountType() == MyMoneyAccount::Investment)) { 923​ if (useBrokerage && (acc.accountType() == eMyMoney::Account::Investment)) {
923 m_qifEntry.clear(); // and construct a temp entry to create/search the account 924​ m_qifEntry.clear(); // and construct a temp entry to create/search the account
924 m_qifEntry << QString("N%1").arg(acc.brokerageName()); 925​ m_qifEntry << QString("N%1").arg(acc.brokerageName());
925 m_qifEntry << QString("Tunknown"); 926​ m_qifEntry << QString("Tunknown");
Context not available.
932 return accountId; 933​ return accountId;
933} 934​}
934 935​
935void MyMoneyQifReader::createOpeningBalance(MyMoneyAccount::_accountTypeE accType) 936​void MyMoneyQifReader::createOpeningBalance(eMyMoney::Account accType)
936{ 937​{
937 MyMoneyFile* file = MyMoneyFile::instance(); 938​ MyMoneyFile* file = MyMoneyFile::instance();
938 939​
Context not available.
1056 1057​
1057 s1.m_accountId = d->st.m_accountId; 1058​ s1.m_accountId = d->st.m_accountId;
1058 switch (d->accountType) { 1059​ switch (d->accountType) {
1059 case MyMoneyAccount::Checkings: 1060​ case eMyMoney::Account::Checkings:
1060 d->st.m_eType=MyMoneyStatement::etCheckings; 1061​ d->st.m_eType=MyMoneyStatement::etCheckings;
1061 break; 1062​ break;
1062 case MyMoneyAccount::Savings: 1063​ case eMyMoney::Account::Savings:
1063 d->st.m_eType=MyMoneyStatement::etSavings; 1064​ d->st.m_eType=MyMoneyStatement::etSavings;
1064 break; 1065​ break;
1065 case MyMoneyAccount::Investment: 1066​ case eMyMoney::Account::Investment:
1066 d->st.m_eType=MyMoneyStatement::etInvestment; 1067​ d->st.m_eType=MyMoneyStatement::etInvestment;
1067 break; 1068​ break;
1068 case MyMoneyAccount::CreditCard: 1069​ case eMyMoney::Account::CreditCard:
1069 d->st.m_eType=MyMoneyStatement::etCreditCard; 1070​ d->st.m_eType=MyMoneyStatement::etCreditCard;
1070 break; 1071​ break;
1071 default: 1072​ default:
Context not available.
1185 MyMoneyAccount account = file->account(accountId); 1186​ MyMoneyAccount account = file->account(accountId);
1186 // FIXME: check that the type matches and ask if not 1187​ // FIXME: check that the type matches and ask if not
1187 1188​
1188 if (account.accountType() == MyMoneyAccount::Investment) { 1189​ if (account.accountType() == eMyMoney::Account::Investment) {
1189 qDebug() << "Line " << m_linenumber << ": Cannot transfer to/from an investment account. Transaction ignored."; 1190​ qDebug() << "Line " << m_linenumber << ": Cannot transfer to/from an investment account. Transaction ignored.";
1190 return; 1191​ return;
1191 } 1192​ }
Context not available.
1231 MyMoneyAccount account = file->account(accountId); 1232​ MyMoneyAccount account = file->account(accountId);
1232 // FIXME: check that the type matches and ask if not 1233​ // FIXME: check that the type matches and ask if not
1233 1234​
1234 if (account.accountType() == MyMoneyAccount::Investment) { 1235​ if (account.accountType() == eMyMoney::Account::Investment) {
1235 qDebug() << "Line " << m_linenumber << ": Cannot convert a split transfer to/from an investment account. Split removed. Total amount adjusted from " << tr.m_amount.formatMoney("", 2) << " to " << (tr.m_amount + s2.m_amount).formatMoney("", 2) << "\n"; 1236​ qDebug() << "Line " << m_linenumber << ": Cannot convert a split transfer to/from an investment account. Split removed. Total amount adjusted from " << tr.m_amount.formatMoney("", 2) << " to " << (tr.m_amount + s2.m_amount).formatMoney("", 2) << "\n";
1236 tr.m_amount += s2.m_amount; 1237​ tr.m_amount += s2.m_amount;
1237 continue; 1238​ continue;
Context not available.
1539 } else if (action == "xin" || action == "xout") { 1540​ } else if (action == "xin" || action == "xout") {
1540 QString payee = extractLine('P'); 1541​ QString payee = extractLine('P');
1541 if (!payee.isEmpty() && ((payee.toLower() == "opening balance") || KMyMoneyGlobalSettings::qifOpeningBalance().toLower().contains(payee.toLower()))) { 1542​ if (!payee.isEmpty() && ((payee.toLower() == "opening balance") || KMyMoneyGlobalSettings::qifOpeningBalance().toLower().contains(payee.toLower()))) {
1542 createOpeningBalance(MyMoneyAccount::Investment); 1543​ createOpeningBalance(eMyMoney::Account::Investment);
1543 return; 1544​ return;
1544 } 1545​ }
1545 1546​
Context not available.
1841 if (result.isEmpty()) { 1842​ if (result.isEmpty()) {
1842 MyMoneyAccount acc; 1843​ MyMoneyAccount acc;
1843 acc.setName(searchname); 1844​ acc.setName(searchname);
1844 acc.setAccountType(MyMoneyAccount::Income); 1845​ acc.setAccountType(eMyMoney::Account::Income);
1845 MyMoneyAccount income = file->income(); 1846​ MyMoneyAccount income = file->income();
1846 MyMoneyFileTransaction ft; 1847​ MyMoneyFileTransaction ft;
1847 file->addAccount(acc, income); 1848​ file->addAccount(acc, income);
Context not available.
1877 if (result.isEmpty()) { 1878​ if (result.isEmpty()) {
1878 MyMoneyAccount acc; 1879​ MyMoneyAccount acc;
1879 acc.setName(searchname); 1880​ acc.setName(searchname);
1880 acc.setAccountType(MyMoneyAccount::Expense); 1881​ acc.setAccountType(eMyMoney::Account::Expense);
1881 MyMoneyFileTransaction ft; 1882​ MyMoneyFileTransaction ft;
1882 MyMoneyAccount expense = file->expense(); 1883​ MyMoneyAccount expense = file->expense();
1883 file->addAccount(acc, expense); 1884​ file->addAccount(acc, expense);
Context not available.
1911 QifEntryTypeE transactionType = EntryTransaction; 1912​ QifEntryTypeE transactionType = EntryTransaction;
1912 QString type = extractLine('T').toLower().remove(QRegExp("\\s+")); 1913​ QString type = extractLine('T').toLower().remove(QRegExp("\\s+"));
1913 if (type == m_qifProfile.profileType().toLower().remove(QRegExp("\\s+"))) { 1914​ if (type == m_qifProfile.profileType().toLower().remove(QRegExp("\\s+"))) {
1914 account.setAccountType(MyMoneyAccount::Checkings); 1915​ account.setAccountType(eMyMoney::Account::Checkings);
1915 } else if (type == "ccard" || type == "creditcard") { 1916​ } else if (type == "ccard" || type == "creditcard") {
1916 account.setAccountType(MyMoneyAccount::CreditCard); 1917​ account.setAccountType(eMyMoney::Account::CreditCard);
1917 } else if (type == "cash") { 1918​ } else if (type == "cash") {
1918 account.setAccountType(MyMoneyAccount::Cash); 1919​ account.setAccountType(eMyMoney::Account::Cash);
1919 } else if (type == "otha") { 1920​ } else if (type == "otha") {
1920 account.setAccountType(MyMoneyAccount::Asset); 1921​ account.setAccountType(eMyMoney::Account::Asset);
1921 } else if (type == "othl") { 1922​ } else if (type == "othl") {
1922 account.setAccountType(MyMoneyAccount::Liability); 1923​ account.setAccountType(eMyMoney::Account::Liability);
1923 } else if (type == "invst" || type == "port") { 1924​ } else if (type == "invst" || type == "port") {
1924 account.setAccountType(MyMoneyAccount::Investment); 1925​ account.setAccountType(eMyMoney::Account::Investment);
1925 transactionType = EntryInvestmentTransaction; 1926​ transactionType = EntryInvestmentTransaction;
1926 } else if (type == "mutual") { // stock account w/o umbrella investment account 1927​ } else if (type == "mutual") { // stock account w/o umbrella investment account
1927 account.setAccountType(MyMoneyAccount::Stock); 1928​ account.setAccountType(eMyMoney::Account::Stock);
1928 transactionType = EntryInvestmentTransaction; 1929​ transactionType = EntryInvestmentTransaction;
1929 } else if (type == "unknown") { 1930​ } else if (type == "unknown") {
1930 // don't do anything with the type, leave it unknown 1931​ // don't do anything with the type, leave it unknown
1931 } else { 1932​ } else {
1932 account.setAccountType(MyMoneyAccount::Checkings); 1933​ account.setAccountType(eMyMoney::Account::Checkings);
1933 qDebug() << "Line " << m_linenumber << ": Unknown account type '" << type << "', checkings assumed"; 1934​ qDebug() << "Line " << m_linenumber << ": Unknown account type '" << type << "', checkings assumed";
1934 } 1935​ }
1935 1936​
Context not available.
1939 // in case the account is not found by name and the type is 1940​ // in case the account is not found by name and the type is
1940 // unknown, we have to assume something and create a checking account. 1941​ // unknown, we have to assume something and create a checking account.
1941 // this might be wrong, but we have no choice at this point. 1942​ // this might be wrong, but we have no choice at this point.
1942 if (account.accountType() == MyMoneyAccount::UnknownAccountType) 1943​ if (account.accountType() == eMyMoney::Account::Unknown)
1943 account.setAccountType(MyMoneyAccount::Checkings); 1944​ account.setAccountType(eMyMoney::Account::Checkings);
1944 1945​
1945 MyMoneyAccount parentAccount; 1946​ MyMoneyAccount parentAccount;
1946 MyMoneyAccount brokerage; 1947​ MyMoneyAccount brokerage;
Context not available.
1948 if (account.isInvest()) { 1949​ if (account.isInvest()) {
1949 acc.setName(i18n("%1 (Investment)", account.name())); // use the same name for the investment account 1950​ acc.setName(i18n("%1 (Investment)", account.name())); // use the same name for the investment account
1950 acc.setDescription(i18n("Autogenerated by QIF importer from type Mutual account entry")); 1951​ acc.setDescription(i18n("Autogenerated by QIF importer from type Mutual account entry"));
1951 acc.setAccountType(MyMoneyAccount::Investment); 1952​ acc.setAccountType(eMyMoney::Account::Investment);
1952 parentAccount = file->asset(); 1953​ parentAccount = file->asset();
1953 file->createAccount(acc, parentAccount, brokerage, MyMoneyMoney()); 1954​ file->createAccount(acc, parentAccount, brokerage, MyMoneyMoney());
1954 parentAccount = acc; 1955​ parentAccount = acc;
Context not available.
1956 } else { 1957​ } else {
1957 // setup parent according the type of the account 1958​ // setup parent according the type of the account
1958 switch (account.accountGroup()) { 1959​ switch (account.accountGroup()) {
1959 case MyMoneyAccount::Asset: 1960​ case eMyMoney::Account::Asset:
1960 default: 1961​ default:
1961 parentAccount = file->asset(); 1962​ parentAccount = file->asset();
1962 break; 1963​ break;
1963 case MyMoneyAccount::Liability: 1964​ case eMyMoney::Account::Liability:
1964 parentAccount = file->liability(); 1965​ parentAccount = file->liability();
1965 break; 1966​ break;
1966 case MyMoneyAccount::Equity: 1967​ case eMyMoney::Account::Equity:
1967 parentAccount = file->equity(); 1968​ parentAccount = file->equity();
1968 break; 1969​ break;
1969 } 1970​ }
Context not available.
1972 // investment accounts will receive a brokerage account, as KMyMoney 1973​ // investment accounts will receive a brokerage account, as KMyMoney
1973 // currently does not allow to store funds in the investment account directly 1974​ // currently does not allow to store funds in the investment account directly
1974 // but only create it (not here, but later) if it is needed 1975​ // but only create it (not here, but later) if it is needed
1975 if (account.accountType() == MyMoneyAccount::Investment) { 1976​ if (account.accountType() == eMyMoney::Account::Investment) {
1976 brokerage.setName(QString()); // brokerage name empty so account not created yet 1977​ brokerage.setName(QString()); // brokerage name empty so account not created yet
1977 brokerage.setAccountType(MyMoneyAccount::Checkings); 1978​ brokerage.setAccountType(eMyMoney::Account::Checkings);
1978 brokerage.setCurrencyId(MyMoneyFile::instance()->baseCurrency().id()); 1979​ brokerage.setCurrencyId(MyMoneyFile::instance()->baseCurrency().id());
1979 } 1980​ }
1980 file->createAccount(account, parentAccount, brokerage, MyMoneyMoney()); 1981​ file->createAccount(account, parentAccount, brokerage, MyMoneyMoney());
Context not available.