Capitais do Brasil

Using my Dolibarr
1

Olá pessoal, afim de ajudar, resolvi adicionar as capitais brasileiras no sistema, siga os passos abaixo para a inserção.

Abra o phpMyAdmin, abra o banco de dados do Dolibarr, procure pela tabela
llx_c_regions, abra a mesma, e execute a seguinte SQL

INSERT INTO llx_c_regions (rowid, code_region, fk_pays, cheflieu, tncc, nom, active) VALUES

(’’, 20000, 56, NULL, NULL, ‘Brasil’, 1);

Depois procure pela tabela llx_c_departements, abra a mesma, importe o seguinte arquivo:

http://www.2shared.com/document/zRsz469T/llx_c_departements.html

Pronto, agora você ja pode selecionar a UF para cadastros.
Estou estudando o codigo, para implementar no cadastro cnpj/cpf e inscrição estadual.
Abraços

ops. Faltou São Paulo, só executar a query abaixo:

INSERT INTO dolibarr.llx_c_departements (
rowid ,
code_departement ,
fk_region ,
cheflieu ,
tncc ,
ncc ,
nom ,
active
)
VALUES (
NULL , ‘SP’, ‘20000’, ‘SAO PAULO’, ‘0’, ‘SP’, ‘São Paulo’, ‘1’
);

2

The link from 2shared point to a virus (setup.exe).
Can you send file to me eldy@destailleur.fr ?

3

Well, I don’t know what happened, but the link is cleaner of the any virus.
Anyway, I’ll put here the SQL query, then you can execute it into your phpMyAdmin.

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net

-- Servidor: localhost
-- Tempo de Geração: 04/02/2012 às 01h38min
-- Versão do Servidor: 5.5.16
-- Versão do PHP: 5.3.8

SET SQL_MODE=“NO_AUTO_VALUE_ON_ZERO”;
SET time_zone = “+00:00”;

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 */;

–
– Banco de Dados: dolibarr

--

–
– Estrutura da tabela llx_c_departements

CREATE TABLE IF NOT EXISTS llx_c_departements (
rowid int(11) NOT NULL AUTO_INCREMENT,
code_departement varchar(6) NOT NULL,
fk_region int(11) DEFAULT NULL,
cheflieu varchar(50) DEFAULT NULL,
tncc int(11) DEFAULT NULL,
ncc varchar(50) DEFAULT NULL,
nom varchar(50) DEFAULT NULL,
active tinyint(4) NOT NULL DEFAULT ‘1’,
PRIMARY KEY (rowid),
UNIQUE KEY uk_departements (code_departement,fk_region),
KEY idx_departements_fk_region (fk_region)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=610 ;

–
– Extraindo dados da tabela llx_c_departements

INSERT INTO llx_c_departements (rowid, code_departement, fk_region, cheflieu, tncc, ncc, nom, active) VALUES
(584, ‘AC’, 20000, ‘ACRE’, 0, ‘AC’, ‘Acre’, 1),
(585, ‘AL’, 20000, ‘ALAGOAS’, 0, ‘AL’, ‘Alagoas’, 1),
(586, ‘AP’, 20000, ‘AMAPA’, 0, ‘AP’, ‘Amapá’, 1),
(587, ‘AM’, 20000, ‘AMAZONAS’, 0, ‘AM’, ‘Amazonas’, 1),
(588, ‘BA’, 20000, ‘BAHIA’, 0, ‘BA’, ‘Bahia’, 1),
(589, ‘CE’, 20000, ‘CEARA’, 0, ‘CE’, ‘Ceará’, 1),
(590, ‘ES’, 20000, ‘ESPIRITO SANTO’, 0, ‘ES’, ‘Espirito Santo’, 1),
(591, ‘GO’, 20000, ‘GOIAS’, 0, ‘GO’, ‘Goiás’, 1),
(592, ‘MA’, 20000, ‘MARANHAO’, 0, ‘MA’, ‘Maranhão’, 1),
(593, ‘MT’, 20000, ‘MATO GROSSO’, 0, ‘MT’, ‘Mato Grosso’, 1),
(594, ‘MS’, 20000, ‘MATO GROSSO DO SUL’, 0, ‘MS’, ‘Mato Grosso do Sul’, 1),
(595, ‘MG’, 20000, ‘MINAS GERAIS’, 0, ‘MG’, ‘Minas Gerais’, 1),
(596, ‘PA’, 20000, ‘PARA’, 0, ‘PA’, ‘Pará’, 1),
(597, ‘PB’, 20000, ‘PARAIBA’, 0, ‘PB’, ‘Paraiba’, 1),
(598, ‘PR’, 20000, ‘PARANA’, 0, ‘PR’, ‘Paraná’, 1),
(599, ‘PE’, 20000, ‘PERNAMBUCO’, 0, ‘PE’, ‘Pernambuco’, 1),
(600, ‘PI’, 20000, ‘PIAUI’, 0, ‘PI’, ‘Piauí’, 1),
(601, ‘RJ’, 20000, ‘RIO DE JANEIRO’, 0, ‘RJ’, ‘Rio de Janeiro’, 1),
(602, ‘RN’, 20000, ‘RIO GRANDE DO NORTE’, 0, ‘RN’, ‘Rio Grande do Norte’, 1),
(603, ‘RS’, 20000, ‘RIO GRANDE DO SUL’, 0, ‘RS’, ‘Rio Grande do Sul’, 1),
(604, ‘RO’, 20000, ‘RONDONIA’, 0, ‘RO’, ‘Rondônia’, 1),
(605, ‘RR’, 20000, ‘RORAIMA’, 0, ‘RR’, ‘Roraima’, 1),
(606, ‘SC’, 20000, ‘SANTA CATARINA’, 0, ‘SC’, ‘Santa Catarina’, 1),
(607, ‘SE’, 20000, ‘SERGIPE’, 0, ‘SE’, ‘Sergipe’, 1),
(608, ‘TO’, 20000, ‘TOCANTINS’, 0, ‘TO’, ‘Tocantins’, 1),
(609, ‘DF’, 20000, ‘DISTRITO FEDERAL’, 0, ‘DF’, ‘Distrito Federal’, 1);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

I hope that you can like it.

cya

4

Thanks. Requests have been added into officiel development branch.

5

Hi Eldy,

Missed a state in the list.

(610, ‘SP’, 20000, ‘SAO PAULO’, 0, ‘SP’, ‘Sao Paulo’, 1),

Att.
Vinícius Nogueira

6

Thanks.
Will be fixed with 3.2

7

Obrigado, pessoal!
Me ajudou muito.

Thanks, guys.
Helped me a lot.

8

Ok I see this in the llx_c_departements but I don’t understand why it should be department when this is an federative republic ?