More After Hours screen captures.

 

Raw Takes title, and descriptions (from their database)

 

Drum Sesh title, and descriptions (from their database)

 

What did you use to extract?

 

Please beware that am not great at this. I used DB Browser for SQLite Version 3.12.2 an loaded the local.db into it. Please note that if you have not installed certain kits/lines they will not show in local.db. It is working with what you have installed so far. I basically followed instruction given by the member, and opened local.db in this application. Once in there I browsed data just as he instructed. I browsed kits I believe. But I took it a step further and browsed "products", which gives a uid for the kits. I just copied that Uid and used it as a filter, and it showed that specific line. It shows what you see in the screen captures, along with empty colums etc. So I just hid the empty colums from view so it looked like what you see, and I did screen captures. I wanted to make text file or pdf of that specific info but I don't yet know how to do that. The screen captures I did seemed the next best method. If I had .txt, or .pdf of this instead of the pictures you could copy/paste from it into the arcade search. The local.db does indeed include those descriptions, which is what you see. The product id string filtered it to be specific. I don't even remember who showed this in one of the threads on here, but I dug in and got results (somewhat). I will do some screen captures of the next one I filter. It's a standard .db file so google sheets works with it. When i get some time I may try importing local.db into a google sheet where I might have better luck exporting specific filtered info. Hope the screenshots help in the meantime. Maybe some of the more experienced can render some docs including descriptions that we can copy/paste from for searches. It seems that with some good help, our days of endless scrolling to find things is in the past. I haven't had to do that in quite awhile now. There is a new line I want to try this method on that has been posted.

 

I don't remember who and where it was I got this help but it was a member here. I did what they told me to do (and then some).

 

Once open in the app I used the browse data (as instructed). He told me to browse kits, but I got the product id by browsing products.

 

So I am browsing products and next to drum sesh you see the product id string in the uuid column

 

I copied this string. I will go back and browse kits and use this to filter the kits by uuid

 

Going back to borwse kits

 

So I am back in browsing kits and I paste in the uuid into the filter and it shows only Drum Sesh with descriptions and some unwanted colums. At the top of the colums you can hide the column from view. I clicked the name column and it alphabetized it, and I ended up with what you see in the screen captures. if you do this in your app you can copy/paste the titles into arcade and you will know what's coming from their descriptions.

 

Thanks the info. Looking to see if everything did install correctly

 

I have found one or 2 kits that did not come up when I tried to load them. The vast majority do come up, so I didn't bother asking to compare. Most work. More than enough that does work so I am not concerned about 1 or 2 that come up empty/error.

 

The newest posted Brainwaves.

A Distant Memory Boomy metallic beats with tape loop FX and floaty synth.
Recommended 60 - 100 BPM
Aberration Hits of modulating, overblown feedback with catlike octaves.
Ancient Clouds Dark clav tones beneath echoes from an airy, warbling moan.
Aquatic Afterlife Jerking beats with blurry synth, keys, and wacky ear candy.
Recommended 70 - 100 BPM
Astound Blistering noise swells within bright, formidable sustains.
Augmentor Three resonant LFO layers form a teetering hypnosis drone.
Balloon Parade Faint lows wobble under bright, whistle-layered sustains.
Behold Drippy synth and keys with funk guitars and fuzzy basslines.
Recommended 70 - 105 BPM
Caffeine Nap Metallic perc, weird guitar, plucks, dark synth, and vox FX.
Recommended 80 - 115 BPM
Celestia Chilly, spacious hits introduce saturated, humming sustains.
Cerulean Hyped beats push euphoric synth, glitch FX, and coin sounds.
Recommended 65 - 95 BPM
Collapsing Sky Deep, futuristic synth and FX float above driving grooves.
Recommended 70 - 110 BPM
Condor Bass Deep, growling sustain with ominous pitch modulation.
Cosmic Relaxation Soft buzz synth begins with ringing cutoff automation.
Dangerous Method Dreamy vox, keys, strings, noise FX, and skipping beats.
Recommended 65 - 95 BPM
Deeper Connection Forest atmosphere over thrumming mid-range synth sustain.
Dirtbath Filtered singing bowl taps with wavering, unnatural sustain.
Dirty Womp Big, blown out synth bass sustains throbbing in warm noise.
Ditchdigger Headbang lo-fi elements with noisy FX and grunge guitars.
Recommended 85 - 115 BPM
Dream in Reverse Starlight keys, FX, and ambient pads wash over pillowy bass.
Recommended 115 - 145 BPM
Fading Wisp Moody bass, guitar, vox, and leads climb bright synth arps.
Recommended 105 - 135 BPM
Frozen in Time Warped pads, sidechain lows, VHS leads, and textural layers.
Recommended 95 - 125 BPM
Gray Matter Curious synth and keys meet buzzing noise and punchy beats.
Recommended 75 - 105 BPM
Green Tea A subtle buzz swells into round one-shots with soft noise.
Hotspot Warm, dry plucks with soft attack and overblown harmonics.
Hybridized Chords and pumping FX shift around wobbling synth scratches.
Recommended 75 - 115 BPM
Hyperaware Two synth chords welcome pulsing elements and jam guitar.
Recommended 65 - 100 BPM
Inferno Bright leads and FX spill over magma pads and rushed beats.
Recommended 65 - 105 BPM
Infinite Window Muddy lows, tarnished guitar, ambient synth, and warped vox.
Recommended 125 - 165 BPM
Invisible Man Alluring beats, lush pads, funky bass, vox, and weird leads.
Recommended 70 - 100 BPM
Lava Stream Flutter textures and waves of live-wire synth fade in turn.
Loosely Locked Shimmering synth and glitchy FX driven by lopsided beats.
Recommended 70 - 100 BPM
Mind Massage Soothing synths, guitar, jazz bass, keys, "hey" vox, and FX.
Recommended 70 - 100 BPM
Misplaced Organ Low, breathy layers under dusty keys have endless release.
Moonlit Waves River sounds layer dull synth drones with subtle modulation.
Nano Circuitry Swell into blazing synth sustains with satisfying phase FX.
Native Habitat Watery synth and FX surround chill beats and distorted subs.
Recommended 70 - 100 BPM
Nebula Mirage Dark, echoing taps trigger airy pads with stereo image FX.
Neural Storm Spectral hits introduce calm strings and crackling textures.
Neuron Ninja Dulcimer and harsh bell leads meet mean subs, drums, and FX.
Recommended 75 - 105 BPM
Panophobia Haunting synth and guitar over tremolo vox and angry lows.
Recommended 120 - 155 BPM
Prism Shatter Retro keys tones trigger a single, crystal clear reflection.
Rapid Eye Movement Leads and FX sparkle through hazy chords and spatial beats.
Recommended 65 - 95 BPM
Recorded Dreams Harsh crumpled paper textures layer ominous ocarina pads.
Salvation Snipping textures permeate wide and lush ambient synth pads.
Sedated Flare Retro synth brass swells with soft, percussive attack.
Semiserious Bitter lows under dreamy pads, lo-fi synth, and ambient vox.
Recommended 90 - 125 BPM
Siren Sub Candle sounds heat rubber subs with low sustain and mad FX.
Soda Sub Fizzy bubbles texturize massive triangle sub sustains.
Space Dust Muted sine plucks with delayed piano key hit and squish FX.
Spells Awaken Hold obscure, vocoder-layered clav sustains to add release.
Static Fatigue Hollow, whistling leads with buzzing layers and hard attack.
Still Waters Crackling textures surround spectral synth brass fifths.
The Multiverse Ambient pads and chaos FX meet glitchy drums and glide sub.
Recommended 60 - 100 BPM
Through Worlds Glowing arps, saws, guitar, and warped vox on steady beats.
Recommended 140 - 175 BPM
Untouched Add noise and squelch layers to ringing ear sustains.
Venus Flytrap Moody synths and guitars float along with creepy vox and FX.
Recommended 75 - 105 BPM
Whisked Away Untamed FX obscures pad swells, blurry leads, and subs.
Recommended 110 - 145 BPM
Wishing Well Hustling beats with bass guitar, roomy keys, and sci-fi FX.
Recommended 80 - 110 BPM
Zero Gravity Aggressive beats propel weightless rhythmic pads and FX.
Recommended 85 - 110 BPM

 

name description (Sazon)
Ay Bendito!
Rolling staccato trumpet rhythms invite you to salsa.
Recommended 90 - 120 BPM
Bajale Dos
Two-chord ostinato progressions of Puerto Rican trumpets.
Recommended 100 - 130 BPM
El Bongosero
Driving bongo grooves and fills in a reverberant space.
Recommended 60 - 90 BPM
Reloj de Arena
Eighth-note three-beats of Afro-Cuban Bata drum.
Recommended 150 - 180 BPM
En La Placita
Stabbing salsa piano over mixed percussion clave rhythms.
Recommended 70 - 110 BPM
Vamos al Mambo
Bass and perc form an implied pulse for lively piano leads.
Recommended 90 - 110 BPM
Cmo Se Baila
Classy bass and piano interplay over flowing drums and perc.
Recommended 110 - 140 BPM
Puro Sabor
Swaying merengue grooves with piano, bass, and lush perc.
Recommended 120 - 140 BPM
La Cumbiamba
Guitar and piano upbeats play off conga and bass grooves.
Recommended 80 - 110 BPM
De La Guajira
Accordion complements hand-strummed guitar and conga.
Recommended 90 - 120 BPM
Verano en Santiago
A lovely bouquet of elegant guitars and rolling percussives.
Recommended 80 - 110 BPM
1968
Venezuelan new wave drums, guitar, and piano play in six.
Recommended 150 - 190 BPM
Down de Islands
Un para
so de upbeat calypso drums, perc, bass, and cuatro.
Recommended 120 - 140 BPM
Una Vueltita
Stomp along to forceful and captivating joropo rhythms.
Recommended 120 - 150 BPM
Desde La Montaa
Stabbing rhythms of squashed piano chords and bass notes.
Recommended 110 - 130 BPM
Sambistas
A surdo drum beats beneath thin samba guitars and tamborim.
Recommended 120 - 140 BPM
Dame Un Break
Carefree piano and bass overlay boomy plena drums and perc.
Recommended 100 - 130 BPM
Cinco por Ocho
Winding five-beat grooves of piano, cuatro, bass, and drums.
Recommended 140 - 160 BPM
Coquito
A parranda celebration of syncopated kick, bass, and guitar.
Recommended 120 - 150 BPM
Repeticin
Samba bass enjoys assorted snare patterns and reversed perc.
Recommended 110 - 130 BPM
Chilea
Pop instrumentals over tonal kicks, rainstick, and pandeiro.
Recommended 80 - 100 BPM
Buena Onda
Subs, synths, organs, and guitars riff on pounding beats.
Recommended 80 - 110 BPM
Nostlgico
Wistful classical guitar flows to grooving bolero strings.
Recommended 90 - 110 BPM
Buenas Tardes
Natural guitar and gentle synth over a deep, layered pulse.
Recommended 70 - 90 BPM
Miti Miti
Poppy cumbia beats with atmosphere and squelching synth.
Recommended 90 - 110 BPM
Ra ces
Reggae drum and bass meet happy synth and skank guitars.
Recommended 80 - 90 BPM
Azuquita
Bomba sica trumpet stabs and legato leads dictate rhythm.
Recommended 90 - 120 BPM
El Jibarito
Poetic, relaxed cuatro melodies overlay hand drum and guiro.
Recommended 150 - 170 BPM
Jangueo
Guitar and piano syncopations bounce to reggaeton rhythms.
Recommended 80 - 110 BPM
Mucho Gusto
Guiro leads a formal dance of pleasant Puerto Rican guitars.
Recommended 130 - 160 BPM
Los Viejos Tiempos
Fun perc rhythms and complex guitars for the holiday season.
Recommended 90 - 110 BPM
Puerta de Oro
Piano and synth chords add melody to sub-heavy cumbia beats.
Recommended 170 - 200 BPM
Pa la Playa
Summertime synths over tubular lows and clean, poppy perc.
Recommended 80 - 100 BPM
Suavecito
Lento grooves welcome drippy synths, sub plucks, and vox FX.
Recommended 150 - 180 BPM
Repiqueteo
Repeater snare and deep house synth add to lush percussives.
Recommended 100 - 130 BPM
Activo
Sky high leads and syncopated synths bounce to baller beats.
Recommended 90 - 110 BPM
Sal y Pimienta
Dreamy synth plucks surround rolling beats with trash claps.
Recommended 100 - 120 BPM
Nos Fuimos
Lush melodics and funky bass march to pop electro beats.
Recommended 90 - 120 BPM
Amalgamar
Rocking reggaeton grooves of tasty guitar, synth, and bass.
Recommended 80 - 100 BPM
Clmate
Plucky synth leads and silky pads overlay punchy pop beats.
Recommended 100 - 120 BPM
Gran Chico Quick and dirty sub swells with macros for extra sauce.
Tapas Little knocks made from bowls and mallets with space FX.
Demasiado Bajo Fat, baffled sub kicks breathe, thanks to layered space.
Az
car
Dry, dulcet muted gong hits coated in a breathy texture.
Atardecer Narrow reeds and mellow keys layers fade elegantly.
Corto Plazo Light sub plucks topped with spacious violin and xylophone.
Encantamiento Pulsations of faint piano lost within claustrophobic noise.
La Fiesta Ponging delay rhythms trail meaty plucks with gamelan.
Pintoresco Violin plucks layered with low sines and muted string slaps.
El Primer Baile Tube guitar tones add depth to buzzing clavinet plucks.
Piano Pequeo Piano stabs housed within a warped synth shell.
Aguas Frescas Add flute pads to popcorn plucks with responsive release.
Quebrando Oro Blistering synth bass tidal waves rush in sudden swells.
D janos Bailar
Tweakable trumpet ensemble sustains or brass synth plucks.
En el Aire Talking sweeps glide to each quacking note of angelic organ.
Sonidos Clidos Hairy, roomy plucks with triplet delay and lo-fi FX.
Recuerdos Quiet, morphing synth brass with a tremolo surprise.
Conseguir Plata Mallets smack fibrous xylophones with a metallic finish.
Vibras de Verano Pluck these bowl-layered, bouncy synths low or high.
El Clsico Bowl bottom and kalimba top accentuate marimba mallets.

 

I have had some success with copying just the titles and descriptions from the database, and inserting it directly into my html editor with the columns in tact as tables. I need to find a way to convert to pdf.

Ok I got this down to a science now I guess. I will start at the top and up pdfs so you all can copy/paste out of them into arcade. It's much better than the screen capture method.

 

Last edited: Nov 17, 2021

Sazon titles and descriptions.

 

Hooked

 

After Hours

 

I had the best success editing the database file. You start by copying all table columns to an excel spreadsheet from the DB viewer, assigning an individual number per kit (e.g. k01, k02) and an individual number per preset WITHIN a kit. Once you have that I renamed every entry to kit number + kit name (HKD for hooked e.g.) + individual name + preset name.
After that you sort all table rows by kit number and then you assign ID numbers to all entries. Copy that back to the database file. Save. Done.

Then in Arcade you can simply search for "k01" and it will give you all presets of that kit. Or you can type (001) which will display the first preset of every kit. Total win. No juggling around with PDFs or whatever.

I had it all sorted in about 2 hours. A worthwile investment of my time.

What helped me be faster
1. Formular to maintain same number as long as kit name (or product id) is identical. This is to assign the same number for all files within the same kit
=WENN(E51=E52;F51;F51+1)

2. Formular to increase the filenumber starting at 1 until reaching the end of a package. Then starting again at 1. (To assign individual number WITHIN a kit)
=WENN(F51<>F52;1;G51+1)

3. use an expressions to build the final file name from all data entries over multiple columns
=[@package]&" - "&[@name]&" ["&[@noinside]&"] - "&"(K"&[@packageno]&")"&" "
becomes: HKD - Forgot Valentine's Day [74] - (K19)

 

Last edited: Nov 17, 2021