ajnyga / tsvConverter

Excel to OJS3 XML conversion tool
GNU General Public License v3.0
17 stars 12 forks source link

Memory allocation failed : growing buffer #6

Closed josuevalrob closed 6 years ago

josuevalrob commented 6 years ago

I have an excel file with 4 lines.
180.xlsx

After convert it to XML and try to import it it got this:

Validation errors: Memory allocation failed : growing buffer Memory allocation failed : growing buffer The document has no document element.

If i just remove one line, and convert the file, i got this:

The import completed successfully. The following items were imported: Vol 180 (2015): Ingeniería Civil

I dont know what is the problem, if it is with the ojs (i have try it in multiple sites) or the convert.php.

Now imagine if i want to upload 1200 lines...

Thanks for your help!

ajnyga commented 6 years ago

I guess there is an error in the XML, not sure what it is. I will do some work on this probably tomorrow so I can take a look.

The largest import I have made had over 600 articles, so that should not be a problem.

josuevalrob commented 6 years ago

The xml is really weird... I can send you both via email.

ajnyga commented 6 years ago

Sure It could be that the style changes (grey background etc.) you have made to the excel sheet is affecting the result in some way.

josuevalrob commented 6 years ago

Okey i clean it. But the still the problem.

ajnyga commented 6 years ago

As I mentioned in the other threat I was able to convert both the smaller and the larger xls file you sent me by email. I did fix a couple of small things in the script but those did not affect the actual result.

I have a feeling that the memory error in the actual XML import in the OJS end has something to do with the very large memory limit you mentioned on the forum. You should use a value like 256M or 512M or even less depending on your server. I think you had something like 256000M. I was able to import the XML files generated from the larger xls file with 128M.

josuevalrob commented 6 years ago

Okey, i will check my xampp configurations

josuevalrob commented 6 years ago

Was a problem with the memory_limit in php.