Import FAQs from a spreadsheet -Failed

  • Resolved assobdpv

    (@assobdpv)


    8 years, 10 months ago

    Hi,
    I try to import FAQs from a spreadsheet but I got a 500 error.
    I simply export FAQ and try to import it in another wordpress (same version of wordpress and plugins).

    The file I try to import : http://doc.bdpv.fr/FAQ_Export.csv

    My Apache log :

    PHP Fatal error: Uncaught PHPExcel_Exception: Invalid character found in sheet title in /var/www/html/doc.bdpv.fr/fr/wp-content/plugins/ultimate-faqs/PHPExcel/Classes/PHPExcel/Worksheet.php:451\nStack trace:\n#0 /var/www/html/doc.bdpv.fr/fr/wp-content/plugins/ultimate-faqs/PHPExcel/Classes/PHPExcel/Worksheet.php(828): PHPExcel_Worksheet::checkSheetTitle(‘”,”Saisie produ…’)\n#1 /var/www/html/doc.bdpv.fr/fr/wp-content/plugins/ultimate-faqs/PHPExcel/Classes/PHPExcel/Reader/HTML.php(264): PHPExcel_Worksheet->setTitle(‘”,”Saisie produ…’)\n#2 /var/www/html/doc.bdpv.fr/fr/wp-content/plugins/ultimate-faqs/PHPExcel/Classes/PHPExcel/Reader/HTML.php(458): PHPExcel_Reader_HTML->processDomElement(Object(DOMElement), Object(PHPExcel_Worksheet), 6, ‘A’, ‘”,”Saisie produ…’)\n#3 /var/www/html/doc.bdpv.fr/fr/wp-content/plugins/ultimate-faqs/PHPExcel/Classes/PHPExcel/Reader/HTML.php(461): PHPExcel_Reader_HTML->processDomElement(Object(DOMElement), Object(PHPExcel_Worksheet), 6, ‘A’, ‘”,”Saisie produ…’)\n#4 /var/www/html/doc.bdpv.fr/fr/wp-cont in /var/www/html/doc.bdpv.fr/fr/wp-content/plugins/ultimate-faqs/PHPExcel/Classes/PHPExcel/Worksheet.php on line 451, referer: http://doc.bdpv.fr/fr/wp-admin/admin.php?page=EWD-UFAQ-Options&DisplayPage=ImportPosts&Action=EWD_UFAQ_ImportFaqsFromSpreadsheet

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • etoilewebdesign

    (@etoilewebdesign)

    8 years, 9 months ago

    Hi assobdpv,

    I just had a look at your exported spreadsheet and there is a whole bunch of HTML code in it. It looks like it’s just outputting the whole HTML code of a webpage. That would definitely explain why it isn’t importing. I noticed you use HTML in some of the fields in your FAQs. It could be that you didn’t close a div or something like that and it affected the whole sheet.

    For the import, try importing just a basic sheet with one question and no HTML code. Does it work?

    Thread Starter assobdpv

    (@assobdpv)

    8 years, 9 months ago

    Hi,
    I don’t know how to export only a basic sheet 🙁
    Or create a basic sheet.

    I install another wordpress with ultimate FAQ.
    Put only a simple faq : http://doc.bdpv.fr/en/index.php/ufaqs/essai-en-anglais/
    I made an export ….
    FAQ_Export.csv contains HTML 🙁
    Put the file here : http://doc.bdpv.fr/FAQ_Export.csv

    Don’t understand why !

    David

    etoilewebdesign

    (@etoilewebdesign)

    8 years, 9 months ago

    Hi David,

    We’re wondering if it’s maybe something specific to the version of PHP you’re using that causes function incompatibility with 2 different version of PHP. Can you tell us what version you are using for PHP please?

    Thank you

    Thread Starter assobdpv

    (@assobdpv)

    8 years, 9 months ago

    Hi EtoileWebDesign 😉

    I am using PHP7.0

    Could send you apache/php log if needed

    David

    etoilewebdesign

    (@etoilewebdesign)

    8 years, 9 months ago

    Hi David,

    We use a third party solution called PHPExcel to implement our import and export functionality. An error like this would normally mean that the version of PHPExcel being used isn’t up to date/doesn’t support the version of PHP you’re using. We update a while ago to ensure functionality with 7.0. I’m not quite sure why it would not be working right now. We’ll run a few tests and release an update with corrections if necessary.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Import FAQs from a spreadsheet -Failed’ is closed to new replies.