I need a newsgroup download utility which saves messages in a SQL Sever Database. I require a table to pass in the newsgroup name ([login to view URL]) and newsgroup name ([login to view URL]). This table should also track the last update, the last messageid downloaded and if the newsgroup is active (to be downloaded - 0 or 1). This table should also have a flag to download attachments or not. Also, it should have a threshold of how large attachments should be downloaded, if attachments are allowed ie 1meg, 1000megs. The utility will be scheduled to download the contents of the newsgroups to a relational table using this information. The downloaded contents will be stored in a separate table. All contents available will be stored in separate columns. Example: subject, dateposted (datetime field), from (broken out to username, email address), messageid, replyto (broken out to replytousername), replyto email address, header, references and message. If the message contains attachments they should be stored in a separate table relationally. You will run into roadblocks of inconsistent dateposted, from and replyto fields which vary based on what client posted the message. It is important that the winning bidder provide a best solution for this problem. Redundancy is OK if you wish to store the original dateposted field then the formatted datetime dateposted field, for example. We will supply the exact database structure to the winning bidder. We have a java utility which offers MOST of the funcationality described (except for attachment table, filesize threshold, datetime and from parsing to separate fields). If necessary we will provide this utility to be modified. This option is to be treated as a last resort and if used the bidding price should be lowered accordingly. Preferred language is C# .NET 2.0.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows Server 2003