BPAL Madness!: how can i keep track of what bpal i've tried? - BPAL Madness!

Jump to content

  • 24 Pages +
  • 1
  • 2
  • 3
  • Last »
  • You cannot start a new topic
  • You cannot reply to this topic

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

#1 User is offline   Belladonnastrap 

  • IT IS KNOWN...I ride a BPALunicorn
  • View gallery
  • Group: Moderators
  • Posts: 10,469
  • Joined: 16-January 04
  • 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 )
  • to the top!

#2 User is offline   jj_j 

  • obsessive precious hoarder
  • Group: Members
  • Posts: 1,665
  • Joined: 17-January 04
  • 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

  • to the top!

#3 User is offline   ViolentKitten 

  • obsessive precious hoarder
  • Group: Members
  • Posts: 1,047
  • Joined: 09-February 04
  • 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!
  • to the top!

#4 User is offline   quantum spice 

  • web goddess
  • View gallery
  • Group: Members
  • Posts: 17,227
  • Joined: 17-January 04
  • 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.
  • to the top!

#5 User is offline   Amber 

  • evil enabler
  • Group: Members
  • Posts: 444
  • Joined: 26-February 04
  • 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... ^^
  • to the top!

#6 User is offline   quantum spice 

  • web goddess
  • View gallery
  • Group: Members
  • Posts: 17,227
  • Joined: 17-January 04
  • 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
  • to the top!

#7 User is offline   shriekingviolet 

  • Totally Outraged
  • View gallery
  • Group: Administrator
  • Posts: 12,611
  • Joined: 16-January 04
  • 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.
  • to the top!

#8 User is offline   TygherRayn 

  • 1/32 too few
  • Group: Members
  • Posts: 3,480
  • Joined: 03-April 04
  • 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.
  • to the top!

#9 User is offline   quantum spice 

  • web goddess
  • View gallery
  • Group: Members
  • Posts: 17,227
  • Joined: 17-January 04
  • 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.
  • to the top!

#10 User is offline   TygherRayn 

  • 1/32 too few
  • Group: Members
  • Posts: 3,480
  • Joined: 03-April 04
  • 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*
  • to the top!

#11 User is offline   quantum spice 

  • web goddess
  • View gallery
  • Group: Members
  • Posts: 17,227
  • Joined: 17-January 04
  • 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.
  • to the top!

#12 User is offline   TygherRayn 

  • 1/32 too few
  • Group: Members
  • Posts: 3,480
  • Joined: 03-April 04
  • Mood:predatory
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 06 June 2004 - 05:55 AM

You rock. Thank you.
  • to the top!

#13 User is offline   clephan 

  • A mystery of spooks
  • View gallery
  • Group: Moderator Emeritus
  • Posts: 4,386
  • Joined: 16-January 04
  • 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
  • to the top!

#14 User is offline   Andra 

  • WHITE DEMON FIRE
  • View gallery
  • Group: Moderators
  • Posts: 17,935
  • Joined: 21-March 04
  • Mood:enraged and musky
  • SotD:Testing Weenies
  • 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!
  • to the top!

#15 User is offline   Belladonnastrap 

  • IT IS KNOWN...I ride a BPALunicorn
  • View gallery
  • Group: Moderators
  • Posts: 10,469
  • Joined: 16-January 04
  • 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
  • to the top!

#16 User is offline   ViolentKitten 

  • obsessive precious hoarder
  • Group: Members
  • Posts: 1,047
  • Joined: 09-February 04
  • 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!!!
  • to the top!

#17 User is offline   foolssilver 

  • lil stinker
  • Group: Members
  • Posts: 85
  • Joined: 16-January 04
  • 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!")
  • to the top!

#18 User is offline   quantum spice 

  • web goddess
  • View gallery
  • Group: Members
  • Posts: 17,227
  • Joined: 17-January 04
  • Mood::(
  • Nothing Selected
  • Nothing Selected
  • Nothing Selected

Posted 09 June 2004 - 07:50 PM

the csv, btw, is out of date as of yesterday.
  • to the top!

#19 User is offline   Andra 

  • WHITE DEMON FIRE
  • View gallery
  • Group: Moderators
  • Posts: 17,935
  • Joined: 21-March 04
  • Mood:enraged and musky
  • SotD:Testing Weenies
  • 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!
  • to the top!

#20 User is offline   Sistinas 

  • diabolical decanter
  • Group: Members
  • Posts: 942
  • Joined: 20-February 04
  • 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.
  • to the top!

#21 User is offline   shriekingviolet 

  • Totally Outraged
  • View gallery
  • Group: Administrator
  • Posts: 12,611
  • Joined: 16-January 04
  • 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.
  • to the top!

#22 User is offline   quantum spice 

  • web goddess
  • View gallery
  • Group: Members
  • Posts: 17,227
  • Joined: 17-January 04
  • 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)
  • to the top!

#23 User is offline   Sistinas 

  • diabolical decanter
  • Group: Members
  • Posts: 942
  • Joined: 20-February 04
  • 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.
  • to the top!

#24 User is offline   MissAnthropy 

  • obsessive precious hoarder
  • Group: Banned
  • Posts: 1,726
  • Joined: 09-April 04
  • 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
  • to the top!

#25 User is offline   quantum spice 

  • web goddess
  • View gallery
  • Group: Members
  • Posts: 17,227
  • Joined: 17-January 04
  • 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.
  • to the top!



  • 24 Pages +
  • 1
  • 2
  • 3
  • Last »
  • You cannot start a new topic
  • You cannot reply to this topic





1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users