Thursday, November 28, 2013

Voice Your Opinion

Vasool Diary - Voice Your Opinion

Vasool Diary - CSV Input Templates

Vasool Diary - (Android based finance collection software) has an option to enter the bulk data in CSV format. This feature is handy for the people already using desktop computer based applications (generally exports the data in table format [MS Excel or Access]), MS Excel or Open Office Spread Sheets or any web based tools.  Vasool Diary has two bulk entry mechanisms
  • Customers : Define all the customer data in this CSV format
CustomerName
Location
Mobile
Phone
Address1
Address2
Reference
Notes
  • Loans (Existing Loans) : Define the existing loans data in this CSV format.
    • This CSV format has fields to enter customer data as well. 
    • Application will create a new customers and then links the loans with the customers
    • Multiple loans can be linked to one cusotomer. Please use the same CustomerID for all the loans of a single customer

CustomerID
CustomerName
Location
Mobile
Phone
Address1
Address2
Reference
Notes

LoanIssueDate
LoanAmount
TotalInstallments
OutstandingAmount
InstallmentAmount

RemainingInstallments
InstallmentStartDate
LoanNotes


What is CSV file?
A comma-separated values (CSV) file stores tabular data (numbers and text) in plain-text form. A CSV file consists of any number of records, separated by line breaks of some kind; each record consists of fields, separated by some other character or string, most commonly a literal comma or tab. Usually, all records have an identical sequence of fields.

CSV Template Files :
  1. VDCustomers_Template.csv
  2. VDLoans_Template.csv

Sample CSV Files : (Request an access to download sample files)
  1. VDCustomers_Sample.csv
  2. VDLoans_Sample.csv
  3. VDCustomers_Sample2.csv
  4. VDLoans_Sample2.csv

Help and Support:
For any queries Call : +91-7204850773