Setting scheduling options for FTP

Now that you have the InfoObject for the FTP destination, you can use the PluginInterface to set the scheduling options that are specific to FTP. These include:

• The address of the FTP server.
• The port that the FTP server is listening on. This is typically port 21.
• The account name, which is used by the FTP server to determine your home directory.
• The user name, which is used to authenticate you.
• The password.
• The file name of the instance. This is optional. Crystal Enterprise will generate a file name if you do not specify one.

For example:

FTPSchedulingOptions = FTP.PluginInterface("").ScheduleOptions;

FTPSchedulingOptions.Account = "jmudge";

FTPSchedulingOptions.ServerName = "ftp.pelican.com";

FTPSchedulingOptions.UserName = "jmudge";

FTPSchedulingOptions.Password = "password";

FTPSchedulingOptions.DestinationFiles.Add ("MyInstance.rpt");

FTPSchedulingOptions.Port = 21;

Once the FTP options are set, you must copy them into the Report.ScheduleInfo.Destination. This will cause the instance to be transferred via FTP after it has been processed. For example:

Report.SchedulingInfo.Destination.SetFromPlugin (FTP);

You are now ready to schedule the report using the InfoStore. The complete example for scheduling via FTP is given below. You can now choose to go to:

• Setting scheduling options for SMTP
• Setting scheduling options for the disk
• Setting scheduling options for the printer
• The section's Example

Example

function ScheduleToFTP(IStore,ReportId, ServerName, AccountName, UserName, Password, FilePath, Port)

{

    var Reports = IStore.Query("SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_ID="+ReportId);

    if (Reports.Count == 0)

    {    

        return;

    }

    var Report=Reports.Item(1);

    var ScheduleInfo ;

    //Create an interface to the scheduling options for the report.

    ScheduleInfo = Report.SchedulingInfo;

    // Run the report once.

    ScheduleInfo.Type = 0;

    // Run it right now.

    ScheduleInfo.RightNow = true;

    var FTPSchedulingOptions;

    var FTP;

    FTP = IStore.Query("Select Top 1* from CI_SYSTEMOBJECTS where SI_PARENTID=29 and SI_NAME='crystalenterprise.ftp'").Item(1);

    FTPSchedulingOptions = FTP.PluginInterface("").ScheduleOptions;

    FTPSchedulingOptions.Account = AccountName;

    FTPSchedulingOptions.ServerName = ServerName;

    FTPSchedulingOptions.UserName = UserName;

    FTPSchedulingOptions.Password = Password;

    FTPSchedulingOptions.DestinationFiles.Add (FilePath);

    FTPSchedulingOptions.Port = Port;

    ScheduleInfo.Destination.SetFromPlugin (FTP);

    //Tell the APS to schedule the report.

    IStore.Schedule (Reports);

}