Author Topic: [OBSOLETE] ordered by ordering (CSV import) REV 812  (Read 3940 times)

iqapps1

  • Full Member
  • ***
  • Posts: 651
[OBSOLETE] ordered by ordering (CSV import) REV 812
« on: April 18, 2007, 14:43:52 pm »
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

Code: [Select]
$q = "SELECT field_id,field_name,field_ordering,field_default_value,field_required FROM `#__{vm}_csv`";  
to this
Code: [Select]
$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]