search

YetiForceCompany / YetiForceCRM

Our team created for you one of the most innovative CRM systems that supports mainly business processes and allows for customization according to your needs. Be ahead of your competition and implement YetiForce!
https://yetiforce.com
Other
1.72k stars 742 forks source link

Import doesn't work #8977

Closed maninvatsa closed 5 years ago

maninvatsa commented 5 years ago

Issue

I exported the accounts from the CRM and While Importing, It keeps failing. It happened many times. The real issue seems to be date but Date is of great importance for me. The accounts are sorted to the date of interaction. The date fields are exactly the way CRM exported and Yet it keeps failing. If i uncheck the Date as Mandatory value, The import works but there's no dates to the account which literally makes no sense.

Actual Behavior

Error importing. Records failed importing

Expected Behavior

The record should be imported because It was exported from the CRM and It's barely 1 accounts with two fields. Account name and Date.

How to trigger the error

yeti bs

Screenshot of configuration

screenshot 2018-12-19 at 00 31 06 screenshot 2018-12-19 at 00 32 10

PHP/Apache/Nginx/Browser/CRM Logs

Logs
Environment Version / Name
YetiForce 4.4
Web server Apache
PHP 7.2
Browser Mozilla, Chrome
Operating System Linux
Database MySQL
vovpff commented 5 years ago

Idea: replace your exported date to YYYY-MM-DD hh:mm:ss and try to import

adudekyeti commented 5 years ago

There was a problem with date format. In the newest version this bug is fixed.

cakrina commented 5 years ago

Just to add my 5 cents, I've noticed during import not only date format has to be YYYY-MM-DD but user settings for date format has to match YYYY-MM-DD and if it's not import will fail

maninvatsa commented 5 years ago

Just to add my 5 cents, I've noticed during import not only date format has to be YYYY-MM-DD but user settings for date format has to match YYYY-MM-DD and if it's not import will fail

This totally worked for me. Thanks @cakrina

apcloic commented 4 years ago

Bear in mind that YYYY-MM-DD is not available for all languages, at least it's not available in french. So first, you also have to change YF user language to English (United States), then you will be able to select YYYY-MM-DD date format before doing the import process. Quite boring but it's working ;)