On Tue, Nov 13, 2012 at 9:25 AM, Ian Whitfield <[email protected]>wrote:
> Hi All > > My saga continues with getting Base to work with MySQL!! I am almost there > but our "friend" Murphy has caught me yet again. > > After a MAJOR battle I managed to get all my data out of the old HSQL > Database. If I tried to extract it all in one go Base either froze or > crashed. So I added a select function to pull out all the 'As", the 'Bs' > etc etc and that worked. I then concatenated all the Data in Calc and spent > a few days cleaning it all up. > > Right final step - to INSERT it into the already prepared SQL Databse, > (created using My Admin). I tried the SQL scripts in a terminal for well > over a day with no results except error messages. While Googling about this > I came across a tutorial on how to do this with MyAdmin so decided to go > that route. > > After several hiccups due to differences in Field Names all seemed to be > right but do what want I can not get past the error "Invalid column count > in CSV input on line 1." I have tried everything I can think of and tried > all the "answers" I found after lots of Googling but the problem remains!! > > Does anyone know what causes this error or better how to fix it?? > > ANY help would be appreciated > > IanW > Pretoria RSA > > > Ian , The error means your columns should be listed on line 1 or the column count does not match the columns within the database. This does not sound like a LibreO issue but a issue between your CSV files and Mysql. -- -- Masekela Walls Web Security Analyst | Senior Server Administrator Powserve.com / Gemini ISP Networks -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
