Answer
Documentation

http://documentation.abila.com/netforum-enterprise/2017.1/Content/GettingStarted/Import_from_Excel.htm​


netFORUM Site

http://train06.netforument.com/nftrain2017bd/iweb/ (authenticates to avhost account)

Username: student99_train where 99 is your own personal number

Password: ******

Exercises

  • Find Individuals where last name = first letter of your own last name
  • Export some individuals into Excel
  • In Excel, remove all columns except primary key, first and last name
  • Delete all rows except 3 random ones -- 
  • Add a top row
  • Enter  column headers
    • ind_cst_key
    • ind_first_name
    • ind_last_name

 

  • Add new column:
    • ind_dob
  • Change some first and last names
  • Enter the DOB for some individuals (MM/DD/YYYY)
  • In Excel, highlight the cells
  • Copy
  • In netFORUM, click the "Import From Excel" link
  • Paste
  • Save
     
More Exercises

Add more row, and do not enter a ind_cst_key. This will create new individuals

Try with other tables

Event or Session registrants - attendance flag

 
Article Type
Product Info
Product Line
netFORUM Enterprise
Product Module/Feature
-None-
Ranking
No votes yet