Uploading, matching, and attaching files - is this possible?

[hgld]

I have a table that has a text column containing filenames. Each record has a single filename in it.

On my computer, stored locally, I have a folder that is full of the actual files referenced by the filename field.

What I want to do is create a script that goes through each record, attempts to match the filename to one of the files in the local folder, and then if there is a match uploads the matching file as an attachment to the record.

Does this sound possible? Or am I dreaming impossible scripting-block dreams?

[kuovonne]

Currently, the scripting block does not have access to the local file system.

However, the scripting block can access resources on the internet. If you place the files on the web, you can upload them to an attachment field. See the scripting API reference for the write format.

[andywingrave]

This was also announced recently:

Maybe it would help?

[x-post] Launched: upload files in the scripting block! Scripting app

We’re excited to announce a new input method for the scripting block: input.fileAsync ! This enables script users to upload files, which the script can then use to do things like create or update records. If you’ve ever wanted to preprocess the data in your files before importing it to your base with the CSV or XML import block, you can now do so with input.fileAsync ! Because you can access the file contents from inside the script, you could also do things like conditional record creation or…

[kuovonne]

While input.fileAsync does let users upload files, I don’t see a way to upload a local file without user intervention for each file.

[hgld]

Yes, this is the crux. I might have to follow your advice and upload them independently onto the web somewhere, and then upload them as attachments. Thanks for your input and valuable thoughts!

[Hannah_Henry]

I am doing something similar but was planning to first use the gallery view bulk upload (purple X) that gives the option to create a record for each image rather than hosing elsewhere. The gallery attachment upload uses the filename as the primary field. My quandary is how to do what @hgld is asking I think - how then to match to a field name in a separate table, link and attach these images to their corresponding field name. Here are screenshots from a screencast showing how I am doing it manually with linked record. But I have 5,000 sketches I have to match up.