Advertisement
Guest User

Untitled

a guest
Oct 21st, 2016
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 KB | None | 0 0
  1. tabItem("chooseFile",
  2. fluidRow(
  3. box(
  4. width = 5, status = "info",solidHeader = TRUE,
  5. title = "Send Emails",
  6. helpText(tags$b("Please uplaod .csv or .tsv file")),
  7. tags$hr(),
  8. fileInput('csv_file', 'Choose file to upload',
  9. accept = c(
  10. 'text/csv',
  11. 'text/comma-separated-values',
  12. 'text/tab-separated-values',
  13. 'text/plain',
  14. '.csv',
  15. '.tsv'
  16. )
  17. ),
  18. tags$hr(),
  19. checkboxInput('header', 'Header', TRUE),
  20. radioButtons('sep', 'Separator',
  21. c(Comma=',',
  22. Semicolon=';',
  23. Tab='t'),
  24. ','),
  25. actionButton("upload_file", tags$b("Upload File"))
  26.  
  27.  
  28. )
  29. )
  30. ),
  31.  
  32. observeEvent(input$upload_file, {
  33. csv <- input$csv_file
  34. saveData(csv)
  35. session$sendCustomMessage(type ='testmessage',
  36. message = paste0("File has been successfully uploaded to database"))
  37.  
  38. })
  39.  
  40. saveData <- function(data) {
  41. # Connect to the database
  42. db <- dbConnect(MySQL(), dbname = databaseName, host = options()$mysql$host,
  43. port = options()$mysql$port, user = options()$mysql$user,
  44. password = options()$mysql$password)
  45. # Construct the update query by looping over the data fields
  46. dbWriteTable(db, table, input$csv, overwrite = TRUE)
  47.  
  48. dbDisconnect(db)
  49.  
  50. return(final_data)
  51. }
  52.  
  53. Error in dbWriteTable(db, table, input$csv_file, overwrite = TRUE) :
  54. object 'input' not found
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement