Jump to content
  • 0
Sign in to follow this  
Heidi

Can you upload data into a table from an excel file?

Question

Hi All,

I am a newbie - so please forgive me if the answer to this is obvious and I've just missed it.

I want a user to be able to append multiple records from an excel file into a table through a data page.  And I want there to be some checks while they do it (like making sure that there are no blank or duplicated records).   The user might want to upload anywhere from 1 to 1,000 records, so it would be very difficult to do this by hand.  Once the data is loaded,  I want to be able to generate charts and reports from it as if it were a regular data table. Is there a mechanism in Caspio to do this? 

Thank you!

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
On 3/6/2017 at 1:25 PM, Heidi said:

Hi All,

I am a newbie - so please forgive me if the answer to this is obvious and I've just missed it.

I want a user to be able to append multiple records from an excel file into a table through a data page.  And I want there to be some checks while they do it (like making sure that there are no blank or duplicated records).   The user might want to upload anywhere from 1 to 1,000 records, so it would be very difficult to do this by hand.  Once the data is loaded,  I want to be able to generate charts and reports from it as if it were a regular data table. Is there a mechanism in Caspio to do this? 

Thank you!

Hi Heidi,

You can append data to table using manual import or scheduled import task. But it's impossible to insert more than 1 record at once though the datapage.

 You may want to contact Professional Services team, I think they will be able to implement that.

Share this post


Link to post
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...
Sign in to follow this  

×
×
  • Create New...