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: deneb on April 16, 2007, 20:39:23 PM

Title: [OBSOLETE] CSV upload - no way to submit - VM 1.1 beta
Post by: deneb on April 16, 2007, 20:39:23 PM
I try to do a CSV upload. The simulation page comes up fine with my good data, now I want to submit, but there is no way to continue....

What is supposed to be available to execute the CSV upload after sim? buttons, text link, am I blind?

This happens in Basic or Extended layout mode in VM admin.
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: iqapps1 on April 16, 2007, 20:48:07 PM
Hi Deneb

Which browser you use!?

you can see import now "button" in FF

Regards
IQAPPS

[attachment cleanup by admin]
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: deneb on April 16, 2007, 22:33:12 PM
Hey iqapps
FF, of course:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3

I've got java and javascript on

hmm...

[attachment cleanup by admin]
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: deneb on April 16, 2007, 22:35:03 PM
If I refresh the simulation page, I get warnings, BUT, the Import Now button appears!

Product Import Log section
Warning: Invalid argument supplied for foreach() in /xxxxxxx/xxxxxxxxx/administrator/components/com_virtuemart/html/product.mycsv.php on line 103

CSV Upload Details / Analysis
Warning: Invalid argument supplied for foreach() in /xxxxxxx/xxxxxxxxx/administrator/components/com_virtuemart/html/product.mycsv.php on line 91

[attachment cleanup by admin]
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: iqapps1 on April 16, 2007, 22:51:52 PM
Hi
Rev 809
one more thing line 55 in ps_csv

Can you change to this and test.....

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

Regards
IQAPPS
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: iqapps1 on April 16, 2007, 22:56:43 PM
Hi

I get this in IE7 when I try to start vm admin.



[attachment cleanup by admin]
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: deneb on April 17, 2007, 00:38:01 AM
Quote from: iqapps1 on April 16, 2007, 22:51:52 PM
Hi
Rev 809
one more thing line 55 in ps_csv

Can you change to this and test.....

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


no help...same results
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: iqapps1 on April 17, 2007, 00:44:46 AM
Hi

That code not helping to your error but to ordering of db fields.


I tryed to replicade you  error but I can't ....

IQAPPS

My browser
QuoteMozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: iqapps1 on April 17, 2007, 00:56:01 AM
Hi again!

I get some other warnings  when I imoprt csv file....
How manu product you have in your csv file....if chase is les at 300 you need to change this on line 114 in ps_csv.php to maybe 10...it worked for me......


Regards
IQAPPS
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: deneb on April 17, 2007, 01:04:50 AM
12 products
Title: Re: CSV upload - still no way to submit - VM 1.1 beta
Post by: deneb on April 18, 2007, 01:59:13 AM
still no dice in any sort of browser. can't find code problems

I get:
No errors found during CSV import simulation.

BUT NO 'IMPORT' button

i'm positive that my CSV is good and I am selecting the appropriate items before upload.

Broken....Back to the drawing board guys.....on the whole backend it seems!

[attachment cleanup by admin]
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: macallf on April 18, 2007, 02:43:21 AM
ps_csv sets the form var csv_import_finished

if( md5( $mosConfig_secret.$d['csv_file']) == $d['csv_filenamehash']
      && $d['csv_start_at'] + $d['csv_lines_to_import'] >= $d['total_lines'] ) {
         unlink( $d['csv_file'] );
         $d['csv_import_finished'] = '1';
      }

If not mistaken that is saying if the secrets match and the start product + lines to import >= total lines then delete the file and set finished to 1 being an error.

This i tracked down to the import simulation not copying the lines processed back to the function.

I added this to line 810 just before the return true

if($simulate) {
            $d['csv_lines_to_import'] = $d['csv_lines_processed'];
        }

See if that helps, Mark
Title: Re: CSV upload - no way to submit - VM 1.1 beta
Post by: aravot on January 22, 2008, 20:59:26 PM
CSV import/export has been removed from VM 1.1 instead use http://www.csvimproved.com