Add Element Values by Import

If your account structure changes, you can add element values by exporting them from an old accounting cycle and then importing them into a new accounting cycle. This process is faster than entering them manually.

Before you begin

The export will obtain all Enabled element values. The only Disabled element values that it obtains are element values that are parents – they will then be enabled. This action will keep the element value hierarchy.

You can import element values from other sources as long as the format conforms to AptaFund specifications. Contact AptaFund Support for more information

Import Process

  1. Export element values from old accounting cycle.

  2. Import element values into new accounting cycle.

Import element values into new cycle

  1. Select Data Import from the Administration menu, and the Manage Data Imports window opens.

  2. Select Chart of Accounts Administration from the Batch Import Process pull-down list, and those processes are displayed.

  3. Check the box for Element Value Maintenance, and click the Edit button, or click the Element Value Maintenance link. The Select file for data source popup opens.

  4. Click Select files.., navigate to the location of the import file, select it, and click Open.

  5. When the file is done uploading, click Save. You're returned to the Manage Data Imports window and notified that the file attached successfully.

  6. If the process has been run previously, check the box labeled Element Value Maintenance, and click Reset. The status is changed to Not Run.

  7. Leave the box checked, and click the Include button.

  8. Leave the box checked, and click Execute Batch. Note: If this is the only process you want to run, make sure all other boxes are unchecked. You're notified that the process is executing. When the process has completed successfully, you're returned to the Manage Data Imports window, and the status is changed to Succeeded. Note: If you get a message that the processes failed, click the Display Successes/Exceptions button.

  9.  

  10. Validate the data was imported successfully by running the Batch Execution Report found in the Data Import module on the Reports menu.

  11. Review & verify the imported data by running the Task Detail Report found in the Data Import module on the Reports menu.

  12. Manually enter any missing or newly defined element values in the Element Value Maintenance window.

 

 

 

 

 

 

 

Return to Element Value Maintenance Overview