Navigation:  Settings > Import & Export >

Import Data

Previous pageReturn to chapter overviewNext page
Show/Hide Hidden Text

Main Menu > Settings >  Import & Export > Import Data (T > I > I)

Through this option you can import data into FR6 from other popular data formats like Excel (.xls), Text (CSV), Text (TAB) and XML (.xml).

The format is mapped in FusionRetail’s specific module, ex: Product Master’s field list. Once this mapping is saved, you may specify time interval by pressing Alt + A key (Auto Import).

You may specify that mapped data file will be available at specified location. This way FusionRetail 6 is configured to look for data at specified location at specified time interval.

 

Fields in the Import Data:

Fields in the Import Data are as follows:

Import As

Select the data to be imported (master or transaction) from the list (like Accounts, Brand, City, Colour, Country, Customer, Opening Stock, Product, Purchase, Purchase Return, Sale, Sale KOT, Sale Return, Size, State, Sub Group, Units etc.

File Type

Select the file type of the import data

Excel 2007 format
Excel (97-2000) format
Text(CSV)
Text(TAB)
XML

Data Include Header Row

Set Yes if the import data includes a header row, else set No

Import Dependency Data

Set Yes to import respective masters along with transactions. In this case you don’t need to import masters separately related to the transactions. If related masters are already exist then set it No.

File Name

Press <enter> and select the File Name

Buttons in the Import Data:

Buttons in the Import Data are as follows:

F10 Save Mapping

Click this button to save names of column header of any format. You can utilize this in auto import where it imports the files whose setting matches the mapping file.

F9 Load Mapping

Click this button to load all names of column header on any format by selecting desired mapping name.

-I Import

Click this button to import data like product master, customer master etc.

-L List

Click this button to open list of selected column.

Importing Physical Stock from Excel file:

It is very easy to import physical stock from an Excel file. FusionRetail6 provides a very user friendly option to import all of your physical stock from an excel file. Now you can scan all your items in an excel file and finally import that Excel file as Physical stock.

Import As

Select Physical Stock to import physical stock from excel file.

File Type

Select the file type of the import data

·

Excel 2007 format

·

Excel (97-2000) format

·

Text(CSV)

·

Text(TAB)

·

XML

Data Include Header Row

Set Yes if the import data includes a header row, else set No

File Name

Press “Enter” and select the File from its location.

Note:

1. If No Warehouse selected then It will take default warehouse ie. '[None]'.

2. If No Location selected then it will take Current Location (Selected by F12).

3. If No Date selected then it will take current date & time.

4. No Master will be created here. Product child is mandatory to import from excel file.

 

You have to map the column of the excel file with the database columns. The available columns are...

[NONE]

Used to discard any column.

Location

Used to map the Location column of the excel file with the database column.

ProductChild ID

Used to map the ProductChild ID column of the excel file with the database column.

Qty

Used to map the Qty column of the excel file with the database column.

Vch Date

Used to map the Vch Date column of the excel file with the database column.

Warehouse

Used to map the Warehouse column of the excel file with the database column.

Related Faqs: