Fabio Calabrot
Posts: 0
Joined: Sun Aug 25, 2013 12:54 am

Import csv file to appery database

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.

Fabio Calabrot
Posts: 0
Joined: Sun Aug 25, 2013 12:54 am

Import csv file to appery database

This alert is showed too.

Each import file line must contain the same number of columns as defined in header.

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Import csv file to appery database

Please post a sample file so we can try it. You can remove any sensitive data. A few sample rows will be fine.

Fabio Calabrot
Posts: 0
Joined: Sun Aug 25, 2013 12:54 am

Import csv file to appery database

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.

Fabio Calabrot
Posts: 0
Joined: Sun Aug 25, 2013 12:54 am

Import csv file to appery database

How can I post a sample file?

maxkatz
Posts: 0
Joined: Fri Aug 13, 2010 3:24 pm

Import csv file to appery database

Just as text.. we need just a few rows.

Fabio Calabrot
Posts: 0
Joined: Sun Aug 25, 2013 12:54 am

Import csv file to appery database

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

Return to “Issues”