Hi,
thanks for your post, and sorry for the trouble.
From the error message, it appears that you are trying the XLSX importer. I suggest to use the CSV importer here. Also, you could try to increase the PHP Memory Limit, by following the instructions from https://codex.ww.wp.xz.cn/Editing_wp-config.php#Increasing_memory_allocated_to_PHP and setting a value like 512M.
How many rows and columns does the table have?
Regards,
Tobias
Installed 512M
when downloading XLSX:
Warning: simplexml_load_string(): (null)Entity: line 2: parser error : out of memory error in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/libraries/simplexlsx.class.php on line 721
Warning: simplexml_load_string(): c:dyDescent=”0.25″><c r=”A55360″ s=”3″><v>26865</v></c><c r=”B55360″ s=”2″ t=”s” in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/libraries/simplexlsx.class.php on line 721
Warning: simplexml_load_string(): ^ in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/libraries/simplexlsx.class.php on line 721
Warning: simplexml_load_string(): (null)Entity: line 2: parser error : out of memory error in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/libraries/simplexlsx.class.php on line 721
Warning: simplexml_load_string(): c:dyDescent=”0.25″><c r=”A55360″ s=”3″><v>26865</v></c><c r=”B55360″ s=”2″ t=”s” in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/libraries/simplexlsx.class.php on line 721
Warning: simplexml_load_string(): ^ in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/libraries/simplexlsx.class.php on line 721
Fatal error: Out of memory (allocated 523763712) (tried to allocate 72 bytes) in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/libraries/simplexlsx.class.php on line 721
when downloading CSV:
Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 72 bytes) in /home1/newdesig/public_html/mdevice.by/wp-content/plugins/tablepress/classes/class-import.php on line 428
Hi,
thanks for the further info. This indicates that the Excel importer (which is still experimental and not very robust) does not like something in the file 🙁
If however, the CSV import also complains, that indicates that the table is really big, so again: How many rows and columns does the table have?
Regards,
Tobias
Column: 12.
line: 148 840.
Hi,
ok, thanks. That kind of explains it. A table of that size is simply too big for TablePress to handle, I’m afraid.
TablePress is plugin that has been designed to make working with tables easier, but it’s by no means a database management system or anything like that. For large tables like that, you should really use a custom database solution, e.g. based on PHP and mySQL.
Regards,
Tobias
OK, I understand you, thank you
Hi,
you are very welcome. Sorry that I could not offer a solution here.
Regards,
Tobias
