Custom CNAM on Callcentric.
dircom:
Callcentric says "CSV files can easily be created with Microsoft Excel"
you can save csv files in Excel.
What application are you suggesting to use? I originally opened in Excel, and saved as CSV
then I tried Notepad ++, and still get same error msg
giqcass:
Unfortunately my computer with Excel tanked so I can't look it right now. Excel should have an option to export as CSV just make sure it's saving it as plain text without extra meta data or formatting. To do what I talked about about above something like notepad should work.
SteveInWA:
This is one of my pet peeves about the utter failure of Microsoft, Google, and any other company that provides or makes use of contacts databases to have cooperated as an industry to fully support vCard or some better tool. Don't even get me started about calendar interoperability. The absolute worst is Outlook. There isn't even a good tool to move between Outlook and MS' own Hotmail/Live Mail/Outlook.com! The third-party solutions over the years have really sucked, too. Every few years, MS would change Outlook, and that would wreck the converters.
Early on, as a CC customer, I tried to export my MS Outlook.com or Gmail contacts into something I could import into CC. CC's tool is so wretchedly limited as to be useless. It took so much time in Excel massaging and exporting as CSV, then trying to import into CC, that I gave up. I am no Excel automation guru, but somebody could write the appropriate automation with Excel to do the massaging. Without automation, it's pointless, because as soon as a few contacts change, you have to update in both places.
Tip: if anyone who is an Excel wizard wants to mess with this, first manually enter some contacts into CC's list, then export it to CSV, so at least you have the specific columnar format CC expects.
My pipe-dream: CC or some other ITSP simply uses Google's API to access my contacts directly, and either do a manual import, or ...imagine this... automatically update on a scheduled basis. In the 1990s, this was called "CTI", or Computer Telephony Integration. We can only dream, or all spend big bucks to buy Microsoft Lync.
dircom:
When I open a CC phone book export in Notepad ++ an entry looks like this
,"Ebay Resolution Center",18015451800,FinancialCRLF
(when I open in Excel, yes the first column is empty)
(Financial is just a group I have in my CC Phn book)
giqcass:
Quote from: dircom on February 28, 2014, 06:11:36 am
CRLF
That is code for a break. Perhaps a simple replace all will fix it.
Navigation
[0] Message Index
[*] Previous page