How can we help you today?
Start a new topic

Contacts list on excel sheets to xml

Hello,

I'd like to transfer a contact list from excel into a snom. I would like to know if it's possible to find the diagram format to export an excel file into an XML file like the one we get when we export our contacts from a snom phone.

My Excel format:

image


I'd like to be able to insert these kind informations on the snom by using an xml file exported from excel, adding to the contact both number on the phone.


I found this xml which show how it's formated on an xml file exported from a snom:

<?xml version="1.0" encoding="utf-8"?>
<tbook e='2' complete="true">
  <item context="active" type='master' fav="false" mod="true">
    <!-- 
        the following tags can reside only in the master entry:
        * first_name
        * last_name
        * birthday
        * fav
    -->
    <!--
        the following tags can reside both in the master or in a member entry:
        * group
        * title
        * organisation
        * email
        * note
    -->
    <!--

        the following tags can reside only in a member entry:
        * name (this is just an alias for the number, not the person)
        * number
        * type
        * context (attribute of the 'item' tag meaning the outgoing identity)
    -->
    <name>Johnny</name>
    <!-- the number in the Master entry is used as an identifier linking referred by the Member entries -->
    <number>123</number>
    <first_name>John</first_name>
    <last_name>Doe</last_name>
    <title>Mr.</title>
  </item>
  <item context="active" context="line2" type='' fav="false" mod="true">
    <!-- Member entry of the Master entry with number 123 -->  
    <last_name>123</last_name>
    <number>003912345678</number>
    <!-- in Member Entry should be "Member_Alias" -->
    <first_name>Member_Alias</first_name>
    <number_type>home</number_type>
    <title>Boss</title>
  </item>
  <item context="active" type='' fav="false" mod="true">
    <!-- Member entry of the Master entry with number 123 -->  
    <last_name>123</last_name>
    <number>003933812345</number>
    <!-- in Member Entry should be "Member_Alias" -->
    <first_name>Member_Alias</first_name>
    <number_type>business</number_type>
  </item>
  <item context="active" type='' fav="false" mod="true">
    <!-- Member entry of the Master entry with number 123 -->  
    <last_name>123</last_name>
    <number>003987654321</number>
    <!-- in Member Entry should be "Member_Alias" -->
    <first_name>Member_Alias</first_name>
    <number_type>mobile</number_type>
  </item>
  <item context="active" type='' fav='false' mod="true">
    <name>Adrian</name>
    <number>42965</number>
    <number_type>fixed</number_type>
  </item>
</tbook>

 Now comes the true problem. Is there any existants xls and xml files which contains the right format to do this?

 



1 Comment

As you already posted here its an example


<tbook e="2">

 

 

<item context="" type="none" fav="false" mod="true" index="0">

 

<number>100</number>

<number_type>sip</number_type>

<first_name>Reception</first_name>

<birthday>00/00/99</birthday>

</item>

<item context="" type="none" fav="false" mod="true" index="1">

 

<number>150</number>

<number_type>sip</number_type>

<first_name>Room Service</first_name>

<birthday>00/00/99</birthday>

</item>

<item context="" type="none" fav="false" mod="true" index="2">

 

<number>180</number>

<number_type>sip</number_type>

<first_name>Laundry</first_name>

<birthday>00/00/99</birthday>

</item>

</tbook>



Let me know if this helps
Let me know if this helps

Login or Signup to post a comment