#how to export the database

[hostitsmartcanada]

Manage and secure your data efficiently by learning step-by-step instructions on downloading SQL databases from cPanel effortlessly. Read now!

[probablyasocialecologist]

The IDF uses extensive facial recognition with a growing network of cameras and mobile phones to document every Palestinian in the West Bank. Starting in 2019, Israeli soldiers used the Blue Wolf app to capture Palestinian faces, which were then compared to a massive database of images dubbed the “Facebook for Palestinians.” Soldiers were told to compete by taking the most photos of Palestinians and the most prolific would win prizes. The system is most extreme in the city of Hebron, where facial recognition and numerous cameras are used to monitor Palestinians, including at times in their homes, instead of the extreme Jewish settlers living there, who routinely express genocidal threats against the Palestinians. The IDF claimed that the program was designed to “improve the quality of life for the Palestinian population.”

Antony Loewenstein, The Palestine Laboratory: How Israel Exports the Technology of Occupation Around the World

[roksik-dnd]

For everyone who asked: a dialogue parser for BG3 alongside with the parsed dialogue for the newest patch. The parser is not mine, but its creator a) is amazing, b) wished to stay anonymous, and c) uploaded the parser to github - any future versions will be uploaded there first!

UPD: The parser was updated!! Now all the lines are parsed, AND there are new features like audio and dialogue tree visualisation. See below!

Patch 7 dialogue is uploaded!

If you don't want to touch the parser and just want the dialogues, make sure to download the whole "BG3 ... (1.6)" folder and keep the "styles" folder within: it is needed for the html files functionality (hide/show certain types of information as per the menu at the top, jumps when you click on [jump], color for better readability, etc). See the image below for what it should look like. The formatting was borrowed from TORcommunity with their blessing.

If you want to run the parser yourself instead of downloading my parsed files, it's easy:

run bg3dialogreader.exe, OPEN any .pak file inside of your game's '\steamapps\common\Baldurs Gate 3\Data' folder,

select your language

press ‘LOAD’, it'll create a database file with all the tags, flags, etc.

Once that is done, press ‘EXPORT all dialogs to html’, and give it a minute or two to finish.

Find the parser dialogue in ‘Dialogs’ folder. If you move the folder elsewhere, move the ‘styles’ folder as well! It contains the styles you need for the color coding and functionality to keep working!

New features:

Once you've created the database (after step three above), you can also preview the dialogue trees inside of the parser and extract only what you need:

You can also listen to the correspinding audio files by clicking the line in the right window. But to do that, as the parser tells you, you need to download and put the filed from vgmstream-win64.zip inside of the parser's main folder (restart the parser after).

You can CONVERT the bg3 dialogue to the format that the Divinity Original Sin 2's Editor understands. That way, you can view the dialogues as trees! Unlike the html files, the trees don't show ALL the relevant information, but it's much easier to orient yourself in.

To get that, you DO need to have bought and installed Larian's previous game, Divinity Original Sin 2. It comes with a tool called 'The Divinity Engine 2'. Here you can read about how to unstall and lauch it. Once you have it, you need to load/create a project. We're trying to get to the point where the tool allows you to open the Dialog Editor. Then you can Open any bg3 dialogue file you want. And in case you want it, here's an in-depth Dialog Editor tutorial. But if you simply want to know how to open the Editor, here's the gist:

Update: In order to see the names of the speakers (up to ten), you can put the _merged.lsf file inside of the "\Divinity Original Sin 2\DefEd\Data\Public\[your project's name here]\RootTemplates\_merged.lsf" file path.

Feel free to ask if you have any questions! Please let me know if you modify the parser, I'd be curious to know what you added, and will possibly add it to the google drive.

[copperbadge]

I never learned how to properly make a spreadsheet! I congratulate you on your initiative and skill.

…I should probably check out that free Excel class from my public library lol.

Honestly, I never had a formal class in it either -- I just fucked around in it and eventually got trained by colleagues and the necessities of the job. :D I do encourage people to learn spreadsheet basics because it's a really helpful way to track information and also to analyze data, and the library classes are a GREAT way to go about it! But also you can just start makin' sheets and every time you want it to do something and don't know how to do it, give it a google.

Google Sheets is free and slightly, I think, more accessible than Excel, but a lot of stuff differs between the two, so if you train in Google Sheets, do be aware that you can do more and different things (and sometimes have to do different things to get the same result) in other programs.

Spreadsheets I don't think were ever meant to be the backbone of most modern data management, but most databases do eventually break down into "well, you can export it as a spreadsheet" so it's a very handy skill to have :) Good luck!

[eggnogo]

sorry i should have put more info,l how did you do the thing in pacific drive with the radio

first i looked up the station's callsign on https://fmstream.org/index.php, then grabbed the link for the .aac stream here

don't download it, it'll just download forever or until the stream ends, you only need the link (also I don't know if it needs to be .aac, I've had .mp3 streams work too but .aac works the most consistently)

then take that link and slap it in VLC under 'open network stream', open it, then once it's playing export it using 'save playlist to file' as an .m3u8 file

then take that and slap it in the custom radio folder and hit rebuild database from the audio settings

if it says something like 'loaded 5 songs' when you only put one stream in there that's normal, some of them have multiple links in them

[if-whats-new]

Meet the Team!

Who are we?

Just a few Interactive Fiction enthusiasts who love sharing their interests with the rest of the internet!

But we're also:

-=-

Heyo! I'm Aj (she/her)

I got into IF through the app called Choices way back in 2017 and since then there was no turning back. It wasn't until last year when I got into text-based IFs. A friend on tumblr reblogged 'Defiled hearts', it caught my interest and here I am deep down in the trenches of IFs.

Listing my favourites isn't an easy thing cause there are so many I love. So I will list some that have been on my mind for a while: Infamous, Press Play, College Tennis: Origin Story, Drink your Villain Juice, Golden, The Golden Rose, Our Life Now and Forever, We Wretched Creatures, TWC , The Lonely Shore, Blood Choke and Midnight Sun.

I mostly help out with finding IF news and game updates in the wild.

-=-

How you doing?!? I'm Bex (she/her)

I started my journey with Voltage (now Love365) and dating sims or Otome games on my PSP Vita *sheds a tear*. I honestly don't know how I came upon IF, but I fell in love with ​Our Life: Beginnings & Always around 2021?

My favourites? Hmm, currently it would be: Love and Leases, Adoriel's Tears, The Abyssal Song, Keyframes, Our Life 2 and a bunch of Kickstarters that I can't wait for!

Personally, I'm married with no kids! And I work full-time as an administrator. Boring, I know.

In regards to the Zine, I normally do the formatting. Basically taking everything the peeps have found and putting it all into the Zine. I try and write some of the Highlights and try to dabble in the Editorial (if my work doesn't get edited).

-=-

Hello!!! This is Briar! (she/her)

I am one of the interviewers!

I got into IFs this year, and boy, my eyes were opened, and I got so obsessed that I decided to write my own (The Mighty Shifter). My personal favourites are TWC, Infamous, God-Cursed, and Viatica.

I am a uni student who is studying English literature. What else...? Have an amazing day/night!

-=-

Hey, hi and hello! I'm Dion (they/he) *on hiatus

I started my journey into IF through Episode, but due to poor non-female MC representation, I soon began to look for something else. My friend then introduced me to text-based games through The Wayhaven Chronicles and Mind Blind. I've been going deeper down the rabbit hole since!

I'm literally majoring in interactive media. IF is my life now, send help. (/j)

Some of my favourites would be: Mind Blind, Shepherds of Haven, Reanimated Heart, Seven days in purgatory, Chronicles of Taldun: The Remainder, seekL, LLLLL (aka LATEX, LEATHER, LIPSTICK, LOVE, LUST) and a lot of the stuff DOMINO CLUB does. (There isn't only IF, but that's what I usually go for. Definitely check them out if you're into creepy indie stuff!)

I'd call myself the jack of all trades concerning the zine. As of now, my main job is to be the social media guy and to do the different exports (playable Zine, Tumblr, PDF/.txt). But I also help out with news-searching and compiling + editing stuff for the editorial, column, highlight, letter and thanks portions.

-=-

Hey all, this is Jenn (she/her) *on hiatus

I am a youth sports coach (fútbol, softball, basketball) based in Los Angeles. I am in the process of applying for a master’s program (Sports psychology).

I did write and code a couple of IF games but never finished. I am a perfectionist and I couldn’t publish something not up to my standards. I started reading IF a couple years ago and I couldn’t possibly name my favorite. Some of the most memorable IFs are: The Exile, TWC, Crown of Ashes and Flames, Infamous, WWC, Zombie Exodus: SH, The Golden Rose, The Fernweh Saga, and Crown of Exile. I can definitely add more…

Basic responsibilities: Scouring the internet for IF news and frequently updating our existing database. I honestly enjoy the challenge. On a good day I can find upcoming IF titles and newly released demos. It’s so exciting to find new IF because I know someone will eventually see the same potential I do in that new IF.

-=-

Ssuuuupppp, I’m Sir tuskhany (He/Him)

I am one of the lovely interviewers who’ll be asking questions, you know grilling fellow authors on their IF, WIPS and favourite characters. The usual. As to why or how I started, I gotta say its cause of books and great authors like Robert Jordan and Brandon Sanderson. And their respective series wheel of time and basically the whole Comsere universe. I tried following in their footsteps writing a few books of my own. But like every writer most of these ended up being WIPs I either abandoned or stopped. Still I didn’t let that stop me and started posting some of them, I am the writer of Borne of the sands a static webnovel with a few chapters and Dusk and Dawn my current ongoing project(Still a work in progress so forgive the grammatical errors. T-T).

My favourite series are the Keeper of the Day and Night, Infamous, Wayhaven Chronicles and Blood Moon.

The current story I’m working on was inspired by these however most of my inspiration came from static or interactive cyoas like the Slayers v4, Supernatural Investigator, Demigod v4, A Traveller!s Tale and Universal War. If you haven’t heard of them please give them a go they are amazing.

Have fun and stay posted!

-=-            

[11vein]

how do you usually go about making a song? I've been wanting to try it out, but have never ended up finishing anything. (｡•́︿•̀｡)

my usual process goes: 1. lay out basic composition and chords (i use hookpad to do this) 2. export chord midis and import into DAW i use (logic pro) 3. mess with samples and vsts until something sounds good..... 4. import instrumental into synthv and figure out topline 5. cry for several months over trying to write lyrics 6. ???????? 7. song i genuinely recommend hookpad/hooktheory for beginners or for figuring out chords, you can look up artists in their theorytab database and look at user-submitted chords for songs you like! don't be afraid to reference chords of things you enjoy. salt wound routine and my other wips i'm working on reference a lot of chords from songs i like (namely touhou ost lol). i forget which specific songs though LOL

[veliseraptor]

figured out how to export a database, convert it into a readable file, and run a sql query for a very specific formatting quirk all by myself from the very basic sql knowledge I've managed to scrape together on my own. i'm so smart

[transformativeworks]

Seeing all posts about so and so merging with AO3 or this fandom archive moving over ...how does the process work? Like how do you avoid story duplicates or even authors? What happens when one author posts the same story under different names on AO3 and whatever old archive you're merging with? Can you filter that out? Easy of course if stories are only posted on the smaller archive and being moved to AO3 but authors post on different platforms all the time so I'm curious how the process actually works on your end.

This is such a great question! I didn't know so I went and asked the people who are in charge of moving archives onto AO3.

Eskici here! I’m one of the chairs of the Open Doors committee, which is responsible for all of the imports of offline and at-risk archives to AO3. Before each import is announced, we compile a spreadsheet with a row for every fanwork from that archive. (If the archive is backed by a database, we can often export this spreadsheet manually, but for hand-coded archives, we often do this manually.) Creators frequently email us shortly after we announce an upcoming import to let us know that their works from the archive are already on AO3 (or if they don’t want their works imported for any other reason), and we track those requests in the spreadsheet as they come in so that we don’t import duplicates. Then, as close to right before the import as we can, we manually search AO3 for every fanwork from the archive whose creator hasn’t already contacted us. Usually, we start by entering just the title of the work and a keyword or two from the name of its fandom. We try to cast as wide a net as possible so that we don’t accidentally filter out results from anyone who didn’t tag their work with the canonical fandom tag, with tags for characters/relationships in the work, etc. If we don’t turn up any results, we mark the work not found, but if we do find a matching work, we check to make sure the content is the same and then mark on our spreadsheet not to import it and instead invite that work to the AO3 collection that the imported archive will feed into. On the other hand, if we find too many matches to check all of them, we add keywords to the search to try to make it more manageable for our searchers. As you can imagine, this is a lot of manual work for us to do on top of the imports themselves, which are sometimes manual as well. Open Doors recruited for import assistants earlier this year to help with tasks exactly like these ones, and we hope to do so regularly in the coming years! If you ever have an offline or at-risk archive you’d like us to look into importing (with moderator permission), you can always reach us at opendoors@transformativeworks.org. And if you’re interested in volunteering for the project, keep an eye out for recruitment. We usually recruit for our different roles at least once or twice a year. Thanks for your interest in fanwork preservation!

[liquidcrystalsky]

im not entirely done btw, i do eventually want to make gamefiles.ranid.space an actual website, i'm tempted to even have little 3d viewers included (so i might actually have to make that gltf exporter. groans)

I'll be posting about it here when it's done (it'll take months at LEAST) and also i have an rss feed now lol

i've just manually written it out but i want to get my website blog into a sort of database (hence why i was interested in mysql) so it can automatically update the feed, but right now it's just a post filled with a bunch of outdated info about cool brower stuff and a post about how im quitting social media so nothing cool yet but i'll talk on there much less frequently because it sucks to manually do all of this.

shout out people on the internet in like the 80s this is just how they did shit. actually i lied they had SQL back then as well. how old is SQL. damn 1974 lmao okay.

i just remembered that Fortran is still being used, what the hell do you mean the best way to make something is with a programming language made in the 50s. what do you mean it's used in supercomputers.

[dead-lights]

game strings - ts4 resource

I went and extracted strings tables for most of the packs I own - essentially, these are collections of text that appears in the game - things like dialogue, item descriptions, etc. There are some strings like lot trait definitions that don't always show up in their specific pack.

Please note: these are UNEDITED string tables - they aren't very readable. Everything is divided into key/value pairs. The keys are database keys rather than human-readable titles so it's hard to know what refers to what. Everything looks like this:

{ "Key": "0x35B871C0", "Value": "Ever wonder where the Grim Reaper operates from? It's here! He's since branched out into a more corporate affair to deal with the rising influx of Sims in need of some reaping. " }

So yes! These are useful, but like I said a little hard to read. Please let me know if you need any help with these. If you need tables for a pack I don't own, let me know and I can talk you through how to export them yourself using S4Studio.

[lira456]

Naruto failure of hokage in every front like his ancestors

Many things needed fair conclusions which were overlooked so what naruto did what kind of reform he enforced regarding clan laws and treatments because of uchiha tragedy, regarding reformation of child soldiers and anbu matters becuase of rin and itachi, regarding reforming continental laws and regulation if invasion of small coutries and villages happening and their rebuilding and reparation because of wrongdoings 5 NATIONS AND KAGE have caused in the past,

also how he gonna bind all shinobi villages and even countries in the mutual trust and common ground so that nothing unlawful conclusion happen like that of shikimaru shinden and who gonna maintain or correct it in future that's why you need solid effective laws that equally and equitably benefit and treat and question everyone( author only just blink of some years bring phone,computer and video games but still maintains feudal sytem does not have international laws we have under UN so that no one can easily go to war even israelis are condemned against by UN but in naruto we don't have any such organization,laws,platform for time to time problem which can connect all shinobi countries and villages on the continent, even villages can not oppose their daimyo's order meaning they have no alternative source of income so naruto did not find another way for complete econmical survival without shinobi missions on 80 percent level such as using chakra and exporting chakra tech not for warfare especially and chakra natures lol feels like he still wants to maintain system in 60 percent ground: pure bad writing to continue boruto),

also what about orphanage system for other villages especially orphan from small villages or destructive land or from remote area like that of ryogi and kabuto and kara children and ame child how did not naruto send no shadow clone or shinobi for such purpose as he always preach about how he understand everyone's pain so called messiah or any welfare like system for poor shinobi from impoverished village shinobi or even his own village especially their widows and orphans did not shown or pension like something for shinobi especially who lost their body parts such as guy or some especial payment for shinobi like kawaki's father and give him alternative employment becuase of being war hero could have saved kawaki feels like villages abandoned many remaining shinobi or why not give them alternative employment because of their past service (just simply dispose of them if they lost value so cruel, just how pain said), by checking all the shinobi they could have but becuase they don't have correct and effective database like system even without tech that's how inaffective their shinobi system is because it's only focus on deciphering stupid message that would do no good for average shinobi and their family, collect tax from people building hiring,build some stupid building, maintain shinobi academy and its doctrination and missions and ranks and secret non transparent scheme meaning they don't have any citizen or shinobi benefit only jonin and upper echelon have that luxury even nothing special fund for orphan that's why ryogi doest not send to kabuto nothing specific, only all connected to glrifying and worshipping their anscestor that's why they don't have effective database maintained because of that after the war they lost track many shinobi and who knows how their family survived not shown not even regarding the other villages saddening, also about their individual desire or dream for that can they stop being shinobi suddenly or leave the village, did not shown regarding such issues especially how they panicked when mitsuki left and send their kids to die really sad.

it seems they even don't have unique trade that could connect all in a way that not one can lie or go to war meaning kakashi did not create any trade system only how they can rebuild and maintain ninja system which was in threat because lack of manpower(losing most of the shinobi in the war) meaning focused mostly making buildings,transportation,long distant upgraded message device and sharing shinobi missions with other villages, so kakashi did not change any political,children curriculam,ideological and law related issues in the village, naruto not even focused on changing of dangerous social struture in kiri village and lack of resources problem in iwa country and village, even we did not see how sand village's lack of resouce problem and how they solved it under gaara, really half baked, so many things overlooked,

so even did not even focus on what law or regulation he would establish to maintain clan's inner environment and conflicts becuase hyuga slavery( ther are maybe no large clans left in konoha anymore because in boruto we never see any clan meeting like that of hyuga or many clan fighting together like sarutobi and akimichi only showed some yamanaka power but not said whether they are members of yamanaka or not that's likely most died in the war, ony maybe at bare minimum members around 20 to 30 and they maintain no more clan positive harmonious tradition like clan meeting and practice just stop the heritage as we are not shown, meaning some cultural genocide, naruto as hokage could have celebrated each clan's power as culture festival making it show in public like we see chinese,european cultures etc. in many carnival and festival, in this way he could have connected and create harmony and pleasure for these lost heritage clans because naruto was suppose to be a hope that connect people it seems he has forgotten his own theme in boruto cooperation through understanding and sharing pain lol he is not doing that kind of effort to maintain harmony,peace and love among village,clan and outsider instead he is busy in collecting more power and benefit from amado and eida and katasuke and even from kawaki, that's strategic why both kawaki and boruto remained in konoha and not in other village, so much for mutual trust lol.

This is why naruto as a hokage and MC is complete bulshite and loser especially kishimoto's false half baked writing surrounding lack of insight of political atmosphere felt so underserving and hypocritical because i felt so much ideological and behavioral difference between zabusa arc naruto and ending &boruto naruto, really dissapointing.

[tobiasdrake]

Some days are just like.

Database: There is $20,000 in unprocessed cash aged more than a week. Me: We have $20,000 in unprocessed cash aged more than a week. Executives: How much of that is from the lockbox? Me: Database, how much of that is from the lockbox? Database: $16,000 is from the lockbox. Me: $16,000 is from the lockbox. Executives: Thank you. Staff Member: Hey, I tried to do the process but it came out wrong. Me: Database, run the process. Database: Export file was too large. The data had to be reformatted to new parameters. Me: Your file's too big, so the system had to change it. Try running it again but for a narrower criteria. Executives: Hey, is there a way to get this dataset to just show totals for this one vendor? Me: Excel, filter this one vendor. Excel: $3,000 for that one vendor. Me: Here you go. $3,000 for that one vendor. Executives: Perfect, thank you!

[heavenlyyshecomes]

The IDF uses extensive facial recognition with a growing network of cameras and mobile phones to document every Palestinian in the West Bank. Starting in 2019, Israeli soldiers used the Blue Wolf app to capture Palestinian faces, which were then compared to a massive database of images dubbed the “Facebook for Palestinians.” Soldiers were told to compete by taking the most photos of Palestinians and the most prolific would win prizes. The system is most extreme in the city of Hebron, where facial recognition and numerous cameras are used to monitor Palestinians, including at times in their homes, instead of the extreme Jewish settlers living there, who routinely express genocidal threats against the Palestinians. The IDF claimed that the program was designed to “improve the quality of life for the Palestinian population.” […] Blue Wolf was a smaller version of the Wolf Pack database, which contained the personal details of virtually every Palestinian in the West Bank, including educational status, photos, security level, and family history. Soldiers in the West Bank were instructed in 2022 to enter the details and photos of at least fifty Palestinians into the Blue Wolf system every shift and were not allowed to end their shift until they did so. There was no security rationale for these actions. This is a similar set-up to what China does against the Uighurs in its Xinjiang province, using surveillance and technology to both track and intimidate the residents, though Beijing receives far more international condemnation than the Jewish state.

—Antony Loewenstein, The Palestine Laboratory: How Israel Exports the Technology of Occupation Around the World

[copperbadge]

Migrating Off Evernote

Evernote, a web-based notes app, recently introduced super-restrictive controls on free accounts, after laying off a number of staff and introducing AI features, all of which is causing a lot of people to migrate off the platform. I haven't extensively researched alternative sites, so I can't offer a full resource there (readers, feel free to drop your alternative sites in notes or reblogs), but because I have access to OneNote both in my professional and personal life, I decided to migrate my Evernote there.

I use them for very different things -- Evernote I use exclusively as a personal fanfic archive, because it stores fics I want to save privately both as full-text files and as links. OneNote I have traditionally used for professional purposes, mainly for taking meeting notes and storing information I need (excel formulas, how-tos for things I don't do often in our database, etc). But while Evernote had some nicer features it was essentially a OneNote clone, and OneNote has a webclipper, so I've created an account with OneNote specifically to store my old Evernote archive and any incoming fanfic I want to archive in future.

Microsoft discontinued the tool that it offered for migrating Evernote to OneNote directly, but research turned up a reliable and so-far trustworthy independent tool that I wanted to share. You export all your Evernote notebooks as ENEX files, then download the tool and unzip it, open the exe file, and import the ENEX one by one on a computer where you already have the desktop version of OneNote installed. I had no problem with the process, although some folks with older systems might.

I suspect I might need to do some cleanup post-import but some of that is down to how Evernote fucked around with tags a while ago, and so far looking through my notes it appears to have imported formatting, links, art, and other various aspects of each clipped note without a problem. I also suspect that Evernote will not eternally allow free users to export their notebooks so if nothing else I'd back up your notebooks to ENEX or HTML files sooner rather than later.

I know the number of people who were using Free Evernote and have access to OneNote is probably pretty small, but if I found it useful I thought others might too.