[GH-ISSUE #4104] [FR] When changing column type, attempt to preserve current column information #1843

Closed
opened 2026-03-23 21:17:39 +00:00 by mirror · 2 comments
Owner

Originally created by @speed2exe on GitHub (Dec 6, 2023).
Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/4104

Description

changing a column type will truncate all the column data associated with it.
propose that app should attempt to change to a column type.

Impact

This will help user in exporting and importing csv from database table. due to limited information that can be stored in csv(column type information is lost), appflowy can also consider using other export format(eg. json
ss2
ss1
).

Additional Context

No response

Originally created by @speed2exe on GitHub (Dec 6, 2023). Original GitHub issue: https://github.com/AppFlowy-IO/AppFlowy/issues/4104 ### Description changing a column type will truncate all the column data associated with it. propose that app should attempt to change to a column type. ### Impact This will help user in exporting and importing csv from database table. due to limited information that can be stored in csv(column type information is lost), appflowy can also consider using other export format(eg. json <img width="727" alt="ss2" src="https://github.com/AppFlowy-IO/AppFlowy/assets/33050391/a0231068-9c38-4633-9b97-988c316edc8f"> <img width="744" alt="ss1" src="https://github.com/AppFlowy-IO/AppFlowy/assets/33050391/c37e1be0-8f08-43dd-b044-3eebfc53deb9"> ). ### Additional Context _No response_
mirror 2026-03-23 21:17:39 +00:00
Author
Owner

@speed2exe commented on GitHub (Dec 6, 2023):

the above image shows importing a doc after exporting

<!-- gh-comment-id:1842131564 --> @speed2exe commented on GitHub (Dec 6, 2023): the above image shows importing a doc after exporting
Author
Owner

@appflowy commented on GitHub (Dec 20, 2023):

The CSV file currently consists only of plain text. However, we have the capability to add more detailed information to the CSV file during the export process. To accommodate this, we could introduce a new export format, which we could name 'afcvs'.

<!-- gh-comment-id:1863813767 --> @appflowy commented on GitHub (Dec 20, 2023): The CSV file currently consists only of plain text. However, we have the capability to add more detailed information to the CSV file during the export process. To accommodate this, we could introduce a new export format, which we could name 'afcvs'.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
AppFlowy-IO/AppFlowy#1843
No description provided.