Text Status Codes

Excel Formatting: If working with excel then there are some formatting issues that may arise. The ISBN will typically be read in as a number and formatted with scientific notation. This will not load properly. The cell will look like this:

The following steps will fix this formatting issue:
1. Click on the Data Tab
2. Highlight the column, then click on the text to columns icon

3. Click the Next button in the Convert Text to Columns Wizard.

4. Click Next again on step 2. (This is one column of data so the delimiter is not relevant)

5. The last screen must be changed from general to text.
6. Click Finish

The column will now show the full ISBN formatted as text.

Item Import Functionality: There is a hammer option in Item Maintenance that allows users to import GM, Textbook or Tradebook items from ASCII tab-delimited files. The hammer is used to import files to:
a. Add new items
b. Update information on existing items c. Update prices
To perform an item import for Text from an *Onyx or ASCII file:*
1. Access Item Maintenance, and choose the text tab.
2. Go to the hammer, and choose 'Import Item Information'.

3. The following screen will display:


4. Choose a Source File type of 'ONIX' or 'ASCII'
5. From the ellipses, choose the file name you wish to import.
6. If adding new items, check the 'Add New' box, and make sure the New and Used DCC's are accurate.
7. If desired, check the 'Get Vendor from ISBN' box to allow the system to assign a vendor to the items based on the ISBN.
8. If you wish to instead assign all items to a single vendor, uncheck the 'Get Vendor From ISBN' field. This allows you to input a specific vendor into the 'Vendor' field.
9.If adding new items, and if you want inventory records created for those items, check the 'Add to Inventory' box.
10. If updating existing items, choose whether to update New Cost, New Retail, Author / Title, Imprint, and/or Binding / Edition / Copyright. Check the appropriate boxes desired.
11. Choose the locations for which you wish to add / update items.
12. When finished, choose 'Import'. You will see a progress bar at the bottom of the dialog box.

13. When the process is complete, a summary will display.

Records will be skipped when there are errors.
1. The vendor could not be identified from the ISBN.
2. The option to add was selected and the item already exists.
3. The ID is bad.
Note: These errors are written to a table in the database called ImportLog_Detail.
To perform an item *import for Trade items from an Onyx or ASCII file:*
1.Access Item Maintenance, and choose the Tradebooks tab.
2.Go to the hammer, and choose 'Import Item Information'.

3.The following screen will display:

4.Choose a Source File type of 'ONIX' or 'ASCII'
5.From the ellipses, choose the file name to import.
6.If adding new items, check the 'Add New' box.
14.If desired, check the 'Get Vendor from ISBN' box to allow the system to assign a vendor to the items based on the ISBN.
15.To assign all items to a single vendor, uncheck the 'Get Vendor From ISBN' field. This allows a specific vendor to be selected. Click the ellipse in the 'Vendor' field to select the vendor.
7.Choose the DCC that will be assigned to the new items once they are loaded.
8. When adding new items, inventory records can also be created. Check the
'Add to Inventory' box to enable this option.
9.If updating existing items, choose whether to update Cost, Retail, Author / Title, Imprint, and/or Binding / Edition / Copyright. Check the associated boxes.
10.Choose the locations for which items will be added or updated.
11. When finished, choose 'Import'. A progress bar will display at the bottom of the dialog box.
12. When the process is complete, a summary will display.

Records will be skipped when there are errors.
1. The vendor could not be identified from the ISBN.
2. The option to add was selected and the item already exists.
3. The ID is bad.
Note: These errors are written to a table in the database called ImportLog_Detail.
To perform an item import for GM from an ASCII file (ONIX not available):
1.Access Item Maintenance, and choose the GM tab.
2.Go to the hammer, and choose 'Import Item Information'.

3.The following screen will display:

4.Choose a Source File type of 'ASCII'
5.From the ellipses, choose the file name to import.
6.Choose the vendor for the items.
7.If adding new items, check the 'Add New' box.
8.If adding new items, choose the DCC for the new items.
9. When adding new items, inventory records can also be created. Check the
'Add to Inventory' box to enable this option
10.If updating existing items, choose whether to update Cost, Retail, Description / Image URL, Size / Color, and/or Pkg Type / Units Per Pack. Check the associated boxes.
11.Choose the locations for which items will be added or updated.
12. When finished, choose 'Import'. A progress bar will display at the bottom of the dialog box.
13. When the process is complete, a summary will display.

Records will be skipped when there are errors.
1. 2. The option to add was selected and the item already exists.
3. The ID is bad.
Note: These errors are written to a table in the database called ImportLog_Detail.