Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Is there a way to automatically upload an excel sheet on a scheduled time from sftp folder?

I am looking to set up an automatic upload of data from an excel sheet 

1 answer

1 accepted

0 votes
Answer accepted
Daniel Eads Atlassian Team Mar 10, 2020

Hi Ramitha,

Thinking about your ask to upload an excel sheet on a schedule, I came up with some ideas:

  • Using the REST API - you could write a small script that attaches the Excel sheet to Confluence Cloud using the attachment REST API. Scheduling the script would then depend on your system - in Linux you could create a cron job to run it on a specific schedule, or on Windows you could add the script to the Windows Task Scheduler.
  • Using an upload connector from the Atlassian Marketplace - there are several apps that provide upload capabilities from various sources. While I'll just encourage you to take a look at the published apps, it's possible you may find something that fits your need (even if it bypasses the SFTP folder).
  • Get the data directly from source - this might be beyond what you're looking for, but it's worth examining the entire pipeline of where the data is coming from. If there's a database export generating the Excel spreadsheet, maybe a more interesting option would be to get the data directly from the database into Confluence using something like the External Data for Confluence app.

Hopefully this provides some ideas to get you going. There might be some solutions to your needs just outside the normal "upload an Excel sheet" box!

Cheers,
Daniel

Hi Daniel,

Thank you so much for your valuable inputs. Def you provided me with some thoughts for me to think more based on my needs.

I am planning to try option 1 and see how it works out 

Ideally 3 might be great because my source is a  database, so might look into it to see how licencing works for our firm. We do not have it with the plan which we currently have 

Thanks again! 

Cheers,

Ramihta 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

8,591 views 7 7
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you