You have to login in order to post a reply to this topic.

3 replies [Last post]
afanofwinning
afanofwinning's picture
User offline. Last seen 42 weeks 1 day ago. Offline
Joined: 11/14/2009
Posts: 50

1. open a text document in  ms word document

2. insert/append an anchor text link in the first link - Click Here

3. save document as pdf.

Example,

Let's say you have the original documetn that says.

The cow jumped over the moon. Then it decided to go back so it took a Virgin flight back to Marbella (lol). The cow jumped over the moon. Then it decided to go back so it took a Virgin flight back to Marbella (lol). The cow jumped over the moon. Then it decided to go back so it took a Virgin flight back to Marbella (lol).

--------

The new document would say:

Click Here For More Info:

The cow jumped over the moon. Then it decided to go back so it took a Virgin flight back to Marbella (lol). The cow jumped over the moon. Then it decided to go back so it took a Virgin flight back to Marbella (lol). The cow jumped over the moon. Then it decided to go back so it took a Virgin flight back to Marbella (lol).

-------------
So step 1 is inserting a hypertext link, step two in converting it to pdf.

My thinking is that this can only be done in Word because you can't save anchor text links in notepad OR save it in pdf. In sum what needs to be automated is:

1. insertion/merging/concatenate of text

2. insertion of a hyperlink

3. save as pdf document

.....fyi as I am just thinking about this perhaps the job could be simplified by turning the document into an html before converting it to pdf...but I don't know.

 

Would REALLY, REALLY, REALLY appreciate some feedback. Tack!!!!

 

 

__________________

~~~~~~~~~~@~~~~~~~~@~~~~~~~~@~~~~~~~~~~~~~~~~~
Double Your Productivity & Profits - Get Exclusive, Tips, Tools, Tutorials & Reviews -when You Join AutomationNewsLetter.com

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

__________________

~~~~~~~~~~@~~~~~~~~@~~~~~~~~@~~~~~~~~~~~~~~~~~
Double Your Productivity & Profits - Get Exclusive, Tips, Tools, Tutorials & Reviews -when You Join AutomationNewsLetter.com

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

D.M.Altizer
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 01/12/2010
Posts: 204
Re: Inserting Links, Converting to PDF?

 Hello,

This sounds like an interesting problem. The first thing that you should notice, is that you cannot automate the specific task without using interactive actions (i.e. actions under "Mouse and Keyboard" and "Windows" categories). 

The WinAutomation steps that could be used are the following (this is just an opinion of course):

1) "Get Files in Folder": to grab all the text files that you want to convert to pdf
2) "For Each": to loop through all the text files
3) "Run Application": to launch MS Word
4) "Wait for Image": to make sure that MS Word is fully loaded
5) "Read Text from File": to read the contents of the current iteration's text file
6) "Send Keys": to write Click Here for More Info
7) "Send Keys": {Control}({Shift}({Home})) to select the Click Here for More Info text
8) "Send Keys": {Control}({K}) to open the "Insert Hyperlink" window
9) "Wait for Window": to wait for the Window with title *Insert Hyperlink* to open
10) "Send Keys": to send the URL where your link will point and then Enter
11) "Wait for Window": *Microsoft Word* to open and focus it
12) "Send Keys": to send an Enter keystroke and change the line
13) "Send Keys": to send the current text file's contents

How you will continue from here depends on the method that you are using to print your doc file into pdf. You can send a Control+P combination and then use keystrokes to select the Adobe Acrobat as the printer and save the file or you can use mouse clicks.
 

__________________

==Dedicated Automation Solutions==

__________________

==Dedicated Automation Solutions==

afanofwinning
afanofwinning's picture
User offline. Last seen 42 weeks 1 day ago. Offline
Joined: 11/14/2009
Posts: 50
Re: Inserting Links, Converting to PDF?

Hi. You can save a document as a pdf in MS Word Using in MSWord 2007 and MSWord 2010 (currently in beta).

You would have to choose it from the drop down menu. I tend to get snagged with these drop down menus (only thing that make sense is sending the down key down several times...but if you know another way, let me know).

ONe idea that just came to me would be to insert the anchor text code into a text document. Then open up the text document in MS Word. Then in MSWord save the document as an HTML file. Then open up the HTML file locally in firefox. Then go to a new site like http://pdfmyurl.com/ and turn the page to a pdf.

Since are talking about thousands of documents here, one clearly would be helped by an automation solution. Perhaps only part ofr the job can be automated and the challenge is finding out which part of the job makes the most sense to automate.

For instance, it's pretty easy to append a given line to two set of text documents - thousands can be done in a few minutes.

The problem is that yhou have some that will look like:

<a href="http://www.domain.com">Click Here For More Info</a> text text text text......

------

PS
Maybe the text document could be opened or saved as a csv file, then manipulated in excel; then the info opened in ms word in order to be converted to pdf


--BOY IF WE COULD FIGURE OUT HOW TO GET WINAUTO TO CONVER T TO PDF IT WOULD BE A MAJOR BREAKTHROUGH :D

__________________

~~~~~~~~~~@~~~~~~~~@~~~~~~~~@~~~~~~~~~~~~~~~~~
Double Your Productivity & Profits - Get Exclusive, Tips, Tools, Tutorials & Reviews -when You Join AutomationNewsLetter.com

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

__________________

~~~~~~~~~~@~~~~~~~~@~~~~~~~~@~~~~~~~~~~~~~~~~~
Double Your Productivity & Profits - Get Exclusive, Tips, Tools, Tutorials & Reviews -when You Join AutomationNewsLetter.com

 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

D.M.Altizer
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 01/12/2010
Posts: 204
Re: Inserting Links, Converting to PDF?

 Hm... This sounds like a really interesting idea... We could create a template HTML file with placeholders for the text and the URL's parts that would be used to create a unique html file for each text file. Then we can upload it to an FTP directory and use something like the attached job (with a list of course, not a user input dialog) to convert it to pdf...

The good thing about this solution is that it will not use interactive actions at all: everything will be happening in the background...

How does this sound?

AttachmentSize
Convert Website To PDF.waj 15 KB
__________________

==Dedicated Automation Solutions==

__________________

==Dedicated Automation Solutions==