Need Script to retrieve article URLs

by Willmarathon

Posted: 14 years ago 7 replies

PROGRAMMING

I have a list of 405 article directories where a spun article was sent and
the URL of each article. I want to send 100 URLs to PingDevice and then list 100 each in Create Your Free Hosted RSS Feed In Seconds , but how do I separate the article URLS from the data in the list?

Here is an example:
www.ArticleMakt.com, GDIFast Track Team Knows Over 35 Programs to ProduceSales with Global Domains International , Approved ,

(the first 4 letters taken off so as not to show a URL)
://www.ArticleMakt.com/Art/28469/27/GDI-Fast-Track-Team-Knows-Over-35-Programs-to-ProduceSales-with-Global-Domains-International.html

#article #retrieve #script #urls

mywebwork 14 years ago

If it wasn't for the final comma it looks like your list is a CSV file, is that true? If so there may be a way of segregating the URL into one column.

Otherwise all I can think of is (a) a custom script or (b) a text editor with a macro. For the latter it might be useful to save the list in an e-mail or HTML editor to automatically create hyperlinks for each URL. These links would server as useful markers for a script or macro.

Bill
- [ 1 ] Thanks
{{ DiscussionBoard.errors[2338567].message }}
Willmarathon 14 years ago

Thank you mywebworker. Yes, they are a csv file and what I will try to do and you made me think ofit by reminding me it was a CSV file (I used to write C,C++ and JavaScript in my programming days), is to load all of them into an OpenOffice.org excel file. I sort of forget how to do that, but I am sure I can query hte Help file on OpenOffice.org and then I will just paste and copy the last column 100 lines down at a time and use those to input to the PingDevice.com file.
Thanks for reminding me about CSV files.
- Thanks
Signature
Best Internet Web Success Home Businesses:Work at Home to Make Money Online,Stay Healthy & Travel the World
Make Affiliate ClickBank Sales & Profit Online
{{ DiscussionBoard.errors[2342319].message }}
mywebwork 14 years ago

If it is a CSV then it is a native file format to both Open Office and MS Office, so that should do the trick for you.

Best of luck with it!

Bill
- Thanks
- 1 reply
{{ DiscussionBoard.errors[2342688].message }}
- Willmarathon 14 years ago
  
  Originally Posted by mywebwork
  
  If it is a CSV then it is a native file format to both Open Office and MS Office, so that should do the trick for you.
  
  Best of luck with it!
  
  Bill
  
  What I did was to click on Insert, then Sheet from File and import
  the file the distribution site had emailed me. But data is filed in Rows,
  but not by columns so I have
  1. Directory Name,Title,Status,URL
  2. Directory Name,Title,Status,URL
  3. Directory Name,Title,Status,URL
  
  None of these are separated by the column lines. However, I did find
  this as refernce for someone:
  Show FORMULA or FORMAT of another cell
  
  I did not see anything in there to help me out, but do you have some suggestions?
  
  Thanks
  
  Signature
  Best Internet Web Success Home Businesses:Work at Home to Make Money Online,Stay Healthy & Travel the World
  Make Affiliate ClickBank Sales & Profit Online
  
  {{ DiscussionBoard.errors[2362612].message }}
mywebwork 14 years ago

Try renaming the file with a ".csv" extension and see if you can open it directly with Excel. This should keep everything in its own column.

Bill
- Thanks
{{ DiscussionBoard.errors[2362653].message }}
Willmarathon 14 years ago

I am using OpenOffice but I will try doing that now.
- Thanks
- 1 reply
Signature
Best Internet Web Success Home Businesses:Work at Home to Make Money Online,Stay Healthy & Travel the World
Make Affiliate ClickBank Sales & Profit Online
{{ DiscussionBoard.errors[2362710].message }}
- Willmarathon 14 years ago
  
  I saved the file as .csv and the bar for columns magically appeared in OpenOffice after I clicked Sheet from File and then imported.
  I then copied the first 100 articles,pasted them into PingDevice,
  then while they were processing I opened Create Your Free Hosted RSS Feed In Seconds
  and created a feed for the first 100 articles. Now I will set up
  Web Traffic Genius on one of my blogs and submit those to all the major
  RSS integration sites.
  
  Thanks
  
  Signature
  Best Internet Web Success Home Businesses:Work at Home to Make Money Online,Stay Healthy & Travel the World
  Make Affiliate ClickBank Sales & Profit Online
  
  {{ DiscussionBoard.errors[2363615].message }}

Need Script to retrieve article URLs

Trending Topics

Been a while! Any of you Old Timers here?

How much does the rebranding affect CR ?

Are billboards still effective in driving customers?

Boat and Jet Ski Rentals...... Door Hangers Effective?

A Very Strange Internet Problem