<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Cambria;
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin-top:0in;
margin-right:0in;
margin-bottom:10.0pt;
margin-left:0in;
line-height:115%;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
h2
{mso-style-priority:9;
mso-style-link:"Heading 2 Char";
margin-top:10.0pt;
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
line-height:115%;
page-break-after:avoid;
font-size:13.0pt;
font-family:"Cambria","serif";
color:#4F81BD;}
p.MsoTitle, li.MsoTitle, div.MsoTitle
{mso-style-priority:10;
mso-style-link:"Title Char";
margin-top:0in;
margin-right:0in;
margin-bottom:15.0pt;
margin-left:0in;
mso-add-space:auto;
border:none;
padding:0in;
font-size:26.0pt;
font-family:"Cambria","serif";
color:#17365D;
letter-spacing:.25pt;}
p.MsoTitleCxSpFirst, li.MsoTitleCxSpFirst, div.MsoTitleCxSpFirst
{mso-style-priority:10;
mso-style-link:"Title Char";
mso-style-type:export-only;
margin:0in;
margin-bottom:.0001pt;
mso-add-space:auto;
border:none;
padding:0in;
font-size:26.0pt;
font-family:"Cambria","serif";
color:#17365D;
letter-spacing:.25pt;}
p.MsoTitleCxSpMiddle, li.MsoTitleCxSpMiddle, div.MsoTitleCxSpMiddle
{mso-style-priority:10;
mso-style-link:"Title Char";
mso-style-type:export-only;
margin:0in;
margin-bottom:.0001pt;
mso-add-space:auto;
border:none;
padding:0in;
font-size:26.0pt;
font-family:"Cambria","serif";
color:#17365D;
letter-spacing:.25pt;}
p.MsoTitleCxSpLast, li.MsoTitleCxSpLast, div.MsoTitleCxSpLast
{mso-style-priority:10;
mso-style-link:"Title Char";
mso-style-type:export-only;
margin-top:0in;
margin-right:0in;
margin-bottom:15.0pt;
margin-left:0in;
mso-add-space:auto;
border:none;
padding:0in;
font-size:26.0pt;
font-family:"Cambria","serif";
color:#17365D;
letter-spacing:.25pt;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.Heading2Char
{mso-style-name:"Heading 2 Char";
mso-style-priority:9;
mso-style-link:"Heading 2";
font-family:"Cambria","serif";
color:#4F81BD;
font-weight:bold;}
span.TitleChar
{mso-style-name:"Title Char";
mso-style-priority:10;
mso-style-link:Title;
font-family:"Cambria","serif";
color:#17365D;
letter-spacing:.25pt;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<div style="mso-element:para-border-div;border:none;border-bottom:solid #4F81BD 1.0pt;padding:0in 0in 4.0pt 0in">
<p class="MsoTitle"><span style="font-size:18.0pt">Importing Comments into vTiger 5.3.0 - Windows Users<o:p></o:p></span></p>
</div>
<p class="MsoNormal">I realized the import/export icon is greyed-out on the module comments, just when I needed to import over 10,000 comments (notes) to our vTiger windows-based server.
<br>
I searched for clues but I did not find any recent solutions, only requests for information.
<br>
I spent a few hours of my weekend and came up with a working solution. It involves working directly with the database, but it is not difficult at all! I will share it with you.<br>
The data needs to be imported into 3 tables: vtiger_modcommentscf, vtiger_modcomments and vtiger_ crmentity, but first you MUST take care of the current vtiger_crmentity_seq id value.<br>
<span class="Heading2Char"><span style="font-size:13.0pt;line-height:115%"><br>
STEP 1</span></span><br>
Go to vtiger_crmentity_seq table (I recommend using phpMyAdmin) and take note of the last used id.
<br>
Let’s assume its value is 1000. <br>
Realize that crmentity_seq is a sequential auto-incremented number, and if you don’t update this table when importing your comments, then your data may be overwritten by the next user of vtiger or there may be double ids.<br>
If you want to import 500 new comments, the id must be incremented by 500, so you must change the id to 1500.
<br>
The easiest way to do it is by using phpMyAdmin. Go ahead and change its id to the new value now.<o:p></o:p></p>
<p class="MsoNormal"><span class="Heading2Char"><span style="font-size:13.0pt;line-height:115%">STEP 2<br>
</span></span>Go to vtiger_modcommentscf and select to export this table.<br>
Use phpMyAdmin to open this table, and select “Export”. Include these parameters:
<br>
Export Method = Custom – display all possible options.
<br>
Rows = Dump some rows; Number of rows 10; Row to begin at 0.
<br>
Format = CSV for MS Excel. <br>
Format-specific options = Put columns names in the first row. <br>
<br>
<img width="891" height="685" id="Picture_x0020_3" src="cid:image002.png@01CDF6A1.172AC960"><o:p></o:p></p>
<p class="MsoNormal">Note: Do the same with vtiger_modcomments and vtiger_crmentity. This way you will have a better understanding of the structure of each table involved in this process.<o:p></o:p></p>
<p class="MsoNormal">Next, create your own excel-based data and name it vtiger_modcommentscf.csv. It should look like:
<o:p></o:p></p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none">
<tbody>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="top" style="width:48.0pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
id<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="top" style="width:48.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1001<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="top" style="width:48.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1002<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="top" style="width:48.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1003<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="top" style="width:48.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1004<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="top" style="width:48.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
…<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="64" nowrap="" valign="top" style="width:48.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1500<o:p></o:p></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Now, import your new data. Remember to always skip row 1 (column names) and use “;” as column separator value.<br>
<br>
<o:p></o:p></p>
<p class="MsoNormal"><img width="893" height="691" id="Picture_x0020_2" src="cid:image004.png@01CDF6A1.172AC960">
<o:p></o:p></p>
<p class="MsoNormal"><span class="Heading2Char"><span style="font-size:13.0pt;line-height:115%">STEP 3</span></span><br>
Prepare an excel-based csv sheet, with the new values for vtiger_modcomments. It should look like:<o:p></o:p></p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none">
<tbody>
<tr style="height:15.0pt">
<td width="113" nowrap="" valign="top" style="width:85.0pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
modcommentsid<o:p></o:p></p>
</td>
<td width="227" nowrap="" valign="top" style="width:170.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
commentcontent<o:p></o:p></p>
</td>
<td width="72" nowrap="" valign="top" style="width:.75in;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
related_to<o:p></o:p></p>
</td>
<td width="123" nowrap="" valign="top" style="width:92.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
parent_comments<o:p></o:p></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="113" nowrap="" valign="top" style="width:85.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1001<o:p></o:p></p>
</td>
<td width="227" nowrap="" valign="top" style="width:170.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
Any comment content 1001<o:p></o:p></p>
</td>
<td width="72" nowrap="" valign="top" style="width:.75in;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
10<o:p></o:p></p>
</td>
<td width="123" nowrap="" valign="top" style="width:92.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
</tr>
<tr style="height:15.0pt">
<td width="113" nowrap="" valign="top" style="width:85.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1002<o:p></o:p></p>
</td>
<td width="227" nowrap="" valign="top" style="width:170.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
More comment content 1002<o:p></o:p></p>
</td>
<td width="72" nowrap="" valign="top" style="width:.75in;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
10<o:p></o:p></p>
</td>
<td width="123" nowrap="" valign="top" style="width:92.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
</tr>
<tr style="height:15.0pt">
<td width="113" nowrap="" valign="top" style="width:85.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1003<o:p></o:p></p>
</td>
<td width="227" nowrap="" valign="top" style="width:170.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
More comment content 1003<o:p></o:p></p>
</td>
<td width="72" nowrap="" valign="top" style="width:.75in;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
10<o:p></o:p></p>
</td>
<td width="123" nowrap="" valign="top" style="width:92.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
</tr>
<tr style="height:15.0pt">
<td width="113" nowrap="" valign="top" style="width:85.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1004<o:p></o:p></p>
</td>
<td width="227" nowrap="" valign="top" style="width:170.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
More comment content 1004<o:p></o:p></p>
</td>
<td width="72" nowrap="" valign="top" style="width:.75in;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
12<o:p></o:p></p>
</td>
<td width="123" nowrap="" valign="top" style="width:92.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
</tr>
<tr style="height:15.0pt">
<td width="113" nowrap="" valign="top" style="width:85.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
… <o:p></o:p></p>
</td>
<td width="227" nowrap="" valign="top" style="width:170.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
<td width="72" nowrap="" valign="top" style="width:.75in;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
<td width="123" nowrap="" valign="top" style="width:92.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
</tr>
<tr style="height:15.0pt">
<td width="113" nowrap="" valign="top" style="width:85.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
1500<o:p></o:p></p>
</td>
<td width="227" nowrap="" valign="top" style="width:170.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
Final comment content 1500<o:p></o:p></p>
</td>
<td width="72" nowrap="" valign="top" style="width:.75in;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
12<o:p></o:p></p>
</td>
<td width="123" nowrap="" valign="top" style="width:92.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">“commentcontent” is the actual comment that you wish to import.<br>
“related to value” is the contactid (if comment is related to a contact), which can be obtained from the table vtiger_contactdetails.<br>
<br>
Save it as vtiger_modcomments.csv and then Import it. Remember to always skip row 1 (column names) and use “;” as column separator value.<o:p></o:p></p>
<p class="MsoNormal"><span class="Heading2Char"><span style="font-size:13.0pt;line-height:115%">STEP 4<br>
</span></span>Finally, you need to prepare your vtiger_crmentity excel-based csv file, with the proper data, and as equally important: the proper format. It should look like this:
<o:p></o:p></p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none">
<tbody>
<tr style="height:22.95pt">
<td width="75" nowrap="" valign="top" style="width:56.55pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">crmid<o:p></o:p></span></p>
</td>
<td width="82" nowrap="" valign="top" style="width:61.4pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">smcreatorid<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">smownerid<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">modifiedby<o:p></o:p></span></p>
</td>
<td width="97" nowrap="" valign="top" style="width:72.85pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">setype<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">description<o:p></o:p></span></p>
</td>
<td width="125" nowrap="" valign="top" style="width:93.95pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">createdtime<o:p></o:p></span></p>
</td>
<td width="126" nowrap="" valign="top" style="width:94.5pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">modifiedtime<o:p></o:p></span></p>
</td>
<td width="53" nowrap="" valign="top" style="width:40.0pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">viewedtime<o:p></o:p></span></p>
</td>
<td width="55" nowrap="" valign="top" style="width:41.25pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">status<o:p></o:p></span></p>
</td>
<td width="62" nowrap="" valign="top" style="width:46.35pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">version<o:p></o:p></span></p>
</td>
<td width="72" nowrap="" valign="top" style="width:53.7pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">presence<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="top" style="width:47.75pt;border:solid windowtext 1.0pt;border-left:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">deleted<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:22.95pt">
<td width="75" nowrap="" valign="top" style="width:56.55pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1001<o:p></o:p></span></p>
</td>
<td width="82" nowrap="" valign="top" style="width:61.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="97" nowrap="" valign="top" style="width:72.85pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">ModComments<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="125" nowrap="" valign="top" style="width:93.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:00<o:p></o:p></span></p>
</td>
<td width="126" nowrap="" valign="top" style="width:94.5pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:00<o:p></o:p></span></p>
</td>
<td width="53" nowrap="" valign="top" style="width:40.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="55" nowrap="" valign="top" style="width:41.25pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="62" nowrap="" valign="top" style="width:46.35pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
<td width="72" nowrap="" valign="top" style="width:53.7pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="top" style="width:47.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:22.95pt">
<td width="75" nowrap="" valign="top" style="width:56.55pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1002<o:p></o:p></span></p>
</td>
<td width="82" nowrap="" valign="top" style="width:61.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="97" nowrap="" valign="top" style="width:72.85pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">ModComments<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="125" nowrap="" valign="top" style="width:93.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:01<o:p></o:p></span></p>
</td>
<td width="126" nowrap="" valign="top" style="width:94.5pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:01<o:p></o:p></span></p>
</td>
<td width="53" nowrap="" valign="top" style="width:40.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="55" nowrap="" valign="top" style="width:41.25pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="62" nowrap="" valign="top" style="width:46.35pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
<td width="72" nowrap="" valign="top" style="width:53.7pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="top" style="width:47.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:22.95pt">
<td width="75" nowrap="" valign="top" style="width:56.55pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1003<o:p></o:p></span></p>
</td>
<td width="82" nowrap="" valign="top" style="width:61.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="97" nowrap="" valign="top" style="width:72.85pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">ModComments<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="125" nowrap="" valign="top" style="width:93.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:02<o:p></o:p></span></p>
</td>
<td width="126" nowrap="" valign="top" style="width:94.5pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:02<o:p></o:p></span></p>
</td>
<td width="53" nowrap="" valign="top" style="width:40.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="55" nowrap="" valign="top" style="width:41.25pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="62" nowrap="" valign="top" style="width:46.35pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
<td width="72" nowrap="" valign="top" style="width:53.7pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="top" style="width:47.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:22.95pt">
<td width="75" nowrap="" valign="top" style="width:56.55pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1004<o:p></o:p></span></p>
</td>
<td width="82" nowrap="" valign="top" style="width:61.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="97" nowrap="" valign="top" style="width:72.85pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">ModComments<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="125" nowrap="" valign="top" style="width:93.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:03<o:p></o:p></span></p>
</td>
<td width="126" nowrap="" valign="top" style="width:94.5pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:03<o:p></o:p></span></p>
</td>
<td width="53" nowrap="" valign="top" style="width:40.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="55" nowrap="" valign="top" style="width:41.25pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="62" nowrap="" valign="top" style="width:46.35pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
<td width="72" nowrap="" valign="top" style="width:53.7pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="top" style="width:47.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:22.95pt">
<td width="75" nowrap="" valign="top" style="width:56.55pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">…<o:p></o:p></span></p>
</td>
<td width="82" nowrap="" valign="top" style="width:61.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="97" nowrap="" valign="top" style="width:72.85pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="125" nowrap="" valign="top" style="width:93.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="126" nowrap="" valign="top" style="width:94.5pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="53" nowrap="" valign="top" style="width:40.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="55" nowrap="" valign="top" style="width:41.25pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="62" nowrap="" valign="top" style="width:46.35pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="72" nowrap="" valign="top" style="width:53.7pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
<td width="64" nowrap="" valign="top" style="width:47.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
</td>
</tr>
<tr style="height:22.95pt">
<td width="75" nowrap="" valign="top" style="width:56.55pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1500<o:p></o:p></span></p>
</td>
<td width="82" nowrap="" valign="top" style="width:61.4pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="97" nowrap="" valign="top" style="width:72.85pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">ModComments<o:p></o:p></span></p>
</td>
<td width="77" nowrap="" valign="top" style="width:57.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="125" nowrap="" valign="top" style="width:93.95pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:05<o:p></o:p></span></p>
</td>
<td width="126" nowrap="" valign="top" style="width:94.5pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">2013-01-19 20:15:05<o:p></o:p></span></p>
</td>
<td width="53" nowrap="" valign="top" style="width:40.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="55" nowrap="" valign="top" style="width:41.25pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">NULL<o:p></o:p></span></p>
</td>
<td width="62" nowrap="" valign="top" style="width:46.35pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
<td width="72" nowrap="" valign="top" style="width:53.7pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">1<o:p></o:p></span></p>
</td>
<td width="64" nowrap="" valign="top" style="width:47.75pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:22.95pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:9.0pt">0<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><span style="font-size:8.0pt;line-height:115%"><o:p> </o:p></span></p>
<p class="MsoNormal">Pay particular attention to the createdtime and modifiedtime format. It should be “yyyy-mm-dd hh:mm:ss” (year-month-day hour:minutes:seconds). I tried saving this format on excel, by using custom format:<o:p></o:p></p>
<p class="MsoNormal"><img width="420" height="376" id="Picture_x0020_1" src="cid:image006.jpg@01CDF6A1.172AC960"><o:p></o:p></p>
<p class="MsoNormal">But every time I tried to save the file as csv: the format was lost!<o:p></o:p></p>
<p class="MsoNormal">I ended up downloading (free) Open Office and manipulating the data in “calc” and saving it as csv.<o:p></o:p></p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none">
<tbody>
<tr style="height:15.0pt">
<td width="871" nowrap="" valign="top" style="width:653.0pt;border:solid windowtext 1.0pt;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:10.0pt">crmid;smcreatorid;smownerid;modifiedby;setype;description;createdtime;modifiedtime;viewedtime;status;version;presence;deleted<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="871" nowrap="" valign="top" style="width:653.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:10.0pt">1001;1;1;1;ModComments;NULL;2013-01-19 20:15:00;2013-01-19 20:15:00;NULL;NULL;0;1;0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="871" nowrap="" valign="top" style="width:653.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:10.0pt">1002;1;1;1;ModComments;NULL;2013-01-19 20:15:01;2013-01-19 20:15:01;NULL;NULL;0;1;0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="871" nowrap="" valign="top" style="width:653.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:10.0pt">1003;1;1;1;ModComments;NULL;2013-01-19 20:15:02;2013-01-19 20:15:02;NULL;NULL;0;1;0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="871" nowrap="" valign="top" style="width:653.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:10.0pt">1004;1;1;1;ModComments;NULL;2013-01-19 20:15:03;2013-01-19 20:15:03;NULL;NULL;0;1;0<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="871" nowrap="" valign="top" style="width:653.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:10.0pt">…<o:p></o:p></span></p>
</td>
</tr>
<tr style="height:15.0pt">
<td width="871" nowrap="" valign="top" style="width:653.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0in 5.4pt 0in 5.4pt;height:15.0pt">
<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">
<span style="font-size:10.0pt">1500;1;1;1;ModComments;NULL;2013-01-19 20:15:05;2013-01-19 20:15:05;NULL;NULL;0;1;0<o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Finally, import your table with new data now. Remember to always skip row 1 (column names) and use “;” as column separator value.<br>
After finishing and verifying your import, created a new comment using vTiger: The new comment should receive an id equal to your last imported id plus 1, i.e. 1501.
<o:p></o:p></p>
<p class="MsoNormal">That’s it. It is not difficult at all. You just need to take some time to prepare your data properly.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>