Import Rates file, template?

Discussion in 'General' started by agidi, Jul 12, 2008.

  1. agidi

    Joined:
    Jan 13, 2008
    Messages:
    152
    Likes Received:
    0
    Hello

    I've searched, and have not been able to find a template/guide/reference on how to format the rates file to import into elastix
    I've tried several guesses with no luck.

    Any developer or coder, can help us with that?

    looking forward to this

    best wishes
    A.Gidi
     
  2. mandimandi

    Joined:
    Jan 19, 2008
    Messages:
    25
    Likes Received:
    0
    I signed the same question and wait the answer.
    Bye from Roby
     
  3. mandimandi

    Joined:
    Jan 19, 2008
    Messages:
    25
    Likes Received:
    0
    I signed the same question and wait the answer.
    Bye from Roby
     
  4. agidi

    Joined:
    Jan 13, 2008
    Messages:
    152
    Likes Received:
    0
    Ok some advance

    I managed to have elastix import ONE line.

    The format goes like
    prefix;name;rate;Rate Offset

    My file looks like:
    1120;egypt proper;0.30706;0.0
    112010;egypt cellular;0.25298;0.0
    112011;egypt cellular;0.30706;0.0
    112012;egypt cellular;0.25298;0.0
    112016;egypt cellular;0.30706;0.0
    112018;egypt cellular;0.30706;0.0
    11202;egypt cairo;0.30706;0.0
    11203;egypt alexandria;0.30706;0.0
    11212;morocco proper;0.27079;0.0

    Problems, I can only get the first line imported, and if I change rate from 0.0 to 2.32 it
    reports an error.

    Could someone try it on their boxes? I'm using the very latest iso release, yum updated.
    Please report.
    thanks
     
  5. Ichorcom007

    Joined:
    Apr 16, 2008
    Messages:
    52
    Likes Received:
    0
    I THINK THIS IS A EXTREAMLY IMPORTANT PART OF ELASTIX!!!!! I HAVE BEEN TRYING TO GET ANSWER FROM COMMUNITY FOR SINCE FEATURE WAS OFFERED SOMEONE PLEASE HELP!!!!!!!!!!!!!!!!!
     
  6. fozzygomad

    Joined:
    Aug 21, 2008
    Messages:
    23
    Likes Received:
    0
    Hi all hope this info helps. I have successfully managed to import 3000 + rates into my Elastix box. Here is how I did it.
    1. The rates must be in the following format within a text file (.txt)
    prefix;name;rate;rate offset;trunk
    a. Prefix format: It is pretty simple but here is the general rule. Use numbers from 1 to whatever. If using a zero (0) then it has to have another digit. E.g. 01, 012, 021 etc. Just using 0 will give an error.
    b. Name format: I think anything can be used here but I found it was having a problem with spaces so I used a program like Dreamweaver to find and replace the spaces with spaces. Makes no sense at all but it worked.
    c. Rate format: rates are on decimal format like 0.00 or sometimes even 0.000
    d. Rate Offset format: I found that using 0.000 format to be safe. It has a problem with 0, 0.0, 0.00 so do yourself a favour and put in an extra zero.
    e. Trunk format: The trunks are important because it calculates your rates based on trunks and if the spelling or format is wrong it won
     

Share This Page