[OBSOLETE] CSV upload - no way to submit - VM 1.1 beta

[deneb]

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.

[iqapps1]

Hi Deneb

Which browser you use!?

you can see import now "button" in FF

Regards
IQAPPS

[attachment cleanup by admin]

[deneb]

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]

[deneb]

If I refresh the simulation page, I get warnings, BUT, the Import Now button appears!

Product Import Log section

Code Select Expand

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

CSV Upload Details / Analysis

Code Select Expand

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

[attachment cleanup by admin]

[iqapps1]

Hi
Rev 809
one more thing line 55 in ps_csv

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

Code Select Expand

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

Regards
IQAPPS

[iqapps1]

Hi

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



[attachment cleanup by admin]

[deneb]

Hi
Rev 809
one more thing line 55 in ps_csv

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

Code Select Expand

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

no help...same results

[iqapps1]

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

Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11

[iqapps1]

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

[deneb]

12 products

[deneb]

still no dice in any sort of browser. can't find code problems

I get:

Code Select Expand

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]

[macallf]

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

[aravot]

CSV import/export has been removed from VM 1.1 instead use http://www.csvimproved.com