Knowlege base

Delete and reimport all calls on Billy Blue's 4 for Cisco UC

Article ID: 375
Last updated: 15 Jun, 2020

Applies to: 

Billy Blue's 4

Description: CLUSTER ENVIROMENT

Delete and reimport all calls on Billy Blue's 4

Solution:

Please follow this procedure:

  1. Stop the ‚ÄčImagicle Replication Service from the Windows Service Panel


     
  2. Stop the Blue's Service Host from the Windows Service Panel


     
  3. Backup your storicoSITE.txt (\StonevoiceAS\Apps\BillyBlues\Engine\BluesrecPro) file.
    This file contains all calls imported up to now, so it's the most important file, take it care.
  4. Delete all your calls (make sure to backup of your Storico files)
    PLEASE NOTE: here under queries will delete ALL your calls, so please make sure you have backed up your database before running the queries

    To perform this task you can't delete calls in company data manually but you need a query to delete calls in the BillyBlues Database.
    Install Microsoft SQL Server Management Studio and use it to run this query:

    
    truncate table chiamate
    truncate table chiamateinterne
    truncate table scarti
    truncate table scarti_tracking
    truncate table chiamate_tracking
    truncate table chiamateinterne_tracking 
    
    
  5. Re-import your calls
    Open the "\StonevoiceAS\Apps\BillyBlues\Engine\BluesrecPro" folder
    This folder contains one or more historical files (512Mb for each one) - StoricoSITE.txt or StoricoSITE_YYYYMMDD.txt
    Open the \StonevoiceAS\Apps\BillyBluesEngine\BluesrecPro
    Make a copy of StoricoSITE.txt in the same folder and rename it in 'BluesrecSITE.txt' (it will be replaced) 

     
  6. Start Billy Blue's services, miner will start importation, this process may take a while to complete.
  7. If you want to import older calls, repeat this procedure (Re-import your calls)
    using StoricoSITE_YYYYMMDD.txt files when the BluesrecSITE.txt is empty (0kb).
     
  8. Start Imagicle Replication Service at the end of the procedure.


 

Description: Standalone - one server only

Delete and reimport all calls on Billy Blue's 4

Solution:

Please follow this procedure:

  1. Stop the Blue's Service Host from the Windows Service Panel


     
  2. Backup your storicoSITE.txt (\StonevoiceAS\Apps\BillyBlues\Engine\BluesrecPro) file.
    This file contains all calls imported up to now, so it's the most important file, take it care.
  3. Delete all your calls (make sure to backup of your Storico files)
    PLEASE NOTE: here under queries will delete ALL your calls, so please make sure you have backed up your database before running the queries

    To perform this task you can't delete calls in company data manually but you need a query to delete calls in the BillyBlues Database.
    Install Microsoft SQL Server Management Studio and use it to run this query:

    
    truncate table chiamate
    truncate table chiamateinterne
    truncate table scarti
    
    
    
  4. Re-import your calls
    Open the "\StonevoiceAS\Apps\BillyBlues\Engine\BluesrecPro" folder
    This folder contains one or more historical files (512Mb for each one) - StoricoSITE.txt or StoricoSITE_YYYYMMDD.txt
    Open folder \StonevoiceAS\Apps\BillyBluesEngine\BluesrecPro\
    Make a copy of StoricoSITE.txt in the same folder and rename it in 'BluesrecSITE.txt' (it will be replaced) 
     
  5. Start Billy Blue's services, miner will start importation, this process may take a while to complete.
  6. If you want to import older calls, repeat this procedure (Re-import your calls)
    using StoricoSITE_YYYYMMDD.txt files when the BluesrecSITE.txt is empty (0kb).
     

Article ID: 375
Last updated: 15 Jun, 2020
Revision: 12
Views: 376
Print Export to PDF Subscribe Share
This article was:  
Prev   Next
How to modify the Scheduled Reports attachment size limit     Billy Blue's scheduler service does not start after changing...