Custom CNAM on Callcentric.
giqcass:
I have decided to add my entire phonebook to Callcentric. The task is a little more daunting then I had hoped. First I exported my contacts from Google Contacts to a CSV file. Then I had to add a leading , to every contact. I had to erase notes, secondary phone numbers addresses and some other extraneous info Callcentric did not support. I had to delete extra , from the file and ;. Much of this was accomplished through search and replace functions in text edit. I created a rule that anyone in my phonebook would ring directly through to my extensions. The primary benefit of going to all this trouble is that all of my contacts will now appear with custom CNAM on my home phone. This feature is quite useful considering cell phones are not listed in CNAM databases. I have heard many people are having trouble with CNAM on Callcentric so hopefully this is also more reliable then the standard lookup process. My contacts just over 100 covers more then 99% of the calls I wish to receive anyway.
Lavarock7:
When you say "erase" I assume that you did not just load the .csv file into a spread sheet program like excel or Open Office?
If you choose the delimiter correctly, each section of info comes up in a separate column which you can then delete the column.
My credo is never do something manually when you can get the computer to do it. Sometimes it takes longer to figure out how to get the computer to do it, but that exercise makes it easier for the next time.
My other credo is never put off until tomorrow, what you can put off until the day after.
giqcass:
I used a series of "find and replace" commands to make the changes. I erased extra fields by replacing them with nothing. Your right, Excel would have been faster. If I had imported the csv file into a spreadsheet I could have just deleted a few columns, added one, and combined two. Then export back to csv. I'm a big fan of excel for repetitive tasks because you can shove in a lot of automation with VB. I created an awesome Excel setup for work that pulled data from another file, edited the data, checked for errors, printed multiple copies to two different printers, and then saved the new file plus a copy of the raw data with auto generated file names. One click shopping!
dircom:
I exported my CallCentric Phone book, added some numbers to it, saved as CSV
and get this error msg when I try and upload it
File type is not allowed (application/ms-excel)
?? its basically the same file I just downloaded
giqcass:
Sounds like you used Microsoft Office to open it. It probably changed the headers of the file.(Stuff you can't see)
Create a new text file with the text edit application. Then copy the contents of the modified text file and paste them into the new file. Then make sure you save it as a plain text file.
Navigation
[0] Message Index
[#] Next page