Seb T. (job poster) hired Anne D. (Tasker) to help with this task. Got a similar task you need done?

187 x .msg files to a sincle .xlsx

Posted by Seb T.



Due date
Monday, 19th Aug 2013
Hi guys,

I have 187 emails in a .msg format which I need entered into a spreadsheet. Each email has the following format:

Uncaught Exception: MySQL error : Duplicate entry [...] (<error details>):
Stack Trace:
#0 <path to file 1>(<line a>): ...
#1 <path to file 2>(<line b>): ...
#2 <path to file 3>(<line c>): ...
I need this extracted into a spreadsheet as;
Message (number in the filename): 1 (this is in the file name)
Error (detail of the uncaught exception): MySQL error : Duplicate entry [...]
File (#0 in the stack trace): <path to file 1>
Line (line number fir #0 in the stacktrace): <line a>
All .msg and a sample xlsx file will be handed over to the winning runner for completion in the coming **24 hours**. This data is confidential in nature and must remain as such. ie cannot be published in any way and must be destroyed after completion.
My estimate:
Copy+paste 3 distinct bits for 1 message: 20 sec
Copy+paste 3 distinct bits for 187 messages: 62 minutes.
Copy+paste 3 distinct bits for 187 messages, efficiently: < 60 minutes

All files are in dropbox ready to be shared.

Anne D.
94%Completion rate

The percentage of accepted tasks this Tasker has completed.

Task Activity
6 comments about this Task
Comments are now closed
Seb T.poster
Hi David, I've assigned to Anne given she responded before and could use a positive review to fill in her profile. ;0)

Anne, will share the dropbox folder with you in private.

Hi Sebastien. I can start immediately and have the work completed today.
Hi Sebastien,
It seems pretty straightforward. I should be able to do it this afternoon.
Regards, Anne
Seb T.poster
Hi Jeff, the .xlsx is at https:// /s/ 6/Errors.xlsx and a sample message (obfuscated) with data to be extracted in green is at https:// /s/ttw7klss9ysgeco/Screen-Shot- at-12.46.37-PM.jpg

can i have access to the file to see what if i can do the task quickly :)
Task Assigned
0 new tasks