We are working hard to make updates to the Shop and Account Management portal.

Please note that many of these changes will roll out this Saturday, June 1st and will require downtime. We are working to ensure minimal disruption for our eOne community and really appreciate your patience as we push out these changes. Please reach out to sales@eonesolutions.com with any questions.

Using SharePoint as a Data Source

Using SharePoint as a Data Source

Setup a SharePoint Folder Data Source Integration.  

Note: SharePoint is only available as a folder data source.

1. In SmartConnect navigate to Data Sources > Bulk Sources > Folder. 

2. On the Folder Data Sources window select “Create Bulk Folder”. 

3. On the New Folder Data Source screen, select the data source file type. 

4. Description – Friendly description for the data source. 

5. File Selection – choose “Load from SharePoint connection”. 

6. Template File Details tab. 

  • File Type – read-only view of file type of data source. 
  • Template File – Select a sample source file with same column headers and data types as files from SharePoint folder. 
  • Excel Sheet – Worksheet from Excel file to process. 

7. SharePoint Details tab. 

  • SharePoint Connection – Select a Graph Odata connection. 
  • Source Directory – Location where the files used for integration are stored. 
  • Success Directory – Files that are processed successfully are moved to this location. 
  • Fail Directory – Files that fail during processing are moved to this location. 
  • Empty File Action – Drop down list which indicates the action should be taken on empty files. 
    • Leave File – leave empty files in the Source Directory. 
    • Move File to Failure – move empty files to the Fail Directory. 
    • Move File to Success – move empty files to the Success Directory. 
  • Overwrite Files – If selected, files in the Fail and Success Directories will be overwritten. 
  • Append Date Time – If selected, SmartConnect will add the current date and time to files moved to the Fail and Success Directories.  

8. Click Validate. 

9. Click Preview to display a pop-up window with a sample of the data from the template spreadsheet. 

10. Click Save. 

 

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters