provided by Star2Billing S.L.

when the prefix is longuer than 10 (11 or higher) digits, the record is in the base (in the cardrate table and in the prefix table) but in the webgui interface, the destination is empty, only the prefix is shown.

Do you have this prefix in the table cc_prefix ?

Yes,

in fact, they are imported in a csv file

regards

can you send us an example of your csv files, just 5 - 10 lines with which you can reproduce your issue ?
Which version of a2billing do you use ?

yours,
Areski

prefix;destination;sellrate;buy rate;initB


the file:
******************
999393;Afghanistan;0.2342;0.1372;30
99939370;Afghanistan Mobile;0.2438;0.1428;30
99939375;Afghanistan Mobile;0.2438;0.1428;30
99939377;Afghanistan Mobile;0.2438;0.1428;30
99939378;Afghanistan Mobile;0.2438;0.1428;30
99939379;Afghanistan Mobile;0.2438;0.1428;30
9993355;Albania;0.0499;0.0292;30
999335567;Albania Mobile;0.2991;0.1752;30
999335568;Albania Mobile;0.2991;0.1752;30
999335569;Albania Mobile;0.2991;0.1752;30
9993213;Algeria;0.0710;0.0416;30
99932135;Algeria [Wataniya];0.3515;0.2059;30
999321355;Algeria [Wataniya];0.3515;0.2059;30
99932136;Algeria Mobile;0.3609;0.2114;30
99932137;Algeria Mobile;0.3609;0.2114;30
99932139;Algeria Mobile;0.3609;0.2114;30
99931684;American Samoa;0.0470;0.0275;30
9993684;American Samoa;0.0470;0.0275;30
99931684252;American Samoa Mobile;0.0493;0.0289;30
99931684254;American Samoa Mobile;0.0493;0.0289;30
99931684258;American Samoa Mobile;0.0493;0.0289;30
9993376;Andorra;0.0268;0.0157;30
99933763;Andorra Mobile;0.2289;0.1341;30
99933764;Andorra Mobile;0.2289;0.1341;30
99933766;Andorra Mobile;0.2289;0.1341;30
9993244;Angola;0.1378;0.0807;30
999324491;Angola Mobile;0.1508;0.0883;30
999324492;Angola Mobile;0.1508;0.0883;30
999324493;Angola Mobile;0.1508;0.0883;30
99931264;Anguilla;0.0992;0.0581;30
99931264235;Anguilla Mobile;0.1315;0.077;30
99931264469;Anguilla Mobile;0.1315;0.077;30
99931264476;Anguilla Mobile;0.1315;0.077;30
99931264536;Anguilla Mobile;0.1315;0.077;30
99931264537;Anguilla Mobile;0.1315;0.077;30
99931264538;Anguilla Mobile;0.1315;0.077;30
99931264539;Anguilla Mobile;0.1315;0.077;30
******************

I got a fix for this but it will harm ur database for a moment if you have lot of rates :

just apply the following,

ALTER TABLE `cc_ratecard` CHANGE `destination` `destination` BIGINT( 20 ) NULL DEFAULT '0';


Yours,
/Areski

thanks a lot