News:

You may pay someone to create your store, or you visit our seminar and become a professional yourself with the silver certification

Main Menu

[OBSOLETE] ordered by ordering (CSV import) REV 812

Started by iqapps1, April 18, 2007, 14:43:52 PM

Previous topic - Next topic

iqapps1

Hi


Check picture VM11_csv_config.jpg.This shows standard csv import ordeing fields.

If you make one csv file after that and upload you get simulation results...
Check picture VM11_csv_simul.jpg. This shows compering of #_vm_csv table and csv simulation.

You can see now sql query not ordering fields after filed_ordering as expeted. It ordering after field_id which results you csv import will be imported in wrong fields.

Siolution is to change line 55 in ps_csv from this

$q = "SELECT field_id,field_name,field_ordering,field_default_value,field_required FROM `#__{vm}_csv`";  
to this
$q = "SELECT field_id,field_name,field_ordering,field_default_value,field_required FROM `#__{vm}_csv` ORDER BY field_ordering ";

Comments please?
Regards
IQAPPS

[attachment cleanup by admin]