Import Error

💬 General Discussion
1

I am noticing when I use the import wizard or for that matter any of the import functions it is importing but two things are occurring.

  1. I am not getting the results of the import (the results screen is blank without option to apply to a list or to download errors, or see duplicates, etc.)
  2. If I am doing an update import (i.e. updating existing field) the updates are not being saved
  3. I am getting the following in the suitecrm log Wed Nov 29 11:11:20 2017 [20172][417c568b-11f2-09c8-e80f-568edd882378][FATAL] Caught error: stat(): stat failed for upload/import/error_417c568b-11f2-09c8-e80f-568edd882378.csv
    Wed Nov 29 11:11:20 2017 [20172][417c568b-11f2-09c8-e80f-568edd882378][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
    Wed Nov 29 11:11:20 2017 [20172][417c568b-11f2-09c8-e80f-568edd882378][FATAL] Caught error: Function create_function() is deprecated

The function is deprecated repeats I suspect for all the records on the attempt to upload.

SuiteCRM 7.9.7
PHP7

Any thoughts, on what is causing this or how to fix this?

2

I’ve never seen this error, but it looks similar to this
https://suitecrm.com/forum/suitecrm-7-0-discussion/9197-import-fails-stat-touch

I don’t know if the proposed solution there, fixed the problem or not.

I would also check the permissions on the upload directory, and perhaps change also the default_permissions settings in config.php

3

@prg I don’t think it is the same, but it was helpful. Thanks. I check all the items reference and my settings are ok. But I did find out why it was erroring -my data is erroring because I tried to import a contact ID which already existed as that Is what I thought I could match on.

My bad. I needed to choose email instead and tried again, but what I am talking about is the last display screen that shows you the errors, duplicates and such. It never displays so I don’t really know if the data was imported.

The earlier example had a hiccup because I thought I was matching on contact ID but in fact, since it already existed it errored out. Which makes sense. When I attempted the second time I matched on email instead and since I was trying to append update information I am ok with the duplicates so just update. The issue is that it never goes in, and the update last page never displays. Only a blank screen.

It seems like it is with the import process in general.

here is the only error in suite CRM log from the second attempt.

Wed Nov 29 14:59:41 2017 [9858][417c568b-11f2-09c8-e80f-568edd882378][FATAL] Caught error: stat(): stat failed for upload/import/status_417c568b-11f2-09c8-e80f-568edd882378.csv
Wed Nov 29 14:59:41 2017 [9858][417c568b-11f2-09c8-e80f-568edd882378][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!

My understanding is that 1. can use the import and update to update data that matches. and 2. you should get a results page upon importing where you can apply the target list, review the duplicates, errors and cancel the import. Correct? it is this page that is not displaying.

I will attempt a simple new record import to see if it is just the import function.

Any other thoughts?

4

Are you also checking php_errors.log, or whatever your web server log is called?

There should be no blank screens - those are PHP fatal errors (a different thing from SuiteCRM fatal errors), and they should produce a useful message on the PHP log.