Dear Sawtooth community,
I have problem importing a csv file of my study in Sawtooth. What I have done so far is to export the data from Lighthouse Studio into Excel for data cleaning (here deleting rows). After that I saved the Excel as a csv file. When I want to upload this file to Lighthouse Studio I get the following error:
The file contains an invalid field 'sys_RespNum;sys_StartTime;sys_EndTime;sys_ElapsedTime;sys_SumPageTimes;sys_StartTimeStamp;sys_EndTimeStamp;sys_DataSource;sys_RespStatus;sys_DispositionCode;sys_LastQuestion;sys_UserJavaScript;sys_OperatingSystem;sys_Browser;sys_IPAddress;sys_UserAgent;sys_ShowPrev;sys_CAPIDeviceID;ChoiceExperiment_Random1;ChoiceExperiment_Random2;ChoiceExperiment_Random3;ChoiceExperiment_Random4;ChoiceExperiment_Random5;ChoiceExperiment_Random6;ChoiceExperiment_Random7;ChoiceExperiment_Random8;ChoiceExperiment_Random9;ChoiceExperiment_Random10;ChoiceExperiment_Random11;ChoiceExperiment_Random12;ChoiceExperiment_Random13;ChoiceExperiment_Random14;sys_CBCVersion_ChoiceExperiment;sys_CBCDesignID_ChoiceExperiment;sys_pagetime_1;sys_pagetime_2;sys_pagetime_3;sys_pagetime_4;sys_pagetime_5;sys_pagetime_6;sys_pagetime_7;sys_pagetime_8;sys_pagetime_9;sys_pagetime_10;sys_pagetime_11;sys_pagetime_12;sys_pagetime_13;sys_pagetime_14;sys_pagetime_15;sys_pagetime_16;Survey_1;Survey_2;Survey_3;Rvenue;sys_pagetime_17;sys_pagetime_18;Example_Random1;sys_CBCVersion_Example;sys_CBCDesignID_Example;sys_pagetime_19;sys_pagetime_20;ChoiceExperiment_Fixed1;ChoiceExperiment_Fixed2;ChoiceExperiment_Random16;ChoiceExperiment_Random17;ChoiceExperiment_Random18;ChoiceExperiment_Random19;ChoiceExperiment_Random20;ChoiceExperiment_Random21;ChoiceExperiment_Random22;ChoiceExperiment_Random23;ChoiceExperiment_Random24;ChoiceExperiment_Random25;ChoiceExperiment_Random26;Email;sys_pagetime_21;sys_pagetime_22;sys_pagetime_23;sys_pagetime_24;sys_pagetime_25;sys_pagetime_26;sys_pagetime_27;sys_pagetime_28;sys_pagetime_29;sys_pagetime_30;sys_pagetime_31;sys_pagetime_32;sys_pagetime_33;sys_pagetime_34;sys_pagetime_35;ID;Gender;Age;Location;Education;FieldEducation_1;FieldEducation_2;FieldEducation_3;FieldEducation_4;FieldEducation_5;FieldEducation_5_other;ExperienceYears;Entrepreneur;Tenure;Position;Position_5_other;BoardSeats;PercentageExit;Syndicate_1;Syndicate_2;Syndicate_3;Stage_1;Stage_2;Stage_3;Stage_4;Stage_5;InvestorType;InvestorType_6_other;AuM;Staff;Industry_1;Industry_2;Industry_3;Industry_4;Industry_5;Industry_6;Industry_7;Industry_8;Industry_9;Industry_10;Industry_11;Industry_12;Industry_12_other;IRR;X2X_1;X2X_2;X2X_3;Syndication_1;ExitPerformance_1;ExitPerformance_2;ExitPerformance_3;ExitPerformance_4;LPs_1;LPs_2;LPs_3;InvestmentFocusRegion_1;InvestmentFocusRegion_2;InvestmentFocusRegion_3;InvestmentFocusRegion_4;InvestmentFocusRegion_5;InvestmentFocusRegion_6;InvestmentFocusRegion_7;CrossBorder;Office;Office2;Leadership;Valueadd_1;Valueadd_2;Valueadd_3;Valueadd_4;Valueadd_5;Valueadd_6;Valueadd_7;studyID;SerialEntrepreneur;Syndi;ExitPerformance_5;InvestorType_8_other;Industry_10_other;X2X;Valueadd_8;Valueadd_8_other;Charity;sys_OriginalRespondentNumber;sys_OriginalFile;sys_OriginalRespondentSignature;'. ERROR: The name contains an invalid character.
Can you provide me with some tips on how to solve the issue?
Best,
René