Problem
Your ROP Configuration.xlsm workbook is formatted properly, but the work steps are not correctly generated.
Solution
If your ROP Configuration.xlsm workbook is formatted properly yet work steps are not correctly generated, the workbook might have some extraneous data that needs to be deleted. If you had previously populated a column and deleted the information, data might still linger in that column. Use the following steps to properly delete the data.
-
Open the ROP Configuration.xlsm workbook to the tab that has work steps not generating properly. For example, if you notice boltup work steps are not generated properly, navigate to the Boltups tab.
-
On the tab, press CTRL + END to navigate to the right-most column with data.
If Excel navigates you to an empty cell, there is data that has not been properly deleted.
-
Select all columns - begin with the column that was selected using CTRL + END to the column to the right of the column with visible data.
-
Right-click the selected columns, and select Delete to open the Delete dialog box. Select Entire column and click OK.
-
Save and close the workbook.
-
Open the workbook.
-
Press CTRL + END to navigate to the right-most column with visible data. Verify all columns with previously deleted data were deleted from the workbook.
-
Repeat steps 1-5 in other tabs where work steps not generating properly.
-
Save the ROP Configuration.xlsm workbook.
-
Open the Main tab of the workbook.
-
Click Generate Configuration File to generate the XML mapping to be used during retrieve.
-
Check in and sign off the ROP Configuration.xlsm workbook.
-
Retrieve documents into Smart Construction.
For more information on configuring rules of progress, see Configure the Rules of Progress.