first usage
first usage
Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:
I am re posting here because I used a wrong category, I will try to delete my first post in wrong category , sorry.
1) I need to change dataset from TEXT to NUMBER . I see that there is a lock which does not permit to change dataset.
Is there any way to change dataset please ?
2) suppose in the future I will decide to leave Cloudtables , is there any way to export the data entered ? If yes, how ?
Thank you !
This question has an accepted answers - jump to answer
Answers
Hi,
Thanks for your question. At the moment I'm afraid that no - there isn't an option to convert the data type of a column. That is something that I want to look at in future, but there are so many edge cases for something like that, that it isn't currently on the development plan I'm afraid. How much data is it you have that needs to be converted?
One possible option (and it also relates to the second question) is to use an export button on the table (See the Customizing video) and then import your data again. If a column contains only numeric data, CloudTables will give you the option to import it as a number. The downside to this is that it will loose the configuration you might have for that data set (but would keep the data).
The other option is to use the API to update existing rows.
Which option is best, depends on how much data you have and any configuration you have done for the data set. Let me know if you need a hand with either option.
For question 2 - at the moment you can export all data from data sets either via the API, or using one of the export buttons such as the Excel, CSV or JSON buttons. There isn't yet an option in the UI to export configuration, but that is also something that will be coming in future (I can't see how a CloudTables configuration would be useful for migration to any other service, but it could be useful for hosted to self-hosted CloudTables for example).
Regards,
Allan