Shopping List Question

All Site Suggestions or General Black Friday Tips

Moderators: Tony, cematra173, killasnake, Huy

User avatar
buynstuff4fun
Black Friday Pro
Posts: 124
Joined: Tue Sep 07, 2010 8:21 am

Shopping List Question

Postby buynstuff4fun » Sat Nov 17, 2012 10:09 am

Sorry if this is a repeat (I searched the boards but couldn't find anything).

Is there a way to download the bfads.net shopping list into Excel? I know I can use the mobile app on my cell, but I'm a little nervous about getting my cell phone in and out in every store, and potentially setting it down during the mayhem. I would love to cross items off a list. I know I can print it as-is, but I would love to be able to sort too. If anyone has figured out how to do this, can you let me know?

Thanks in advance for your help!

User avatar
jeanerz13
Black Friday Pro
Posts: 1756
Joined: Fri Oct 15, 2010 10:42 pm
Location: Missouri

Re: Shopping List Question

Postby jeanerz13 » Sat Nov 17, 2012 12:58 pm

There's a button for "view printable list" Is there a reason it needs to be excel instead of the printable list they provide?

Edit: Just re-read... you need to sort ;) Reading comprehension fail on my part

barbd00
Black Friday Pro
Posts: 108
Joined: Sat Nov 13, 2010 2:09 pm

Re: Shopping List Question

Postby barbd00 » Sat Nov 17, 2012 1:11 pm

If you email it to yourself, you'll be able to copy-paste. I was hoping it was tabbed and therefore separated everything into cells, but it doesn't. Each line is in one cell. It's not the best, but it might work.

User avatar
buynstuff4fun
Black Friday Pro
Posts: 124
Joined: Tue Sep 07, 2010 8:21 am

Re: Shopping List Question

Postby buynstuff4fun » Sat Nov 17, 2012 2:27 pm

Okay - thanks everyone!

User avatar
Shopper X
Suspected Line Jumper
Posts: 2646
Joined: Wed Nov 16, 2005 6:05 pm

Re: Shopping List Question

Postby Shopper X » Sat Nov 17, 2012 3:45 pm

Is this something that people would find useful? I could try writing a CGI script that converts the shopping list to a CSV spreadsheet.

User avatar
jeanerz13
Black Friday Pro
Posts: 1756
Joined: Fri Oct 15, 2010 10:42 pm
Location: Missouri

Re: Shopping List Question

Postby jeanerz13 » Sat Nov 17, 2012 3:59 pm

Shopper X wrote:Is this something that people would find useful? I could try writing a CGI script that converts the shopping list to a CSV spreadsheet.


lol I thought you could since you do a full spreadsheet for all items and almost posted a suggestion to that effect but thought it wouldn't be too nice to volunteer work for you :P

I actually make my own spreadsheet in google docs. I like having a separate sheet for each store and I have sections for item, price, and personal notes. Normally I don't even bother with the shopping list though I am this year to see if it helps me compare the same item side by side to see which store I should go to. Short answer is I think I might use it as a starting point (probably not this year since I have my spreadsheet already put together) but I would still have to mess with the data to get it organized the way I like. But I'm just one opinion :)

User avatar
Shopper X
Suspected Line Jumper
Posts: 2646
Joined: Wed Nov 16, 2005 6:05 pm

Re: Shopping List Question

Postby Shopper X » Sun Nov 18, 2012 1:48 am

The online utility that converts BFAds.net shopping lists to CSV spreadsheet is ready for testing. Please let me know if there are any problems or if it doesn't work for you.

I've only used the shopping list function without logging into BFAds.net. I don't know if it appears or behaves differently if you log in. If it does, then the utility might not work without a bit more fixing.

FYI, there's a behavior in the BFAds.net shopping list such that category headings are not printed when the first items for a new store are not in a different category as the last items in the previous store. This turns into a bug in the utility if an item has no category in the BFAds database. (There are only a few items like this. See the first item in the Sam's Club ad listings for an example.) These no-category items will inherit the previous, probably incorrect, category in the spreadsheet.

User avatar
jeanerz13
Black Friday Pro
Posts: 1756
Joined: Fri Oct 15, 2010 10:42 pm
Location: Missouri

Re: Shopping List Question

Postby jeanerz13 » Sun Nov 18, 2012 11:29 am

good job!

User avatar
steffj89
Black Friday Pro
Posts: 4288
Joined: Mon Oct 22, 2007 11:52 pm
Location: OK
Contact:

Re: Shopping List Question

Postby steffj89 » Sun Nov 18, 2012 12:33 pm

how does it work? sorry, i am a bit of an idiot about this stuff....
www.myinitials-inc.com/steffsbags/
steffsbags@ymail.com
Because there's only one You!!

User avatar
Shopper X
Suspected Line Jumper
Posts: 2646
Joined: Wed Nov 16, 2005 6:05 pm

Re: Shopping List Question

Postby Shopper X » Sun Nov 18, 2012 12:36 pm

steffj89 wrote:how does it work? sorry, i am a bit of an idiot about this stuff....

Are you asking, "how do you use it?" Or, are you asking how the script works on a more technical level?

User avatar
jeanerz13
Black Friday Pro
Posts: 1756
Joined: Fri Oct 15, 2010 10:42 pm
Location: Missouri

Re: Shopping List Question

Postby jeanerz13 » Sun Nov 18, 2012 12:40 pm

1. Open the link Shopper X provided in a new tab or window
2. Go to your BFAds Shopping List
3. Right click
4. Choose "View Source" (this text may vary by browser)
5. Select all the text (you can do this easily by pressing Ctrl + A)
6. Go to the tab/window with the Shopper X's link
7. Paste what you copied into the big text box (you can do this easily by pressing Ctrl + V)
8. Click the "Convert it" button
9. At the top of the page there will be list of your items. Each column is separated by commas. You can copy this into notepad or whatever and save it as a .csv file (for instance save it as list.csv) Close it in notepad and then you should be able to open it with Excel.

User avatar
steffj89
Black Friday Pro
Posts: 4288
Joined: Mon Oct 22, 2007 11:52 pm
Location: OK
Contact:

Re: Shopping List Question

Postby steffj89 » Sun Nov 18, 2012 1:09 pm

ok....not sure I have notepad...i have word starter 2010....
www.myinitials-inc.com/steffsbags/
steffsbags@ymail.com
Because there's only one You!!

User avatar
teknoge3k
Forum geek
Posts: 10808
Joined: Tue Oct 07, 2008 9:57 am
Location: Virginia
Contact:

Re: Shopping List Question

Postby teknoge3k » Sun Nov 18, 2012 1:12 pm

steffj89 wrote:ok....not sure I have notepad...i have word starter 2010....


Notepad comes with Windows. ;) It's under accessories or you can start / run / "notepad" (without the quotes)
That moment you realize that Bruce Jenner is Kanye Wests' mother in-law

facebook.com/teknoge3k
twitter.com/teknoge3k

User avatar
steffj89
Black Friday Pro
Posts: 4288
Joined: Mon Oct 22, 2007 11:52 pm
Location: OK
Contact:

Re: Shopping List Question

Postby steffj89 » Sun Nov 18, 2012 1:20 pm

not a feature i use much huh?
LOL

Thanks TEK
www.myinitials-inc.com/steffsbags/
steffsbags@ymail.com
Because there's only one You!!


Return to “Suggestions and Tips”

Who is online

Users browsing this forum: No registered users and 2 guests