Batch Processing

udiMagic v3.0 Release 1.67 supports "Batch Processing". In simple words, it allows you to "import data in Tally from multiple excel sheets" in one-go.

Using the "Batch processing" feature is quite easy. The steps (with screen-snapshots) are given below :-


STEP 1

Start udiMagic and click on the NEXT button.

STEP 2

Select the option "Excel to Tally" and click on the NEXT button.

STEP 3

Select the option "Multiple Excel Sheets" and click on the NEXT button.

STEP 4

Click on the NEXT button.

Remarks:-
a) The default file-name "Batch-process.xml" appears automatically.
b) The "Batch-process.xml" file contains a list of Excel-files from which data is to be imported into Tally.
c) You can view or edit the "Batch-process.xml" file by clicking on the "View/Edit" button. Alternatively, you may use any Text-Editor (say Notepad.exe) to view / edit the "Batch-process.xml" file.
d) A sample entry from the "batch-process.xml" file is given below for your reference.

<FILELIST.LIST>

<!-- TO DO : Specify the data-type here MASTERS or VOUCHER-->
<RECORDTYPE>Masters</RECORDTYPE>

<!-- TO DO : Specify the Excel file name here -->
<EXCELFILE>Master - GroupMaster.xls</EXCELFILE>

<!-- TO DO : Specify the XML tags file name here [Optional] -->
<XMLTAGSFILE></XMLTAGSFILE>

</FILELIST.LIST>
STEP 5

Click on the START button to start the process of Importing data into Tally.

Remarks:-
a) You may enable the Auto-Run feature (a tick sign means enabled). The Auto-Run feature would be effective from the next-time. (i.e. when you run udiMagic next-time).
b) The Auto-Run feature automatically processes (imports) data into Tally, thus saving your time and Clicks.

SUMMARY

Batch Processing

The Batch-processing feature allows import of data from multiple Excel sheets into Tally Software in one-go.

Auto Run

The Auto-Run feature allows import of data into Tally without any user-intervention. The auto-run status report is generated in autorun.txt file.

Scheduling udiMagic to run a specific time

With the Auto-Run and Batch-Processing features, you can automate your tasks. In simple words, you can schedule udiMagic in such a way that it automatically runs at a specified time (daily or weekly...) and imports data from one or more Excel (CSV) sheets into Tally. For more information, refer "Using Windows Scheduler to run udiMagic at specified timings"