{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["회신번호 - 길이체크","수신번호 - 길이체크","수신번호 - 유효성","SMS - 길이체크","제목 - null체크","제목 - 길이체크","메세지 - 길이체크","이미지 없음","이미지확장자","파일누락","이미지용량","카카오 길이체크","카카오 확장자","카카오 JSON FILE"],"read":"whole","date_system":"1900"}

{"sheet":"회신번호 - 길이체크","index":0,"n_rows":6,"n_cols":1,"rows_kept":6}
["### 회신번호 에러 : 321 : 길이체크"]
["-- SMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n) VALUES ('S', '0', NOW(), '01012345678', '123', 'message test 20240708');"]
["-- LMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n) VALUES ('L', '0', NOW(), '01012345678', '123', 'LMS message test 20240708', 'subject');"]
["-- MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '123', 'MMS message test 20240708', 'subject', 'send.png');"]
["-- 알림톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '123', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]
["-- 친구톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '123', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]

{"sheet":"수신번호 - 길이체크","index":1,"n_rows":6,"n_cols":1,"rows_kept":6}
["수신번호 에러 : 331 : 길이체크"]
["-- SMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n) VALUES ('S', '0', NOW(), '0101234', '01043219876', 'message test 20240708');"]
["-- LMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n) VALUES ('L', '0', NOW(), '0101234', '01043219876', 'LMS message test 20240708', 'subject');"]
["-- MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '0101234', '01043219876', 'MMS message test 20240708', 'subject', 'send.png');"]
["-- 알림톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '0101234', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]
["-- 친구톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '0101234', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]

{"sheet":"수신번호 - 유효성","index":2,"n_rows":6,"n_cols":1,"rows_kept":6}
["수신번호 에러 : 332 : 유효하지 않은 번호"]
["-- SMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n) VALUES ('S', '0', NOW(), '11012345678', '01043219876', 'message test 20240708');"]
["-- LMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n) VALUES ('L', '0', NOW(), '11012345678', '01043219876', 'LMS message test 20240708', 'subject');"]
["-- MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '11012345678', '01043219876', 'MMS message test 20240708', 'subject', 'send.png');"]
["-- 알림톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '11012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]
["-- 친구톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '11012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]

{"sheet":"SMS - 길이체크","index":3,"n_rows":2,"n_cols":1,"rows_kept":2}
["SMS : 341 : 길이체크"]
["-- SMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n) VALUES ('S', '0', NOW(), '01012345678', '01043219876', 'sms message test 20240708. sms message sms message test 20240708 test 20240708 sms message test 20240708 sms message test 20240708');"]

{"sheet":"제목 - null체크","index":4,"n_rows":5,"n_cols":1,"rows_kept":5}
["제목 : 350 : null 체크 : LMS, MMS, 카카오"]
["-- LMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n) VALUES ('L', '0', NOW(), '01012345678', '01043219876', 'LMS message test 20240708', null);"]
["-- MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'MMS message test 20240708', null, 'send.png');"]
["-- 알림톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', null, 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]
["-- 친구톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', null, 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]

{"sheet":"제목 - 길이체크","index":5,"n_rows":5,"n_cols":1,"rows_kept":5}
["제목 : 351 : 길이체크 : LMS, MMS , 카카오"]
["-- LMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n) VALUES ('L', '0', NOW(), '01012345678', '01043219876', 'LMS message test 20240708', 'subject test is over byte.  test is over byte test is over byte');"]
["-- MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'MMS message test 20240708', 'subject test is over byte.  test is over byte test is over byte', 'send.png');"]
["-- 알림톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject test is over byte.  test is over byte test is over byte', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]
["-- 친구톡 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject test is over byte.  test is over byte test is over byte', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]

{"sheet":"메세지 - 길이체크","index":6,"n_rows":7,"n_cols":1,"rows_kept":7}
["메시지 : 361 : 길이체크 : 2000바이트 넘게 입력후 테스트"]
["\n샘플 메시지 내용 >>\n\nLorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque eleifend luctus auctor. Quisque nec sem viverra, tempus lorem et, eleifend ex. Vivamus quis aliquam turpis. Nullam et faucibus quam. Morbi dictum turpis sit amet massa porttitor efficitur. Duis pellentesque erat non risus mollis sodales. Nunc id odio libero. Nullam bibendum urna in aliquam tristique. Curabitur ultrices finibus vehicula. Suspendisse lobortis, eros ut iaculis vehicula, nulla nunc mattis est, sed maximus mi neque non enim.\n\nProin pretium odio vel nunc mattis cursus. Donec hendrerit venenatis aliquam. Nulla commodo nibh nec sem auctor, ut aliquet massa luctus. Aliquam quis fringilla erat, vitae egestas elit. Donec consectetur nibh molestie pharetra accumsan. Nunc ultricies vel libero quis fringilla. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Aliquam pulvinar molestie dignissim. Phasellus lectus ipsum, elementum eu venenatis nec, egestas vel arcu. Vivamus tincidunt pharetra nulla ut interdum. Etiam quis ultrices massa, scelerisque interdum nisl. Donec at fringilla massa, non interdum est. Maecenas hendrerit mi leo, nec tempor dolor pellentesque ut. Suspendisse lobortis mi sed tellus tempus, commodo viverra felis tempus.\n\nNunc id leo tortor. Pellentesque placerat efficitur felis, nec auctor turpis interdum eget. Morbi at tincidunt lacus, et iaculis arcu. Nam quis lorem eu est pellentesque convallis. Etiam ac eros erat. Aenean nec quam quis orci euismod accumsan eu non ex. Donec sem nibh, porttitor sit amet orci sed, tempus scelerisque ex. In vel eros nisl. Integer consequat dui in posuere egestas. Integer ut imperdiet mauris. Nam eget orci ut libero fermentum accumsan sit amet eu augue. Morbi interdum id arcu nec tempor. Donec et orci at ipsum accumsan auctor suscipit sed metus. Phasellus mauris nisl, gravida nec odio eu, auctor consequat metus. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Pellentesque ornare purus dui, id tincidunt libero sollicitudin at.\n\nNunc vulputate dui ipsum, a blandit tellus vehicula non. Aliquam erat volutpat. Maecenas in est non tortor venenatis maximus. Integer nec nisl dapibus, pulvinar libero at, dapibus mi. Nulla vel interdum ipsum. Phasellus faucibus tristique dolor, fermentum semper ligula mattis eget. Morbi auctor eros odio, eu sodales enim vestibulum quis. Vestibulum purus leo, eleifend eget sem ut, bibendum eleifend arcu"]
[]
["--LMS 발송\n\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n) VALUES ('L', '0', NOW(), '01012345678', '01043219876', 'message', 'subject');"]
["--MMS 발송\n\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'message.\n', 'subject', 'send.png');"]
["--알림톡발송\n\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]
["--친구톡발송\n\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]

{"sheet":"이미지 없음","index":7,"n_rows":1,"n_cols":1,"rows_kept":1}
["이미지 : 370 : 이미지 첨부 없음\n--MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'MMS message test 20240708', 'subject', null);"]

{"sheet":"이미지확장자","index":8,"n_rows":1,"n_cols":1,"rows_kept":1}
["이미지 : 371 : 지원하지 않는 이미지 확장자\n--MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'MMS message test 20240708', 'subject', 'send.hop ');"]

{"sheet":"파일누락","index":9,"n_rows":2,"n_cols":1,"rows_kept":2}
["이미지 : 372 : 경로에 파일이 없는 경우"]
["--MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'MMS message test 20240708', 'subject', 'send01.png');"]

{"sheet":"이미지용량","index":10,"n_rows":2,"n_cols":1,"rows_kept":2}
["이미지 : 373 : 이미지 용량이 초과하는 경우\n>> 300K가 넘는 이미지 파일로 테스트필요"]
["--MMS 발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , FILENAME01\n) VALUES ('M', '0', NOW(), '01012345678', '01043219876', 'MMS message test 20240708', 'subject', 'send.png');"]

{"sheet":"카카오 길이체크","index":11,"n_rows":9,"n_cols":4,"rows_kept":9}
["카카오 KAKAO_SENDER_KEY : 380 : 길이체크",null,null,"카카오 KAKAO_TEMPLATE_CODE : 390 : 길이체크"]
["--알림톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', '', 'bbbbbbb', 'sample_alarm.json');",null,null,"--알림톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', '', 'sample_alarm.json');"]
["--친구톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', '', 'bbbbbbb', 'sample_alarm.json');",null,null,"--친구톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', '', 'sample_alarm.json');"]
[]
[]
["카카오 KAKAO_JSON_FILE : 400 : 길이체크"]
["--알림톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', null);"]
[]
["--친구톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', null);"]

{"sheet":"카카오 확장자","index":12,"n_rows":4,"n_cols":1,"rows_kept":4}
["카카오 KAKAO_JSON_FILE : 401 : 확장자체크"]
["--알림톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.txt');"]
[]
["--친구톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.docs');"]

{"sheet":"카카오 JSON FILE","index":13,"n_rows":11,"n_cols":3,"rows_kept":11}
[null,null,"카카오 KAKAO_JSON_FILE : 402 : 경로에 파일이 없는 경우"]
["카카오 KAKAO_JSON_FILE : 402 : 경로에 파일이 없는 경우"]
["--알림톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm1.json');",null,"--알림톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm1.json');"]
[]
["--친구톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm2.json');",null,"--친구톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm2.json');"]
[]
[]
["카카오 KAKAO_JSON_FILE : 403 : 용량이 초과하는 경우 : 100K넘게 작성후 테스트 필요"]
["--알림톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('A', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]
[]
["--친구톡발송\nINSERT INTO MUNJAON_MSG (\n    MSG_TYPE\n    , SEND_STATUS\n    , REQUEST_DATE\n    , RECV_PHONE\n    , SEND_PHONE\n    , MESSAGE\n    , SUBJECT\n    , KAKAO_SENDER_KEY\n    , KAKAO_TEMPLATE_CODE\n    , KAKAO_JSON_FILE\n) VALUES ('F', '0', NOW(), '01012345678', '01043219876', 'KAKAO message test 20240708', 'subject', 'aaaaaaa', 'bbbbbbb', 'sample_alarm.json');"]