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

Image

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