Comments (2)
Try the option orderHeaders: false
from jsonexport.
That solved the problem, Thanks!
var jsonexport = require('jsonexport');
var options = {
orderHeaders: false
};
router.get('/:catid', function (req, res, next) {
var catData;
models.Product.findAll({
where: {parent_id: req.params.catid},
include: [
{
model: models.ProductNumeric
},
{
model: models.ProductAlphanumeric
}
]
}).then(function (category) {
var dt = datetime.create();
var currentDate = dt.format('Y/m/d');
jsonexport(JSON.parse(JSON.stringify(category)),options,function(err, csv){
if(err) return console.log(err);
res.setHeader('Content-disposition', 'attachment; filename=category_' + req.params.catid + '_' + currentDate + '.csv');
res.setHeader('Content-type', 'text/csv');
res.charset = 'UTF-8';
res.write(csv);
res.end();
});
});
});
//CSV
id,parent_id,regular,parent,child,configuration,name,alias,part_number,status,published,pb_free,rohs,hirel,is_new,registerable,navigation,search
84192,3551,1,0,0,(none),name,alias,PD-LPM-0102EP,Obsolete,1,0,0,0,0,1,1,1
84193,3551,1,0,0,(none),name,alias,PD-NPM-0305EP,Obsolete,1,0,0,0,0,1,1,1
84194,3551,1,0,0,(none),name,alias,PD-NPM-0306EP,Obsolete,1,0,0,0,0,1,1,1
84944,3551,1,0,0,(none),name,alias,PD70101ILQ,In Production,1,1,1,0,0,1,1,1
84945,3551,1,0,0,(none),name,alias,PD70201ILQ,In Production,1,1,1,0,0,1,1,1
84195,3551,1,0,0,(none),name,alias,PD-NPM-0307EP,Obsolete,1,0,0,0,0,1,1,1
84196,3551,1,0,0,(none),name,alias,PD-NPM-0308EP,Obsolete,1,0,0,0,0,1,1,1
136582,3551,1,0,0,0,name,alias,PD81001,In Production,1,1,1,0,0,1,1,1
from jsonexport.
Related Issues (20)
- Stream does not support typeHandlers option HOT 3
- How to remove the title option from inside xls file
- Nested JSONObject not correctly mapping to csv
- Update v2.5.2 to v2.5.3 with Bug Fixes for package.json stuck on v2
- verticalOutput with Arrays HOT 1
- No option to ignore fields / limit fields to export ? HOT 2
- large files not converting HOT 10
- (I think I) found a bug HOT 6
- typeHandlers tests & more samples
- speed question/issue HOT 4
- Column values with zero (0) are being replaced with "" HOT 3
- Complex JSON array - unexpected behavior HOT 1
- Need Help : Complex Json Array to CSV HOT 2
- Json Complex Example HOT 2
- JSON Array not converting to CSV HOT 1
- TypeError: this._options.handleDate is not a function HOT 5
- Question. What is expected behaviour when exporting objects where some do not have all fields in header HOT 12
- typeHandlers is not part of UserOptions HOT 2
- CLI: Json Complex Object outputting all keys as headers HOT 11
- Exporting a dataset with a hashtag (#) in a string breaks CSV HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jsonexport.