Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

Exporting ALL Extension Settings

Discussion in '3CX Phone System - General' started by Shadragon, Feb 1, 2018.

Thread Status:
Not open for further replies.
  1. Shadragon

    Shadragon New Member

    Joined:
    Feb 1, 2018
    Messages:
    151
    Likes Received:
    15
    Howdy,

    I'm setting up a 3CX system for 200+ users who are currently on another vendors rather dated SIP system. We're doing a slow transition from one to the other. Big bang is out of the question.

    I set up an extension on 3CX the way we want new users to start. I then did a csv export of that extension and used it as a base to create a csv spreadsheet with all users to import back into 3CX. That way I don't have to manually create 200+ users. That part works fine.

    Problem is, the csv export of the example extension does not contain anything from the "Forwarding Rules" section, at least not the "Statuses" portion which is really important in our set-up. Basically, when DND status is set, the call will forward to a specific ext for internal and external calls. We set up new 3CX users with the DND toggle set (which is in the export) and a forward to an already established 3CX extension. That will allow us to transition over time with no call interruption or loss.

    How can I set the Forwarding Rules for 200'ish users with a csv import? Even better, how can I export the Forwarding Rules set-up for any given extension? Image shows the info I need.

    Thanks.

    [​IMG]
     
  2. eddv123

    eddv123 Well-Known Member

    Joined:
    Aug 15, 2017
    Messages:
    1,408
    Likes Received:
    186
    Your options that I am aware of is to use an example template from this guide:
    https://www.3cx.com/docs/bulk-extension-import/

    Or export from the 3CX System under "Extensions".

    If the settings you want (forwarding rules etc) are the same you can export all of your extensions in normally and then on the extensions page in 3CX multi-select the extensions (holding down the ctrl key) and then configure all extensions in multi-mode.

    This would save some time.
     
  3. Shadragon

    Shadragon New Member

    Joined:
    Feb 1, 2018
    Messages:
    151
    Likes Received:
    15
    Yes, they are individually tailored to each user. Editing them in a csv is trivial. Mass selecting in the 3CX web browser would take forever.

    eddv123, I saw that series of tags previously, thanks. I can turn off the FR tab but that's all.

    Will see if I can find a workaround. Typing it in manually seems so 2006. :)
     
  4. NickD_3CX

    NickD_3CX Support Team
    Staff Member 3CX Support

    Joined:
    Jun 2, 2014
    Messages:
    1,379
    Likes Received:
    84
    Unfortunately in the current implementation, the Forwarding Rules cannot somehow be mass imported.
    The reason is rather complicated to explain, but suffice to say that it has to do with how it is coded, even if you could export to CSV, the values wouldn't be something you could tweak from a text editor easily.
     
  5. Shadragon

    Shadragon New Member

    Joined:
    Feb 1, 2018
    Messages:
    151
    Likes Received:
    15
    Well, I did find a way, but it's kludgy. First step is to populate the extensions of all users via the csv upload method and add the 200 users names, emails, extensions, etc. I mass select the new numbers in the 3CX web console and edit Forwarding Rules to add discrete DND numbers.

    Then I made a backup of the entire server. Inside that save is a ZIP file containing a XML file containing all extension forwarding rules between the tags <ForwardingRules> and </ForwardingRules> I wrote a QuickBasic program to parse that file, making note of what the current extension is and look between those tags for other tags called: <Internal DN="XXX" /> and <External>XXX</External> (Where XXX is the extension to be forwarded too)

    When those tags are seen, the program then references an Excel CSV sheet I cobbled together with both the original reference extension and extension modifications then amends those numbers to what I need. It then goes through and replaces each relevant line in the XML as I want them, then saves the new line. With that done, I restore the save back to the same server and (in theory) all forwards should be what I need.

    Have not done the last part yet as I need the weekend for testing to ensure it works correctly. However, the amendment program does work and I have an updated XML file ready to go.

    For reference, my XML file was called 332407165Db.xml and was in the root of the save ZIP. YMMV
     
    Chris_ likes this.
Thread Status:
Not open for further replies.