Xibo

How to Delete a Row in a DataSet?

Asked by Barry Wood

Hi,

I'm trying to develop an automated process to import data into a DataSet, rather than having to manually add values one at a time. However, in testing I've come across something that is a small annoyance :-)

How do you delete a row in a DataSet? I can see how you add rows, or delete the DataSet or edit the columns etc. but can't figure how to delete a single (or multiple) row/s of data's

Looking at the table in MySQL the data (in DataSetData table) for one record is spread over multiple rows as per the database schema setup, so it is fraught with danger (not to say painstaking) trying to delete rows from MySQL.

Question information

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

Hi Barry

You're trying to do something we didn't intend. Access to edit the data is via the web interface where this is all handled for you.

If you need to edit the records directly, and in an unsupported way, then I'd suggest writing the whole set out each time you edit from your own representation of the data, rather than try and edit it inplace.

Alex

Revision history for this message
Barry Wood (barry-x8) said : 		#2

Alex,

OK. the only problem I see this way is the complex method the data is stored in the table - the fields of one record are split over multiple rows in DataSetData table.

Maybe the way is to delete all the records in the table first then re-import with the required records.

I'm not an SQL expert but there may be a way to create a View of DataSetData table in such a way the records are presented in the 'normal' way - that is all the values of a record in one row (as per the view of the data in Xibo).