Copy seatable attachments to seafile

vqui · December 9, 2022, 9:42pm

Hi,
I would like to transfer attachments from seatable to seafile. Seafile is already connected and attachments are referenced via seafile API to a file column. Attachments added directly to the base should now go the other way around to my seafile to save storage in seatable.

I found the manual that says it works (Seafile integration - SeaTable Admin Manual) but also a forum issue that says seatable to seafile is not yet working (Seafile link to my seatable database).

Is seatable to seafile working? If yes, how?

Thanks.

vqui · December 16, 2022, 11:56am

Is anyone using seatable with seafile together?

vqui · January 4, 2023, 5:49pm

According to the seafile forum this has never been possible most likely will not be implemented.

Too bad no one in this forum has replied so far since it is a documented feature in seatable, not seafile.

Quant · January 5, 2023, 4:36am

Strongly agree with you, I use Seafile with SeaTable, too.
I think the file-share connection between Seafile and SeaTable is vital to their integrated system.
Sometimes, it is the product manager who create user’s demand instead of the user-self.

cdb · January 6, 2023, 8:13pm

Hey vqui and Quant,
as far as I can tell the integration between SeaTable and Seafile is only used by a handful of users. Give me some time, I will clarify what the plans of this featre are and then report back.
Christoph

vqui · June 2, 2023, 7:23pm

For anyone interested in this. I wrote a script that migrates attachments to seafile and adds a link to the file to seatable.

github.com

vquie/seatable-python-snippets/blob/main/migrate_attachments.py

"""
This script downloads file attachments from a SeaTable table row, uploads them to Seafile, and updates the table row with the new URLs.

Prerequisites:
- A SeaTable base and a Seafile library with valid credentials.
- A Seafile API key for the user that is used to connect to the API.

Usage:
1. Connect your SeaTable base to your Seafile library.
2. Create a Seafile API key for your user.
3. Import this script into your SeaTable base.
4. Run the script once. It will create a settings table.
5. Fill the values in the settings table:
   - seafile_host: the hostname or IP address of your Seafile server for the API calls.
   - seafile_api_token: the Seafile API token for your user (not the library).
   - seafile_library_id: the ID of your Seafile library.
   - seafile_library_api_token: the Seafile library API token that you used for connecting to Seafile.
   - seafile_dir: the parent directory of the uploaded files in your Seafile library.
6. Run the script in an automation or via a button.

This file has been truncated. show original