# MSP-PODCAST Manual Listening Task

# Step0. Download the files in the database
1. Go to [IONOS](https://login.ionos.com/?ac=OM.US.USo41K356157T7073a&shoplogin=enabled&linkId=hd.nav.login&ucuoId=PUAC:default.WH.US-20220909173123-3344B0F8A147402D906BBCCB64F90D9C.TClxa5b&_gl=1*6jx4ot*_ga*NzA1MDUxMjM3LjE2NjI3Mzc0OTM.*_ga_29DKNVLRWX*MTY2MjczNzUwMy4xLjAuMTY2MjczNzUwMy42MC4wLjA.):

    Username: www.lab-msp.com
    Password: Alec2013.

2. Click the button **"Manage"** under Database

3. Click the button **"open"**

4. Click the button **"Videos"** on the left-hand side

5. Click the buttion **"Export"** --> **"Export"** --> **"CSV"**

6. Click the buttion **"Go"**

7. Copy the file, **"Videos.csv"**, and change the name of the file to **"Videos.txt"**, and open and edit with the **"Notepad++"** on the **"Videos.txt"**

8. File name processing
* replace `^.*MSP` with `MSP`

* replace `mp4.*` with `wav`
9. Generate **""Videos.txt""**

--------
# Step1. Prepare Data (Create Text File)
1. Create file_path.txt using **""Creat_Txt.py""** (Need to change the folder name)

2. Copy the **""Videos.txt""** into the folder

3. Compress the folder into **""Videos.txt""** and upload into the folder for student works

--------
# Step2. Listening task
1. Open Matlab
2. Open **""main.m""** file
3. Change the dir path, start the task, and generate the answers file, **""xxx.mat""**.

4. Copy the answers file, **""xxx.mat""**
--------
# Step3. Process answers
1. Use **""S1_Combine.m""** this steps combines all answer files if the number of files is more than 2

2. Use **""S2_copywaves.m""** to copy selected audios to the folder, named **""Selected_Audio""**. Record numbers of **""Selected and Listened""** in the **""MSP-Podcast_Queue_ProgressReport.xlsx""**.
3. Use **""S3_CreateFLV_3.m""** to create selected audios' videos to the folder, named **""Selected_Video""**

5. Upload all generated vidoes in **""Selected_Video""** to the IONOS database via Filezilla credentials (**Make sure you log in the UTD Internet if you are outside of campus via UTD VPN**):
`Host:home709791326.1and1-data.host`
`User:u91268882`
`Password:Ab13Rl16Km@utd`
* **Path '/MSP_Podcast_survey/videos/'**

7. Use **""S4_Update_Video_Table.m""** to generate SQL commands line file, named "XXXX.csv"
8. Open **Python Environment**. Use **""S5_cal_duration.py""** to calculate duration of the selected audios
9. Open **Python Environment**. Use **""S6_add_priority.py""** to define priority of the selected audios (higher values, higher priority)
10. Go to the **IONOS** website
* Manage
* Open
* Videos
* Browse --> **Edit inline** --> Open the "XXXX_update.csv" copy all to the inline editor and hit GO, "XXXX_duration.csv"copy all to the inline editor and hit GO, and "XXXX_priority.csv"copy all to the inline editor and hit GO with Notepad++ --> copy the SQL command line--> **Go** (Notice that you need to do this for three times)
* Check the vidoe is good to open
* Open "XXXX_update.csv" with Notapad++ and click the line in any lines

--------
# Step4. Generate student worker's weekly or bi-weekly report
1. Create the folder and name the folder by the student's name, e.g., Arej
2. Create the folder, named 'Answers'
3. Pull all answer files into the folder in the path, e.g., './Arej/Answers/All/' (**Notice that DO NOT DELETE OLD ANSWERS FILES**)
4. Open **Python Environment**. **Change the **"Worker_name"** if needed. **Run the **""Step0_History_multiple_files.py""**.
5. Open **Python Environment**. **Change the **"Worker_name"** if needed. Set the **"Duration"** time in the code. **Run the **""Step1_History_segmentation.py""**.
6. Open **Python Environment**. **Run the **""Step2_Report_generate.py""**.
7. Open **Python Environment**. Set the **"Bi-weekly Working timesheet start and end date"** in the code. Set the **"Worker_fullname"** in the code. Set the **"Worker_name"** in the code. **Run the **""Step3_Summary.py""**.
* Must send the **"Bi-weekly Working timesheet"** to Dr. Busso **every middle and end of month**, e.g., **9/15** and **09/30**.
9. Send the generated file, named **"Workerfullname_listening_month.txt"**, and **"MSP-Podcast_Queue_ProgressReport.xlsx"** to Dr. Busso.