|
danthecomicman74 Posts: 1
1/14/2016
|
Hi everyone - is there a way to export or print the information in My Comic Collection?
Any info would be appreciated.
Thanks!
Dan
|
|
|
0
link
|
|
Laroo42 Posts: 104
1/26/2016
|
Hey!
I just did this (on a PC) to make sure it works:
1) Click the My Comic Boxes on the toolbar tab
2) Select the box that you wish to "export" (down arrow on the left)
3) Select Print
4) Don't print it but, convert it to a PDF. I used Adobe.
Hope this helps!
|
|
|
0
link
|
|
netstuffers Administrator Posts: 239
1/27/2016
|
New video covering this topic.
edited by netstuffers on 1/27/2016
|
|
|
0
link
|
|
BrotherLadies Posts: 4
8/7/2016
|
Hi! This very helpful! Particularly for users who want an organized, printable list. This great for simple bookkeeping, however if you need your data set up in a format ready for analysis, obviously, this website (which is great!) would need to: (1) Create a differently formatted spreadsheet export (which is difficult or tedious to program if your programming platform is table-based (SQL, Tableau, for example); (2) Each user may want a different export. This can get frustrating is users are picky, and do not understand that websites which are basically online ("back end") databases, in which users can choose variables, execute queries, etc. This website is not built that way.
What I propose: I can create a template FOR PROGRAMMERS (programmers on this type of platform will be able to understand what I mean) to utilize IF you would like to build out an export specifically for analysis and more book keeping. I understand that this poses challenges, as another "export" button may be needed (meaning: updating A LOT of code on the front end).
However, if you are interested in the basic structure and metrics needed to create an export with more practical utility (if you like to work with print outs just know that .csv files can save you quite a bit of time.)
Personally, I have created a macro in excel to recreate the export so that it formats in a way that is more useful for analysis and book keeping.
I can share the macro, but I can't de-bug for everyone. So I'll share the macro, but consider the basic template that I proposed earlier.
Peace & Love!
|
|
|
0
link
|
|
Jamieinnh Posts: 1
1/22/2017
|
Hello and thanks for such a great site! As a new collector I am wanting to export my lists into excel, and I love that this can be done, but there is one column missing on the export and I was wondering if this would be something you could add please.
On the site, we can enter the value we paid for an issue. Can this column be exported as well? You have the pricing information, but not the price paid value.
Thanks again for such a great site!
Jamie
|
|
|
0
link
|
|
Gilgandra Posts: 1246
1/22/2017
|
Great stuff Shawn.
I need to organize my collection into boxes one day.
|
|
|
0
link
|
|
sclingerman Posts: 157
1/25/2017
|
So you can't save/print your entire collection unless you do it for each individual publisher and combine the files, or put all of your comics into one box?
|
|
|
0
link
|
|
kds_comics Posts: 652
1/26/2017
|
BrotherLadies wrote:
Hi! This very helpful! Particularly for users who want an organized, printable list. This great for simple bookkeeping, however if you need your data set up in a format ready for analysis, obviously, this website (which is great!) would need to: (1) Create a differently formatted spreadsheet export (which is difficult or tedious to program if your programming platform is table-based (SQL, Tableau, for example); (2) Each user may want a different export. This can get frustrating is users are picky, and do not understand that websites which are basically online ("back end") databases, in which users can choose variables, execute queries, etc. This website is not built that way.
What I propose: I can create a template FOR PROGRAMMERS (programmers on this type of platform will be able to understand what I mean) to utilize IF you would like to build out an export specifically for analysis and more book keeping. I understand that this poses challenges, as another "export" button may be needed (meaning: updating A LOT of code on the front end).
However, if you are interested in the basic structure and metrics needed to create an export with more practical utility (if you like to work with print outs just know that .csv files can save you quite a bit of time.)
Personally, I have created a macro in excel to recreate the export so that it formats in a way that is more useful for analysis and book keeping.
I can share the macro, but I can't de-bug for everyone. So I'll share the macro, but consider the basic template that I proposed earlier.
Peace & Love!
BL
My unsolicited suggestion is that if you want to write SQL programming for data export you volunteer to assist admins here. I'd like mine in a common format. If the export was in "comma delimted text" or something - I could import to excel or access or SQL database. May be confusing to the average user, but might be a more practical suggestion that special programming stuff.
Only my opinion. Not that anyone listens...
KDS
|
|
|
0
link
|
|
netstuffers Administrator Posts: 239
1/27/2017
|
Yeah, we're going to have some more export formats in the next version. CSV is the likely candidate, but I gotta warn y'all... it will be a dump that will not be for the faint of heart. We keep a LOT of data and getting it all at once will be unwieldy for anyone other than you database wizards 
|
|
|
+1
link
|
|
marcer Posts: 28
5/12/2017
|
Need a little help here: I'm trying to export my Marvel collection via the publisher option button but it's only exporting books from the first title (2001, A Space Odyssey) of my Marvel collection. I switched to DC and the same thing happened. It only printed a list of the first title (All-Star Squadron) of my DC collection. How can I export my complete Marvel collection into one excel sheet? Any help would be greatly appreciated. Thanks!
|
|
|
0
link
|
|
marcer Posts: 28
5/13/2017
|
Update: I figured it out. Thanks
|
|
|
0
link
|
|
kds_comics Posts: 652
5/15/2017
|
netstuffers wrote:
Yeah, we're going to have some more export formats in the next version. CSV is the likely candidate, but I gotta warn y'all... it will be a dump that will not be for the faint of heart. We keep a LOT of data and getting it all at once will be unwieldy for anyone other than you database wizards
The effort is much appreciated. Than you.
|
|
|
0
link
|
|
rgooden Posts: 6
6/8/2017
|
Any update on when the next version may be available with the exporting capabilities? Also, how about adding some simple search criteria.
For example
* Give me all my comics valued $200 or more.
* Give me all comics graded 9.0 or above.
* Give me all comics graded 9.0 or above and valued at $200 or more.
I'm sure there are a few other options that could easily be added. Of course with the export, one can do this themselves if they have the skills in excel or databases. But adding a screen like this and the results seems like it would be greatly used.
|
|
|
0
link
|
|
rixmaxx Posts: 459
6/8/2017
|
rgooden wrote:
Any update on when the next version may be available with the exporting capabilities? Also, how about adding some simple search criteria.
For example
* Give me all my comics valued $200 or more.
* Give me all comics graded 9.0 or above.
* Give me all comics graded 9.0 or above and valued at $200 or more.
I'm sure there are a few other options that could easily be added. Of course with the export, one can do this themselves if they have the skills in excel or databases. But adding a screen like this and the results seems like it would be greatly used.
While you're holding your breathe for that,  have you ever tried Comicbase? I have all my comics imputed into both systems. (CBPG and Comicbase) Each has pros and cons but Comicbase has all the breakdown criteria options you could want. With my books in both systems, I have a better idea of the true value range of them...............Just my two cents. 
edited by rixmaxx on 6/8/2017
|
|
|
0
link
|
|
sclingerman Posts: 157
6/9/2017
|
rixmaxx: "I have all my comics imputed into both systems."
It's why I also put mine in an Access Database. Any query I want, I've got.
|
|
|
0
link
|
|
rgooden Posts: 6
6/13/2017
|
I haven't used Comicbase. Nothing against it but I made a choice and went with ComicsPriceGuide. It's been a year and I'm still inputting comics (my fault really, can't find time to go through the boxes). I'd hate to do 2 systems. CPG Seems mostly usable, just a few tweeks would be nice. Depends I guess on what type of user you are. While I am not actively selling any of my collection, it's nice to see the values and overall picture.
However, if I do want to sell It seems CPG does not have any good ways to determine what I would like to sell. I certainly don't plan to sell all Marvels or DC's or whatever. It would be nice if the system allowed the minimal query items I talked about. Now if you really want to hold your breath, then the system could identify those items that are hot/increasing in price and put them in a separate list.
|
|
|
0
link
|
|
fanboy77 Posts: 10
7/10/2017
|
Does anyone know who I should contact if I am having problems when I try to export these excel files? When I copy them and check them against what is in my collection all the titles are not there. I copied it one time and it did have any of the titles starting with the letter A. Next time it dropped the titles starting with the letter N. Any help would be appreciated. thx.
|
|
|
0
link
|
|
Gilgandra Posts: 1246
7/10/2017
|
fanboy77 wrote:
Does anyone know who I should contact if I am having problems when I try to export these excel files? When I copy them and check them against what is in my collection all the titles are not there. I copied it one time and it did have any of the titles starting with the letter A. Next time it dropped the titles starting with the letter N. Any help would be appreciated. thx.
Shawn should be-able to work it out for you. (head administrator/developer).
shawn@comicspriceguide.com
Hope that helped.
|
|
|
0
link
|
|
kds_comics Posts: 652
7/11/2017
|
Laroo42 wrote:
Hey!
I just did this (on a PC) to make sure it works:
1) Click the My Comic Boxes on the toolbar tab
2) Select the box that you wish to "export" (down arrow on the left)
3) Select Print
4) Don't print it but, convert it to a PDF. I used Adobe.
Hope this helps!
Or you can print to a Microsoft ".xps" Document Writer file if your printing system has this capability. This is still a graphical file, so nothing to get too excited about.
edited by kds_comics on 7/11/2017
|
|
|
0
link
|
