asterisk users - Oct 2010 - Updating asteriskcdrdb with uniqueid field from Master.csv, Master.csv.1....Master.csv.5 - Must I bring all files together first?

Hi Everyone,

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

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 parameters from time to
time)

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.

My Questions:

1- Must I bring those files into one big file first before trying to update
the MySQL table?
2- Must I remove all data from asteriskcdrdb first to avoid duplication and
then do the update through a php script?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20101029/a356d68f/attachment.htm

On Fri, Oct 29, 2010 at 4:55 PM, Bruce B <bruceb444 at gmail.com>
wrote:
> Hi Everyone,
> 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
> 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?parameters?from time to
> time)
> 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.
> My Questions:
> 1- Must I bring those files into one big file first before trying to update
> the MySQL table?
> 2- Must I remove all data from asteriskcdrdb first to avoid duplication and
> then do the update through a php script?
> Thanks
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> ? ? ? ? ? ? ? http://www.asterisk.org/hello
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
> ? http://lists.digium.com/mailman/listinfo/asterisk-users
>
I would say no to both, as long as you structure