[ic] Using IC for CRM tool? (Problems with Customer userdb display settings and a form)

[Julia Jacobs]

Hi there!
I'm using IC to build a website for a consultant.  He wants to upload
mailing list tab delimited databases into his website and then have
potential clients qualify themselves by filling out a form on his website
and adding themselves to his client database.  Also he wants a little e-mail
newsletter sign up form, where a client can add their name and e-mail
address and get added to the client database too.

These are the problems I'm running into:

I want him to be able to view his clients on the Customer page in the
Administration UI, but no matter what I do, I cannot get the Customer page
to display any more information about each customer than the ID, Name,
Company and Location.  I went into the userdb display settings and chose the
fields I wanted to show up, but they would not show.

Also I created a component for the e-mail newsletter sign up form.  The
problem is, it does not save the information to the userdb.  I can't figure
out why.  Here's the code:

<!-- BEGIN COMPONENT [control component emaillist] -->
[comment]
ui_component: emaillist
ui_component_type: vertical, content
ui_component_group: promotion
ui_component_label: E Mail List Sign-Up Box

[/comment]

<SCRIPT>    // JavaScript Form Validation Demo    // by Paul Colton
        // Make sure the email field is not blank
        ch = ch.toUpperCase();
    }
    </SCRIPT>

<FORM ACTION="[process secure=1]" METHOD="POST" name=emaillist>
    <INPUT TYPE=hidden NAME=mv_session_id VALUE="[data session id]">
    <INPUT TYPE=hidden NAME=mv_nextpage VALUE="thankyou2">
    <INPUT TYPE=hidden NAME=mv_doit VALUE=refresh>
    <INPUT TYPE=hidden NAME=mv_check    VALUE="Save_database">
    
    [if session logged_in]
      [set Save_database]
      [if cgi mv_todo ne submit]
      [calc] Log("Saving userdb in mv_check.")[/calc]
      [userdb save]
      [/if]
      [/set]
    [/if]

<table border="0" bgcolor="cornsilk" width="201" height="250">
  <tr> 
    <td><font face="Verdana, Arial, Helvetica, sans-serif" size="2"><b>Enter
your 
      name and email address to recieve more information:</b></font></td>
  
  <tr> 
    <td align=left class="contentbar1"> [error name=fname std_label="First
Name" 
      required=1]<br>
      <input type=text name=fname value="[value fname]" size="20"
maxlength="20">
    </td>
  </tr>
  <tr> 
    <td align="left" class="contentbar1">[error name=lname std_label="Last
Name" 
      required=1]<br>
      <input type=text name=lname value="[value lname]" size="20">
    </td>
  </tr>
  <tr> 
    <td align="left" class="contentbar1"> [error name=email std_label="Email
Address" 
      required=1] 
      <input type=text name=email value="[value email]" size="30">
    </td>
  </tr>
  <tr> 
    <td align="left" valign="middle" class="contentbar1"><b><font
face="Verdana, Arial, Helvetica, sans-serif" size="2">Mail
      lists</font></b><br>
      [perl tables="__UI_META_TABLE__ mv_metadata"] return; [/perl]
[input-filter 
      name=mail_list op=null_to_space][/input-filter] [display table=userdb
type=multiple 
      column=mail_list key="[data session username]"]
      <br>
             [button
        name="mv_click"
        src="buttonMail.gif"
        text="Mail"
        hidetext=1
        form=emaillist]
        mv_todo=submit
          [/button]
    </td>
  </tr>
</table>

<!-- END COMPONENT [control component emaillist_vertical] -->

Any ideas?  Also anyone know of a good Open Source POP3 Sendmail Webmail
program?  Also an e-mail newsletter management program with those same
specs?  I was going to check out this program I dug up on Sourceforge.net
called Relata:
http://www.relata.org/
Anyone heard of it or used it?

-- 
Julia Jacobs
Currant Media
407-977-4523
Fax 407-261-0176
http://www.currantmedia.com
Members of The Better Business Bureau
* Multimedia Producers
* Web Design & Development
* 2D/3D Graphics/Animation
* Hosting, domain and e-mail
* E-Commerce ­ check, credit card validation