none
How do I export email body (eml files) to excel or php for a better view (Cobian backup log) RRS feed

  • Question

  • How can I extract specific value into excel table. For example: the excel should be have some column or table:
    Total backup time:
    Backup done or error
    Backup up the task
    etc ...

    Here is the email body (Cobian backup log email - version 11)

     ------------------------------------------------------------------------------------------
    2014-11-12 19:45 The operation was successfully completed
    2014-11-12 19:45 The system can now enter sleep mode
    2014-11-12 19:45 Total backup time: 0 hours, 0 minutes, 32 seconds
    2014-11-12 19:45 *** Backup done. Errors: 0. Processed files: 2424. Backed up files: 0. Total size: 0 bytes ***
    2014-11-12 19:45 -- 
    2014-11-12 20:00 *** A new backup has started. Number of tasks in queue: 1 ***
    2014-11-12 20:00 Preventing the system from entering sleep mode...
    2014-11-12 20:00 ** Backing up the task "Server 1.5 ABC 2012" **
    2014-11-12 20:00 Counting the files for the task "Server 1.5 ABC 2012"...
    2014-11-12 20:00 Starting the Volume Shadow Copy snapshot for the drives: C:\
    2014-11-12 20:00 The Volume Shadow Copy snapshot set has been created successfully
    2014-11-12 20:00 Creating the destination directory "\\backup\192.168.1.x\ABC 2012\ABC XYZ 2012 2014-11-12 20;00;24 (Incremental)"
    2014-11-12 20:00 The destination directory "\\backup\192.168.1.x\ABC 2012\ABC XYZ 2012 2014-11-12 20;00;24 (Incremental)" has been successfully created
    2014-11-12 20:00 Backing up the directory "GLOBALROOT\Device\HarddiskVolumeShadowCopy24\ABC Group\ABC XYZ 2012"
    2014-11-12 20:00 Deleting the Volume Shadow Copy snapshot "1bb6ea17-dd31-4666-b3a9-e9aa178e8a73"
    2014-11-12 20:00 The Volume Shadow Copy snapshot set has been successfully deleted
    2014-11-12 20:00 Total backup time for "Server 1.5 ABC 2012": 0 hours, 0 minutes, 25 seconds
    2014-11-12 20:00 ** Backup done for the task "Server 1.5 ABC 2012". Errors: 0. Processed files: 2314. Backed up files: 1. Total size: 3.37 KB **
    2014-11-12 20:00 --

    Tuesday, November 18, 2014 4:35 AM

All replies