Product: MailOmatic for Schools
Description: An error occurs when trying to import payments from Diamond Mind. An error occurred during import: String was not recognized as a valid DateTime
Version: MOMS clients with the Diamond Mind integration
Environment: All
Answer:
This error occurs when the downloaded .csv file is opened in excel and saved.
If no changes need to happen to the file, download the batch file from Diamond Mind as a .csv document and do not open it before importing the file into the deposit.
If changes do need to happen to the file, download the batch file from Diamond Mind as a .xls document. Open the file and make the necessary changes. Choose to save as a .csv document and import the file into the deposit.
Description: An error occurs when trying to import payments from Diamond Mind. An error occurred during import: String was not recognized as a valid DateTime
Version: MOMS clients with the Diamond Mind integration
Environment: All
Answer:
This error occurs when the downloaded .csv file is opened in excel and saved.
If no changes need to happen to the file, download the batch file from Diamond Mind as a .csv document and do not open it before importing the file into the deposit.
If changes do need to happen to the file, download the batch file from Diamond Mind as a .xls document. Open the file and make the necessary changes. Choose to save as a .csv document and import the file into the deposit.