Re: search email list to extract data in spreadsheet
> > Why can't you just contact the college for the information? > > The main reason why I need to extract the information onto a spreadsheet is > to save time (instead of doing it manually) - we > work with several universities in the UK and store their information in our > database - to promote our product/services. Have you tried contacting those universities for the information? They could provide it in a more easily consumable format. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: search email list to extract data in spreadsheet
J.J, Thanks for your replay. The main reason why I need to extract the information onto a spreadsheet is to save time (instead of doing it manually) - we work with several universities in the UK and store their information in our database - to promote our product/services. You mentioned that although difficult (email address "javascript protected") it is possible. Is there a way that I could obtain sample code of how to do this? Tom >Tom, > >You would use CFHTTP to get the HTML and then parse the data from there. > >I will say that the website you sent is trying its best for you not to >do what you are doing. If you look in the HTML it clearly has the >email address "javascript protected" which doesn't mean you can't do >it, it just means it is going to be a little more difficult. > >Why can't you just contact the college for the information? If they >aren't going to give it to you then maybe you don't need it :-) > > >-J.J. > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353966 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: search email list to extract data in spreadsheet
Tom, You would use CFHTTP to get the HTML and then parse the data from there. I will say that the website you sent is trying its best for you not to do what you are doing. If you look in the HTML it clearly has the email address "javascript protected" which doesn't mean you can't do it, it just means it is going to be a little more difficult. Why can't you just contact the college for the information? If they aren't going to give it to you then maybe you don't need it :-) -J.J. On Fri, Jan 18, 2013 at 2:29 AM, Tom Small wrote: > > Hi Attila, > > Thanks for your email and I should of been much clearer in my previous email. > Hi John, > > Another questions - what if I wanted to extract information from a list of > emails found on web (http://rg.kcl.ac.uk/staffprofiles/?by=A) and run some > code that can extract details from each email link and store each details in > a excel spreadsheet. > > I know how to add a list of emails from a spreadsheet and send then to > clients although not sure how to extract it from a website? > > Hope that this make sense and if you need more information please let me know. > > Thanks again for you help & advise. > > Tom > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: search email list to extract data in spreadsheet
Sorry about the first part of my previous email... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353964 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: search email list to extract data in spreadsheet
Hi Attila, Thanks for your email and I should of been much clearer in my previous email. Hi John, Another questions - what if I wanted to extract information from a list of emails found on web (http://rg.kcl.ac.uk/staffprofiles/?by=A) and run some code that can extract details from each email link and store each details in a excel spreadsheet. I know how to add a list of emails from a spreadsheet and send then to clients although not sure how to extract it from a website? Hope that this make sense and if you need more information please let me know. Thanks again for you help & advise. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353963 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: search email list to extract data in spreadsheet
Hi John, Thanks for the link. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353961 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: search email list to extract data in spreadsheet
Assuming you can get to the list via POP, this should do what you need: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f96.html On Thu, Jan 17, 2013 at 2:19 PM, Tom Small wrote: > > Hi, > > Can someone advise me on the following.. > > I want to know the best way to search through a list of emails and extract > the information (e.g. first, address, position, address, etc) into an excel > spreadsheet. > > Appreciate any advice on this issue. > > Tom > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
search email list to extract data in spreadsheet
Hi, Can someone advise me on the following.. I want to know the best way to search through a list of emails and extract the information (e.g. first, address, position, address, etc) into an excel spreadsheet. Appreciate any advice on this issue. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm