NetClose - Upload Task List
Overview
Netgain has developed basic upload templates that can be used to upload task details in batch.
Step-by-Step Process
- Fill out the applicable information in the NetClose Task Upload Template
- Add or upload Non-Working Days
- Complete creation/update of Task Classifications
- Prepare the "Task Upload Template" tab as a CSV file for upload
- Delete any informational or example rows
- When finished updating the Excel File, save it in a known location as a .csv file
- Delete any informational or example rows
- Navigate to the Import Assistant by accessing Setup > Import/Export > Import CSV Records
- With the Import Assistant open, update the Import Type to Custom Records and the Record Type drop-down to NetClose Task
- Under the CSV files section, click on the Select button and upload the .csv file you saved
- Select Next to progress to the Step 2 Import Options
- Within the Import Options section, make sure Add is selected (or Update if doing a bulk update to Amortization Types) and "Run Server SuiteScript and Trigger Workflows" is checked
Importing preparers or reviewers
Any preparer or reviewer field left blank will default to the user running the import. To prevent this, on the Import Options tab above, check Overwrite Missing Fields. This treats blanks as null and leaves those fields untouched instead of stamping your own name on them.
10. Select Next to progress
11. After progressing through File Mapping, you will be prompted for Field Mapping
12. Note that NetSuite tries to directly map all the fields it can recognize. When fields are not recognized, they must be manually matched between the .csv upload file and NetSuite fields
- The recommendation is to match based on Internal ID for applicable fields
13. If the fields are mapped correctly and the field contents match the field values in NetSuite, select Save & Run or Run as desired
14. To view the status of the upload, select "Import Job Status" in the Confirmation banner or navigate to Setup > Import/Export > View CSV Import Status
15. When complete, the status will change to complete and show the records imported successfully
16. In the event of a failed upload, review the logs for the specific reasons, make necessary updates to the CSV file, and repeat the above steps
Adding tasks in the UI
For information on adding single tasks in the NetClose UI, reference the NetClose Tasks article.
Reviewing your task list
To review your uploaded task list, go to NetClose > Lists > Tasks. Please note that tasks will not appear on the Task Board or Task List until tasks have been generated for a period.
