Bulk import... from a spreadsheet?

annekaelber · 06-13-2022, 08:54 PM

Hey y'all!

I had a "brilliant" idea -- and now I'm buried in meta-data hell.

I'm creating a library for my crafting patterns (knit and crochet), with custom columns to track things I need to know when looking for a pattern. On Ravelry, I was able to export my library to a spreadsheet. Is there a way I can use that spreadsheet to ... flesh out(?) the import?

Currently, my patterns are in folders so that Knit and Crochet are "top-level" folders. Inside each of those, I have major pattern categories like "hats", "shawls", etc. For Crochet.Shawls, I clicked "add books" and drilled down the the right directory, then grabbed all the PDFs and imported them. Then, had to go through them manually to clean up Title and Author AND add in the data I want in my custom columns -- amount of yarn, weight of yarn, hook or needle size, shape (for shawls and blankets, etc.). It took the better part of a day to get through just Crochet.Shawls patterns (about 75, I think). With close to 200 Knit.Shawl patterns, I'm suddenly wishing for some way to make this easier.

TL;DR: Is there a way to manage an import with a spreadsheet -- such that values in the spreadsheet are applied to the appropriate entry for the correct pattern? I really don't want to have to hunt everything down manually!

(I know I'm reaching here, but if I don't ask, you can't surprise me with a good answer!

)

Thanks in advance for any advice or suggestions.

theducks · 06-13-2022, 09:36 PM

Import List Plugin: (from) CSV
You will need to map the fields

BetterRed · 06-14-2022, 01:55 AM

↑ ↑ ↑ ✔

@annekaelber = you might want to touch base with member DivingDuck, who uses calibre to manage embroidery patterns ==>> https://www.mobileread.com/forums/member.php?u=86759

06-13-2022, 08:54 PM	#1
annekaelber Enthusiast Posts: 32 Karma: 10 Join Date: Mar 2014 Location: Mesa, AZ, USA Device: Samsung Galaxy S3 and Note 8.0	Bulk import... from a spreadsheet? Hey y'all! I had a "brilliant" idea -- and now I'm buried in meta-data hell. I'm creating a library for my crafting patterns (knit and crochet), with custom columns to track things I need to know when looking for a pattern. On Ravelry, I was able to export my library to a spreadsheet. Is there a way I can use that spreadsheet to ... flesh out(?) the import? Currently, my patterns are in folders so that Knit and Crochet are "top-level" folders. Inside each of those, I have major pattern categories like "hats", "shawls", etc. For Crochet.Shawls, I clicked "add books" and drilled down the the right directory, then grabbed all the PDFs and imported them. Then, had to go through them manually to clean up Title and Author AND add in the data I want in my custom columns -- amount of yarn, weight of yarn, hook or needle size, shape (for shawls and blankets, etc.). It took the better part of a day to get through just Crochet.Shawls patterns (about 75, I think). With close to 200 Knit.Shawl patterns, I'm suddenly wishing for some way to make this easier. TL;DR: Is there a way to manage an import with a spreadsheet -- such that values in the spreadsheet are applied to the appropriate entry for the correct pattern? I really don't want to have to hunt everything down manually! (I know I'm reaching here, but if I don't ask, you can't surprise me with a good answer! ) Thanks in advance for any advice or suggestions.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Custom Column Values - Bulk Add or Import?	userbooknerd	Library Management	3	03-11-2021 04:15 PM
How to bulk import book metadata from another catalog?	Floating Quietly	Library Management	2	01-23-2020 01:10 AM
bulk import of metadata using files and command line	morquai	Library Management	1	08-25-2014 03:42 PM
Determining which files were not imported during a bulk import	valunthar	Library Management	3	06-17-2011 08:51 PM
Bulk import - possibly stupid question	Megahurts	Calibre	3	04-16-2010 05:59 AM

06-13-2022, 09:36 PM	#2
theducks Well trained by Cats Posts: 31,037 Karma: 60358908 Join Date: Aug 2009 Location: The Central Coast of California Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A	Import List Plugin: (from) CSV You will need to map the fields

06-14-2022, 01:55 AM	#3
BetterRed null operator (he/him) Posts: 21,715 Karma: 29711016 Join Date: Mar 2012 Location: Sydney Australia Device: none	↑ ↑ ↑ ✔ @annekaelber = you might want to touch base with member DivingDuck, who uses calibre to manage embroidery patterns ==>> https://www.mobileread.com/forums/member.php?u=86759

Advert