I have a use case where our shared storage is on OneDrive. Can we point the flat file adapter to a OneDrive folder to ingest the csv file? If so, what is the format of the folder path?
Hi Richard,
Sure you can. In the OneDrive folder, right click on the CSV file that you want to ingest and select "copy as path". Paste this into the file path box of the flat file configuration in Adapters. Make sure you remove the double quotes (if any) on the file path box. After you have defined the delimiter, qualifier ad column mappings, save the job and execute the job from the adapters client. That should upload the content of the CSV file into Assets Data Manager.
'Copy as path gives' me a local drive path that starts with "c:\". I am assuming that it is a local file on my local drive that is synced up to oneDrive.
I have the adapter on a vm running 24/7 so it can do updates. If I have the adapter on a schedule to run while my local is not online, how will the adapter pull in the file that is on my oneDrive? Does this mean that I need to have oneDrive desktop installed on the computer that is running the adapter so that the local and online drive is always synced?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Q: 'Copy as path gives' me a local drive path that starts with "c:\". I am assuming that it is a local file on my local drive that is synced up to oneDrive.
A: YES!
Q: Does this mean that I need to have oneDrive desktop installed on the computer that is running the adapter so that the local and online drive is always synced?
A: YES!
Q: I have a use case where our shared storage is on OneDrive. Can we point the flat file adapter to a OneDrive folder to ingest the csv file? If so, what is the format of the folder path
A: You could also use the Universal Naming Convention (UNC) path in the file path field/box in the flat file configuration if you know the server name and the shared resource name. A valid UNC path must have at least two path components; the server name and a shared name. There are no drive letters like C: or D: An example of a UNC path could be \\servername\shared-resource-pathname i.e. \\MYSERVER\MYFOLDER\test.csv
The assumption is firewall rules are set up so that the adapter client can access the "test.csv" file.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.