Export CSV should be stable (Comic Book Forums)

• Export CSV should be stable

Author	Discussion
codedread Collector in Training Posts: 4 My Collection	Posted: November 24, 2024 1:41:13 pm I periodically export my collection as CSV (about once a month). I have noticed that sometimes the order of rows is not stable. Just as an example: My Oct export had rows in this order: - Booster Gold, Vol. 1, Issue 24 - Booster Gold, Vol. 1, Issue 25 - Booster Gold, Vol. 2, Issue 20 - Booster Gold, Vol. 2, Issue 21 My Nov export had rows in this order: - Booster Gold, Vol. 1, Issue 24 - Booster Gold, Vol. 2, Issue 20 - Booster Gold, Vol. 1, Issue 25 - Booster Gold, Vol. 2, Issue 21 Is there any way that export can be stable in terms of order? I would guess sorting by title, then by volume, then by issue
dough boy I have no life moderator lifetime member Location: Kansas City Posts: 12129 My Collection	Posted: December 3, 2024 7:43:06 pm I can look at it. Can I ask why you want it stable? Favorite Quote: "You're not just some guy in a bat costume are you? ARE YOU FREAKING KIDDING ME?! - Justice League #1, 2011" Hunting for (mainly reprints/variants) - Please help! - See My Profile
codedread Collector in Training Posts: 4 My Collection	Posted: December 3, 2024 8:00:53 pm Thanks! Every month I pull the CSV, import it into a spreadsheet, then insert a column and paste the new values into a master spreadsheet to allow me to compare how issues change month-to-month. The order needs to be stable for that to happen Last edited December 3, 2024 8:01:52 pm
dough boy I have no life moderator lifetime member Location: Kansas City Posts: 12129 My Collection	Posted: December 3, 2024 8:18:33 pm Why don't you just use the "On the Move" report? It will show you your changes. Favorite Quote: "You're not just some guy in a bat costume are you? ARE YOU FREAKING KIDDING ME?! - Justice League #1, 2011" Hunting for (mainly reprints/variants) - Please help! - See My Profile
codedread Collector in Training Posts: 4 My Collection	Posted: December 3, 2024 8:29:12 pm Thanks for the tip! I played around a bit with the reports; I can see some of them being useful. But I'm always going to want to do special things with my data. Track an individual issue over a long period of time, etc. Make notes, etc. Providing the raw data in CSV is a really great service you provide, but if your website one day ends, as all things eventually do, then I will be able to continue tracking things my way (assuming some similar service) until I eventually end Last edited December 3, 2024 8:30:28 pm
dough boy I have no life moderator lifetime member Location: Kansas City Posts: 12129 My Collection	Posted: December 3, 2024 9:01:58 pm I just looked. It is already sorting by Title (a-z), Type (issue, tpb, etc), and then the order in the database. I went ahead and added another sort that should make sure that the series are grouped correctly. Check it out and let me know. Favorite Quote: "You're not just some guy in a bat costume are you? ARE YOU FREAKING KIDDING ME?! - Justice League #1, 2011" Hunting for (mainly reprints/variants) - Please help! - See My Profile
6 posts • Page 1 of 1

When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.