Seeking help uploading batches of JPEGs and extracting filename into multiple columns

[shaneartistry]

Hello,

Currently using the free cloud plan. I’m looking for a way to mass upload JPEGs into an attachment column, creating one row per JPEG. The JPEG filenames are ID-title-size. I’d like to extra the filename info into separate columns (ID, title, size) as well. Is there a way to easily do this? I’ve tried a couple different formulas but couldn’t get it to work.

[rdb]

There is no easy (no-code) way. Sorry.

But a Python script should get you pretty far. Here’s what you can do:

• Add a table with the four columns: ID (text), title (text), size (number) and JPEG (image) (you can also use different column names)
• Upload the files in bulk into a base’s file storage via file management (now the files are available in the base)
• Use a Python script to a.) read all files from the base’s file storage and b.) create new rows using the information from the file name to populate the column ID, title, size and c.) insert the link to the file into column JPEG.

More on Python scripting in SeaTable: Introduction - SeaTable Developer Manual