GET SMARTER: (650) 579-0210
Follow

Data operations with Excel SmartClient for NetSuite: Office Add-in

Add Template

The first step is to create templates. Templates are records with a set of fields. Data is downloaded into templates, processed and saved for reuse. For example, an employee record with a set of fields such as name, date of joining, department, location etc. is what makes up a template. You can edit the template to add or remove fields. You can reuse templates to download the same data the next time, without having to recreate the same data set. Data in the templates can be kept in sync with the data in NetSuite.

Templates can also be accessed from the Settings section.

Search Record types

While adding a new template,use the search option for quick record type selection. Select the Record and click Select Fields.

Next step is to select the Fields associated with the record. Once the field is selected, green tick mark appears. To remove the fields, click the red cross mark.

Enter a name for the template and Save.

Save and load. The template is loaded into the sheet  where the mouse cursor is placed.

Note: You cannot load a new template on the top of an existing template. The template will not load in the Excel sheet .

From your list of templates page, the template can also be  loaded using the ‘Play’ button. Pencil icon is to edit the template (to modify the field selections)

Once the template is loaded into the sheet, the blue outlines indicate the binding area separating the template from the rest of the worksheet. Apart from the selected fields, two additional fields/columns are created: one to track internal IDs and the other to track errors that may occur during the data operations.

Download Records

Data operations include: Download, Update, Delete, Refresh, Add rows.

To download records, click Download.

By default, records are downloaded in batches of hundreds.

Filter Records

You can also apply filters to download specific data. You can add multiple rules. Select Apply Filter checkbox and download.



Update Records

After modifying the data, you upload data back to NetSuite source using the Update option.

Selected rows are updated. To update all rows in a single go, select the ‘All Rows’ checkbox before updating.

Error resolutions

Errors are color coded.

Refresh option

Refresh option removes the deleted records and clears the error colors. Refresh also keeps your Excel data in sync with NetSuite.

Working with saved searches

Saved search


Type into search bar


Select the record and click ‘Get Saved Searches’. List of saved searches from your NetSuite account are displayed.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk