TsQ07CzU

1const express = require('express');
2const router = express.Router();
3const bodyParser = require('body-parser')
4const urlencodedParser = bodyParser.urlencoded({ extended: false })
5const jsforce = require('jsforce');
6const fs = require('fs');
7const Json2csvParser = require('json2csv').Parser;
8const flash = require('connect-flash');
9const jsonexport = require('jsonexport');
10
11
12
13 router.post('/auth', urlencodedParser, function (req, res) {
14         const ACCOUNT = {
15         username: req.body.username,
16         password: req.body.password,
17         securityToken: req.body.securityToken
18         }
19
20        
21         const conn = new jsforce.Connection({
22            instanceUrl : 'https://cunning-wolf-guynfm-dev-ed.my.salesforce.com/',
23           });
24        
25           conn.login(ACCOUNT.username, ACCOUNT.password + ACCOUNT.securityToken, function (err, res) {
26             if (err) { 
27               return console.error(' I am not working correctly ' + err);
28              }
29             conn.query('SELECT Id, Name FROM Account', function (err, res) {
30               if (err) {
31               return console.error(err);
32              } 
33        
34              const contact = [];
35               for (let i = 0; i < res.records.length; i++) {
36                   const data = {
37                     First_Name: res.records[i].Name,
38                     Last_Name: res.records[i].Name,
39                     Resource_email: 'hello' + i + '@gmail.com',
40                     Phone_1_Type: 'Mobile',
41                     Phone_1_Value: '02020220020202' + i,
42                     Phone_2_Type: 'Mobile',
43                     Phone_2_Value: '02020220020202' + i
44                   }
45                   contact.push(data);
46               }
47          
48      
49                  jsonexport(contact,function(err, csv){
50                  if(err) return console.log(err);
51  
52                  fs.appendFile(__dirname + '/contact-details.csv', csv, 'utf8', function (err) {
53                  if (err) {
54                    console.log('Some error occured - file either not saved or corrupted file saved.');
55                  } else {
56                    console.log('It\'s saved!');
57                  }
58                });
59});
60
61//                 fs.appendFile('contact-details.csv', csv, 'utf8', function (res, req, err) {
62//                   if (err) {
63//                     console.log('Some error occured - file either not saved or corrupted file saved.');
64//                   } else {
65//                     console.log('It\'s saved!');
66//                   }
67//                 });
68            
69             });
70         });
71         res.redirect('/download');
72   });
73
74
75
76
77module.exports = router;
78
79
80// const convertContact = JSON.stringify(contact);
81// var array = typeof convertContact != 'object' ? JSON.parse(convertContact) : convertContact;
82// var str = '';
83
84// for (var i = 0; i < array.length; i++) {
85//     var line = '';
86//     for (var index in array[i]) {
87//         if (line != '') line += ','
88
89//         line += array[i][index];
90//     }
91
92//     str += line + '\r\n';
93// }