FAQ-1227 File Import/Export Utilities

QUESTION:

How do I use the Import/Export Utilities to import a .CSV file into the station file?

ANSWER:

The Import/Export Utilities can import or export station information in .CSV format. If you run the EXPORT utility first, it will create the .CSV file so that you can see the fields and the file format that the IMPORT utility uses.

Then you can modify the .CSV file in your spreadsheet, export it back to .CSV, and then import it back into Comm One. When you import all station information in Comm One is overwritten with the data in the .CSV file.

IMPORT/EXPORT UTILITIES

  1. Start Call Accounting
  2. Select the FILE Menu from the top menu bar.
  3. Select EXPORT Stations. A File names c:\ca20XX\export\station.csv will be created.
  4. Open the STATION.CSV File in Excel and edit it as needed. When you are done SAVE the file as a .CSV File and save it to the c:\ca20XX\export directory and overwrite the existing file.
  5. To IMPORT the csv file select FILE then IMPORT STATIONS from the top menu bar.

.CSV IMPORT/EXPORT FILE STRUCTURE

(Comma Separated)

FIELD

FIELD NAME

DESCRIPTION

Field 1

extn

Extension Number

Field 2

name

User Name

Field 3

department

Department Code

Field 4

div

Division Code

Field 5

hzip

Site

Field 6

type

Set Type

Field 7

edoth1

User Field 1

Field 8

building

User Field 2

Field 9

edoth3

User Field 3

Field 10

room

Room

Field 11

eloc

Jack Location

Field 12

edoth6

User Field 6

Field 13

edoth7

User Field 7

Field 14

edoth8

User Field 8

Field 15

edoth9

User Field 9

Field 16

edoth10

User Field 10

Field 17

edoth11

User Field 11

Field 18

edoth12

User Field 12

Field 19

edoth13

User Field 13

Field 20

edoth14

User Field 14

 

*(Where xx = the version. Example: ca2017 for the 2017 version)

 

Comm One LLC Technical Support
138 E 12300 S Ste #C102
Draper, UT 84020
385-529-5819
[email protected]

Contact Comm One
Visit the Comm One Call Accounting Web Page

Last Reviewed: 02/02/2017

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk