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

[Heidi]

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!

[Mathilda]

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.