2. Run an Employee Data Import in Sage 100 France

2. Run an Employee Data Import in Sage 100 France

This article explains how to import employee data into Sage 100 France.

Import the Data File into Sage

Overview
After the import format is ready, you can import the real data file (for example, data exported from Factorial). This part of the article explains how to start the import, select the correct format, and generate an error report.


Procedure:

  1. Open Sage and load your employee environment.
    When you go to Liste du Personnel, you can see all existing employees.

  2. Start the import.

    • Click the small arrow next to Créer.

    • Select Importer.

    • Choose Excel.

  3. Choose the import format.

    • Under Format Personnalisé, click the three dots.

    • Select the import format you created earlier (for example, brynq_factorial_import).

    • In the video example, Scenario Template is chosen because it is already complete.

  4. Set the correct option for editing records.
    Sage asks whether existing records may be edited.

    • This must be set to Oui.

    • Confirm when the system shows the value.

  5. Confirm the format and continue.
    Click OK to proceed.

  6. Select the file to import.

    • Browse to the folder where your Excel file is stored.

    • Select the employee data file sent to you or prepared earlier.

  7. Choose the error report type.

    • Select PDF as the report format.

    • Confirm with OK.

  8. Save the PDF file.
    Enter a name such as Result–11December25.pdf.
    Sage now processes the import.

  9. Review the results.

    • Go to the folder where the PDF was saved.

    • Open the report.

    • You will see the number of errors (if any).
      In the example, three errors were included on purpose to show how the report works.

  10. Fix issues if needed.
    You can:

    • Correct the data in your file and import again, or

    • Send the PDF report to the support team for review.

  11. Validate new employees.
    When the import is successful, you will see the newly imported employees in Liste du Personnel.


Alert
Always check your error report after each import. Even small issues (wrong formats, missing values) can cause errors.
If the import format is correct and the data file is complete, the import will create or update all employee records as expected.

This completes the setup and the import process. Good luck with importing your data into Sage!


    • Related Articles

    • 1. Set Up an Employee Data Import in Sage 100 France

      This article explains how to create an import format in Sage in order to import employee data. Create the Import Format in Sage Overview Before you can import data into Sage, you must create an import format. This format contains all the fields ...

    • Integration Between AFAS and Entra ID (Azure AD)

      Integration Between AFAS and Entra ID (Azure AD) Our interface between AFAS Profit and Microsoft Entra ID keeps your employee data consistent and secure — automatically. When someone joins, leaves, or changes roles in AFAS, the interface ensures that ...

    • Integration Between AFAS and Entra ID (Azure AD)

      Integration Between AFAS and Entra ID (Azure AD) Our interface between AFAS Profit and Microsoft Entra ID keeps your employee data consistent and secure — automatically. When someone joins, leaves, or changes roles in AFAS, the interface ensures that ...

    • Certificaat gebruiken voor interne communicatie

      In sommige gevallen staat de agent bij de klant op een andere server dan de proxy (zoals IIX of NginX). Dit betekend dat het verkeer van buitenaf eerst naar de proxy gaat om vervolgens intern naar een andere server gerouteerd te worden. Het is ...

    • AFAS Profit-connector

      Om data uit AFAS Profit op te halen, zijn er twee zaken nodig: een omgevingsnummer en een XML-token. Nadat deze zijn opgeslagen in BrynQ, is het mogelijk om data vanuit AFAS Profit in dashboards in te laden. Instructies Volg de volgende stappen om de ...