The errors show as follows: ( I will drop this CUVc into sample data and then if this does not fail, I will also drop ACTVc data into sample as the errors also shows there.) Last resort is to get the customer to tidy up - but they have a very large quantity


2018-02-20 15:55:58 Too long string during import: (212)686-5522 ext. 673 is longer than 20 register: CUVc nr: $100573 field: Phone NOT TRUNCATING
2018-02-20 15:56:30 Too long string during import: (212) 688-5444 (business) is longer than 20 register: CUVc nr: $101883 field: Phone NOT TRUNCATING
2018-02-20 15:56:52 Too long string during import: (816)360-6176(Mary-Accts) is longer than 20 register: CUVc nr: $102736 field: AltPhone NOT TRUNCATING
2018-02-20 15:57:39 Too long string during import: 01373 451500 (DIRECT = 458300) is longer than 20 register: CUVc nr: 102044 field: Phone NOT TRUNCATING
2018-02-20 15:57:51 Too long string during import: 01225 873145 (EX DIRECTORY) is longer than 20 register: CUVc nr: 102355 field: Phone NOT TRUNCATING
2018-02-20 15:58:10 Too long string during import: rachelgoodchild@blueyonder.co.uk is longer than 20 register: CUVc nr: 102783 field: Phone NOT TRUNCATING
2018-02-20 15:58:17 Too long string during import: talk2us@buglemedia.com is longer than 20 register: CUVc nr: 102891 field: Phone NOT TRUNCATING
2018-02-20 16:00:09 Too long string during import: (01481) 264302 + 266240 is longer than 20 register: CUVc nr: 104937 field: Phone NOT TRUNCATING
2018-02-20 16:00:12 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: CUVc nr: 105151 field: Phone NOT TRUNCATING
2018-02-20 16:00:15 Too long string during import: (0171)496-4000 & (O181)658-0712 is longer than 20 register: CUVc nr: 105342 field: Phone NOT TRUNCATING
2018-02-20 16:00:17 Too long string during import: 444544 DIRECT LINE: 476021 is longer than 20 register: CUVc nr: 105499 field: Phone NOT TRUNCATING
2018-02-20 16:00:19 Too long string during import: 020 7225 9801 (DIRECT LINE) is longer than 20 register: CUVc nr: 105673 field: Phone NOT TRUNCATING
2018-02-20 16:00:21 Too long string during import: 01225 383 459 (BUSINESS) is longer than 20 register: CUVc nr: 105806 field: Phone NOT TRUNCATING
2018-02-20 16:00:21 Too long string during import: 01747 850667 (EX-DIRECTORY) is longer than 20 register: CUVc nr: 105821 field: Phone NOT TRUNCATING
2018-02-20 16:00:24 Too long string during import: (0171) 2590047 (DAYTIME) is longer than 20 register: CUVc nr: 106234 field: Phone NOT TRUNCATING

2018-02-20 16:00:24 Too long string during import: 0171) 371 3111 (SHIRLEY .PA) is longer than 20 register: CUVc nr: 106237 field: Phone NOT TRUNCATING
2018-02-20 16:00:29 Too long string during import: OFFICE: 01249 822 422 is longer than 20 register: CUVc nr: 106532 field: Phone NOT TRUNCATING
2018-02-20 16:00:29 Too long string during import: 020 75354660+MOBILE:07775637117 is longer than 20 register: CUVc nr: 106539 field: Phone NOT TRUNCATING
2018-02-20 16:00:30 Too long string during import: 01225 526000 - GENERAL OFFICE is longer than 20 register: CUVc nr: 106679 field: Phone NOT TRUNCATING
2018-02-20 16:00:39 Too long string during import: 01225 526000 - GENERAL OFFICE is longer than 20 register: CUVc nr: 107177 field: Phone NOT TRUNCATING
2018-02-20 16:00:39 Too long string during import: 020 7 774 3582 (DIRECT) OR 020 7 774 1000 (SWITCHBOARD) is longer than 20 register: CUVc nr: 107213 field: Phone NOT TRUNCATING
2018-02-20 16:00:40 Too long string during import: Philip's 07775 636 395 is longer than 20 register: CUVc nr: 107257 field: Mobile NOT TRUNCATING
2018-02-20 16:00:43 Too long string during import: 01666 502381/07789 773995 is longer than 20 register: CUVc nr: 107464 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 20950 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 20997 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 20998 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 20999 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 21000 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 21001 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 21002 field: Phone NOT TRUNCATING
2018-02-20 16:03:20 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 21003 field: Phone NOT TRUNCATING
2018-02-20 16:03:23 Too long string during import: 01225 480762 OR 460762 is longer than 20 register: ActVc nr: 21633 field: Phone NOT TRUNCATING
2018-02-20 16:03:24 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 21832 field: Phone NOT TRUNCATING
2018-02-20 16:03:28 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: ActVc nr: 23125 field: Phone NOT TRUNCATING
2018-02-20 16:03:33 Too long string during import: CAROLINE: 0734 699967 is longer than 20 register: ActVc nr: 24779 field: Phone NOT TRUNCATING
2018-02-20 16:03:33 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 24816 field: Phone NOT TRUNCATING
2018-02-20 16:03:35 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: ActVc nr: 25270 field: Phone NOT TRUNCATING
2018-02-20 16:03:35 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: ActVc nr: 25507 field: Phone NOT TRUNCATING
2018-02-20 16:03:36 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 25593 field: Phone NOT TRUNCATING
2018-02-20 16:03:36 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: ActVc nr: 25736 field: Phone NOT TRUNCATING

2018-02-20 16:03:37 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 26038 field: Phone NOT TRUNCATING
2018-02-20 16:03:38 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 26050 field: Phone NOT TRUNCATING
2018-02-20 16:03:38 Too long string during import: 0171) 371 3111 (SHIRLEY .PA) is longer than 20 register: ActVc nr: 26237 field: Phone NOT TRUNCATING
2018-02-20 16:03:38 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 26324 field: Phone NOT TRUNCATING
2018-02-20 16:03:39 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 26539 field: Phone NOT TRUNCATING

2018-02-20 16:03:42 Too long string during import: CAROLINE: 0734 699967 is longer than 20 register: ActVc nr: 27252 field: Phone NOT TRUNCATING

2018-02-20 16:03:44 Too long string during import: OFFICE: 01249 822 422 is longer than 20 register: ActVc nr: 27939 field: Phone NOT TRUNCATING

2018-02-20 16:03:47 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: ActVc nr: 28517 field: Phone NOT TRUNCATING
2018-02-20 16:03:47 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 28709 field: Phone NOT TRUNCATING
2018-02-20 16:03:49 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 29245 field: Phone NOT TRUNCATING
2018-02-20 16:03:50 Too long string during import: 01225 383 459 (BUSINESS) is longer than 20 register: ActVc nr: 29309 field: Phone NOT TRUNCATING
2018-02-20 16:03:54 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 30523 field: Phone NOT TRUNCATING
2018-02-20 16:03:54 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: ActVc nr: 30524 field: Phone NOT TRUNCATING
2018-02-20 16:03:55 Too long string during import: 01225 526000 - GENERAL OFFICE is longer than 20 register: ActVc nr: 30796 field: Phone NOT TRUNCATING
2018-02-20 16:03:58 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 31383 field: Phone NOT TRUNCATING
2018-02-20 16:03:58 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 31476 field: Phone NOT TRUNCATING
2018-02-20 16:03:59 Too long string during import: CAROLINE: 0734 699967 is longer than 20 register: ActVc nr: 31754 field: Phone NOT TRUNCATING
2018-02-20 16:03:59 Too long string during import: CAROLINE: 0734 699967 is longer than 20 register: ActVc nr: 31755 field: Phone NOT TRUNCATING
2018-02-20 16:04:01 Too long string during import: 448 494 WORK (THRINGS & LONG) is longer than 20 register: ActVc nr: 32146 field: Phone NOT TRUNCATING
2018-02-20 16:04:03 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 32668 field: Phone NOT TRUNCATING
2018-02-20 16:04:10 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 34430 field: Phone NOT TRUNCATING
2018-02-20 16:04:11 Too long string during import: 01225 383 459 (BUSINESS) is longer than 20 register: ActVc nr: 34746 field: Phone NOT TRUNCATING
2018-02-20 16:04:11 Too long string during import: 01225 383 459 (BUSINESS) is longer than 20 register: ActVc nr: 34747 field: Phone NOT TRUNCATING
2018-02-20 16:04:16 Too long string during import: 01225 526000 - GENERAL OFFICE is longer than 20 register: ActVc nr: 35629 field: Phone NOT TRUNCATING
2018-02-20 16:04:16 Too long string during import: 01225 526000 - GENERAL OFFICE is longer than 20 register: ActVc nr: 35630 field: Phone NOT TRUNCATING
2018-02-20 16:04:16 Too long string during import: 01225 526000 - GENERAL OFFICE is longer than 20 register: ActVc nr: 35793 field: Phone NOT TRUNCATING
2018-02-20 16:04:16 Too long string during import: 01225 526000 - GENERAL OFFICE is longer than 20 register: ActVc nr: 35794 field: Phone NOT TRUNCATING
2018-02-20 16:04:20 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 36610 field: Phone NOT TRUNCATING
2018-02-20 16:04:29 Too long string during import: 01225 383 459 (BUSINESS) is longer than 20 register: ActVc nr: 38863 field: Phone NOT TRUNCATING
2018-02-20 16:04:29 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 38918 field: Phone NOT TRUNCATING
2018-02-20 16:04:33 Too long string during import: 0207 730 6775 LORD AIRLIE'S OFFICE(LONDON): is longer than 20 register: ActVc nr: 40007 field: Phone NOT TRUNCATING
2018-02-20 16:04:38 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 41153 field: Phone NOT TRUNCATING
2018-02-20 16:04:41 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 41971 field: Phone NOT TRUNCATING
2018-02-20 16:04:55 Too long string during import: 01963 440344 (AND FAX) is longer than 20 register: ActVc nr: 45613 field: Phone NOT TRUNCATING