Upload an Excel file automatically on MadCap Flare

This forum is for all Flare related Tips and Tricks.
Have a tip or trick you use while working in Flare? Share it here.
Post Reply
Mritunjay_g
Propeller Head
Posts: 74
Joined: Tue Apr 11, 2017 11:56 pm

Upload an Excel file automatically on MadCap Flare

Post by Mritunjay_g »

Hi All,

Can anyone help me in uploading the Excel file on MadCap Flare automatically?

Pls, guide me if, by some other means, we can achieve it.


Thank you
Mj
RStreets
Propeller Head
Posts: 63
Joined: Wed Apr 19, 2017 8:37 am
Location: Cambridge, UK

Re: Upload an Excel file automatically on MadCap Flare

Post by RStreets »

Hi Mj,

Have you looked at using the Excel imports option? You can configure this to Auto-reimport before 'Generate output' (in the options tab of the Excel Import Editor). Once defined, this will pull in changes to the specified excel sheet(s) each time you build.

If you then want to automate publishing the output, could you make use of a Batch target with a scheduled build?
Rae Streets (Flare user since 2017, now on Flare 2023; Central user from 2020)
Mritunjay_g
Propeller Head
Posts: 74
Joined: Tue Apr 11, 2017 11:56 pm

Re: Upload an Excel file automatically on MadCap Flare

Post by Mritunjay_g »

Hi RStreets,

Thank you very much for your response.
I am using flare 2017r3, where I can find this Excel Import Editor?

I have to maintain the history, so, I can opt for uploading Excel also. And, the topic in flare will keep on appending with new uploads every time. Appending text will make it large very soon.

Yes, I have automated the publishing of output.

Again, Thank you very much for taking my query.

Thanks,
Mj
RStreets
Propeller Head
Posts: 63
Joined: Wed Apr 19, 2017 8:37 am
Location: Cambridge, UK

Re: Upload an Excel file automatically on MadCap Flare

Post by RStreets »

In the Project Organizer, right click the Imports folder, and choose Add MS Excel Import File...
Rae Streets (Flare user since 2017, now on Flare 2023; Central user from 2020)
Mritunjay_g
Propeller Head
Posts: 74
Joined: Tue Apr 11, 2017 11:56 pm

Re: Upload an Excel file automatically on MadCap Flare

Post by Mritunjay_g »

Thanks RStreets,

I will give a try to this.
Post Reply