importing address: why not mobile #?

[paul.blitz]

I have a membership list, in a spreadsheet. Amongst the data is the person's home phone, work phone and mobile phone.

So, I export the data to csv, then over to the Garmin Palm Desktop, into the addresses function, then file/import. So far, so good.

Select the file, tell it to use .csv, then start matching up the fields.... ok, there is the "home phone", and there is the "work phone". I can see the "other phone", as well as "fax", but can I see "mobile"??? Can I heck!!!

So, how DO I import the mobile phone #???


Paul

[MitchellShnier]

Have you opened the .csv file in Notepad (or any other simple text editor, such as Wordpad) to see if it is what you expected.

[paul.blitz]

Indeed I have!

But the problem is NOTHING to do with the CSV format: when you do a CSV import, it shows the available palm fields on LHS, and the csv fields on RHS, and you match them up.

The issue is that "mobile" is simply not offered as one of the palm fields. You'll see "home", "work", "fax", "other" etc, but NOT "mobile! Grrrrrr!!!!

(looking back, I see my original explanation didn't make this very clear: sorry!)

Paul

[jrose1g]

I don't know the answer to your question, but "mobile" is in a sub-menu of "other" in the Address Edit page of the iQue.

[Ken in Regina]

For what it's worth, I tried to drag and drop a contact with a mobile phone from Outlook Express into the Palm Desktop (it goes across as vcard format) and everything came across just as it should, including the cell phone, which went into the Mobile field in the Palm Desktop.

[nanscombe]

Hi Paul,

The VCard format is a text file and has the structure below:

BEGIN:VCARD
VERSION:2.1
N:Last Name;First Name
FN:First Name Last Name
TITLE:Title
ORG:Company
ADR:;;Address;Town;County;Post Code;Country
NOTE:This is the Note
TEL;WORK:Work No
TEL;HOME:Home No
TEL;FAX:Fax No
TEL;CELL:Mobile No
EMAIL:E-Mail
X-Palm-Custom1:Assistant
X-Palm-Custom2:Spouse
X-Palm-Custom3:Children
X-Palm-Custom4:Custom 4
END:VCARD

These are all of the fields available, that I could derive, from Palm desktop. If there is no information available do not include it in the file.

It should be possible to use an MS Word mailmerge to turn your Excel spreadsheet into a series of records as above, ie:

BEGIN:VCARD
1st Person
......
END:VCARD
BEGIN:VCARD
2nd Person
......
END:VCARD
BEGIN:VCARD
3rd Person
......
END:VCARD

Palm desktop should then be able to read them correctly. It's the phrase TEL;CELL that tells it that it is a mobile.

Regards
Nigel

[paul.blitz]

The VCard format is a text file and has the structure below: <bits deleted>
[/QUOTE]

Thanks for that... isn't it so typical... the *simple* way isn't quite properly done, so you need to go the slightly more complicated route!!

I'll have to have a play with the VCard format, and see if I can make it work.

Cheers!


Paul

[nanscombe]

Hi Paul,

What you could try is ...

1) Import your records from the Excel spreadsheet, so you get the default phone number.

2) Export the records in VCard format

3) Use Wordpad, or something similar on the Vcard file to Search and replace TEL;HOME: with TEL;CELL:

4) Resave file in text file format

5) Re-Import the VCard file.

In theory that should do it.

Regards
Nigel

[paul.blitz]

What you could try is ...


Yes, I like simple ideas like that: if my brain was working today, I could probably have come up with that myself!!!!!

Cheers!


Paul

[paul.blitz]

In princple, exporting & importing the vCard worked (the "other" phone showed up simply as "TEL:", so a global change to "TEL:CELL;" did what was needed).

However, it does NOT export & import the "private" setting, so, a new question:


How can you set the "private" setting on all addresses in a category at once?


Paul

[nanscombe]

Hi Paul,

You've got me there!!!!

The only way, that I have found, to get the Export flag is via the CSV export .... Back to square 1.

Sorry.

Nigel