ijtzib

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 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,

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,

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;;

}

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 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

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