Jump to content
KAZOOcon: hackathon signup and details here! ×
  • 2600Hz-logo-RGB copy.png

    Welcome our Monster UI Apps Resource Pages!
    Below is a list of the applications developed by 2600Hz for KAZOO using the Monster UI Interface and documentation related to it. 
    If you have a question that is not covered here, check out our community forums.  

          Featured Apps

      New Updates!    Check it out!     

               SmartPBX_x512.png          

              CallCenter-PRO_x512.png          

              PortingManager_x512.png          

             commio_AppIcon-updated_round_x512.png          

             \DynamicCallerID.png            

             CallThruUs_x512.png          

    Smart PBX

    Call Center Pro

    Porting Manager   Comm.land   Dynamic Caller ID CallThru.us

     

    >>  2600Hzroundorangelogo.png  Return to Monster Apps Home Page  

     

  • CSV Onboarding User Guide


    2600HZ STEP GUIDE  CSV Onboarding

    CSV Onboarding is a tool that allows you to enter an exported list (.csv file) of users and (optionally) phone data into the KAZOO environment.  This replaces the process of entering the most common data manually when you are first setting up your users.

    Before you Start

    • Create a .CSV (Comma-Separated Values) export file from your existing phone list. 
      The following fields are used by KAZOO; you can create the same fields or if there are existing field names, map what is imported to the KAZOO names.

      first_name, last_name, password, email, extension, notification_emailmac_address,  brand, family, model
       
    • NOTES
      • If you want to upload User names only, the fields after extension are not required.
      • Notification_email field is optional for either onboarding option.
      • Double-check the field name and spelling of your phone model.  It must match the syntax and capitalization exactly for the import to be successful.

    Quick Steps

    1. Open the CSV Onboarding app.
    2. Choose if you want to Add Users only, or Add Users & Devices
    3. Drag the .csv file you created into the box and pick Proceed.
    4. You will see your imported file.  The top row above the drop down fields displays the fields in your .csv file.
    5. Using the drop-down fields, select the KAZOO field you want the .csv field to map to.
    6. If you have advanced programming knowledge, enter your json payload information for 
    7. Pick Proceed.   The screen will follow your progress. 
    8.  If you want to cancel, close the window.
       
     
    Detailed Steps

    Activate and open the CSV Onboarding app.

    CSVJobsManager_x512.png

    Choose whether to onboard Users Only or Users and Devices

    CSV Onboarding Opening Page.png

    Adding Users Only
    You will see the screen below.  Check your .csv file to make sure it includes a header row with the fields mentioned. 

    • NOTE: If the header is different, you will be able to match/change that in the next step, but the values for the columns must match.


    CSV Onboard Add User Only.png

     

    Preview your imported fields and its data

    Once you upload the file, the CSV app will map the fields it recognizes to the account fields and provide you with an account of what is still missing.  You will see a preview of the result.

    csv mapping required records.png

    What to look for as you review this page:

    • The information box will let you know how many fields are recognized,
    • The "required records mapped" counter to the right will indicate if you have additional records to map before a successful import.
    • The fields displayed above the drop down field options are the fields that were imported from your .csv file. 
    • The field names in the drop down are the proposed match to your import file.  You will need to verify this is correct.
    • If the field is empty and should map to a required field in the drop down options, you must assign it a value.  
    • All required fields must be mapped to one of the columns you have imported so the system will be able to place them in the correct instance.
    • If some fields are empty they will transfer as empty. 
    • Make sure to scroll to the right to see all the fields.

    Map any remaining "missing" fields 

    Your next step is to map the fields you've imported with the fields required by the Account.  In this case,

    • the "Contact" field can be mapped to the required "email" field, and
    • the "pwd" field can be mapped to Password. 

    Click on the field to remap, and then click on the account field to match it with in the drop down.  Once these are defined, you should see the "Required records mapped" indicator turn to green and all the Required Columns/Headers in the drop down display a green checkmark.

    The JSON Checkbox
    At the bottom of the screen near the Proceed button, you will see a checkbox asking if you want to add a JSON config.  
     

    CSV Onboarding JSON Checkbox.png

    This is available for advanced programmers who may want to add some custom settings for voicemail boxes, call parking and other feature codes using JSON. If you check the box at the bottom of the screen you will be prompted to add your code into one of 3 different fields:  User Settings, Device Settings, or Voicemail Box Settings.   Some reference information about these settings is included at the end of this document.

    You're ready for the Import!   Click Proceed

    You will see a screen like this:

    CSV Onboard In Progress.png

    If the import process finds an error and cannot import some of your records, you will see a screen similar to below:

    CSV import error users not unique.png

    In this case the error, "email is not unique for this account likely means you already have a user imported that has the same email.  If you want to add devices to the already existing user, you will need to go to SmartPBX and add them there.

    If the import is complete without errors, your screen will look more like this:

    CSV import success screen.png
     

      Importing both Users and Devices

      If you have a more robust .csv file that includes device details, you can also include them in your import.  At the first step, select "Add Users and Devices."   At a minimum, you will need the following fields:

      first_name, last_name, password, email, extension, notification_emailmac_address,  brand, family, model

      The email, extension and mac_address values must be unique, and not already added in the database.   The notification field is optional. 
      NOTE: Once imported, you are not able to adjust a device's brand, family, or model information without deleting and recreating a device, so please ensure your information is accurate.

      From here the process is the same as importing just users.   Note you may have to use the scroll button an the bottom of your screen to view all the fields you've submitted for import.  

      Sample .csv file


      Sample CSV File with Device list added

      Spreadsheet First

      CSV Onboard sample csv file.png
       

      Then saved as a .csv file, will look like something like this, commas separating the fields.
      MAKE SURE THERE ARE NO SPACES!   This will block the import.

      first_name,last_name,login,email,extension,notification_email,mac_address,Phone,Family,Type
      AUser,One,userone,auser@test.com,101,test@test.com,00-15-E9-2B-99-3C,111-22-1231,aaa,111
      BUser,Two,usertwo,buser@test.com,102,,00-15-E9-2B-99-3D,111-22-1232,bbb,222
      CUser,Three,userthree,cuser@test.com,103,,00-15-E9-2B-99-3E,111-22-1233,aaa,111
      DUser,Four,userfour,duser@test.com,104,,00-15-E9-2B-99-3F,111-22-1234,bbb,222
      EUser,Five,userfive,euser@test.com,105,test@test.com,00-15-E9-2B-99-3G,111-22-1235,aaa,111
      FUser,Six,usersix,fuser@test.com,106,,00-15-E9-2B-99-3H,111-22-1236,bbb,222
      GUser,Seven,userseven,guser@test.com,107,test@test.com,00-15-E9-2B-99-3I,111-22-1237,aaa,111

       

      Starter Template .csv file


      For starters, you  can use this file as a template, provided in our community forums.

      Frequently Asked Questions

      Check out our CSV Onboarding FAQ document HERE.

      JSON Reference links


      To add your custom JSON payloads, check the box that says "add JSON", and you will see this screen.  It shows an added script to assign a voicemail box.  For additional reference to the syntax for JSON scripts, check the links below.

      CSV Onboard JSON page with VM code.png

      Devices: https://docs.2600hz.com/supported/applications/crossbar/doc/devices/
      Users:  https://docs.2600hz.com/supported/applications/crossbar/doc/users/
      VoiceMail:  https://docs.2600hz.com/supported/applications/crossbar/doc/voicemail/

       

       

      API Reference Links

        docs.2600hz.comdocs.2600hz.com

      REST API Reference for Kazoo Crossbar API
       
      docs.2600hz.comdocs.2600hz.com
      REST API Reference for Kazoo Crossbar API
       
      docs.2600hz.comdocs.2600hz.com
      REST API Reference for Kazoo Crossbar API

      #####

      CSV-Onboarding_x512.pngCSV Onboard successful upload.pngCSV Import Preview re-mapping.pngCSV import screen.png

      Edited by Emily R (show revisions)




      User Feedback

      Recommended Comments

      There are no comments to display.


    ×
    ×
    • Create New...