Jump to content


Photo

how can i keep track of what bpal i've tried?


  • Please log in to reply
603 replies to this topic

#1 Belladonnastrap

Belladonnastrap

    Shake your coconuts GO GO GO

  • Moderators
  • 10,501 posts
  • Mood:Opulent
  • SotD:Snow, Glass, Apples
  • Ram
  • Virgo
  • United States

Posted 06 June 2004 - 12:32 AM

Hi everyone!

I'm extremely pressed for time and do not have the time to figure out my new spreadsheet software so I was wondering if anyone here has all of the oils with their descriptions (including the new ones) in a file and if you do could you perhaps send to me? I would love to re-read and savour it while on my long flight on Wednesday. If you do just fire off a PM and I'll recieve it...thanks so much!

(posted in BPAL chatter but if it belongs in randomness you can just move it...I wasn't sure where to put it! :P )

#2 jj_j

jj_j

    obsessive precious hoarder

  • Members
  • 1,665 posts
  • Mood:hopeful
  • SotD:Embalming Fluid
  • Tiger
  • Scorpio
  • United States

Posted 06 June 2004 - 12:36 AM

Mine doesn't have descriptions, or you'd be welcome to it. It's on my to-do list when I actually have a half-day to do it in. :D

Besides, you don't want my comments on how they smell on me. :P


#3 ViolentKitten

ViolentKitten

    obsessive precious hoarder

  • Members
  • 1,047 posts
  • Mood:wired
  • SotD:Velvet Unicorn
  • Pig
  • Taurus
  • Australia

Posted 06 June 2004 - 01:19 AM

What? Nooooo. I don't do crazy obsessed things like that. :P Will PM you!

#4 quantum spice

quantum spice

    web goddess

  • Members
  • 17,227 posts
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 03:33 AM

i can make a csv file (comma deliminated text file that excel likes) from the database, if you'd like.

#5 Amber

Amber

    evil enabler

  • Members
  • 444 posts
  • Mood:tired
  • SotD:Regan
  • Rooster
  • Aries
  • United States

Posted 06 June 2004 - 03:50 AM

Karyn, I have mine (with descriptions), but you said you didn't have Excel... :S

And it doesn't have the updates yet... ^^

#6 quantum spice

quantum spice

    web goddess

  • Members
  • 17,227 posts
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 04:23 AM

this is the current perfumes listing. so sayeth the search engine, anyways :P

#7 shriekingviolet

shriekingviolet

    On Hiatus

  • Moderator Emeritus
  • 12,611 posts
  • Mood:exhausted
  • SotD:Haunted Palace
  • Rooster
  • Scorpio
  • United States

Posted 06 June 2004 - 04:27 AM

I can email you mine karyn. I'm not sure what software you use, so I'll export it as a pdf.

#8 TygherRayn

TygherRayn

    1/32 too few

  • Members
  • 3,480 posts
  • Mood:predatory
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 05:15 AM

Oooh .. can I get in on that action? I like my database, but I want in in a spreadsheet, and I'm too lustrated to mess around enough to transfer it all.

#9 quantum spice

quantum spice

    web goddess

  • Members
  • 17,227 posts
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 05:23 AM

if you're using access, you should be able to export a table or query into a spreadsheet.

#10 TygherRayn

TygherRayn

    1/32 too few

  • Members
  • 3,480 posts
  • Mood:predatory
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 05:25 AM

*ponders* It's been entirely too long since I've played with Access then, cos I couldn't remember how.. I'll have to find that then. Thanks!

*hugs*

#11 quantum spice

quantum spice

    web goddess

  • Members
  • 17,227 posts
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 05:37 AM

highlight the table/query you want to export into a spreadsheet, go to file -> export, and scroll down to excel.

you should be able to link the spreasheet to info in the database directly, so it's always in sync.

#12 TygherRayn

TygherRayn

    1/32 too few

  • Members
  • 3,480 posts
  • Mood:predatory
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 05:55 AM

You rock. Thank you.

#13 clephan

clephan

    A mystery of spooks

  • Moderator Emeritus
  • 4,386 posts
  • Mood:lonely
  • SotD:Blackberry jam and scones
  • Snake
  • Pisces
  • United Kingdom

Posted 06 June 2004 - 07:25 AM

426 items?! Whee!

Many thanks for the CSV :P

#14 Ina Garten Davita

Ina Garten Davita

    Ebola Peach

  • Moderators
  • 18,040 posts
  • Mood:enraged and musky
  • Nothing Selected
  • Virgo
  • United States

Posted 06 June 2004 - 02:53 PM

That is awesome. I just imported into my already compulsively maintianed comprehensive spreadsheet. I've truly lost it!

#15 Belladonnastrap

Belladonnastrap

    Shake your coconuts GO GO GO

  • Moderators
  • 10,501 posts
  • Mood:Opulent
  • SotD:Snow, Glass, Apples
  • Ram
  • Virgo
  • United States

Posted 07 June 2004 - 12:38 AM

You guys. ROCK.

Thanks SO much for all your replies and help. I love this damn board :P

#16 ViolentKitten

ViolentKitten

    obsessive precious hoarder

  • Members
  • 1,047 posts
  • Mood:wired
  • SotD:Velvet Unicorn
  • Pig
  • Taurus
  • Australia

Posted 07 June 2004 - 12:54 AM

Yippee! I'm so glad it worked! Have a great trip and fun reading!!!

#17 foolssilver

foolssilver

    lil stinker

  • Members
  • 85 posts
  • Mood:geeky
  • Nothing Selected
  • Aquarius
  • United States

Posted 09 June 2004 - 07:47 PM

quantumspice: thank you!

i am SO happy to have it all in excel so speedily! i was NOT looking foward to updating my old spreadsheet, and yours is in a better format anyway. now to work on trying them ALL!

(ps. i borrowed some imps from ladylatemar, and i saw your name on the tag, and i was all, "oh, this used to belong to quantumspice!")

#18 quantum spice

quantum spice

    web goddess

  • Members
  • 17,227 posts
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 09 June 2004 - 07:50 PM

the csv, btw, is out of date as of yesterday.

#19 Ina Garten Davita

Ina Garten Davita

    Ebola Peach

  • Moderators
  • 18,040 posts
  • Mood:enraged and musky
  • Nothing Selected
  • Virgo
  • United States

Posted 10 June 2004 - 07:53 PM

Though I went through it with a fine toothed comb, if there are any errors, please let me know.

thanks!

#20 Sistinas

Sistinas

    diabolical decanter

  • Members
  • 942 posts
  • Mood:shy
  • SotD:Aunt Caroline's Joy Mojo
  • Horse
  • Cancer
  • United States

Posted 10 June 2004 - 09:26 PM

I made myself a simple spreadsheet using open-office but I would really like one with the descriptions et al. I am not too savy with databases and spreadsheets and tried to import the csv to open office but had no success. If anyone would be willing to give me help with using quantum spice's csv, I would appreciate it.

#21 shriekingviolet

shriekingviolet

    On Hiatus

  • Moderator Emeritus
  • 12,611 posts
  • Mood:exhausted
  • SotD:Haunted Palace
  • Rooster
  • Scorpio
  • United States

Posted 10 June 2004 - 10:01 PM

Sistinas, I use open office and would happy to just send you a copy of mine. AFAIK it's up to date.

#22 quantum spice

quantum spice

    web goddess

  • Members
  • 17,227 posts
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 10 June 2004 - 10:52 PM

it's probably because i imported/exported it with ms office to get rid of fields people don't need to see.

what's there right now is up-to-date, and has the exact output from the database's csv export function. (which does work in openoffice, since that's all i have on the laptop i'm using for the summer - and if i remember, i'll go through and take out the extra fields tomorrow)

#23 Sistinas

Sistinas

    diabolical decanter

  • Members
  • 942 posts
  • Mood:shy
  • SotD:Aunt Caroline's Joy Mojo
  • Horse
  • Cancer
  • United States

Posted 10 June 2004 - 11:14 PM

Thank you for the replies. Belladonastrap said it well, You all Rock, this is a great board to be a part of.

#24 MissAnthropy

MissAnthropy

    obsessive precious hoarder

  • Banned
  • 1,726 posts
  • Mood:accomplished
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 04 July 2004 - 11:46 PM

If there's an updated version of the spreadsheet available, I'd LOVE to get a copy! Can someone help me out? :P


-Leslie

#25 quantum spice

quantum spice

    web goddess

  • Members
  • 17,227 posts
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 05 July 2004 - 01:08 AM

updated => csv, xls

as a warning, the xls does have a macro, but you can disable it. it does three things: replaces NULL with nothing, fixes the case for the name & area, and creates links from the number in hte review id.

i don't remember if it has ingenue in it, but it does have hemlock + some of the up&comings + the rest of the lunacy series.


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users