<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en_US" xml:lang="en_US">
<head>
<title>kaddressbook: csvimportdialog.cpp Source File (kaddressbook)</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="pics-label" content='(pics-1.1 "http://www.icra.org/ratingsv02.html" comment "ICRAonline DE v2.0" l gen true for "http://www.kde.org" r (nz 1 vz 1 lz 1 oz 1 cb 1) "http://www.rsac.org/ratingsv01.html" l gen true for "http://www.kde.org" r (n 0 s 0 v 0 l 0))' />
<meta name="trademark" content="KDE e.V." />
<meta name="description" content="K Desktop Environment Homepage, KDE.org" />
<meta name="MSSmartTagsPreventParsing" content="true" />
<meta name="robots" content="all" />
<link rel="shortcut icon" href="../../favicon.ico" />
<link rel="stylesheet" media="screen" type="text/css" title="APIDOX" href="doxygen.css" />
<style type="text/css">
<!--
hr { display: none; }
#content h2 { margin-left: 0px; }
table.mdTable { background-color: #f8f8f8; border: .2em solid #d7d7d7; }
td.mdRow { padding: 8px 20px; }
td.md { font-weight: bold; }
td.mdname1 { font-weight: bold; color: #602020; }
td.mdname { font-weight: bold; color: #602020; }
-->
</style>
</head>
<body>
<div id="nav_header_top" align="right">
<a href="#content" class="doNotDisplay" accesskey="2">Skip to main content ::</a>
<a href="../.."><img id="nav_header_logo" alt="Home" align="left" src="../../kde_gear_64.png" border="0" /></a>
<span class="doNotDisplay">::</span>
<img id="nav_header_logo_right" alt="" align="right" src="../../pimlogo.png" border="0" />
<div id="nav_header_title" align="left">KDE PIM API Reference</div>
</div>
<div id="nav_header_bottom" align="right">
<span class="doNotDisplay">:: <a href="#navigation" accesskey="5">Skip to Link Menu</a><br/></span>
<div id="nav_header_bottom_left" style="text-align: left;">
/ <a href="../../">API Reference</a>
/ <a href=".">kaddressbook</a>
</div>
</div>
<table id="main" border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td valign="top" class="menuheader" height="0"></td>
<td id="contentcolumn" valign="top" rowspan="2" >
<div id="content" style="padding-top: 0px;"><div style="width:100%; margin: 0px; padding: 0px;">
<h2><a name="content"></a>kaddressbook</h2>
<!-- Generated by Doxygen 1.5.5 -->
<h1>csvimportdialog.cpp</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="comment">/*</span>
<a name="l00002"></a>00002 <span class="comment"> This file is part of KAddressBook.</span>
<a name="l00003"></a>00003 <span class="comment"> Copyright (C) 2003 Tobias Koenig <tokoe@kde.org></span>
<a name="l00004"></a>00004 <span class="comment"> based on the code of KSpread's CSV Import Dialog</span>
<a name="l00005"></a>00005 <span class="comment"></span>
<a name="l00006"></a>00006 <span class="comment"> This library is free software; you can redistribute it and/or</span>
<a name="l00007"></a>00007 <span class="comment"> modify it under the terms of the GNU Library General Public</span>
<a name="l00008"></a>00008 <span class="comment"> License as published by the Free Software Foundation; either</span>
<a name="l00009"></a>00009 <span class="comment"> version 2 of the License, or (at your option) any later version.</span>
<a name="l00010"></a>00010 <span class="comment"></span>
<a name="l00011"></a>00011 <span class="comment"> This library is distributed in the hope that it will be useful,</span>
<a name="l00012"></a>00012 <span class="comment"> but WITHOUT ANY WARRANTY; without even the implied warranty of</span>
<a name="l00013"></a>00013 <span class="comment"> MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU</span>
<a name="l00014"></a>00014 <span class="comment"> Library General Public License for more details.</span>
<a name="l00015"></a>00015 <span class="comment"></span>
<a name="l00016"></a>00016 <span class="comment"> You should have received a copy of the GNU Library General Public License</span>
<a name="l00017"></a>00017 <span class="comment"> along with this library; see the file COPYING.LIB. If not, write to</span>
<a name="l00018"></a>00018 <span class="comment"> the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,</span>
<a name="l00019"></a>00019 <span class="comment"> Boston, MA 02110-1301, USA.</span>
<a name="l00020"></a>00020 <span class="comment">*/</span>
<a name="l00021"></a>00021
<a name="l00022"></a>00022
<a name="l00023"></a>00023 <span class="preprocessor">#include <qbuttongroup.h></span>
<a name="l00024"></a>00024 <span class="preprocessor">#include <qcheckbox.h></span>
<a name="l00025"></a>00025 <span class="preprocessor">#include <qcombobox.h></span>
<a name="l00026"></a>00026 <span class="preprocessor">#include <qlabel.h></span>
<a name="l00027"></a>00027 <span class="preprocessor">#include <qlayout.h></span>
<a name="l00028"></a>00028 <span class="preprocessor">#include <qlineedit.h></span>
<a name="l00029"></a>00029 <span class="preprocessor">#include <qpushbutton.h></span>
<a name="l00030"></a>00030 <span class="preprocessor">#include <qradiobutton.h></span>
<a name="l00031"></a>00031 <span class="preprocessor">#include <qtable.h></span>
<a name="l00032"></a>00032 <span class="preprocessor">#include <qtextcodec.h></span>
<a name="l00033"></a>00033 <span class="preprocessor">#include <qtooltip.h></span>
<a name="l00034"></a>00034
<a name="l00035"></a>00035 <span class="preprocessor">#include <kapplication.h></span>
<a name="l00036"></a>00036 <span class="preprocessor">#include <kdebug.h></span>
<a name="l00037"></a>00037 <span class="preprocessor">#include <kdialogbase.h></span>
<a name="l00038"></a>00038 <span class="preprocessor">#include <kfiledialog.h></span>
<a name="l00039"></a>00039 <span class="preprocessor">#include <klineedit.h></span>
<a name="l00040"></a>00040 <span class="preprocessor">#include <klocale.h></span>
<a name="l00041"></a>00041 <span class="preprocessor">#include <kinputdialog.h></span>
<a name="l00042"></a>00042 <span class="preprocessor">#include <kmessagebox.h></span>
<a name="l00043"></a>00043 <span class="preprocessor">#include <kprogress.h></span>
<a name="l00044"></a>00044 <span class="preprocessor">#include <kstandarddirs.h></span>
<a name="l00045"></a>00045 <span class="preprocessor">#include <kurlrequester.h></span>
<a name="l00046"></a>00046
<a name="l00047"></a>00047 <span class="preprocessor">#include "dateparser.h"</span>
<a name="l00048"></a>00048
<a name="l00049"></a>00049 <span class="preprocessor">#include "csvimportdialog.h"</span>
<a name="l00050"></a>00050
<a name="l00051"></a>00051 <span class="keyword">enum</span> { Local = 0, Guess = 1, Latin1 = 2, Uni = 3, MSBug = 4, Codec = 5 };
<a name="l00052"></a>00052
<a name="l00053"></a>00053 CSVImportDialog::CSVImportDialog( KABC::AddressBook *ab, QWidget *parent,
<a name="l00054"></a>00054 <span class="keyword">const</span> <span class="keywordtype">char</span> * name )
<a name="l00055"></a>00055 : KDialogBase( Plain, i18n ( <span class="stringliteral">"CSV Import Dialog"</span> ), Ok | Cancel | User1 |
<a name="l00056"></a>00056 User2, Ok, parent, name, true, true ),
<a name="l00057"></a>00057 mAdjustRows( false ),
<a name="l00058"></a>00058 mStartLine( 0 ),
<a name="l00059"></a>00059 mTextQuote( <span class="stringliteral">'"'</span> ),
<a name="l00060"></a>00060 mDelimiter( <span class="stringliteral">","</span> ),
<a name="l00061"></a>00061 mAddressBook( ab )
<a name="l00062"></a>00062 {
<a name="l00063"></a>00063 initGUI();
<a name="l00064"></a>00064
<a name="l00065"></a>00065 mTypeMap.insert( i18n( <span class="stringliteral">"Undefined"</span> ), Undefined );
<a name="l00066"></a>00066 mTypeMap.insert( KABC::Addressee::formattedNameLabel(), FormattedName );
<a name="l00067"></a>00067 mTypeMap.insert( KABC::Addressee::familyNameLabel(), FamilyName );
<a name="l00068"></a>00068 mTypeMap.insert( KABC::Addressee::givenNameLabel(), GivenName );
<a name="l00069"></a>00069 mTypeMap.insert( KABC::Addressee::additionalNameLabel(), AdditionalName );
<a name="l00070"></a>00070 mTypeMap.insert( KABC::Addressee::prefixLabel(), Prefix );
<a name="l00071"></a>00071 mTypeMap.insert( KABC::Addressee::suffixLabel(), Suffix );
<a name="l00072"></a>00072 mTypeMap.insert( KABC::Addressee::nickNameLabel(), NickName );
<a name="l00073"></a>00073 mTypeMap.insert( KABC::Addressee::birthdayLabel(), Birthday );
<a name="l00074"></a>00074
<a name="l00075"></a>00075 mTypeMap.insert( KABC::Addressee::homeAddressStreetLabel(), HomeAddressStreet );
<a name="l00076"></a>00076 mTypeMap.insert( KABC::Addressee::homeAddressLocalityLabel(),
<a name="l00077"></a>00077 HomeAddressLocality );
<a name="l00078"></a>00078 mTypeMap.insert( KABC::Addressee::homeAddressRegionLabel(), HomeAddressRegion );
<a name="l00079"></a>00079 mTypeMap.insert( KABC::Addressee::homeAddressPostalCodeLabel(),
<a name="l00080"></a>00080 HomeAddressPostalCode );
<a name="l00081"></a>00081 mTypeMap.insert( KABC::Addressee::homeAddressCountryLabel(),
<a name="l00082"></a>00082 HomeAddressCountry );
<a name="l00083"></a>00083 mTypeMap.insert( KABC::Addressee::homeAddressLabelLabel(), HomeAddressLabel );
<a name="l00084"></a>00084
<a name="l00085"></a>00085 mTypeMap.insert( KABC::Addressee::businessAddressStreetLabel(),
<a name="l00086"></a>00086 BusinessAddressStreet );
<a name="l00087"></a>00087 mTypeMap.insert( KABC::Addressee::businessAddressLocalityLabel(),
<a name="l00088"></a>00088 BusinessAddressLocality );
<a name="l00089"></a>00089 mTypeMap.insert( KABC::Addressee::businessAddressRegionLabel(),
<a name="l00090"></a>00090 BusinessAddressRegion );
<a name="l00091"></a>00091 mTypeMap.insert( KABC::Addressee::businessAddressPostalCodeLabel(),
<a name="l00092"></a>00092 BusinessAddressPostalCode );
<a name="l00093"></a>00093 mTypeMap.insert( KABC::Addressee::businessAddressCountryLabel(),
<a name="l00094"></a>00094 BusinessAddressCountry );
<a name="l00095"></a>00095 mTypeMap.insert( KABC::Addressee::businessAddressLabelLabel(),
<a name="l00096"></a>00096 BusinessAddressLabel );
<a name="l00097"></a>00097
<a name="l00098"></a>00098 mTypeMap.insert( KABC::Addressee::homePhoneLabel(), HomePhone );
<a name="l00099"></a>00099 mTypeMap.insert( KABC::Addressee::businessPhoneLabel(), BusinessPhone );
<a name="l00100"></a>00100 mTypeMap.insert( KABC::Addressee::mobilePhoneLabel(), MobilePhone );
<a name="l00101"></a>00101 mTypeMap.insert( KABC::Addressee::homeFaxLabel(), HomeFax );
<a name="l00102"></a>00102 mTypeMap.insert( KABC::Addressee::businessFaxLabel(), BusinessFax );
<a name="l00103"></a>00103 mTypeMap.insert( KABC::Addressee::carPhoneLabel(), CarPhone );
<a name="l00104"></a>00104 mTypeMap.insert( KABC::Addressee::isdnLabel(), Isdn );
<a name="l00105"></a>00105 mTypeMap.insert( KABC::Addressee::pagerLabel(), Pager );
<a name="l00106"></a>00106 mTypeMap.insert( KABC::Addressee::emailLabel(), Email );
<a name="l00107"></a>00107 mTypeMap.insert( KABC::Addressee::mailerLabel(), Mailer );
<a name="l00108"></a>00108 mTypeMap.insert( KABC::Addressee::titleLabel(), Title );
<a name="l00109"></a>00109 mTypeMap.insert( KABC::Addressee::roleLabel(), Role );
<a name="l00110"></a>00110 mTypeMap.insert( KABC::Addressee::organizationLabel(), Organization );
<a name="l00111"></a>00111 mTypeMap.insert( KABC::Addressee::noteLabel(), Note );
<a name="l00112"></a>00112 mTypeMap.insert( KABC::Addressee::urlLabel(), URL );
<a name="l00113"></a>00113
<a name="l00114"></a>00114 mCustomCounter = mTypeMap.count();
<a name="l00115"></a>00115 <span class="keywordtype">int</span> count = mCustomCounter;
<a name="l00116"></a>00116
<a name="l00117"></a>00117 KABC::Field::List fields = mAddressBook->fields( KABC::Field::CustomCategory );
<a name="l00118"></a>00118 KABC::Field::List::Iterator it;
<a name="l00119"></a>00119 <span class="keywordflow">for</span> ( it = fields.begin(); it != fields.end(); ++it, ++count )
<a name="l00120"></a>00120 mTypeMap.insert( (*it)->label(), count );
<a name="l00121"></a>00121
<a name="l00122"></a>00122 reloadCodecs();
<a name="l00123"></a>00123
<a name="l00124"></a>00124 connect( mDelimiterBox, SIGNAL( clicked( <span class="keywordtype">int</span> ) ),
<a name="l00125"></a>00125 <span class="keyword">this</span>, SLOT( delimiterClicked( <span class="keywordtype">int</span> ) ) );
<a name="l00126"></a>00126 connect( mDelimiterEdit, SIGNAL( returnPressed() ),
<a name="l00127"></a>00127 <span class="keyword">this</span>, SLOT( returnPressed() ) );
<a name="l00128"></a>00128 connect( mDelimiterEdit, SIGNAL( textChanged ( <span class="keyword">const</span> QString& ) ),
<a name="l00129"></a>00129 <span class="keyword">this</span>, SLOT( textChanged ( <span class="keyword">const</span> QString& ) ) );
<a name="l00130"></a>00130 connect( mComboLine, SIGNAL( activated( <span class="keyword">const</span> QString& ) ),
<a name="l00131"></a>00131 <span class="keyword">this</span>, SLOT( lineSelected( <span class="keyword">const</span> QString& ) ) );
<a name="l00132"></a>00132 connect( mComboQuote, SIGNAL( activated( <span class="keyword">const</span> QString& ) ),
<a name="l00133"></a>00133 <span class="keyword">this</span>, SLOT( textquoteSelected( <span class="keyword">const</span> QString& ) ) );
<a name="l00134"></a>00134 connect( mIgnoreDuplicates, SIGNAL( stateChanged( <span class="keywordtype">int</span> ) ),
<a name="l00135"></a>00135 <span class="keyword">this</span>, SLOT( ignoreDuplicatesChanged( <span class="keywordtype">int</span> ) ) );
<a name="l00136"></a>00136 connect( mCodecCombo, SIGNAL( activated( <span class="keyword">const</span> QString& ) ),
<a name="l00137"></a>00137 <span class="keyword">this</span>, SLOT( codecChanged() ) );
<a name="l00138"></a>00138
<a name="l00139"></a>00139 connect( mUrlRequester, SIGNAL( returnPressed( <span class="keyword">const</span> QString& ) ),
<a name="l00140"></a>00140 <span class="keyword">this</span>, SLOT( setFile( <span class="keyword">const</span> QString& ) ) );
<a name="l00141"></a>00141 connect( mUrlRequester, SIGNAL( urlSelected( <span class="keyword">const</span> QString& ) ),
<a name="l00142"></a>00142 <span class="keyword">this</span>, SLOT( setFile( <span class="keyword">const</span> QString& ) ) );
<a name="l00143"></a>00143 connect( mUrlRequester->lineEdit(), SIGNAL( textChanged ( <span class="keyword">const</span> QString& ) ),
<a name="l00144"></a>00144 <span class="keyword">this</span>, SLOT( urlChanged( <span class="keyword">const</span> QString& ) ) );
<a name="l00145"></a>00145
<a name="l00146"></a>00146 connect( <span class="keyword">this</span>, SIGNAL( user1Clicked() ),
<a name="l00147"></a>00147 <span class="keyword">this</span>, SLOT( applyTemplate() ) );
<a name="l00148"></a>00148
<a name="l00149"></a>00149 connect( <span class="keyword">this</span>, SIGNAL( user2Clicked() ),
<a name="l00150"></a>00150 <span class="keyword">this</span>, SLOT( saveTemplate() ) );
<a name="l00151"></a>00151 }
<a name="l00152"></a>00152
<a name="l00153"></a>00153 CSVImportDialog::~CSVImportDialog()
<a name="l00154"></a>00154 {
<a name="l00155"></a>00155 mCodecs.clear();
<a name="l00156"></a>00156 }
<a name="l00157"></a>00157
<a name="l00158"></a>00158 KABC::AddresseeList CSVImportDialog::contacts()<span class="keyword"> const</span>
<a name="l00159"></a>00159 <span class="keyword"></span>{
<a name="l00160"></a>00160 <a class="code" href="classDateParser.html" title="This class parses the date out of a given string with the help of a pattern.">DateParser</a> dateParser( mDatePatternEdit->text() );
<a name="l00161"></a>00161 KABC::AddresseeList contacts;
<a name="l00162"></a>00162
<a name="l00163"></a>00163 KProgressDialog progressDialog( mPage );
<a name="l00164"></a>00164 progressDialog.setAutoClose( <span class="keyword">true</span> );
<a name="l00165"></a>00165 progressDialog.progressBar()->setTotalSteps( mTable->numRows() );
<a name="l00166"></a>00166 progressDialog.setLabel( i18n( <span class="stringliteral">"Importing contacts"</span> ) );
<a name="l00167"></a>00167 progressDialog.show();
<a name="l00168"></a>00168
<a name="l00169"></a>00169 kapp->processEvents();
<a name="l00170"></a>00170
<a name="l00171"></a>00171 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> row = 1; row < mTable->numRows(); ++row ) {
<a name="l00172"></a>00172 KABC::Addressee a;
<a name="l00173"></a>00173 <span class="keywordtype">bool</span> emptyRow = <span class="keyword">true</span>;
<a name="l00174"></a>00174 KABC::Address addrHome( KABC::Address::Home );
<a name="l00175"></a>00175 KABC::Address addrWork( KABC::Address::Work );
<a name="l00176"></a>00176 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> col = 0; col < mTable->numCols(); ++col ) {
<a name="l00177"></a>00177 QComboTableItem *item = <span class="keyword">static_cast<</span>QComboTableItem*<span class="keyword">></span>( mTable->item( 0,
<a name="l00178"></a>00178 col ) );
<a name="l00179"></a>00179 <span class="keywordflow">if</span> ( !item ) {
<a name="l00180"></a>00180 kdError() << <span class="stringliteral">"ERROR: item cast failed"</span> << endl;
<a name="l00181"></a>00181 <span class="keywordflow">continue</span>;
<a name="l00182"></a>00182 }
<a name="l00183"></a>00183
<a name="l00184"></a>00184 QString value = mTable->text( row, col );
<a name="l00185"></a>00185 <span class="keywordflow">if</span> ( 1 == row && static_cast<QTableItem *>(item)->text() == value )
<a name="l00186"></a>00186 <span class="comment">// we are looking at a header row, stop now</span>
<a name="l00187"></a>00187 <span class="keywordflow">break</span>;
<a name="l00188"></a>00188
<a name="l00189"></a>00189 <span class="keywordflow">if</span> ( !value.isEmpty() )
<a name="l00190"></a>00190 emptyRow = <span class="keyword">false</span>;
<a name="l00191"></a>00191
<a name="l00192"></a>00192 <span class="keywordflow">switch</span> ( posToType( item->currentItem() ) ) {
<a name="l00193"></a>00193 <span class="keywordflow">case</span> Undefined:
<a name="l00194"></a>00194 <span class="keywordflow">continue</span>;
<a name="l00195"></a>00195 <span class="keywordflow">break</span>;
<a name="l00196"></a>00196 <span class="keywordflow">case</span> FormattedName:
<a name="l00197"></a>00197 a.setFormattedName( value );
<a name="l00198"></a>00198 <span class="keywordflow">break</span>;
<a name="l00199"></a>00199 <span class="keywordflow">case</span> GivenName:
<a name="l00200"></a>00200 a.setGivenName( value );
<a name="l00201"></a>00201 <span class="keywordflow">break</span>;
<a name="l00202"></a>00202 <span class="keywordflow">case</span> FamilyName:
<a name="l00203"></a>00203 a.setFamilyName( value );
<a name="l00204"></a>00204 <span class="keywordflow">break</span>;
<a name="l00205"></a>00205 <span class="keywordflow">case</span> AdditionalName:
<a name="l00206"></a>00206 a.setAdditionalName( value );
<a name="l00207"></a>00207 <span class="keywordflow">break</span>;
<a name="l00208"></a>00208 <span class="keywordflow">case</span> Prefix:
<a name="l00209"></a>00209 a.setPrefix( value );
<a name="l00210"></a>00210 <span class="keywordflow">break</span>;
<a name="l00211"></a>00211 <span class="keywordflow">case</span> Suffix:
<a name="l00212"></a>00212 a.setSuffix( value );
<a name="l00213"></a>00213 <span class="keywordflow">break</span>;
<a name="l00214"></a>00214 <span class="keywordflow">case</span> NickName:
<a name="l00215"></a>00215 a.setNickName( value );
<a name="l00216"></a>00216 <span class="keywordflow">break</span>;
<a name="l00217"></a>00217 <span class="keywordflow">case</span> Birthday:
<a name="l00218"></a>00218 a.setBirthday( dateParser.parse( value ) );
<a name="l00219"></a>00219 <span class="keywordflow">break</span>;
<a name="l00220"></a>00220 <span class="keywordflow">case</span> Email:
<a name="l00221"></a>00221 <span class="keywordflow">if</span> ( !value.isEmpty() )
<a name="l00222"></a>00222 a.insertEmail( value, <span class="keyword">true</span> );
<a name="l00223"></a>00223 <span class="keywordflow">break</span>;
<a name="l00224"></a>00224 <span class="keywordflow">case</span> Role:
<a name="l00225"></a>00225 a.setRole( value );
<a name="l00226"></a>00226 <span class="keywordflow">break</span>;
<a name="l00227"></a>00227 <span class="keywordflow">case</span> Title:
<a name="l00228"></a>00228 a.setTitle( value );
<a name="l00229"></a>00229 <span class="keywordflow">break</span>;
<a name="l00230"></a>00230 <span class="keywordflow">case</span> Mailer:
<a name="l00231"></a>00231 a.setMailer( value );
<a name="l00232"></a>00232 <span class="keywordflow">break</span>;
<a name="l00233"></a>00233 <span class="keywordflow">case</span> URL:
<a name="l00234"></a>00234 a.setUrl( KURL( value ) );
<a name="l00235"></a>00235 <span class="keywordflow">break</span>;
<a name="l00236"></a>00236 <span class="keywordflow">case</span> Organization:
<a name="l00237"></a>00237 a.setOrganization( value );
<a name="l00238"></a>00238 <span class="keywordflow">break</span>;
<a name="l00239"></a>00239 <span class="keywordflow">case</span> Note:
<a name="l00240"></a>00240 a.setNote( a.note() + value + <span class="stringliteral">"\n"</span> );
<a name="l00241"></a>00241 <span class="keywordflow">break</span>;
<a name="l00242"></a>00242
<a name="l00243"></a>00243 <span class="keywordflow">case</span> HomePhone:
<a name="l00244"></a>00244 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00245"></a>00245 KABC::PhoneNumber number( value, KABC::PhoneNumber::Home );
<a name="l00246"></a>00246 a.insertPhoneNumber( number );
<a name="l00247"></a>00247 }
<a name="l00248"></a>00248 <span class="keywordflow">break</span>;
<a name="l00249"></a>00249 <span class="keywordflow">case</span> BusinessPhone:
<a name="l00250"></a>00250 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00251"></a>00251 KABC::PhoneNumber number( value, KABC::PhoneNumber::Work );
<a name="l00252"></a>00252 a.insertPhoneNumber( number );
<a name="l00253"></a>00253 }
<a name="l00254"></a>00254 <span class="keywordflow">break</span>;
<a name="l00255"></a>00255 <span class="keywordflow">case</span> MobilePhone:
<a name="l00256"></a>00256 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00257"></a>00257 KABC::PhoneNumber number( value, KABC::PhoneNumber::Cell );
<a name="l00258"></a>00258 a.insertPhoneNumber( number );
<a name="l00259"></a>00259 }
<a name="l00260"></a>00260 <span class="keywordflow">break</span>;
<a name="l00261"></a>00261 <span class="keywordflow">case</span> HomeFax:
<a name="l00262"></a>00262 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00263"></a>00263 KABC::PhoneNumber number( value, KABC::PhoneNumber::Home |
<a name="l00264"></a>00264 KABC::PhoneNumber::Fax );
<a name="l00265"></a>00265 a.insertPhoneNumber( number );
<a name="l00266"></a>00266 }
<a name="l00267"></a>00267 <span class="keywordflow">break</span>;
<a name="l00268"></a>00268 <span class="keywordflow">case</span> BusinessFax:
<a name="l00269"></a>00269 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00270"></a>00270 KABC::PhoneNumber number( value, KABC::PhoneNumber::Work |
<a name="l00271"></a>00271 KABC::PhoneNumber::Fax );
<a name="l00272"></a>00272 a.insertPhoneNumber( number );
<a name="l00273"></a>00273 }
<a name="l00274"></a>00274 <span class="keywordflow">break</span>;
<a name="l00275"></a>00275 <span class="keywordflow">case</span> CarPhone:
<a name="l00276"></a>00276 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00277"></a>00277 KABC::PhoneNumber number( value, KABC::PhoneNumber::Car );
<a name="l00278"></a>00278 a.insertPhoneNumber( number );
<a name="l00279"></a>00279 }
<a name="l00280"></a>00280 <span class="keywordflow">break</span>;
<a name="l00281"></a>00281 <span class="keywordflow">case</span> Isdn:
<a name="l00282"></a>00282 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00283"></a>00283 KABC::PhoneNumber number( value, KABC::PhoneNumber::Isdn );
<a name="l00284"></a>00284 a.insertPhoneNumber( number );
<a name="l00285"></a>00285 }
<a name="l00286"></a>00286 <span class="keywordflow">break</span>;
<a name="l00287"></a>00287 <span class="keywordflow">case</span> Pager:
<a name="l00288"></a>00288 <span class="keywordflow">if</span> ( !value.isEmpty() ) {
<a name="l00289"></a>00289 KABC::PhoneNumber number( value, KABC::PhoneNumber::Pager );
<a name="l00290"></a>00290 a.insertPhoneNumber( number );
<a name="l00291"></a>00291 }
<a name="l00292"></a>00292 <span class="keywordflow">break</span>;
<a name="l00293"></a>00293
<a name="l00294"></a>00294 <span class="keywordflow">case</span> HomeAddressStreet:
<a name="l00295"></a>00295 addrHome.setStreet( value );
<a name="l00296"></a>00296 <span class="keywordflow">break</span>;
<a name="l00297"></a>00297 <span class="keywordflow">case</span> HomeAddressLocality:
<a name="l00298"></a>00298 addrHome.setLocality( value );
<a name="l00299"></a>00299 <span class="keywordflow">break</span>;
<a name="l00300"></a>00300 <span class="keywordflow">case</span> HomeAddressRegion:
<a name="l00301"></a>00301 addrHome.setRegion( value );
<a name="l00302"></a>00302 <span class="keywordflow">break</span>;
<a name="l00303"></a>00303 <span class="keywordflow">case</span> HomeAddressPostalCode:
<a name="l00304"></a>00304 addrHome.setPostalCode( value );
<a name="l00305"></a>00305 <span class="keywordflow">break</span>;
<a name="l00306"></a>00306 <span class="keywordflow">case</span> HomeAddressCountry:
<a name="l00307"></a>00307 addrHome.setCountry( value );
<a name="l00308"></a>00308 <span class="keywordflow">break</span>;
<a name="l00309"></a>00309 <span class="keywordflow">case</span> HomeAddressLabel:
<a name="l00310"></a>00310 addrHome.setLabel( value );
<a name="l00311"></a>00311 <span class="keywordflow">break</span>;
<a name="l00312"></a>00312
<a name="l00313"></a>00313 <span class="keywordflow">case</span> BusinessAddressStreet:
<a name="l00314"></a>00314 addrWork.setStreet( value );
<a name="l00315"></a>00315 <span class="keywordflow">break</span>;
<a name="l00316"></a>00316 <span class="keywordflow">case</span> BusinessAddressLocality:
<a name="l00317"></a>00317 addrWork.setLocality( value );
<a name="l00318"></a>00318 <span class="keywordflow">break</span>;
<a name="l00319"></a>00319 <span class="keywordflow">case</span> BusinessAddressRegion:
<a name="l00320"></a>00320 addrWork.setRegion( value );
<a name="l00321"></a>00321 <span class="keywordflow">break</span>;
<a name="l00322"></a>00322 <span class="keywordflow">case</span> BusinessAddressPostalCode:
<a name="l00323"></a>00323 addrWork.setPostalCode( value );
<a name="l00324"></a>00324 <span class="keywordflow">break</span>;
<a name="l00325"></a>00325 <span class="keywordflow">case</span> BusinessAddressCountry:
<a name="l00326"></a>00326 addrWork.setCountry( value );
<a name="l00327"></a>00327 <span class="keywordflow">break</span>;
<a name="l00328"></a>00328 <span class="keywordflow">case</span> BusinessAddressLabel:
<a name="l00329"></a>00329 addrWork.setLabel( value );
<a name="l00330"></a>00330 <span class="keywordflow">break</span>;
<a name="l00331"></a>00331 <span class="keywordflow">default</span>:
<a name="l00332"></a>00332 KABC::Field::List fields = mAddressBook->fields( KABC::Field::CustomCategory );
<a name="l00333"></a>00333 KABC::Field::List::Iterator it;
<a name="l00334"></a>00334
<a name="l00335"></a>00335 <span class="keywordtype">int</span> counter = 0;
<a name="l00336"></a>00336 <span class="keywordflow">for</span> ( it = fields.begin(); it != fields.end(); ++it ) {
<a name="l00337"></a>00337 <span class="keywordflow">if</span> ( counter == (<span class="keywordtype">int</span>)( posToType( item->currentItem() ) - mCustomCounter ) ) {
<a name="l00338"></a>00338 (*it)->setValue( a, value );
<a name="l00339"></a>00339 <span class="keywordflow">break</span>;
<a name="l00340"></a>00340 }
<a name="l00341"></a>00341 ++counter;
<a name="l00342"></a>00342 }
<a name="l00343"></a>00343 <span class="keywordflow">break</span>;
<a name="l00344"></a>00344 }
<a name="l00345"></a>00345 }
<a name="l00346"></a>00346
<a name="l00347"></a>00347 kapp->processEvents();
<a name="l00348"></a>00348
<a name="l00349"></a>00349 <span class="keywordflow">if</span> ( progressDialog.wasCancelled() )
<a name="l00350"></a>00350 <span class="keywordflow">return</span> KABC::AddresseeList();
<a name="l00351"></a>00351
<a name="l00352"></a>00352 progressDialog.progressBar()->advance( 1 );
<a name="l00353"></a>00353
<a name="l00354"></a>00354 <span class="keywordflow">if</span> ( !addrHome.isEmpty() )
<a name="l00355"></a>00355 a.insertAddress( addrHome );
<a name="l00356"></a>00356 <span class="keywordflow">if</span> ( !addrWork.isEmpty() )
<a name="l00357"></a>00357 a.insertAddress( addrWork );
<a name="l00358"></a>00358
<a name="l00359"></a>00359 <span class="keywordflow">if</span> ( !emptyRow && !a.isEmpty() )
<a name="l00360"></a>00360 contacts.append( a );
<a name="l00361"></a>00361 }
<a name="l00362"></a>00362
<a name="l00363"></a>00363 <span class="keywordflow">return</span> contacts;
<a name="l00364"></a>00364 }
<a name="l00365"></a>00365
<a name="l00366"></a>00366 <span class="keywordtype">void</span> CSVImportDialog::initGUI()
<a name="l00367"></a>00367 {
<a name="l00368"></a>00368 mPage = plainPage();
<a name="l00369"></a>00369
<a name="l00370"></a>00370 QGridLayout *layout = <span class="keyword">new</span> QGridLayout( mPage, 1, 1, marginHint(),
<a name="l00371"></a>00371 spacingHint() );
<a name="l00372"></a>00372 QHBoxLayout *hbox = <span class="keyword">new</span> QHBoxLayout();
<a name="l00373"></a>00373 hbox->setSpacing( spacingHint() );
<a name="l00374"></a>00374
<a name="l00375"></a>00375 QLabel *label = <span class="keyword">new</span> QLabel( i18n( <span class="stringliteral">"File to import:"</span> ), mPage );
<a name="l00376"></a>00376 hbox->addWidget( label );
<a name="l00377"></a>00377
<a name="l00378"></a>00378 mUrlRequester = <span class="keyword">new</span> KURLRequester( mPage );
<a name="l00379"></a>00379 mUrlRequester->setFilter( <span class="stringliteral">"*.csv"</span> );
<a name="l00380"></a>00380 hbox->addWidget( mUrlRequester );
<a name="l00381"></a>00381
<a name="l00382"></a>00382 layout->addMultiCellLayout( hbox, 0, 0, 0, 4 );
<a name="l00383"></a>00383
<a name="l00384"></a>00384 <span class="comment">// Delimiter: comma, semicolon, tab, space, other</span>
<a name="l00385"></a>00385 mDelimiterBox = <span class="keyword">new</span> QButtonGroup( i18n( <span class="stringliteral">"Delimiter"</span> ), mPage );
<a name="l00386"></a>00386 mDelimiterBox->setColumnLayout( 0, Qt::Vertical );
<a name="l00387"></a>00387 mDelimiterBox->layout()->setSpacing( spacingHint() );
<a name="l00388"></a>00388 mDelimiterBox->layout()->setMargin( marginHint() );
<a name="l00389"></a>00389 QGridLayout *delimiterLayout = <span class="keyword">new</span> QGridLayout( mDelimiterBox->layout() );
<a name="l00390"></a>00390 delimiterLayout->setAlignment( Qt::AlignTop );
<a name="l00391"></a>00391 layout->addMultiCellWidget( mDelimiterBox, 1, 4, 0, 0 );
<a name="l00392"></a>00392
<a name="l00393"></a>00393 mRadioComma = <span class="keyword">new</span> QRadioButton( i18n( <span class="stringliteral">"Comma"</span> ), mDelimiterBox );
<a name="l00394"></a>00394 mRadioComma->setChecked( <span class="keyword">true</span> );
<a name="l00395"></a>00395 delimiterLayout->addWidget( mRadioComma, 0, 0 );
<a name="l00396"></a>00396
<a name="l00397"></a>00397 mRadioSemicolon = <span class="keyword">new</span> QRadioButton( i18n( <span class="stringliteral">"Semicolon"</span> ), mDelimiterBox );
<a name="l00398"></a>00398 delimiterLayout->addWidget( mRadioSemicolon, 0, 1 );
<a name="l00399"></a>00399
<a name="l00400"></a>00400 mRadioTab = <span class="keyword">new</span> QRadioButton( i18n( <span class="stringliteral">"Tabulator"</span> ), mDelimiterBox );
<a name="l00401"></a>00401 delimiterLayout->addWidget( mRadioTab, 1, 0 );
<a name="l00402"></a>00402
<a name="l00403"></a>00403 mRadioSpace = <span class="keyword">new</span> QRadioButton( i18n( <span class="stringliteral">"Space"</span> ), mDelimiterBox );
<a name="l00404"></a>00404 delimiterLayout->addWidget( mRadioSpace, 1, 1 );
<a name="l00405"></a>00405
<a name="l00406"></a>00406 mRadioOther = <span class="keyword">new</span> QRadioButton( i18n( <span class="stringliteral">"Other"</span> ), mDelimiterBox );
<a name="l00407"></a>00407 delimiterLayout->addWidget( mRadioOther, 0, 2 );
<a name="l00408"></a>00408
<a name="l00409"></a>00409 mDelimiterEdit = <span class="keyword">new</span> QLineEdit( mDelimiterBox );
<a name="l00410"></a>00410 delimiterLayout->addWidget( mDelimiterEdit, 1, 2 );
<a name="l00411"></a>00411
<a name="l00412"></a>00412 mComboLine = <span class="keyword">new</span> QComboBox( <span class="keyword">false</span>, mPage );
<a name="l00413"></a>00413 mComboLine->insertItem( i18n( <span class="stringliteral">"1"</span> ) );
<a name="l00414"></a>00414 layout->addWidget( mComboLine, 2, 3 );
<a name="l00415"></a>00415
<a name="l00416"></a>00416 mComboQuote = <span class="keyword">new</span> QComboBox( <span class="keyword">false</span>, mPage );
<a name="l00417"></a>00417 mComboQuote->insertItem( i18n( <span class="stringliteral">"\""</span> ), 0 );
<a name="l00418"></a>00418 mComboQuote->insertItem( i18n( <span class="stringliteral">"'"</span> ), 1 );
<a name="l00419"></a>00419 mComboQuote->insertItem( i18n( <span class="stringliteral">"None"</span> ), 2 );
<a name="l00420"></a>00420 layout->addWidget( mComboQuote, 2, 2 );
<a name="l00421"></a>00421
<a name="l00422"></a>00422 mDatePatternEdit = <span class="keyword">new</span> QLineEdit( mPage );
<a name="l00423"></a>00423 mDatePatternEdit->setText( <span class="stringliteral">"Y-M-D"</span> ); <span class="comment">// ISO 8601 format as default</span>
<a name="l00424"></a>00424 QToolTip::add( mDatePatternEdit, i18n( <span class="stringliteral">"<ul><li>y: year with 2 digits</li>"</span>
<a name="l00425"></a>00425 <span class="stringliteral">"<li>Y: year with 4 digits</li>"</span>
<a name="l00426"></a>00426 <span class="stringliteral">"<li>m: month with 1 or 2 digits</li>"</span>
<a name="l00427"></a>00427 <span class="stringliteral">"<li>M: month with 2 digits</li>"</span>
<a name="l00428"></a>00428 <span class="stringliteral">"<li>d: day with 1 or 2 digits</li>"</span>
<a name="l00429"></a>00429 <span class="stringliteral">"<li>D: day with 2 digits</li></ul>"</span> ) );
<a name="l00430"></a>00430 layout->addWidget( mDatePatternEdit, 2, 4 );
<a name="l00431"></a>00431
<a name="l00432"></a>00432 label = <span class="keyword">new</span> QLabel( i18n( <span class="stringliteral">"Start at line:"</span> ), mPage );
<a name="l00433"></a>00433 layout->addWidget( label, 1, 3 );
<a name="l00434"></a>00434
<a name="l00435"></a>00435 label = <span class="keyword">new</span> QLabel( i18n( <span class="stringliteral">"Textquote:"</span> ), mPage );
<a name="l00436"></a>00436 layout->addWidget( label, 1, 2 );
<a name="l00437"></a>00437
<a name="l00438"></a>00438 label = <span class="keyword">new</span> QLabel( i18n( <span class="stringliteral">"Date format:"</span> ), mPage );
<a name="l00439"></a>00439 layout->addWidget( label, 1, 4 );
<a name="l00440"></a>00440
<a name="l00441"></a>00441 mIgnoreDuplicates = <span class="keyword">new</span> QCheckBox( mPage );
<a name="l00442"></a>00442 mIgnoreDuplicates->setText( i18n( <span class="stringliteral">"Ignore duplicate delimiters"</span> ) );
<a name="l00443"></a>00443 layout->addMultiCellWidget( mIgnoreDuplicates, 3, 3, 2, 4 );
<a name="l00444"></a>00444
<a name="l00445"></a>00445 mCodecCombo = <span class="keyword">new</span> QComboBox( mPage );
<a name="l00446"></a>00446 layout->addMultiCellWidget( mCodecCombo, 4, 4, 2, 4 );
<a name="l00447"></a>00447
<a name="l00448"></a>00448 mTable = <span class="keyword">new</span> QTable( 0, 0, mPage );
<a name="l00449"></a>00449 mTable->setSelectionMode( QTable::NoSelection );
<a name="l00450"></a>00450 mTable->horizontalHeader()->hide();
<a name="l00451"></a>00451 layout->addMultiCellWidget( mTable, 5, 5, 0, 4 );
<a name="l00452"></a>00452
<a name="l00453"></a>00453 setButtonText( User1, i18n( <span class="stringliteral">"Apply Template..."</span> ) );
<a name="l00454"></a>00454 setButtonText( User2, i18n( <span class="stringliteral">"Save Template..."</span> ) );
<a name="l00455"></a>00455
<a name="l00456"></a>00456 enableButtonOK( <span class="keyword">false</span> );
<a name="l00457"></a>00457 actionButton( User1 )->setEnabled( <span class="keyword">false</span> );
<a name="l00458"></a>00458 actionButton( User2 )->setEnabled( <span class="keyword">false</span> );
<a name="l00459"></a>00459
<a name="l00460"></a>00460 resize( 400, 300 );
<a name="l00461"></a>00461 }
<a name="l00462"></a>00462
<a name="l00463"></a>00463 <span class="keywordtype">void</span> CSVImportDialog::fillTable()
<a name="l00464"></a>00464 {
<a name="l00465"></a>00465 <span class="keywordtype">int</span> row, column;
<a name="l00466"></a>00466 <span class="keywordtype">bool</span> lastCharDelimiter = <span class="keyword">false</span>;
<a name="l00467"></a>00467 <span class="keywordtype">bool</span> ignoreDups = mIgnoreDuplicates->isChecked();
<a name="l00468"></a>00468 <span class="keyword">enum</span> { S_START, S_QUOTED_FIELD, S_MAYBE_END_OF_QUOTED_FIELD, S_END_OF_QUOTED_FIELD,
<a name="l00469"></a>00469 S_MAYBE_NORMAL_FIELD, S_NORMAL_FIELD } state = S_START;
<a name="l00470"></a>00470
<a name="l00471"></a>00471 QChar x;
<a name="l00472"></a>00472 QString field;
<a name="l00473"></a>00473
<a name="l00474"></a>00474 <span class="comment">// store previous assignment</span>
<a name="l00475"></a>00475 mTypeStore.clear();
<a name="l00476"></a>00476 <span class="keywordflow">for</span> ( column = 0; column < mTable->numCols(); ++column ) {
<a name="l00477"></a>00477 QComboTableItem *item = <span class="keyword">static_cast<</span>QComboTableItem*<span class="keyword">></span>( mTable->item( 0,
<a name="l00478"></a>00478 column ) );
<a name="l00479"></a>00479 <span class="keywordflow">if</span> ( !item || mClearTypeStore )
<a name="l00480"></a>00480 mTypeStore.append( typeToPos( Undefined ) );
<a name="l00481"></a>00481 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( item )
<a name="l00482"></a>00482 mTypeStore.append( item->currentItem() );
<a name="l00483"></a>00483 }
<a name="l00484"></a>00484
<a name="l00485"></a>00485 clearTable();
<a name="l00486"></a>00486
<a name="l00487"></a>00487 row = column = 1;
<a name="l00488"></a>00488
<a name="l00489"></a>00489 QTextStream inputStream( mFileArray, IO_ReadOnly );
<a name="l00490"></a>00490
<a name="l00491"></a>00491 <span class="comment">// find the current codec</span>
<a name="l00492"></a>00492 <span class="keywordtype">int</span> code = mCodecCombo->currentItem();
<a name="l00493"></a>00493 <span class="keywordflow">if</span> ( code == Local )
<a name="l00494"></a>00494 inputStream.setEncoding( QTextStream::Locale );
<a name="l00495"></a>00495 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( code >= Codec )
<a name="l00496"></a>00496 inputStream.setCodec( mCodecs.at( code - Codec ) );
<a name="l00497"></a>00497 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( code == Uni )
<a name="l00498"></a>00498 inputStream.setEncoding( QTextStream::Unicode );
<a name="l00499"></a>00499 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( code == MSBug )
<a name="l00500"></a>00500 inputStream.setEncoding( QTextStream::UnicodeReverse );
<a name="l00501"></a>00501 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( code == Latin1 )
<a name="l00502"></a>00502 inputStream.setEncoding( QTextStream::Latin1 );
<a name="l00503"></a>00503 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( code == Guess ) {
<a name="l00504"></a>00504 QTextCodec* codec = QTextCodec::codecForContent( mFileArray.data(), mFileArray.size() );
<a name="l00505"></a>00505 <span class="keywordflow">if</span> ( codec ) {
<a name="l00506"></a>00506 KMessageBox::information( <span class="keyword">this</span>, i18n( <span class="stringliteral">"Using codec '%1'"</span> ).arg( codec->name() ), i18n( <span class="stringliteral">"Encoding"</span> ) );
<a name="l00507"></a>00507 inputStream.setCodec( codec );
<a name="l00508"></a>00508 }
<a name="l00509"></a>00509 }
<a name="l00510"></a>00510
<a name="l00511"></a>00511 <span class="keywordtype">int</span> maxColumn = 0;
<a name="l00512"></a>00512 <span class="keywordflow">while</span> ( !inputStream.atEnd() ) {
<a name="l00513"></a>00513 inputStream >> x; <span class="comment">// read one char</span>
<a name="l00514"></a>00514
<a name="l00515"></a>00515 <span class="keywordflow">if</span> ( x == <span class="charliteral">'\r'</span> ) inputStream >> x; <span class="comment">// eat '\r', to handle DOS/LOSEDOWS files correctly</span>
<a name="l00516"></a>00516
<a name="l00517"></a>00517 <span class="keywordflow">switch</span> ( state ) {
<a name="l00518"></a>00518 <span class="keywordflow">case</span> S_START :
<a name="l00519"></a>00519 <span class="keywordflow">if</span> ( x == mTextQuote ) {
<a name="l00520"></a>00520 state = S_QUOTED_FIELD;
<a name="l00521"></a>00521 } <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( x == mDelimiter ) {
<a name="l00522"></a>00522 <span class="keywordflow">if</span> ( ( ignoreDups == <span class="keyword">false</span> ) || ( lastCharDelimiter == false ) )
<a name="l00523"></a>00523 ++column;
<a name="l00524"></a>00524 lastCharDelimiter = <span class="keyword">true</span>;
<a name="l00525"></a>00525 } <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( x == <span class="charliteral">'\n'</span> ) {
<a name="l00526"></a>00526 ++row;
<a name="l00527"></a>00527 column = 1;
<a name="l00528"></a>00528 } <span class="keywordflow">else</span> {
<a name="l00529"></a>00529 field += x;
<a name="l00530"></a>00530 state = S_MAYBE_NORMAL_FIELD;
<a name="l00531"></a>00531 }
<a name="l00532"></a>00532 <span class="keywordflow">break</span>;
<a name="l00533"></a>00533 <span class="keywordflow">case</span> S_QUOTED_FIELD :
<a name="l00534"></a>00534 <span class="keywordflow">if</span> ( x == mTextQuote ) {
<a name="l00535"></a>00535 state = S_MAYBE_END_OF_QUOTED_FIELD;
<a name="l00536"></a>00536 } <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( x == <span class="charliteral">'\n'</span> && mTextQuote.isNull() ) {
<a name="l00537"></a>00537 setText( row - mStartLine + 1, column, field );
<a name="l00538"></a>00538 field = <span class="stringliteral">""</span>;
<a name="l00539"></a>00539 <span class="keywordflow">if</span> ( x == <span class="charliteral">'\n'</span> ) {
<a name="l00540"></a>00540 ++row;
<a name="l00541"></a>00541 column = 1;
<a name="l00542"></a>00542 } <span class="keywordflow">else</span> {
<a name="l00543"></a>00543 <span class="keywordflow">if</span> ( ( ignoreDups == <span class="keyword">false</span> ) || ( lastCharDelimiter == <span class="keyword">false</span> ) )
<a name="l00544"></a>00544 ++column;
<a name="l00545"></a>00545 lastCharDelimiter = <span class="keyword">true</span>;
<a name="l00546"></a>00546 }
<a name="l00547"></a>00547 state = S_START;
<a name="l00548"></a>00548 } <span class="keywordflow">else</span> {
<a name="l00549"></a>00549 field += x;
<a name="l00550"></a>00550 }
<a name="l00551"></a>00551 <span class="keywordflow">break</span>;
<a name="l00552"></a>00552 <span class="keywordflow">case</span> S_MAYBE_END_OF_QUOTED_FIELD :
<a name="l00553"></a>00553 <span class="keywordflow">if</span> ( x == mTextQuote ) {
<a name="l00554"></a>00554 field += x;
<a name="l00555"></a>00555 state = S_QUOTED_FIELD;
<a name="l00556"></a>00556 } <span class="keywordflow">else</span> <span class="keywordflow">if</span> ( x == mDelimiter || x == <span class="charliteral">'\n'</span> ) {
<a name="l00557"></a>00557 setText( row - mStartLine + 1, column, field );
<a name="l00558"></a>00558 field = <span class="stringliteral">""</span>;
<a name="l00559"></a>00559 <span class="keywordflow">if</span> ( x == <span class="charliteral">'\n'</span> ) {
<a name="l00560"></a>00560 ++row;
<a name="l00561"></a>00561 column = 1;
<a name="l00562"></a>00562 } <span class="keywordflow">else</span> {
<a name="l00563"></a>00563 <span class="keywordflow">if</span> ( ( ignoreDups == <span class="keyword">false</span> ) || ( lastCharDelimiter == <span class="keyword">false</span> ) )
<a name="l00564"></a>00564 ++column;
<a name="l00565"></a>00565 lastCharDelimiter = <span class="keyword">true</span>;
<a name="l00566"></a>00566 }
<a name="l00567"></a>00567 state = S_START;
<a name="l00568"></a>00568 } <span class="keywordflow">else</span> {
<a name="l00569"></a>00569 state = S_END_OF_QUOTED_FIELD;
<a name="l00570"></a>00570 }
<a name="l00571"></a>00571 <span class="keywordflow">break</span>;
<a name="l00572"></a>00572 <span class="keywordflow">case</span> S_END_OF_QUOTED_FIELD :
<a name="l00573"></a>00573 <span class="keywordflow">if</span> ( x == mDelimiter || x == <span class="charliteral">'\n'</span> ) {
<a name="l00574"></a>00574 setText( row - mStartLine + 1, column, field );
<a name="l00575"></a>00575 field = <span class="stringliteral">""</span>;
<a name="l00576"></a>00576 <span class="keywordflow">if</span> ( x == <span class="charliteral">'\n'</span> ) {
<a name="l00577"></a>00577 ++row;
<a name="l00578"></a>00578 column = 1;
<a name="l00579"></a>00579 } <span class="keywordflow">else</span> {
<a name="l00580"></a>00580 <span class="keywordflow">if</span> ( ( ignoreDups == <span class="keyword">false</span> ) || ( lastCharDelimiter == <span class="keyword">false</span> ) )
<a name="l00581"></a>00581 ++column;
<a name="l00582"></a>00582 lastCharDelimiter = <span class="keyword">true</span>;
<a name="l00583"></a>00583 }
<a name="l00584"></a>00584 state = S_START;
<a name="l00585"></a>00585 } <span class="keywordflow">else</span> {
<a name="l00586"></a>00586 state = S_END_OF_QUOTED_FIELD;
<a name="l00587"></a>00587 }
<a name="l00588"></a>00588 <span class="keywordflow">break</span>;
<a name="l00589"></a>00589 <span class="keywordflow">case</span> S_MAYBE_NORMAL_FIELD :
<a name="l00590"></a>00590 <span class="keywordflow">if</span> ( x == mTextQuote ) {
<a name="l00591"></a>00591 field = <span class="stringliteral">""</span>;
<a name="l00592"></a>00592 state = S_QUOTED_FIELD;
<a name="l00593"></a>00593 <span class="keywordflow">break</span>;
<a name="l00594"></a>00594 }
<a name="l00595"></a>00595 <span class="keywordflow">case</span> S_NORMAL_FIELD :
<a name="l00596"></a>00596 <span class="keywordflow">if</span> ( x == mDelimiter || x == <span class="charliteral">'\n'</span> ) {
<a name="l00597"></a>00597 setText( row - mStartLine + 1, column, field );
<a name="l00598"></a>00598 field = <span class="stringliteral">""</span>;
<a name="l00599"></a>00599 <span class="keywordflow">if</span> ( x == <span class="charliteral">'\n'</span> ) {
<a name="l00600"></a>00600 ++row;
<a name="l00601"></a>00601 column = 1;
<a name="l00602"></a>00602 } <span class="keywordflow">else</span> {
<a name="l00603"></a>00603 <span class="keywordflow">if</span> ( ( ignoreDups == <span class="keyword">false</span> ) || ( lastCharDelimiter == <span class="keyword">false</span> ) )
<a name="l00604"></a>00604 ++column;
<a name="l00605"></a>00605 lastCharDelimiter = <span class="keyword">true</span>;
<a name="l00606"></a>00606 }
<a name="l00607"></a>00607 state = S_START;
<a name="l00608"></a>00608 } <span class="keywordflow">else</span> {
<a name="l00609"></a>00609 field += x;
<a name="l00610"></a>00610 }
<a name="l00611"></a>00611 }
<a name="l00612"></a>00612 <span class="keywordflow">if</span> ( x != mDelimiter )
<a name="l00613"></a>00613 lastCharDelimiter = <span class="keyword">false</span>;
<a name="l00614"></a>00614
<a name="l00615"></a>00615 <span class="keywordflow">if</span> ( column > maxColumn )
<a name="l00616"></a>00616 maxColumn = column;
<a name="l00617"></a>00617 }
<a name="l00618"></a>00618
<a name="l00619"></a>00619 <span class="comment">// file with only one line without '\n'</span>
<a name="l00620"></a>00620 <span class="keywordflow">if</span> ( field.length() > 0 ) {
<a name="l00621"></a>00621 setText( row - mStartLine + 1, column, field );
<a name="l00622"></a>00622 ++row;
<a name="l00623"></a>00623 field = <span class="stringliteral">""</span>;
<a name="l00624"></a>00624 }
<a name="l00625"></a>00625
<a name="l00626"></a>00626 adjustRows( row - mStartLine );
<a name="l00627"></a>00627 mTable->setNumCols( maxColumn );
<a name="l00628"></a>00628
<a name="l00629"></a>00629 <span class="keywordflow">for</span> ( column = 0; column < mTable->numCols(); ++column ) {
<a name="l00630"></a>00630 QComboTableItem *item = <span class="keyword">new</span> QComboTableItem( mTable, mTypeMap.keys() );
<a name="l00631"></a>00631 mTable->setItem( 0, column, item );
<a name="l00632"></a>00632 <span class="keywordflow">if</span> ( column < (<span class="keywordtype">int</span>)mTypeStore.count() )
<a name="l00633"></a>00633 item->setCurrentItem( mTypeStore[ column ] );
<a name="l00634"></a>00634 <span class="keywordflow">else</span>
<a name="l00635"></a>00635 item->setCurrentItem( typeToPos( Undefined ) );
<a name="l00636"></a>00636 mTable->adjustColumn( column );
<a name="l00637"></a>00637 }
<a name="l00638"></a>00638
<a name="l00639"></a>00639 resizeColumns();
<a name="l00640"></a>00640 }
<a name="l00641"></a>00641
<a name="l00642"></a>00642 <span class="keywordtype">void</span> CSVImportDialog::clearTable()
<a name="l00643"></a>00643 {
<a name="l00644"></a>00644 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> row = 0; row < mTable->numRows(); ++row )
<a name="l00645"></a>00645 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> column = 0; column < mTable->numCols(); ++column )
<a name="l00646"></a>00646 mTable->clearCell( row, column );
<a name="l00647"></a>00647 }
<a name="l00648"></a>00648
<a name="l00649"></a>00649 <span class="keywordtype">void</span> CSVImportDialog::fillComboBox()
<a name="l00650"></a>00650 {
<a name="l00651"></a>00651 mComboLine->clear();
<a name="l00652"></a>00652 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> row = 1; row < mTable->numRows() + 1; ++row )
<a name="l00653"></a>00653 mComboLine->insertItem( QString::number( row ), row - 1 );
<a name="l00654"></a>00654 }
<a name="l00655"></a>00655
<a name="l00656"></a>00656 <span class="keywordtype">void</span> CSVImportDialog::reloadCodecs()
<a name="l00657"></a>00657 {
<a name="l00658"></a>00658 mCodecCombo->clear();
<a name="l00659"></a>00659
<a name="l00660"></a>00660 mCodecs.clear();
<a name="l00661"></a>00661
<a name="l00662"></a>00662 QTextCodec *codec;
<a name="l00663"></a>00663 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> i = 0; ( codec = QTextCodec::codecForIndex( i ) ); i++ )
<a name="l00664"></a>00664 mCodecs.append( codec );
<a name="l00665"></a>00665
<a name="l00666"></a>00666 mCodecCombo->insertItem( i18n( <span class="stringliteral">"Local (%1)"</span> ).arg( QTextCodec::codecForLocale()->name() ), Local );
<a name="l00667"></a>00667 mCodecCombo->insertItem( i18n( <span class="stringliteral">"[guess]"</span> ), Guess );
<a name="l00668"></a>00668 mCodecCombo->insertItem( i18n( <span class="stringliteral">"Latin1"</span> ), Latin1 );
<a name="l00669"></a>00669 mCodecCombo->insertItem( i18n( <span class="stringliteral">"Unicode"</span> ), Uni );
<a name="l00670"></a>00670 mCodecCombo->insertItem( i18n( <span class="stringliteral">"Microsoft Unicode"</span> ), MSBug );
<a name="l00671"></a>00671
<a name="l00672"></a>00672 <span class="keywordflow">for</span> ( uint i = 0; i < mCodecs.count(); i++ )
<a name="l00673"></a>00673 mCodecCombo->insertItem( mCodecs.at( i )->name(), Codec + i );
<a name="l00674"></a>00674 }
<a name="l00675"></a>00675
<a name="l00676"></a>00676 <span class="keywordtype">void</span> CSVImportDialog::setText( <span class="keywordtype">int</span> row, <span class="keywordtype">int</span> col, <span class="keyword">const</span> QString& text )
<a name="l00677"></a>00677 {
<a name="l00678"></a>00678 <span class="keywordflow">if</span> ( row < 1 ) <span class="comment">// skipped by the user</span>
<a name="l00679"></a>00679 <span class="keywordflow">return</span>;
<a name="l00680"></a>00680
<a name="l00681"></a>00681 <span class="keywordflow">if</span> ( mTable->numRows() < row ) {
<a name="l00682"></a>00682 mTable->setNumRows( row + 5000 ); <span class="comment">// We add 5000 at a time to limit recalculations</span>
<a name="l00683"></a>00683 mAdjustRows = <span class="keyword">true</span>;
<a name="l00684"></a>00684 }
<a name="l00685"></a>00685
<a name="l00686"></a>00686 <span class="keywordflow">if</span> ( mTable->numCols() < col )
<a name="l00687"></a>00687 mTable->setNumCols( col + 50 ); <span class="comment">// We add 50 at a time to limit recalculation</span>
<a name="l00688"></a>00688
<a name="l00689"></a>00689 mTable->setText( row - 1, col - 1, text );
<a name="l00690"></a>00690 }
<a name="l00691"></a>00691
<a name="l00692"></a>00692 <span class="comment">/*</span>
<a name="l00693"></a>00693 <span class="comment"> * Called after the first fillTable() when number of rows are unknown.</span>
<a name="l00694"></a>00694 <span class="comment"> */</span>
<a name="l00695"></a>00695 <span class="keywordtype">void</span> CSVImportDialog::adjustRows( <span class="keywordtype">int</span> rows )
<a name="l00696"></a>00696 {
<a name="l00697"></a>00697 <span class="keywordflow">if</span> ( mAdjustRows ) {
<a name="l00698"></a>00698 mTable->setNumRows( rows );
<a name="l00699"></a>00699 mAdjustRows = <span class="keyword">false</span>;
<a name="l00700"></a>00700 }
<a name="l00701"></a>00701 }
<a name="l00702"></a>00702
<a name="l00703"></a>00703 <span class="keywordtype">void</span> CSVImportDialog::resizeColumns()
<a name="l00704"></a>00704 {
<a name="l00705"></a>00705 QFontMetrics fm = fontMetrics();
<a name="l00706"></a>00706 <span class="keywordtype">int</span> width = 0;
<a name="l00707"></a>00707
<a name="l00708"></a>00708 QMap<QString, uint>::ConstIterator it;
<a name="l00709"></a>00709 <span class="keywordflow">for</span> ( it = mTypeMap.begin(); it != mTypeMap.end(); ++it ) {
<a name="l00710"></a>00710 width = QMAX( width, fm.width( it.key() ) );
<a name="l00711"></a>00711 }
<a name="l00712"></a>00712
<a name="l00713"></a>00713 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> i = 0; i < mTable->numCols(); ++i )
<a name="l00714"></a>00714 mTable->setColumnWidth( i, QMAX( width + 15, mTable->columnWidth( i ) ) );
<a name="l00715"></a>00715 }
<a name="l00716"></a>00716
<a name="l00717"></a>00717 <span class="keywordtype">void</span> CSVImportDialog::returnPressed()
<a name="l00718"></a>00718 {
<a name="l00719"></a>00719 <span class="keywordflow">if</span> ( mDelimiterBox->id( mDelimiterBox->selected() ) != 4 )
<a name="l00720"></a>00720 <span class="keywordflow">return</span>;
<a name="l00721"></a>00721
<a name="l00722"></a>00722 mDelimiter = mDelimiterEdit->text();
<a name="l00723"></a>00723 fillTable();
<a name="l00724"></a>00724 }
<a name="l00725"></a>00725
<a name="l00726"></a>00726 <span class="keywordtype">void</span> CSVImportDialog::textChanged ( <span class="keyword">const</span> QString& )
<a name="l00727"></a>00727 {
<a name="l00728"></a>00728 mRadioOther->setChecked ( <span class="keyword">true</span> );
<a name="l00729"></a>00729 delimiterClicked( 4 ); <span class="comment">// other</span>
<a name="l00730"></a>00730 }
<a name="l00731"></a>00731
<a name="l00732"></a>00732 <span class="keywordtype">void</span> CSVImportDialog::delimiterClicked( <span class="keywordtype">int</span> <span class="keywordtype">id</span> )
<a name="l00733"></a>00733 {
<a name="l00734"></a>00734 <span class="keywordflow">switch</span> ( <span class="keywordtype">id</span> ) {
<a name="l00735"></a>00735 <span class="keywordflow">case</span> 0: <span class="comment">// comma</span>
<a name="l00736"></a>00736 mDelimiter = <span class="stringliteral">","</span>;
<a name="l00737"></a>00737 <span class="keywordflow">break</span>;
<a name="l00738"></a>00738 <span class="keywordflow">case</span> 4: <span class="comment">// other</span>
<a name="l00739"></a>00739 mDelimiter = mDelimiterEdit->text();
<a name="l00740"></a>00740 <span class="keywordflow">break</span>;
<a name="l00741"></a>00741 <span class="keywordflow">case</span> 2: <span class="comment">// tab</span>
<a name="l00742"></a>00742 mDelimiter = <span class="stringliteral">"\t"</span>;
<a name="l00743"></a>00743 <span class="keywordflow">break</span>;
<a name="l00744"></a>00744 <span class="keywordflow">case</span> 3: <span class="comment">// space</span>
<a name="l00745"></a>00745 mDelimiter = <span class="stringliteral">" "</span>;
<a name="l00746"></a>00746 <span class="keywordflow">break</span>;
<a name="l00747"></a>00747 <span class="keywordflow">case</span> 1: <span class="comment">// semicolon</span>
<a name="l00748"></a>00748 mDelimiter = <span class="stringliteral">";"</span>;
<a name="l00749"></a>00749 <span class="keywordflow">break</span>;
<a name="l00750"></a>00750 }
<a name="l00751"></a>00751
<a name="l00752"></a>00752 fillTable();
<a name="l00753"></a>00753 }
<a name="l00754"></a>00754
<a name="l00755"></a>00755 <span class="keywordtype">void</span> CSVImportDialog::textquoteSelected( <span class="keyword">const</span> QString& mark )
<a name="l00756"></a>00756 {
<a name="l00757"></a>00757 <span class="keywordflow">if</span> ( mComboQuote->currentItem() == 2 )
<a name="l00758"></a>00758 mTextQuote = 0;
<a name="l00759"></a>00759 <span class="keywordflow">else</span>
<a name="l00760"></a>00760 mTextQuote = mark[ 0 ];
<a name="l00761"></a>00761
<a name="l00762"></a>00762 fillTable();
<a name="l00763"></a>00763 }
<a name="l00764"></a>00764
<a name="l00765"></a>00765 <span class="keywordtype">void</span> CSVImportDialog::lineSelected( <span class="keyword">const</span> QString& line )
<a name="l00766"></a>00766 {
<a name="l00767"></a>00767 mStartLine = line.toInt() - 1;
<a name="l00768"></a>00768 fillTable();
<a name="l00769"></a>00769 }
<a name="l00770"></a>00770
<a name="l00771"></a>00771 <span class="keywordtype">void</span> CSVImportDialog::slotOk()
<a name="l00772"></a>00772 {
<a name="l00773"></a>00773 <span class="keywordtype">bool</span> assigned = <span class="keyword">false</span>;
<a name="l00774"></a>00774
<a name="l00775"></a>00775 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> column = 0; column < mTable->numCols(); ++column ) {
<a name="l00776"></a>00776 QComboTableItem *item = <span class="keyword">static_cast<</span>QComboTableItem*<span class="keyword">></span>( mTable->item( 0,
<a name="l00777"></a>00777 column ) );
<a name="l00778"></a>00778 <span class="keywordflow">if</span> ( item && posToType( item->currentItem() ) != Undefined )
<a name="l00779"></a>00779 assigned = <span class="keyword">true</span>;
<a name="l00780"></a>00780 }
<a name="l00781"></a>00781
<a name="l00782"></a>00782 <span class="keywordflow">if</span> ( assigned )
<a name="l00783"></a>00783 KDialogBase::slotOk();
<a name="l00784"></a>00784 <span class="keywordflow">else</span>
<a name="l00785"></a>00785 KMessageBox::sorry( <span class="keyword">this</span>, i18n( <span class="stringliteral">"You have to assign at least one column."</span> ) );
<a name="l00786"></a>00786 }
<a name="l00787"></a>00787
<a name="l00788"></a>00788 <span class="keywordtype">void</span> CSVImportDialog::applyTemplate()
<a name="l00789"></a>00789 {
<a name="l00790"></a>00790 QMap<uint,int> columnMap;
<a name="l00791"></a>00791 QMap<QString, QString> fileMap;
<a name="l00792"></a>00792 QStringList templates;
<a name="l00793"></a>00793
<a name="l00794"></a>00794 <span class="comment">// load all template files</span>
<a name="l00795"></a>00795 QStringList list = KGlobal::dirs()->findAllResources( <span class="stringliteral">"data"</span> , QString( kapp->name() ) +
<a name="l00796"></a>00796 <span class="stringliteral">"/csv-templates/*.desktop"</span>, <span class="keyword">true</span>, <span class="keyword">true</span> );
<a name="l00797"></a>00797
<a name="l00798"></a>00798 <span class="keywordflow">for</span> ( QStringList::iterator it = list.begin(); it != list.end(); ++it )
<a name="l00799"></a>00799 {
<a name="l00800"></a>00800 KSimpleConfig config( *it, <span class="keyword">true</span> );
<a name="l00801"></a>00801
<a name="l00802"></a>00802 <span class="keywordflow">if</span> ( !config.hasGroup( <span class="stringliteral">"csv column map"</span> ) )
<a name="l00803"></a>00803 <span class="keywordflow">continue</span>;
<a name="l00804"></a>00804
<a name="l00805"></a>00805 config.setGroup( <span class="stringliteral">"Misc"</span> );
<a name="l00806"></a>00806 templates.append( config.readEntry( <span class="stringliteral">"Name"</span> ) );
<a name="l00807"></a>00807 fileMap.insert( config.readEntry( <span class="stringliteral">"Name"</span> ), *it );
<a name="l00808"></a>00808 }
<a name="l00809"></a>00809
<a name="l00810"></a>00810 <span class="comment">// let the user chose, what to take</span>
<a name="l00811"></a>00811 <span class="keywordtype">bool</span> ok = <span class="keyword">false</span>;
<a name="l00812"></a>00812 QString tmp;
<a name="l00813"></a>00813 tmp = KInputDialog::getItem( i18n( <span class="stringliteral">"Template Selection"</span> ),
<a name="l00814"></a>00814 i18n( <span class="stringliteral">"Please select a template, that matches the CSV file:"</span> ),
<a name="l00815"></a>00815 templates, 0, <span class="keyword">false</span>, &ok, <span class="keyword">this</span> );
<a name="l00816"></a>00816
<a name="l00817"></a>00817 <span class="keywordflow">if</span> ( !ok )
<a name="l00818"></a>00818 <span class="keywordflow">return</span>;
<a name="l00819"></a>00819
<a name="l00820"></a>00820 KSimpleConfig config( fileMap[ tmp ], <span class="keyword">true</span> );
<a name="l00821"></a>00821 config.setGroup( <span class="stringliteral">"General"</span> );
<a name="l00822"></a>00822 mDatePatternEdit->setText( config.readEntry( <span class="stringliteral">"DatePattern"</span>, <span class="stringliteral">"Y-M-D"</span> ) );
<a name="l00823"></a>00823 uint numColumns = config.readUnsignedNumEntry( <span class="stringliteral">"Columns"</span> );
<a name="l00824"></a>00824 mDelimiterEdit->setText( config.readEntry( <span class="stringliteral">"DelimiterOther"</span> ) );
<a name="l00825"></a>00825 mDelimiterBox->setButton( config.readNumEntry( <span class="stringliteral">"DelimiterType"</span> ) );
<a name="l00826"></a>00826 delimiterClicked( config.readNumEntry( <span class="stringliteral">"DelimiterType"</span> ) );
<a name="l00827"></a>00827 <span class="keywordtype">int</span> quoteType = config.readNumEntry( <span class="stringliteral">"QuoteType"</span> );
<a name="l00828"></a>00828 mComboQuote->setCurrentItem( quoteType );
<a name="l00829"></a>00829 textquoteSelected( mComboQuote->currentText() );
<a name="l00830"></a>00830
<a name="l00831"></a>00831 <span class="comment">// create the column map</span>
<a name="l00832"></a>00832 config.setGroup( <span class="stringliteral">"csv column map"</span> );
<a name="l00833"></a>00833 <span class="keywordflow">for</span> ( uint i = 0; i < numColumns; ++i ) {
<a name="l00834"></a>00834 <span class="keywordtype">int</span> col = config.readNumEntry( QString::number( i ) );
<a name="l00835"></a>00835 columnMap.insert( i, col );
<a name="l00836"></a>00836 }
<a name="l00837"></a>00837
<a name="l00838"></a>00838 <span class="comment">// apply the column map</span>
<a name="l00839"></a>00839 <span class="keywordflow">for</span> ( uint column = 0; column < columnMap.count(); ++column ) {
<a name="l00840"></a>00840 <span class="keywordtype">int</span> type = columnMap[ column ];
<a name="l00841"></a>00841 QComboTableItem *item = <span class="keyword">static_cast<</span>QComboTableItem*<span class="keyword">></span>( mTable->item( 0,
<a name="l00842"></a>00842 column ) );
<a name="l00843"></a>00843 <span class="keywordflow">if</span> ( item )
<a name="l00844"></a>00844 item->setCurrentItem( typeToPos( type ) );
<a name="l00845"></a>00845 }
<a name="l00846"></a>00846 }
<a name="l00847"></a>00847
<a name="l00848"></a>00848 <span class="keywordtype">void</span> CSVImportDialog::saveTemplate()
<a name="l00849"></a>00849 {
<a name="l00850"></a>00850 QString fileName = KFileDialog::getSaveFileName(
<a name="l00851"></a>00851 locateLocal( <span class="stringliteral">"data"</span>, QString( kapp->name() ) + <span class="stringliteral">"/csv-templates/"</span> ),
<a name="l00852"></a>00852 <span class="stringliteral">"*.desktop"</span>, this );
<a name="l00853"></a>00853
<a name="l00854"></a>00854 <span class="keywordflow">if</span> ( fileName.isEmpty() )
<a name="l00855"></a>00855 <span class="keywordflow">return</span>;
<a name="l00856"></a>00856
<a name="l00857"></a>00857 <span class="keywordflow">if</span> ( !fileName.contains( <span class="stringliteral">".desktop"</span> ) )
<a name="l00858"></a>00858 fileName += <span class="stringliteral">".desktop"</span>;
<a name="l00859"></a>00859
<a name="l00860"></a>00860 QString name = KInputDialog::getText( i18n( <span class="stringliteral">"Template Name"</span> ), i18n( <span class="stringliteral">"Please enter a name for the template:"</span> ) );
<a name="l00861"></a>00861
<a name="l00862"></a>00862 <span class="keywordflow">if</span> ( name.isEmpty() )
<a name="l00863"></a>00863 <span class="keywordflow">return</span>;
<a name="l00864"></a>00864
<a name="l00865"></a>00865 KConfig config( fileName );
<a name="l00866"></a>00866 config.setGroup( <span class="stringliteral">"General"</span> );
<a name="l00867"></a>00867 config.writeEntry( <span class="stringliteral">"DatePattern"</span>, mDatePatternEdit->text() );
<a name="l00868"></a>00868 config.writeEntry( <span class="stringliteral">"Columns"</span>, mTable->numCols() );
<a name="l00869"></a>00869 config.writeEntry( <span class="stringliteral">"DelimiterType"</span>, mDelimiterBox->id( mDelimiterBox->selected() ) );
<a name="l00870"></a>00870 config.writeEntry( <span class="stringliteral">"DelimiterOther"</span>, mDelimiterEdit->text() );
<a name="l00871"></a>00871 config.writeEntry( <span class="stringliteral">"QuoteType"</span>, mComboQuote->currentItem() );
<a name="l00872"></a>00872
<a name="l00873"></a>00873 config.setGroup( <span class="stringliteral">"Misc"</span> );
<a name="l00874"></a>00874 config.writeEntry( <span class="stringliteral">"Name"</span>, name );
<a name="l00875"></a>00875
<a name="l00876"></a>00876 config.setGroup( <span class="stringliteral">"csv column map"</span> );
<a name="l00877"></a>00877
<a name="l00878"></a>00878 <span class="keywordflow">for</span> ( <span class="keywordtype">int</span> column = 0; column < mTable->numCols(); ++column ) {
<a name="l00879"></a>00879 QComboTableItem *item = <span class="keyword">static_cast<</span>QComboTableItem*<span class="keyword">></span>( mTable->item( 0,
<a name="l00880"></a>00880 column ) );
<a name="l00881"></a>00881 <span class="keywordflow">if</span> ( item )
<a name="l00882"></a>00882 config.writeEntry( QString::number( column ), posToType(
<a name="l00883"></a>00883 item->currentItem() ) );
<a name="l00884"></a>00884 <span class="keywordflow">else</span>
<a name="l00885"></a>00885 config.writeEntry( QString::number( column ), 0 );
<a name="l00886"></a>00886 }
<a name="l00887"></a>00887
<a name="l00888"></a>00888 config.sync();
<a name="l00889"></a>00889 }
<a name="l00890"></a>00890
<a name="l00891"></a>00891 QString CSVImportDialog::getText( <span class="keywordtype">int</span> row, <span class="keywordtype">int</span> col )
<a name="l00892"></a>00892 {
<a name="l00893"></a>00893 <span class="keywordflow">return</span> mTable->text( row, col );
<a name="l00894"></a>00894 }
<a name="l00895"></a>00895
<a name="l00896"></a>00896 uint CSVImportDialog::posToType( <span class="keywordtype">int</span> pos )<span class="keyword"> const</span>
<a name="l00897"></a>00897 <span class="keyword"></span>{
<a name="l00898"></a>00898 uint counter = 0;
<a name="l00899"></a>00899 QMap<QString, uint>::ConstIterator it;
<a name="l00900"></a>00900 <span class="keywordflow">for</span> ( it = mTypeMap.begin(); it != mTypeMap.end(); ++it, ++counter )
<a name="l00901"></a>00901 <span class="keywordflow">if</span> ( counter == (uint)pos )
<a name="l00902"></a>00902 <span class="keywordflow">return</span> it.data();
<a name="l00903"></a>00903
<a name="l00904"></a>00904 <span class="keywordflow">return</span> 0;
<a name="l00905"></a>00905 }
<a name="l00906"></a>00906
<a name="l00907"></a>00907 <span class="keywordtype">int</span> CSVImportDialog::typeToPos( uint type )<span class="keyword"> const</span>
<a name="l00908"></a>00908 <span class="keyword"></span>{
<a name="l00909"></a>00909 uint counter = 0;
<a name="l00910"></a>00910 QMap<QString, uint>::ConstIterator it;
<a name="l00911"></a>00911 <span class="keywordflow">for</span> ( it = mTypeMap.begin(); it != mTypeMap.end(); ++it, ++counter )
<a name="l00912"></a>00912 <span class="keywordflow">if</span> ( it.data() == type )
<a name="l00913"></a>00913 <span class="keywordflow">return</span> counter;
<a name="l00914"></a>00914
<a name="l00915"></a>00915 <span class="keywordflow">return</span> -1;
<a name="l00916"></a>00916 }
<a name="l00917"></a>00917
<a name="l00918"></a>00918 <span class="keywordtype">void</span> CSVImportDialog::ignoreDuplicatesChanged( <span class="keywordtype">int</span> )
<a name="l00919"></a>00919 {
<a name="l00920"></a>00920 fillTable();
<a name="l00921"></a>00921 }
<a name="l00922"></a>00922
<a name="l00923"></a>00923 <span class="keywordtype">void</span> CSVImportDialog::setFile( <span class="keyword">const</span> QString &fileName )
<a name="l00924"></a>00924 {
<a name="l00925"></a>00925 <span class="keywordflow">if</span> ( fileName.isEmpty() )
<a name="l00926"></a>00926 <span class="keywordflow">return</span>;
<a name="l00927"></a>00927
<a name="l00928"></a>00928 QFile file( fileName );
<a name="l00929"></a>00929 <span class="keywordflow">if</span> ( !file.open( IO_ReadOnly ) ) {
<a name="l00930"></a>00930 KMessageBox::sorry( <span class="keyword">this</span>, i18n( <span class="stringliteral">"Cannot open input file."</span> ) );
<a name="l00931"></a>00931 file.close();
<a name="l00932"></a>00932 <span class="keywordflow">return</span>;
<a name="l00933"></a>00933 }
<a name="l00934"></a>00934
<a name="l00935"></a>00935 mFileArray = file.readAll();
<a name="l00936"></a>00936 file.close();
<a name="l00937"></a>00937
<a name="l00938"></a>00938 mClearTypeStore = <span class="keyword">true</span>;
<a name="l00939"></a>00939 clearTable();
<a name="l00940"></a>00940 mTable->setNumCols( 0 );
<a name="l00941"></a>00941 mTable->setNumRows( 0 );
<a name="l00942"></a>00942 fillTable();
<a name="l00943"></a>00943 mClearTypeStore = <span class="keyword">false</span>;
<a name="l00944"></a>00944
<a name="l00945"></a>00945 fillComboBox();
<a name="l00946"></a>00946 }
<a name="l00947"></a>00947
<a name="l00948"></a>00948 <span class="keywordtype">void</span> CSVImportDialog::urlChanged( <span class="keyword">const</span> QString &file )
<a name="l00949"></a>00949 {
<a name="l00950"></a>00950 <span class="keywordtype">bool</span> state = !file.isEmpty();
<a name="l00951"></a>00951
<a name="l00952"></a>00952 enableButtonOK( state );
<a name="l00953"></a>00953 actionButton( User1 )->setEnabled( state );
<a name="l00954"></a>00954 actionButton( User2 )->setEnabled( state );
<a name="l00955"></a>00955 }
<a name="l00956"></a>00956
<a name="l00957"></a>00957 <span class="keywordtype">void</span> CSVImportDialog::codecChanged()
<a name="l00958"></a>00958 {
<a name="l00959"></a>00959 fillTable();
<a name="l00960"></a>00960 }
<a name="l00961"></a>00961
<a name="l00962"></a>00962 <span class="preprocessor">#include <csvimportdialog.moc></span>
</pre></div></div>
</div></div>
</td>
</tr>
<tr>
<td valign="top" id="leftmenu" width="25%">
<a name="navigation"></a>
<div class="menu_box"><h2>kaddressbook</h2>
<div class="nav_list">
<ul><li><a href="index.html">Main Page</a></li><li><a href="hierarchy.html">Class Hierarchy</a></li><li><a href="classes.html">Alphabetical List</a></li><li><a href="annotated.html">Class List</a></li><li><a href="files.html">File List</a></li><li><a href="functions.html">Class Members</a></li><li><a href="pages.html">Related Pages</a></li></ul>
<!--
<h2>Class Picker</h2>
<div style="text-align: center;">
<form name="guideform">
<select name="guidelinks" style="width:100%;" onChange="window.location=document.guideform.guidelinks.options[document.guideform.guidelinks.selectedIndex].value">
<option value="annotated.html">-- Choose --</option>
<option value="classAddressEditDialog.html">addresseditdialog</option>, <option value="classAddressEditWidget.html">addresseditwidget</option>, <option value="classAddresseeUtil.html">addresseeutil</option>, <option value="classAddressTypeDialog.html">addresstypedialog</option>, <option value="classAddViewDialog.html">addviewdialog</option>, <option value="classCardView.html">cardview</option>, <option value="classCardViewItem.html">cardviewitem</option>, <option value="classCardViewLookNFeelPage.html">cardviewlooknfeelpage</option>, <option value="classConfigureCardViewWidget.html">configurecardviewwidget</option>, <option value="classConfigureTableViewWidget.html">configuretableviewwidget</option>, <option value="classDateParser.html">dateparser</option>, <option value="classDistributionListView.html">distributionlistview</option>, <option value="classDynamicTip.html">dynamictip</option>, <option value="classEmailEditWidget.html">emaileditwidget</option>, <option value="classEmailSelector.html">emailselector</option>, <option value="classFilter.html">filter</option>, <option value="classFilterSelectionWidget.html">filterselectionwidget</option>, <option value="classIMAddressLVI.html">imaddresslvi</option>, <option value="classIMAddressWidget.html">imaddresswidget</option>, <option value="classImageButton.html">imagebutton</option>, <option value="classImageLoader.html">imageloader</option>, <option value="classIMEditorWidget.html">imeditorwidget</option>, <option value="classIMEditWidget.html">imeditwidget</option>, <option value="classJumpButtonBar.html">jumpbuttonbar</option>, <option value="classKABPrinting_1_1PrintingWizard.html">kabprinting::printingwizard</option>, <option value="classKABPrinting_1_1PrintProgress.html">kabprinting::printprogress</option>, <option value="classKABPrinting_1_1PrintStyle.html">kabprinting::printstyle</option>, <option value="classKABPrinting_1_1PrintStyleFactory.html">kabprinting::printstylefactory</option>, <option value="classKAddressBookCardView.html">kaddressbookcardview</option>, <option value="classKAddressBookIconView.html">kaddressbookiconview</option>, <option value="classKAddressBookMain.html">kaddressbookmain</option>, <option value="classKAddressBookTableView.html">kaddressbooktableview</option>, <option value="classKAddressBookView.html">kaddressbookview</option>, <option value="classLookAndFeelPage.html">lookandfeelpage</option>, <option value="classNameEditDialog.html">nameeditdialog</option>, <option value="classPhoneEditWidget.html">phoneeditwidget</option>, <option value="classPhoneTypeDialog.html">phonetypedialog</option>, <option value="classTypeCombo.html">typecombo</option>, <option value="classViewConfigureWidget.html">viewconfigurewidget</option>, <option value="classViewManager.html">viewmanager</option>,
</select>
</form>
</div>
-->
</div></div>
<div class="menu_box"><h2>API Dox</h2>
<div class="nav_list">
<ul>
<li><a href="../../akregator/html/index.html">akregator</a></li><li> <a href="../../akregator/src/html/index.html">src</a></li><li> <a href="../../akregator/src/librss/html/index.html">librss</a></li><li><a href="../../certmanager/html/index.html">certmanager</a></li><li> <a href="../../certmanager/lib/html/index.html">lib</a></li><li><a href="../../kaddressbook/html/index.html">kaddressbook</a></li><li><a href="../../kalarm/html/index.html">kalarm</a></li><li> <a href="../../kalarm/lib/html/index.html">lib</a></li><li><a href="../../kandy/html/index.html">kandy</a></li><li><a href="../../karm/html/index.html">karm</a></li><li><a href="../../kdgantt/html/index.html">kdgantt</a></li><li><a href="../../kgantt/html/index.html">kgantt</a></li><li><a href="../../kioslaves/html/index.html">kioslaves</a></li><li> <a href="../../kioslaves/imap4/html/index.html">imap4</a></li><li> <a href="../../kioslaves/mbox/html/index.html">mbox</a></li><li><a href="../../kitchensync/html/index.html">kitchensync</a></li><li><a href="../../kmail/html/index.html">kmail</a></li><li><a href="../../knotes/html/index.html">knotes</a></li><li><a href="../../konsolekalendar/html/index.html">konsolekalendar</a></li><li><a href="../../kontact/html/index.html">kontact</a></li><li><a href="../../korganizer/html/index.html">korganizer</a></li><li><a href="../../kpilot/html/index.html">kpilot</a></li><li> <a href="../../kpilot/kpilot/html/index.html">kpilot</a></li><li> <a href="../../kpilot/lib/html/index.html">lib</a></li><li><a href="../../libemailfunctions/html/index.html">libemailfunctions</a></li><li><a href="../../libkcal/html/index.html">libkcal</a></li><li><a href="../../libkdepim/html/index.html">libkdepim</a></li><li><a href="../../libkholidays/html/index.html">libkholidays</a></li><li><a href="../../libkmime/html/index.html">libkmime</a></li><li><a href="../../libkpgp/html/index.html">libkpgp</a></li><li><a href="../../libkpimidentities/html/index.html">libkpimidentities</a></li>
</ul></div></div>
</td>
</tr>
</table>
<span class="doNotDisplay">
<a href="http://www.kde.org/" accesskey="8">KDE Home</a> |
<a href="http://accessibility.kde.org/" accesskey="9">KDE Accessibility Home</a> |
<a href="http://www.kde.org/media/accesskeys.php" accesskey="0">Description of Access Keys</a>
</span>
<div style="height: 8px"></div>
<div id="footer">
<div id="footer_left">
Maintained by <a href="mailto:groot@kde.org">Adriaan de Groot</a>
and
<a href="mailto:winter@kde.org">Allen Winter</a>.
<br/>
KDE and K Desktop Environment are trademarks of <a href="http://www.kde.org/areas/kde-ev/" title="Homepage of the KDE non-profit Organization">KDE e.V.</a> |
<a href="http://www.kde.org/contact/impressum.php">Legal</a>
</div>
<div id="footer_right"><img src="/media/images/footer_right.png" style="margin: 0px" alt="" /></div>
</div>
<!--
WARNING: DO NOT SEND MAIL TO THE FOLLOWING EMAIL ADDRESS! YOU WILL
BE BLOCKED INSTANTLY AND PERMANENTLY!
<a href="mailto:aaaatrap-425acc3b5374943f@kde.org">Block me</a>
WARNING END
-->
</body>
</html>
