Ask the community for help and advice here
|
agamoto Posts: 47
7/19/2021
|
I just spent over 10 minutes going through 3 pages of publishers exporting to excel.
I had to click "raw" and "graded" 250+ times for all the different publishers in my collection.
Is there no other way to export the collection data beyond per publisher exports or printing a list of everything in each of my boxes? That's not much better as I have 215 boxes.
|
|
|
0
link
|
|
agamoto Posts: 47
7/20/2021
|
So, lacking the box information on the publisher export spreadsheets, I chose to try the Box Content Printout export method.
It's nice that this method maintains the numerical grades assigned, while the per publisher sheets do not. and unlike the publisher exports, these results have the box location information baked in. One thing this output lacks is information notes on the variant or key information. Which sucks, but whatever.
It took me around 40 minutes to save to pdf, convert to excel via adobe.com, then arrange the spreadsheet so that you can actually use the data.
I have 216 more boxes to go through like this... I do NOT have an additional 144 hours of time to fix something that could be easily solved with a simple CSV output.
How much will it cost to get you to run a private SQL query to pull the data fields I need for just my books? I'm already a paying member, but I CANNOT afford to spend 144 freaking hours on this stuff.
THIS is useful...
THIS is not...
|
|
|
+2
link
|
