rmsharp / snprcspf Goto Github PK

Terry Hawkins (to All):
An error occurred when running the script 'snprc_luminex.R', exit code: 1).
Loading required package: httr
Loading required package: jsonlite
Error in insert_combined_assay_results(conn, combined_df) :
insert into luminex_screen_results failed status: 22007 241 [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string.insert into luminex_screen_results failed status: [RODBC] ERROR: Could not SQLExecDirect 'INSERT INTO luminex_screen_results (
file_name, plate_id, sample, species, snprc_id, sample_date,
report_date, repeated, agent,
procedure_id, procedure_name, test_id, test_name, assay_value)
values ('SPF Colony Testing Plate 99999 03-60-20.xlsx', '99999', '20191210-31160-R', 'MACAQUE', ' 31160', '2019-12-10', '2020-03-60', 'Y', 'STLV', '10641', 'RHESUS SPF SCREEN', '789', 'STLV-1 AB', 'N') '
In addition: Warning message:
In if (!status == "No Data") stop(stri_c("insert into ", table, :
the condition has length >

There is a need to have openxlsx since it provides the formatting. Since openxlsx also reads Excel files, there is no need for readxl.