Topic 70: Data Loading

[welcomewiki]

Update 9015 records from file.
7. Click Back (F3) ****on.

Information: The following section details updating the Charge Object Assignment template, steps to open text files and saving the file as a text file (.txt) for upload into BEACON.
Information: An Excel (.xls) template is available on the BEACON help site that can be used when creating the Charge Object Assignment load file. The .xls template must be in the proper format and then saved as a .txt for the upload in transaction ZPTA030 to be successful.

8. Open the upload file in Excel.

[welcomewiki]

Microsoft Excel - Book1


9. Click File >> Open...

Open


10. Select Charge_Pbject_Assignment_Load.xls in the list box.
11. Click Open ****on.

[welcomewiki]

Text Import Wizard - Step 1 of 3


12. Click Next > ****on.

Text Import Wizard - Step 2 of 3


13. Click Next > ****on.

Text Import Wizard - Step 3 of 3


14. Press right Arrow ****on to scroll to the last column.

[welcomewiki]

Text Import Wizard - Step 3 of 3


15. Press and hold Shift and click the last column.

Text Import Wizard - Step 3 of 3


16. Click Text radio ****on.
17. Click Finish ****on.

Information: Upon completion of changes the file needs to be saved as text.

Microsoft Excel - Charge_Pbject_Assignment_Load.xls

[welcomewiki]

18. Click File >> Save As...

Save As


19. Click the Save as type: dropdown.

Screen Title


20. Select Text (Tab delimited) (*.txt) in the Save as type: list box.

Save As


21. Update the following required and optional fields:

Field Name	Description	R/O/C	Values
File name:	Enter a File name.	R	Enter value in File name:. Example: Charge_Pbject_Assignment_Load.txt

22. Click Save ****on.

Microsoft Excel


23. Click Yes ****on.
24. The system task is complete.