A welcome message from the affiliate who referred you:
Hello,
My name is Sergey, nickname TakeReal. I am Freelancer from St.Petersburg, Russia.
I offer great help for my affiliates.
Looks like you are my affiliate, so you can contact me if you have questions about VWorker.com. E-mail: Sergey(at)TakeReal.com
I know VWorker.com inside out because I work via VWorker.com since 2003.
I have 1038 completed jobs so far. My VWorker profile: http://bit.ly/takereal
--
Sergey aka Takereal. |
|
Log Parser
Project Id: 1495297
|
|
|
|
Description
|
Posted by: |
Mentalix (3 ratings)
(Employer rating 10 )
|
|
Non-action ratio: |
Very Good - 20.00%
|
|
Employer security verifications: |
  Excellent
|
|
Approved on: |
Sep 10, 2010
1:36:48 PM EDT
|
|
Bidding closes: |
Sep 20, 2010
12:00:00 PM EDT
|
|
Viewed (by workers): |
1402 times
|
|
Deadline: |
Tuesday Oct 5, 2010 3:08:39 PM EDT
(14 days after 9/21/2010 3:08:39 PM)
|
|
|
 Sourcing Type: Outsourcing
This is an outsourcing project.
To apply,
place your bid below and we'll notify you if the employer
picks you
to work on it.
Since this is a pay-for-deliverables project, you will
bid a fixed price to complete the entire job.
If you win and complete the work according to contract,
you will be paid completely at the end (or partially as each of your optional
milestones arrive).
vWorker.com
guarantees payment to all workers who
meet their contracts.
 Brief summary:
We receive log files via email (plain TXT attachments) that we need dumped into a SQL Server Express database.
The database would have a table for each customer/email address, and 6 columns denoted by the ; delimiter, each time stamp line would be given it's own row in the db.
We are running Windows SBS 2003 SP2 + Exchange 2003 SP2 right now and hope to have this script running (as a service maybe) on that machine to process emails as they arrive. We are open to ideas for implementation, code language, etc.
Include a brief description of how you would approach this app along with your bid.
Requirements Interview Answers:
To help you bid more accurately, the employer was interviewed about the requirements for this project. Below are their answers.
Untitled Page
Detailed Requirements:
vWorker.com requirements notice: As originally posted, this bid request does not have complete details. Should a dispute arise and this project go into arbitration "as is", the contract's vagueness might cause it to be interpreted against you, even though you were acting in good-faith. So for your protection, if you are interested in this project, please work-out and document the requirements onsite.
This broadcast message was sent to all bidders on Friday Sep 10, 2010 2:03:04 PM: We are not running Outlook (or Express), this is the Exchange server that would prefer it to run on as a SERVICE or SYSTRAY app. Bid accordingly.There is no POP3 available to retrieve the messages, they are in an Exchange mailbox. They will not be in a folder on the C:\. If you so choose, you can write two programs, one to extract the attachment and drop in it a folder and a second to query the folder, parse it, and dump it to the database.
This broadcast message was sent to all bidders on Friday Sep 10, 2010 2:12:36 PM:
ZIP with log files uploaded.
This broadcast message was sent to all bidders on Friday Sep 10, 2010 2:27:30 PM:
Log event example:
Sep 9 2010 1:46:56:433PM; PRINT_bgrd; ; Certified-55502159681 (1 in queue) (MDE Size=24.9 MBytes); bookin;
should be parsed as (database columns):
SQLdatetime ; Event ; MessageID ; Description ; User ; Notes
These events start at line 3 of the log file.
At the bottom of the log file is a summary of those events. That can be ignored.
This broadcast message was sent to all bidders on Friday Sep 10, 2010 2:42:55 PM:
A mailbox query interval time setting would be nice. In minutes, or hours. It does not have to import the logs the instant they arrive in the mailbox.
This broadcast message was sent to all bidders on Friday Sep 10, 2010 3:10:08 PM:
The text file attachments have a unique name. The parser should ignore filenames that have already been parsed and the email should be left alone in the inbox (not deleted).
The ";" character is not used in any of the fields.
This broadcast message was sent to all bidders on Friday Sep 10, 2010 4:43:15 PM:
These log files are sent to a dedicated email address, and reside in a full mailbox on Exchange (no alias box). I don't want any code requiring Outlook (or Express) or to be running on a separate machine. If at all possible. SQL Server 2008 R2 Express is already installed on the server. No test server will be supplied for this project. No coder access to our production server will be granted.
-
Worker: On pay-for-deliverable
projects, all deliverables must be
uploaded to
vWorker.com before the
deadline(s)…with no exceptions. If
this contract makes it impossible
to do this (for example if it is
for a service that cannot be
uploaded), then do not start
this project. Otherwise, you
may find
yourself unprotected by the
payment guarantee.
Instead, ask the employer
to switch this project to
pay-for-time, so you are
guaranteed payment. If the
employer will not switch this, then
please alert us.
(Click here for more details...)
Example of unprotected/un-guaranteed work:
Imagine that this project is to
install something on the employers
website.
You do the work but upload nothing
to vWorker.com (because it takes too
long,
or you cannot). As long as there is
no dispute, you will not notice the
potential problem. But if the
employer disputes what you did then
we must make sure you delivered to the
triple-point-guarantee (100% to-contract: and
done in the industry exepcted manner, and
by the deadline). If the employer
does not allow us access to their
website, or accidentally/deliberately
changes the work you did on their
website, when we go to test it, we
will see that it does not work.
Then you would have no proof that
you delivered the final deliverables,
lose the arbitration, the escrowed
funds and receive a poor rating
(which will say "testing showed
the final deliverables did not
work").
So for this reason,
you should have instead followed
the above instructions and
switched it to pay-for-time.
Had you done this, we would simply
have checked the Accutimcard to
make sure you punched-in the time
and were working on it. You would
have been paid for every hour
you worked.
- Remember that contacting the other party outside of the site (by email, phone, etc.) on all outsourcing pay-for-deliverables projects < $500 (before the employer's money is escrowed) is a violation of both the employer and worker agreements.
vWorker.com monitors all site activity for such violations and can instantly expel transgressors on the spot, so we thank you in advance for your cooperation.
If you notice a violation please help out the site and report it. Thanks for your help.
Categories:
-
The categories were created by the employer, but sometimes mistakes occur.
If any of these categories are incorrect, please
report it and let us know.
-
Like everything else on this page, these categories are part of the original contract
for this project.
Microsoft Windows, Database, Languages, Operating systems / platforms, Other (software language), C#, Visual Basic .Net, SQL Server, Technology, Software Development, Scripts and utilities, Tech details
Additional Files:
|
|
Post first message
|
|
- Workers:
-
If you already have an account: Click here to
login. You'll be brought back to this page where you
can respond and/or view your previous responses and/or bids on this
project (if any).
-
If you don't have an account: Click here to
create one. You'll be brought back to this page
so you can then respond.
- Employers:
- Click here to log in. You will then be brought to the bidding
section tab, where you can
see all your bids/comments, accept one, etc.
|
|
| |
|
Where did the rest of this page go?
We listened to your feedback and split up the long
project page list into
separate tabs (to group things better, make it faster loading and reduce clutter).
Click here to
see the new tabs, or click here to
get to the new location of the
shortcut / control panel.
|
|
Post new project
Find workers...
Search workers
Browse by category
Move menu
Tools
Articles
FAQ
News
Help
Newest
Contests / Trials 
What is this list?