Import

Import Maps

Accounts can be imported into ConColl from a spreadsheet in a particular format

Advance Import

This is for importing information (the name of the sheet must be "new accounts") The system will auto generate the account number based on the number placed in the client last account number. The program will also check if each column is in the right place. If there is no information for column that column must remain in its place.

1. suffix
2. Name
3. contact
4. Street number
5. Address
6. addr1
7. City
8. Parish (State)
9. Zip
10. Country
11. TRN
12. Date of birth
13. Home phone number
14. Cell number
15. Other number
16. email
17. POE (Place of employment)
18. POE number
19. Occupation
20. Monthly income
21. Marital status
22. Original account number
23. Misc_1
24. Client status
25. Branch
26. Transit_no
27. Date assigned"
28. Principal
29. Client expense
30. Interest rate
31. Interest date
32. Interest os
33. Currency
34. Debt type
35. Notes_1

The cells 36 to 46 is added to notes, they will be combined

Basic Import

Basic import (The name of the sheet must be "data")

1. Name
2. Contact
3. Street number
4. Address
5. Address2
6. City
7. Parish
8. Country
9. TRN
10. Telephone
11. Principal
12. Currency
13. Interest rate
14. Interest date
15. Original account number
16. Client status
17. Misc_1
18. Transit number
19. Branch
20. Debt type
21. Date assigned
22. Note_1

Import Relations

1. acct
2. f_name
3. l_name
4. fullname
5. street_number
6. address
7. city
8. parish
9. country
10. home number
11. mobile
12. poe
13. poe number
14. Occupation
15. trn
16. relation
17. obligation

Research

When this box is checked the system will check if the same name,phone number and similar last name is already in the system and compile a list if found.

Delete Import

If something goes wrong with an import it can be deleted by clicking the delete import button then enter the import id. You can then correct the format or data and import again.