RMD27 Posted October 11, 2011 Share Posted October 11, 2011 editing the category descripition table with the import export function in phpmyadmin has anyone tried to do this using .ods file formats? I have tried this method and I get no joy whatsoever. 1. Save the file as ods.2. After you close the file from the Open Office Calc, rename it from .ods to .zip. 3. Open the zip file and uncompress (export) the content.xml 4. Rename it from .xml to .ods 5. Compress it to .gz with 7zip application. It is free and you can get it from: http://www.7-zip.org/download.html 6. Make sure the file is named as content.ods.gz 7. Import the file with phpmyadmin. Most of the times you have to choose utf8 encoding but that really depends on your database tables format. I need to edit the descriptions in bulk and using a spreadsheet is the only way of doing. If anyone has any experience of importing with phpmyadmin with .ODS file formats please feel free to chime in Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.