Forum | Appery.io

Hi,

I will like to develop an app using appery.io database. But i do not want to provide the client an access to login and access database. How do i achieve this? Do i have any option to allow user in accessing the database or best an exported csv? Or how do i ftp in, such as the path to the extracted data then i could probably build an external app to achieve this.

Cheers,
Pat

Hello!

To store data for common use you can use files table http://docs.appery.io/documentation/b.... For now there is no REST API to export data in CSV format, it can be done manually only http://docs.appery.io/documentation/b...

@Patrick, this code makes it very easy to trigger a CSV download from a JSON array. Originally from Stackoverflow (http://stackoverflow.com/a/4130939/317) , I mod-ed it to be easier to use as needed (without button styles to trigger it)

function JSON2CSV(objArray, blnGetLabels) {
var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;

 var str = ''; 
 var line = ''; 

 if (blnGetLabels) { 
     var head = array[0]; 
     if ($("#quote").is(':checked')) { 
         for (var index in array[0]) { 
             var value = index + ""; 
             line += '"' + value.replace(/"/g, '""') + '",'; 
         } 
     } else { 
         for (var index in array[0]) { 
             line += index + ','; 
         } 
     } 

     line = line.slice(0, -1); 
     str += line + '\r\n'; 
 } 

 for (var i = 0; i < array.length; i++) { 
     var line = ''; 

     if ($("#quote").is(':checked')) { 
         for (var index in array[i]) { 
             var value = array[i][index] + ""; 
             line += '"' + value.replace(/"/g, '""') + '",'; 
         } 
     } else { 
         for (var index in array[i]) { 
             line += array[i][index] + ','; 
         } 
     } 

     line = line.slice(0, -1); 
     str += line + '\r\n'; 
 } 
 return str; 

}

function DownloadCSV(objArray, blnGetLabels) {
var array = typeof objArray != 'object' ? JSON.parse(objArray) : objArray;
var csv = JSON2CSV(array, blnGetLabels);
window.open("data:text/csv;charset=utf-8," + escape(csv));
};