Are there any limits when it comes to columns in c...
# csvimports
e
Are there any limits when it comes to columns in csv imports? If I have an upload with 100 columns and 10000 rows would I be able to run it? I am curious as to what the limitations of the system really are. NetSuite’s Help Documentation does not mention columns at all, only rows.
l
I'm pretty sure we have imported over 100 columns before. But like you said, the row and file size limit will start to become a factor before the column limit more than likely.
😀 1
*if there is a column limit
e
Thank you! I am very curious as to largest file a NetSuite csv import could handle. By columns and rows.
k
I'd expect performance to be an issue long before you ran into the physical limit
😀 1
e
thank you!
n
25,000 by rows and maybe there is a file size limit also which might limit your cols.
wow 1
e
I thought there would be a column limit for sure! There goes that theory.
k
I mean, if you are loading more than a hundred columns, I'd probably posit you are doing something wrong
😂 1
e
Well, what if we have a lot of metadata we want to bring in from the CRM?
k
How can you effectively report on that many columns out of NetSuite would be my response. and I mean - Digesting it. It's one thing to have it - it's another to use that information well. I'd be tempted to just use the CRM tool for most of that data.
😀 1
e
Thank you all for your advice and replies!