Import/Export Visites

Principle:

Import allows technical visit records to be added in bulk to the system using a file in a specific format (usually Excel).

Import Steps:

Access the Import Module:

• Click on the optionImportin the technical visits menu.

Download the Pre-Formatted Template:

• Download the template file to ensure the data follows the required structure.

Fill in the Data:

Complete the file with the necessary information:

Required Fields:

• Vehicle
• Start date
• End date

Optional Fields:

• Number, Amount excluding VAT, Amount VAT, Stamps, Type of technical visit, CNPAC, Technical visit center, COM TAX, CNEH, Total amount, Attachment, Comment, User.

Import File:

• Sélectionnez et téléversez le fichier complété dans le système.

Vérification et Validation :

• Le système analyse le fichier pour détecter d'éventuelles erreurs ou incohérences.
• Correct the reported errors and retry the import if necessary.

Confirmation:

• Une fois le fichier validé, les enregistrements sont ajoutés au système, et un message de confirmation est affiché.

Export of Technical Visits

Principle:

The export generates a file containing all the data from the recorded technical visits, organized for external use (analyses, audits, sharing).

Export Steps:

Access the Export Module:

• Click on the optionExportin the technical visits menu.

Select Criteria:

• Optionally, apply filters to include only specific records.

Start the Export:

• The file is generated in Excel format.

Download the File:

• Click the link to download the file.

Exported Data:

• Fleet: Identifier or name of the fleet.
• Registration: Vehicle registration number.
• Number: Unique reference for the technical visit.
• Type Technical Visit: Periodic, exceptional, etc.
• Amounts: Excl. VAT, VAT, CNPAC, COM TAX, CNEH, Stamps, Total amount.
• Technical Visit Center: Name or reference of the center.
• Dates: Start and end of validity of the visit.
• How: Additional notes.
• User: Identity of the user who added or modified the record.

Benefits of the Feature

For Import:

• Time Saving:Quickly adding a large volume of data.
• Uniformity:Using a standardized format reduces errors.

For Export:

• Clarity:The exported data is well structured, making it easier to use.
• Flexibility:Users can choose to download all or part of the data according to their needs.
• Simplified Sharing:Files can be transmitted to internal or external stakeholders.

Conclusion

The import and export of technical visits strengthens the management and monitoring of vehicles by allowing rapid and structured data processing. These tools guarantee increased efficiency and better collaboration between teams.