Not able to download duplicates or rows with errors using Import function

👨‍💻 Development Help
1

Dear Friends,

I am not able to download CSV file(s) after importing in Accounts. I think this is the same with all modules probably. It simply throws Error 500 or something with no suitecrm display.

I am in urgent need of importing around 10000 records and I am expecting there would be many error in importing. I would surely need to download these CSV.

Please leaving instructions to solve this or guide me.

With thanks,

RK

(just updated to lastest version of SuiteCRM)

2

If you have a 500 error you should have more clues in php_errors.log or suitecrm.log

It could be just an issue with the size of the import, check these settings in php.ini:

memory_limit
max_execution_time
max_upload_size

3

Hello pgr,

I could observe that the error or duplicates CSVs are being generated.

I also created a php.ini at the root of public_html:

; cPanel-generated php ini directives, do not edit
; Manual editing of this file may result in unexpected behavior.
; To make changes to this file, use the cPanel MultiPHP INI Editor (Home >> Software >> MultiPHP INI Editor)
; For more information, read our documentation (https://go.cpanel.net/EA4ModifyINI)

allow_url_fopen = On
allow_url_include = Off
asp_tags = Off
display_errors = On
enable_dl = On
file_uploads = On
max_execution_time = 30
max_input_time = 60
max_input_vars = 1000
memory_limit = 256M
session.gc_maxlifetime = 1440
session.save_path = "/tmp"
upload_max_filesize = 32M

Then clicking on any of the link shown by SuiteCRM threw the following error at me:

Fatal error: Uncaught Error: Call to undefined function mime_content_type() in /home2/luminisi/public_html/SuiteCRM/download.php:180 Stack trace:
#0 /home2/luminisi/public_html/SuiteCRM/include/MVC/Controller/SugarController.php(1014): require_once()
#1 /home2/luminisi/public_html/SuiteCRM/include/MVC/Controller/SugarController.php(465): SugarController->handleEntryPoint()
#2 /home2/luminisi/public_html/SuiteCRM/include/MVC/Controller/SugarController.php(373): SugarController->process()
#3 /home2/luminisi/public_html/SuiteCRM/include/MVC/SugarApplication.php(109): SugarController->execute()
#4 /home2/luminisi/public_html/SuiteCRM/index.php(52): SugarApplication->execute()
#5 {main} thrown in /home2/luminisi/public_html/SuiteCRM/download.php on line 180

Kindly guide me as to know what to do next.

With thanks,

RK

4

I made further experiments.

I removed the both php.ini from webserver home root and from public_html. Thus, the php related status-quo was re-gained.

Then I attempted to import again. None of the CSV-files could be downloaded.

However, I also observed the following in SuiteCRM.log:

Fri May  4 10:23:51 2018 [28440][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteP/modules is not a file or a dir.



Fri May  4 10:28:52 2018 [44138][1][FATAL] Caught error: stat(): stat failed for upload/import/error_1.csv
Fri May  4 10:28:52 2018 [44138][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Fri May  4 10:28:52 2018 [44138][1][FATAL] Caught error: stat(): stat failed for upload/import/status_1.csv
Fri May  4 10:28:52 2018 [44138][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!

Kindly guide.

RK

5

Dear PGR,

Your suggestion in some another post-reply gave me a hint, i.e., enabling ‘fileinfo’ in php-setting.

Once done, I could download both CSV files. This part of the problem I was facing is over.

However, there is still some error in importing the records, as

How to solve this problem?

With thanks,

RK

6

I think you’re using an old version of SuiteCRM… are you?

Some old bugs had this error message, they happened when you’re triyng to import a CSV that has a dropdown field, but the values you’re entering don’t match any value in the dropdown.

7

Dear pgr,

2-days before I have updated it to SuiteCRM 7.10.4.

Fun part is that CSV which I am trying to upload is meant for experimenting in order to get download CSV works. I actually selected 2-records from leads module, then got those exported in a csv file. Then I am keeping 1-record as it is, and adding a blank space at the end of email_1 of another record. I am not making any change to the dates related columns, at all.

Then I go through the import-process of the same. None of the records gets imported.

Kindly have a look at the CSV of rows which has errors, i.e., errorecordsonly_1.csv

Please guide further.

RK

(I am not able to attached any file today here. I don’t know why?

8

Friends,

I could find the following entry in suitecrm.log:

Fri May  4 07:30:41 2018 [254704][1][DEBUG] Localization: translating [<b>Error</b> Invalid datetime <br/><b>Field Name</b> Date Created (date_entered) <br/><b>Value</b> 5/9/2017 4:47 <br/>] from UTF-8 into UTF-8

How to solve this?

With thanks,

RK

9

When importing, in the Wizard, there is a button to “Show details” or “Show preferences” or something like that. Inside that, you can select date formats and other details.