This topic is locked
[SOLVED]

 How to extract one field/column ?

3/14/2010 4:54:12 AM
PHPRunner General questions
E
employee author

Hello all,
I have a table in my database in which there is 'email_id' filed, Im wondering if there is a way from within PHPRunner(5.1) to export ONLY that filed/column to any '.cvs' file or text file ?. In case it is not possible with PHPRunner, what about MySQL database itself, is there a command to export only one column values from MySQL database table ?!
Thank you.

E
employee author 3/15/2010

Any idea?!
Thanks.

N
nix386 3/15/2010

I'm not sure I follow you correctly but why not just use the PHPRunner export xls function then delete the other columns leaving only the emails?

What exactly is your need as far as the xls or csv file goes?



Any idea?!
Thanks.

R
rgfischerjr 3/15/2010



I'm not sure I follow you correctly but why not just use the PHPRunner export xls function then delete the other columns leaving only the emails?

What exactly is your need as far as the xls or csv file goes?


I believe that when you select the fields for each page that if you only select the email_id for the export page that then you will only export that field.

E
employee author 3/19/2010

Hello,
scubadiver:
Unfortunately, on export page there is no option to select specific fields to only extract, there is only two options: 1- Data Range:All records , 2- Data Range: Current page only.
Thanks for your kind participation.
nix386:
Believe I didn't thought about your suggestion at all in spite of i felt it is good simple one just after I read it, maybe we will see a direct export command for specific fields in the coming version, tell then, I will adopt your nice idea, it is most enough for me right now, many thanks nix386.
Regards,

J
Jane 3/19/2010

Hi,
you can select what fields you want to export on the Choose fields tab in PHPRunner.

E
employee author 3/23/2010

Hello Jane,
Thanks a lot, I just found it, you are right, I was looking in the wrong place. In the 'Choose fields to appear in each page' we can check/uncheck the wanted fields for each page, I unchecked all the fields and kept 'email' field checked for the export page, so the exported file have nothing but the email column.
Thanks again for you, and for all the participants.
Regards,