Retrieving Transcript and Quiz - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Retrieving Transcript and Quiz

Jerry Fowler

6 months ago

I see you have changed the way we can look at the Transcripts, Quizzes, Summaries, and so on. See, I have been retrieving that data from your pages using the grabbed CommentsID. Then, going to that page and grabbing the text of the Transcripts and Quizzes.
But now with the new format (which I'm a big fan of), I need a push to try and figure out how to grab the text using your new format.
I have been using your ScrapeAndSave, FindBetween processes. Any help is needed and appreciated.

	Alex Hedley @Reply 6 months ago
Is there an ID you can use to identify them?

	Jerry Fowler OP @Reply 6 months ago
Alex, I haven't been able to find an ID. Up to a few days ago I was able to get the transcript commentID and the Quiz CommentID from the tech help page. Now you go to the bottom of the page and click on the Transcript or Quiz to open that section. I am trying to pull the data by searching the code to retrieve the data.

	Jerry Fowler OP @Reply 6 months ago

	Alex Hedley @Reply 6 months ago
You could get all elements by name i.e. `<Details>` and check what the `<Summary>` is? Or ask Richard nicely to add an identifier to it?

Richard Rost @Reply

6 months ago

Well the BlogID would be in the URL. Fitness 58, for example, is BlogID=3749. To get the transcript and quiz, just look for the summary sections for them.

Adding them as comments was just a quick fix when I first developed it. I've been meaning for a long time to move those fields into the actual blog table, which I finally got around to doing, and then importing all the data and deleting those comments.

	Alex Hedley @Reply 6 months ago
`<details id="quiz">`

	Jerry Fowler OP @Reply 6 months ago
Thanks for all the comments and help. You have pointed me in the right direction.

	Jerry Fowler OP @Reply 6 months ago
Just wanted to let you know that with all your help, I was able to rework the VBA code to put the Transcript and the Quiz off the page. Thanks again, I would not have been able to pull this off or any of the work that I have been doing for the last few years if it weren't for this group, and of course Richard.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View