Call activity download

[TechniKal]

How about adding the ability to download call activity records in CSV or some other format? That'd be nice for seeing where calls were going, doing expense reports, etc.

[VTAllan]

Good idea, hasn't been mentioned yet. I could see some sort of process to compile the list in a .pdf, .txt, or some other format for purposes as you mentioned.

Currently you can see the normal list, choose dates to check out activities, and then also a print-friendly text-based version of the logs as well. No specific "downloadable" formats yet. Great idea!

[sbradshaw]

I would definitely like to see this.

[gfwalker]

I also would like to see this. Creating downloadable CSV files is not exactly a new idea; credit card companies and other such consumer-service companies have been doing it for years.

My current workaround for the lack of this capability is as follows:

1. On the ViaTalk Support website, do "View All Calls" for the desired period and then do "Print Results" (on screen).

2. Starting from the bottom, Copy all the data and then Paste it into a blank Word document.

3. Execute the following set of Word 2003 "Find and Replace" instructions to convert the Pasted data into columns, then do "Table --> Convert --> Text to Table" (Separate text at Tabs) to convert the columnized data into a 7-column table that can be brought into Excel or used as is in Word.

===============================

1. Insert a paragraph character in front of the year by replacing “2006-“ with “^p2006-“. This breaks the data up into individual rows.

2. Split the date and time into two columns by replacing “-(?)(?) “ with “-\1\2^t” (this syntax may only work in Word 2003 or later, I'm not sure).

3. Put the Caller ID into a column by replacing all quotes (") with tabs (^t).

4. Put the From number into a column by replacing “ <” with nothing (empty) and “>” with “^t”.

5. Put the To and Status data into columns by making the following replacements (with the “Match case” option checked):
a. ANSWERED ---> ^tAnswered^t
b. BUSY --------> ^tBusy^t
c. NO ANSWER --> ^tNo Answer^t
d. FAILED -------> ^tFailed^t

6. Fix the missing From number in Anonymous calls by replacing “Anonymous” with “Anonymous^t”.

7. Fix (foreign) From numbers without Caller IDs by *manually* inserting two tab characters in front of the number and one tab character after the number. (I can't think of a way to do this automatically.) At this point these numbers can easily be found because of the visual columnization of the list due to the tabs already inserted in previous steps. Hopefully there aren't too many of them...

8. Remove extra spaces in the data by replacing “ ^t” and “^t “ with “^t”.

===============================