Subversion Repositories bacoAlunos

Compare Revisions

Ignore whitespace Rev 1418 → Rev 1419

/branches/v3/impl/conf/language/MessageResources.properties
388,7 → 388,7
username=Nome de Utilizador
password=Palavra Passe
username.pae=Número de Aluno/Docente
password.pae=Palavra Passe ou Número do Cartão de Cidadão (BI)
password.pae=<label class="label label-info" style="font-size:1.3em">Número</label> do <label class="label label-success" style="font-size:1.5em">Cartão de Cidadão</label> <label class="label label-info" style="font-size:1.2em">ou bilhete de identidade</label>
password.again=Repita a password
submit=Entrar
edit=Editar
/branches/v3/impl/src/doc/BacoV32016/processos/QuestionariosAccess/importMdb.sh
New file
0,0 → 1,23
MDB_FILE=$1
QUESTDATA=$2
QUESTPERIODO=$3
TABLES="INQUERITO PROFESSOR CURSO DISCIPLINA PROFESSOR_DISCIPLINA R_DISCIPLINA R_DOCENTE"
echo "Using file:$1 in year $2 semestre $3"
 
echo "drop database inqueritos$QUESTDATA$QUESTPERIODO;" | mysql -uroot
echo "create database inqueritos$QUESTDATA$QUESTPERIODO;" | mysql -uroot
 
#mdb-schema inquerito_final.mdb | sed "s/Double/int/" | sed "s/Long Integer/int/" | sed "s/\[//" | sed "s/\]//" | sed "s/\Text (.*)/varchar(250)/" | sed "s/Boolean/BIT(1)/" | sed "s/Numeric (.*)/int/" | sed "s/Cópia de /copia_de_/" | mysql -uroot inqueritos_$QUESTDATA_$QUESTPERIODO
 
#mdb-schema -S inquerito_final.mdb mysql | mysql -uroot inqueritos$QUESTDATA$QUESTPERIODO
 
 
mdb-schema -S inquerito_final.mdb mysql | grep -i CREATE | cut -f 3 -d " " | sed "s/\`//" | sed "s/\`//" | grep -v mdb > tmp_tables
 
echo $TABLES
for i in $TABLES
do
echo "Exporting $i to mysql"
mdb-schema -S -T $i inquerito_final.mdb mysql | mysql -uroot inqueritos$QUESTDATA$QUESTPERIODO
mdb-export -I mysql -H inquerito_final.mdb $i | mysql -uroot inqueritos$QUESTDATA$QUESTPERIODO
done
Property changes:
Added: svn:executable
+ *
/branches/v3/impl/src/doc/BacoV32016/processos/QuestionariosAccess/scriptMdbToolsExportMdbMySql.rtf
New file
0,0 → 1,16
{\rtf1\ansi\ansicpg1252\cocoartf1348\cocoasubrtf170
{\fonttbl\f0\fnil\fcharset0 Menlo-Regular;}
{\colortbl;\red255\green255\blue255;}
\paperw11900\paperh16840\margl1440\margr1440\vieww15780\viewh8400\viewkind0
\pard\tx560\tx1120\tx1680\tx2240\tx2800\tx3360\tx3920\tx4480\tx5040\tx5600\tx6160\tx6720\pardirnatural
 
\f0\fs22 \cf0 \CocoaLigature0 \
exportar MDB com mdbtools para linux\
\
mdb-schema inquerito_final.mdb | sed "s/Long Integer/int/" | sed "s/\\[//" | sed "s/\\]//" | sed "s/\\Text (.*)/varchar(250)/" | sed "s/Boolean/BIT(1)/" | sed "s/Numeric \\(.*\\)/int/"\
\
\
ESCOLHER APENAS AS TABELAS DESEJADAS\
\
\
mdb-export -I mysql inquerito_final.mdb INQUERITO | mysql -uroot inqueritos_201415_S2}
/branches/v3/impl/src/doc/siges/ModeloDeInformacaoPAE-EmVigor.docx
Cannot display: file marked as a binary type.
svn:mime-type = application/octet-stream
/branches/v3/impl/src/web/auth/index.jsp
15,7 → 15,7
</div>
</logic:notEmpty>
<div class="row">
<div class="col-sm-4">
<div class="col-sm-6">
<html:errors/>
<jomm:messages/>
<form role="form" action="<%=request.getContextPath()%><%=Globals.SYSTEM_REDIRECTIONS_POLICY_AUTHENTICATION_ACTION%>" method="post">