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

Title: [OBSOLETE] ordered by ordering (CSV import) REV 812
Post by: iqapps1 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]

Title: Re: ordered by ordering (CSV import) REV 812
Post by: aravot on October 19, 2007, 18:05:57 PM

Dev input needed.

Title: Re: [DEV INPUT NEEDED] ordered by ordering (CSV import) REV 812
Post by: aravot on January 11, 2008, 23:19:07 PM

CVS functionality has been removed from VM instead use http://www.csvimproved.com

VirtueMart Forum

VirtueMart Dev/Coding Central: VM1 (old version) => Quality & Testing VirtueMart 1.1.x => Virtuemart 1.1 Development (Archiv) => Q&T Resolved => Topic started by: iqapps1 on April 18, 2007, 14:43:52 PM