Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Data Export Products Rate Topic   - - - - -

 
  • albertpro
  • Member
  • Members
  • Join Date: 25-Nov 07
  • 118 posts

Posted 25 June 2018 - 06:51 PM #1

Hi,

I need help. I Upgrade 4.7.4 - 4.8.1 and I am having a problem, with the export result.

 

I just want to know if anyone has this problem.

 

I am using a certain export for updating inventory like always for years by using these fields

 

  • product id 
  • Language
  • Product code
  • Quantity
  • Availbility
  • Status
  • List Price
  • Price

After update I did export file in csv format like always, (and also tried in different format too the same problem)

 

it was an interesting result. there is a line break after certain line. I tried in my other website with cscart and I see the same result.

 

Is there anything we can do to resolve, this is very important and we need the data update.

 

I attached the excel files and I highliged Yellow the break lines.

 

Thank you

Albert

Attached Files


CS-CART: version 4.6.1


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11306 posts

Posted 25 June 2018 - 07:08 PM #2

Any formatting probably won't stick.  Maybe reference the product code in your data.

It looks like you have a non-escaped double-quote in the "Language" column for Product Doce 34 H0030.

Most likely this is an error in the Product code "34 H0030


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 

Posted 25 June 2018 - 07:31 PM #3

Hi,

I need help. I Upgrade 4.7.4 - 4.8.1 and I am having a problem, with the export result.

 

I just want to know if anyone has this problem.

 

I am using a certain export for updating inventory like always for years by using these fields

 

  • product id 
  • Language
  • Product code
  • Quantity
  • Availbility
  • Status
  • List Price
  • Price

After update I did export file in csv format like always, (and also tried in different format too the same problem)

 

it was an interesting result. there is a line break after certain line. I tried in my other website with cscart and I see the same result.

 

Is there anything we can do to resolve, this is very important and we need the data update.

 

I attached the excel files and I highliged Yellow the break lines.

 

Thank you

Albert

 

 

App/controllers/backend/exim.php

 

this may be problem: fn_define('DB_LIMIT_SELECT_ROW', 30);

 

change the value 30 to a lot higher number, clear cache and try again.


John Carroll
My Webshop: Alpha Spas

 
  • albertpro
  • Member
  • Members
  • Join Date: 25-Nov 07
  • 118 posts

Posted 25 June 2018 - 08:16 PM #4

App/controllers/backend/exim.php

 

this may be problem: fn_define('DB_LIMIT_SELECT_ROW', 30);

 

change the value 30 to a lot higher number, clear cache and try again.

 

Hi John,

Thank you so much, for the help I changed the 30 to 3000000 and it worked. 

 

I am sure that was something that changed during the update.


CS-CART: version 4.6.1


 
  • The Tool
  • Been Here Way Too Long Member
  • Members
  • Join Date: 30-Mar 07
  • 3801 posts

Posted 26 June 2018 - 03:58 AM #5

I haven't experienced the issue but fn_define('DB_LIMIT_SELECT_ROW', 30) has been in the code forever.  Why is it now causing an issue?



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11306 posts

Posted 26 June 2018 - 06:36 PM #6

Could be that the number of products has tipped the scale on how many can be processed within the Webservice timeout and increasing the number of rows processed on each request can lower that somewhat at the cost of some memory.  I personally think that going from 30 to 3 million rows is a bit much, but again, you're then just reading a bunch of data into memory and moving it between processes.  The exim stuff generally keeps everything in memory anyway.  However, this number dies influence (I think) when the data is sync'd to disk.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.