Import rental objects

 

General

In order to import rental objects, you must first create Categories and Planningen.

 

Import Rental objects in e-Captain

Attention! e-Captain can only import from the first tab in your MS Excel file!

 

To import the rental objects into e-Captain, the following steps must be taken:

 

  • In the main menu, choose Management Centre.
  • Click Import.
  • Then choose in the heading Objects for Import Objects.


importeren-importeren-objecten-1

 

  • The screen below will be opened:


importeren-importeren-objecten-2

 

  • Click the Browse button to select your excel file.
  • Select your Excel file and click the Open button.
  • Click the Send button to continue.
  • Check the columns and adjust the values if necessary.


importeren-importeren-objecten-3

 

  • Then click the Import button! to continue.
  • Click OK to actually import your Excel file into e-Captain.


You have now imported your Excel file. You will now also receive the following message on your screen, indicating how many items have been imported from all items.

 

importeren-importeren-objecten-4

Available fields for import rental objects

For the import of rental objects within e-Captain, the 1st column (A1) of the Excel document must start with the field Obj.no.

 

The first row of the Excel document must consist of the field names, this is the header.

 

importeren-importeren-objecten-5

 

You must ensure that unique object numbers are listed in column A. If the object number does not appear in your file, the object will be added.

 

If the object number is found, it is updated with the data in the excel sheet. When importing you will be asked in which planning you want to import the objects.

 

If you have not created any plans yet, you must do this first. You do this via:

 

  • In the main menu, choose Management Centre
  • Click on Objects.
  • Select the Planning management item.

 

Object data Possible values
Obj.no. (Mandatory 1st column)
Description Texst
Length (comma number)
Width (comma number)
Height (comma number)
Max. length (comma number)
Max. width (comma number)
Max. height (comma number)
Fixed price (comma number) (Only fill in if there is always a fixed price calculated for this object No use is made of the automatic price calculation methods)

 

Example import document

We have made an example import document. You can download it below.

 

Download voorbeeld Excel bestand

 
 
 

Get the most out of e-Captain!

e-Captain has a very extensive Member Management package. We offer several basic trainings which teach you to work with e-Captain in an accessible way.  The trainings take place at our office in  's-Hertogenbosch.

View our trainings

 

TeamViewer

To be able to support you optimally, it can be easy to look with you on your computer from a distance. We use TeamViewer to do this. TeamViewer makes it possible to take over your computer from a distance.

 Download TeamViewer

 

This page was last updated on: 16 August 2018