Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsOtherProgramming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old June 18th, 2007, 10:35 AM
whatnow whatnow is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 18 whatnow User rank is Just a Lowly Private (1 - 20 Reputation Level) 
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.

Reply With Quote
Reply

Viewing: ASP Free ForumsOtherProgramming Help > ASP/JS/CSS/HTML to grab a chunk of data and send to CSV / TextFile / Clipboard??


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway
Stay green...Green IT