Guidance for creating a .csv export template. 

Instructions for Template Creation

1. Launch MagIC Net software. 
2. Click Database tab. 
3. Click Tools → Templates → Export templates...
4. Click New.
5. Create a template with the following properties:
   1. Name: CSV (or similar). 
   2. Target directory: location on hard drive or network drive (click the button to the right of field to search for a folder—click "New Directory" to create a new folder). 
   3. File type: *.csv (comma separated). 

   4. File name: 

      1. Determination ID—automatic unique ID assigned by MagIC Net. 
      2. Sample identification—file name based on user-entered ID. 
      3. Request on each export. 
      4. Fixed file name (append data)—file name of your choice (exported data appended to same file). 

      

6. Click Options. 
   1. Filed separator: select the comma. 
   2. Record separator: select CR/LF.

   3. Header: check this if you want the 'displayed name' as defined in the 'Select fields' menu (see step 7 below) at the top of each column in the export file. 

      

7. Click Select Fields.
   1. Highlight fields from the left panel and click the >> button in the middle of the window to move to right panel—to be included in the export file. 
   2. Highlight fields from the right panel and click the >> button in the middle of the window to move to the left panel—to be removed from the export file. 

   3. You can reorder the fields by highlighting the field name and using the up/down arrows on the far-right side of the window. 

      

8. Click OK to store the new template. 
9. Click Close to exit the template window. 

How to Manually Export

1. Click Database tab. 
2. If current database is not already open, click File → Open and select the appropriate database. 
3. Select all determinations you wish to export in the Determination Overview window. 

4. Click Determinations → Export. 

   

5. Select your newly created Export template. 
6. The files will be exported to the target directory as programmed in the template. 

Set Up Automatic Export in Method

To automatically export determination(s) after determination is completed, add Automatic Export settings into your MagIC Net Method. 

1. Click Method tab. 
2. Click File → Open and select method in which you would like to add automatic export. 

3. In Evaluation panel, click Results → Database tab. 

   

4. Double click in Export Settings box to open. 

5. Use the drop-down menu to select your newly created export template. 

   

6. Click OK. 
7. Click File → Save to save the updated Method. 

Additional Support

If you encounter any issues or need additional help, please submit a support ticket through Metrohm Technical Support. 

For additional training on any of these topics, explore our available Metrohm Ion Chromatography Training courses or learn more about our Metrohm Custom Training options.