In this article
Overview
You can import and export asset data for a member or members of a household.
Access the Data Loader and Export tool from the Household Summary tab.
Using Data Loader Import
File Type, Format Facts & Information
The Data Loader will only accept a CSV file format with the following columns included: id, name, source, value.
Optionally download and complete our blank CSV template before uploading again.
Optionally download and change the existing financial data before uploading again.
If the CSV file uploaded by the user contains any other columns than these four, the Data Loader will ignore them.
NOTE - the specific ordering of the columns within the import file does not matter
“id” can be set to any (alphanumeric) value the user wishes to use.
Net New Instruments uploaded via the loader will always import as "Non-retirement Assets" IF no ‘type’ or ‘category’ columns/values (which are optional fields) are specified within the file
The Data Loader uses the id column to update the other fields with the information provided in the CSV file columns. If it recognizes a matching id, it will update the information for that instrument as indicated by the user.
Use Case Example #1: User uploads CSV file #1. This file contains 10 instruments. After uploading, the user wishes to change the “name” field for all 10 instruments. Using the Data Loader, they can update the name cell in the “name” column of the CSV file for all 10 instruments and re-upload the same file. All 10 instrument names will update.
Use Case Example #2: User uploads CSV file #2. This file contains 10 instruments. After uploading, the user wishes to change or update only the “value” field for all 10 instruments. Using the Data Loader, they can update the value cell in the “value” column of the CSV file for all 10 instruments. Then by selecting the “Only Update Values on Sync” checkbox, only the values that changed will be updated regardless of other changes made to the CSV file.
Note: only the changed values for the line items will be changed. Other information like NOTES or DETAILS of the financial remains unchanged.
Using Data Loader Export
The Data Loader has a function to Export Household Financials that also allows for the ability to edit instruments that currently exists in Asset-Map households.
Data Loader Export: File Type, Format Facts & Information
The Export Household Financials link on the Data Loader page allows for mass instrument editing via CSV by a user.
When an export file is produced it includes: hash, type, category, name, source, and value columns.
If any changes are made to any of these columns with the exception of “hash” the associated instruments in Asset-Map will reflect the changes made by the user when the file is saved and uploaded.
If a “hash” is altered in any way from the export file, a new instrument will be created in the household. Asset-Map uses the “hash” column to identify preexisting instruments, so when a “hash” does not exist in the database, a new one is automatically created.
So long as type and category columns are not edited in the file that is exported from Asset-Map, instruments will maintain their types and categories when the file is re-uploaded to Asset-Map.
2/2024