I created a report of my contacts, including the ID, Firstname, Lastname, etc. I then modified this data in Excel and saved it as a tab delimited file. I then attempt to upload it again and am matching all the columns with existing columns. I have not chosen anything to check for duplicates (only have the first name, last name and name available).
I then get an Import Error dialog box with a whole heap of SQL code, but nothing more. Code like the following (abbreviated) excerpt:
SELECT accounts.account_type from accounts WHERE accounts.id='8eb4d5f8-551f-0429-7d86-552c287af35d' and accounts.deleted=0update contacts_cstm set accounttype_c='' WHERE id_c='66df808e-5808-790d-3574-552c280c34ff'SELECT accounts.name from accounts WHERE accounts.id='8eb4d5f8-551f-0429-7d86-552c287af35d' and accounts.deleted=0persistentsys.comupdate contacts_cstm set account_name_hidden_c='persistentsys.com' WHERE id_c='66df808e-5808-790d-3574-552c280c34ff'SELECT accounts.account_type from accounts WHERE accounts.id='5b1cbbed-
Anyone have any ideas how I can get this data to be loaded back into SuiteCRM?
I think you abbreviated too much. I would prefer to see the full SQL query, and the error it gives, and the complete Stack trace, if there is one (lines beginning #0, #1, etc)
Thanks for the reply. Here is the full text of the Import Error. I am sorry, but I don’t know how to get the Stack trace. Thanks heaps for your help, John
SELECT accounts.account_type from accounts WHERE accounts.id='8eb4d5f8-551f-0429-7d86-552c287af35d' and accounts.deleted=0update contacts_cstm set accounttype_c='' WHERE id_c='66df808e-5808-790d-3574-552c280c34ff'SELECT accounts.name from accounts WHERE accounts.id='8eb4d5f8-551f-0429-7d86-552c287af35d' and accounts.deleted=0persistentsys.comupdate contacts_cstm set account_name_hidden_c='persistentsys.com' WHERE id_c='66df808e-5808-790d-3574-552c280c34ff'SELECT accounts.account_type from accounts WHERE accounts.id='5b1cbbed-74c9-2125-23c0-552c2966e191' and accounts.deleted=0update contacts_cstm set accounttype_c='' WHERE id_c='acb5382e-e1f4-4a99-4e7e-552c29837dd6'SELECT accounts.name from accounts WHERE accounts.id='5b1cbbed-74c9-2125-23c0-552c2966e191' and accounts.deleted=0infosys.comupdate contacts_cstm set account_name_hidden_c='infosys.com' WHERE id_c='acb5382e-e1f4-4a99-4e7e-552c29837dd6'SELECT accounts.account_type from accounts WHERE accounts.id='86944267-262e-61c1-3fa0-546beae75fc9' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='f53009af-d97d-722f-9c20-546bfd2e8bbd'SELECT accounts.name from accounts WHERE accounts.id='86944267-262e-61c1-3fa0-546beae75fc9' and accounts.deleted=0Nutricia Australia Pty Ltdupdate contacts_cstm set account_name_hidden_c='Nutricia Australia Pty Ltd' WHERE id_c='f53009af-d97d-722f-9c20-546bfd2e8bbd'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='883e5d43-182b-0b11-6eee-546bfd9f5eea'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='883e5d43-182b-0b11-6eee-546bfd9f5eea'SELECT accounts.account_type from accounts WHERE accounts.id='fbbf0838-16b4-6c5f-098a-546bea113821' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='3f37c7c3-2b50-2b71-acd7-546bfdbdfbd5'SELECT accounts.name from accounts WHERE accounts.id='fbbf0838-16b4-6c5f-098a-546bea113821' and accounts.deleted=0Campbell Arnottsupdate contacts_cstm set account_name_hidden_c='Campbell Arnotts' WHERE id_c='3f37c7c3-2b50-2b71-acd7-546bfdbdfbd5'SELECT accounts.account_type from accounts WHERE accounts.id='8044a78c-5214-d3a1-4208-546beac720e4' and accounts.deleted=0Supplierupdate contacts_cstm set accounttype_c='Supplier' WHERE id_c='a01aa5f5-fa02-3e21-da5f-546bfd20edf8'SELECT accounts.name from accounts WHERE accounts.id='8044a78c-5214-d3a1-4208-546beac720e4' and accounts.deleted=0Satyamupdate contacts_cstm set account_name_hidden_c='Satyam' WHERE id_c='a01aa5f5-fa02-3e21-da5f-546bfd20edf8'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='58a65b18-d316-0175-0682-546bfdd49aa1'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='58a65b18-d316-0175-0682-546bfdd49aa1'SELECT accounts.account_type from accounts WHERE accounts.id='5d96c7ea-e2f1-f4f6-a1b3-546beacf9e39' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='4fc096fc-d6cd-84f6-aacf-546bfdc8b0d2'SELECT accounts.name from accounts WHERE accounts.id='5d96c7ea-e2f1-f4f6-a1b3-546beacf9e39' and accounts.deleted=0Woolworthsupdate contacts_cstm set account_name_hidden_c='Woolworths' WHERE id_c='4fc096fc-d6cd-84f6-aacf-546bfdc8b0d2'SELECT accounts.account_type from accounts WHERE accounts.id='7e698fe0-c550-6c30-abeb-546bea109e24' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='add93bbd-ae2a-e215-676e-546bfdb913e1'SELECT accounts.name from accounts WHERE accounts.id='7e698fe0-c550-6c30-abeb-546bea109e24' and accounts.deleted=0Qantasupdate contacts_cstm set account_name_hidden_c='Qantas' WHERE id_c='add93bbd-ae2a-e215-676e-546bfdb913e1'SELECT accounts.account_type from accounts WHERE accounts.id='e5b30742-1d9d-179a-b645-546bea762a87' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='d4200c98-980a-ce29-c9c6-546bfd26e357'SELECT accounts.name from accounts WHERE accounts.id='e5b30742-1d9d-179a-b645-546bea762a87' and accounts.deleted=0IPD Groupupdate contacts_cstm set account_name_hidden_c='IPD Group' WHERE id_c='d4200c98-980a-ce29-c9c6-546bfd26e357'SELECT accounts.account_type from accounts WHERE accounts.id='53e64624-5eb0-8622-13ae-546beab5b88b' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='19b45cb2-d7f6-d107-dab0-552c2812b176'SELECT accounts.name from accounts WHERE accounts.id='53e64624-5eb0-8622-13ae-546beab5b88b' and accounts.deleted=0Avnetupdate contacts_cstm set account_name_hidden_c='Avnet' WHERE id_c='19b45cb2-d7f6-d107-dab0-552c2812b176'SELECT accounts.account_type from accounts WHERE accounts.id='1e1305f4-3f8a-30c9-c393-546bea10eee8' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='ab4cdc48-741f-d9ad-0ee6-546bfde52fc4'SELECT accounts.name from accounts WHERE accounts.id='1e1305f4-3f8a-30c9-c393-546bea10eee8' and accounts.deleted=0Newcastle Permanent Building Societyupdate contacts_cstm set account_name_hidden_c='Newcastle Permanent Building Society' WHERE id_c='ab4cdc48-741f-d9ad-0ee6-546bfde52fc4'SELECT accounts.account_type from accounts WHERE accounts.id='8b50aea0-ea60-5d88-00e0-552c283b4000' and accounts.deleted=0Competitorupdate contacts_cstm set accounttype_c='Competitor' WHERE id_c='45a270c5-7c06-74f0-68e9-552c288e95b7'SELECT accounts.name from accounts WHERE accounts.id='8b50aea0-ea60-5d88-00e0-552c283b4000' and accounts.deleted=0Oaktonupdate contacts_cstm set account_name_hidden_c='Oakton' WHERE id_c='45a270c5-7c06-74f0-68e9-552c288e95b7'SELECT accounts.account_type from accounts WHERE accounts.id='ac1c831e-1233-411c-d5ff-546bea9a6691' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='2fcf2650-2f88-7d7a-1929-546bfd5cdb38'SELECT accounts.name from accounts WHERE accounts.id='ac1c831e-1233-411c-d5ff-546bea9a6691' and accounts.deleted=0Challengerupdate contacts_cstm set account_name_hidden_c='Challenger' WHERE id_c='2fcf2650-2f88-7d7a-1929-546bfd5cdb38'SELECT accounts.account_type from accounts WHERE accounts.id='6f10f669-003b-c938-2ac6-546beae3ef7d' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='1e4c09a8-c4d6-29c2-5ed1-546bfd7cff28'SELECT accounts.name from accounts WHERE accounts.id='6f10f669-003b-c938-2ac6-546beae3ef7d' and accounts.deleted=0Goodman Fielderupdate contacts_cstm set account_name_hidden_c='Goodman Fielder' WHERE id_c='1e4c09a8-c4d6-29c2-5ed1-546bfd7cff28'SELECT accounts.account_type from accounts WHERE accounts.id='947edafa-6c2d-3745-19e5-546bea4e51eb' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='af9154fc-3002-1d43-7a65-546bfd401372'SELECT accounts.name from accounts WHERE accounts.id='947edafa-6c2d-3745-19e5-546bea4e51eb' and accounts.deleted=0Stramit Corporationupdate contacts_cstm set account_name_hidden_c='Stramit Corporation' WHERE id_c='af9154fc-3002-1d43-7a65-546bfd401372'SELECT accounts.account_type from accounts WHERE accounts.id='5facbdda-4445-d8dd-c7a3-546beaeb9f85' and accounts.deleted=0Competitorupdate contacts_cstm set accounttype_c='Competitor' WHERE id_c='9b4c2ef5-e50c-3176-fe0c-546bfd6885a8'SELECT accounts.name from accounts WHERE accounts.id='5facbdda-4445-d8dd-c7a3-546beaeb9f85' and accounts.deleted=0Taysolsupdate contacts_cstm set account_name_hidden_c='Taysols' WHERE id_c='9b4c2ef5-e50c-3176-fe0c-546bfd6885a8'SELECT accounts.account_type from accounts WHERE accounts.id='d386dd18-f195-9b3e-6120-546beab21775' and accounts.deleted=0Supplierupdate contacts_cstm set accounttype_c='Supplier' WHERE id_c='80612507-6a9a-1bcc-01f4-546bfd07b16b'SELECT accounts.name from accounts WHERE accounts.id='d386dd18-f195-9b3e-6120-546beab21775' and accounts.deleted=0Andrews ITupdate contacts_cstm set account_name_hidden_c='Andrews IT' WHERE id_c='80612507-6a9a-1bcc-01f4-546bfd07b16b'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='ad724c5d-84d2-0744-edeb-546bfd651a99'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='ad724c5d-84d2-0744-edeb-546bfd651a99'SELECT accounts.account_type from accounts WHERE accounts.id='5a5ec9e4-0d44-971e-c280-5539a97efcbd' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='2ffba38c-1daa-3558-5fe1-5539c433ccc8'SELECT accounts.name from accounts WHERE accounts.id='5a5ec9e4-0d44-971e-c280-5539a97efcbd' and accounts.deleted=0Australian Mathematics Trustupdate contacts_cstm set account_name_hidden_c='Australian Mathematics Trust' WHERE id_c='2ffba38c-1daa-3558-5fe1-5539c433ccc8'SELECT accounts.account_type from accounts WHERE accounts.id='b8f4da6b-297a-3feb-009d-546bea7855db' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='6b29989a-ffd3-7da8-2c0c-546bfd04aea8'SELECT accounts.name from accounts WHERE accounts.id='b8f4da6b-297a-3feb-009d-546bea7855db' and accounts.deleted=0Harcourts International Limitedupdate contacts_cstm set account_name_hidden_c='Harcourts International Limited' WHERE id_c='6b29989a-ffd3-7da8-2c0c-546bfd04aea8'SELECT accounts.account_type from accounts WHERE accounts.id='ceb8beae-1961-1626-9e3b-546bea0138dd' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='4152aa00-7f8b-efe7-d515-546bfdef4d3d'SELECT accounts.name from accounts WHERE accounts.id='ceb8beae-1961-1626-9e3b-546bea0138dd' and accounts.deleted=0Foxtelupdate contacts_cstm set account_name_hidden_c='Foxtel' WHERE id_c='4152aa00-7f8b-efe7-d515-546bfdef4d3d'SELECT accounts.account_type from accounts WHERE accounts.id='ab11d05a-7192-b122-d612-546bea9475b0' and accounts.deleted=0Internalupdate contacts_cstm set accounttype_c='Internal' WHERE id_c='51a336be-cfc1-f413-9d8b-546bfdbe281c'SELECT accounts.name from accounts WHERE accounts.id='ab11d05a-7192-b122-d612-546bea9475b0' and accounts.deleted=0Infocubeupdate contacts_cstm set account_name_hidden_c='Infocube' WHERE id_c='51a336be-cfc1-f413-9d8b-546bfdbe281c'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='1e170bf2-3476-9a38-9993-546bfdead71c'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='1e170bf2-3476-9a38-9993-546bfdead71c'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='c3dd203e-27bf-def6-7543-552c2896deec'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='c3dd203e-27bf-def6-7543-552c2896deec'SELECT accounts.account_type from accounts WHERE accounts.id='ca772cd2-fc5e-d4b2-e911-546beacc3fe4' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='7dfb88df-9635-4c0f-6179-546bfd68f6b3'SELECT accounts.name from accounts WHERE accounts.id='ca772cd2-fc5e-d4b2-e911-546beacc3fe4' and accounts.deleted=0Birch & Waiteupdate contacts_cstm set account_name_hidden_c='Birch & Waite' WHERE id_c='7dfb88df-9635-4c0f-6179-546bfd68f6b3'SELECT accounts.account_type from accounts WHERE accounts.id='5d96c7ea-e2f1-f4f6-a1b3-546beacf9e39' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='8760562d-7307-c3e4-ac98-546bfda8e896'SELECT accounts.name from accounts WHERE accounts.id='5d96c7ea-e2f1-f4f6-a1b3-546beacf9e39' and accounts.deleted=0Woolworthsupdate contacts_cstm set account_name_hidden_c='Woolworths' WHERE id_c='8760562d-7307-c3e4-ac98-546bfda8e896'SELECT accounts.account_type from accounts WHERE accounts.id='3746be94-5873-6758-03f7-546bea391157' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='e2039683-d5f5-f058-214f-546bfdb55122'SELECT accounts.name from accounts WHERE accounts.id='3746be94-5873-6758-03f7-546bea391157' and accounts.deleted=0HSBC Bank Australiaupdate contacts_cstm set account_name_hidden_c='HSBC Bank Australia' WHERE id_c='e2039683-d5f5-f058-214f-546bfdb55122'SELECT accounts.account_type from accounts WHERE accounts.id='86944267-262e-61c1-3fa0-546beae75fc9' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='41683986-e7d2-80f2-b546-546bfd949843'SELECT accounts.name from accounts WHERE accounts.id='86944267-262e-61c1-3fa0-546beae75fc9' and accounts.deleted=0Nutricia Australia Pty Ltdupdate contacts_cstm set account_name_hidden_c='Nutricia Australia Pty Ltd' WHERE id_c='41683986-e7d2-80f2-b546-546bfd949843'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='900568fd-6a74-945d-5778-546bfd60d93b'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='900568fd-6a74-945d-5778-546bfd60d93b'SELECT accounts.account_type from accounts WHERE accounts.id='6fb928fa-8986-3f25-94d0-546bea8f4ebf' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='812f4673-d35d-431d-e34d-546bfd14e0a5'SELECT accounts.name from accounts WHERE accounts.id='6fb928fa-8986-3f25-94d0-546bea8f4ebf' and accounts.deleted=0FKP Propertyupdate contacts_cstm set account_name_hidden_c='FKP Property' WHERE id_c='812f4673-d35d-431d-e34d-546bfd14e0a5'SELECT accounts.account_type from accounts WHERE accounts.id='b1703313-feca-54f5-0217-546bea646a58' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='618cba74-dcbf-bcaf-9cac-546bfdbc0c1f'SELECT accounts.name from accounts WHERE accounts.id='b1703313-feca-54f5-0217-546bea646a58' and accounts.deleted=0Payless Shoesupdate contacts_cstm set account_name_hidden_c='Payless Shoes' WHERE id_c='618cba74-dcbf-bcaf-9cac-546bfdbc0c1f'SELECT accounts.account_type from accounts WHERE accounts.id='38793f80-0748-1b2e-c3e7-546bea760aaa' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='f3d2f12c-1c2f-8eaf-4112-546bfd923b2f'SELECT accounts.name from accounts WHERE accounts.id='38793f80-0748-1b2e-c3e7-546bea760aaa' and accounts.deleted=0RailCorpupdate contacts_cstm set account_name_hidden_c='RailCorp' WHERE id_c='f3d2f12c-1c2f-8eaf-4112-546bfd923b2f'SELECT accounts.account_type from accounts WHERE accounts.id='86944267-262e-61c1-3fa0-546beae75fc9' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='a67bf9e7-ec7d-5711-97f5-546bfdc91577'SELECT accounts.name from accounts WHERE accounts.id='86944267-262e-61c1-3fa0-546beae75fc9' and accounts.deleted=0Nutricia Australia Pty Ltdupdate contacts_cstm set account_name_hidden_c='Nutricia Australia Pty Ltd' WHERE id_c='a67bf9e7-ec7d-5711-97f5-546bfdc91577'SELECT accounts.account_type from accounts WHERE accounts.id='79e79fe2-eeed-a079-9fbd-546bea9866d9' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='72970fe5-7dff-1a25-479f-546bfd6b1422'SELECT accounts.name from accounts WHERE accounts.id='79e79fe2-eeed-a079-9fbd-546bea9866d9' and accounts.deleted=0Unileverupdate contacts_cstm set account_name_hidden_c='Unilever' WHERE id_c='72970fe5-7dff-1a25-479f-546bfd6b1422'SELECT accounts.account_type from accounts WHERE accounts.id='18f1450b-23f7-ff9e-0333-546bea0c2698' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='f10bef3c-d52e-cfe3-94c6-546bfd9d46fb'SELECT accounts.name from accounts WHERE accounts.id='18f1450b-23f7-ff9e-0333-546bea0c2698' and accounts.deleted=0NSW Treasuryupdate contacts_cstm set account_name_hidden_c='NSW Treasury' WHERE id_c='f10bef3c-d52e-cfe3-94c6-546bfd9d46fb'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='f13193ca-d4ef-d52e-8226-546bfdbf6674'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='f13193ca-d4ef-d52e-8226-546bfdbf6674'SELECT accounts.account_type from accounts WHERE accounts.id='5d96c7ea-e2f1-f4f6-a1b3-546beacf9e39' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='d31c1e80-b630-250e-db54-56e9fa33fc45'SELECT accounts.name from accounts WHERE accounts.id='5d96c7ea-e2f1-f4f6-a1b3-546beacf9e39' and accounts.deleted=0Woolworthsupdate contacts_cstm set account_name_hidden_c='Woolworths' WHERE id_c='d31c1e80-b630-250e-db54-56e9fa33fc45'SELECT accounts.account_type from accounts WHERE accounts.id='91ba97d8-346c-c1e2-a713-5703079520c2' and accounts.deleted=0Prospectupdate contacts_cstm set accounttype_c='Prospect' WHERE id_c='73c25f77-cba8-3b53-b7d8-570308b5fb60'SELECT accounts.name from accounts WHERE accounts.id='91ba97d8-346c-c1e2-a713-5703079520c2' and accounts.deleted=0Parramatta City Councilupdate contacts_cstm set account_name_hidden_c='Parramatta City Council' WHERE id_c='73c25f77-cba8-3b53-b7d8-570308b5fb60'SELECT accounts.account_type from accounts WHERE accounts.id='49fd6cfd-d22d-d814-8a48-546bea253fda' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='dbddcbb9-3dd9-6dfc-4657-546bfd7214d7'SELECT accounts.name from accounts WHERE accounts.id='49fd6cfd-d22d-d814-8a48-546bea253fda' and accounts.deleted=0News Limitedupdate contacts_cstm set account_name_hidden_c='News Limited' WHERE id_c='dbddcbb9-3dd9-6dfc-4657-546bfd7214d7'SELECT accounts.account_type from accounts WHERE accounts.id='49fd6cfd-d22d-d814-8a48-546bea253fda' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='7a5be4c8-a0f7-9721-5c71-546bfdf58e73'SELECT accounts.name from accounts WHERE accounts.id='49fd6cfd-d22d-d814-8a48-546bea253fda' and accounts.deleted=0News Limitedupdate contacts_cstm set account_name_hidden_c='News Limited' WHERE id_c='7a5be4c8-a0f7-9721-5c71-546bfdf58e73'SELECT accounts.account_type from accounts WHERE accounts.id='49fd6cfd-d22d-d814-8a48-546bea253fda' and accounts.deleted=0Customerupdate contacts_cstm set accounttype_c='Customer' WHERE id_c='b928b214-732d-97bf-953e-546bfd03a7f1'SELECT accounts.name from accounts WHERE accounts.id='49fd6cfd-d22d-d814-8a48-546bea253fda' and accounts.deleted=0News Limitedupdate contacts_cstm set account_name_hidden_c='News Limited' WHERE id_c='b928b214-732d-97bf-953e-546bfd03a7f1'SELECT accounts.account_type from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0Partnerupdate contacts_cstm set accounttype_c='Partner' WHERE id_c='5dddabc3-4f8f-833b-5367-546bfd722dc5'SELECT accounts.name from accounts WHERE accounts.id='68c3ef38-b25d-f80f-e2c6-546bea9b9706' and accounts.deleted=0IBMupdate contacts_cstm set account_name_hidden_c='IBM' WHERE id_c='5dddabc3-4f8f-833b-536
If you want to upload files, you can use Dropbox, Google Drive, OneDrive, etc.
To put them in Pastebin you open them in your computer, select all, Copy, then Paste them in Pastebin, it gives you a link, and you put it here.
Note that I am not too keen to be examining people’s full logs, it takes time and it’s a job better done by you. You can pay attention to the timestamps and focus on the lines that are emitted when you do the failed Import.
I see what you mean about me interrogating the files first. The only relevant records I could find are these. The first and last few are repeated ad nauseam in the log. The rest are relevant. Thanks for your help, John
Wed Oct 10 10:38:04 2018 [1309059][dcc8648b-20e1-5053-cd08-54668a3c6995][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Oct 10 10:38:04 2018 [1309059][dcc8648b-20e1-5053-cd08-54668a3c6995][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Oct 10 10:38:04 2018 [1309059][dcc8648b-20e1-5053-cd08-54668a3c6995][FATAL] Caught error: stat(): stat failed for upload/import/status_dcc8648b-20e1-5053-cd08-54668a3c6995.csv
Wed Oct 10 10:38:04 2018 [1309059][dcc8648b-20e1-5053-cd08-54668a3c6995][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Wed Oct 10 10:38:04 2018 [1309059][dcc8648b-20e1-5053-cd08-54668a3c6995][ERROR] File upload://import/status_dcc8648b-20e1-5053-cd08-54668a3c6995.csv cannot be touched
Wed Oct 10 10:38:04 2018 [1309129][dcc8648b-20e1-5053-cd08-54668a3c6995][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Oct 10 10:38:04 2018 [1309129][dcc8648b-20e1-5053-cd08-54668a3c6995][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Wed Oct 10 10:38:04 2018 [1309129][dcc8648b-20e1-5053-cd08-54668a3c6995][ERROR] Unable to load custom logic file: include/SugarSearchEngine/SugarSearchEngineQueueManager.php
Sorry for the delay answering, I was away for a few days.
So the previous SQL query errors no longer show in your logs?
These current errors suggest permissions problems - SuiteCRM having trouble writing to the directories it needs to. Is this a new installation? Did you set ownership and permissions as indicated in the installation guide? Are you sure about the web server user name you used for ownerships?