Difference between revisions of "Card import from CSV file"

From Kolmisoft Wiki
Jump to navigationJump to search
 
Line 60: Line 60:
<br><br>
<br><br>
Now you can see imported Cards in Cards list.
Now you can see imported Cards in Cards list.
<!---
 
Video which demonstrates Card import from a CSV file:
Video which demonstrates Card import from a CSV file:


<flashow>http://wiki.kolmisoft.com/videos/cciport.swf|width=600|height=455</flashow>
http://wiki.kolmisoft.com/videos/cciport.gif
--->
 
<br><br>
<br><br>



Latest revision as of 09:47, 29 January 2021

Description

MOR has possibility to import Calling Cards from a CSV file. It is useful if you got Calling Cards list in file and you want to insert those Cards into MOR.

Usage

File format

The format is simple: CARDNUMBER, CARDPIN

When importing, make sure your CARDNUMBER length and CARDPIN length match the lengths in the Calling Card Group.

Example:

You are trying to import this file:

10000000001,625825
10000000002,572585
10000000003,973748
10000000004,969498
10000000005,415685
....

Your Calling Card number length is 11 and your PIN length is 6. So you can only import cards into the Card Group which have the following values:

Card group lengths.png

Otherwise you will get an error.

Import

Step 1

In page of Cards list click on Icon add.pngAdd new Card(s) – you will reach the window where you can add additional Cards to the Card Group.

Upload selected file.

Step 2

Select columns names which corresponds Value of data:

Card import step2.png

Step 3

Step 3 let you to check, does your selected columns are in the right place (if no, click Back and correct your choices):

Card import step3.png

Step 4

In step 4 you are able to anilize import details:

Card import step4.png

Step 5

Import successfuly completed, check results:

Card import step5.png

Now you can see imported Cards in Cards list.

Video which demonstrates Card import from a CSV file:

cciport.gif



See also