Web Hosting Forum | Lunarpages
News: November 3, 2008 - Enter Your URL in to WIN the November Site of the Month Award!
 
Home Help Search Calendar Login Register
*
Welcome, Guest. Please login or register.
Did you miss your activation email? 		November 21, 2008, 07:57:11 AM


Login with username, password and session length


Web Hosting Forum | Lunarpages > Lunarpages Web Hosting - Online Help Desk > Lunarpages - DreamWeaver > Downloading data fields to Excel
Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: Downloading data fields to Excel  (Read 332 times)
nelson linnabary
Newbie
*
Offline Offline

Posts: 4


WWW
« on: September 01, 2006, 02:42:51 PM »
Hello,
In DWMX2004 I have created a form to be filled out by users. I would like to retrieve the data to my hard drive. Is there a ready made cgi script or program I can use to directly fill columns in excel?
I could also create the form in a PDF if that is any easier. Adobe PDF can directly gather data into Excel from an email but not from a web server.
Thank you
Logged
Rowan
hamburglar
Über Jedi
*****
Offline Offline

Posts: 1918


I used to be Human....2.0b


WWW
« Reply #1 on: September 01, 2006, 03:59:19 PM »
I would look at exporting the form to a csv file and import that into excel.
From:
http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXCSVImport-Export/Product-Forum/Details/100596/Create+CSV+from+Form+Submit%3F.html
Quote
You can attach a custom AFTER trigger to the insert transaction. In this trigger you can open a file using the fopen PHP function and write the data in the CSV format to it using fwrite.


There is a cheap script (18$) which might do what you want:
Quote
Export to Excel" Server Behavior for Dreamweaver MX -Dreamweaver 8
http://www.linecraft.com/e2e/help.php

Hope that helps get you in the right direction.
Logged
Lunarpages Web Hosting

Lunarpages Forums

Lunarpapages Affiliate Program

Lunarpages Web Hosting Blog




----


http://row1.info -- http://sardless.com
nelson linnabary
Newbie
*
Offline Offline

Posts: 4


WWW
« Reply #2 on: September 01, 2006, 05:05:10 PM »
Rowan,
Thank you, the 18 dollar solution is what I was looking for.
There are many web sites doing this very thing so I thought there would be a program to handle the date - I just couldn't find it.
Nelson
Logged
Rowan
hamburglar
Über Jedi
*****
Offline Offline

Posts: 1918


I used to be Human....2.0b


WWW
« Reply #3 on: September 01, 2006, 05:06:58 PM »
You will probably want the PHP & MySQL solution they offer.
Logged
Lunarpages Web Hosting

Lunarpages Forums

Lunarpapages Affiliate Program

Lunarpages Web Hosting Blog




----


http://row1.info -- http://sardless.com
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM