I imported sheetJS like I would any other module a...
# suitescriptr
reptar
09/01/2023, 3:53 PMI imported sheetJS like I would any other module and it's showing undefined.
a
Anthony OConnor
09/01/2023, 4:02 PMwhat do you mean by "it's showing undefined" where is it showing that?
r
reptar
09/01/2023, 4:07 PMCannot find property utils of undefined
reptar
09/01/2023, 4:08 PMUntitled.js
reptar
09/01/2023, 4:08 PMThis is summary stage of an MR.
a
Anthony OConnor
09/01/2023, 4:10 PMhuh ok, that is weird. You're not using sheetJS until the summary?
and the file is in the libraries folder, not in /libraries/SheetJS/ ?
r
reptar
09/01/2023, 4:11 PMIt's in the same folder as the other library i'm using in this script
a
Anthony OConnor
09/01/2023, 4:11 PMfigured, just ruling stuff out
r
reptar
09/01/2023, 4:12 PMIt's my first time using sheetJS. I followed the NS instructions and landed here: https://cdn.sheetjs.com/xlsx-0.20.0/package/dist/xlsx.full.min.js
a
Anthony OConnor
09/01/2023, 4:23 PMsorry, you want someone more familiar with the specifics of sheetJS, but my gut instinct is that .min file is for browser usage and it wont work serverside / in an MR script.
r
reptar
09/01/2023, 4:30 PMIt says the script I linked is verified for MR. https://docs.sheetjs.com/docs/demos/cloud/netsuite/
a
Anthony OConnor
09/01/2023, 4:41 PMI don't feel like this section is very clear.
Anthony OConnor
09/01/2023, 4:46 PMoh maybe that stuff is just optional... hmm I know it shouldn't matter but try changing the alias to XLSX like they use in all their docs
r
reptar
09/01/2023, 4:58 PMi did that. also tried using core.min.js with a shim. https://netsuiteprofessionals.com/blog/question/does-sheetjs-work-in-netsuite-serverside-script/
a
Anthony OConnor
09/01/2023, 5:14 PMaight.. gimme a few minutes, I've not used it but one of my colleagues has, let me take a look at his code and figure out how he got it working (he's on PTO today)
thankyou 1
r
reptar
09/01/2023, 5:24 PMyou might try doing a diff with the source code. in at least one article they mention hacking on the source code... ... ... 😕
reptar
09/01/2023, 5:34 PMtried this, but it's not recognizing my config i don't think. i don't typically use an amdconfig either. https://github.com/nserpsolutions/public/tree/main/excel-samples
👍 1
a
Anthony OConnor
09/01/2023, 5:39 PMyeah code is looking wildly different, maybe he had to get an old version of it... or he's tried with the mini instead of full... and then switched back but used the mini file name that still existed lol yeah need to do some more diffs 😂
Anthony OConnor
09/01/2023, 6:05 PMugh... i know why this code looks so different, we bought the paid version
r
reptar
09/01/2023, 6:12 PMso that link i shared... it works. not sure why it's not working in my MR.
reptar
09/01/2023, 6:12 PMi have a working scheduled script that produces a spreadsheet
a
Anthony OConnor
09/01/2023, 6:13 PMwhich link?
Anthony OConnor
09/01/2023, 6:14 PMso I doubt its actually an issue, but why does your other lib have spaces in the file name? don't have spaces in files names, why would you do that?
r
reptar
09/01/2023, 6:16 PMi do that all the time
a
Anthony OConnor
09/01/2023, 6:17 PM🤮
r
reptar
09/01/2023, 6:17 PMit's perfectly allowed...
a
Anthony OConnor
09/01/2023, 6:17 PMnot by ME it isn't 😂
Anthony OConnor
09/01/2023, 6:19 PMso you got it working with the NAmdConfig and the JSONconfig path file stuff?
r
reptar
09/01/2023, 6:22 PMyep, just trying to apply that to my MR
reptar
09/01/2023, 6:22 PMalso had to include jszip
👍 1
reptar
09/01/2023, 6:25 PMresolved. god that was a headache
a
Anthony OConnor
09/01/2023, 6:28 PMhey man that's good work for a Friday... you earned your weekend 👍
true news 1
4 Views