Hi there. Has anyone experience with exporting a collection, making edits or additions, and importing the file where duplicates are not created?
I did not want to work with individual issues when there are mass edits to make.
When I do it now, it creates new duplicate entries and those entries are not recognized compared to individual additions from earlier, like with cover images.
It could be done through using unique identifiers to sync, but any insight would be appreciated.
No, it’s not intended to be able to export and then import changes to existing entries. And if you’d always clear your database and then import whatever you exported, you might run into other problems and definitely lose all covers you added yourself.
Let’s take a step by: What are you mass editing?
CLZ Comics Web has an “edit multiple” feature, could you not use that for your changes?
Hi CLZ_AJ,
I have a need for this feature too. I have built a workflow using python and SQL to manage the selling of my collection. I can’t do this yet, because the feature doesn’t exist, but in my perfect world, I can update 5 fields in the CLZ database base on what sold: clz_index (matching to an existing record), sale_date, sale_price, collection_status, and sold_item_id (a cross reference field that I put into a custom field).
When you’re managing thousands of books, hunting and pecking just does not work. I want to quickly be able to migrate books with sales data to the proper collection status.
It is painful in the current iteration and it is sad that such a wonderful tool (THANK YOU!) cannot do a simple upsert using the CSV import function, keying in on the clz_index.
I could offer my services to help build this for you if I understood the backend, BUT you don’t know me and it’s your baby, so I understand.
This feels like a “must-have” for a full service collection management system, but I only realized that it was missing when I started to sell my collection. I imagine others started feeling it missing when the custom fields option arrived (which I haven’t really used much yet).
But: CLZ Comics Web has an “edit multiple” feature, could you not use that for your changes?
You can checkbox comics to select them, then hit Edit, and you can choose which fields you wish to edit for all of those comics in one go.
Is this not something that you can make work for you?
I understand you’re selling a lot of comics (are you running a store?), but our software is aimed at the home collector - and with Edit Multiple you have a powerful tool built right into your collection to do mass edits!