Attachment ha389e0d.zip not found
Please keep in mind that the XLS-Import is very limited. Because every import must guess the format of a field the table normally needs to be corrected afterwards.
The import also replaces the whole TABLE. It is not possible to import and append single sheets.
Version 3.0 will have a non destructive and advanced import-function which let you choose the field-type and relation.
I added an example. As you see. JooSet all fields with text to TEXT. That is not optimal.
Name, Title e.g. should be Varchar. Neme should have an Index. Speciality should be an ENUM or SET-Field so you can select.
You should use PHPMyAdmin or other tools to change your table afterwards.
See example
CREATE TABLE IF NOT EXISTS `Actors` (
`published` tinyint(1) NOT NULL DEFAULT '1',
`id` int(12) NOT NULL DEFAULT '0',
`First_name` varchar(128) DEFAULT NULL,
`Last_name` varchar(128) DEFAULT NULL,
`Title` varchar(254) DEFAULT NULL,
`Institution` varchar(254) DEFAULT NULL,
`Specialty` enum('Western','Comedy','Scify','Drama') DEFAULT NULL,
`Curriculum_Vitae` text,
PRIMARY KEY (`id`),
KEY `Last_name` (`Last_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin2;
