6.
On the
Text Import Wizard - Step 3 of 3
window, select all columns in
Data preview
, select
Text
in
Column data format
, and then click
Finish
.
The TSV file will be opened.
Note
•
Phone numbers must be treated as text strings. Otherwise, a "0" at the beginning of a phone number
might disappear when exported.
To save the phonebook data for importing to the unit
1.
After editing the phonebook entries, click
Office Button
, and then
Save As
.
Assign record IDs manually before saving.
2.
Enter a file name in
File name
, and select
Unicode Text
in
Save as type
.
The file will be saved in UTF-16 little endian with a BOM. Fields will be separated by tabs.
3.
Click
Save
.
A message warning you about file compatibility will be displayed.
4.
Click
Yes
.
The file will be saved as a Unicode text file, with the fields separated by tabs.
Note
•
The procedure may vary depending on the software version of Microsoft Excel. Therefore, files
exported and imported between the unit and Microsoft Excel are not always compatible with each
other.
6.1.3 Exporting Data from Microsoft Outlook
You can export address book data stored in programs such as Microsoft Outlook, and then edit the exported
data with a program such as Microsoft Excel in order to import it to the unit.
To export the Microsoft Outlook address book data
1.
In Microsoft Outlook, click
File
, and then click
Import and Export
.
2.
Select
Export to a file
, and click
Next
.
3.
Select
Tab Separated Values (Windows)
, and click
Next
.
4.
Select
Contacts
, and click
Next
.
5.
Click
Browse
, select a folder, and then enter the file name to export the data to.
6.
Click
OK
.
6.1.3 Exporting Data from Microsoft Outlook
Document Version: 2017-07
Administrator Guide
363
