Guest User

Untitled

a guest
May 20th, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 KB | None | 0 0
  1. fs.readFile('C:/upload2.csv', {encoding : 'utf-8'}, function (err, data) {
  2. var insert_data = data;
  3. var options = {
  4. mysql: {
  5. host: 'localhost',
  6. user: 'root',
  7. database: 'manajemen-event',
  8. },
  9. csv: {
  10. comment: '#',
  11. quote: '"'
  12. },
  13. table: 'venue'
  14. }
  15. cm.import(options, insert_data, function (err, rows) {
  16. if (err === null) err = false;
  17. expect(err).to.equal(false);
  18. req.flash('message_success', 'Berhasil mengimport menggunakan CSV');
  19. res.redirect('/manajemen_list_venue');
  20. });
  21.  
  22. })
  23.  
  24. var data = '"c1","c2","c3"n"1","2","3"n"4","5","6"';
  25.  
  26. var data = '"A","B"n"1","2"n"3","4"';
Add Comment
Please, Sign In to add comment