Date: Fri, 29 Mar 2024 16:20:37 +0100 (CET) Message-ID: <479792802.3736.1711725637397@teamwork> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_3735_1620548309.1711725637397" ------=_Part_3735_1620548309.1711725637397 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Valid for: |
N610 |
N670 |
N870 |
N870E |
|
Virtual Integrator |
To make it easier to create a phone-book file, we have created an = example excel file with Macro's you can use the create the phonebook.xml fi= le.
Download the excel file here: CentralPhonebook_V3.3.xlsm
if your excel complains about the Macro's, you need to put this file int= o a trusted location. This is a folder on your PC.
In excel go to Options - Trust Center - Trusted Locations - Add = new location and select the folder where you store the excel file.= Now you are allowed to run the Macro's.
With:
Important
XML cannot handle the character "&" and should therefore be replaced=
by "&" to be able to upload the XML file in the N670 or N870.
Use CTRL + r Replace [&] with [&]
Here is an example how to export your Microsoft office contacts into an = CSV file.
In Microsoft office go to: File - Open & Export - Import/Exp= ort - Export to a file
Comma Separated Values
Select your contacts folder
Select your destination folder
Map Customer Fields
Adjust on the right side the To: field to have the foll= owing fields and using the same sequence.
Press Finish to generate the CSV file
Open de Gigaset excel file and via CTRL+l select the ab= ove CSV file, all contacts are visible in the excel file.
The Macro will remove special characters and changes the numbers to numb= ers the Gigaset phone understands.
The Macro (CTRL + w) generates the phonebook.xml file and stored in= the same folder as the excel file is stored.
In the N870/N670 go to: SETTINGS - Online directories - Central = phonebook - Load phonebook from PC and select your phonebook.xml f= ile.