I have a computer-programming background, but readily admit that I am not very knowledgeable in Perl, and my Unix experience was awhile ago, so I apologize in advance for possibly asking naive questions. But I need some help!

My workstation is a PC running Windows 10, and my organization uses a Linux server. I can access our files on the server with FTP.

We have a web application that lets users fill out an HTML form, which (when they hit "Submit") invokes a Perl program on our server. I created this Perl program by borrowing code from Matt's Formmail. My Perl program sends usefully-formatted email to a member of our organization. It works fine.

Now I want the Perl program to also update a Google spreadsheet. So I found the Perl Module called Net::Google::Spreadsheets. And I can't figure out how to install it on our server!

I downloaded the module to my PC and unzipped it. I created a lib directory on our server, and copied the downloaded files and directories under lib onto the server. Just to be safe, I gave 777 permissions to all of these files and directories. For an initial trial, I simply added the following two statements near the beginning of my Perl program:

use lib '../../lib';
use Net::Google::Spreadsheets;

[download]

(Note that my Perl program is located in cgi-bin/formmail/, so it must look two levels up to find lib.)

But when I run the program it gets a General Error. My guess is that it isn't finding all of the pieces of Net::Google::Spreadsheets. I looked at the code within the Spreadsheets module, and found what appear to be references to other Modules. These are things I did not download because I didn't know about them. Must I now download all of those modules? And what if they refer to still other modules?

Is there a straightforward way to install ALL of the Perl stuff I need onto my server? I tried to read articles in PerlMonks about installing Modules, but they seem to assume that I am logged directly into the server - unfortunately my access to the server is only via FTP.

Can one of you kind people help me? Thanks.

-- ted201

In reply to Installing GoogleAPI on my server by ted201

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.