For existing customers upgrading to Box for Oracle NetSuite v3+ from v2 or below, after installing v3, you will need to migrate your Box Custom Records. An alternative method from manually exporting or importing the custom records as CSVs is the Box Migration Tool.
This article goes over the steps to manually export and import the custom records as CSVs.
1. Export Custom Records
To export records:
- In NetSuite, on the global dashboard, navigate to Customization > List, Records, & Fields > Record Types
- View custom record list. First, navigate to the first custom record list: Box Account Association
- Click Customize View to show all columns.
- For Box Account Association, add the following columns and then click Save.
- Box User id
- External ID
- Inactive
- Internal ID
- NetSuite User id
- You will be navigated back to the list view which should now show all the columns you added in the previous step. Now click the icon button for Export - CSV
- Follow instructions 2-5 for the remaining 5 custom records:
-
Box Folder Collaborations
- Account Association id
- Box Collaboration id
- Box Collaboration Type
- Folder Association id
- External ID
- Inactive
- Internal ID
-
Box Folder Collaborations
-
Integration Config
- Name
- Box Root Folder id
- Box Subdomain
- Box Verified Enterprise
- Enterprise id
- External ID
- Inactive
- Internal ID
- Move V1 Content to V2
- Upgraded from V1
-
Box Record Folder
- Box Record Folder id
- External ID
- Inactive
- Internal ID
- Netsuite Record id
- Netsuite Record Type
-
Box Record Type Config
- Name
- Create
- Edit
- Enabled
- External ID
- Full
- Inactive
- Internal ID
- Permission id
- Prefix
- Record Field
- Record Type
- Record Type Folder Name
- View
-
Type Folder
- Box Folder id
- External ID
- Inactive
- Internal ID
- NetSuite Object Type
Once complete, proceed to Import Custom Records.
2. Import Custom Records
Note: Due to NetSuite limitations, you can only import up to 25k rows at a time. If any of the records you have exported above exceed this limit, you will need to split your CSV export file into 25k row files, either manually or through a third party tool. This most commonly occurs for Box Record Folder - for this record type, this results in not being able to view your mapped Box folders for a given NetSuite record.
- Navigate to Setup > Import / Export > Import CSV Records.
- Set the following fields and click Next.
- For Import Type, select Custom Records.
- For Record Type, select <Record Type Name> (example: Box Account Association)
- For CSV File(s), upload saved CSV file(s) for the corresponding record type.
- NetSuite’s Import Assistant only supports up to 25,000 records. If the CSV file contains more than that, you must split them up to multiple CSV files
- Select import data handling method:
- Click ADD, then Next for the following record types:
- Account Association
- Folder Collaborations
- Record Folder
- Type Folder
- (As needed) Any other custom record
- Click ADD, then Next for the following record types:
-
- Click UPDATE, then NEXT for:
- Record Type Config
- Integration Config
- Click UPDATE, then NEXT for:
- Verify that all fields are correctly mapped, and click Next.
- Run the import job. Filling out the fields and saving it is optional. You just need to run it. Navigate to the Save & Run button submenu and click Run.
- Confirm, and click OK.
- You should be navigated to the confirmation page. You can click on Import Job Status to view the progress.
Below is a sample view of the Job Status:
Note: If you created any Custom Records, you will need to download the CSV Response, which will show which records did not exist. Then, Import the record by selecting ADD.
- Repeat steps 2-7 for the remaining custom records.