#csv-upload

[futuristicinno]

How to Solve Quadratic Equations: 5 Simple Methods with Examples Quadratic equations might seem intimidating at first, but once you understand the different solving methods, they become much easier to handle. Whether you're a Class Read more

[agardenandlibrary]

coworker: "hot tip on how to do X thing!"

me: is it a "hot tip" or is it a common functionality that's easily visible if someone actually read the page?

coworker: it's a hot tip!

Open it up.

It's a common functionality.

[natural-blogarithm]

i think it is once again time for me to write a little python script to deal with this exam score nonsense

[thevalleyisjolly]

Manual data entry my beloathed

[nashvillehotchicken]

trying to figure out soulseek so i can save my favorite tmg uploads but digging through my youtube playlists to find the songs i wanna download is tedious as all hell

[sosquaresowhat]

I get to make an inventory spreadsheet for fun today and I am so hype

[fanfictionlibrary01]

AO3 Data Scraped for AI Training Dataset

What is happening, and what you can do. Check for potential edits with additions at the end of the post!

What is happening? What do we know?

A user going by "nyuuzyou" on the HuggingFace platform uploaded a dataset a few days ago - containing scraped content from AO3. HuggingFace is a very popular platform and widely used for sharing machine learning and AI models/datasets. The scraped dataset includes fics, fanart, and other fanworks - all taken without permission and intended for use in training gen AI models. You can find more information in this Reddit post.

This dataset is one of several compiled from various websites—at least seven in total. While two datasets have been removed, the AO3 one was only disabled on HuggingFace. This means that it’s not downloadable at the moment but still visible. It may also return if takedown efforts end up being challenged/reversed by that user.

Key Details

Scope: On AO3, all content with work IDs between 1 and 63,200,000 has been targeted. The work ID is the number at the end of a work's URL — for example, in https://archiveofourown.org/works/12345678, 12345678 is the work ID. You can find it by simply opening the work and checking the URL in your browser’s address bar. So, if your work falls in that range and is publicly accessible (i.e., not locked and open to everyone, including guests), it’s mostly likely included in the dataset. This dataset is currently disabled on HuggingFace, but that doesn't mean it's gone. It's only a temporary takedown as of now.

Takedown notices have been issued, but this user has also uploaded the dataset to other sites after backlash and partial removal.

There are talks in the discussion forums of potentially moving this dataset to Telegram, torrents, and/or other private channels.

HuggingFace AO3 dataset page

Other distributed sites listed here (as per a Reddit comment)

Currently deleted from ModelScope

What can you do?

Should the dataset return again and you see that your work was affected: file your own DMCA or copyright takedown notice. The uploader, in their own words, "has not agreed to take down the entire repo. At this time, the scraper has agreed with taking down art from the person who owns the copyright. That means each of you will need to request a takedown."

Instructions and a sample CSV template to list your work IDs for removal are provided in this guide. You can find more details in this announcement by PaperDemon.

Lock your works! It would limit visibility to registered users only, and is a very good step to prevent scraping or unauthorized use. To lock all your works on AO3, go to “My Works,” click “Edit Works,” and select all. Then click “Edit” and check the box labeled “Only show to registered users.” Scroll down and click “Update All Works” to apply the change.

⚠️ | Final Notes:

This user has so far shown no signs of stopping and is continuing to redistribute the data across multiple sites, even after numerous takedown requests (read more here). So, we can only recommend to be cautious and beware, lock your works, feel free to make use of takedown notices if you're unfortunately affected, and spread the word to fellow creators.

Follow up on this and get the latest updated in the Fanfic Communities Network (FCN) Discord Server!

If you have more information regarding this - e.g. if works from other sites are affected too - please reach out to us in the FCN!!

Edit (2025-04-26):

The user who has scraped the works has, upon request by another person, posted a way to convert ao3 json to markdown:

https://huggingface.co/datasets/nyuuzyou/archiveofourown/discussions/170

https://gist.github.com/nyuuzyou/b2f83669ad80a22e435728245ebcdf9f

This shows us that nyuuzyou continues to show no signs of taking down the scraped works.

Edit (2025-04-28):

A user warned that even archive-locked AO3 fics were included in a scraped dataset (most likely taken while the scraper was logged in, before they were banned or switched to public-only access). Some public works were missed as well:

https://huggingface.co/datasets/nyuuzyou/archiveofourown/discussions/213#680fcdb76d9e022324a70cf1

Edit (2025-05-03):

Hey everybody, this is a bit late, but the AO3 dataset has been permanently removed from HuggingFace: https://huggingface.co/datasets/nyuuzyou/archiveofourown. While this unfortunately doesn’t prevent it from being shared elsewhere (like torrents) nor does it guarantee any deletion of past downloads and whatnot, having it taken down from a major platform like HF is still a significant step forward. (There is more info about other sites on PaperDemon.)

So please don’t be disheartened—every action counts, and this shows that pushing back and filing DMCAs and copyright notices as appropriate does make a difference. We’ll certainly keep an eye out for more info and post updates here, but thank you again to everyone who helped report, spread the word, or supported the effort. Keep reading, keep writing. ♥️

[wokealqaeda]

A stabbing happened today at 10:42am in Vähäjärvi school, Pirkkala Finland.

A 16-year old boy named "Alex" stabbed 3 girls in the hallway and filmed the crime. None of the victims got life threatning injuries and paramedics were able to stop their bleeding.

Pirkkala School Stabber's Manifesto

• Location: Vähäjärvi school, Pirkkala

• Date: May 20th, 2025

• Target: Female students

• Weapon: Knife

• Perpetrator: 16-year-old boy

• Motives: desire to do something impactful, bring excitement to my life, and go to prison for 2–4 years

About Me

• I am an atheist existentialist with a deterministic worldview.

• I enjoyed writing, filming, and listening to things, I had experienced in the past.

• I've never had friends, and didn't want any.

Socials:

https://old.reddit.com/user/Vouhen/

https://youtube.com/@vouhen (NOT UP ANYMORE.)

CSV file: https://jmp.sh/Y5wMLAlE

About the Attack

• I planned this half by myself, half using ChatGPT.

• The goal was to stab at least one person dead and injure at least two others.

• The targets were female students because I consider them easier targets and because the idea of hurting them feels pleasant to me.

• I will film the crime and upload it to a website.

• There were moments of hesitation but those didn't last for long.

• This was not the first crime I had planned.

• I thought this was the most optimal decision in life for me and I would regret if I didn't do it.

Summary of the Plan

1. After class, I go to the bathroom.

2. I put on a mask made out of a T-shirt, and a belt where I have my knife.

3. I attach my phone to the belt and start recording the video.

4. I leave the bathroom and walk towards the first victim.

5. I try to stab her in the carotid artery.

6. I run toward other victims and stab them both once in the waist area.

7. I leave the school.

8. I walk toward the Suupantie street while posting the video and manifesto.

9. I call emergency services and report my location.

10. I surrender when the police car arrives.

[souptastical]

Wanna find your fav old fic but it's now lost? Aaronmelzak's Harry Potter Fanfic Archive of 100+ Sites/Forums Is Now Hosted Via Me In Accessible Format✨

✦•··················INFO·····················•✦

╔═══════════════════════╗

Someone archived/collected over 100 sites/forums for HP Fanfic. This doesn't only include popular ones like AO3, FFN, HPFF, Mugglenet but very small pairing-centric and smaller communities like Checkmated, Gryffindor Tower, The Full Moony, The Restricted Section and so much more.

This is not only an extreme service to data preservation in regards to creative works, but for fandom history as a whole. Upon my post in the hpff subreddit, I had people backing up these files from the torrent & my hosted link to their own cloud service of choice, and people planning to do the above once their dl was finished. You have free reign to do the same, including taking my folder and uploading it to share. The only request is that you of course link back to the original archivist, and if you choose to change the file structure, disclaim how it has changed from the very original structure.

To help the apparent confusion: This comes as a torrent file unless you choose to look through the archive link by zips. This is a good way, but doesn't allow to see the file structure as the archivist created. So I downloaded almost 100 GB & uploaded it, file structure as is, besides a few changes which I will put below. You are now able to browse at will through the folders, which are sorted. This was done due to ease of access. You will need to use a program like winrar/7zip which is as simple as opening the zip through said program, which allows you to view it. This is also available on smartphone. To view the directories, you need to open the .csv files through excel which is just as simple as the above, and is also on smartphone.

The list of archived sites is long, so I won't be including it here. If you don't wanna look through the folders yourself at which zips are provided, send me a PM and I'll get back to you as quick as I can💖

To note: I'm only sharing 50% of transfer quota. Wish I could share more, but I've already shared 200 GB.

Changes made from original archivist file structure:

"No longer updated" + "Assorted" folder: now mixed and called "Original Fan Sites- Misc- Assorted"

"Actively Updated" folder: now called "Last Updated 2023"

╚═══════════════════════╝

[corseque]

@selemchant @noxconsortium

Here's a breakdown of what I did

I went through the ">conversations" section, looking for which files actually made up the dialogue trees. It's a little different than Inquisition, but I eventually found that they seem to be within the "FC_ConvFlowLayer" files.

Frosty actually has the strings linked correctly within these files, but it's very cumbersome to look at in Frosty. I wanted to make it easier to read. When you export these FC_ConvFlowLayer files, they are .xml files that link to numbers instead of strings.

When you export the raw script of DAV from Frosty Editor, every line is paired with the same matching little numbers (minus the first "0x" for some reason).

The raw script is a .csv file that looks like this:

So I added an "0x" to every line of the .csv file (so they would match) and then made a python program that found all the strings within the <StringId></StringId> tags in all the xml files, and then looked up the matching number in the Raw Script .csv file and then saved the second column (the text) from the .csv file into the .xml files.

So now instead of numbers, I have strings:

Now, these .xml files have a lot of information in them that someone smarter than me could figure out how to make a comprehensive dialogue tree out of, because I think all of the information you would need is provided by the xml files. But that's hard and for now I just wanted a .txt file of who spoke what line.

It wasn't hard from there to write another little program to extract just the speaker and the lines into a plain .txt file

And then to merge all the text files together and use notepad++ and the power of regular expressions to clean them even more:

IF YOU WOULD LIKE TO PLAY AROUND WITH THE .XML FILES THAT HAVE THE NUMBERS REPLACED WITH STRINGS but that still have all the conversation information intact, like how each of the lines are linked to each other, I uploaded them here on google drive (there are 1500 files, but they're pretty small):

LINK TO THE XML FILES FOR YOU TO DO WHAT YOU WANT WITH

[shellhawk]

AO3 has been scraped again. Dammit.

All the information and updates are here as far as April 22 are here, so please, read it all: https://www.paperdemon.com/app/g/pdarpg/events/view/994/immediate-action-required-your-art-and-writing-has-been-scraped-and-published-in-an-ai-dataset/1

The summary is this: a user of the HuggingFace (a machine learning website where people upload databases, applications and models) that goes by the name of nyuuzyou has done an unauthorized scrape of both artwork and writing from at least seven (7) websites, Archive of Our Own included. You can see it here: https://huggingface.co/datasets/nyuuzyou/archiveofourown Of those seven websites, only two (2) datasets has been deleted.

The dataset of AO3 on HuggingFace is currently disabled, meaning: you can't download it but you can still see the relevant information of the dataset and it could be available again if the copyright infringement/DMCA takedowns requests are countered. As far as of April 23 (today), the AO3 dataset has only 4 copyright infringement notices. I encourage eveyone to do one, since (quoting): "the scraper has not agreed to take down the entire repo. At this time, the scraper has agreed with taking down art from the person who owns the copyright. That means each of you will need to request a takedown".

EDIT: I apologize for not including this in the OG post, but yes, as others in the comments have said, the database "was created by processing works with IDs from 1 to 63,200,000 that are publicly accessible." Work ID means the number in the URL of the works, so if your work has a matching ID between 1 to 63,200,000, then your work is in the dataset and you can fill a DMCA or a copyright infringement notice. The CSV thing on PaperDemon is just a list that you privately (via email) send to the user who did the dataset so they identify your work in the dataset and delete it. So you can do it just, copy and paste your works' ID to an excel file and send that.

The link with all the information I shared above has instructions as to how to do it, but if anyone does it and wants to share their process please feel free to do so.

EDIT 2: The user nyuuzyou has doubled down and uploaded the AO3 dataset (and the other ones, included the ones that they deleted on HuggingFace --fucking ass) to others sites. You can see the sites on this comment: https://old.reddit.com/r/AO3/comments/1k6a3t6/ao3_has_been_scraped_again_for_genai_purposes/moosipe/

EDIT 3: The dataset has been deleted from the ModelScope website. https://www.modelscope.cn/datasets/nyuuzyou/ao3

[futuristicinno]

Who are the two women at the center of the alleged affairs involving Donald Trump? Former President Donald Trump has remained a polarizing figure in American politics, no longer nice due to his regulations and management style but additionally due Read more

[tessasilverswan]

Latest AO3 scrape into AI database

Please read this if you're an AO3 user with public, not archive-locked works. This is information on the latest known instance of someone taking AO3 works to build datasets on which to train AI and the ongoing process to get them removed. I don't really make posts adressing people, but I am furious about my work being used and I know some of my mutuals don't have their fics archive-locked so I hope I can at least get the information to some people.

Earlier this month (April) a, to my understanding, rp fanworks website named PaperDemon.com got word that a user of an AI dataset website, HuggingFace, had scraped its contents, as well as those of a bunch of other websites among which AO3 is included, where they can be freely downloaded to train generative AI models. For AO3 specifically, the user themselves reports that all public works with IDs ranging from 1 to 63,200,000 have been scraped.

As of April 25 and per the updating Paper Demon publication, 2 of 8 affected sites have gotten their content removed and the rest have achieved temporary disabling (supposedly data is visible but not downloadable) pending a counter-notice from the scraper, who appears to be set on the aim of dismissing the request as unfounded. Furthermore, the AO3 dataset has already been downloaded 2,244 times in the last month. On earlier updates of the PD post they mentioned that the scraper agreed to remove, on an individual basis, the content of those who file a Copyright infringement report. So far there are about 150 reports against the AO3 dataset. The scraper also uploaded them to another website, but appears to have removed at least the PD ones, as well as to his personal website which the PD post doesn't even link for safety reasons. The platform HuggingFace has also been made aware of the situation (that's what got us the temporary disabling)

I have personally filed a Copyright infringement report using the helpful guide put together by the PD team and have emailed the scraper on the address listed there providing the title and URL of my work and requesting for it to be removed from the dataset.

I have one concern regarding the PD guide, though (disclaimer: this is coming from someone with a very limited knowledge on computers & digital information and my understanding of the majority of concepts is from 3h of internet searches + ms help page + messing around in my laptop) They rightly recommend to not publish the work URLs in the report and instead instruct to collect them in a spreadsheet in .cvs filetype. This, however, has a problem of personally-identifying metadata being stored "alongside" the file itself and it can be accessed. The MS Excel Inspector tool allows the removal of this type of data, but apparently only when it's shared through the MS account? For Google sheets there is a different problem, which is that you can't just make your spreadsheet in .csv filetype, you need to download it and the reupload it (if there is a way, it's not easily accessible; i looked at like 4 step-by-step guides and they all said to download) which again adds properties to the file that may contain personal information.

I was very sleep deprived and very close to giving up, because I do not wish to provide a person that's massively stealing content any information linked to my identity, but then I thought I could just send the info on the email body itself. It's not the best solution but I think it's better than the alternative.

I am beyond mad that this happened and will archive-lock my affected work as soon as I receive a response (or after enough days of silence, I guess, but I hope my report won't be ignored). Unfortunately I can't file a DMCA take-down notice, because it requires personal information which might be shared with the infringer if they file a counter-notice, but I have hope that, if everyone whose works were scraped files Copyright infringement reports, AO3's DMCA won't be dismissed.

I encourage anyone who has read this to also file a report to get their work(s) removed asap and, if anyone is more informed or knowledgeable on the topic, to please share any useful info you have. I might also email AO3 to inquire about the DMCA status later because the PD publication is understandably only really tracking theirs.

[wefel00]

The Ultimate Guide to Gimkit: Unlocking the Power of Game-Based Learning

In today’s classrooms, student engagement can be one of the biggest challenges teachers face. Enter Gimkit—a game-changing platform that transforms traditional quizzes into fast-paced, competitive, and fun learning games. Whether you’re a seasoned educator or just hearing about Gimkit for the first time, this guide will walk you through everything you need to know.

1. What Is Gimkit?

Origins of Gimkit

Gimkit was developed in 2017 by high school student Josh Feinsilber as part of a project for a business class. Frustrated with boring review methods, he created a more interactive and exciting way for students to study.

Purpose and Vision

Gimkit blends gamification and formative assessment, allowing students to answer questions in a live or asynchronous environment while earning virtual money to upgrade their gameplay. The vision is to keep learning fun, personalized, and data-rich.

2. How Gimkit Works

Core Gameplay Mechanics

Teachers create “Kits”—question sets tailored to any subject or skill level. During the game, students answer questions to earn virtual money, which they can use to buy power-ups or upgrades that impact gameplay.

Reinforcement Through Repetition

Gimkit is structured so that students see incorrect questions again and again until they answer correctly, helping to reinforce knowledge through strategic repetition.

3. Creating a Gimkit Account

Signing Up as a Teacher or Student

To get started, visit gimkit.com. Teachers and students can sign up using their Google accounts or a standard email address.

Account Types and Roles

Teachers can create Kits, host games, and access reports.

Students can join games via a code—no account is required to play but having one allows them to track their progress over time.

4. Building Your First Kit

Creating Custom Questions

You can build Kits from scratch, including multiple choice, short answer, or flashcard-style questions. Add images, mathematical expressions, or audio to make questions more engaging.

Importing Existing Content

Gimkit lets you import question sets from Quizlet or upload CSV files, which is perfect for busy teachers looking to reuse or adapt existing materials.

5. Hosting a Live Game

What Is Live Mode?

Live mode turns the classroom into a game show. Students use a join code to enter, then race to earn virtual cash by answering questions.

Customizing the Game

Teachers can set game length, question repetition rules, and determine whether students play solo or in teams. You can also enable or disable upgrades and power-ups.

6. Assigning Homework with Gimkit

What Is Assignment Mode?

Unlike live games, Assignments allow students to complete a game at their own pace. This mode is ideal for remote learning, homework, or asynchronous reviews.

Monitoring Student Progress

Teachers receive detailed reports including:

Completion rates

Time spent on each question

Accuracy and improvement over time

7. Exploring Gimkit Game Modes

Classic Mode

The original game format—fast-paced, competitive, and familiar. Great for quick classroom reviews.

Creative Game Modes

Gimkit frequently introduces new modes like:

The Floor Is Lava: Avoid “lava” as it rises while answering questions.

Trust No One (Among Us-style): Combines social deduction with academic review.

Draw That!: A drawing-based mode ideal for vocabulary or concepts. These modes are rotated to keep the gameplay fresh and exciting.

8. Power-Ups and In-Game Strategy

What Are Power-Ups?

Using the money earned from correct answers, students can purchase power-ups such as:

Increased earnings per correct answer

Insurance (no money loss for wrong answers)

Multipliers This adds a strategic element beyond just knowing the right answers.

Why They Matter

Power-ups mimic gaming logic and keep students engaged longer. Students begin thinking about risk-reward, which encourages deeper thinking and planning.

9. Analytics and Student Reports

Real-Time Data

During live games, teachers can see who’s answering questions correctly and who might be struggling—instantly.

Post-Game Reports

Gimkit generates downloadable reports showing:

Individual and class-wide accuracy

Top performers

Time spent per question

Growth metrics over multiple games These insights help teachers fine-tune instruction and provide targeted support.

10. Classroom Management and Engagement

Boosting Participation

Gamification appeals to students who may otherwise be disengaged. The reward system provides instant feedback and motivation.

Encouraging Teamwork and Collaboration

Team modes allow for collaborative play, helping to build peer relationships and social-emotional skills in the classroom setting.

11. Integrating Gimkit into Your Curriculum

Applicability Across Subjects

Gimkit isn’t just for trivia. It works well with:

Math (problem-solving, computation drills)

Science (vocab, processes, diagrams)

Language Arts (grammar, reading comprehension)

Foreign Languages (vocab practice)

Social Studies (dates, terms, historical context)

Lesson Plan Alignment

With careful planning, you can align Kits to state standards or learning outcomes, making Gimkit not just a review tool, but a core instructional resource.

12. Pricing, Plans, and Gimkit Pro

Free Plan

Includes basic features like:

Live games

Creating Kits

Access to a limited number of modes However, it comes with some restrictions on assignments and advanced game types.

Gimkit Pro

For a monthly or annual fee, Gimkit Pro unlocks:

Unlimited Kits and assignments

Access to all game modes

Deeper analytics and reporting

Collaborative Kit building

Priority support There’s also Gimkit for Schools, allowing districts to purchase access for all teachers.

Conclusion: Why Gimkit Is Changing the Classroom

Gimkit isn’t just a game—it's a learning revolution. With its intuitive interface, powerful analytics, and engaging gameplay, Gimkit helps students master material while having fun. It supports a student-centered learning environment where motivation and mastery go hand in hand.

Whether you’re using it to reinforce vocabulary, prep for tests, or differentiate instruction, Gimkit empowers both teachers and students to take ownership of learning.

[epshreyashsompura]

How to Add CSV Data to an Online Map?

Introduction 

If you're working with location-based data in a spreadsheet, turning it into a map is one of the most effective ways to make it visually engaging and insightful. Whether you're planning logistics, showcasing population distribution, or telling a location-driven story, uploading CSV (Comma-Separated Values) files to an online mapping platform helps simplify and visualize complex datasets with ease.

🧩 From Spreadsheets to Stories

If you've ever worked with spreadsheets full of location-based data, you know how quickly they can become overwhelming and hard to interpret. But what if you could bring that data to life—turning rows and columns into interactive, insightful maps?

📌 Why Map CSV Data?

Mapping CSV (Comma-Separated Values) data is one of the most effective ways to simplify complex datasets and make them visually engaging. Whether you're analyzing population trends, planning delivery routes, or building a geographic story, online mapping platforms make it easier than ever to visualize the bigger picture.

⚙️ How Modern Tools Simplify the Process

Modern tools now allow you to import CSV or Excel files and instantly generate maps that highlight patterns, relationships, and clusters. These platforms aren’t just for GIS professionals—anyone with location data can explore dynamic, customizable maps with just a few clicks. Features like filtering, color-coding, custom markers, and layered visualizations add depth and context to otherwise flat data.

📊 Turn Data Into Actionable Insights

What’s especially powerful is the ability to analyze your data directly within the map interface. From grouping by categories to overlaying district boundaries or land-use zones, the right tool can turn your basic spreadsheet into an interactive dashboard. And with additional capabilities like format conversion, distance measurement, and map styling, your data isn't just mapped—it's activated.

🚀 Getting Started with Spatial Storytelling

If you're exploring options for this kind of spatial storytelling, it's worth trying platforms that prioritize ease of use and flexibility. Some tools even offer preloaded datasets and drag-and-drop features to help you get started faster.

🧭 The Takeaway

The bottom line? With the right platform, your CSV file can become more than just data—it can become a story, a strategy, or a solution.

Practical Example

Let’s say you have a CSV file listing schools across a country, including their names, coordinates, student populations, and whether they’re public or private. Using an interactive mapping platform like the one I often work with at  MAPOG, you can assign different markers for school types, enable tooltips to display enrollment figures, and overlay district boundaries. This kind of layered visualization makes it easier to analyze the spatial distribution of educational institutions and uncover patterns in access and infrastructure.

Conclusion

Using CSV files to create interactive maps is a powerful way to transform static data into dynamic visual content. Tools like MAPOG make the process easy, whether you're a beginner or a GIS pro. If you’re ready to turn your spreadsheet into a story, start mapping today!

Have you ever mapped your CSV data? Share your experience in the comments below!

[micecakes]

dam I rly had to format a csv document to upload users to a thing and now it’s done the tell me they have a system to do it automatically with something we already have integrated, like why tell me this now after I’ve already done the like 400+ users