What I’m trying to do:
Take an Anvil-written CSV file, exported from a table via the Anvil IDE, and write a routine for importing it into a similar table.
For example, I have data in one of an App’s database’s tables, and I want to copy it into the same table, but in one of the App’s other databases.
I want to make sure that I have all of the potential column types covered.
In all of the examples I’ve tried so far, a link_multiple column is rendered into CSV format in one of the following forms:
""– from a column value ofNone"#ROWS[]"– from a column value of[](an empty list)"#ROWS[[t,r1],[t,r2],…]"– from a column value containing row ids,
where t is the numerical table id, and r1, r2, … are row numbers within that table. This is a rendition of the
In my sample data, I have seen a None or "null" entry for a link_single column. So it makes sense to me that one might appear inside a link_multiple list; but I’ve never seen one. Nor will the IDE let me enter one manually.
Just wondering whether this is a case that I need to accommodate.