Jump to content
  • 0

Importing/Exporting spreadsheet with list-DataType


WatashiwaJin
 Share

Question

3 answers to this question

Recommended Posts

  • -1

Hello @WatashiwaJin,

Just wanted to let you know that I also experience that kind of issue before, and when I ask Caspio support they informed me that importing or exporting table(s) with List Data-Type values will not be included because they said that this issue is one of the current Caspio’s limitation.

Regards,

IamGroot

Link to comment
Share on other sites

  • 2

Hello @IamGroot,

Just wanted to inform you, I found a way to export/import a table/database with List-DataType value inside it. 

1. Change the DataType to "Text(255) field" and Export it.

2. And in your Excel file, make sure that the value for the List-String field is comma separated like this: (Item1,Item2,Item3,Item4, etc.)

3. Proceed with the import as usual. After successfully importing your file. Go to your Table and to the Table Design.

4.  Change the "Text(255) Field" (The one we changed in step 1) back to List-String DataType.

5. Then it will just return the way it was. If you want to export it (reapeat step(1)).

I hope this helps :) 

~WatashiwaJin~

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...