Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Can you use a CSV file with the Business Data catalog?

  Asked By: Jordan    Date: Jul 29    Category: Sharepoint    Views: 1027

I need to gather data into a list from a CSV which is dumped to a file location nightly. Can this be done using the bdc? Or is the bdc just for databases?



2 Answers Found

Answer #1    Answered By: Tera Callahan     Answered On: Jul 29

It should. The BDC can generally access any data  that can be accessed using ADO.NET.

Answer #2    Answered By: Mark Davis     Answered On: Jul 29

Another option could be write a webservice that can expose the CSV data  to sharepoint and consume that web service using BDC (use LINQ to csv for querying csv file, if you search you can get examples)
I would still consider like fernando suggested upload CSV data to SQL table and hookup BDC to this database or you could create a custom list  and upload the CSV data in custom list (right approach would depend on your scenario) BDC is not really meant for accessing csv files, its meant as a way to easily view LOB data that is otherwise exposed via LOB apps from sharepoint without having to write much custom code

Didn't find what you were looking for? Find more on Can you use a CSV file with the Business Data catalog? Or get search suggestion and latest updates.