Skip to content

DocXtender

DocXtender – SharePoint Structure

Viewing 13 posts – 1 through 13 (of 13 total)
  • Author
    Posts
  • #8057
    Blair H.

    Hi, can you clarify if / how you can define the SharePoint site structure. Documentation shows ‘SharePoint Host’, ‘SharePoint Folder’ and ‘SharePoint Site’.

    Does DocXtender create folders for each Account / Vendor and transactions type?

    This is the structure I am hoping to confirm.

    • company.sharepoint.com
      • Business Central – (Site)
        • Customer Account – (Folder)
          • Sales Order number – (Folder)
            • Attachments – (files)
        • Vendor Account – (Folder)
          • Purchase Inv Header Number – (Folder)
            • Attachments – (files)

    What is the Site & Folder naming convention? If I wanted to reference the SharePoint site where a Purchase Inv Header attachment was stored from BC, what would be the URL path?

    Thank you,

    Blair

    #9140
    Brett M.
    Insight Works

    Hello Blair,

    You have the essence of the idea. There will also be a subfolder created for the document type.
    The SharePoint subfolders will be created based on the card that the document is attached to (see below).

    • SharePoint Host
      • SharePoint Site – (Site)
        • SharePoint Folder – (Folder)
          • Document Type – (i.e. Sales Order)
            • Document Number – (Folder)
              • Attachments – (files)

    The first three points will come from the settings in DocXtender Setup. Please see the knowledge article regarding configuration for DocXtender, below.

    Configure DocXtender Setup

    #9141
    Blair H.

    Hi Brett,

    Thanks for the quick reply. So documents are grouped Document Type and Document Number. There is no grouping by Customer or Vendor and then by Document Type and then Document number.

    Thanks, Blair

    #9157
    Brett M.
    Insight Works

    Hi Blair,

    Unfortunately, there is no configuration for it. The structure is pre-defined based on the type of document that it is attached to.

    #9558
    Devon D.

    Hi,

    I know this is a late reply but I have DocXtender configured correctly to go to our sharepoint, but I do not see the file structure that you are mentioning above.

    Do I have to create that Business Central Site and then it would create all the subdirectories?

    #9559
    Brett M.
    Insight Works

    Hi Devon,

    Please see this knowledge base article: http://kb.dmsiworks.com/knowledge-base/initial-configuration/

    You may need to ask your Business Central partner for troubleshooting help or you can submit a paid support ticket to su*****@*******ks.com

    #9637
    Tim M.

    We have been using docXtender for a while now and are wanted to switch from “BC Database storage” to “SharePoint storage”. the two key features I see missing from DocXtender that are in other similar apps are custom mapping and sync or move options.

    It would be very helpful if there was a table mapping that could be changed or edited. Instead of having all attachments go to Site>Library>folder being able to map them out much like Blair stated previously.

    • <company>.sharepoint.com
      • Business Central Documents (Library)
        • Customer Folder (Name-CustomerNo.)
          • Contracts/Agreements
          • Orders (DocNumber)
          • Invoices (DocNumber)
        • Vendors
          • <subfolder>
        • Items
          • <subfolder>
          • <subfolder>

    Once this mapping is created the option to sync or move current attachments from the BC Database to the SharePoint site would be very helpful.

    #9963
    Theo S.

    Hi there,

    I am doing an initial Setup and am wondering if the SharePoint Folder may:

    1. Contain Spaces e.g. ‘BC Documents’

    2. May include subfolders too e.g. ‘BC Documents\Company A’

    We have the latter, and when dropping in a document it:

    1. lands in SharePoint

    2. Shows in the Links Factbox

    3.  but the DocXtender Control (in the Item Card Page) still shows 0 (Zero) Documents

    Could this be related to the SharePoint Folder we used?

    Thanks

    Theo

    #9964
    Travis P.
    Insight Works

    While spaces are technically valid, try to avoid all symbols and keep names to just alphanumeric characters to keep it simple and avoid possible issues in the URL lookup.

    As for the link, DocXtender does not control the refresh of the Attachment or Link factboxes, so try backing out of the record and re-opening it to see if the link shows up.

    #10272
    George S.

    Hello all.

    Wondering if by chance there has been any change with regards to setup a folder structure by Vendor or Customer as per Blair’s request above.

    My trusty Copilot has suggested the below:
    <div><!–ScriptorStartFragment–>

      <li class=”scriptor-listItemlist!list-44375317-4fb1-4973-aff2-f657f53c79020″>Define Folder Structure for Each Document Type:
      <ul class=””>
      <li class=”scriptor-listItemlist!list-44375317-4fb1-4973-aff2-f657f53c79020″>In the SharePoint Folder field, you can define a dynamic folder structure using placeholders. For example:
      <ul class=””>
      <li class=”scriptor-listItemlist!list-44375317-4fb1-4973-aff2-f657f53c79020″>For purchase invoices: <code class=”language-PlainText”>Documents/Purchase Invoices/{VendorName}/{DocumentNumber}
      <li class=”scriptor-listItemlist!list-44375317-4fb1-4973-aff2-f657f53c79020″>For sales orders: <code class=”language-PlainText”>Documents/Sales Orders/{CustomerName}/{DocumentNumber}
      <!–ScriptorEndFragment–>

    </div>
    However, the above just does not work.

    Am I missing something by change?  Is my Copilot out to lunch?

    Thank you,

    George S.

    #10273
    George S.

    Apologies see below for plain text

    Define Folder Structure for Each Document Type:
    In the SharePoint Folder field, you can define a dynamic folder structure using placeholders.

    For example:
    For purchase invoices: Documents/Purchase Invoices/{VendorName}/{DocumentNumber}

    For sales orders: Documents/Sales Orders/{CustomerName}/{DocumentNumber}

    #10274
    Travis P.
    Insight Works

    I’m not sure what your copilot is referring to because the DocXtender folder structure is hard coded to guarantee each path is unique. It is not user configurable or extendable. The copilot is probably referring to some other app.

    #10278
    George S.

    Thanks Travis.  Guess Copilot took me on a bit of wild goose chase.  Having said that it would be some awesome functionality to add to DocXtender in the future.

Viewing 13 posts – 1 through 13 (of 13 total)
  • Sign in below to reply.