All your data currently in spreadsheets? No sweat... tiny+ lets you import all your contacts, projects and company records directly from your .xlsx or .csv file.
For Projects: from the home screen, navigate to Projects -> All Projects. Import Projects will be an option on the right hand menu.
For Companies: from the home screen, navigate to Companies -> All Companies. Import companies will be an option on the right hand menu.
For Contacts: from the home screen, navigate to Contacts. Import contacts will be an option on the right hand menu.
Do you have categories or tags in your spreadsheet that you would like to import into tiny+?
For example, you might have a column in your spreadsheet which identifies if a contact is a Client/Supplier/Consultant.
If so, before you begin your import it's worth setting up these categories in tiny+ first.
Once the categories are set up, make sure the tags are set up in your spreadsheet correctly. One column per category, and multiple tags separated by a semi-colon (;).
Then, simply match the category in tiny+ to the correct column during your import.
You can provide a semi-colon-separated list of team members in a column to import multiple related team members to a project, company or contact.
Planning to do several imports? Or maybe your spreadsheet has some double-ups with records already in tiny+? Don't stress, tiny+ can reduce duplicates wherever possible by doing smart field matching. For example, for Contacts we will check for matches on:
email address + full name
company name + full name
mobile phone number
We have similar sensible duplicate checks for Projects and Companies.
If we detect a duplicate, we will attempt to fill in any fields from your import that are not currently in the existing record, and attach the 'Assigned To' user you specify to the record's Team list.
You can disable this feature by unchecking 'Reduce duplicates?' before you start your import.
Easy. We recommend that you do TWO imports using the same spreadsheet file.
First import the companies, and ignore any contact-specific fields when field-matching during the import.
Then import the contacts, and ignore all company-specific fields, except for matching the Company Name field in your spreadsheet to the Related Company tiny+ field.