Blastinburn 2 years{"ops":[{"insert":"I'm trying to import a CSV into archidekt to add to my collection but the importer has trouble identifying specific editions of cards despite providing both the set and collector number. I can fix this problem by adding the scryfall ID manually but pulling the scryfall ID for 3 dozen + cards is tedious and I'm hoping I'm just doing something wrong that can be fixed.\n\nI generate my CSV from an excel document that pulls all the necessary information into a single sheet.\n"},{"attributes":{"link":"https://cdn.discordapp.com/attachments/432636123232206858/1106988631396188251/Archidekt.csv"},"insert":"Here is the CSV."},{"insert":"\nHere are the cards that are currently having trouble importing, plus everything in the CSV that I've added a scryfall ID to.\n2,Swamp,033,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"2,Plains,029,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Island,031,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"2,Elsewhere Flask ,015,BRR,Foil,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Foundry Inspector ,016,BRR,Foil,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Hexavus ,014,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Ichor Wellspring,021,BRR,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"2,Island,032,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Kayla's Music Box,015,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Lantern of Insight,135,MYSTOR,Foil,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,March of Progress,008,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"2,Plains,030,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,\"Sanwell, Avenger Ace\",005,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Scholar of New Horizons,006,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Swamp,034,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Thopter Shop,019,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Wire Surgeons,010,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Wreck Hunter,011,BRC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Fighting Drake,077,8ED,Normal,LP,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Remove Soul,095,8ED,Normal,LP,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Dehydration,075,8ED,Normal,LP,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"2,Horned Turtle,083,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Puppeteer,094,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Sage Owl,098,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Phantom Warrior,093,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Aven Fisher,061,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Fleeting Image,079,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Mana Leak,089,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Blaze,127,8ED,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Foulmire Knight // Profane Insight,090,ELD,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Silverflame Squire // On Alert,031,ELD,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Faerie Guidemother // Gift of the Fae,011,ELD,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Charming Prince,008,ELD,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Glass Casket,015,ELD,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,An Offer You Can't Refuse,051,SNC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,Incriminate,084,SNC,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"},{"insert":"1,The Wanderer,037,WAR,Normal,NM,"},{"attributes":{"blockquote":true},"insert":"\n"}]}
2
Jeremy(Archidekt Moderator)
2 years{"ops":[{"insert":"I apologize for the slow reply! This one has been stumping me for a few days as well. \n\nI think what I've narrowed it down to is something related to two digit collector numbers. You'll notice all but five or so of the ones it can't find don't have the full three digits so it has an extra 0 or two added in front. That said, there's no reason that should be a problem. \n\nI'm going to keep digging into this, but I was able to get it to find everything with about five exceptions by copy/pasting the data into a new Excel file. It's possible the original was malformed somehow with its formatting, but how or why that's causing the issue is beyond me. Regardless, I'd suggest giving that a shot and seeing if it works for you. I'll let you know when I come up with a more concrete explanation of what's going on.\n"}]}
1
Blastinburn 2 years{"ops":[{"insert":"Thank you for looking into this.\n\nI've tried copying the data into a new CSV file and importing that but it results in the same unsure of editions problem as with the exported sheet. I also tried creating a new CSV by copying the data from excel into LibreCalc and am still seeing the same cards missing editions.\n\nEdit: I tried changing the formatting to remove the leading 0s from the collector numbers since you pointed that out and that fixed all but 2 of the entries! Definitely seems like that is the source of the problem.\n\nEdit 2: I fixed the 2 remaining issues, the first was just I have no idea what set codes wotc uses for their secret lair promo packs, but the last remaining error was that the collection importer just didn't recognize 8ED Blaze for some reason. I put in the scryfall ID so it's imported now but I couldn't figure out any reason Blaze wouldn't have been entered correctly.\n"}]}
Edited 5/23/2023, 4:35:33 PM
0