
June 18th, 2007, 10:35 AM
|
|
Registered User
|
|
Join Date: Apr 2007
Posts: 18
Time spent in forums: 6 h 19 m 21 sec
Reputation Power: 0
|
|
|
ASP/JS/CSS/HTML to grab a chunk of data and send to CSV / TextFile / Clipboard??
Ok, sorry about the extended title, but here's what I'm trying to do.
I've built a form which captures a fair bit of data (about 100 variables, it then sends this data to a recipient email address. The data is presented in two ways upon receipt:
Tabular - Contains the info in a nice, readable format.
CSV - Pipe (|) Deliminated chunk of data, also has file csv headers too.
The CSV block is then copied and pasted into an blank csv file on a local server. this CSV file is checked and then uploaded via FTP to run as a EDI (Electronic Document Interface). Ignoring anything complicated, what I want to do is minimise on the amount of user input it takes from receiving the email to getting it in a format readable by our EDI.
The current steps are a little too involving, mouse clicks, navigation, finding files, opening, replacing data and such like.
What I thought about doing was creating a small VB application which would read the data in the clipboard (or allow past too) and then seperate this |deliminated info into variables, allow for a quick error check (and possibly user intervention on any of these variables) and then a quick button to finialise the process.
Would this be the best way? Could I run it entirly from script in the email if it has file access and access to run batch files or exe's? Perhaps just a batch file will do the job, copying, moving files, running the EDI etc...
I just want to make it idiot/bullet proof, but i'm not really sure of the best way - I'm a bit out of practice.
Any advice would be appreciated.
|