Forums - Thread Details
  • State Not Answered
  • Replies 10 replies
  • Subscribers 319 subscribers
  • Views 1901 views
  • Users 0 members are here
Forum Actions
Related

Invalid File Path When Importing Targets Error

Dan Petersen

We recently upgraded from Sugar 8.0.2 to 9.0.2. We have started to notice a new error when importing targets. Whenever you change the field mapping during the import the screen turns white after clicking import targets. We checked our error logs and found the message below. Does anyone know of a permanent solution for this? In the mean time we are just fixing the import file headings to they map automatically when importing.

Sugar Version: Professional 9.0.2

Exception in Controller: Sugarcrm\Sugarcrm\Security\InputValidation\Exception\ViolationException: Invalid file path in /var/www/html/sugar/modules/Import/sources/ImportFile.php:103
Stack trace:
#0 /var/www/html/sugar/modules/Import/views/view.last.php(157): ImportFile->__construct('upload://import...', ',', '"', false, false)
#1 /var/www/html/sugar/modules/Import/views/view.last.php(114): ImportViewLast->getListViewTableFromFile('upload://import...', 'dup')
#2 /var/www/html/sugar/include/MVC/View/SugarView.php(153): ImportViewLast->display(Array)
#3 /var/www/html/sugar/include/MVC/Controller/SugarController.php(350): SugarView->process(Array)
#4 /var/www/html/sugar/include/MVC/Controller/SugarController.php(298): SugarController->processView()
#5 /var/www/html/sugar/include/MVC/SugarApplication.php(199): SugarController->execute()
#6 /var/www/html/sugar/index.php(27): SugarApplication->execute()
#7 {main}

Thanks,

Dan

Parents Reply Children
  • 0 in reply to Dan Petersen

    Hi Dan,

    This code is invoked to generate the Duplicate and Errors tabs on the import confirmation page. I tried a few tests on my own but I was unable to reproduce the issue. I tried the following:

    - Importing a CSV with a header row

    - Importing a CSV with no header row and all records successfully imported

    - Importing a CSV with no header row and some records reported as duplicate

    - Importing a CSV with no header row and some records reported as error

    Under each scenario, the confirmation page was displayed as expected and the Duplicate and Error tabs showed their information as expected. Please provide some more details about the file you typically try to import, and we may be able to identify the proper steps to reproduce the issue:

    1. Is file a CSV or is it delimited by some other means (e.g. tab)?
    2. Does the file contain a header row?
    3. If the file does not contain a header row, does step 3 of the import process properly identify that no header row was found above the data examples?

    Thanks!

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year