Difference between revisions of "Card import from CSV file"

From Kolmisoft Wiki
Jump to navigationJump to search
Line 1: Line 1:
It is possible to import calling cards from CSV file.
It is possible to import calling cards from a CSV file.


Format is simple:
The format is simple:


CARDNUMBER,CARDPIN
CARDNUMBER,CARDPIN


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


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 10 and your PIN length is 4. So you can only import cards into the Card Group which have the following values:


[[Image:card_group_lengths.png]]
[[Image:card_group_lengths.png]]


Otherwise you will get error.
Otherwise you will get an error.




Video which demonstrates Card import from CSV file:
Video which demonstrates Card import from a CSV file:


<flashow>http://wiki.kolmisoft.com/videos/card_import_from_csv.swf|width=600|height=455</flashow>
<flashow>http://wiki.kolmisoft.com/videos/card_import_from_csv.swf|width=600|height=455</flashow>

Revision as of 06:10, 24 May 2010

It is possible to import calling cards from a CSV file.

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:

1000000001,6258
1000000002,5725
1000000003,9737
1000000004,9694
1000000005,4156
....

Your Calling Card number length is 10 and your PIN length is 4. 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.


Video which demonstrates Card import from a CSV file:

<flashow>http://wiki.kolmisoft.com/videos/card_import_from_csv.swf%7Cwidth=600%7Cheight=455</flashow>