Can't export more than 5000 rows to Excel?

Question :

I have a problem about export data to xls,

I can't export more then 5000 rows to excel?

Answer :

Well after doing my last testing i found the answer and was very easy.

I was using LINUX UBUNTU 64 bit and it uses OPEN OFFICE (LIBRE CALC) and this program is only showing 5000 rows.

The solution is:

Open the file using Microsoft Excel on Windows.

Thank you. 

How to Change Date Format on JQGrid

How to Change Date Format  on JQGrid

Before :

 {name:'LASTUPDATE',index:'LASTUPDATE', width:90},

After :

 {name:'LASTUPDATE',index:'LASTUPDATE', width:90, formatter : 'date', formatoptions: {newformat: 'd/m/Y'}},

Delete from data select in SQL Server

Delete from data select

example :

delete   tm_access_det from tm_access_det
inner join tm_access_hdt a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=20285
and SEC_DEPARTMENT='QC'

update from data select in sql server

update From data select

example :

update tm_access_det  set  AJD_Emplcode=20033
from  tm_access_det
inner join tm_access_hdr a on AJD_HeaderID=AJH_ID
inner join tbmst_section on ajh_sectioncode=sec_sectioncode
inner join tbmst_employee  on em_emplcode=AJD_Emplcode
where  AJD_Emplcode=10043

How to Backup database mysql

Backup database mysql

open terminal :

mysqldump -u root -p root_password database_name > database_name.sql

How to change or reset MySql root password on Linux

How to Set or  change or reset the MySQL root password on Ubuntu Linux.

Enter the following lines in your  terminal.

Stop the MySQL Server.
sudo /etc/init.d/mysql stop

Start the mysqld configuration.
sudo mysqld --skip-grant-tables &

Login to MySQL as root.
mysql -u root mysql

Replace YOURNEWPASSWORD with your new password!

UPDATE user SET Password=PASSWORD('YOURNEWPASSWORD') WHERE User='root'; FLUSH PRIVILEGES; 
exit

Keunggulan Telegram dari WhatsApp

Aplikasi Telegram ini bisa berjalan pada Android ,iOS, Windows Phone, juga web version, OS X , OS Linux dan Windows desktop.
adapun beberapa keunggulan telegram dari whatsapp :

1. Telegram Lebih Cepat daripada WhatsApp

Tidak seperti WhatsApp, Telegram berbasis cloud (layanan komputasi awan) dan sangat terenkripsi. Hasilnya, Telegram menjadi lebih cepat daripada WhatsApp.

2. Telegram Lebih Aman daripada WhatsApp
Masih terkait cloud, basis data di sana membuat Telegram lebih aman.

3. Telegram Mudah Diakses dari Berbagai Perangkat
WhatsApp sebenarnya juga bisa diakses dari laptop. Namun, lagi-lagi karena faktor basis cloud, Telegram membuat Anda bisa mengakses pesan dari berbagai perangkat (termasuk PC) dan berbagi foto, video dan dokumen tanpa batas.

4. Telegram Bisa Berbagai File Hingga Ukuran GigaByte
Seperti dilansir Telegram dalam deskripsi di Google Play Store, aplikasi ini memungkinkan penggunanya berbagi file dan video hingga ukuran gigabyte.

5. Telegram Bebas Iklan
Meskipun WhatsApp dulunya juga bebas iklan, akuisisi mahal yang dilakukan Facebook atas aplikasi ini menimbulkan kekhawatiran bahwa WhatsApp akan dijejali iklan sebagaimana Facebook baik versi desktop maupun mobile. Sedangkan Telegram, developernya menjamin “100% free and no ads.”

6. Jumlah Anggota Grup Telegram Lebih Besar daripada WhatsApp
Mungkin Anda pernah merasakan betapa terbatasnya Grup WhatsApp yang membatasi anggotanya hanya 50 orang. Padahal, teman kantor atau teman alumni sekolah Anda lebih dari seratus orang. Sementara anggota grup WhatsApp terbatas 50 orang, anggota grup Telegram maksimal 200 orang. Empat kali lipan daripada WhatsApp. Ini salah satu alasan utama mengapa orang pindah ke Telegram.

install Telegram on Ubuntu

1. download application :

wget https://tdesktop.com/linux32 on a 32-bit system
or
wget https://tdesktop.com/linux on a 64-bit system

2. extact file

tar xvf linux*

3. Runing Application :

./Telegram/Telegram

Send Emali with SSMTP

install ssmtp :

sudo apt-get install ssmtp

Edit file  ssmtp.conf
sudo vim /etc/ssmtp/ssmtp.conf

edit seperti dibawah ini :

# Config file for sSMTP sendmail
#
# The person who gets all mail for userids < 1000
# Make this empty to disable rewriting.
#root=postmaster
root=test@gmail.com

# The place where the mail goes. The actual machine name is required no
# MX records are consulted. Commonly mailhosts are named mail.domain.com
#mailhub=mail
mailhub=smtp.gmail.com:587
AuthUser=test@gmail.com
AuthPass=xxxxxxxx
UseTLS=YES
UseSTARTTLS=YES

# Where will the mail seem to come from?
#rewriteDomain=

# The full hostname
hostname=test@gmail.com

# Are users allowed to set their own From: address?
# YES - Allow the user to specify their own From: address
# NO - Use the system generated From: address
FromLineOverride=YES


on php file :


//create fuction for send email

   function sendmail ($cc,$to,$sb,$msg)
    {       

    $headers  = 'MIME-Version: 1.0' . "\r\n";
    $headers .= "From: aem@aem.co.id \r\n";
    $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
    $headers .= 'cc:'.$cc. "\r\n";
    $headers .= 'Bcc:aem@aem.co.id'. "\r\n";
    ini_set("SMTP","smtp.aem.co.id");
    ini_set("sendmail_from",$mailfrom); 
    mail($to,$sb, $msg, $headers);
    //return $true;           
       
    }   


//send mail

$from: "xxx@xxx.com";
$mailto: "xxx@xxx.com";
$subject: "testing send email";
$message: "Test";

sendmail($from,$mailto,$subject,$message);

Install IE pada Mozilla Firefox

Download and install from Addons mozilla

https://addons.mozilla.org/en-US/firefox/addon/ie-tab-2-ff-36/

and then Restart Firefox.

add virtaul IP on Ubuntu

#sudo vim /etc/network/interfaces

auto lo
iface lo inet loopback

Add script virtual ip :

auto eth0
iface eth0 inet static
address 192.9.18.27
netmask 255.255.255.0
gateway 192.9.8.8
dns-nameservers 180.131.144.144

auto eth0:0
iface eth0:0 inet static
address 192.168.1.12
netmask 255.255.255.0
gateway 192.168.1.1
dns-nameservers 180.131.144.144

Chagne Port 80 on ubuntu

Edit file port.conf

 vim /etc/apache2/ports.conf

and then You have to change your virtualHost setting,

vim /etc/apache2/sites-enabled/000-default

Change from ;

 <VirtualHost *:80>

to

 <VirtualHost *:8050>

And make sure that your ports.conf looks like

 NameVirtualHost *:8050

Testing :

 listen 8085

Restart apache
service apache2 restart
or
/etc/init.d/apache2 restart

check the result on firefox:

http://localhost:8085/ijinpedia/