Import Loan Data

you can use salesforce import data wizard to import equipment loan data 1\ prepare the import file on salesforce, go to reports and click the new report button select equipment as the report type and click create drag the equipment id field into the report alongside any other fields you may wish to use to assist in identifying the record in the report click run report from the report page, click export change the export file format to csv and click export open the file in a spreadsheet editor and save it you will now take the data in that worksheet and add additional columns to provide the assignment data loan type = user, contact, account, or opportunity loan start date = yyyy mm dd estimated return date = yyyy mm dd loaned id = the sfdc id of the record this is used to associate the record with the equipment loan you may need to export all your associated records and use vlookup to find the salesforce id for contact and account, you can use the name field and do not need to obtain the sfdc id for those types of records loading loan data must be done based on the loan type field if you have loans to users , contacts , accounts, and opportunities , you may have as many as 4 files to load save each file filtered on loan type ( user , contact , account, and opportunity ) as a separate csv 2\ import the file on salesforce, go to setup > data > data import wizard scroll down and click the launch wizard! button the data import wizard will open select the following values for each pane what kind of data are you importing? custom objects equipment loans what do you want to do? add new records additional questions will be revealed based on the loan type you are loading, answer the appropriate question where is your data located? drag the csv file you saved earlier onto the drop spot click next on this field map , you will need to make some changes click map next to equipment id , select equipment click map next to loaned id , select contact (or user , account, or opportunity based on which loan type you are currently loading) click next again the field map summary will be presented click previous to edit or click start import to proceed you will be directed to the bulk data load jobs page here you can monitor your job and review results as necessary repeat the steps above for each loan type you are loading ( user , contact , account, or opportunity ) loading multiple loans for a single equipment record if you need to load historical loan data (more than the current loan) we recommend you contact us for assistance