How to add a new author to the data spreadsheet:
1) Go to the Author Data Form page: http://kopptech.com/admin.html
2) Fill out the form with information from the author's page and Media Sharing spreadsheet (such as tags, including genre and BIPOC questions).
3) Once you copy the generated text, paste it next to the appropriate name in the Author Data spreadsheet: https://docs.google.com/spreadsheets/d/1rV2TXKFl8qsX8Lzupb8Fwce2OfqZVn-HH26Z0cjAUgs/edit#gid=1432787566 If there is no name, add it to the bottom of the spreadsheet, then re-alphabetize it by selecting Column B (last names), clicking the down arrow, and clicking Sort Sheet A -> Z.
4) Make sure the color of the newly added author is different from the rest so that if can be updated in the master file.
2) Fill out the form with information from the author's page and Media Sharing spreadsheet (such as tags, including genre and BIPOC questions).
3) Once you copy the generated text, paste it next to the appropriate name in the Author Data spreadsheet: https://docs.google.com/spreadsheets/d/1rV2TXKFl8qsX8Lzupb8Fwce2OfqZVn-HH26Z0cjAUgs/edit#gid=1432787566 If there is no name, add it to the bottom of the spreadsheet, then re-alphabetize it by selecting Column B (last names), clicking the down arrow, and clicking Sort Sheet A -> Z.
4) Make sure the color of the newly added author is different from the rest so that if can be updated in the master file.
How to update specific information in the data spreadsheet:
1) Go to the Author Data spreadsheet: https://docs.google.com/spreadsheets/d/1rV2TXKFl8qsX8Lzupb8Fwce2OfqZVn-HH26Z0cjAUgs/edit#gid=1432787566
2) Each data string is as follows:
{"name":"Author Name","title":"Book Title","headshot":"https://7705676-509064085926457829.preview.editmysite.com/uploads/7/7/0/5/7705676/author-headshot.jpg","cover":"https://7705676-509064085926457829.preview.editmysite.com/uploads/7/7/0/5/7705676/book-cover.png","tags":"tag tag tag","pageLink":"https://www.22debuts.com/authorfirstname-middlename-lastname.html"},
You can edit any of the highlighted data as long as all punctuation stays the same. Every comma, quote, : and space must be kept or it will mess up the master sheet. You can add any tag in any order as long as there is only a space between each one and it is spelled the same way as the data form page generates it. The tag spellings are as follows:
mg ya adult nonfiction gn lgbtqia bipoc disability contemporary dystopian fantasy gothic historical horror literary magicalrealism mystery retelling romance romcom sapphic scifi specfic stem suspense thriller womens
3) Change the color of the newly updated info cell so that we know to update it in the master file.
2) Each data string is as follows:
{"name":"Author Name","title":"Book Title","headshot":"https://7705676-509064085926457829.preview.editmysite.com/uploads/7/7/0/5/7705676/author-headshot.jpg","cover":"https://7705676-509064085926457829.preview.editmysite.com/uploads/7/7/0/5/7705676/book-cover.png","tags":"tag tag tag","pageLink":"https://www.22debuts.com/authorfirstname-middlename-lastname.html"},
You can edit any of the highlighted data as long as all punctuation stays the same. Every comma, quote, : and space must be kept or it will mess up the master sheet. You can add any tag in any order as long as there is only a space between each one and it is spelled the same way as the data form page generates it. The tag spellings are as follows:
mg ya adult nonfiction gn lgbtqia bipoc disability contemporary dystopian fantasy gothic historical horror literary magicalrealism mystery retelling romance romcom sapphic scifi specfic stem suspense thriller womens
3) Change the color of the newly updated info cell so that we know to update it in the master file.
How to update the master file:
1) Download the file from here: https://drive.google.com/file/d/113ckW-AVd2AkEAVsixzabRReDa68GPG8/view?usp=sharing (there is no preview option for it, only download)
2) Open the file in Notepad.
3) Copy in the entire column of strings in the data spreadsheet (but only the Column C!)
4) Select the placeholder string in the Notepad file between the [ brackets ]; (but make sure not to select the brackets themselves!)
5) Paste all the strings over it.
6) Save the file.
7) Go to this page and in the Weebly editor (not live).
8) Click on the people.jsonp file below this list of instructions and click upload file and replace it with the new file you just saved.
9)It should be updated and be live on the website. Sometimes to see it immediately you need to clear your cache (Press F12 on your keyboard and Right click the reload button on your browser and choose Empty Cache and Hard Reload).
10) Change the colors of any updated info to match the rest so we know it's been updated.
2) Open the file in Notepad.
3) Copy in the entire column of strings in the data spreadsheet (but only the Column C!)
4) Select the placeholder string in the Notepad file between the [ brackets ]; (but make sure not to select the brackets themselves!)
5) Paste all the strings over it.
6) Save the file.
7) Go to this page and in the Weebly editor (not live).
8) Click on the people.jsonp file below this list of instructions and click upload file and replace it with the new file you just saved.
9)It should be updated and be live on the website. Sometimes to see it immediately you need to clear your cache (Press F12 on your keyboard and Right click the reload button on your browser and choose Empty Cache and Hard Reload).
10) Change the colors of any updated info to match the rest so we know it's been updated.
| people.jsonp |
Backup embed code for Authors and Books pages (in case of emergency):
Just in case something gets messed up or deleted by accident , you can revert any changes to the Authors and Books pages by copy and pasting the entire code from the following:
Authors page:
<div style="width:100%; padding-bottom:56.25%; position:relative;">
<iframe src="https://kopptech.com/portfolio_gallery.html" style="position:absolute; top:0px; left:0px;
width:100%; height:800px; border: none; overflow: hidden;"></iframe>
</div>
Book covers page:
<div style="width:100%; padding-bottom:56.25%; position:relative;">
<iframe src="https://kopptech.com/book_gallery.html" style="position:absolute; top:0px; left:0px;
width:100%; height:800px; border: none; overflow: hidden;"></iframe>
</div>
Authors page:
<div style="width:100%; padding-bottom:56.25%; position:relative;">
<iframe src="https://kopptech.com/portfolio_gallery.html" style="position:absolute; top:0px; left:0px;
width:100%; height:800px; border: none; overflow: hidden;"></iframe>
</div>
Book covers page:
<div style="width:100%; padding-bottom:56.25%; position:relative;">
<iframe src="https://kopptech.com/book_gallery.html" style="position:absolute; top:0px; left:0px;
width:100%; height:800px; border: none; overflow: hidden;"></iframe>
</div>
