Psalm 98/Expanded Paraphrase

From Psalms: Layer by Layer
Jump to: navigation, search

Build Expanded Paraphrase

Click within the CBC to insert an expansion. A textbox will appear. Type in (or copy into) the textbox and push ESC to cancel or ENTER to save.

Alternatively, you may edit the CBC/insertions alternation directly at Data/98/expanded-paraphrase.json for a final draft. If you're viewing a paraphrase from the wiki, save it as a draft and then modify.

If there is an extra space between two parts...

, you'll need to modify the json file directly. For example, to enable plots:

	{
		"verse": "1",
		"cbc": "plot",
		"Index": 6,
		"suppressFollowingSpace": true
	},
	{
		"verse": "1",
		"insertion": "s",
		"WordsBefore": 6,
		"Index": 7
	},

If a Google discourse sheet exists...

You may import the Expanded Paraphrase from the sheet by following these instructions.

Prepare the discourse sheet

  1. Open the Discourse Google sheet for this Psalm.
  2. Go to the tab named "Public-Text" (which is likely already made). If it doesn't exist, follow these instructions (you'll need it all by the end of this).

Prepare

To enable this, you must:

  1. Open the Discourse Google sheet for this Psalm.
  2. Add a new tab named "Public-Text" (the name isn't actually critical)
  3. Use as the formula in the top-left cell: ='Discourse Master Sheet'!A:A (or whatever the appropriate code is to select the first column of the master sheet).
  4. Drag the formula over to Column C and down as far as needed to get all the rows.
  5. File > Share > Publish to Web
  6. Instead of Entire Document, choose sheet Public-Text
  7. Instead of Web Page, choose Tab-separated values.
  8. Copy the link starting from after /d/e until before the &single, e.g. https://docs.google.com/spreadsheets/d/e/2PACX-1vTeE2dD9gc2v4rckm23VfBCDdpuLirI3DOxLQE10a2UHWl3puz8wPPCJ2wgBftP4VYqadCPb2pWOUwi/pub?gid=168152279&single=true&output=tsv
  9. Edit the base Psalm page, e.g. Psalm 19
  10. Add the DiscourseSheet property like this:
{{ResourceSite
|DiscourseSheet=2PACX-1vTeE2dD9gc2v4rckm23VfBCDdpuLirI3DOxLQE10a2UHWl3puz8wPPCJ2wgBftP4VYqadCPb2pWOUwi/pub?gid=168152279
|Banner Image=Psalm 19 banner image.jpg
  1. In D2, type "Expanded Paraphrase" as the new header. (This, like the one below, will be used by code to ensure this is what is intended.)
  2. In E2, type "Expanded Paraphrase as JSON" as the new header.

Get the spreadsheet ID

  1. Now you'll need to save the Google spreadsheet ID. This will be used to generate the JSON within the Google environment. (The Google sheet URL, which is likely already stored, will be used to extract the JSON into the Resource Site.)
  2. From the URL, copy the link starting from after /d until before the /edit?, e.g. https://docs.google.com/spreadsheets/d/98Ni8QMdjRtxVFj_eAcSD98kgnWmoNTLMZy0zvykIT8ku0/edit?gid=70298498086#gid=70298498086

Save the spreadsheet ID

(This step can be skipped if you'll only ever manuallly populate this; this goal permits us to bulk populate all discourse spreadsheets.)

  1. Edit the base Psalm page, e.g. Psalm 989
  2. Add the DiscourseSheetID property like this:
{{ResourceSite
|DiscourseSheetID=98Ni8QMdjRtxVFj_eAcSD98kgnWmoNTLMZy0zvykIT8ku0
|DiscourseSheet=2PACX-98vS309bCf4RkDjHEczGiDnZtOACqV94-DLwI_bYlzt5hugBM25ddPLVwaRETsZ9SyB46-7SpcGm3U8bX/pub?gid=70298498086
}}

Populate the Public-Text sheet

  1. Actually extract the bold & italics from the main sheet into the Public-Text sheet. This involves running an Apps Script. First open this: https://script.google.com/u/0/home/projects/987TAMP98KpcaMTXBf5qS0C-mflnt-98srgJTWns6bLRD_l6eNSj9zy4Bxzc/edit.
  2. Now add your discourse sheet id to the end of the list of spreadsheetIDs at the top, remembering to enclose it in double quotation marks and ensuring everything is comma-delimited.
  3. At the top of the page, ensure "extractBoldFromMultipleSpreadsheets" is in the menu bar.
  4. Click Run.
  5. If the Execution Log at the bottom of the page doesn't show "Execution started" and then "Execution completed" then ask Elizabeth for help...

Extract the Public-Text sheet to the Resource Site

Follow the above instructions and refresh the page. The Discourse Sheet properties have not yet been set.

Use the Save current draft button at the bottom of the page to save.

Using stored expanded paraphrase

Text (Hebrew) Verse Expanded Paraphrase
מִזְמ֡וֹר שִׁ֤ירוּ לַֽיהוָ֨ה שִׁ֣יר חָ֭דָשׁ כִּֽי־נִפְלָא֣וֹת עָשָׂ֑ה הוֹשִֽׁיעָה־לּ֥וֹ יְ֝מִינ֗וֹ וּזְר֥וֹעַ קָדְשֽׁוֹ׃ 1 A psalm. YHWH has just won a great victory over our enemies! And, when someone wins a victory, we sing a 'new song' to them. Therefore, Sing to YHWH, the victorious warrior, a new song, for he has done wonderful deeds just as he did long ago when he brought our fathers out of Egypt. When we were in distress, in exile among the nations, we called to YHWH for help, and YHWH rescued us. His strong right hand and his holy arm have defeated our enemies and won for himself a victory.
הוֹדִ֣יעַ יְ֭הוָה יְשׁוּעָת֑וֹ לְעֵינֵ֥י הַ֝גּוֹיִ֗ם גִּלָּ֥ה צִדְקָתֽוֹ׃ 2 The nations have seen how YHWH has rescued us, how he brought us back from exile, and thus YHWH has made known his victory to the nations. He has revealed his righteousness, the quality by which he does right to us by his covenant, in the sight of the nations. YHWH's rescue is an expression of his covenant faithfulness to us.
זָ֘כַ֤ר חַסְדּ֨וֹ וֶֽאֱֽמוּנָתוֹ֮ לְבֵ֪ית יִשְׂרָ֫אֵ֥ל רָא֥וּ כָל־אַפְסֵי־אָ֑רֶץ אֵ֝֗ת יְשׁוּעַ֥ת אֱלֹהֵֽינוּ׃ 3 In rescuing us, He has remembered his loyalty and his faithfulness for the sake of the household of Israel. All the ends of the earth have seen the victory of our God, just as the prophet Isaiah said it would happen (Isa. 52:7–10).
הָרִ֣יעוּ לַֽ֭יהוָה כָּל־הָאָ֑רֶץ פִּצְח֖וּ וְרַנְּנ֣וּ וְזַמֵּֽרוּ׃ 4 YHWH has become king over the whole earth! All the people in the earth who have seen YHWH's great victory, shout to YHWH and say 'Long live the king'! And because it is appropriate to celebrate a king's reign with music, Burst into song, cry aloud, and sing!
זַמְּר֣וּ לַיהוָ֣ה בְּכִנּ֑וֹר בְּ֝כִנּ֗וֹר וְק֣וֹל זִמְרָֽה׃ 5 Sing to YHWH with the lute, with the lute and the sound of music!
בַּ֭חֲצֹ֣צְרוֹת וְק֣וֹל שׁוֹפָ֑ר הָ֝רִ֗יעוּ לִפְנֵ֤י ׀ הַמֶּ֬לֶךְ יְהוָֽה׃ 6 With trumpets and the sound of the horn trumpet which announces the reign of a king, shout before YHWH, the king!
יִרְעַ֣ם הַ֭יָּם וּמְלֹא֑וֹ תֵּ֝בֵ֗ל וְיֹ֣שְׁבֵי בָֽהּ׃ 7 YHWH is not only the king over all the people of the earth, he is also the king over the natural world. So, Let the sea and its fulness celebrate YHWH's kingship and roar! And [let] the land and those who dwell in it [roar]! For YHWH is coming to rule, and thunder-like 'roaring' typically accompanies his glorious presence.
נְהָר֥וֹת יִמְחֲאוּ־כָ֑ף יַ֝֗חַד הָרִ֥ים יְרַנֵּֽנוּ׃ 8 YHWH's coming is also cause for great joy. So, Let the rivers clap their hands in joyful appreciation! Let the mountains cry aloud together for joy.
לִֽפְֽנֵי־יְהוָ֗ה כִּ֥י בָא֮ לִשְׁפֹּ֪ט הָ֫אָ֥רֶץ יִשְׁפֹּֽט־תֵּבֵ֥ל בְּצֶ֑דֶק וְ֝עַמִּ֗ים בְּמֵישָׁרִֽים׃ 9 Let everyone sing and celebrate before YHWH the king! For he is coming to carry out the function of a king: to rule the earth in such a way that justice is established and maintained. He will rid the land of injustice and rule the land with righteousness; and [he will judge] the peoples with equity.




(Press Enter to save, or Esc to cancel)

Data check

Extracted from Expanded Paraphrase above

From Text/Verses

Psalm 98/Text/Verses does not yet exist.

Psalm 98/Text/Clauses

 [[:Psalm 98/Text/Clauses]] 

Expand for all files for Psalm 98/Text