Pleas keep in mind that SPAM will be deleted instantly
numerical fields
- francescaconte.comcast
- Topic Author
- Offline
Less
More
- Posts: 1
- Thank you received: 0
11 years 2 months ago #3348
by francescaconte.comcast
numerical fields was created by francescaconte.comcast
Hello,
I have set up a database with last names. The table is not showing any numerical values/columns, just text columns. Each person is assigned a bib number but the system is counting the excel line instead of the numerical assigned to each name. My database has first name, last name, number, city, state and age. The only ones that show up are last name, first name, city and state but no number or age.
Thank you for any help!
I have set up a database with last names. The table is not showing any numerical values/columns, just text columns. Each person is assigned a bib number but the system is counting the excel line instead of the numerical assigned to each name. My database has first name, last name, number, city, state and age. The only ones that show up are last name, first name, city and state but no number or age.
Thank you for any help!
Please Log in to join the conversation.
- d.hoeschen
-
- Offline
Less
More
- Posts: 1222
- Thank you received: 226
11 years 2 months ago #3398
by d.hoeschen
I am not really sure to understand you. Do you have Problems importing a excel-file?
What does that mean only text fields are displayed? If the are not imported correctly. Try to reformat the columns as standard text and change the column types after the import with a tool like phpmyadmin.
If you still have problems send us a example file via email with one address.
Replied by d.hoeschen on topic numerical fields
francescaconte.comcast wrote: My database has first name, last name, number, city, state and age. The only ones that show up are last name, first name, city and state but no number or age.
I am not really sure to understand you. Do you have Problems importing a excel-file?
What does that mean only text fields are displayed? If the are not imported correctly. Try to reformat the columns as standard text and change the column types after the import with a tool like phpmyadmin.
If you still have problems send us a example file via email with one address.
Please Log in to join the conversation.
Moderators: d.hoeschen, joest
