I need to migrate some data from one doc to another. I have a ‘Files’ type column with some binaries and images. Copy / Paste doesn’t move the data from one browser window to another. Anyone have an idea on how to migrate without manually downloading and re-uploading every time? Thanks! 
Hi @Johg_Ananda, for me Copy from one tab and paste in another works!
And also, .url() doesn’t, it could be helpful to import just url of files but it’s not to consider due to file.url() return row url
@Mario What browser are you using?
And what do you mean - can I get the coda CDN url and just link to it? I would think permissions would prevent this?
I’m using latest chrome, maybe you have a big number of file?
Proof:
My idea apart from this was to get the images or files url and recover them from the doc2, but i’m not able to get urls of files with formulas
@Mario OK so you inspired me to try again. I was able copy and paste <10 at a time, but I have a table with about 800 rows (only ~5% have files) and it didn’t work. So it might have somethign to do with the computer’s memory / clipboard.
I’ve got some problem too with copy/paste in coda, but i’m sure 1 year ago i was able to copy enormous table from and into coda, nowadays an empty but with many lookup columns table is “too big to copy”…
The other option as you said is a batch download but then you have to re-upload all of them in the new doc and it’s not practical…
I have two suggestions, first the difficult one.
One can use a platform like Zapier to bring new data from one to another in 3 steps:
- Copy all rows to new table (via a FormulaMap logic in a button)
- Each time a new row is created, a zap is triggered
- you inject the data in the table you set in Zapier
The second and easier option is maybe to work via a cross doc logic. As such you use the second version of the mother doc and from there you set up the new file you fill out with the data using a button and a FormulaMap logic like this:
[Table 01].Filter(Checkbox=true).
email.FormulaMap(AddRow([Table 02],[Table 02].Email,CurrentValue))
I included in this formula a filter option with a checkbox to filiter out the ones you do not need, and this one is about the copy of an email, but this could be anything. And via a lookup as explained here, you have all the rest in a format that permits editing.
Cheers, Christiaan
hey @Christiaan_Huizer thanks for the follow up. These are great ideas … have you tested that they work specifically with binaries/files?
nope I did not test this, but when you have an image URL, the proposed ideas should not be an issue, I guess. Or do did you test something like this and notice it did not work?
Today I tested a few things with images and attachments and filled-out a Typeform with feedback for Coda HQ, I came accross a problem with files (jpg).
Yes exactly, so this post was about the fact that uploaded binaries/files/images don’t behave ‘normal’. Normal meaning if you copy from one table and paste into a table in another browser, they do not always carry over the same way text fields (including image urls) do.
tldr; when copying binaries, copy and paste small groups at a time and it works
1 Like
Does anyone have experience here on how to do this well? I am thinking that if I have a table of 1000 rows, I will try to copy 100 rows and see if that works, and then half until I get N working amount. Then create a view of the table that shows N rows with a button that deletes the 50 showing and reveals another 50, so I can copy/paste/click to reset.
Other ideas?
I just selected an entire column from a filtered table - approx. 30 rows with multiple documents per row (up to 5 docs per row I guess). These are mixed docs (.jpg, .pdf) and they copy in a heartbeat - to a different page in the same doc or to an other doc. I have done this today, but also months ago and never experienced any issues. Size of the combined docs was approx. 120 Mb.
1 Like