Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
joomla25:auction:import_csv [2013/11/22 12:15] admin |
joomla25:auction:import_csv [2013/11/22 12:34] admin |
||
|---|---|---|---|
| Line 8: | Line 8: | ||
| \\ | \\ | ||
| 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.\\ | 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]].\\ | + | To help you even further to understand the structure of the CSV file, you can download {{:auction:auction_import_sample.csv|}}.\\ |
| - | \\ | + | \\ |
| + | |||
| + | |||
| + | ---- | ||
| + | |||
| + | More information available on our forum at: http://www.thefactory.ro/joomla-forum/auction-factory/sample-data-332.0.html | ||