Can I Import From Excel File Through Datapage

[tborley]

I want my staff to be able to update some of the tables with bulk data, several thousand lines per upload.  I don't want them to have access to the Caspio account, so would like to build a datapage to handle the upload.

 

Can this be done?

[MayMusic]

If you want them to feed the table without having access to Caspio you can request for datahub which is a scheduled import/export task. User can put the file somewhere like a FTP site and Caspio can be programed to run for instance every hour to import the data. Using this feature you can either replace the table or append the data to the table

 

If you want to let them update certain records then you can try web services http://www.caspio.com/extend/platform-extensions/web-services.aspx if you know programming.

[edujobs2k18]

On 1/1/2014 at 12:08 AM, MayMusic said:

If you want them to feed the table without having access to Caspio you can request for datahub which is a scheduled import/export task. User can put the file somewhere like a FTP site and Caspio can be programed to run for instance every hour to import the data. Using this feature you can either replace the table or append the data to the table

 

If you want to let them update certain records then you can try web services http://www.caspio.com/extend/platform-extensions/web-services.aspx if you know programming.

can you elaborate it? i just read the article. but couldn't manage to understand this. I am new in this. Don't know much.

[Franchiser]

On 6/5/2018 at 6:18 AM, edujobs2k18 said:

can you elaborate it? i just read the article. but couldn't manage to understand this. I am new in this. Don't know much.

@edujobs2k18

A Web API is a development in web services where emphasis has been moving to simpler representational state transfer (REST) based communications.A web service is an application or data source that is accessible via a standard web protocol (HTTP or HTTPS). Unlike web applications, web services are designed to communicate with other programs, rather than directly with users.

While web services can provide data in a number of different formats, XML and JSON are the most common. These standard text-based formats can be easily recognized and parsed by another program that receives the data. The most common web service protocol – SOAP (Simple Object Access Protocol) – simply adds a header to each XML message before it is transferred over HTTP.

Business-oriented web services may use a standard called UDDI. This formats data in a specific type of XML known as the Web Services Description Language, or WSDL. While UDDI transmits .WSDL files instead of standard .XML files, it may still use the SOAP protocol to transfer data.

Most web services provide an API, or a set of functions and commands, that can be used to access the data. For example, Twitter provides an API that allows developers to access tweets from the service and receive the data in JSON format. Yelp provides an API for programmers to access information about businesses, which can be displayed directly in an app or website. Google Maps provides an API for receiving geographical data and directions from the Google Maps database.

NOTE: An API is a specific set of commands and guidelines used for accessing data, while a web service is an actual service provided by an Internet-based source.

You may try this brief explanation about API: 

 

 

Hope this helps.

-Franchiser-

 

[Pumpedplop]

Hello, @tborley

I found that this is exaclty what I want to do, and was just wondering if you found a working solution in the end. And if you were willing to share it.

[autonumber]

Hi @Pumpedplop - you can check this forum post: