SitePoint Sponsor

User Tag List

Results 1 to 10 of 10
  1. #1
    SitePoint Enthusiast
    Join Date
    May 2013
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    HTML Form - To CSV - Wordpress Sign Up - Various

    Hi

    Not sure which forum to put this is as it cover every section!

    I am running a competition on my website which will collect me email address's for a mailing list.

    I want a form which will do this for me. I am ok with a simple HTML form but have a few questions to see if I can get it to do exactly what I want

    Preferably without using PHP (As I havent read about it yet) although I'm 90% sure this wont be possible (especialy my last point)

    Questions below:

    1. My mailing list will be in excel, can i export directly to this format (CSV or xlsm)?
    2. I will have a drop down list which will have around 720 values! This is far too many so I wondered if I could cut this down by another part of the form

    IE: If x is selected, then the drop down list = abcdef. If Y is selected then the drop down list = GHIJKL.

    3. Now this is the tricky part! My website is built in HTML but I use wordpress for my forum and blog. Can I make it so my form registers the 'form user' for my wordpress account?

    Any help would be greatly appreciated as I'm looking to go live at the beginning of Dec

  2. #2
    SitePoint Wizard
    Join Date
    Oct 2005
    Posts
    1,859
    Mentioned
    5 Post(s)
    Tagged
    2 Thread(s)
    Quote Originally Posted by kimbo_king View Post
    Hi

    Not sure which forum to put this is as it cover every section!

    I am running a competition on my website which will collect me email address's for a mailing list.

    I want a form which will do this for me. I am ok with a simple HTML form but have a few questions to see if I can get it to do exactly what I want

    Preferably without using PHP (As I havent read about it yet) although I'm 90% sure this wont be possible (especialy my last point)
    You are going to have to use some sort of scripting language to process the email submissions and, I assume, save them in a database. Unless you can find a Wordpress plugin to do it for you.

    Quote Originally Posted by kimbo_king View Post
    Questions below:

    1. My mailing list will be in excel, can i export directly to this format (CSV or xlsm)?
    Export from where? From a database? You can export from a database to CSV using phpMyAdmin.

    Quote Originally Posted by kimbo_king View Post
    2. I will have a drop down list which will have around 720 values! This is far too many so I wondered if I could cut this down by another part of the form

    IE: If x is selected, then the drop down list = abcdef. If Y is selected then the drop down list = GHIJKL.
    On the web page? You will have to use Javascript for that.

    Quote Originally Posted by kimbo_king View Post
    3. Now this is the tricky part! My website is built in HTML but I use wordpress for my forum and blog. Can I make it so my form registers the 'form user' for my wordpress account?
    Look for a Wordpress plugin to do that.

  3. #3
    SitePoint Enthusiast
    Join Date
    May 2013
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks CheeseDude!

    Quote Originally Posted by cheesedude View Post
    You are going to have to use some sort of scripting language to process the email submissions and, I assume, save them in a database. Unless you can find a Wordpress plugin to do it for you.

    Export from where? From a database? You can export from a database to CSV using phpMyAdmin.
    Suppose I meant, can I export to a CSV file, rather than a database. IE: Past straight into the CSV?



    Quote Originally Posted by cheesedude View Post
    On the web page? You will have to use Javascript for that.
    Though so, I'l have a dig into that then...

    Quote Originally Posted by cheesedude View Post
    Look for a Wordpress plugin to do that.
    Any reccomendations? I've searched through but its hard to put into words as a search term...

  4. #4
    #titanic {float:none} silver trophy
    molona's Avatar
    Join Date
    Feb 2005
    Location
    from Madrid to Heaven
    Posts
    8,269
    Mentioned
    251 Post(s)
    Tagged
    1 Thread(s)
    If you handle your mailing list with campaign monitor or mailchimp, then you already have a WordPress plugin for that.

    If you simply want to have the details because you're hadling your mailing list with another software or program (let's say, Outlook or Thunderbird, although these softwares are not really suited for this), use a normal from that will e-mail you the details you need

  5. #5
    SitePoint Enthusiast
    Join Date
    May 2013
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Suppose my boggest question is, how do I store the data from the form. My book states response'o'matic.

    Can I do this straight to an exce;/ csv file or a SQL database? What are my options

  6. #6
    SitePoint Enthusiast
    Join Date
    May 2013
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by molona View Post
    If you handle your mailing list with campaign monitor or mailchimp, then you already have a WordPress plugin for that.

    If you simply want to have the details because you're hadling your mailing list with another software or program (let's say, Outlook or Thunderbird, although these softwares are not really suited for this), use a normal from that will e-mail you the details you need
    Thanks, I missed this previously

    Just checking out mailchimp and it looks good. I dont love teh form though so may just make one to email me.

    I'd like to show the results but think I'm out of my depth

    It will be a competition where everyone who signs up will choose their club. I'd like to show which club s in the lead (Like a poll)

  7. #7
    #titanic {float:none} silver trophy
    molona's Avatar
    Join Date
    Feb 2005
    Location
    from Madrid to Heaven
    Posts
    8,269
    Mentioned
    251 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by kimbo_king View Post
    Thanks, I missed this previously

    Just checking out mailchimp and it looks good. I dont love teh form though so may just make one to email me.

    I'd like to show the results but think I'm out of my depth

    It will be a competition where everyone who signs up will choose their club. I'd like to show which club s in the lead (Like a poll)
    You can always change the looks of the form by chaging the CSS.

    Now, you're adding a new concept into the equation... that you wanted to collect the e-mail addresses... To show this results, you at least need to keep count and that means some programming whether you like it or not.

    Not sure that there's any plugin that can do what you want (capturing e-mails and showing the results of this competition) but i would suggest that you search again, in this case using the word "competition" as a main search because it is likely that if the plugin does exist, it will capture the e-mail addresses and add it to a database where you can export it as CSV

  8. #8
    SitePoint Enthusiast
    Join Date
    May 2013
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm more than happy with the programming. I'd like to avoid PHP if possible but would love a HTML/ Java one (although I'm new to Java)

    Unless I've missed the point there

    I can do my form easily in HTML/ Java, email will be fine. Showing the results is a whole new ball game

  9. #9
    #titanic {float:none} silver trophy
    molona's Avatar
    Join Date
    Feb 2005
    Location
    from Madrid to Heaven
    Posts
    8,269
    Mentioned
    251 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by kimbo_king View Post
    I'm more than happy with the programming. I'd like to avoid PHP if possible but would love a HTML/ Java one (although I'm new to Java)

    Unless I've missed the point there

    I can do my form easily in HTML/ Java, email will be fine. Showing the results is a whole new ball game
    You should be fine if you know Java and your server support it (most of them do so I don't think that you'll have problem there)

    You can code your page with HTML and program the functionality with Java, if that's what you know.

  10. #10
    SitePoint Enthusiast
    Join Date
    May 2013
    Posts
    83
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks I'll do that

    I'm incredibly new to java so a push on the right direction would be great but I'm happy to get my hands dirty!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •