http://www.perlmonks.org?node_id=546183


in reply to Re: Extract data from website and transfer it to Outlook
in thread Extract data from website and transfer it to Outlook

Thanks Punkish, I'm actually working on multiple avenues towards that end result of getting all these contacts onto my Boss' Outlook rolodex. There is a .pdf file of this information as well and I'll be working on converting that to a text file and so forth. If I was fluent in Perl, it'd help me abbreviate the 4 or 5 tiered process I'd have to go through, because the script will ideally do this, and take it all into consideration. But the .pdf might pose its own set of problems. I'll see about this when I try to tackle it tomorrow.

I'm really trying all avenues at once and I thought this was a good time as any to take a deeper look at Perl.
  • Comment on Re^2: Extract data from website and transfer it to Outlook

Replies are listed 'Best First'.
Re^3: Extract data from website and transfer it to Outlook
by punkish (Priest) on Apr 28, 2006 at 14:24 UTC
    I'm really trying all avenues at once and I thought this was a good time as any to take a deeper look at Perl.
    Probably is a good reason to take a deeper look at Perl, whether or not it is a good time is your call depending on how much of a hurry you are in to do the current task.

    On another list I subscribe to, a common question is "What language is the best for scripting?" This is for a GIS (mapping) application that can be scripted using many different languages. My answer is, "The best language is the one you know best."

    There is a .pdf file of this information as well and I'll be working on converting that to a text file and so forth

    That is great, esp. if the PDF is actually text and not an image. You can export the text out to RTF, save that as plain text, open it up in Excel, and format it as CSV. All that would remain would be to determine the CSV format that Outlook expects, massage your Excel file accordingly, export it to CSV, and then import to Outlook.

    Once this task is behind you, you can start learning Perl, and then maybe even come back to this task to see how you could do it using Perl.

    --

    when small people start casting long shadows, it is time to go to bed