Skip to content
View in the app

A better way to browse. Learn more.

Tip.It Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Database Question

Featured Replies

I am currently working on a project that requires me to pull a large amount of information information directly off a website. All the info is in a standard format, but it's not delimited into a table or anything. I was wondering, does anyone know of a program or other method to efficiently catalog this information for me into a table?

Could you provide the website?

polvCwJ.gif
"It's not a rest for me, it's a rest for the weights." - Dom Mazzetti

Well, it all depends on the source and the amount of data you are trying to collect. The easiest way to gather the data if they exist, would be an external API made by the site for the specific purpose of gathering the data. If that fails you could use any number of different programming or scripting languages to automate the proccess of accessing and parsing the web pages and formatting the output file (Not sure what, if any programming languages you know, so I will just suggest going to google to search for how you can parse html with the programming language of your choice) If it is a somewhat small number of pieces of data, you may save time by just doing it manually.

Luna_pirate_signature.png

Thanks to DrCue at DeviantArt for the signature source

Whatever you do, don't use Regex :P

polvCwJ.gif
"It's not a rest for me, it's a rest for the weights." - Dom Mazzetti

  • Author

I need the database for a college schedule builder I'm working on. The website I need to pull from can be found here: http://www.registrar.fas.harvard.edu/fasro/courses/index.jsp?cat=ugrad&subcat=courses (click on each individual department name for the list). Ideally, it would pull down the description, term offered, and other relevant information as listed. No API is available to me.

What programming language are you using? Basically you should use an xml parser to grab this data....so for C# for instance you could use LINQ to XML...

polvCwJ.gif
"It's not a rest for me, it's a rest for the weights." - Dom Mazzetti

  • Author

I was thinking Java, since I'm proficient in it, but I'm still at a fairly early stage of planning at this point. Note that I don't need the system to dynamically update - the course catalog is only altered infrequently, so manual updates should not be problematic.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.