Pre-condition - Do not use ' and " sign in excel
In Import DSC - There are many fields in excel but only 9 basic fields are mandatory. Lets discuss all the options brief:
1. Sr No -
- Accept only numeric values
- Do not enter any blank spaces before and after values
2. PAN no -
- This field is mandatory
- Accept only alphanumeric values
- Enter only up to 10 alphanumeric values like (eg-ASASA1231A)
- Do not enter any blank spaces before and after values
3. Name -
- This field is mandatory
- Enter only characters values
- Do not enter any blank spaces before and after values
4. Related Company -
- This field is mandatory
- Enter only characters values
- Do not enter any blank spaces before and after values
5. Issue date -
- This field is mandatory
- Enter YYYY-MM-DD format only
- Do not enter any blank spaces before and after values
6. Valid Till Date -
- This field is mandatory
- Enter YYYY-MM-DD format only
- Do not enter any blank spaces before and after values
7. Issuing Authority -
- enter only alphanumeric value
- Do not enter any blank spaces before and after values
8. Password -
- This field is mandatory
- enter only values like alphanumeric values, special characters like @,#,/etc
- Enter up to only 50 limit
9. Position -
- This field is mandatory
- enter only values - Individual, Director, Partner
- Do not enter any blank spaces before and after values
10. Class Type -
- This field is mandatory
- enter only values - Class-Type-1, Class-Type-2, Class-Type-3
- Do not enter any blank spaces before and after value
11. Mobile No -
- Enter valid only 10 digit (which is already not registered in ERPCA)
- Do not enter any blank spaces before and after values
12. Email id -
- Enter valid and unique email id (which is already not registered in ERPCA) to recover the login details of the user.
- Do not enter any blank spaces before and after values
13. Custodian Name -
- This field is mandatory
- Accept Characters values only
- Do not enter any blank spaces before and after values