Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am getting the error even if file is loaded properly.
Regards,
KK
Try this:
Directory;
LOAD Start,
Duration,
Operator,
[Real Time Session ID],
skill,
phoneNumber,
email,
identifier,
[chat_customer_satisfaction_1(ES)],
[chat_customer_satisfaction_2(ES)],
[chat_customer_satisfaction_3(ES)],
[chat_customer_satisfaction_4(ES)],
[chat_first_contact_resolution(ES)],
[send_transcript(ES)],
[ESQ_s1 q2],
[ESQ_s1 q3],
[ESQ_s1 q4],
[ESQ_s1 q5],
[ESQ_s1 q6],
[ESQ_s1 q7],
[ESQ_s1 q10],
[ESQ_s1 q11],
[ESQ_s1 q12],
[ESQ_s1 q13],
[ESQ_s1 q14],
[ESQ_s1 q15],
[ESQ_s1 q16],
[ESQ_s2 q9],
[ESQ_s2 q10],
[ESQ_s2 q11],
[ESQ_s2 q12],
[ESQ_s2 q13],
[ESQ_s2 q14],
[ESQ_s2 q15],
[ESQ_s2 q16],
[ESQ_s2 q17],
[ESQ_s2 q18],
[ESQ_s2 q19],
[ESQ_s3 q9],
[ESQ_s3 q10],
[ESQ_s3 q11],
[ESQ_s3 q12],
[ESQ_s3 q13],
[ESQ_s3 q14],
[ESQ_s3 q15],
[ESQ_s3 q16],
[ESQ_s3 q17],
[ESQ_s3 q18],
[ESQ_s4 q2],
[ESQ_s4 q3],
[ESQ_s4 q4],
[ESQ_s4 q5],
[ESQ_s4 q6],
[ESQ_s4 q9],
[ESQ_s4 q10],
[ESQ_s4 q11],
[ESQ_s4 q12],
[ESQ_s4 q13],
[ESQ_s4 q14],
[ESQ_s4 q15],
[ESQ_s5 q9],
[ESQ_s5 q10],
[ESQ_s5 q11],
[ESQ_s5 q12],
[ESQ_s5 q13],
[ESQ_s5 q14],
[lead_value(OS)],
[operator_first_contact_resolution(OS)],
[order_value(OS)],
[qualified_chat(OS)],
[OSQ_s1 q6],
[OSQ_s1 q7],
[OSQ_s1 q8],
[OSQ_s1 q9],
[OSQ_s1 q10],
[OSQ_s1 q11],
[Type of Chat* (Checkbox)],
[Pre-Sales Category (Checkbox)],
[Please Specify (which competitor pre-sales) (Text Field)],
[Please Specify (other pre-sales) (Text Field)],
[Ready to Buy Category (Checkbox)],
[Please Specify (Other Ready to Buy) (Text Field)],
[Post-Sales & Non-related Category (Checkbox)],
[Please Specify (post-sales & non related) (Text Field)],
[Main product of interest for the customer (Dropdown Box)],
[Version of product (Dropdown Box)],
[Second Product Of Interest for the customer (if applicable) (Dropdown Box)],
[Third product of interest for the customer (if applicable) (Dropdown Box)],
[Product recommended to the customer (Dropdown Box)],
[Additional Offer (Checkbox)],
[Chat Agent Action (Checkbox)],
[Please Specify (other Department) (Text Field)],
[How was the referral made? (Checkbox)],
[Please specify (other action) (Text Field)],
[Status of customer request (Dropdown Box)],
[Comments (Text Field)],
[Salesforce Case Number (Front Desk Only - when transferred) (Text Field)],
[OSQ_s3 q6],
[OSQ_s3 q7],
[OSQ_s3 q8],
[OSQ_s3 q9],
[OSQ_s3 q10],
[OSQ_s3 q11],
[OSQ_s3 q12],
[OSQ_s3 q13],
[OSQ_s3 q14],
[OSQ_s3 q15],
[OSQ_s3 q16],
[OSQ_s3 q17],
[OSQ_s3 q18],
[OSQ_s3 q19],
[OSQ_s3 q20],
[OSQ_s3 q21],
[OSQ_s3 q22],
[OSQ_s3 q23],
[OSQ_s3 q24],
[OSQ_s3 q25],
[OSQ_s3 q26],
[OSQ_s3 q27],
[OSQ_s4 q1],
[OSQ_s4 q2],
[OSQ_s4 q7],
[OSQ_s4 q8],
[OSQ_s4 q9],
[OSQ_s4 q10],
[OSQ_s4 q11],
[OSQ_s5 q5],
[OSQ_s6 q6],
[message(OF)],
[subject(OF)],
LP_Visitor_Category,
[chat-button-name],
[chat-button-room],
pagecounter,
InteractiveChat,
DisconnectedBy,
Proxy_IP,
visitorActive,
pageLoadTime,
unit,
PageName,
language,
campaign_medium,
room,
page_room,
SectionS,
[impression-query-room],
[impression-query-name],
[click-query-channel],
[click-query-name],
[click-query-state],
[click-query-room],
OrderTotal,
CartTotal,
Exclude,
ErrorCounter,
maxCartTotal,
campaign_source,
ExcludeEstore,
[Pre-Hot-Lead],
[Hot-Lead],
SalesCounter,
ErrorCtr,
campaign_search_keywords,
SaleAfterChat2.0,
SaleAfterChat1.0,
SaleAfterChat3.0,
SaleAfterChat4.0,
OrderNumber,
OrderNumberForRules,
OrderNumberForReports,
OrderTotalForReports,
DuplicateOrderNumberCounter,
TrialPage,
ConversionStage,
ChatEngage,
Section,
product3,
product2,
product1,
live_engage_control_group,
deliveryHook_BrowsingSite,
[engageFlagOncartpage-comingfromaffiliates(2013links)-ACADLT,InventorLT,InventorLTSuite_EnterPage],
[engageFlagCoreUSeStorevisitors[fromUSandCA]]]_EnterSite],
Currency,
excludeEstoreEmea,
ChatRule,
ReportedChatStart,
ReportedChatEnd,
Browser,
[Host IP],
[Operating System],
Country,
City,
Organization,
[World Region],
[Postal Code],
[Time Zone],
ISP,
[Connection Type],
[Pre-Chat Survey],
[Exit Survey],
[Operator Survey],
[Offline Survey]
FROM
Demo_Chat.xlsx
(ooxml, embedded labels, table is Sheet1);
For more details on the idea of excape sequence, check here: Escape sequences
Check this?
Try this:
Directory;
LOAD Start,
Duration,
Operator,
[Real Time Session ID],
skill,
phoneNumber,
email,
identifier,
[chat_customer_satisfaction_1(ES)],
[chat_customer_satisfaction_2(ES)],
[chat_customer_satisfaction_3(ES)],
[chat_customer_satisfaction_4(ES)],
[chat_first_contact_resolution(ES)],
[send_transcript(ES)],
[ESQ_s1 q2],
[ESQ_s1 q3],
[ESQ_s1 q4],
[ESQ_s1 q5],
[ESQ_s1 q6],
[ESQ_s1 q7],
[ESQ_s1 q10],
[ESQ_s1 q11],
[ESQ_s1 q12],
[ESQ_s1 q13],
[ESQ_s1 q14],
[ESQ_s1 q15],
[ESQ_s1 q16],
[ESQ_s2 q9],
[ESQ_s2 q10],
[ESQ_s2 q11],
[ESQ_s2 q12],
[ESQ_s2 q13],
[ESQ_s2 q14],
[ESQ_s2 q15],
[ESQ_s2 q16],
[ESQ_s2 q17],
[ESQ_s2 q18],
[ESQ_s2 q19],
[ESQ_s3 q9],
[ESQ_s3 q10],
[ESQ_s3 q11],
[ESQ_s3 q12],
[ESQ_s3 q13],
[ESQ_s3 q14],
[ESQ_s3 q15],
[ESQ_s3 q16],
[ESQ_s3 q17],
[ESQ_s3 q18],
[ESQ_s4 q2],
[ESQ_s4 q3],
[ESQ_s4 q4],
[ESQ_s4 q5],
[ESQ_s4 q6],
[ESQ_s4 q9],
[ESQ_s4 q10],
[ESQ_s4 q11],
[ESQ_s4 q12],
[ESQ_s4 q13],
[ESQ_s4 q14],
[ESQ_s4 q15],
[ESQ_s5 q9],
[ESQ_s5 q10],
[ESQ_s5 q11],
[ESQ_s5 q12],
[ESQ_s5 q13],
[ESQ_s5 q14],
[lead_value(OS)],
[operator_first_contact_resolution(OS)],
[order_value(OS)],
[qualified_chat(OS)],
[OSQ_s1 q6],
[OSQ_s1 q7],
[OSQ_s1 q8],
[OSQ_s1 q9],
[OSQ_s1 q10],
[OSQ_s1 q11],
[Type of Chat* (Checkbox)],
[Pre-Sales Category (Checkbox)],
[Please Specify (which competitor pre-sales) (Text Field)],
[Please Specify (other pre-sales) (Text Field)],
[Ready to Buy Category (Checkbox)],
[Please Specify (Other Ready to Buy) (Text Field)],
[Post-Sales & Non-related Category (Checkbox)],
[Please Specify (post-sales & non related) (Text Field)],
[Main product of interest for the customer (Dropdown Box)],
[Version of product (Dropdown Box)],
[Second Product Of Interest for the customer (if applicable) (Dropdown Box)],
[Third product of interest for the customer (if applicable) (Dropdown Box)],
[Product recommended to the customer (Dropdown Box)],
[Additional Offer (Checkbox)],
[Chat Agent Action (Checkbox)],
[Please Specify (other Department) (Text Field)],
[How was the referral made? (Checkbox)],
[Please specify (other action) (Text Field)],
[Status of customer request (Dropdown Box)],
[Comments (Text Field)],
[Salesforce Case Number (Front Desk Only - when transferred) (Text Field)],
[OSQ_s3 q6],
[OSQ_s3 q7],
[OSQ_s3 q8],
[OSQ_s3 q9],
[OSQ_s3 q10],
[OSQ_s3 q11],
[OSQ_s3 q12],
[OSQ_s3 q13],
[OSQ_s3 q14],
[OSQ_s3 q15],
[OSQ_s3 q16],
[OSQ_s3 q17],
[OSQ_s3 q18],
[OSQ_s3 q19],
[OSQ_s3 q20],
[OSQ_s3 q21],
[OSQ_s3 q22],
[OSQ_s3 q23],
[OSQ_s3 q24],
[OSQ_s3 q25],
[OSQ_s3 q26],
[OSQ_s3 q27],
[OSQ_s4 q1],
[OSQ_s4 q2],
[OSQ_s4 q7],
[OSQ_s4 q8],
[OSQ_s4 q9],
[OSQ_s4 q10],
[OSQ_s4 q11],
[OSQ_s5 q5],
[OSQ_s6 q6],
[message(OF)],
[subject(OF)],
LP_Visitor_Category,
[chat-button-name],
[chat-button-room],
pagecounter,
InteractiveChat,
DisconnectedBy,
Proxy_IP,
visitorActive,
pageLoadTime,
unit,
PageName,
language,
campaign_medium,
room,
page_room,
SectionS,
[impression-query-room],
[impression-query-name],
[click-query-channel],
[click-query-name],
[click-query-state],
[click-query-room],
OrderTotal,
CartTotal,
Exclude,
ErrorCounter,
maxCartTotal,
campaign_source,
ExcludeEstore,
[Pre-Hot-Lead],
[Hot-Lead],
SalesCounter,
ErrorCtr,
campaign_search_keywords,
SaleAfterChat2.0,
SaleAfterChat1.0,
SaleAfterChat3.0,
SaleAfterChat4.0,
OrderNumber,
OrderNumberForRules,
OrderNumberForReports,
OrderTotalForReports,
DuplicateOrderNumberCounter,
TrialPage,
ConversionStage,
ChatEngage,
Section,
product3,
product2,
product1,
live_engage_control_group,
deliveryHook_BrowsingSite,
[engageFlagOncartpage-comingfromaffiliates(2013links)-ACADLT,InventorLT,InventorLTSuite_EnterPage],
[engageFlagCoreUSeStorevisitors[fromUSandCA]]]_EnterSite],
Currency,
excludeEstoreEmea,
ChatRule,
ReportedChatStart,
ReportedChatEnd,
Browser,
[Host IP],
[Operating System],
Country,
City,
Organization,
[World Region],
[Postal Code],
[Time Zone],
ISP,
[Connection Type],
[Pre-Chat Survey],
[Exit Survey],
[Operator Survey],
[Offline Survey]
FROM
Demo_Chat.xlsx
(ooxml, embedded labels, table is Sheet1);
For more details on the idea of excape sequence, check here: Escape sequences
I didn't get any errors