Skip to main content

RAW File <Newsletter>

Image: Diagram Process of Newsletter

STEP 1: File Arrives

DISCORD:

A notification with <@username> will alert the designer upon file arrival in “#newsletter-daily” channel.

GOOGLE DRIVE

  1. Make a Copy of <.pptx> file from Shared Folder into “My Drive”
  2. Rename this <.pptx> file in this format: DD-MM-YY.pptx (Ex: 01-01-24.pptx)

STEP 2: File Conversion

GOOGLE CODE COLABORATORY

https://colab.research.google.com/drive/1gRdKN3KrNed5e-l6FpcKXelZgF0l5-r2?usp=sharing

Connect to the Server (Locate the Option on Top Right Corner) Connect with Cloud Server Open Table of Content (Locate on the Top Left Corner) Open Colab Index Go to CREATE RAW Under PROCESS 1 : [Newsletter-Daily] and Run It Run the Cell Allow Access to Google Credentials and Google Drive Allow Connect to Google Drive Enter the Exact <.pptx> filename into the Input Field Example Image: 02-08-24.pptx Go to EXTRACT IMG DATA Under PROCESS 1 : [Newsletter-Daily] and Run It Run the Cell Enter the Exact <.pptx> filename into the Input Field Example Image: 02-08-24.pptx

STEP 3: File Processing

GOOGLE DRIVE

  • Select and Cut {Ctrl+X} all 3 Items (Img Folder + Newsletter + PPTX)
  • Paste into this Location: My Drive / MAGDB / Month / Daily-Newsletter

GOOGLE DOCS

Open the Newsletter Docs file for formatting as Instructed below in video:

WATCH VIDEO GUIDE

https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link

Properly Identify Headings using pptx file as reference.Remove Non-Heading type Content and make them as “Normal-Text” instead.CHECK: Dual Tables on Single Slides, Fix them.Remove repetitive occurrence of the word: “NEWSLIDE” using CTRL + H.

MCQ Table /w AI

METHOD 1:

Using the URL to Google Colaboratory, In Process 1 of [NEWSLETTER-DAILY], Go to “GENERATE QA /W AI” and enter the full name of Newsletter Document ex: ‘NEWSLETTER-DD-MM-YY-RAW.docx’, the API will process the document and 4 responses will be presented, then Manually Read all 4 Responses one by one and choose only the best table with a good level of Questions-Answers.

https://colab.research.google.com/drive/1S6_rGzKJbys0IzNyLCLsiEGPZaCU6k3_?authuser=3#scrollTo=oYGsgKV_uy2f

https://drive.google.com/file/d/1iuOcjKT2beOgjvf-KKSteBbj4bE7oz4g/view?usp=sharing

METHOD 2:

After the Docs file is edited as instructed above, we’ll save the file as Markdown (.md) Save the File as PDF

https://www.perplexity.ai/search/what-to-do-read-the-attached-c-kuarMG1ORyiwoDjMuE4esQ

Create a new thread/conversation by clicking on the + icon then in the chat tap on the paperclip icon to attach the makrdown file to Perplexity AI and Give this Prompt to find Top 5 MCQs then Copy the Output of Generated table and paste it into Newsletter-Docs-File.

NOTION

Update the STATUS to: “In-Progress” Paste the Link to docs file in INPUT-RAW-URL

STEP 4: File Designing

Watch this video to understand the complete design process:

https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link

CANVA

  • Open the associated Design File of Newsletter.
  • Use the Newsletter Docs File to update the Design file to Latest Content.
  • Insert Images into Design File using the Drive Folder containing the extracted Images.
  • Insert Hyperlinks of the associated Newsletter LIVE Sessions.

YOUTUBE

STEP 5: File Cross-Checking

  • Check Consistency of Newsletter Content in the final design using the Raw Newsletter Docs File in Split Screen Mode.
  • Check for any possible repetition of any content or any unwanted errors.
  • Open the Attached URLs of Live Stream to check their workability.
  • Check the MCQs: The Qs table and Answer table should be correctly updated to today’s version of the Newsletter.
SHARE > DOWNLOAD > File type: PDF Print (All Pages) > [DOWNLOAD]

STEP 6: Final File Upload

GOOGLE DRIVE

Upload the file to the “Newsletter-Daily-FINAL” folder after Completing the checking. Copy the Link to this uploaded final Newsletter PDF File.

NOTION

Update the STATUS to: “Done” Update the “Pass 1” to Checked. Update the Pages of PDF: Paste the Link to PDF file in OUTPUT-URL

WATCH VIDEO GUIDE

https://drive.google.com/file/d/1DNvcSWZRNotqgOJKXSebYijQt-EhEKbc/view?usp=drive_link