Please see attached file of links

Comics Core | Processed
1

2026-01-11_UnlinkedSubmission_01.csv (5.4 MB)

I used the CLZ cloud to download my collection, and added a column (L - CovrPrice URL) that contains the link for each unlinked comic specified in the row, which includes the Core Comic ID in column AH. Hopefully this accelerates the linking of these comics.

2

Hi, thank you for providing a list. Will get back to you here once I’ve worked trough it.

3

Please note I filtered the list to only those unlinked comics for which I found a match on Covrprice. Hidden / filtered out are submissions to Covrprice for missing comics, as well as those I hadn’t matched yet to existing entries.

1 Like
4

@CLZ_Justin please advise if this format is ok or if you have a preferred table format that helps you link the comics. I have a lot more coming ( at least several hundred), happy to align with your preferred method

5

James, let’s discuss here.
BTW: I looked at the CSV above and I am not seeing CovrPrice URLs in there. I see the columns, but it is empty.

6

I see the problem - when I pasted the URL into the excel file, it automatically converted the text to a friendly name with the URL automatically linked instead of the actual URL - when converted to CSV, it simply kept the friendly name text.

Let me create a new file with the URL text intact, and post that here and see if that gets us to where we want to be.

7

CLZ_Unlinked_sub02.csv (16.5 KB)

@CLZ_Alwin Try this file - the URL is now in clear text.

8

If this works, happy to use whatever template you prefer for additional submissions - I know you only need a subset of this information.

9

Yes, I am now seeing the CovrPrice URL in the CSV file.

First, I have to say: NOTHING in your Facebook post and the long discussion with me afterwards, indicated that you were providing these CovrPrice URLs. I assumed you were just going to provide a CSV with a list of your unlinked comics, requested us to link them.

So that is why I reacted as I did: basically saying that you were causing us a lot of work, processing your comics, as apposed to allowing us to prioritize the linking based on popularity of series in comics.

However, NOW I understand that you were actually trying to help us by providing the links to us, apparently hoping we could important somehow. That is a totally different discussion of course, and if I knew THAT is what you were trying to do, I would have reacted differently and would have tried to work with you to make that possible.

So… my apologies for the misunderstand.

NOW… looking at your CSV file, I see the CLZ Comic ID, which is good. I see the CovrPrice URL, which shows you have indeed done the work to find the matching comic.

But, I need the CovrPrice ID, not the URL. Internally, we link up the comics with the CLZ Core Comic ID and the CovrPrice ID. And the CovrPrice ID cannot be parsed from the URL.

So I need to find out how to make this happen. I will ask the CovrPrice tech crew and the CLZ tech crew, to ask if they know a solution.

Will keep you posted.

10

My original post here said I included the Covrprice URL - but it wasn’t until you looked at it and said there’s no URL here that I picked up on the issue with Excel.

Anyway, we’re past that now.

You mentioned you had all the Covrprice data - I would assume the includes both the cover price ID and URL, and there should be a 1-1 mapping for those.(meaning you could do a lookup of CP ID by url.

if the url you have at CLZ includes a CP ID, I might have to dig into the CP reference to see if I can tease that out.

Otherwise, I would have to create a collection in CP of missing comics and hopefully locate the ID through them.

BTW - if you could include the CP ID in your csv export, that would allow me to filter out what’s already linked. I’m manually flagging as I go, and that’s a pain.

11

Yes, here on the forum you said that, but I was not aware of this post here from Jan 11, never seen it.
Then you posted on Facebook, not referring to the original forum conversation and never mentioned there that you were planning to provide CovrPrice URLs.

You mentioned you had all the Covrprice data - I would assume the includes both the cover price ID and URL,

We just have the CovrPrice IDs.

BTW: I just heard from the CovrPrice team, that you asked them about the internal CovrPrice IDs. I would have preferred if you had waiting for MY investigation on that.

12

@CLZ_Alwin My reaching out to CP was just to learn if there was a standard way to obtain their internal ID. They confirmed that they intentionally omit or obfuscate their internal IDs to prevent scraping.

Unless you have other options, the best I can do is provide a unique url to the CP comic.

I don’t want to pester … what would be a reasonable timeframe to check back in with you on your analysis - 2 weeks?

(FWIW - if it turns out the CP URL is the best way to submit a request to link a comic, it would be great to have that capability in the CLZ app for unlinked comics to submit the CP link). This way you don’t have to scan the forums, and could perhaps build in an automation with CP to process those requests). Just thinking aloud.

13

I don’t know, so far you are the ONLY user who has been working to provide the CovrPrice URLs.

Most other users just tell us ‘hey this CLZ entry is unlinked” and then leave it up to us to find and link the correct CovrPrice entry.

So I don’t think there is much demand for a more automated tool within the app, as most users won’t go through the trouble anyway.

Don’t get me wrong, I appreciate that you DO want to do that work. But even then, I don’t know if it will help us much. Even IF we can find the CovrPrice ID from the URL, then still we would have to trust you that you did your work correctly and carefully.
I mean do we really dare to just blindly import your “CLZ ID → CovrPrice ID” list? That is usually not how we work. Our database is fully moderated and our content managers love the help from users, but never trust them blindly :slight_smile:

All in all, I am hesitant to spend a lot of to build an import tool for this, as we will probably be building it just for you and for your collection.
I am going to give it a try, I am going to discuss this with our developers and maybe the CP developers, but we’re only going to proceed if it’s easy and if we can find some way to actually check your linking.

14

@CLZ_Alwin i never in any way suggested you blindly accept the information I provided. You have moderated content, I get that from the forums and interactions.

Your guidance to CLZ users here in the forum for missing links includes verifying the comic exists in CP, and the easiest way to do that is provide the url. I think you’ll find that the urls I provided are indeed accurate. I see other people post individual requests here with the CP URL.

Consider that I (and others) have a vested interest in getting better coverage for our collections - that’s why you see the posts here. I would think there are a litany of ways of mitigating manual effort.

  • does the url resolve to a CP page?
  • Score the title of the comic (use your favorite algorithm, like jarowinkler similarity) - is it a high probability match with CLZ Core title?
  • How old is the unlinked record?

I would expect you could queue up the requests, run a batch process to eliminate any that have been linked since the submission (or last run), verify for the rest that the url resolves and whether there’s a high score match on the title and issue.

I would likely pass those through for automatic linking, and then maybe do a visual pass (either through sampling or whatever QA you think is adequate) - maybe those that have high values and / or show as keys / variants.

Whatever the case - we KNOW that CP has both the url and the internal id. I would hope they’d be willing as part of your partnership to provide a simple lookup of id by url limited to your use only.

15

Thanks for your technical advise. However, I am sure we could come up with all that ourselves, we have a smart team of developers here at the CLZ side and at the CovrPrice side.

The big question is, and maybe you missed that from my previous reply:

I am hesitant to spend a lot of to build an import tool for this, as we will probably be building it just for you and for your collection.

16

I’m far from the only one posting here with unlinked issues, but you’ve made your position clear that you prefer manual processing from a blogging tool.

I will continue to submit unlinked comics here, likely limiting my submissions to only links that have sales data in CP.