Review Dates/Frequency - assigning in bulk?
Hi there! I hope this is ok to post here!
We are looking at automating our review process further and wanted to know if there is a way to bulk add review dates & frequency to selected clients in the Manage Reviews screen?
Thank you 🙂
2 Replies
- courtney.youngblutt
Xplan Expert
Hi fiona.matthews.0 , thanks for posting! You can use a csv file import file to bulk add review dates & frequency to selected clients.
⚠️Before importing client data, it is recommended that you first export the relevant data being updated and save this file as a back-up. Read: Export Client Data
👨🎓 Always test your import file on a few test clients before running it across your entire client list!
I've attached a csv template here that you can use and I also recommend reading the following article: Import Client Data, particularly the sections on valid date formats , import field group data and warnings about importing data.
For example, a csv for the review group would contain the following columns:
entity_id review_manual_completion review_review_comment review_date_completed review_time_completed review_date review_desc review_frequency review_adviser review_end_time review_time review_status review_type You must include the entity id in the file and make sure you understand the difference between append and overwrite as per the above article.
Finally, the ability to import data is capability based so if you don't see the menu options under your log in, you may need to get in touch with your site administrator. Often your site administrator will even perform this task for you if you provide them with the import file!
I hope that helps!
- fiona.matthews.0Network Navigator
Thank you!! Very helpful and I appreciate your time!
Welcome to the Advisely forums!
This is where financial advice professionals from all walks of life come together to share knowledge, swap ideas, solve problems, and talk all things growth and efficiency.
Here are some tips when posting in the forums:
- Be respectful and courteous to fellow members
- If a reply helped you, mark it as a solution so other users can find it easily
- Take a moment to read through our Community Guidelines
- For Xplan support issues, it's best to raise a ticket in Iress Connect first. You can also search the discussions for posts about the same issue first before starting a new thread.
- Keep an eye out for our 'Ask me anything (AMA)' threads – these are live text-based Q&As with industry and Xplan experts during a set period of time. Find out when the next one is happening here.
- Don’t be shy! You don’t need to be an expert to help someone out. Many users are looking for practical advice, shared experiences, or just a fresh perspective
- Introduce yourself and meet other members here!
We’re glad you’re here – see you around! 😁
Recent Discussions
Adding attachment icon to Client Portal Messages
Hi Team Please can you consider adding an "attachment" icon like a paperclip to file notes sent to clients via the client portal that have an attachment to them? At the moment, and particularly i...sharyn.evans817 hours agoActive Interactor1View0likes0CommentsLifestyle Assets in Client Portal Fact Find
Hi Team, We've just moved from a 3rd party platform that we used for capturing online fact finds, over to the integrated client portal fact find in Xplan. What we're saddened to see is that current...sharyn.evans818 hours agoActive Interactor24Views1like3CommentsWhy Financial Advice Accountability Legislation Needs to Change Now
After my article in the IFA on CSLR and the accountability gap we currently see in Australian financial advice, I have had a number of people ask what specific legislation needs to change to tighten ...tonybeaven2 days agoNetwork Navigator8Views0likes0CommentsThings to consider when creating individual vs company Professional Advisers in Xplan
Hi everyone 👋 I’m looking for best practices and things to consider when creating Professional Advisers in Xplan. The purpose is purely to link them to clients as authorised third parties, and to ...michelle.butler.05 days agoActive Interactor37Views2likes5Comments