Go Back   Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub
GL4x4 Live! GL4x4 Casino

The Pub A friendly forum where everybody is nice, and will answer any questions you have about life.







Search
Reply
 
Thread Tools
Old January 15th, 2008, 09:38 PM   #1
TechJeeper
Formerly "Gr8archer"
 
TechJeeper's Avatar
 
Join Date: 11-05-05
Location: Lansing, MI
Posts: 2,737
iTrader: (22)
Mentioned: 0 Post(s)
Send a message via AIM to TechJeeper
Default Mailing List Kiosk - Long Shot Help

Okay, so my work is looking to build a kiosk station where customers can sign up for our mailing list. This station will not have internet. I am stumped on this, is there a way to build a html form and have it save the submitted results in an excel file? I know its a long shot on a 4x4 forum, but there is alot of talent out there.

Thanks,
Cody
TechJeeper is offline   Reply With Quote
Old January 15th, 2008, 09:49 PM   #2
mtnbikinbryno
Senior Member
 
mtnbikinbryno's Avatar
 
Join Date: 11-08-05
Location: TC
Posts: 5,182
iTrader: (3)
Mentioned: 0 Post(s)
Send a message via AIM to mtnbikinbryno
Default

How 'bout a simple little VB program?
mtnbikinbryno is offline   Reply With Quote
Old January 15th, 2008, 10:07 PM   #3
schweeb
spelling nazi
 
schweeb's Avatar
 
Join Date: 07-02-07
Location: Grosse Pointe Woods, MI
Posts: 2,557
iTrader: (3)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by Gr8archer View Post
Okay, so my work is looking to build a kiosk station where customers can sign up for our mailing list. This station will not have internet. I am stumped on this, is there a way to build a html form and have it save the submitted results in an excel file? I know its a long shot on a 4x4 forum, but there is alot of talent out there.

Thanks,
Cody
This would be really easy to do with MySQL and PHP or something. I would recommend MySQL rather than a flat file. You can't "just" use an HTML file, that HTML file needs a script of some sort to post results to for processing.
schweeb is offline   Reply With Quote
Old January 16th, 2008, 07:22 AM   #4
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,944
iTrader: (2)
Mentioned: 0 Post(s)
Default

if it's completely stand alone why not just use one of the built in templates that comes with Access?
RyeBread is offline   Reply With Quote
Old January 16th, 2008, 09:04 AM   #5
TechJeeper
Formerly "Gr8archer"
 
TechJeeper's Avatar
 
Join Date: 11-05-05
Location: Lansing, MI
Posts: 2,737
iTrader: (22)
Mentioned: 0 Post(s)
Send a message via AIM to TechJeeper
Default

i havnt messed with access much, with the templete are you able to mask the data. I am not sure if people would want to sign up if the last person who signed up's address and phone number are visable and open to anyone.

thanks for the ideas im still tryin to figure this out.
TechJeeper is offline   Reply With Quote
Old January 16th, 2008, 09:19 AM   #6
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,944
iTrader: (2)
Mentioned: 0 Post(s)
Default

Quote:
Originally Posted by Gr8archer View Post
i havnt messed with access much, with the templete are you able to mask the data. I am not sure if people would want to sign up if the last person who signed up's address and phone number are visable and open to anyone.

thanks for the ideas im still tryin to figure this out.
out of the box, the standard template would indeed allow someone to simply click through the record arrows to see whom had registered.

with some editing of the standard template it could easily be locked down to a "submit only" type of data entry form.

another option is as you originally indicated - a stand alone html template that gathered the information and the onsubmit action would be to post inside of some back end file.

be it mysql, excel, access, or even a delimited text file that you later imported into CRM software (or a simple mail merge)

http://www.google.com/search?q=sign+...template&hl=en brings up a number of free templates, but I didn't spend any significant amount of time looking at any. My existing large sql query is close to wrapping up so back to work for me, until the next one ties up my machine.
RyeBread is offline   Reply With Quote
Old January 16th, 2008, 09:28 AM   #7
TechJeeper
Formerly "Gr8archer"
 
TechJeeper's Avatar
 
Join Date: 11-05-05
Location: Lansing, MI
Posts: 2,737
iTrader: (22)
Mentioned: 0 Post(s)
Send a message via AIM to TechJeeper
Default

Having the form submit to a text file would work. I have been trying to do that and cant seem to get it to work. I do <FORM action="output.txt" method="post"> and when the submit button is clicked, it simply brings up the text file.... its driving me nuts!!!!
TechJeeper is offline   Reply With Quote
Old January 16th, 2008, 09:38 AM   #8
RyeBread
Catch the wave
 
RyeBread's Avatar
 
Join Date: 11-08-05
Location: Fenton
Posts: 7,944
iTrader: (2)
Mentioned: 0 Post(s)
Default

blah. I guess I may have just been thinking about this with respect to the form being hosted on a webserver with something like coldfusion, php, mysql, asp, cgi, etc. hosted as well.

according to some very quick reading, by itself, a straight up html form and/or javascript can't write natively to a text file. Guess I'm a bit more tired than I thought.

for reference:

http://www.thescripts.com/forum/thread147272.html

http://www.htmlcodetutorial.com/help...start=0&t=2100
RyeBread is offline   Reply With Quote
Reply
Great Lakes 4x4. The largest offroad forum in the Midwest > General 4x4 Stuff > The Pub
Thread Tools

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -5. The time now is 02:46 PM.


Powered by: vBulletin, Copyright 2000 - 2012, Jelsoft Enterprises Ltd.
User Alert System provided by Advanced User Tagging (Lite) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd. Runs best on HiVelocity Hosting.
Copyright 2005 - 2012 Cracker Enterprises - Powered by Linux
vB Ad Management by =RedTyger=
Page generated in 0.10637 seconds with 26 queries