Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- importXLS: function (req, res) {
- var uploadFile = req.file('xlsx_file_to_import');
- var request = require('request');
- var url = req.body.url;
- //console.log(req.params()); -> send error params is not a function
- console.log(req.body); // send me {}
- console.log(req.param('url')); //send me undefined
- var directoryName = sails.config.appPath +'/.tmp/public/import/xlsx/';
- var shortid = require('shortid');
- var fileName = shortid.generate()+'.xlsx';
- var mkdirp = require('mkdirp');
- mkdirp(directoryName, function (err) {
- if (err){
- console.log(err);
- res.status(500);
- return res.send("Can not create directory");
- }
- uploadFile.upload({saveAs : fileName, dirname : directoryName},function onUploadComplete(err, files) {
- if (err){
- console.log(err);
- return res.serverError(err);
- }
- var xlsx = require('node-xlsx');
- var obj = xlsx.parse(directoryName+fileName);
- var data = obj[0]['data'];
- var objReference = createObjectReference(data);
- //données brut
- var toPost = [];
- for(var i = 1; i< data.length; i++){
- var o = {};
- var j = 0;
- for(var name in objReference){
- o[name] = data[i][j];
- j++;
- }
- toPost[i-1] = o;
- }
- });
- });
- },
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement