Howto: Import data from Excel to joomla table using Kimport v1.5.0

After proper installation of Kimport component for joomla 1.5.x, you can try to manage the data using this component.

There is something you need to do before uploading the excel file to the component. The most important step to do is mapping the data columns to the excel columns. For instance, you probably have a table like this:

example data table

You can read the data structure by typing “describe [your-table-name]” on the command line or GUI-based mysql admin tools. Then you may now construct your excel file. Create a Excel file in Office 2003 (note that Kimport currently recognizes Excel2003), the paradigm of the excel file should look like: (Click the picture to enlarge the picture below)

excel file with a proper paradigm

You can see that the first column of the Excel is reserved to further use,  then the first row have to be IDENTICAL with the columns’ name of your data table. The second row is the data type property of the column. For instance, product_sku should be string, so the data type is written “string”.

Okay, now you know that the excel’s paradigm is to map the data meta information of the actual data table. The yellow high-lined part of this excel means the reserved information. Please also note the “sheet name” below. The sheet name should be the EXACTLY same as the table’s name. After the excel file is prepared, you can proceed to upload the file to the component.

Two steps are need to perform upload:

  1. Select “Kimport” from the top menu “Components”. (click the image below to enlarge)
    step 1
  2. Select the Excel file from the local computer. Then click “Save” on the top-right of the page. (click the image below to enlarge)
    step 2
  3. If upload is succeed, you can see a information notification on the page. (click the image below to enlarge)
    step 3

Easy, huh? But Still need to keep in mind when you arrange the Excel data:

  • The first column of the excel file is reserved.
  • The first row without the first column is mapped to the columns’ name of the data table.
  • The second row without the first column is the data type of the column
  • The sheet name of the excel file should rename to the EXACT name of the data table.

25 thoughts on “Howto: Import data from Excel to joomla table using Kimport v1.5.0”

  1. I’ve followed your instructions but get this result. Any suggestions.

    Succeesfully imported 0 rows[3]

  2. Seems that your excel is not correct. But did you try the newly post version? I updated on google app host, please get the newly code. If import failed, there will be more hints to help you out.

  3. i too followed the steps. >Succeesfully imported 0 rows[3][4][5][6][7][8][9][10][11][12][13]

    the steps are not that clear. do i have to create a data base table or something? im confused about “mapping the data” part. and how to output the imported data. if you can elaborate on this that would be greatly appreciated. more power.

  4. Thanks for you kindly reply…Those days my server is down and the site has been a long time not under administration. Shame on me…

  5. when i import the Excel file , i am getting Succeesfully imported 0 rows[3][4] .. I have created a Table in my database with the data column names .. Is that correct. But nothing has been imported to the table . Pls clarify the doubt..

  6. Please note that the version of Excel is 2003, not 2007.(*.xlsx is currently not supported yet)

    Please also note that, column 1 should never contain any content. Row 1 and row 2 are used for meta data (I call them metadata, they are just the mapping description)

    Again, the sheet name should be the table name. Exactly the same table name.

    Last, if you ignore any error information of the web server, you may not be able to see the error message.

  7. Hi
    I am learning to build a Joomla Website. My data is mainly tabular data formatted in Excel. I found your Kimport 1.5 article whihe seaching for how to import Excel data into Joomla.
    I downloaded the Kimport zip file but got the following error when trying to add it to my Joomla site:
    JInstaller::install: File ‘C:\wamp\www\mywebsite\tmp\install_4bb758dcc536b\administrator\components\com_kimport\tempdata\readme.txt’ does not exist.
    Can you tell me how to resolve this?

    Many thanks
    Tony

  8. Can you just extract the zipped file, and then edit kimport.xml, after that, remove line 19. tempdata/readme.txt, Then zip the whole lot again.

    Sorry about this mistake. The error doesn’t show up before. I think newer version of Joomla strictly interprets the component’s configuration file.

  9. Thank you – I’m not too sure how to edit the xml file. I tried to delete the line but could not do it. I will do some research on how to edit xml files and give it a try.
    Thanks for your help.
    Tony

  10. i installed KImport and it installed successfully but when i upload my excel document, after i click ‘save’, it shows me this error report: “Catchable fatal error: Object of class PHPExcel_RichText could not be converted to string in C:\xampp\htdocs\joomla15\administrator\components\com_kimport\admin.kimport.php on line 113″.
    What is going on? Pleaseeeee Help.

  11. Hello i have a fetal error it says

    Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 11 bytes) in C:\wamp\www\joomlaexcel_15\administrator\components\com_kimport\classes\PHPExcel\Style\Color.php on line 278

    so what should i do

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">