Jump to content
  • 0
kpcollier

Importing Excel Files To Table

Question

I'm trying to figure out a way to get our estimating files on Caspio. I have been looking at Scheduled Imports, but I'm a little confused.

Can you only do one file at a time on a scheduled import? If so, does that mean I would have to create multiple scheduled imports and make sure my files are named in the right order? That seems like it won't work for a long time solution. Is there a way to import multiple files a day from excel to Caspio, without being in the Bridge?

Or, maybe, is there a way I could get the upload to happen as soon as my colleague saves it to our office server?

Any insight will be appreciated!

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

You may want to try checking the Web Services Integration (API) thingy. https://howto.caspio.com/web-services-api/

 

However, its kind of complicated.

 

Cant use it myself so I stick with multiple scheduled import and rely on the best practices they suggested: https://howto.caspio.com/tables-and-views/scheduled-import-and-export/scheduled-tasks-datahub/#:~:text=Best Practices,of high-speed data transfer.

Quack

Share this post


Link to post
Share on other sites
  • 0

@NiceDuck Thank you, that's a helpful article and it answered most of my questions.  

May I ask, how many tasks do you have set up? Is there a limit to the number of tasks I can have? I don't need them to run at the same time, just on the same day, and I would probably need ~15 of them. 

I do understand the DataHub Requests per month limit - I am just wondering about actual connections for different files. 

Share this post


Link to post
Share on other sites
  • 0

Hi @kpcollier, I also contacted Caspio and they have stated that the these are the available datahub tasks limitation:

Max File Size: DataHub

Import          50 MB (zipped or unzipped)

Export          50 MB (zipped)

DataHub limitation

6 tasks simultaneously for an account

200 simultaneous  tasks per site.

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...

×
×
  • Create New...