<span class="Apple-style-span" style="font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; ">Hi Everyone,</span></font></span><div style="text-indent: 0px !important; font-family: Tahoma; font-size: 10pt; ">
<br style="text-indent: 0px !important; "></div><div style="text-indent: 0px !important; font-family: Tahoma; font-size: 10pt; ">Just noted that PBXinaFLASH failed me again on yet something else. The uniqueid field didn't update on the asteriskcdrdb in the past few months but it is available in the .csv files in /var/log/asterisk/cdr-csv/*.csv</div>
<div style="text-indent: 0px !important; font-family: Tahoma; font-size: 10pt; "><br style="text-indent: 0px !important; "></div><div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; ">
<font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; ">I have already re-did the asterisk-addons install with correct parameters to include future calls "uniqueid" in the table (I have no clue why these flavours of Asterisk chose to remove neccessary </span></font><font class="Apple-style-span" face="Tahoma" size="3" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 13px; ">parameters</span></font><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; "> from time to time)</span></font></div>
<div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; "><br style="text-indent: 0px !important; ">
</span></font></div><div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; ">Anyhow, the uniqueid field is needed to be there for ARI to work and for recordings to be pulled. So, I am checking the folder for .csv files and I see Master.csv.1 Master.csv.2 Master.csv.3......Master.csv.5.</span></font></div>
<div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; "><br style="text-indent: 0px !important; ">
</span></font></div><div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; ">My Questions:</span></font></div>
<div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; "><br>
</span></font></div><div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; ">1- Must I bring those files into one big file first before trying to update the MySQL table? </span></font></div>
<div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; ">2- Must I remove all data from asteriskcdrdb first to avoid duplication and then do the update through a php script?</span></font></div>
<div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; "><br style="text-indent: 0px !important; ">
</span></font></div><div style="text-indent: 0px !important; font-family: 'Times New Roman'; font-size: medium; "><font class="Apple-style-span" face="Tahoma" size="4" style="text-indent: 0px !important; "><span class="Apple-style-span" style="text-indent: 0px !important; font-size: 10pt; ">Thanks</span></font></div>