When I try to import a CSV for projects, after I equate all the fields, on “next” i get a blank screen. I turned error reporting on and there is nothing in the log but browser shows:
“LBL_ACTION_ERROR”
Now I can’t even log back in.
Yes, I just reset all my permissions and still encounter this error. Has anyone encountered this and/or has successfully imported records into SuitCRM 8. (8.3.0)?
Update: Just upgraded to 8.6.1 same behavior, same issue with leads module. No errors generated. Nothing relevant in console or error log.
Update: same behavior in Chrome and Edge, but Firefox works???
I’ve just tested it and the import ran just fine.
On Projects, that was my first import now. On the more standard modules, I’ve ran quite a few imports on multiple 8.x versions.
If memory serves me well, I had an issue like this before multiple times.
I was able to re-login after restarting the web server (I thought it was an NGINX + some session related issue).
The problem went away, I think it was after an upgrade - maybe 8.4 to 8.5?
thanks @BastianHammer that was helpful. I was able to get past the point in the import dialoge with your file. I think the date formatting might be the issue. I have like 2010-11-23, but I’ve selected that format in the file properties so it shouldn’t be an issue. Also, normally if it doesn’t like a date format usually it proceeds and just doesn’t import the record.
I’m going to try and re-format my date fields see if that helps.
Update, changing the date fields doesn’t work either. I’m literally only importing “name” and “start_date” I made end date not required and still can’t get it to import. In Firefox it works up until the very last screen where it shows a summary that I get a blank screen on too. However, the import does happen.
I had issues with the date format before as well.
If you make the start date not required as well and import without it, I assume it works on Chrome as well?
Do you have any extensions enabled on Chrome?
It’s hard to imagine, but maybe something is messing up the local cache or similar there.
If you try it in the incognito mode, you still receive the same results?
Since it works with FF, it seems like SuiteCRM and the servers are ruled out as suspects.
It kind of, but not totally works in Firefox. I am able to get through the dialogue and import records, but the part where it asks you to choose a field on which to look for duplicates is empty (althought it could be just because I don’t have any unique fields designated, I’ll have to test that).
It’s weird because I can use your list in Chrome or Edge no problem, but my list only works in Firerfox. So I still don’t know if its a browser thing or a server side thing.
If you compare your and my list via an editor, do you see big differences (beside the date format)?
Encoding is UTF-8 as well?
I usually use LibreOffice Calc - Excel can probably do CSV but I find it a bit too fancy / more cumbersome than LibreOffice, maybe that’s worth a try.
(And I often export a test record first, open that file, add my records underneath and pay attention to pattern breaks from line one to following lines and then delete the first data-row before the import, but I assume you’ve got a similar approach?)
Arg!! This is so frustrating!!! I’ve done dozens of imports in SuiteCRM 7 without issue. Now I’m getting this error.
None of these values are in my CSV
I’ve completely removed all integer fields
It fails randomly, sometimes after 150 records, sometims 4xx, I got up to 9xx records once. I cant’ figure it out. I’m wondering if the strftime() function is a problem? Usually deprication issues don’t crash it out.
Wed Jul 24 16:56:26 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Implicit conversion from float 999.0000000000001 to int loses precision
Wed Jul 24 16:56:26 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Implicit conversion from float 501283.99999999994 to int loses precision
Wed Jul 24 16:56:26 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Implicit conversion from float 505785.00000000006 to int loses precision
Wed Jul 24 16:56:26 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Implicit conversion from float 508997.99999999994 to int loses precision
Wed Jul 24 16:56:26 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Implicit conversion from float 515584.00000000006 to int loses precision
Wed Jul 24 16:56:27 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Implicit conversion from float 127174.00000000001 to int loses precision
Wed Jul 24 16:56:29 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Implicit conversion from float 258504.99999999997 to int loses precision
Wed Jul 24 16:56:29 2024 [432729][a7fe2114-5472-2381-7c2a-6671ee2385e4][FATAL] Caught error: Function strftime() is deprecated
@pgr the issue is it’s on a client’s serve to which I don’t have access. I’m going to try checking the PHP memory limit first. The fact that it happens kind of randomly at different amounts of records imported kind of leads me to a memory issue. If not I’m going to have build a dev installation and see if I can import where I have access to the server on my own VPS.
