Skip to content

Frequently Asked Questions

Jane edited this page Feb 18, 2022 · 4 revisions

Welcome to the FAQs! Here I attempt to anticipate and answer some questions that may come up about this application.

Can you see what username and password I put in the app?

No, I cannot. This information is entirely local to your machine. I have no way of seeing it, fetching it, etc.

Each time you start the app, the username and password that you used the last time will appear. ⚠This information is stored in a plain text configuration file located at \Claim Skimmer\bin\Debug\net5.0-windows. You can open that file in a plain text editor like Notepad or WordPad and delete the values stored after the = sign if you do not want those values to appear. (But they will be stored again, of course, next time you enter them in the app window.)

image

I don't have Visual Studio, but I still want to use this tool. Can I?

Yes! You can download a pre-built version.

Who can use this tool?

Anyone! The tool was built for prompt meme administrators in mind, but people who'd just like to browse the meme more easily can also use it. If you're a prompt meme administrator, it may be worth hosting a public-facing version of the spreadsheet for people to browse.

Hosting a public-facing version

Since this tool generates a comma-separated values file, the logical train of thought would be to host it on a public Google sheet so that others can browse. I, too, thought this, then realized the most annoying thing about that: if multiple users are viewing a sheet at the same time, then Person B sees whatever Person A is filtering on, and any changes Person B makes affect what Person A sees.

To get around this, the best method that I found was to embed the spreadsheet in an external website. Of course, with most cloud-based software - Google Sheets included - sorting and filtering options are stripped out of the HTML used to embed the sheet, so it becomes functionally useless.

Oddly enough, Microsoft Excel Online is the real winner here. It is free with an Outlook email account. When you embed an Excel Online document on your website, users will be able to interact with the embed without affecting anyone else's view. AND they can sort and filter, too!

Example:

image

tl;dr Excel Online with a website embed. You can even use carrd! (You will need the paid version to access embeds, and currently the "Pro Standard" plan - the lowest tier that still includes embeds - is $19 per year.)

  • I actually upgraded to the Pro Plus plan so I could make the spreadsheet iframe mobile responsive. If you're interested in that, let me know!

Do I have to use Excel to open this spreadsheet?

Nope! This program generates a comma-separated values file, which is not exclusive to Excel. You can import this sheet into cloud-based software like Google Sheets or Zoho Sheets without ever opening it in Excel.

Does this application follow the AO3's Terms of Service?

Yes! Per AO3, they do not have a policy against bots or scraping. Additionally, this application waits five seconds between page requests.