Xibo

Data set Imprt csv

Asked by frank verdonk

Environment : cloud hosted server.

Hi Support.

I tried to import a csv file in to a data set but it will not import correct.

First i created the columns and than import the CSV file.

"137824,Vitesse 22 D7,Vitesse 22 D7,DSS D8,Vitesse 22 D7 - DSS D8,08-11-14,09:45,veld 4,"
"80865,Vitesse 22 B2,Vitesse 22 B2,IJmuiden B1,Vitesse 22 B2 - IJmuiden B1,08-11-14,09:45,veld 2,"

It only import the first column.

And is it possible to do a auto upload via a api. ?

Kind Regards Frank

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Dan Garner
Solved:
Last query:
Last reply:
Revision history for this message
Best Dan Garner (dangarner) said : 		#1

Your CSV file is not correctly formatted - the " mark in CSV should be wrapped around each column - not the entire string.

Yes - there is an API method for it: http://xibo.org.uk/manual/index.php?toc=developer_api&p=admin/api_datasets#DataSetImportCsv

Revision history for this message
frank verdonk (o-infm-m) said : 		#2

Thanks Dan Garner, that solved my question.