How to handle large docs (Archive Docs)

Showcase Tips and Hacks
13

Hey those on this thread! (@Christiaan_Huizer , @Pch , @Connor_McCormick1 , @Jean_Pierre_Traets ) - Looking through some different archiving options and wanted to stay away from _merge()

The way Im approaching it now is:

  • Holding x amount of archived rows in a single row in a CSV format
  • Using ParseCSV(), formulaMap(), and addRow() to recover the rows

Its seeming to work really well but just wanted to see if ya’ll had any opinions on limitations? Don’t want to go for this method if Im going to run into obstacles down the road - (In this instance, won’t need the data for queries, charts, etc after its been archived. Just want to store the data and not lose it)

Here’s random example doc just as proof-of-concept:

Edit : The only real limits I’m noticing is cell length limits (The amount of characters you can hold in a single cell)

  • Cell with rich text: ~7,000 character limit
  • Cell with no rich text: ~43,000 character limit

You can store rich text (dates for example) as plain text and they are still recoverable. The run I did for the 43,000 character limit was:

  • 1156 rows
  • 4 columns of data per row

If you had to archive more than 43,000 characters you could easily do it in two runs. . .

7 Likes