Error: Parameter has no default value

FAQs: Import data from Foxpro DBF into Tally

I am using the UDIMagic software to import data from my Foxpro DBF into Tally. While running UDIMagic, I am getting the following error :-
"Parameter has no default value"

Cause of Error:-
The above error generally errors when incorrect field-name is specified in the SQL-SELECT statement.

Solution:-
1) Check (and rectify) the field-name(s) specified in the SQL-SELECT statement.
2) Also ensure that you have specified the correct folder-name which contains the DBF's from which data is to be imported into Tally. The steps to specify the folder-name are as follows :-

STEP 2a

STEP 2b

---

Import data into Tally from multiple Excel Sheets

Batch Processing
UDIMagic v3.0 Release 1.67 supports "Batch Processing". In simple words, it allows you to "Import of data from multiple Excel sheets" in one-go.

Before going into the details of this feature, let's have a look at the Auto-Run feature of UDI-Magic which was introduced some-time back (UDIMagic v3.0 Release 1.60).

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 detailed description, please refer Import data into Tally from multiple Excel Sheets

---

Import Branch Office Tally data into Head Office Tally

In UDIMagic v3.0 Release 1.64, the Branch to Head Office feature supports data transformation also. Here are some examples of data transformation :-

Example 1 : Transform Sales vouchers as "Branch Sales"
Assuming that at your Branch Office, "Sales" vouchers are entered. Your requirement is that when the Branch-data is imported into the Head Office Tally, it must be imported as "Branch Sales" vouchers.

Example 2: Import specific Voucher-types only
At you Branch-Office, various type of entries like "Sales", "Receipt", "Payment" etc are done in Tally. You need to import the Branch-Office data in your Head-Office Tally, but only the "Sales" entries are to be imported, that too as "Branch Sales".

Remarks:-
1) We have listed some examples of data transformation.
2) UDIMagic [Professional] provides two features viz Tally-to-Tally and Branch-to-HO which support Data-transformation.
3) Almost all-types of Data-transformation can be done.

---

No Company is Open in Tally

FAQ's - Excel to Tally

I am using UDI-Magic to import data into Tally. Even though I have started Tally and opened one Company, UDI-Magic still shows error message "No company is opened in Tally". How do I solve this problem ?

Temporary Solution

Those who are using UDI-Magic Demo for evaluation purpose, are requested to follow these steps :-

1) Close the Tally Software.
2) Next, press Ctrl+Alt+Del.
3) Next select "Task Manager"
4) Next, search for Tally9.exe (or Tally72.exe under processes-tab) and click on the End-Process button to close it.
5) Next, search for TallyLicServer.exe (under processes-tab) and click on the End-Process button to close it.
6) Next, start Tally Software and open your Company.
7) Run UDI-Magic and try importing data in Tally Software.

Remarks:-
Re-start the Computer afterwards so that workstations can access the Tally-license Server which we had terminated manually.

---

Excel to Tally || Mapping of fields

FAQs

"How is the mapping of Excel sheet cells done with the Tally fields ?"

UDIMagic uses XML tags for mapping Excel Sheet cells with the Tally fields. The XML tags can be written using any text-editor like NOTEPAD.

There are two ways of writing XML tags viz
1) In the Comments of Cell A1 (or any other cell in 1st row) in the Excel sheet itself
2) In a separate file with extension XML.

For those who are totally new to XML, initially it may be difficult to digest all these things. But then, it is not very difficult.

We have provided several tutorials at Learn-Tally-XML-Tags blog-site

There is one more tutorial which covers the basics of "Writing XML tags" with step-by-step Instructions.

You can get several other good reference / links from our web-site at www.rtslink.com/udimagic-standard.html

PS: End-users need not worry about learning XML tags to use UDIMagic. Shweta Softwares provides the XML tags. Refer www.rtslink.com/orderinfo.html for more information.


Tips:
You can open XML files in IE (Internet Explorer) or any other browser. However, to edit it you must use a Text-editor or XML-editor.

---

Tally to Tally || Convert Sales vouchers to Purchase

This Post provides Tally-to-Tally Rules for converting Sales vouchers to Purchase.

Download
1) Sales-to-Purchase Rules (zip file)
2) Instructions for using Tally-to-Tally feature (PDF file)

What is Tally to Tally ?

UDIMagic v3.0 [Professional] comes with a feature called Tally-to-Tally that allows you to transform Tally data. As the name suggests, the Tally-to-Tally feature allows you to retrieve data from one Tally Company; apply transformation rules; and then send it to another Tally Company.

For more information, refer Tally-to-Tally

---

FAQs

I am having X records (say 10,000 records) in my Excel Sheet. I am using the licensed version of UDI Magic. However, UDI Magic processes only few records (say 100 records). What could be the reason ?

It is likely that your Excel Sheet has a BLANK-ROW or HIDDEN-ROW at or near the ROW-number 100 in the Excel Sheet. Remove that and try again. It should work.

PS:
1) UDI Magic stops processing if it finds a BLANK-ROW or a HIDDEN-ROW.
2) If you are using DEMO version of UDI Magic, then only 5 or 10 records (Vouchers and Masters resp.) shall be processed.

---