ijtzib

HI Kim,

I tried changed it to a one-to-many relationship instead of lookup listbox but I’m trying to understand how will I then be able to select the student?

Ian

Hi,

Another issue I am observing is that it is duplicating the students as I create another enrollment. eg. Standard II and so on…

See below screenshot

https://snipboard.io/lBCPmF.jpg

Ian

Hi Peter,

I realized that I can do this in data table as custom query and by the way I have already run it and it work good there.

Thank you for the assistance Peter.

Regards,

Ian

Hi Kim,

For this case, should I create a new field in my table to store the results for the avg? Please advice. Thanks.

Ian

Hi Kim,

That was the trick. Had to make it !important. ?? Thank you!

Hi Kim,

Don’t think is an independent code. I using the search setting for that table to display the drop down select to search in my form: see… https://snipboard.io/JQf4ph.jpg

HI Kim,

I am calculating a avg with specific formula and would like to display my results for every row in the assessment tab of my project form. How to I go about doing that?

See sql here… https://snipboard.io/5GVntE.jpg

See image of where I would like the results to be displayed a column within the assessment tab.. https://snipboard.io/jXzW0G.jpg

Hi Kim,

Thank you. I followed your instructions and it did worked but the ADD NEW button did not inherited the changes. So went to the inspector and it does change there but eg. the code below was copied from the inspector. but when I plug it in the additional css of my theme nothing happens. Also see SS.

https://snipboard.io/3yKg1a.jpg

.wrap .add-new-h2, .wrap .add-new-h2:active, .wrap .page-title-action, .wrap .page-title-action:active {    
   border-radius: 33px;;

}

Sure. will open a new thread.

Hi Kim,

Thank you for your response. Yes it be great if there is more flexibility in terms of customizing the jQuery UI themes for the project forms and hopefully it can come soon. however how about customizing the forms using the other shortcode eg. [wpdadiehard project_id=”3″ page_id=”51″] .

Is there a way to customize using the CSS… change colors, customize the buttons etc… Also HTML to customize the layout and so on, for the specific project form or page. This is in contrast to using the jQuery UI theme. OR should you guide me on how to customize the jQuery UI theme instead? What advice can you give me? Thank you for you kind assistance. Below screenshot of my parent child form.

https://snipboard.io/93jkHq.jpg

hi Peter

Can you give us a general guidance how to accomplish this. My scenario is that when i select a module/subject in the search select box and hit search then filter only the set of learning outcome for that subject..

Thank you

IAN.

Hi Kim,

I manage to accomplish the relationship and view and it worked just fine. Thank you for replying to this post. Below view and screenshot:

CREATE ALGORITHM=UNDEFINED DEFINER=root@localhost SQL SECURITY DEFINER VIEW studentenrollmentview1 AS select s.student_id AS student_id,s.student_firstname AS student_firstname,c.enrollment_id AS enrollment_id from ((bz_sas_student s join bz_sas_class c on((s.student_id = c.student_id))) join bz_sas_student_enrollment se on((c.enrollment_id = se.enrollment_id)))

See belowhttps://snipboard.io/Sx2IUW.jpg

this is a screenshot of what I want to accomplish..I want to assess the students in the student list. be able to select a student for each assessment created.

Hi @peterschulznl

Im still getting the error

THis is how my csv looks like:

“ID”,”Room”,”BoxNo”,”Number”,”Year”,”Description”,”NoOfPages”,”DocumentLink”
1,2,1,”Census-2″,1816,”A Census of the population”,93,”Digital Census PDF\\1816 Population Census.pdf”
2,2,1,”Census-3″,1820,”Census of the Slave”,87,”Digital Census PDF\\1820 Slave Population Census.pdf”
4,2,1,”Census-4″,1823,”Population Census”,164,”Digital Census PDF\\1823 Population Cenus.pdf”

…and updated table sql looks like this:

CREATE TABLEincensus`
( Census_ID int(11) NOT NULL AUTO_INCREMENT
, Census_Room int(11) DEFAULT NULL
, Census_BoxNo int(11) DEFAULT NULL
, Census_Number varchar(50) COLLATE latin1_general_ci DEFAULT NULL
, Census_Year varchar(50) COLLATE latin1_general_ci DEFAULT NULL
, Census_Description text COLLATE latin1_general_ci
, Census_Pages int(11) DEFAULT NULL
, Census_Link text COLLATE latin1_general_ci
, PRIMARY KEY (Census_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci`

error looks like this:

Reading CSV file info...

Validating column mapping...

Enabling buffering...

Reading CSV file...

Connecting to database...

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Census of the population,93,Digital Census PDF\\1816 Population Census.pdf)' at line 1
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'of the Slave,87,Digital Census PDF\\1820 Slave Population Census.pdf)' at line 1
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Census,164,Digital Census PDF\\1823 Population Cenus.pdf)' at line 1
Import ready!

3 rows processed
0 rows inserted
3 rows with errors

Hi,

Here is my Table sql:

CREATE TABLEincensus`
( Census_ID int(11) NOT NULL AUTO_INCREMENT
, Census_Room int(11) DEFAULT NULL
, Census_BoxNo int(11) DEFAULT NULL
, Census_Number varchar(300) COLLATE latin1_general_ci DEFAULT NULL
, Census_Year varchar(300) COLLATE latin1_general_ci DEFAULT NULL
, Census_Description varchar(300) COLLATE latin1_general_ci DEFAULT NULL
, Census_Pages int(11) DEFAULT NULL
, Census_Link varchar(255) COLLATE latin1_general_ci DEFAULT NULL
, PRIMARY KEY (Census_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci`