Pepperplate Export to Paprika YAML

exportPepper.sh

#!/bin/sh

ids=`sqlite3 ./recipes_2.db <<!
.mode csv
select Id from Recipe;
!`

dumprecipe() {
sqlite3 ./recipes_2.db <<!
.separator ' '
select '- name: ', Title from Recipe where Id = $1;
select '  servings: ', Yield from Recipe where Id = $1;
select '  source: ', Source from Recipe where Id = $1;
select '  description: ', Description from Recipe where Id = $1;
select '  prep_time: ', ActiveTime from Recipe where Id = $1;
select '  cook_time: ', TotalTime from Recipe where Id = $1;
select '  notes: ', Note from Recipe where Id = $1;
!
sqlite3 ./recipes_2.db <<!
.separator ' '
select 'categories: [', Tag.Text, ']' from ItemTag join Tag on Tag.Id = ItemTag.TagId where ItemTag.RecipeId = $1;
!
echo '  ingredients: |'
sqlite3 ./recipes_2.db <<!
.separator ' '
select '   ', IngredientGroup.Title, Ingredient.Quantity, Ingredient.Text from IngredientGroup join Ingredient on Ingredient.GroupId = IngredientGroup.Id where IngredientGroup.RecipeId = $1 order by IngredientGroup.DisplayOrder, Ingredient.DisplayOrder;
!
echo '  directions: |'
sqlite3 ./recipes_2.db <<!
.separator ' '
select '   ', DirectionGroup.Title, Direction.Text from DirectionGroup join Direction on Direction.GroupId = DirectionGroup.Id where DirectionGroup.RecipeId = $1 order by DirectionGroup.DisplayOrder, Direction.DisplayOrder;
!
}

#for id in $ids
for id in 483 1 435
do
    dumprecipe $id
    echo
done

I am more than half way done re-downloading all my recipes into Paprika with the built in browser. by the time I farted around with the python script to try and get it to work I would be done. So I will just continue doing it the "hard" way but thanks for the input. Just doesn't work for me.

…

On Thu, Oct 17, 2019 at 2:48 PM dweiss2 ***@***.***> wrote: I'm not sure why it would have a problem with that line but make sure you have at least Python 3.7 installed. I used 3.7.4 to write and test it. I've also updated the readme with hopefully clearer instructions. On Wed, Oct 16, 2019 at 5:39 PM skieremy ***@***.***> wrote: > I was having a ton of trouble getting this to run (mostly because I don't > use a mac), so I recreated it in Python. > https://gitlab.com/dweiss2/pepperplate-export-to-paprika > > Thanks for creating this Python to use on Windows! > I have tried running it and it states that there is a syntax error in line > 28 position 29. Any thoughts? > Can you provide a little bit of instruction similar to what people have > posted above in regards to the Mac instructions? i.e. Place downloaded > files at this location, change this to point to pepperplate file, etc. > > — > You are receiving this because you commented. > Reply to this email directly, view it on GitHub > < https://gist.github.com/bd76d83510b772bacfa98e7d93746c5b?email_source=notifications&email_token=ANLKXHCUKZ5DEVKZJ54GLWTQO6JZHA5CNFSM4HMKMH3KYY3PNVWWK3TUL52HS4DFVNDWS43UINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAF2TYA#gistcomment-3057536 >, > or unsubscribe > < https://github.com/notifications/unsubscribe-auth/ANLKXHAJUU7YYSTB7GAPXB3QO6JZHANCNFSM4HMKMH3A > > . > — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://gist.github.com/bd76d83510b772bacfa98e7d93746c5b?email_source=notifications&email_token=ABGFVS4L6FIKPQWKRZ6ZDZ3QPC6RXA5CNFSM4HMKMH3KYY3PNVWWK3TUL52HS4DFVNDWS43UINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAF2VUQ#gistcomment-3058504>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABGFVS27BBRP5WJMIJC224TQPC6RXANCNFSM4HMKMH3A> .

Hi everyone. We have added support for directly importing Pepperplate .db files into the latest version of Paprika, so you don't need to go through this process anymore. :)

Same with RecipeSage (recipesage.com) if you're looking for a free alternative :)

Doesn't require a .db file since it grabs the recipes directly from Pepperplate itself.

cool, I will give it a try

…

On Sun, Oct 20, 2019 at 6:27 PM Steven Wei ***@***.***> wrote: Hi everyone. We have added support for directly importing Pepperplate .db files into the latest version of Paprika, so you don't need to go through this process anymore. :) — You are receiving this because you commented. Reply to this email directly, view it on GitHub <https://gist.github.com/bd76d83510b772bacfa98e7d93746c5b?email_source=notifications&email_token=ABGFVS4HMNWQN2MWN7G5XIDQPTSM3A5CNFSM4HMKMH3KYY3PNVWWK3TUL52HS4DFVNDWS43UINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAF22HQ#gistcomment-3060856>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABGFVS2JOFAYIKZGCQYRLYLQPTSM3ANCNFSM4HMKMH3A> .

Worked great except the images must not be in the database which isn't your fault. have all my recipes now so thanks a ton. just need to get images but I can do that over time. On Sat, Nov 2, 2019 at 9:02 AM Bart Burroughs <bart.burroughs@cox.net> wrote:

…

cool, I will give it a try On Sun, Oct 20, 2019 at 6:27 PM Steven Wei ***@***.***> wrote: > Hi everyone. We have added support for directly importing Pepperplate .db > files into the latest version of Paprika, so you don't need to go through > this process anymore. :) > > — > You are receiving this because you commented. > Reply to this email directly, view it on GitHub > <https://gist.github.com/bd76d83510b772bacfa98e7d93746c5b?email_source=notifications&email_token=ABGFVS4HMNWQN2MWN7G5XIDQPTSM3A5CNFSM4HMKMH3KYY3PNVWWK3TUL52HS4DFVNDWS43UINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAF22HQ#gistcomment-3060856>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/ABGFVS2JOFAYIKZGCQYRLYLQPTSM3ANCNFSM4HMKMH3A> > . >

I tried importing from Pepperplate into recipesage.com and it appears to have worked quite well. I have not had time yet to try recipesage but I look forward to seeing if it suits my needs.

I've updated the RecipeSage import tool after some feedback from users. It's a bit faster and more reliable now.

Also, just an FYI - RecipeSage supports export, so even if you're not looking to use RecipeSage long term, you can use it to transform your recipes into text, JSON, or XML.

Link: https://recipesage.com

For anyone else using this and seeing the export contain only 3 recipes, it's because of the following lines:

#for id in $ids
for id in 483 1 435

If you change this to just:

for id in $ids

then all recipes will be exported. The version with the "483 1 435" was presumably there for debugging to avoid dumping too much data at once. (Sorry if this is stated elsewhere in the thread -- I didn't see it)

For anyone looking, please note that at least as of late September 2020, Paprika now directly imports Pepperplate's text file export that Pepperplate will allow you to do for free if you don't pay their extortionate rate to continue using their service. Everyone should be incredibly thankful for people like rgstephens writing code to help before the developers get their act together -- I certainly am, but at this point, no reason to muck with any of this, simply go to Pepperplate.com, export your recipes as a .zip file, and import that .zip file directly into Paprika.
Once again, thank you to the developer for providing this option prior to the development team.