Export Events

 

DEFINITION

 

The export of events is used to export a set of events from a schedule to an external destination outside VISUAL PLANNING.

Events are exported to a unique destination, which can be:

  • A CSV file format,

  • A worksheet (or a tab) in an Excel file,

  • An XML document format,

  • A database table in one of the following formats:

    • MSAccess,

    • MySQL,

    • Oracle,

    • SQL Server,

    • PostgreSQL,

    • MariaDB.

PREREQUISITES

 

Technical prerequisites

 

The technical prerequisites vary depending on the technology used by the destination.

The principal is that the destination exists and VISUAL PLANNING can access it properly.

Other pre-requisites may appear depending on the trigger used to start the export.

 

Functional pre-requisites

This functionality has no indispensable pre-requisites.

However, for proper use, it is recommended that:

  • A heading is created, named VPEXPORT, in the following format:
    • Boolean,
    • Text,
    • or Multi-line text.

This heading is used to store the last export date and time, the login and the name of the context used for the export, excluding the Boolean function, which is ticked once the export has been completed.

Print Friendly, PDF & Email
1 Etoile2 Etoiles3 Etoiles4 Etoiles5 Etoiles (2 votes, average : 5.00 on 5)
Loading...
Consulting training

Need training?

Use our consulting services!