Hi, does anyone know how to save a file onto the f...
# general
c
Hi, does anyone know how to save a file onto the file cabinet with a size larger than 10MB? We are trying to download a CSV file generated from a map reduce script.
n
compress or split.
πŸ™Œ 1
c
Thanks. But do you know any other way that does not require compressing or splitting the file?
We would like to save the csv as one file.
n
If NetSuite say the limit is 10MB then that's the limit mate, there's no circumventing this, you'd need to use an external storage solution.
c
Gotcha. Thanks!
πŸ‘πŸ» 1
m
Strange i have a suitelet and scheduled script to generate csv from saved search The size of the csv is 180mo
n
Stored in the filecabinet?
m
Yes the csv is created and stored in the file cabinet
n
I didn't raise the question I was going with what was being asked about 10MB. However it looks like 100MB would be the limit, maybe 10MB is for attachments or something... But you're saying 180MB???
Maybe 10MB relates to email attachments only πŸ€”
Hold on, 180MB CSV jeeeesus what you storing in that???
m
Saved search to represent general ledger with multiple information
With date filter it’s 32.14mo But without it’s like 180-200mo
n
Cool @Chris chan Enriquez, are you sure about the 10MB limit you're hitting since Mb is showing a CSV that's 32MB?
m
10MB is the limit per line when you use File.appendLine
βœ… 1
c
@Marc Are you also using appendLine on your script?
@NElliott What the script does before is that it creates the CSV and save it directly without using appendLine.
n
I'm learning some interesting things here. I am familiar with file size restrictions on both email and the filecabinet but entered this conversation not knowing the exact limits and running with what Chris originally said. My point still stands if there's a limit you're not getting around it, you're immediate options are compress or split, if storing in the filecabinet whatever the size limit is. πŸ™‚ At this point what needs sorting out to help you Chris is why are you seeing a problem with 10MB files if that's not the limit? The more detail about what you're doing will help everyone help you. (apologies if my rambling on about filesizes 10mb / 100mb etc has mudded the waters, just trying to help.)
πŸ™Œ 1
c
@NElliott I do apologize for not being able to give more context about what I was trying to do. But I solved the problem with the method @michoel mentioned. Basically the script will create a file with the column headers as its initial content, and then just append certain number of rows that would not exceed 10mb. During testing the script was able to produce 90mb csv file. Thanks for your help everyone. πŸ™‚
n
I appreciate you coming back on this with an update, it will be useful to recall at a later date I'm sure. Everyday is a school day πŸ™‚ I guess the next question is, 90MB today, how big tomorrow and what IS the limit before it breaks for you? πŸ€”