CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • customized reports and importing from another html email editor
Pages: [1]

Author Topic: customized reports and importing from another html email editor  (Read 2134 times)

anto

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
customized reports and importing from another html email editor
January 20, 2010, 12:05:39 pm
Hello,

We use joomla as a website manager/editor.  I am just getting a handle on how to update the website and I have a lot to learn.  Our organization in general is still in the ice age in terms of data/contact management and keeping track of donations.  For contact management, we are currently using Microsoft Access, which obviously cannot be automatically updated when we send out an email to our listserve or when someone makes a donation through paypal on our website.  In addition, our board of directors receives many of the (check) donations, and they are located in a different country than we are.  What currently happens is when they receive checks, they compile a list (in a chart in a word document) of deposits into the account, send out thank you letters manually, and send us the list so we update the (poorly configurated) Access database.  I think it would be very useful to have an online contact and donor management database, so it could be accessed remotely by the board of directors, staff, etc.  I have a couple of questions, though:

1. Recently, I wanted to create a report from our Access database to do end of the year fundraising phone calls.  I wanted the report to be of all of our contacts in a certain state, for whom we had phone numbers for, and include in the report the name, address, phone number, email address (so this info could be verified during the calls), as well as a history of contributions that each of these people had made and the program they were interested in/involved in.  Is there a way in CiviCRM Reports to customize reports so I could create a separate report by state for those contacts we had phone numbers for and include in the report their donation/pledge history?

2.  One of our most recent advancements in technology is that we have begun to send out html emails through an email marketing manager, VerticalResponse.  The email canvas that VerticalResponse has seems to be quite superior to the one that CiviCRM has to send out emails, invitations, newsletters, etc, so I would like to continue using it if we began to use CiviCRM.  Is there any way to import the fact that we sent out an email (often with a paypal donation button) through verticalresponse, but track donations from it in CiviCRM?  Does this make sense? I am just beginning my journey to webdesign literacy and don´t know all of the lingo...

3. My most important question is whether someone with no programming and VERY minimal coding and website managing experience could handle uploading and managing CiviCRM along with our joomla website.  Is this even a possibility for an organization caught in the 90s?  Or would it be necessary to hire a webmaster, etc, to manage this?

Thank you in advance for the insight.

anto

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
Re: customized reports and importing from another html email editor
January 26, 2010, 07:15:59 am
Is there noone that can provide a little advice?

Please? ???

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: customized reports and importing from another html email editor
January 26, 2010, 07:42:21 am

for your below needs (i.e. migration and integration with VR), you will need someone familiar with CiviCRM / websites and programming experience to help you get it all setup and migrated over

once things are setup, someone with limited experience can run the site on a day-to-day basis

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

conductorchris

  • I post frequently
  • ***
  • Posts: 167
  • Karma: 9
    • Vermont Rail Action Network
  • CiviCRM version: 4.5.0
  • CMS version: Joomla 3.2.7
  • MySQL version: 5.5.32
  • PHP version: 5.3.26
Re: customized reports and importing from another html email editor
January 26, 2010, 08:32:03 am
Regarding your question on reports:

You can set up a group based on a search for state, contributions and phone number (you use % as a wildcard and it would return all phone numbers).  You can then make a report based on that group or perhaps even better, you can export those names (comma separated so you can read it with a spreadsheet) so you can slice and dice it in a spreadsheet as well (civiCRM is great, but sometimes using a spreadsheet is faster for a very specific one-time job).

I am someone who had no programming and VERY minimal coding and website managing experience when I started with civiCRM.  I learned what I needed.  I am also someone who is comfortable with computers.  If you have the aptitude to learn access, you have the aptitude to learn civiCRM.  But of course not everybody does.  It has taken a lot of time, more than I thought, and some struggle.  But given my options as a 1 person shop in a non-profit we are raising from the ground with small resources, it's allowed me to do things that would simply not be possible any other way.  I am very, very grateful for civiCRM and those who have developed it.

How much of a struggle you might have depends partly on how good your host is.  I used a cheap hosting service and it really made things hard (there weren't enough server resources to properly install civicrm in joomla and I had to figure out a back-door kind of way.  A bunch of things didn't work completely as designed.)  I would recommend making sure you have a good host.  And here I will put in a plug for my new host, civihosting, which I am really pleased with.  The reason I went with them is they have sever configurations specifically designed for civicrm, yet are still affordable ($15 a month).  The guy who runs it will do instillations for you and considering what your time is worth, it might be better to just pay him and be done with it.  It's not expensive.
Thanks to those who help create and enhance civiCRM!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Pre-installation Questions (Moderator: Dave Greenberg) »
  • customized reports and importing from another html email editor

This forum was archived on 2017-11-26.