Importing csv files

I am using a Sprint PPC-6700 phone. I have a requirement to import a CSV file
of phone numbers into the phone and incorporate it into a speed dial function
or into the contacts section. Is there a procedure built into the phone to
accomplish this, or do I need to write a small prorgam to do this task. Any
help, links, etc. will be appreciated. I will be developing in VS 2005/VB
.Net.

Thanks for your time and effort in advance.
--
vbkoder

MSenne
Wed Jan 11 11:10:20 CST 2006

CSV is a comma delimited file exported from a spreadsheet program.
Easiest way to start is by cracking open your .csv in a plain text
editor to find 2 things:
1. encoding (you'll want to know this when opening the file)
2. format (to parse it properly with Regexes)

Take a look at System.Text.RegularExpressions.Regex on MSDN lib and
learn to use regular expressions. Your task is easier than you think
:)
-Matt Senne

Ginny
Wed Jan 11 11:42:22 CST 2006

There is a TextDataAdapter on www.opennetcf.org that reads CSV files into
Datasets.

--
Ginny Caughey
.NET Compact Framework MVP


"vbkoder" <vbkoder@discussions.microsoft.com> wrote in message
news:5C8C63A8-D892-4DE5-9639-AF5A051EC7DA@microsoft.com...
>I am using a Sprint PPC-6700 phone. I have a requirement to import a CSV
>file
> of phone numbers into the phone and incorporate it into a speed dial
> function
> or into the contacts section. Is there a procedure built into the phone to
> accomplish this, or do I need to write a small prorgam to do this task.
> Any
> help, links, etc. will be appreciated. I will be developing in VS 2005/VB
> .Net.
>
> Thanks for your time and effort in advance.
> --
> vbkoder

Philip
Thu Jan 12 06:37:37 CST 2006

Are you planning to transfer CSV files to a Pocket PC? If you use a .csv
extension for these files, then ActiveSync will *not* convert them to UTF-8
format, which means that your program will not be able to read them at all.

I would recommend that you use TSV format instead. You can then use a .txt
extension. This *is* recognised by ActiveSync, and your ANSI text will get
converted nicely. TSV is also a lot easier to parse.

You should also bear in mind that spreadsheets like Excel can do horrendous
things to CSV files. How do you think it would treat a phone number like
02087673566?

"vbkoder" <vbkoder@discussions.microsoft.com> wrote in message
news:5C8C63A8-D892-4DE5-9639-AF5A051EC7DA@microsoft.com...
>I am using a Sprint PPC-6700 phone. I have a requirement to import a CSV
>file
> of phone numbers into the phone and incorporate it into a speed dial
> function
> or into the contacts section. Is there a procedure built into the phone to
> accomplish this, or do I need to write a small prorgam to do this task.
> Any
> help, links, etc. will be appreciated. I will be developing in VS 2005/VB
> .Net.
>
> Thanks for your time and effort in advance.
> --
> vbkoder