First names not going into user database

[vtm]

Lead Factory is sending first names and emails, but only the emails are appearing in the user database. If I subscribe by email or form, first names and emails appear fine.

Is there a setting to include the Lead Factory firstnames? They are gathering them, but names appear only if the subscriber enters first AND last names.

thanks
Laurie

[steve]

Laurie,
Are you pulling from an Excel CSV file? If so, use the import from CSV file and ListMail should ask you what column is what.
Steve

[DW]

Hi Laurie,

I am unclear about how the leads from Lead Factory are getting into ListMail.  Are you using a text file or Excel, as Steve suggested?

[vtm]

Hi Dean and Steve

Thanks for your responses - I've been trying to get real answers for you.

Hope this helps: (I've replaced identifying names with NAME ):

Hi Laurie,

We're sending each lead via email immediately after signup, to
the responder address you gave us. A signup email that our
system sends to yours looks like this:

<SAMPLE>
From NAME@amtelecom.net  Tue Nov 30 13:18:18 2004
Return-Path: <NAME@amtelecom.net>
Received: (from NAME@localhost)
        by phl13.note.com (8.11.6/8.11.6) id iAUIIGq08433;
        Tue, 30 Nov 2004 13:18:16 -0500
Date: Tue, 30 Nov 2004 13:18:16 -0500
Message-Id: <200411301818.iAUIIGq08433@phl13.note.com>
To: lfdec@online-home-based-business.info
From: "NAME" <NAME@amtelecom.net>
X-HTTP-User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProd
ucts)
X-Remote-Host:
X-Remote-Address: 216.129.36.134
X-LB-Subad: homebizdec01
X-LB-Comment: LF Subscription; complaints to abuse@LeadFactory.com
X-Mailer: robosub from LeadFactory.com (v. 1.02)
Subject: Subscriber from LeadFactory

IP Address: 216.129.36.XXX,  Host:  (LeadFactory)
</SAMPLE>

Take note of the From line:
From: "NAME" <NAME@amtelecom.net>

That has just the first name, and the email address.

Please keep me posted as to how we can make this work for you


 * C *

Czarina Caro L. Tablante  <service@LeadFactory.com>
   http://LeadFactory.com/leads/support.htm

[vtm]

That probably isn't as clear as it could be.

The example is of a problem email. The email address went into the database, but left the fname field blank, even though the subscriber supplied it. These are the problem ones.

If the subscriber supplies fname AND lname, the dbase receives fname, lname and email - all OK.

Hope that clarifies.

Laurie

[DW]

Okay, there may be a bug in signup-listX.cgi.

You'll have to manually open the CGI script and change the following:

Code: [Select]

   $spos = index($name,' ');
    if($spos>=0){
     $fn = substr($name,0,$spos);
     $ln = substr($name,$spos+1,length($name)-$spos-1);
    }
To the following, adding an "else" statement:

Code: [Select]

   $spos = index($name,' ');
    if($spos>=0){
     $fn = substr($name,0,$spos);
     $ln = substr($name,$spos+1,length($name)-$spos-1);
    } else {
     $fn = substr($name,0,length($name));
    }

Let me know if this helps!

[vtm]

Thanks Dean. I've edited the script OK, so will upload and get them to run some more names through.

[DW]

It should work, I just compared the original to the updated and experienced the error and working solution.

Let me know if it doesn't.  Sorry about that.

Regards!

[vtm]

That's assuming I did my bit right  :wink:

Apparently, also, a percentage of people find it impossible to click the unsubscribe link, and email LF to do it for them. They've been sending me those addresses and I've been going in and doing them manually.

Is there any link I could give LF that would unsubscribe such individuals automatically?

thanks Dean

Laurie

[vtm]

It worked!

Thanks Dean

Laurie