Hello,

 

Below instructions for CR 033:

 

1. Open advanced export and download companies data:

 

2. On grid tabs (Programs By Country in this example), you will find grid data and row id which will be used for updating grid rows:

 

 

Let’s update program id for organizations 8674, 8675 from list above:

 

 

3. Use info from step 2 to create batch update excel:

 

 

Parameter 1 and 2 is taken from setup of custom fields

 

<Grid title="Programs by Country" id="countryGrid" orderby="country" descending="true">

…

<Column title="Program" id="program" type="dropdown">

<Option title="EDI" value="EDI"/>

<Option title="Email (PDF)" value="Email (PDF)"/>

<Option title="OB-10" value="OB-10"/>

<Option title="XML" value="XML"/>

</Column>

 

 

Parameter3 is option value, Parameter 4 is option title (same in this case)

Parameter5 is rowid from step 2.

 

4. Go to Super Admin -> Batch Updates, and upload this file, review results:

 

5. Open organizations 8674, 8675:

 

 



 

6. Lets use another option to delete grid row (in case instead of setting field you want to remove row). Using organization 8676:

 

 

7. Creating file for update:

 

 

Here we need to specify only grid id (Paraneter1) and rowid from step2, because we need to delete whole row.

 

 

8. Review organization – row deleted:

 

 

9. Let’s add new row to organization from step 8. This will require more work as we need to set all fields:

 

10. Again running batch update:

 

 

11. Results:

 

 

 

Sample file used in this instruction attached.