 |
 |
Another problem could be that your separator, usually a comma, is present in a text field that is not delimited by quotes, making that field into 2 fields giving you an extra column in that row. Will Will William G. Cowan ________________________________ From: Code for Libraries <[log in to unmask]> on behalf of Max <[log in to unmask]> Sent: Monday, January 16, 2023 7:22:29 PM To: [log in to unmask] <[log in to unmask]> Subject: [External] [CODE4LIB] "The rows are not all the same number of columns." [Some people who received this message don't often get email from [log in to unmask] Learn why this is important at https://aka.ms/LearnAboutSenderIdentification ] This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources. ------- Hi code4lib folks: Does anyone know a tool or hack to help fix a problem at a CSV that's causing a "The rows are not all the same number of columns." error when trying to import the CSV at a web application? I'm trying to use the CSV Import module <https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fomeka.org%2Fs%2Fdocs%2Fuser-manual%2Fmodules%2Fcsvimport%2F&data=05%7C01%7Cwgcowan%40iu.edu%7C98d9cc93c4fa41a28a7e08daf82183c8%7C1113be34aed14d00ab4bcdd02510be91%7C0%7C0%7C638095120077267200%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=PjRN47Tr82ap7rllK%2FKDSiSDKXbzxyqkGzpNWaqX%2BRU%3D&reserved=0> at Omeka S. I've had success in the past with different CSV files. But some kinda problem at the CSV I'm trying to import right now is causing this error, & reviewing the CSV in Excel & as plain text (literally counting commas to confirm rows are the same number of columns) isn't helping. Thanks! Cheers all, Max Maxwell Gray https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmaxgray20.com%2F&data=05%7C01%7Cwgcowan%40iu.edu%7C98d9cc93c4fa41a28a7e08daf82183c8%7C1113be34aed14d00ab4bcdd02510be91%7C0%7C0%7C638095120077267200%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=9Y%2FNtdNU1c%2Bj%2BXvPrugoNWpvafhKCES4Sd5rK1yiu%2Bg%3D&reserved=0