What’s the maximum length of a value stored in a field

What’s the maximum length of a value stored in a field

Postby Anterya » Tue Oct 01, 2024 6:27 pm

Hi, I have a question. What is the maximum length of a value stored in a field of FCD? I encountered this issue before, but at that time the upload form simply reported a smaller amount of rows being actually uploaded (e.g. my spreadsheet had 1000 rows, but only 900 were uploaded), so I was able to fix this by finding the questionable rows/cells and manually making the values shorter. But this time the upload form simply refuses to accept my spreadsheet, so I don't know what to do.

I have a pretty large data (more than 6000 rows), but it was fine before. This time I added the "Text 5" column with relatively large size of values in it, so the upload form gave me an error no matter how many times I tried. I also tried using Google Drive, it uploads this without a warning, but simply ignores the "Text 5" column altogether.

I'm ready to try to experiment with my deck in the hope to fix the problem, but I don't know the maximum length of a value of the field. Or is it about the total maximum length of all fields in a row? I'd appreciate if you could clarify this. Thank you!
Anterya
 
Posts: 5
Joined: Sat Mar 02, 2019 1:10 pm

Re: What’s the maximum length of a value stored in a field

Postby Ernie » Wed Oct 02, 2024 7:22 pm

There is no max length for a field. I'm not 100% sure of this as far as using my website upload goes, but I don't think so. But the website upload can easily get confused with an extra double-quote or a newline in Excel after you copy-paste the Excel data into the website. It's not recommend for complex lists.

Instead I recommend you use Google Drive or OneDrive to transfer. You should be able to upload fields of any length.

I responded to your email.

Ernie
Ernie
Site Admin
 
Posts: 5062
Joined: Fri Oct 01, 2010 6:12 pm
Location: San Francisco / Taiwan

Re: What’s the maximum length of a value stored in a field

Postby Anterya » Wed Oct 09, 2024 5:05 am

@Ernie
I was able to fix the problem with my deck. It was indeed not related to the length of the field / side. But it was good to know that it was confirmed (by your answer) that such a limit doesn't exist.

I replied to your email with the details.

Anterya
Anterya
 
Posts: 5
Joined: Sat Mar 02, 2019 1:10 pm

Return to Comments, Questions and Feedback