Mamut Import/Export

File - Import - Import/Export - Import from Excel or File - Import or Export - Import/Export

Mamut Import/Export is a program that simplifies communication between Mamut Business Software and other programs. Mamut Import/Export contains several predefined formats for import and export of customers, suppliers, products, orders, invoice information etc.

There are two ways available to import and export information to and from Mamut Business Software: via Microsoft® Excel® or CSV files.

Import from Excel

To import data from Excel into Mamut Business Software, you have to create an Excel file. The first line should contain field headings, which the import wizard will display when you map the columns in Excel to the fields available within Mamut Business Software. To access import from Excel, go to File - Import - Import/Export - Import from Excel.

Import/Export (CSV files)

CSV files are commaseparated files (*.csv) which can be opened either as text or via Excel and the data you wish to import into Mamut Business Software needs to conform to specific pre-defined formats. More information about the file formats for importing and exporting CSV files can be found in Description of CSV file formats. Mamut Import/Exportfor CSV files can be started by going to File - Import - Import/Export or File - Export - Import/Export in Mamut Business Software. Alternatively, you can double-click on the program icon Mamut ImportExport.exe in the folder where you installed Mamut Business Software.

A number of example files are included when installing Mamut Business Software. The example files can be found in the folder containing the program files: "…\Mamut\ImportExport\ExampleFiles".

The example files, as well as files exported from Mamut Business Software, are text files which can be opened with Microsoft Excel. However, before you can open the files in Excel you must first change the file format from .txt to .csv. The .csv file will open in Excel as a semicolon-separated file - making the file much easier to read and edit.

You can import both .txt (as in the example files) and .csv files to Mamut Business Software. When saving an Excel file you wish to import, simply choose File - Save as and select the file type CSV (comma-separated) (*csv).

Before getting started with import files, you are advised to make sure that your Windows platform is configured to display lists separated with semicolon <;>. The setting can be found by navigating to the Windows Control Panel. Click Clock, Region, and Language - Change the date, time, or number format - Formats - Additional settings - List separator (the description refers to Windows 7 and may differ from other Windows editions).

Backup

Before importing data you should always create a backup copy; in case the import process malfunctions you will be able to restore the backup before trying again. Create a backup copy by clicking File - Backup - Create backup.