|Home||Reviews||Tools||Forums||FAQs||Find Service||ISP News||Maps||About|
how-to block ads
The default format of the CSV file is tailored to the default CSV MicroSoft Outlook Contacts database file generated using "file export".
Although this feature did not have well documented CSV formats, three users provided some solutions as described below:
TBB user "PCode" has provided the following:
I am linking the tool I whipped up that allows me to convert my Outlook contacts CSV to Primus-compliant CSV. I am including the VB source as well, in case anyone feels adventurous...
TBB user "John G." has also had some success with formatting exported info to match the .CSV format used by Primus. He has provided a sample .CSV file and the following instructions:
Here's a test CSV file.
•Primus needs a 'header' record. This is the first record (line) and is usually the names of the fields. The header record must be present even though it doesn't get imported. It can be a line of spaces or all commas.
•Second record shows records of 58 or more fields are not imported,
•Third record shows records of 57 or fewer fields get imported. Each field's value is it's field position (1 - 57) and so shows where each field ends up in the Directory listing.
•Fourth, fifth and sixth records are to show how various phone number formats end up in the Directory. Look in the CSV file and look how the numbers appear in the Directory. It seems an area code is needed. Only space, - , ( and ) symbols can be used. International numbers have no symbols after the 011-.
Here is further advice from user "Dan":
This might help with the import directory problem . . .
Steve, In your CSV File Import Feature (#12208)VoIP FAQ post, Dan says, "This might help with the import directory problem . . ." 1. 2. 3. remove all columns to the right of column BF from contacts.csv Strangely, the columns to THE LEFT of column BF, include such obscure titles as Anniversary, Billing Information, Assistant Name......and so on. What on earth does the Primus Directory do with these columns.....if in fact they are to be included in the import? I haven't had any "luck" importing yet. Still waiting for a current answer to this dilemma. All the online (forum) tips seem to be from 2005......and none of them are working for me. Has anyone else found an answer? Thanks for any help. Signed, Desperate.
Hi, Anyone.....everyone......product managers....techies: I'm sorry to bug you but I'm not having any luck with the subject. Dan's (not sure who he is) post says/shows 10 fields to be downloaded...but there are only 9 on the Directory Edit page: First Name Last Name Company Email Address Office Number Cell Number Home Number Pager Number Fax Number He shows a Title, I think...but there is no title on the Primus page. Also, I'm still looking for the most basic of instructions....like, do I use the Export to a File command? Do I use Comma Separated Values? or Tab separated values? DOS or Windows? Or do I use neither...and export in Excel format? Do I have to Map the data so that the number of columns corresponds...do the names have to be changed to Primus values or should they stay as they are in Outlook? If I DO strip out all the "non-Primus" fields (are there 9 or 10) do my cells have to have a specific number of characters or not? (what happens, for example, if I have a note to myself to "phone Mr and Mrs Jones before faxing them" in the fax field? Does it trash the entire download because it's not in the 10-digit phone number format? Or because it's text? I'm sorry, but Primus'instructions are really lacking on this. Why don't they find out the difinitive answer from a user who's made it work.....then POST IT as THE solution. Get rid of all the other conversations and guesswork posts. Better yet, is there not a product manager who knows how to make this product work? How about the US company they bought the software? Surely someone down there (the AUTHOR, perhaps?) knows how to make this thing work. Yes? Just looking for some simple answers, please. (Whoever Blaine is seemed to think this was a simple procedure when he posted
Both of the links in Pcode's post, above, are dead. Suggest you remove it to stop pissing people (like me) off. Michael
Steve, this is part of the post from John G., above: "Whatever CSV files that are produced (from Outlook or anything else) may have to be rearranged to suit the Primus format." Give me a break: "MAY have to be arranged"????? They are either correct.........or they're not. They either HAVE TO BE ARRANGED.....or they don't. You folks REALLY have to get your S**T together on up/downloading a directory from Outlook. Can it be done?.........Or can't it? If it can, please publish the solution in a clear, obvious place. Thanks, Michael