Supplier Management

Get Involved. Join the Conversation.

Topic

    Shivani Roy
    Points to consider when importing supplier attachments using...
    Topic posted October 31, 2018 by Shivani RoyBlue Ribbon: 750+ Points, tagged How-To, Import, Supplier Profile Management, Tip 
    40 Views
    Title:
    Points to consider when importing supplier attachments using Import Supplier Attachments FBDI template.
    Summary:
    Here are some useful tips for importing supplier attachments using the supplier attachments import template:
    Content:

    1. Pick the correct template as per your quarterly update. Refer to this post to access the correct FBDI template for your quarterly update:

    Where can I find FBDI Import templates for my current quarterly update?

    2. In general an import job can complete successfully and still have error status even if one of the records failed to import due to incorrect data provided. Check the report to ensure all attachments are    imported successfully and identify any failed records.

    3. The Supplier Attachment Import template contains three individual worksheets for importing supplier profile, supplier site and business classification attachments.The instructions to run the import are given in the ‘Instructions and CSV Generation’ worksheet of the import template.Do not delete worksheets corresponding to levels of attachments that you do not intend to import. Delete only the sample data from these unused worksheets.

    4. For a file attachment consider the following points:

    • Make sure the zip filename matches the zip file uploaded in the UCM server.
    • Make sure the ‘File/Text/URL*’ column value in the spreadsheet has the full folder hierarchy of the attachment file inside the zip folder including subfolders if any. Take a look at the example below.

                             e.g: we have a zip file named: Policies.zip

                                    Subfolder: SupplierPolicies is a subfolder in the zip file

                                    File Name: Terms.doc is the file inside the subfolder

                                    Input for column ‘File/Text/URL*’: SupplierPolicies/Terms.doc

                                    Input for column ‘File Attachments .ZIP’: Policies.zip

    • Use multiple small zip files instead of one large zip file.  Use one or more zip files for each batch and use batch name as part of zip file name for ease of data entry in the spread sheet. You can also have multiple zip files under the same batch.
    • Some of the special characters are currently not supported for a filename:

               <  >  *  ?  |  ;  "  :  /  \\  %  $  ( )

     

    Readiness training video is available for further reference: Supplier Attachments Import

    Tips on general supplier import: Supplier Import Tips