Is it possible to export your previous smokes inventory to Excel like the other humidors? :-)
Tried that one to no avail. Do not think it is possible but would love it if it was
QuoteLonghorn - 7/2/2013 4:31 PM
Is it possible to export your previous smokes inventory to Excel like the other humidors? :-)
That would be really nice.
No reason why you can't copy and paste all that mess......... there's actually not too much to clean up even........
With 890 cigars in my previous smoked already, I seriously doubt I will be doing so.........
QuoteVroomp - 7/3/2013 12:32 PM
No reason why you can't copy and paste all that mess......... there's actually not too much to clean up even........
With 890 cigars in my previous smoked already, I seriously doubt I will be doing so.........
Yes you can simply copy and paste it. Make sure you are only selecting the data, copy then select the upper left cell and paste and it will automatically put it into a table for you.
Your computer has a virus, it's called windows!
QuoteVroomp - 7/3/2013 2:32 PM
No reason why you can't copy and paste all that mess......... there's actually not too much to clean up even
That's what I do now, but with 16 pages of previous smokes, it is a chore....
OK - the copy/paste works, but how hard would it be to append the download file to include the previous smokes?
:bump:
QuoteLonghorn - 7/8/2013 6:49 PM OK - the copy/paste works, but how hard would it be to append the download file to include the previous smokes? :bump:
Shouldn't be too difficult, although I'd rather see them as separate download functions rather than combining them to a single spreadsheet.
You could also set up a spreadsheet to automatically import the data.
Just click Data > Import From Web...
Enter the following address:
http://www.cigargeeks.com/humidor/default.asp?action=&page=1&set=prev
A new window will open up...
(https://lh3.googleusercontent.com/-EaDf8p3N-A8/UdtiaEPv7xI/AAAAAAAAHP8/CADJthTHz38/s800/DIExcel.png)
Click the yellow arrow next to the table (it will turn green), and click import. Select the starting cell to import too (default for the first page should be A1).
If you want you can have the spreadsheet reload all data from the web site every time you open it...
(https://lh4.googleusercontent.com/-WFtVEqtAYJ8/UdtkUGIk6WI/AAAAAAAAHQY/neVatyiITMQ/s800/DIRef.png)
...but I actually prefer to load external data manually by clicking Data > Refresh All
To load subsequent pages, go to the next empty row below what you just imported, and repeat the process with the following link...
http://www.cigargeeks.com/humidor/default.asp?action=&page=2&set=prev
(Notice the bolded.)
Not as simple as being able to export all at once from the site, but once you get it set up, it is simple to refresh the data.
QuoteTed - 7/8/2013 7:20 PM
once you get it set up, it is simple to refresh the data.
YA all that stuff he just said :smoker:
:-)
I'm guessing the admin could more easily copy the export function from the current inventory to the previous. That or allow the user to set "pageSize=" in the request for a single Excel query.
Thanks, Ted.
Hey guys. This wouldn't be too much work (i'm pretty sure at first glance.) I'm heading out of town for the next 5 days, but i'll try to take a look at it when I get back.
-Paul
QuoteSenorPablo - 7/8/2013 11:07 PM
Hey guys. This wouldn't be too much work (i'm pretty sure at first glance.) I'm heading out of town for the next 5 days, but i'll try to take a look at it when I get back.
-Paul
Thanks Paul.
Oh, and thanks Ted for the tips on getting the tables.
QuoteSenorPablo - 7/8/2013 9:07 PM Hey guys. This wouldn't be too much work (i'm pretty sure at first glance.) I'm heading out of town for the next 5 days, but i'll try to take a look at it when I get back. -Paul
Very cool, thanks!
Awesome!
Export feature is up and running! Thanks!
Is there anyway we can get the notes to export as well?
Also, sort of on topic, but is there any way to allow users to customize the colums shown in the humidors? I still have so many I have never tried, that when I go looking it would be nice to sort my inventory by strength, avg rating, wrapper, etc.
I must be missing something, for me the export feature remains the same s it was.
I deleted cookies and temp files, logged off and on again but all I get in the exported file is the content of my humidors, not the previous smokes.
What am I doing wrong?
Switch to your Previous Smokes, and there is now an export button at the bottom. I don't know if it was available for the Wish List previously, but it is there as well. An option to export all humi (each one into a separate tab) would be nice, but I'm happy with this solution having only two humis I care about.
The button's there but it exports the same data, content of my actual humidors.
Same goes with the button for the whish list. So the three buttons bring the same results back.
I'm still missing something :shamebag:
Can't believe I've been a computer tech for almost 20 years, let's keep this amongst ourselves :biggrin:
QuoteMojo66 - 7/18/2013 12:03 PM
The button's there but it exports the same data, content of my actual humidors.
Same here.
The "Export" buttons have always been on the Previous Smokes and Wish List humidor pages - they all behave the same way and do not export previous/wish list data.
Good, so I'm not crazy... well I might be crazy, but at least I'm not the only one :blech:
Hahaha!
Sorry!
:whistle:
I don't remember the button there previously. Didn't actually compare the data.
:shamebag:
Is there an easy way to import into the virtual online humidor? I've got a spreadsheet with all of the data already, so I'd love a quick way to ingest that in.
It would also be cool to see a "where purchased" category
Thanks for having something that works with both the app and web - that's exactly what I was looking for!
Currently, there is no feature to upload data into the virtual humidor. However, once you get all the initial data input into it, it is fairly easy to maintain in my opinion.
Hi Folks. Exporting Wish Lists and Previous Smokes doesn't seem like too bad of an ask. Let me work on it.
Importing is just too tough as validating and trying to match whatever anyone might enter for a cigar name to whats in the DB (including whatever edits we may have made). Would just be more frustrating to folks than useful I think.
-Paul
Paul, that export feature for previous smokes would be awesome. Any thoughts given to being able to export a person's reviews - at least maybe the cigar and the star rating?
:bump:
Any progress on this? I would love to be able to export my previous smokes and wishlist to Excel :-)
Hey guys. I had this in testing for awhile. Just lost sight of moving it to production when the server crashed. It is live now.
-Paul
That is very cool, Paul.
I noticed that when I export previous smokes, it doesn't reconcile. As it shows on the site, I've got 1,400+ cigars in my previous smokes. When I export, the total is right around 1,000. Just a FYI.
QuoteSenorPablo - 3/17/2014 3:12 PM
Hey guys. I had this in testing for awhile. Just lost sight of moving it to production when the server crashed. It is live now.
-Paul
Hi Paul, just tried this and I am not really seeing any effect of the new buttons...
Quotehebron - 3/17/2014 10:20 AM
QuoteSenorPablo - 3/17/2014 3:12 PM
Hey guys. I had this in testing for awhile. Just lost sight of moving it to production when the server crashed. It is live now.
-Paul
Hi Paul, just tried this and I am not really seeing any effect of the new buttons...
Not sure why you wouldn't see any affect from the change. It is there.
-Paul
I see the new include check-boxes, but the xls file only contains items in my humidors. If I summarize the quantity field in the xls file I get 80, the same count I have in my current inventory.
When I export I get all my humis and previous smokes but I dont get the wish list.
What I find is that it exports my current inventory and my previous smokes only, but the numbers don't add up to what they should, according to the online humidor. I don't get the wish list stuff at all.
QuoteconditionZero - 3/17/2014 10:47 AM
What I find is that it exports my current inventory and my previous smokes only, but the numbers don't add up to what they should, according to the online humidor. I don't get the wish list stuff at all.
Same here, now that I've taken a closer look.
Hmmm...try again guys. I just made another change.
-Paul
QuoteSenorPablo - 3/17/2014 6:24 PM
Hmmm...try again guys. I just made another change.
-Paul
That did it! All the numbers are are a match between the xls and my humidor now. Thanks Paul, great job :bigthumbs:
Worked for me as well. Thanks Paul!
Ok. Good to hear.
-Paul