How to update quiz pot by csv file

Can you send me a copy of your CSV file so I can take a look.
[email protected]

Alex

Please, dear here is my csv file…

https://download1640.mediafire.com/irurtorb5aqg/u9lyrfjgz8c0pg0/Physics.csv

I’ve checked the import code and there is an anomaly.
You can fix by opening up quiz-tool-lite/scripts/export-functions.php

and on remove line 176 – 186.
i.e. delete

		else
		{
			$wpdb->insert( 
				$table_name, 
				array( 
					'potName' => $potName 
				), 
				array( 
					'%s' 
				) 
			);

I’ve tested that and it seems to work OK. however you do get duplicate questions.
Is the expected behavior to overwrite any existing questions with the new data or to add any questions as NEW?

Alex

If I delete line 176-186, my website doesn’t work.

Apologies I missed out a curly bracket. Try just removing

$wpdb->insert( 
				$table_name, 
				array( 
					'potName' => $potName 
				), 
				array( 
					'%s' 
				) 
			);

Of just comment it out
Alex

Now, the website works but the plugin doesn’t import any csv

OK I’ll try and put together a new version today and upload it.
What is expected behaviour for duplicate questions IDs? Should they be overwritten or duplicated with new IDs?