Hyperlink checker for local website (1 Viewer)

R

ram_rtg

Registered User.

Local time

Today, 20:48

Joined

Jun 18, 2015

Messages

47

• Dec 7, 2016

• #1

Hi everyone,

I'm wondering if anyone has attempted to use Access to identify broken links on a local website.

I know there's a lot of tools out there that already do this but I would like to build one using Access.

I searched the forum and looked in the sample databases but couldn't find anything so I'm assuming this hasn't been done yet.

Any thoughts, ideas or recommendations?

Thanks in advance.

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 12:18

Joined

Jul 9, 2003

Messages

16,280

• Dec 7, 2016

• #2

I'm sure it's possible in Access and VBA. If your goal is to get a deep understanding of vba then it might be worth the effort.

However I do know that Python has beautifulsoup which I understand is specially designed for scanning websites.

I have also seen some excellent books and video tutorials on using Python and in particular beautifulsoup. From the point of view of gathering the information, getting help, then a better route would be Python I believe.

The problem of doing this in MS Access is that I don't recall many posts on the subject. I think you might have problems finding specific information, although you could try a VBA forum for this type of information.

Sent from my SM-G925F using Tapatalk

 

S

Simon_MT

Registered User.

Local time

Today, 12:18

Joined

Feb 26, 2007

Messages

2,177

• Dec 8, 2016

• #3

I have used Xenu for years and its good for both 404s and missing assets although it will not pick-up <Picture> element assets used with Media queries. That is asking a lot. Will do local and external web sites.

Simon

 

Uncle Gizmo

Nifty Access Guy

Staff member

Local time

Today, 12:18

Joined

Jul 9, 2003

Messages

16,280

• Dec 8, 2016

• #4

Xenu

http://home.snafu.de/tilman/xenulink.html

Sent from my SM-G925F using Tapatalk

 

G

Galaxiom

Super Moderator

Staff member

Local time

Today, 21:18

Joined

Jan 20, 2009

Messages

12,852

• Dec 8, 2016

• #5

Link Checker is very good.

 

S

SimplySarah

Registered User.

Local time

Today, 04:18

Joined

Oct 24, 2016

Messages

15

• Dec 8, 2016

• #6

Why specifically do you want to use Access?

 

R

ram_rtg

Registered User.

Local time

Today, 20:48

Joined

Jun 18, 2015

Messages

47

• Dec 15, 2016

• #7

Simon_MT said:

I have used Xenu for years and its good for both 404s and missing assets although it will not pick-up <Picture> element assets used with Media queries. That is asking a lot. Will do local and external web sites.

Simon

Click to expand...

I've used Xenu in the past and it was pretty good however it's a bit slow for our website and doesn't take into consideration the JS used to rectify the incorrect links when the page is loaded so there will always be some more work after I run it.

 

R

ram_rtg

Registered User.

Local time

Today, 20:48

Joined

Jun 18, 2015

Messages

47

• Dec 15, 2016

• #8

Galaxiom said:

Link Checker is very good.

Click to expand...

It's a nice simple interface so I downloaded it and running it now however I still think it will not be ale to incorporate the JS that fixes incorrect links once the page is loaded.

 

R

ram_rtg

Registered User.

Local time

Today, 20:48

Joined

Jun 18, 2015

Messages

47

• Dec 15, 2016

• #9

SimplySarah said:

Why specifically do you want to use Access?

Click to expand...

I need a Link checker that can scan through a page and ignore the links that the JS will rectify when the page loads but still identify the others that are broken.

I don't need to use Access. I started off with Excel initially however I generally find Access to be a bit more faster so I thought I would go with that.

Do you have any recommendations?