Posts

Showing posts with the label Database

Excel PDF CSV Export for jQuery Datatable

Image
The Jquery Data-table has PDF ,CSV ,Excel support which  reduce lot of cording by integrating other open source libraries .  https://datatables.net/extensions/buttons/examples/initialisation/export.html Here I have indicated step by step guide for the integration . Step 1 . JS Imports  dataTables.buttons.min.js  //Provided in \DataTables-1.10.13\extensions\Buttons buttons.flash.min.js            //Provided in \DataTables-1.10.13\extensions\Buttons buttons.html5.min.js          //Provided in \DataTables-1.10.13\extensions\Buttons buttons.print.min.js           //Provided in \DataTables-1.10.13\extensions\Buttons jszip.min.js                       //Please download from http://stuk.github.io/jszip/ pdfmake.min.js                //Please Download from https://github.com/bpampuch/pdfmake vfs_fonts.js                     //Please Download from https://github.com/bpampuch/pdfmake CSS imports  buttons.dataTables.min.css          //Provided in \DataTables-1.10.13\exten

Oracle SQL Developer 'Enter value for action:'

Image
I have given the following prompt message in SQL Developer wile executing quarries like below Insert into MENU (MENUID,MENUNAME,MENULINK)  values  (64,'Add - e','index.php?controller= product & action=changePage') ; The for the prompt message is & sign indicated which expect a value as a parameter.  This will tell the story : https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:4549764300346084350  In Order Bypass the prompt  you need to indicate   set define off at the beginning of the code.

Heroku Postgres Database Backup

Image
Hi I have Heroku ,And I face lot of problems in upgrading the models based on the changes . http://www.panhidhalyrics.com/ Based on lot of discussions  the migrations of Heroku ,  doing in local and apply them in the remote after pushing not gives me the expected outcome. Rather application ends up in  errors. 1. $ heroku run python manage.py makemigrations panhidhaapp 2. Push the changes to git   3.  $ heroku run python manage.py migrate The other thing we can do it  we change the Model and apply the change in the DB manually trough PgAdmin Frist you need to login and get the db Cardinals https://id.heroku.com/login Navigate to the following location Application >> Addons >> Heroku Postgres :: -- >> Overview Section Open PgAdmin and  give the detail as it is .The value in the database will be given to the maintenance db in pgAdmin.   After login you have to navigate to your own database which does not indicated the access restriction by cros