Asp.net website with local keystroke macro

キャンセルされた 投稿 Feb 8, 2010 着払い
キャンセルされた 着払い

Create a new Asp.Net 3.5 website using VB and using a MSSQL db for the data. And create an XP scheduled event keystroke macro as a way to generate and upload csv files to the website . The purpose of the site is to make available on the web, information that basically mirrors our local unix server. You will be responsible for developing a:

·? ? ? ? ? ? ? ? New base website with a login system and MS SQL2008 database.

·? ? ? ? ? ? ? ? XP based keystroke macro or ??? to run on set schedule multiple times per day.

·? ? ? ? ? ? ? ? Automated file upload from local PC to remote website.

·? ? ? ? ? ? ? ? Code to import CSV file into the ? SQLdb.

## Deliverables

Create a new Asp.Net 3.5 website using VB and using a MSSQL db for the data. And create an XP scheduled event keystroke macro as a way to generate and upload csv files to the website . The purpose of the site is to make available on the web, information that basically mirrors our local unix server. You will be responsible for developing a:

·? ? ? ? ? ? ? ? New base website with a login system and MS SQL2008 database.

·? ? ? ? ? ? ? ? XP based keystroke macro or ??? to run on set schedule multiple times per day.

·? ? ? ? ? ? ? ? Automated file upload from local PC to remote website.

·? ? ? ? ? ? ? ? Code to import CSV file into the ? SQLdb.

Login System Requirements:

·? ? ? ? ? ? ? ? If using the built in .Net login controls, I would like it modified to use an email address in place of the username.

·? ? ? ? ? ? ? ? No self-registration, all users are added/edited/deleted by the Admin via a web interface that you would build.

·? ? ? ? ? ? ? ? Password recovery via users email address enabled (password do not need to be encrypted)

·? ? ? ? ? ? ? ? Each user will have these additional profile options that are set by the admin so I can route the users appropriately when they log in.

o? ? Location: optional

§? CC

§? GJ? ? ? ? ? ? ? ? ? ?

§? CS

o? ? Territory: optional

§? CC1? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

§? CC2

§? CC3

§? GJ1

§? CS1

o? ? Status: optional

§? New

§? Rental

§? Shop

§? User

o? ? Level: Required

§? Admin? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?

§? Sales

§? Rentals

§? Service

§? Office

§? Accounting

·? ? ? ? ? ? ? ? Here’s the tricky part…. Users that log in from one of 3 IP addresses (our 3 stores) AND Level ? <> “Sales??, I want them to have a login that does not expire for 9 hours. The others can expire in 20 min as usual.

Keystroke Macro:

We have our business system running on a Unix server and we (still) use “green screen?? terminal emulators to access the system. The system has a report writer module that outputs saved reports as .csv files. I need a way to:

Create an executable file that can be run from a PC running Windows XP, at regular scheduled intervals between the hours of 8:00AM and 5:00PM, Monday thru Friday. ? I need to run a script or macro that :

·? ? ? ? ? ? ? ? Opens an installed terminal emulation program. ("C:\Program Files \J River\[url removed, login to view]")

·? ? ? ? ? ? ? ? Enters a username and password thereby logging into our Unix based business system.

·? ? ? ? ? ? ? ? Perform a series of keystrokes to run several preconfigured reports and have the results saved in its default .csv file in the default folder location (folder is publicly available as shared? folder on our UNIX server)

·? ? ? ? ? ? ? ? Log off the emulator.

Keystroke sequence would look something like this (after the emulator is open and has the focus):? ? ? ? ? ? ?

1.? ? ? ? ? ? Username (has focus when emulator starts) [ENTER]

2.? ? ? ? ? ? Password [ENTER]

3.? ? ? ? ? ? 13 [ENTER]

4.? ? ? ? ? ? 2 [ENTER]

5.? ? ? ? ? ? ### (3 digit report number) [ENTER]

6.? ? ? ? ? ? F [ENTER]

7.? ? ? ? ? ? Filename [ENTER]

8.? ? ? ? ? ? P [ENTER]

9.? ? ? ? ? ? [ENTER]

10.? ? [ENTER]

11.? ? [ENTER]

12.? ? [ENTER]

13.? ? {10 second delay to allow report to generate}

?

Repeat from step #4 for additional reports. (approx. 5 total)

?

14.? ? [F7] to close emulator

?

?

File Upload:

·? ? ? ? ? ? ? ? Now I need to upload the csv files just generated from a public folder on our local UNIX server to a folder on the remote web server. I don’t know whether to use ftp or aspUpload or???. (I’m thinking ASPUpload might be the best choice so after the upload is complete, it could trigger the next step)

·? ? ? ? ? ? ? ? Then using VB code in a page or stored procedure or whatever, we need to import the data in the csv file into its corresponding table in a sql database. I have no idea how to trigger the import code to run every time a file is uploaded….looking for ideas here.

After the csv file is initially uploaded and imported into the database table for the first time, subsequent uploads will simply be to keep the db properly updated. I would think it faster to overwrite the tables every time instead of iterating and checking for new or changed records. The largest of the csv files has over? 8000 records.

?

I am including one csv file to use as an example, I can adjust your code to handle any additional reports. (this is one attached)

?

What I want back is a website I can open in VS2008 with a MSSql Db included so I can run and test on my local machine. If there is a keystroke macro program you intend to use and there is a purchase price for that, let me know in your bid.

?

?

?

* * *This broadcast message was sent to all bidders on Wednesday Feb 17, 2010 6:42:24 PM:

Thank you all for bidding.... I have decided to cancel this bid request and resubmit the project in separate sections. I think I tried to get too much done with one bid request based on the bids I got. If you are interested in re bidding, I will be reposting in a day or two Thanks,

ASP PHP

プロジェクトID: #3162101

プロジェクトについて

4個の提案 リモートプロジェクト アクティブ Feb 17, 2010

4人のフリーランサーが、平均$1568 で、この仕事に入札しています。

Kartoos

See private message.

$170 USD 7日以内
(111件のレビュー)
6.6
dotnetguru14

See private message.

$255 USD 7日以内
(43件のレビュー)
5.6
thecloudkernel

See private message.

$5100 USD 7日以内
(9件のレビュー)
5.4
Eoyonix

See private message.

$748 USD 7日以内
(3件のレビュー)
3.7