Import PDF file generated in Microsoft Access

  • Hello Support.. I am looking at a project that would allow the import into my WP site from a pdf created in Microsoft Access.

    This pdf file is updated every 15 minutes and I was looking at a way to automatically import /update the pdf file to a specific page.

    The pdf file is created by Microsoft Access and updated in the application every 15 minutes and saved to a folder on my local computer replacing the existing pdf.

    I do not know if this is possible to automate the process but hopefully there is a plugin that may help?

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)

  • Alexander,

    You could use the WordPress API (https://developer.www.ads-software.com/rest-api/reference/posts/) to update the post every time it is generated.

    Let me know if you need more help. [redacted]

    Thread Starter alexanderweb

    (@alexanderweb)

    Sorry for the late reply Steve. I did not get a notification so will check and update.

    API is completely new to me but I am willing to learn.

    The pdf would be on its own page and the pdf generated in Microsoft Access would be saved to a specific folder eg My Desktop.

    From the Desktop I was hoping to automatically send the pdf to the website page (via a button on my Access form) and as we update results every 15 minutes I wondered if the PDF could be updated.

    Thanks
    Alexander

    Yes Alexander,

    You could make a script on your local machine. It would do the following:

    Every 15 minutes

    1. Get the pdf file from local machine.
    2. Check if there has been any changes from previews one.
    3. Use WordPress api to connect to the site and update a specific post.
    4. Thats it..

    Thread Starter alexanderweb

    (@alexanderweb)

    Many thanks eliasmarca … you make it sound very easy !!!

    So I can leave the file name of the PDF the same each time I save it on the local computer. Originally I had planned to change the name each time we saved a result.

    By specific post can I take it you also mean a specific page that contains the PDF?

    As I said I am willing to learn so the first step should be to find some examples of API in action and see if I can work out how to do it.

    By script are you referring to a .bat file as I would do in DOS?

    Thanks for your continuing help and pointers.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Import PDF file generated in Microsoft Access’ is closed to new replies.