Author Topic: Exporting Tracked Hits Information (Read 3958 times)

jac · « **on:** April 12, 2007, 10:43:02 am »

Is there any way of exporting the Tracked Hits information?

I would like to be able to export a CSV file or the like, for importing into Excel so I can clear down the logs regularly and sort/present the information easily.

This is probably possible via PHP MyAdmin but could someone take my hand and lead me through the process as I am not too technically minded when it come to databases.

Many thanks
---
John

DW · « **Reply #1 on:** April 12, 2007, 04:21:28 pm »

John,

Check out this post:
http://listmailpro.com/forum/index.php?topic=496.0

You'll be happy to know extensive detailed reports including impressions, click-thru rate, etc. are coming for ListMail in the next update. Patience.

Regards

jac · « **Reply #2 on:** April 12, 2007, 05:40:42 pm »

Thanks for that Dean. That's good but not quite what I need.

In a similar way to the code you have already supplied, I would like to be able to select a particular link from a drop dowm menu and export a CSV file of all of that link's tracked hits information that is usually presented:

Date
   Time
   Link
   Name
   Email
   List

I can then import this information to Excel to be manplulated/presented in various ways.

Any thoughts

Thanks
---
John

DW · « **Reply #3 on:** April 13, 2007, 03:32:22 am »

How about this one:
http://listmailpro.com/forum/index.php?topic=29.0

I would rather avoid an additional custom script considering I'm working so hard on the next update at the moment and there are huge improvements being made in this area.

Regards

jac · « **Reply #4 on:** April 13, 2007, 04:39:12 am »

Ok

I have tried to get this script working to see if it will do the job but it just gives me:

Cannot Access Hit Statistics

its set up in www.barntheatre.co.uk/listmail/hits_wq.php

hits_wq.php is set up as follows:

Code: [Select]

/* ======  STUFF TO EDIT MANUALLY  =============  */
$configfile = "./config.php";
$adminfile = "./admin.php";


/* ======  THE MEAT  ======== */
if ( $p == "btc" ) {
  // continue
} else {
  echo "<html><head></head><body>Cannot Access Hit Statistics</body></html>";
  exit;
}

etc etc no change below this...

If I goto:

http://barntheatre.co.uk/listmail/hits_wq.php?p=btc

I just get the error. ListMail is working fine so I don't think its a database issue.

If you have time have you any ideas?

I would alse be interested know how much a custom script would cost me.

Many thanks for your help Dean
---
John

DW · « **Reply #5 on:** April 13, 2007, 08:24:49 pm »

Hi John,

I have a hunch that this could be caused by the "p" variable not being passed properly from the address bar to the script.

After this line:

Code: [Select]

$adminfile = "./admin.php";
add

Code: [Select]

echo "P=$p<br>";
Browse to the script at ?p=btc and if it says "P=" with no value, there is an issue with "Register Globals" not being enabled.
You would have to add this at the top to set the variable:

Code: [Select]

$p = $_GET['p'];
or ALL this, to automatically cast all vars to "globals"....

Code: [Select]

if(isset($_GET)){
 while(list($key,$val)=each($_GET)){
  if(!is_array($val)){
   if($gpc) $val = stripslashes($val);
   @eval("\$$key = \$val;");
  } else {
   eval("\$$key = array();");
   foreach ($val as $key2=>$val2){
    if($gpc) $val2 = stripslashes($val2);
    @eval("array_push(\$$key,\$val2);");
   }
  }
 }
}

I unfortunately cannot do an involved custom script at this time - I need to get the next update finished! Of course, if it can be simplified I might be able to help....

What are you looking for, exactly?

Regards

jac · « **Reply #6 on:** April 14, 2007, 02:40:27 am »

Thanks for that Dean I'll try it. However as I have no got it working et I don't even know if it will do what I need! :?

I literally just need a script to output a CSV file of JUST the information presented when you go to Tracked Hits.

Date
Time
Link
Name
Email
List

I can then sort/present it from there.

Thanks Dean
---
John

DW · « **Reply #7 on:** April 14, 2007, 05:25:26 pm »

John,

Are you familiar with PhpMyAdmin?

Try the following custom SQL query:

Code: [Select]

select h.date,k.refcode,k.title,u.fname,u.lname,u.email,u.list from lm_hits h left join lm_links k on h.kid = k.id left join lm_users u on h.uid = u.id

You should be able to export to CSV from there.

Regards

jac · « **Reply #8 on:** April 14, 2007, 05:50:52 pm »

Dean

Thank you. I wish I knew what that query said and how to do it but I had a little look at PHpMyAdmin, put the query in where I thought it goes and tried it out...yes it worked perfectly.

Many thanks and kind regards
---
John