• View
• Edit
• History
• Attach
• Print

How To Copy Web Stores Product Information Into Assist And Get It Into Web Store

This procedure takes approximately 30 minutes.

Follow the steps below carefully and you will successfully update WebStore with data that has been entered in the Product Manager and in Assist.

You may need to be set up with certain privileges before you can perform all of the steps in this procedure.

This is what is about to happen:

1. You will convert the Product Manager data that is on the web into a format that can be imported into Assist.
2. You will download those text files from the web server that is in downtown Denver to the M: drive on our local Sonlight network.
3. You will import those text files from the M: drive into Assist on our IBM AS/400. The data goes into the Assist/WebStore interface area.
4. You will run a process in Assist that will convert the data into files that can be imported into WebStore.
5. You will run a process in Assist that will import the files from our AS/400 to the WebStore server in downtown Denver. Then it will import those files into the WebStore application's database.
6. You will run a process in Assist that will reboot the Tomcat server on the SCOPS server in our hosting facility in Denver. This will make the new data live on SCOPS.

Ready? Then let's begin.

Convert Product Manager Data

Click on the appropriate link below to start the conversion process.

• Convert LIVE Product Manager Data
• Convert TEST Product Manager Data

Download Text Files to the M: Drive

1. When the program from the previous step finishes, there are links at the bottom of that browser window in the second-to-last section on that page for downloading the text files. Make note of the location where it instructs you to save those files.
2. Click on a link for one of the files. It will open the converted text file in a new window.
3. Click on the View selection from the window's toolbar and select Source. That will bring up the actual source of the text file in a text editor.
4. Click on the File option on the text editor's toolbar and select Save As.
5. Save the file to the location that is specified in the window from the first step. Remove the "[1]" from the filename before saving!
6. Close the text editor and the window that is displaying the text file.
7. Repeat these steps for all files listed.

NOTE: Be sure that you save the files to the correct directory on the M: drive. Otherwise your data could be imported into the wrong environment on the next step or it could not be imported at all.

Import Text Files from the M: Drive into Assist

1. There are also links at the bottom of the screen where you just ran the Product Manager conversion file that will run the file imports. You must have completed the previous section before you begin this one.
2. Click on a link for one of the file imports.
3. A dialog box will come up to either Open or Save. Choose Open. This will run the import procedure.
4. An AS/400 data transfer dialog window will open. Click on the Transfer Data to AS/400 button.
5. You will be asked to provide your Assist userid/password. Do so.
6. You will see a record count begin which will let you know that the data is being transferred. When it is complete it will tell you how many rows were transferred.
7. Click on the OK button.
8. Close the data transfer dialog window.
9. Repeat these steps for all of the files listed.

Convert Assist Data into WebStore Format

1. If you are processing LIVE data, log onto assist.
2. If you are processing TEST data, log onto assistp.
3. Press the ESC key.
4. Select the Work With Printer Output from the menu.
5. Delete all previous REPORT1, REPORT2 and REPORT3 spool files.
6. Press F12 twice to get back to the Assist menu.
7. Select the E-Commerce selection from the main menu.
8. Select the Import Menu option from the next menu.
9. Select the Create Import File option from the next menu.
10. Enter SON into the Merchant Code Field.
11. Press Enter
12. Press F5 to update the screen and begin the conversion process.
13. You will be taken back to the previous menu.
14. Watch for an error that says the previous primary import file has not been processed. It must be processed before you can create a new one!. Press F12 which will take you back to the previous screen. Then you must perform the steps in the next section, Transfer and Import Data from Assist to WebStore, after which you can return to this section and repeat these steps.
15. You now have to wait until the process finishes creating the REPORT1, REPORT2 and REPORT3 files.
16. Press the ESC key.
17. Select the Work With Printer Output from the menu.
18. Press F5 to refresh the screen. Do this as necessary until the page count stops increasing on REPORT1. Then you know it's done and you can do the steps in the next section.

NOTE: You can print the three REPORT files to see if specific product information will be imported into WebStore or not. It will tell you if they've been added or removed. If a product is not going to be imported into WebStore from Assist it will tell you why. Those things can be corrected in Assist and then you can do the import process again.

Transfer and Import Data from Assist to WebStore

1. Press F12 twice to return to the Assist menu.
2. Select the Import Data to WebStore option from the menu.
3. You will get a screen next that will show the files being transferred from the AS/400 to the web server. Wait until it says Press ENTER to end terminal session.
4. Press Enter.
5. Now you will see a message that says Import process on remote server is running. Please wait...
6. Wait.
7. When it is done importing the data into the WebStore database you will be taken to the previous menu screen where you can perform the steps in the next section.

Reboot the WebStore Tomcat Server

1. Select the Restart Tomcat Remote Server option from the current menu.
2. You will see a message that says Stopping Tomcat on Remote Server. Please wait...
3. Wait.
4. In just a minute, that message will go away and return you to the menu. If it takes a long time to go away, then there is an error and you need to contact Assist probably.
5. This just starts the reboot process on the server. Even though the message has gone away in Assist, the process takes several more minutes on the WebStore Server. Customers will get a maintenance screen while the server is rebooting. It takes about 3-5 minutes total.