All columns to be imported must be formatted as text in the Excel sheet. If this is not done, you risk that data will not be imported into 24SevenOffice.
It is possible to export custom dimensions from one client and import into another client. If you do not have any custom dimensions in the client before, set DimensionType to 101 on the first dimension, DimensionType 102 on the second dimension, and so on.
Dimensions: | |
Import Field | Explanation |
Dimension type | Dimension ID |
DimensionName | Name of dimension |
DimensionRowValue | Dimension row ID |
DimensionRowName | Dimension row name |