Page 1 of 1
Import csv file to appery database
Posted: Mon Aug 26, 2013 6:42 pm
by Fabio Calabrot
I am trying to import the csv file to collection. In my opinion the system is very .......
I don ́t know how I will get to import it. I never have thought that I have lose this fight. Sorry! but the I am boring with it.
The other message show that the number of columns doesn ́t match.
Wrong column name: 'Data;Hora;Bairrocrime;RuaCrime;Tipo;Idade;Nome'. Column name should contain only alphanumeric characters or underscore and must begin with a letter.
Import csv file to appery database
Posted: Mon Aug 26, 2013 6:49 pm
by Fabio Calabrot
This alert is showed too.
Each import file line must contain the same number of columns as defined in header.
Import csv file to appery database
Posted: Mon Aug 26, 2013 6:53 pm
by maxkatz
Please post a sample file so we can try it. You can remove any sensitive data. A few sample rows will be fine.
Import csv file to appery database
Posted: Mon Aug 26, 2013 7:01 pm
by Fabio Calabrot
the new message
Wrong column name: 'Data;Hora;Bairrocrime;RuaCrime;Tipo;Idade;Nome'. Column name should contain only alphanumeric characters or underscore and must begin with a letter.
Import csv file to appery database
Posted: Mon Aug 26, 2013 7:31 pm
by Fabio Calabrot
How can I post a sample file?
Import csv file to appery database
Posted: Mon Aug 26, 2013 7:33 pm
by maxkatz
Just as text.. we need just a few rows.
Import csv file to appery database
Posted: Mon Aug 26, 2013 8:00 pm
by Fabio Calabrot
Data Hora Bairrocrime RuaCrime Tipo Idade Nome
02/01/2013 00:30 Beira Mar sem dados Homicídio 31 Alessandro de Siqueira Ribeiro
06/01/2013 00:30 Olavo Bilac sem dados Homicídio sem dados semdados
11/01/2013 11:28 Gramacho sem dados Homicídio Culposo sem dados Luana da Costa Ferreira
13/01/2013 02:40 Bar dos Cavaleiros sem dados Homicídio sem dados semdados
this is the csv file in excell exibition
Import csv file to appery database
Posted: Mon Aug 26, 2013 11:54 pm
by Alena Prykhodko