Extra Help - Putting It All Together Exercise 2

lindascott
edited March 2023 in Academy Discussions

Use the screenshots below as a guide for completing Putting It All Together Exercise 2.

On the Model Settings tab, select General Lists. Then select Insert from the General Lists menu.On the Model Settings tab, select General Lists. Then select Insert from the General Lists menu.

 

 

 

 

 

 

 

 

 

 

 

 

Type the name of the new list into the dialog. In this case, type Stores.Type the name of the new list into the dialog. In this case, type Stores.Back on the General Lists menu, add a top level for your new list. In this case, type All Stores. Then click the name of the new list, Stores, and then click Open.Back on the General Lists menu, add a top level for your new list. In this case, type All Stores. Then click the name of the new list, Stores, and then click Open.With the Stores list open, click the Properties tab, then click Insert.With the Stores list open, click the Properties tab, then click Insert.Type the name of the Property to add. In this case, type Address.Type the name of the Property to add. In this case, type Address.Select the Format of the property you just added. In this case, select Text.Select the Format of the property you just added. In this case, select Text.With the Stores list open, go to the Grid View tab and click Import. Navigate to and select Stores.csv as the import source file.With the Stores list open, go to the Grid View tab and click Import. Navigate to and select Stores.csv as the import source file.Preview the import in the File options dialog. Ensure that the data is properly parsed (check the type of delimiter if it is not) and that the header row and first data row are correctly identified.Preview the import in the File options dialog. Ensure that the data is properly parsed (check the type of delimiter if it is not) and that the header row and first data row are correctly identified.Map the Store and Address fields to the proper columns on the source .csv file.Map the Store and Address fields to the proper columns on the source .csv file.If the import completes properly, you will see this screen. If it does not match, the most likely problem is that you have not mapped the source file data to the model fields. Click Close, and then start over with your import. You will need to remove the source file from the  initial import screen and then reload it.If the import completes properly, you will see this screen. If it does not match, the most likely problem is that you have not mapped the source file data to the model fields. Click Close, and then start over with your import. You will need to remove the source file from the initial import screen and then reload it.The completed import should look like this in Grid View. If the addresses did not import correctly, you have most likely forgotten to set the format of the Address property to Text. Make that change and then run the import again.The completed import should look like this in Grid View. If the addresses did not import correctly, you have most likely forgotten to set the format of the Address property to Text. Make that change and then run the import again.The completed import should look like this in Tree View.The completed import should look like this in Tree View.You can zoom in on a screenshot by clicking the magnifying glass in the upper right corner of the image