Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Next revision Both sides next revision | ||
|
joomla25:auction:import_csv [2013/11/20 14:35] mircea created |
joomla25:auction:import_csv [2013/11/22 12:30] admin |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| To help you populate your database much more easier, you can use the **Import Auctions from CSV** feature. With it you can import data from the admin backend as a bulk upload, which will append the data to your existing database.\\ | To help you populate your database much more easier, you can use the **Import Auctions from CSV** feature. With it you can import data from the admin backend as a bulk upload, which will append the data to your existing database.\\ | ||
| \\ | \\ | ||
| - | To access this page go to **Components/Auction Factory/Tools** and click on **Import Auctions from CSV**, there you will find 2 fields which will allow you to upload a ".csv" file and an archive with images corresponding with the uploaded csv respectively.\\ | + | To access this page go to **Components/Auction Factory/Tools** and click on **Import Auctions from CSV**, there you will find 2 fields which will allow you to upload a ".csv" file and an archive with images corresponding with the uploaded csv respectively. This feature is also available on the frontend if enabled in the configuration, the import button will show on the **My Auctions** Page.\\ |
| \\ | \\ | ||
| {{gallery> joomla25:auction:importcsv.png }}\\ | {{gallery> joomla25:auction:importcsv.png }}\\ | ||
| \\ | \\ | ||
| - | These ".csv" files need to be written in a specific order and format to be eligible for upload and to have no errors since each value will be inserted in the database. Custom fields are not supported.\\ | + | These ".csv" files need to be written in a specific order and format to be eligible for upload and to have no errors since each value will be inserted in the database.\\ |
| - | It is very important that the information is separated by tab spacing and without a header row.\\ | + | It is very important that the information is separated by **tab spacing** and without a header row.\\ |
| \\ | \\ | ||
| - | The order of the fields found in database is defined by the "**tools.php**" file found on "components\com_bids\helpers".\\ | + | The CSV to DB field mapping can be seen in the **ImportFromCSV** function in the "**tools.php**" file found at "components\com_bids\helpers".\\ |
| - | To know exactly how the structure of the file must be, here is a list of the fields with their corresponding IDs and automatically how they should be ordered on the .csv file:\\ | + | To know exactly how the structure of the file must be, here is a list of the fields with their corresponding IDs and how they should be ordered on the .csv file:\\ |
| \\ | \\ | ||
| ^ ID ^ Name ^ Description ^ Example ^ | ^ ID ^ Name ^ Description ^ Example ^ | ||
| Line 36: | Line 36: | ||
| | 21 | Category | Name of one of the available categories | Electronics | | | 21 | Category | Name of one of the available categories | Electronics | | ||
| \\ | \\ | ||
| - | + | To help you even further to understand the structure of the CSV file, you can download [[this sample]].\\ | |
| + | \\ | ||