![]() ![]() ![]() Data too long for column 'services' at row 1īut I have checked and none of these are too long like the error msg says. Data too long for column 'sp_categories' at row 1 Data too long for column 'phone' at row 1 Data too long for column 'zipcode' at row 1 :-/ Here's that error output: Data too long for column 'in_business_since' at row 1 But frustratingly, when I import that version, I get entirely different errors. So I decided to take just the first 3,000 lines of it, save it out as a new csv, and to try to debug that since it's smaller. "An error occurred when reading the file, as it could not be read using the encoding you selected (Autodetect - Western (Windows Latin 1)). ![]() this, is a comma, separated, list of all, different things, about this customer 2006 A 123 Main St #4 VCA 123 Smallville California 12345 30.12345 -92.937672 4154151515 4157891010 Jan Smith 67 another,comma,separated,listĪnd this is the error I get when importing: this, is a comma, separated, list of all, different things, about this customer 2006 A 123 Main St #4 VCA 123 Smallville California 12345 30.12345 -81.889951 4154151515 4157891010 Jan Smith 67 another,comma,separated,listĮxample Customer One Mon 08.30 AM - 05.00 PM, Tue 08.30 AM - 05.00 PM, Wed 08.30 AM - 05.00 PM, Thu 08.30 AM - 05.00 PM, Fri 08.30 AM - 05.00 PM, Sat Closed, Sun Closed This is just a really long description and in this case it was only one thousand characters long, way shorter than the 8192 this field will allow. This is an example couple of entries (I had to change the data since it is private customer data): Example Customer One Mon 08.30 AM - 05.00 PM, Tue 08.30 AM - 05.00 PM, Wed 08.30 AM - 05.00 PM, Thu 08.30 AM - 05.00 PM, Fri 08.30 AM - 05.00 PM, Sat Closed, Sun Closed This is just a really long description and in this case it was only one thousand characters long, way shorter than the 8192 this field will allow. The csv has about 47,000 customer entries. ) ENGINE=InnoDB AUTO_INCREMENT=33298 DEFAULT CHARSET=latin1 `user_id` int(11) NOT NULL AUTO_INCREMENT, `has_been_initially_contacted` varchar(16) CHARACTER SET utf8 DEFAULT NULL, `sp_categories` varchar(1024) CHARACTER SET utf8 DEFAULT NULL, `num_of_reviews` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `website` varchar(254) CHARACTER SET utf8 DEFAULT NULL, `email_address` varchar(254) CHARACTER SET utf8 DEFAULT NULL, `last_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, ![]() `first_name` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `fax` varchar(45) CHARACTER SET utf8 DEFAULT NULL, `phone` varchar(45) CHARACTER SET utf8 DEFAULT NULL, `longitude` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `latitude` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `zipcode` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `state` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `city` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `address2` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `address1` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `rating` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `in_business_since` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `services` varchar(1024) CHARACTER SET utf8 DEFAULT NULL, `description` varchar(8192) CHARACTER SET utf8 DEFAULT NULL, `hours` varchar(255) CHARACTER SET utf8 DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 DEFAULT NULL, The table structure is: CREATE TABLE `sp_personal_info13` ( I'm importing with all the default options, encoding as latin1. I have a csv full of customer data, and am getting a number of errors when trying to import it into MySQL using Sequel Pro's Import function. ![]()
0 Comments
Leave a Reply. |