Import images

You can import images, for example for persons, employees, employers (logos), projects, and articles.

You can import images with various file types, such as JPG, BMP, GIF, PNG and TIF. AFAS recommends using the JPEG format. This format takes up little storage space. Images are saved as .jpg or .gif files in Profit. When importing, the image is saved in its regular size and in a small size (thumbnail).

Make sure that the names of images match the codes for data in Profit. For articles, for example, ensure that the name of an image matches the code for the article in question. This allows you to create an import file in Microsoft Excel in which the code for the article and the image are linked.

Import images:

In this example you import photos of employees. The name of the photo matches the code of the employee.

  1. Create an import file. Export the Employees employed view, for example, using the 'Export data to Excel' function. Save this export as a .csv file.  
  2. In the import file, add the field with the location (the path) of the files.
  3. Merge the name of the image with the file location. The following formula allows you to merge the file location, file name (the code of the employee) and the extension:

    =CONCATENATE(A3;B3;C3)

    Note:

    In AFAS Online, the name of the path has a different format.

  4. Go to: the import function (here: HR / Management / Import employee change / Employee).
  5. Follow the regular procedure until you get to the fields.
  6. Drag the field from your import file (with the paths to the images) to the Image location/path field of Profit.

  7. Complete the wizard.

Directly to

  1. Import options for fields
  2. Empty field via import
  3. Import fixed value for a field
  4. Automatically edit import field for this imported
  5. Automatically add consecutive number to field via import
  6. Enter field value for each line during import
  7. Enter field value once during import
  8. Import images