Imagicle Call Analytics
Imagicle Call Analytics
Breadcrumbs

How to clean-up SQL Server call archive with multiple StoricoSITE files and re-import it from a "Storico" file

Applies to:

Imagicle UCX Suite, any version.

How-to:

  1. Stop Blue's Service Host service from the web interface (CallAnalytics → Administrative Pages → Service Manager) or via the Windows Service Panel

    image-20250117-150539.png

  1. Make a copy of "storicoSITE"

    image-20250117-150545.png

  1. Extract each "storicoSITE_[Date].zip" that you need to reimport (example "storicoSITE_20221129.zip")    Example:

    image-20250117-150559.png

If the SITEBluesrecSITE_D.txt is not empty, contact our support team.

Example with SITE code:If the SITEBluesrecSITE_D.txt is empty-> Rename StoricoSITE(copy).txt -> SITEbluesrecSITE_D.txt

image-20250117-150609.png

  1. Rename "StoricoSITE" extracted before sorting them from oldest to newer (D0001, D0002, D0003, etc.)
    Example: 20221129 newer then StoricoSITE_20220815(copy).txt, so:

    • "StoricoSITE_20221129(copy).txt" → SITEbluesrecSITE_D0002.txt

    • "StoricoSITE_20220815(copy).txt" → SITEbluesrecSITE_D0001.txt

NOTE: if you have a long sequence of storico files to re-import, you can use the attached Powershell script to automate the files uncompression and renaming of the multiple StoricoSITE_xxxxxxxx.zip files.

  1. Start Blue's Service Host service from the web interface (CallAnalytics → Administrative Pages → ServiceManager) or via the Windows Service Panel

  2. Wait for the re-import to be accomplished.

  3. Now you can safely run the SQL query to remove date. See here for more details.

UncompressStoricoFilesForReimport.zip


Last updated: