Project Detail

Export Excel Contact info to simple XML schema  

Export Excel Contact info to simple XML schema is project number 262738
posted at GetAFreelancer.com. Click here to post your own project.

 

Bookmark and Share
Free Trial For New Buyers
 

Status: Closed
(Selected Service Provider)

Selected Providers: cooldev

Budget: $30-250

Created: 05/16/2008 at 3:38 EDT

Bid Count: 13

Average Bid: $ 102

05/20/2008 at 3:38 EDT

Project Creator: hubris67 View PM Post PM
Employer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10 (5 reviews)

Bid On This Project
 

Description

I want to regularly export Outlook contact info into a simple XML format for import into the Address Book on Cisco 7921G phone handsets. I'll export from Outlook into Excel, where a simple one-row-per-record layout results.

I then want you to write a macro/VB script within Excel that will do the following:

1. Prompt for a folder to put the output.
2. Create a single file with a filename of "YYMMDD HHMM Contact export for Cisco phones.xml" The Y, M, D, H and M characters should represent the date and time that the file was created.
3. Write each contact into the file in the following format:

<updateContact>
<vCard>
<N Family="lastname"
Given="firstname"/>
<NICKNAME>nickname</NICKNAME>
<ORG Orgname="company"/>
<TEL type="work" spddial=x PREF=1>0123567546</TEL>
<TEL type="home" spddial=x>0123435463456</TEL>
<TEL type="cell" spddial=x>04123345656</TEL>
<TEL type="other" spddial=x>0412343546546</TEL>
<ADR type="home" Street="street number and name"
Locality="city"
Pcode="pc" Region="state"
Country="country"/>
<EMAIL type="internet">email</EMAIL>
<IMPP>im</IMPP>
</vCard>
</updateContact>

4. Note that blank fields should not be included in the output file.
5. The speedial (spddial=x) value x should be incremented from 2 to 99.
6. An error should be generated if there are more than 98 separate contacts in the output.
7. Once the speeddial number "99" is allocated to a phone number, additional phone numbers should not have the text "spddial=x" in the TEL line. They won't have a speeddial, but will still be there.
8. The macro should work with Outlook 2007, Excel 2007 and Vista.
9. You have to provide the source as well, which will become my property.


Additional information submitted:

05/16/2008 at 8:21 EDT:
A clarification - I'm expecting an Excel macro only. I mention Outlook 2007 only to allow bidders to see what the output to Excel looks like by doing their own export.


Messages Posted: 0 View project clarification board Post message on project clarification board

Bid On This Project
 
If you are the project creator or one of the bidders Log In for more options

  View PM Post PM

150

3 days

05-16-2008 08:05 EDT

VBA developer since 1997. I hope I get it right - it is about Excel macro only, not both Outlook and Excel, isn't it? Anyway, my bid is for the Excel macro as decribed above. Excel 2007 available. Can do. Regards, Svet.

help

  View PM Post PM

120

2 days

05-16-2008 19:55 EDT

I will be pleased to apply my 12+ year experience with VB/VBA/VBS (programming for Excel inclusive) to completing your project. Please see more details in PM

help

  View PM Post PM

50

5 days

05-16-2008 03:49 EDT

Thank You for consideration!

help

  View PM Post PM

250

3 days

05-16-2008 18:23 EDT

plz view pm i have short cut for you...

help

  View PM Post PM

30

0 days

05-19-2008 06:06 EDT

Please see the PMB for a 'excel contacts to xml' demo.

help

  View PM Post PM

90

3 days

05-19-2008 06:43 EDT

Hi, I think I was the man you are looking for, I have good experiences on Visual basic macro developing, I have finished several projects on this field, such as Excel Dialer. I can get it done with rapidly response and lower bid. Thanks.

help

  View PM Post PM

30

1 day

05-16-2008 12:56 EDT

Hiii, I can easily do that. The cost is minimum.

help

  View PM Post PM

250

12 days

05-16-2008 03:40 EDT

(No Feedback Yet)

We can do you project. Please check your PM. Thanks!

help

  View PM Post PM

150

3 days

05-16-2008 13:11 EDT

(No Feedback Yet)

---------------------------------

help

  View PM Post PM

40

2 days

05-16-2008 20:32 EDT

(No Feedback Yet)

can do in short order...If you pay over $40, you've paid too much for this type of project.

help

  View PM Post PM

60

3 days

05-16-2008 21:34 EDT

(No Feedback Yet)

Hi. I've recently done the similar project. I can do it for you. Thanks.

help

  View PM Post PM

70

1 day

05-17-2008 00:25 EDT

(No Feedback Yet)

I got a vast experience in this kind of project and I can able to finish within the specified period with great accuracy.

help

  View PM Post PM

30

3 days

05-17-2008 02:52 EDT

(No Feedback Yet)

can be well done!

help

    Bid on this Project