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:
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)
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:
- Select “Kimport” from the top menu “Components”. (click the image below to enlarge)
- Select the Excel file from the local computer. Then click “Save” on the top-right of the page. (click the image below to enlarge)
- If upload is succeed, you can see a information notification on the page. (click the image below to enlarge)
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.