add address

About Support Directory add address

  • This topic is empty.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #2512
    Avatar for BradleyBradley
    Member

    is there any way to integrate the add address into a register type page to allow the user to input their info themselves or is there a register plugin that you are aware of that will put all the fields into the church directory. i’m struggling with how to make this happen because we don’t have the manpower to have to input this info manually ourselves but really want to use the mass mail option for a newsletter. any thoughts?

    #3173
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Thinking about integrating users in a later version, but for now – do you have your address list in a electronic form? It can then be converted and bulk added.

    If you are not a techie I could quote you – should take up to an hour for a spreadsheet. Please get in touch with the contact form…

    If you are techie enough, you are looking to get your data into a comma separated form and then create an sql statement to use in phpmyadmin on your webhost of the form

    Create your small groups first using the plugin and print them out using phpmyadmin so you know the smallgroup_id. Then the address statement needs to look a bit like…
    INSERT INTO `wp_church_admin_directory` (`address_line1`, `address_line2`, `city`, `state`, `zipcode`, `homephone`, `cellphone`, `first_name`, `last_name`, `children`, `email`, `email2`, `website`, `small_group`) VALUES(‘1 Street’,’Area’,’My City’,’My State’,’Postalcode’,’01234 567890′,’0789012345′,’John & Jane’,’Doe’,’a@b.com’,’b@c.com’,’www.web.com’,’1′) and then a comma before the next set of bracketed values… If you want a value to be blank use NULL.

    #3174
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Bulk Add Service Link

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.