Announcement

Collapse
No announcement yet.
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • hombre
    replied
    strangely we've been able to upload successfully the accountcode, accountcodeinput and accountname; and we still get the invalid code response from system. If we enter the code from within the shaoreware director then it gets placed as a valid code. what does the shoreware director turn on that importing it does not?

    Leave a comment:


  • mwyatt2
    replied
    Thanks svalles. I got this to work in 11.2 using a slightly modified version of your script.

    USE shoreware;
    LOAD DATA LOCAL INFILE '/scripts/AccountCodes.csv'
    INTO TABLE accountcodes
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '\r\n'
    (AccountCode, AccountCodeInput, AccountName);


    BTW, for anyone that hasn't done it, you'll need to make sure you connect to the MySQL instance that contains your configuration Database... Seems obvious to me now, but it took me a few minutes to work it out.

    Leave a comment:


  • svalles
    replied
    This is what we do for our customers and it works you do have to restart the account code service though.

    Here are the steps

    1. Export you account codes into a .CSV file and name it anything in this example i'll name it AccountCodes.csv format should be like below

    1037,1037,Mike Jones
    1040,1040,Nancy Smith

    "Notice the account code is there twice, also make sure there is no commas in the name, and spaces are okay"

    2. Run this script below to import from AccountCodes.csv which is located in the root of C:\

    LOAD DATA LOCAL INFILE '/AccountCodes.csv'
    INTO TABLE accountcodes
    FIELDS TERMINATED BY ','
    LINES TERMINATED BY '\r\n'
    (AccountCode, AccountCodeInput, AccountName);

    Leave a comment:


  • bluepointe
    replied
    We will test this on the demo system in a few days to see if that makes a difference. Glad I have a engineer who knows how to work with MySQL. :-)

    Thanks for the information.

    Leave a comment:


  • Palitto Consulting
    replied
    Did you restart the account code service after import? The changes only are refreshed when the appropriate trigger is fired or about once a day.

    Leave a comment:


  • bluepointe
    replied
    Version 8.0 - We contacted TAC and they stated it was not possible.

    We tried to back door this but when we attempted to import using MySQL Query Broswer the account codes appeared in the list but stated invalid when used.

    Would be nice to have them add this as a feature as well as a PRINT feature.

    Thanks.

    Leave a comment:


  • Palitto Consulting
    replied
    Later versions use MySQL to store the config, but it is stored in much the same format. You should be able to use the MySQL ODBC driver and some other program such as OpenOffice Base or maybe even a linked table in Access to do the import. Note this isn't supported by Shoretel, but I don;t see why it won't work. :_smile:

    Leave a comment:


  • phemiii
    replied
    what version is it? if its 7.5 you can import in MS access, use a excel spreadsheet, with the headers AccountCodeID

    AccountCode

    AccountCodeInput

    AccountName

    then import the spreadsheet into the database as a table, the account codes will be there.

    Leave a comment:


  • bluepointe
    started a topic Import Account Codes

    Import Account Codes

    We would like to request a way to import Account Codes.

    One of our customers is a law firm that wants to have all their client numbers entered for LD calls. We have to manually input 1753 client numbers into the system.

    This would be a nice add on for the future.

    Thanks.
Working...
X