Difference between revisions of "Card import from CSV file"

From Kolmisoft Wiki
Jump to navigationJump to search
 
(9 intermediate revisions by 3 users not shown)
Line 1: Line 1:
It is possible to import calling cards from CSV file.
=Description=


Format is simple:
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.
<br><br>
=Usage=


CARDNUMBER,CARDPIN
==File format==


When importing make sure your CARDNUMBER length and CARDPIN length matches lengths in Calling Card Group.
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:
Example:


If you are trying to import such file:
You are trying to import this file:


  1000000001,6258
  10000000001,625825
  1000000002,5725
  10000000002,572585
  1000000003,9737
  10000000003,973748
  1000000004,9694
  10000000004,969498
  1000000005,4156
  10000000005,415685
  ....
  ....


That means that your Calling Card number length is 10 and PIN length is 4. So you can only import such cards into Card Group which has such values:
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:
<br><br>
[[Image:card_group_lengths.png]]
<br><br>
Otherwise you will get an error.
<br><br>
==Import==


[[Image:card_group_lengths.png]]
===Step 1===
In page of Cards list click on [[Image:icon_add.png]]'''Add new Card(s)''' – you will reach the window where you can add additional Cards to the Card Group.
 
Upload selected file.
<br><br>
===Step 2===
 
Select columns names which corresponds Value of data:
<br><br>
[[File:card_import_step2.png]]
<br><br>
===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):
<br><br>
[[File:card_import_step3.png]]
<br><br>
===Step 4===
 
In step 4 you are able to anilize import details:
<br><br>
[[File:card_import_step4.png]]
<br><br>
===Step 5===
 
Import successfuly completed, check results:
<br><br>
[[File:card_import_step5.png]]
<br><br>
Now you can see imported Cards in Cards list.
 
Video which demonstrates Card import from a CSV file:


Otherwise you will get error.
http://wiki.kolmisoft.com/videos/cciport.gif


Video which demonstrates Card import from CSV file:
<br><br>


=See also=


<flashow>http://wiki.kolmisoft.com/videos/card_import_from_csv.swf|width=600|height=455</flashow>
* [[Calling Card management]]

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