Import από .ods σε phpmyadmin version 3.3 +

published by spyros on Mon, 10/10/2011 - 20:12

It seems that Open Office automatically compresses the file in a format not compatible with phpmyadmin.

What you have to do is:

1. Save the file as ods.
2. After you have closed 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.

Tags:

Add new comment

More information about text formats

Filtered HTML

  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • To post pieces of code, surround them with <code>...</code> tags. For PHP code, you can use <?php ... ?>, which will also colour it based on syntax.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.