[LINUX] Descompactando arquivos zip, rar, tar.gz, bz2, tar.bz2 pelo terminal

<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOwtEpbpOa5EQiOXBrstUSTXDy_TAde4a1GwUHaQKIRM94is1dFbeFDNy30wc3NsVmSMLyN9v8lb327rj2ryrwUzwKpPmg5jbRo3eOiyl-6lHE5mgitXIyF0fvDpPeE5x8kavKSAM7dB0/s1600/Linuxs.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOwtEpbpOa5EQiOXBrstUSTXDy_TAde4a1GwUHaQKIRM94is1dFbeFDNy30wc3NsVmSMLyN9v8lb327rj2ryrwUzwKpPmg5jbRo3eOiyl-6lHE5mgitXIyF0fvDpPeE5x8kavKSAM7dB0/s400/Linuxs.jpg" width="400" /></a></div><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">Para descompactar estes formatos de arquivos os comandos são simples: </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">zip: </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><strong style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">gunzip nomedoarquivo.zip</strong><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;"> </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">rar: </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><strong style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">unrar x nomedoarquivo.rar</strong><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;"> </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">tar: </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><strong style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">tar -xvf nomedoarquivo.tar</strong><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;"> </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">tar.gz: </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><strong style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">tar -vzxf nomedoarquivo.tar.gz</strong><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;"> </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">bz2: </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><strong style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">bunzip nomedoarquivo.bz2</strong><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;"> </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">tar.bz2: </span><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><br style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;" /><strong style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;">tar -jxvf nomedoarquivo.tar.bz2</strong><span style="background-color: white; font-family: Verdana, 'DejaVu Sans'; font-size: 11px; text-align: justify;"> </span>

[LINUX] Descompactando arquivos zip, rar, tar.gz, bz2, tar.bz2 pelo terminal

Para descompactar estes formatos de arquivos os comandos são simples:  zip:  gunzip nomedoarquivo.zip   rar:  unrar x nomedoarquivo.rar   ta...

Read more »

Configurando Área de trabalho Remota no Ubuntu 9 em Diante

<span style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; word-spacing: 2px;">Para que um computador com o Windows possa se conectar ao seu </span><span class="blsp-spelling-error" id="SPELLING_ERROR_13" style="background-color: white; border: 0px; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline; word-spacing: 2px;">Ubuntu</span><span style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; word-spacing: 2px;">, siga os passos abaixo: Instale o </span><span class="blsp-spelling-error" id="SPELLING_ERROR_14" style="background-color: white; border: 0px; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline; word-spacing: 2px;">vncviewer</span><span style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; word-spacing: 2px;">, para isso clique em "Aplicativos", "Acessórios" e depois em "Terminal";</span><br /><span style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; word-spacing: 2px;"><br /></span><span style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; word-spacing: 2px;">Digite "</span><span class="blsp-spelling-error" id="SPELLING_ERROR_15" style="background-color: white; border: 0px; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline; word-spacing: 2px;">sudo apt-get install xvnc4viewer</span><span style="background-color: white; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; word-spacing: 2px;">" e digite a senha do </span><a href="http://www.todoespacoonline.com/como-criar-ou-modificar-a-senha-do-root-no-ubuntu-1110___269" style="-webkit-transition: color 200ms ease-out 0s; background-color: white; border: 0px; color: #2b6bb3; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline; word-spacing: 2px;">super-usuário (<span class="blsp-spelling-error" id="SPELLING_ERROR_20" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">root</span>)</a><br /><br /><br /><div style="background-color: white; border: 0px; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline; word-spacing: 2px;"><span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: bold; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Nota:</span> <span style="border: 0px; font-family: inherit; font-style: italic; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Instale o <span class="blsp-spelling-error" id="SPELLING_ERROR_21" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">RealVNC</span> no Windows, para baixar o aplicativo para Windows, clique </span><a href="http://www.todoespacoonline.com/adm/redirect.php?url=http://www.realvnc.com/products/download.html" rel="nofollow" style="-webkit-transition: color 200ms ease-out 0s; border: 0px; color: #2b6bb3; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; text-decoration: none; vertical-align: baseline;" target="_blank">aqui</a><span style="border: 0px; font-family: inherit; font-style: italic; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">.</span></div><div style="background-color: white; border: 0px; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline; word-spacing: 2px;">Depois de ter feito tudo, configure o <span class="blsp-spelling-error" id="SPELLING_ERROR_22" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Ubuntu</span> para receber conexões de Área de Trabalho remota, para isso, clique em "Sistema", depois em "Preferências", depois em "Área de trabalho remota";</div><div style="background-color: white; border: 0px; color: #444444; font-family: Arial, Helvetica, sans-serif; font-size: 15px; line-height: 22px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline; word-spacing: 2px;"></div><div style="border: 0px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Marque as opções como preferir, só que você deve permitir que outros usuários possam se conectar ao computador via área de trabalho remota marcando as duas primeiras opções.</div><div style="border: 0px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; color: red; font-family: inherit; font-style: inherit; font-weight: bold; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Nota:</span> <span style="border: 0px; font-family: inherit; font-style: italic; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Foi necessário reiniciar os dois computadores para que tudo funcionasse <span class="blsp-spelling-error" id="SPELLING_ERROR_23" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">corretamente</span></span>.</div><div style="border: 0px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Para testar se tudo está correto, vá até o computador com o Windows que tenha o <span class="blsp-spelling-error" id="SPELLING_ERROR_24" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">RealVNC</span>instalado, clique em "Iniciar", "Programas", "<span class="blsp-spelling-error" id="SPELLING_ERROR_25" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">RealVNC</span>", "<span class="blsp-spelling-error" id="SPELLING_ERROR_26" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">VNC</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_27" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">viewer</span>4", "<span class="blsp-spelling-error" id="SPELLING_ERROR_28" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Run</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_29" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">VNC</span> <span class="blsp-spelling-error" id="SPELLING_ERROR_30" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Viewer</span> 4". Em "<span class="blsp-spelling-error" id="SPELLING_ERROR_31" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Server</span>" (Servidor), digite o IP do seu computador com o <span class="blsp-spelling-error" id="SPELLING_ERROR_32" style="border: 0px; font-family: inherit; font-style: inherit; margin: 0px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Ubuntu</span> mais ":0",</div><div style="border: 0px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Exemplo: 192.168.0.2.</div><div style="border: 0px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;">Href = <a href="http://www.todoespacoonline.com/area-de-trabalho-remota-entre-windows-e-ubuntu___170" target="_blank">http://www.todoespacoonline.com/area-de-trabalho-remota-entre-windows-e-ubuntu___170</a></div><div style="border: 0px; margin-bottom: 20px; margin-top: 20px; max-width: 640px; outline: 0px; padding: 0px; vertical-align: baseline;"><br /></div><br />

Configurando Área de trabalho Remota no Ubuntu 9 em Diante

Para que um computador com o Windows possa se conectar ao seu  Ubuntu , siga os passos abaixo: Instale o  vncviewer , para isso clique em ...

Read more »

Montar HD-Externo no Ubuntu Server 9.0 E 10.0

<br /><h2 style="background-color: #f9f9f9; font-family: arial, sans-serif; font-size: 26px; font-weight: normal; margin: 0px 0px 5px; padding: 0px; text-shadow: rgb(204, 204, 204) 2px 2px 2px;">[Linux]</h2><time style="background-color: #f9f9f9; color: #cccccc; display: block; font-family: arial, sans-serif; font-size: 12px; margin: 0px 0px 20px; padding: 0px;"><span style="color: #444444; line-height: 1.6em;">Primeiramente para montar o HD-Externo você precisa saber o caminho dele no sistema, com o comando</span><span style="color: #444444; line-height: 1.6em;"> </span><strong style="color: #444444; line-height: 1.6em;">fdisk -l</strong><span style="color: #444444; line-height: 1.6em;"> </span><span style="color: #444444; line-height: 1.6em;">você pode fazer isso facilmente, veja o exemplo:</span></time><pre style="background-color: #f9f9f9; color: #444444; font-size: 12px;">//Essa primeira linha abaixo indica qual o caminho do disco e qual o tamanho total do disco em seguinte os detalhes.<br />Disk /dev/sda: 1000.2 GB, 1000204886016 bytes<br />255 heads, 63 sectors/track, 121601 cylinders<br />Units = cylinders of 16065 * 512 = 8225280 bytes<br />Sector size (logical/physical): 512 bytes / 4096 bytes<br />I/O size (minimum/optimal): 4096 bytes / 4096 bytes<br />Disk identifier: 0x00052079<br /><br />Device Boot Start End Blocks Id System<br />/dev/sda1 * 1 120137 964998144 83 Linux<br />/dev/sda2 120137 121602 11761665 5 Extended<br />Partition 2 does not start on physical sector boundary.<br />/dev/sda5 120137 121602 11761664 82 Linux swap / Solaris<br /><br />Disk /dev/sdb: 1000.2 GB, 1000204886016 bytes<br />255 heads, 63 sectors/track, 121601 cylinders<br />Units = cylinders of 16065 * 512 = 8225280 bytes<br />Sector size (logical/physical): 512 bytes / 4096 bytes<br />I/O size (minimum/optimal): 4096 bytes / 4096 bytes<br />Disk identifier: 0x0001e24f<br /><br />Device Boot Start End Blocks Id System<br />/dev/sdb1 1 121602 976760832 8e Linux LVM<br /><br />Disk /dev/sdc: 500.1 GB, 500107862016 bytes<br />255 heads, 63 sectors/track, 60801 cylinders<br />Units = cylinders of 16065 * 512 = 8225280 bytes<br />Sector size (logical/physical): 512 bytes / 512 bytes<br />I/O size (minimum/optimal): 512 bytes / 512 bytes<br />Disk identifier: 0x42a05de7<br /><br />//Esse é o disco que nós iremos montar<br />Device Boot Start End Blocks Id System<br />/dev/sdc1 * 1 60801 488384000+ 7 HPFS/NTFS</pre><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">Mas como saber qual o disco nessa lista toda?</div><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">Simples, sempre o último disco da lista é o que foi colocado por último então como você conectou o HD na USB por último então ele vai estar no fim da lista.</div><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">Agora que já sabemos que o disco que está no caminho /dev/sdc1 vamos então efetivamente monta-lo.</div><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">Usaremos o comando <strong>mount </strong>seguido do parâmetro <strong>-t</strong> que serve para especificar o tipo de particionamento do HD, o tipo do particionamento que é <strong>ntfs </strong>, o caminho do disco que no nosso caso é <strong>/dev/sdc1 </strong>, e o mais importante, o destino(pasta onde o HD será montado) que será a pasta <strong>/home/hd-externo/</strong></div><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">Por fim o comando completo fica assim:</div><pre lang="bash" style="background-color: #f9f9f9; color: #444444; font-size: 12px;">mount -t ntfs /dev/sdc1 /home/hd-externo/</pre><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">Após a execução do comando já podemos acessar o HD no endereço especificado, então para isso executamos o comando:</div><pre lang="bash" style="background-color: #f9f9f9; color: #444444; font-size: 12px;">cd /home/hd-externo/</pre><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">e nele estarão todos os arquivos do HD.</div><div style="background-color: #f9f9f9; color: #444444; font-family: arial, sans-serif; font-size: 12px; line-height: 1.6em;">Para desmontar o HD em segurança basta usar o unmount mais o caminho do HD, ficando assim:</div><pre lang="bash" style="background-color: #f9f9f9; color: #444444; font-size: 12px;">umount /dev/sdc1</pre><pre lang="bash" style="background-color: #f9f9f9; color: #444444; font-size: 12px;"><br /></pre><pre lang="bash" style="background-color: #f9f9f9; color: #444444; font-size: 12px;">HREF BY=<a href="http://felipems.com.br/blog/?p=75" target="_blank">http://felipems.com.br/blog/?p=75</a></pre><div><br /></div>

Montar HD-Externo no Ubuntu Server 9.0 E 10.0

[Linux] Primeiramente para montar o HD-Externo você precisa saber o caminho dele no sistema, com o comando   fdisk -l   você pode fazer isso...

Read more »

Atalhos de Teclado For Linux Ubuntu 12.04

<br /><div style="background-color: white; color: #4e4e4e; float: left; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; margin-left: 10px; margin-top: -6px; text-align: left; width: 620px;"><br /></div><div style="background-color: white; color: #4e4e4e; float: left; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; margin-left: 10px; margin-top: -6px; text-align: left; width: 620px;"><br /><br /></div><div style="background-color: white; float: left; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; margin-left: 10px; margin-top: -6px; text-align: left; width: 620px;"><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;"><span style="color: #4e4e4e; font-weight: normal; line-height: 16px;">Algumas destas combinações precisa ter instalado o Compiz Manager.</span></strong><br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Win + E </strong><span style="color: #4e4e4e;">- Mostrar todos os desktops horizontais de uma só vez.</span><br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + Alt + Seta Esquerda. ou direita.</strong><span style="color: #4e4e4e;"> – Mova entre secretarias para a direita ou esquerda.</span><br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + Alt + Shift + seta para esquerda. ou Direita </strong><spidertag><span style="color: #4e4e4e;">-</span><span style="color: #ed030b;"><b>Mover</b></span><span style="color: #4e4e4e;"> a janela atual para uma outra área de trabalho para a direita ou esquerda.</span></spidertag><br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + Shift + seta para cima </strong><span style="color: #4e4e4e;">- Esta acção inicia uma bela interface para alternar entre janelas usando as teclas de seta para baixo, segurando </span><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + Shift.</strong><br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + F9/F10 -</strong><span style="color: #4e4e4e;"> Minimizar / Maximizar a janela atual, você está vendo.</span></div><div style="background-color: white; color: #4e4e4e; float: left; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; margin-left: 10px; margin-top: -6px; text-align: left; width: 620px;"><span id="more-884"></span><br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + F5 -</strong> Desmaximizar a janela atual, você está vendo.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + F7</strong> – Com esse atalho que você pode mover a janela ao redor da tela usando as setas indicam a direcção APRA, se arrastar para a direita, ou esquerda, vai ser mudado secretária.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + F8 </strong>- Redimensione a janela atual tamanho, você está vendo.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + Alt + D -</strong> Mostrar desktop – para mostrar as janelas que você tinha antes de exibi-lo.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + Shift + Tab </strong>- Alternar entre janelas em vez de como você faz com Alt + Tab.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + Shift + N</strong> – Rapidamente criar uma nova pasta.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + Enter </strong>- Exibe propriedades rapidamente item selecionado (ou arquivo ou pasta.)<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + 1 / 2</strong> – Mudar a forma como você vê os elementos da lista ou ícones.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + W</strong> – Fechar a janela atual do Nautilus.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + Shift + W</strong> – Feche todas as janelas actual Nautilus.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + T</strong> – Abre uma nova aba no Nautilus (muito útil para trabalhar com o mover / copiar arquivos)<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + Seta Cima / Baixo</strong><spidertag> – Mova para a pasta <a class="AdSpiderClass" href="http://www.blogger.com/blogger.g?blogID=897138209366994595" id="spiderWordFound0" rel="nofollow" style="border-bottom-style: dotted !important; border-bottom-width: 1px !important; color: #ed030b; cursor: pointer !important; font-weight: 700 !important;">pai</a> ou mover entre elas.</spidertag><br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + seta esquerda / direita</strong>. – Afaste-se ou entre pastas no Nautilus.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + Home</strong> – Ir para a pasta / home.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">F9</strong> – Mostrar / Ocultar painel lateral do Nautilus.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + H </strong>- Mostrar / Ocultar arquivos ocultos ou pastas.</div><div style="background-color: white; color: #4e4e4e; float: left; font-family: Arial, Helvetica, sans-serif; font-size: 12px; line-height: 16px; margin-left: 10px; margin-top: -6px; text-align: left; width: 620px;"><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Ctrl + Alt + L</strong> – Rápido acesso para bloquear seu desktop, se tiver de se levantar e deixar o seu computador apenas uma vez.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + F1</strong> – Abre o menu das aplicações do Ubuntu.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Alt + F2 -</strong> Abre a caixa Lazar aplicações.<br /><strong style="color: black; line-height: 20px; margin-left: 3px; margin-top: -6px;">Win + Wheel Mouse</strong> – Ótimo zoom sobre a área de trabalho, o que aumenta a área que se encontra o mouse.<br /><br />REF:<a href="http://www.sodicas.org/atalhos-para-linux-ubutu" target="_blank">http://www.sodicas.org/atalhos-para-linux-ubutu</a></div>

Atalhos de Teclado For Linux Ubuntu 12.04

Algumas destas combinações precisa ter instalado o Compiz Manager. Win + E  - Mostrar todos os desktops horizontais de uma só vez. Ctrl + Al...

Read more »

Tutorial de instalação do JAVA Oracle 7 no Ubuntu 12.04,12.10 e Linux Mint 13

<a href="http://www.diolinux.com.br/2012/10/como-instalar-o-java-oficial-no-ubuntu-mint.html" target="_blank">http://www.diolinux.com.br/2012/10/como-instalar-o-java-oficial-no-ubuntu-mint.html</a><br /><br /><br /><h3 style="font-family: Arial, Verdana; text-align: left;">Instalação</h3><div style="font-family: Arial, Verdana; font-size: 12px; text-align: left;">Adicione o repositório e atualize</div><div style="font-family: Arial, Verdana; font-size: 12px; text-align: left;"><br /></div><blockquote class="tr_bq" style="border-left-color: rgb(202, 218, 231); border-left-style: solid; border-left-width: 3px; color: #666666; font-family: Arial, Verdana; font-size: 12px; font-style: italic; overflow: hidden; padding-left: 9px; text-align: left;"><b>sudo add-apt-repository ppa:webupd8team/java && sudo apt-get update</b></blockquote><span style="background-color: white; font-family: Arial, Verdana; font-size: 12px; text-align: left;">Este repositório foi criado pelo time do </span><a href="http://www.webupd8.org/" rel="nofollow" style="color: #017db0; font-family: Arial, Verdana; font-size: 12px; outline: none; text-align: left;" target="_blank">http://www.webupd8.org/</a><span style="background-color: white; font-family: Arial, Verdana; font-size: 12px; text-align: left;">  ( congratulações pessoal) agora com o próxima comando instalaremos o JAVA propriamente dito.</span><br style="font-family: Arial, Verdana; font-size: 12px; text-align: left;" /><br style="font-family: Arial, Verdana; font-size: 12px; text-align: left;" /><blockquote class="tr_bq" style="border-left-color: rgb(202, 218, 231); border-left-style: solid; border-left-width: 3px; color: #666666; font-family: Arial, Verdana; font-size: 12px; font-style: italic; overflow: hidden; padding-left: 9px; text-align: left;"><b>sudo apt-get install oracle-jdk7-installer</b></blockquote><span style="background-color: white; font-family: Arial, Verdana; font-size: 12px; text-align: left;">Aguarde a instalação, para verificar a versão instalada digite no terminal:</span><br style="font-family: Arial, Verdana; font-size: 12px; text-align: left;" /><br style="font-family: Arial, Verdana; font-size: 12px; text-align: left;" /><blockquote class="tr_bq" style="border-left-color: rgb(202, 218, 231); border-left-style: solid; border-left-width: 3px; color: #666666; font-family: Arial, Verdana; font-size: 12px; font-style: italic; overflow: hidden; padding-left: 9px; text-align: left;"><b>java --version </b></blockquote><span style="background-color: white; font-family: Arial, Verdana; font-size: 12px; text-align: left;">Muitos </span><a href="http://www.diolinux.com.br/search/label/internet" style="color: #017db0; font-family: Arial, Verdana; font-size: 12px; outline: none; text-align: left;" target="_blank">Internet</a><span style="background-color: white; font-family: Arial, Verdana; font-size: 12px; text-align: left;"> Bankings não funcionam com o OpenJDK somente com o JAVA propriamente dito, essa dica deve solucionar estes problemas.</span><span style="font-family: Arial, Verdana; font-size: 12px; text-align: left;"><br />Read more: <a href="http://www.diolinux.com.br/2012/10/como-instalar-o-java-oficial-no-ubuntu-mint.html#ixzz2H32qDaaX" style="color: #003399; outline: none;">http://www.diolinux.com.br/2012/10/como-instalar-o-java-oficial-no-ubuntu-mint.html#ixzz2H32qDaaX</a></span>

Tutorial de instalação do JAVA Oracle 7 no Ubuntu 12.04,12.10 e Linux Mint 13

http://www.diolinux.com.br/2012/10/como-instalar-o-java-oficial-no-ubuntu-mint.html Instalação Adicione o repositório e atualize sudo add-ap...

Read more »

Import dans libreoffice base

Dans ce billet nous allons montrer comment facilement importer les données d'un fichier de type CSV dans une base données HSQL (base de donnée intégrée à libreoffice).<br />A l'ouverture de libreoffice base, nous choisissons de nous connecter à une base de données existante de type texte.<br />Tiens, on ne vient pas, là tout de suite, de parler de base de données HSQL?<br />Oui, mais cela ce sera pour plus tard.<br />Donc nous choisissons de nous connecter à une base de données existante de type texte:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEHIMgHGo5TODzOVK0FULOO4BrgID-4AFA5gb2J-vlfKEGpPps4Ii-3vIVHhs3Cr8pmVu3PXB1QNMSfI4NukHABrnFUn_NqpVVlrUlcTtI3uiIWmPpSjkVsOqSNzZqHDsVOR__voOd1Zs/s1600/bdcsv01.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjEHIMgHGo5TODzOVK0FULOO4BrgID-4AFA5gb2J-vlfKEGpPps4Ii-3vIVHhs3Cr8pmVu3PXB1QNMSfI4NukHABrnFUn_NqpVVlrUlcTtI3uiIWmPpSjkVsOqSNzZqHDsVOR__voOd1Zs/s1600/bdcsv01.png" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Nous avons préalablement créé un dossier ~/Documents/bdcsv destiné à contenir les tables de notre base de données (qui sont en réalité des fichiers de type CSV) et nous en indiquons le chemin au moment de paramétrer la connexion vers les fichiers textes. Nous ne manquons pas de paramétrer le point-virgule comme étant le séparateur de champ (s'il en est ainsi pour nos fichiers CSV) et de choisir pour séparateur de décimales celui qui convient:</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrScci1MtOzD8wO1OneCMZbkCUd_UGlImJ52tGYGppWBry9r2eIJAuBqjjaBzjE7W_dMf3tkx1xa-iRhd7WFc3CRDl3VMPOpYMFYvScVJYExH1GH1l4HhPo93D3UNNjisHLiKcgLTNHkc/s1600/bdcsv02.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrScci1MtOzD8wO1OneCMZbkCUd_UGlImJ52tGYGppWBry9r2eIJAuBqjjaBzjE7W_dMf3tkx1xa-iRhd7WFc3CRDl3VMPOpYMFYvScVJYExH1GH1l4HhPo93D3UNNjisHLiKcgLTNHkc/s1600/bdcsv02.png" /></a></div><div class="separator" style="clear: both; text-align: left;"></div><div class="separator" style="clear: both;"><br /></div><div class="separator" style="clear: both;">Nous terminons en enregistrant la base de données sous le nom bdcsv. </div><div class="separator" style="clear: both;">A l'ouverture du fichier bdcsv.odb, nous constatons que la base de données ne contient aucune table.</div><div class="separator" style="clear: both;">Normal puisque ~/Documents/bdcsv est vide.</div><div class="separator" style="clear: both;">Nous y plaçons le fichier opérations.csv contenant les donnée à importer:</div><div class="separator" style="clear: both;"><br /></div><div class="separator" style="clear: both;"></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">id_op;date_op;montant;contrepartie </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2011-0458;2011-12-30;487.33;RN2 </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0001;2012-01-03;1874.56;RN1 </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0002;2012-01-03;-42.57;ceci </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0003;2012-01-14;-119.23;cela </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0004;2012-01-14;-314.00;VOIT </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0005;2012-01-31;-114.23;Tél </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0006;2012-01-31;-956.00;Loyer </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0007;2012-01-31;1874.56;RN1 </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0008;2012-02-01;-127.23;GS </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0009;2012-02-09;-47.00;Autre </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0010;2012-02-11;-845.99;TV </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0011;2012-02-14;-25.47;Div </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0012;2012-02-15;-49.00;Ceci </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0013;2012-02-20;-314.00;VOIT </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0014;2012-02-27;-103.49;Tél </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0015;2012-02-29;-956.00;Loyer </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0016;2012-02-29;1874.56;RN2 </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0017;2012-03-01;-117.23;GS </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0018;2012-03-06;-43.00;Autre </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, Courier, monospace;">2012-0019;2012-03-06;-76.84;Div</span></div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;"><br />Pour voir apparaître l'icône de la table, nous passons par le menu Affichage → Actualiser les tables : <br /><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSSd-oHAIbiaZKU5cUPleTjJ_yZ8ljsXPUQKFJA1HSOYLBXZyqEIVnhbsYTcdIVAiFW1uus8Yg2R0We81ruLFt16KoNCdMG9EjTO0yIxceKBYOsnxFy_FRUWtJj8p8q_tYV3g9sbs1BU8/s1600/bdcsv03.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSSd-oHAIbiaZKU5cUPleTjJ_yZ8ljsXPUQKFJA1HSOYLBXZyqEIVnhbsYTcdIVAiFW1uus8Yg2R0We81ruLFt16KoNCdMG9EjTO0yIxceKBYOsnxFy_FRUWtJj8p8q_tYV3g9sbs1BU8/s1600/bdcsv03.png" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Cliquant droit sur l'icône de la table qui est apparue</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIuDN9fC23NBpRSxYw5Hg4BdCGsiOF3cguV7_mYRwb38It8uncwvZhbF-9F_sQphpiQg-Z98inWGVfulTLenZsjF0Ur2q39I-VM3HNOSQv2VFZWz2_f59TvsrlyDZxR2XviRwXzYJjwiY/s1600/bdcsv051.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIuDN9fC23NBpRSxYw5Hg4BdCGsiOF3cguV7_mYRwb38It8uncwvZhbF-9F_sQphpiQg-Z98inWGVfulTLenZsjF0Ur2q39I-VM3HNOSQv2VFZWz2_f59TvsrlyDZxR2XviRwXzYJjwiY/s1600/bdcsv051.png" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;">nous sélectionnons 'Éditer' dans le menu contextuel qui surgit  afin de vérifier quel type a été attribué aux différents champs de la table:<br /><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt1k3tjvZqJnVHFfm7CpOPz-6V-KKMCCa79_XR1GsgZYt5fG9K5SOb8MSbTMHWAwwSuekiheHr6Kpreo4CuKKqKmqWOaSXLq4R3tBegbWXiRZhUv7f0JdbfevqYZQPm0T_1_qOzYXTma0/s1600/bdcsv052.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgt1k3tjvZqJnVHFfm7CpOPz-6V-KKMCCa79_XR1GsgZYt5fG9K5SOb8MSbTMHWAwwSuekiheHr6Kpreo4CuKKqKmqWOaSXLq4R3tBegbWXiRZhUv7f0JdbfevqYZQPm0T_1_qOzYXTma0/s1600/bdcsv052.png" /></a></div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;"><br /></div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;"></div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;">Nous vérifions que pour le champ 'montant' les décimales ont bien été prises en compte.</div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;">Nous constatons que date_op est bien au format 'Date'. Ce ne serait pas le cas si une seule rangée de la table contenait une date invalide : date_op serait alors au format 'Texte' ce qui ne manquerait pas de poser problème pour la suite.</div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;">La suite ? Quelle suite ?</div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;">Et bien, rappelons le,  le but est d'importer les données du fichier opérations.csv dans une base de données intégrée à libreoffice (HSQL).</div><div lang="fr-FR" style="background-position: initial initial; background-repeat: initial initial; margin-bottom: 0cm;">bdcsv.odb est en fait une base de de données de transit, un réservoir de données à importer dans la véritable base de données finale. Chaque fois que nous disposerons de données au format CSV à importer, il nous suffira avant de procéder de placer le fichier de données dans ~/Documents/bdcsv.<br />Attention: si le fichier en question utilise le séparateur de texte, toutes les données concernées seront de type texte. Si ce n'est pas souhaité, il convient alors de supprimer le dit séparateur par exemple en utilisant sed:<br /><div style="background: #ccffff; margin-bottom: 0cm;"><style type="text/css">P { margin-bottom: 0.21cm; </style><span style="font-family: Courier New, monospace;"><span style="background: transparent;">sed -r -i.old 's/\"//g' fichier.csv</span></span></div></div><div>Lançons maintenant une deuxième instance de libreoffice en choisissant au niveau du menu d’accueil l'option 'Créer une base de données' et nous terminons en enregistrant cette base de données sous le nom 'opérations'. Et voici notre base de données finale sur les rails!<br />Ensuite, plutôt que d'utiliser le mode 'Ébauche' pour créer la table où placer les données à importer, nous procédons via le menu Outils → SQL:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7BPos-yARVB7MdcEp9E5atuYis9JOf5RUGZfNvVEKNzG9PNlAmWFb0FhPlVpKtk7UroP6P8G_cLziTo1ulITzvu4LMzNp0Klk0Q4I6886q4c64zcAVjd1_dgsmmGBIQcJadD5HVC5JTs/s1600/bdcsv04.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7BPos-yARVB7MdcEp9E5atuYis9JOf5RUGZfNvVEKNzG9PNlAmWFb0FhPlVpKtk7UroP6P8G_cLziTo1ulITzvu4LMzNp0Klk0Q4I6886q4c64zcAVjd1_dgsmmGBIQcJadD5HVC5JTs/s1600/bdcsv04.png" /></a></div><br /></div>Dans la fenêtre 'Instruction SQL', nous collons l'instruction:<br /><br /><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">CREATE TABLE opérations </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">(reference CHAR(9) PRIMARY KEY, </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">date_exec DATE, </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">montant NUMERIC(13,2), </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">contrepartie CHAR(5)) </span></div><div lang="fr-FR" style="background: #ccffff; margin-bottom: 0cm;"><span style="font-family: Courier New, monospace;">;</span></div><div class="western" style="margin-bottom: 0cm;"><br />et nous appuyons sur le bouton exécuter: <br /><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibdS6AsMkMfph0XyqLAlhwHaisJ8PRGzpy-rCdv77pYAG-thSH3_MsaqGjvfv7nw8P-RtiIdAYFMXkUT8FMO3OKfOrbSxozBuEIK0bwo8FdPSy2d54-aiHpn60d4nf5Yn26a1o6y1d6KA/s1600/bdcsv05.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEibdS6AsMkMfph0XyqLAlhwHaisJ8PRGzpy-rCdv77pYAG-thSH3_MsaqGjvfv7nw8P-RtiIdAYFMXkUT8FMO3OKfOrbSxozBuEIK0bwo8FdPSy2d54-aiHpn60d4nf5Yn26a1o6y1d6KA/s1600/bdcsv05.png" /></a></div><div class="western" style="margin-bottom: 0cm;"><br /></div><br />La table nouvellement créée sera visible après utilisation du menu Affichage -> Actualiser les tables. Nous constatons que la table a été créée sous le nom 'OPÉRATIONS':<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0ELgiySjE9S2vAh_jeBRgb2paALQE1bhhfEVqCJzYtURwJYAtjWM1uhb1euZq3v3mZ-gNparlLLChtNhPNiOHDvTMJz9FnoxzqTKoyY46rLACHzcKmQWZOrWxdXTReDWqd9-AMi-5qPU/s1600/bdcsv06.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0ELgiySjE9S2vAh_jeBRgb2paALQE1bhhfEVqCJzYtURwJYAtjWM1uhb1euZq3v3mZ-gNparlLLChtNhPNiOHDvTMJz9FnoxzqTKoyY46rLACHzcKmQWZOrWxdXTReDWqd9-AMi-5qPU/s1600/bdcsv06.png" /></a></div><br />Effectuons un 'glisser-déposer' de l'icône bdcsv.odb->opérations dans la zone des Tables de opérations.odb. Dans la fenêtre qui surgit nous remplaçons le nom de la table source (opérations) par celui de la table cible (OPÉRATIONS) et nous cochons 'Ajouter des données' :<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO82d3D9kh-LbRXah4vnT3R6brytpErv0pZrFMQao8Kypoe3Fd_Dc8gdGYmvDUNpdfGambTY3vtHOT7Rj7GiwHI0EjxAp6lU-TuLASc6yXsoVTJd0WCQz2CRWacPVi1Hc2VeczMLO25xA/s1600/bdcsv07.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="350" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO82d3D9kh-LbRXah4vnT3R6brytpErv0pZrFMQao8Kypoe3Fd_Dc8gdGYmvDUNpdfGambTY3vtHOT7Rj7GiwHI0EjxAp6lU-TuLASc6yXsoVTJd0WCQz2CRWacPVi1Hc2VeczMLO25xA/s640/bdcsv07.png" width="640" /></a></div><br />L'appui sur le bouton 'Suivant' nous permet de vérifier la correspondance des colonnes.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisZEsI4kcdptK_mJW0Y2f-fU01MPLHIoSJhg8T5Xx-TiOOGYOg5w9v6tvQ-RWbZMtZWGybEXa0WjRou5Qp2hpE1DHCSmgjHtGgpIboEJXSUK9ZYECpzWH5oMOejJby5QRDreDRozfVjCU/s1600/bdcsv08.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="344" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisZEsI4kcdptK_mJW0Y2f-fU01MPLHIoSJhg8T5Xx-TiOOGYOg5w9v6tvQ-RWbZMtZWGybEXa0WjRou5Qp2hpE1DHCSmgjHtGgpIboEJXSUK9ZYECpzWH5oMOejJby5QRDreDRozfVjCU/s640/bdcsv08.png" width="640" /></a></div><br />L'appui sur 'Créer' finalise l'opération d'importation.<br /><br />Il est plus facile (comme nous l'avons fait) mais pas nécessaire de créer au préalable la table destinée à recevoir les données que nous souhaitons importer.<br />Si cette table n'existe pas, dans la fenêtre 'Copier la table', nous cochons 'Définition et données' ainsi que 'Créer une clé primaire' à laquelle nous donnons le nom id_op. Mais ceci nous conduit à une impasse:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPIKsQmVw1KT_vQvtwJiE9_b5YuCAfBkAJ9UJUHsf-b-jswdGFm6G9juU086eaHOrwkJzNvRGc0O6mqPpEgWPTu9kjfWegzLSPHdiA9wWiWwtUt7FPkkqLlM7o-2rOQrJClAnCuSUEp2M/s1600/bdcsv092.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPIKsQmVw1KT_vQvtwJiE9_b5YuCAfBkAJ9UJUHsf-b-jswdGFm6G9juU086eaHOrwkJzNvRGc0O6mqPpEgWPTu9kjfWegzLSPHdiA9wWiWwtUt7FPkkqLlM7o-2rOQrJClAnCuSUEp2M/s1600/bdcsv092.png" /></a></div><br />Aussi nous recommençons après avoir remis le nom par défaut et après avoir décoché 'Créer une clé primaire':<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk_pilTlfngzmw0zeVVeJXKeQXBnLKdYq5aH_-WDPeoW7Kg7-70oHR7r15NrkPs3MF5wLhCnXWjl_XhezjARccl9unq1UGplytld2bldae7oIuBBXgBq44ya2tpIBW6yroxKX8Mc4KD4c/s1600/bdcsv09.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgk_pilTlfngzmw0zeVVeJXKeQXBnLKdYq5aH_-WDPeoW7Kg7-70oHR7r15NrkPs3MF5wLhCnXWjl_XhezjARccl9unq1UGplytld2bldae7oIuBBXgBq44ya2tpIBW6yroxKX8Mc4KD4c/s1600/bdcsv09.png" /></a></div><br />Le bouton 'Suivant' nous donne le choix des colonnes à importer :<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuSyKQ3KIKJZrZ6j465jIOoyrZCLFvfpG1vN3MmSM_nCFu4quOVsGvRUGVhXupdDn9XeTtkiKp3y67ovZDcJuaWc3rs2xr7AUD-h5e8HUrsub9T8KGdpi_VDW1fDiCV-ues5vAgMZBjxw/s1600/bdcsv10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuSyKQ3KIKJZrZ6j465jIOoyrZCLFvfpG1vN3MmSM_nCFu4quOVsGvRUGVhXupdDn9XeTtkiKp3y67ovZDcJuaWc3rs2xr7AUD-h5e8HUrsub9T8KGdpi_VDW1fDiCV-ues5vAgMZBjxw/s1600/bdcsv10.png" /></a></div><br />Nous pouvons ensuite modifier à notre guise le type des différents champs, par exemple pour id_op passer du type TEXTE[VARCHAR] au type TEXTE (FIXE)[CHAR].<br />Il ne faut pas oublier de mettre le nombre de décimales à 2 pour le champ 'montant' :<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCLK3XUzcMlmOFlX4aRGebQOcauZkJPhqSExSLOJI2QewIL0hSr9-1cneatN6m4ccLRIooAbWpZ40MNYJ7is5pjeP6TANxtHw-EeNefQPKa3QeazpRJStM0YK70Tm944C2HDtNkqm1L_U/s1600/bdcsv11.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCLK3XUzcMlmOFlX4aRGebQOcauZkJPhqSExSLOJI2QewIL0hSr9-1cneatN6m4ccLRIooAbWpZ40MNYJ7is5pjeP6TANxtHw-EeNefQPKa3QeazpRJStM0YK70Tm944C2HDtNkqm1L_U/s1600/bdcsv11.png" /></a></div><br />Après avoir appuyé sur 'Créer', nous répondons 'Oui' à la question 'Créer une clef primaire' car sans cela il nous sera impossible par la suite de définir id_op comme clé primaire:<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVvovPZGnye7jx-UI7OJOQkjzv_-tOtL4ZQFAbMNXyQu-IwR2fp-ReFOVW11hA0cGakdkPYo2KXJWZd93l6YIJm9AkmvphNcgDyurmG12IzDMJPH-rfzHf1tB6FqLP6dEFv7T39YIuq8Y/s1600/bdcsv12.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="337" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgVvovPZGnye7jx-UI7OJOQkjzv_-tOtL4ZQFAbMNXyQu-IwR2fp-ReFOVW11hA0cGakdkPYo2KXJWZd93l6YIJm9AkmvphNcgDyurmG12IzDMJPH-rfzHf1tB6FqLP6dEFv7T39YIuq8Y/s640/bdcsv12.png" width="640" /></a></div><br />Évidemment ceci ajoute une colonne supplémentaire (ID par défaut) à la table, colonne que nous supprimons illico.<br />Pour ce faire nous cliquons droit sur l'icône de la table qui vient d'être créée et nous sélectionnons 'Editer' dans le menu contextuel qui surgit. Ensuite dans la fenêtre 'Table design' nous cliquons droit en tête de la ligne définissant ID et nous choisissons 'Supprimer' :<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil22Vih9yFYgezFXOTY-U703fT5T4RPeLGl_EVtIzmX4frguq_xrgl2TbbrlZcJ3CxZvRTlr2omF3L9pf-oCA-_lXeP7EWhOaDf6NOG8HWCALl_rxbbzIggSxiXQ_vl8phnlM8r2aSvAg/s1600/bdcsv13.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEil22Vih9yFYgezFXOTY-U703fT5T4RPeLGl_EVtIzmX4frguq_xrgl2TbbrlZcJ3CxZvRTlr2omF3L9pf-oCA-_lXeP7EWhOaDf6NOG8HWCALl_rxbbzIggSxiXQ_vl8phnlM8r2aSvAg/s1600/bdcsv13.png" /></a></div><br />Puis comme il nous faut une clef primaire pour pouvoir éditer les données, nous cliquons droit en tête de la ligne définissant id_op et nous choisissons 'Clef primaire' :<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLN9IPmW7aGYjLe0lLgiAvhDC0juZDXEbKfSyxwiSULw0RXF_ZvBRN4GZ9975h6yd-9OLz58xGV4UKe4oWosJGYDSQC9GUdgzo9AdXLvNWvULxhR286u8WXp8yHUtAf6c-hqDzz11HuSc/s1600/bdcsv14.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhLN9IPmW7aGYjLe0lLgiAvhDC0juZDXEbKfSyxwiSULw0RXF_ZvBRN4GZ9975h6yd-9OLz58xGV4UKe4oWosJGYDSQC9GUdgzo9AdXLvNWvULxhR286u8WXp8yHUtAf6c-hqDzz11HuSc/s1600/bdcsv14.png" /></a></div><br />Et voilà!

Import dans libreoffice base

Dans ce billet nous allons montrer comment facilement importer les données d'un fichier de type CSV dans une base données HSQL (base de ...

Read more »