We store in Couchbase flat and hierarchical data.
Our customer support team needs from time to time to change value of some fields in some records. The team is not very technical and unlikely to use N1QL. In some cases even a batch of 1000 documents needs to be updated in other cases it is a single document.
I will appreciate ideas on tools/methods that will enable non-technical people to have access to the documents and change them. Another idea raised was to be able to export the information to CSV and then upload it, this is a second priority.
Sounds like your going to have to create a Web N1QL and FTS builder for the end user.
GENERAL DOC STRUCTURE INSIGHT
You can use N1QL’s INFER
bucket-name to give user an idea of what documents are in your DB.
Then have a simple drop-box like query builder to build your " WHERE … and … "
FTS to find docs Ids that match searches searches
CHANGE VALUES INPUT
Now that you have your Keys you want to change via FTS and/or have your WHERE … and … parameter build you can do a N1QL UPDATE with the WHERE and have a input box with the new values.
How much access do you want to give users to change data?
Look and change any record?