Sharepoint and Sql Server
0
I have a SharePoint list where every item has an attachment in .xlsx format.Is it possible to read the content of the attachments and then create a table in Sql.
example, if there are 10 items with 10 attachments , then it should create 10 tables with the contents from the attachment..
any possibilities ?
sql-server sharepoint asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
add a comment |
0
I have a SharePoint list where every item has an attachment in .xlsx format.Is it possible to read the content of the attachments and then create a table in Sql.
example, if there are 10 items with 10 attachments , then it should create 10 tables with the contents from the attachment..
any possibilities ?
sql-server sharepoint asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
Why do that at all? What are you trying to do and why do you think that copying anything to SQL Server is the solution? Besides attachments are files not rows. The question doesn't make sense as is. You describe what you have but not what you want to do.
– Panagiotis Kanavos
Nov 14 '18 at 15:22
1
ODATA and CSOM can get you list items and attachments. Libraries like EPPlus or even an OpenXmlReader can read that data. What do you want to do with it though? Each file can have completely different contents, multiple sheets, multiple ranges per sheet
– Panagiotis Kanavos
Nov 14 '18 at 15:34
You can look at this stackoverflow.com/questions/45555620/… OR Cozyroc (which is out of bizz) was a 3rd party component you can use to dl sharepoint excel. Either way if its a 1 time solution you can go proposed route in url above to just dl the excel locally and then ETL into sql tables. But if its a on-going process you may need a solidified solution.
– junketsu
Nov 14 '18 at 20:28
add a comment |
0
0
0
I have a SharePoint list where every item has an attachment in .xlsx format.Is it possible to read the content of the attachments and then create a table in Sql.
example, if there are 10 items with 10 attachments , then it should create 10 tables with the contents from the attachment..
any possibilities ?
sql-server sharepoint asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
I have a SharePoint list where every item has an attachment in .xlsx format.Is it possible to read the content of the attachments and then create a table in Sql.
example, if there are 10 items with 10 attachments , then it should create 10 tables with the contents from the attachment..
any possibilities ?
sql-server sharepoint sql-server sharepoint asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
asked Nov 14 '18 at 15:16
partha buragohainpartha buragohain
196
196
Why do that at all? What are you trying to do and why do you think that copying anything to SQL Server is the solution? Besides attachments are files not rows. The question doesn't make sense as is. You describe what you have but not what you want to do.
– Panagiotis Kanavos
Nov 14 '18 at 15:22
1
ODATA and CSOM can get you list items and attachments. Libraries like EPPlus or even an OpenXmlReader can read that data. What do you want to do with it though? Each file can have completely different contents, multiple sheets, multiple ranges per sheet
– Panagiotis Kanavos
Nov 14 '18 at 15:34
You can look at this stackoverflow.com/questions/45555620/… OR Cozyroc (which is out of bizz) was a 3rd party component you can use to dl sharepoint excel. Either way if its a 1 time solution you can go proposed route in url above to just dl the excel locally and then ETL into sql tables. But if its a on-going process you may need a solidified solution.
– junketsu
Nov 14 '18 at 20:28
add a comment |
Why do that at all? What are you trying to do and why do you think that copying anything to SQL Server is the solution? Besides attachments are files not rows. The question doesn't make sense as is. You describe what you have but not what you want to do.
– Panagiotis Kanavos
Nov 14 '18 at 15:22
1
ODATA and CSOM can get you list items and attachments. Libraries like EPPlus or even an OpenXmlReader can read that data. What do you want to do with it though? Each file can have completely different contents, multiple sheets, multiple ranges per sheet
– Panagiotis Kanavos
Nov 14 '18 at 15:34
You can look at this stackoverflow.com/questions/45555620/… OR Cozyroc (which is out of bizz) was a 3rd party component you can use to dl sharepoint excel. Either way if its a 1 time solution you can go proposed route in url above to just dl the excel locally and then ETL into sql tables. But if its a on-going process you may need a solidified solution.
– junketsu
Nov 14 '18 at 20:28
Why do that at all? What are you trying to do and why do you think that copying anything to SQL Server is the solution? Besides attachments are files not rows. The question doesn't make sense as is. You describe what you have but not what you want to do.
– Panagiotis Kanavos
Nov 14 '18 at 15:22
Why do that at all? What are you trying to do and why do you think that copying anything to SQL Server is the solution? Besides attachments are files not rows. The question doesn't make sense as is. You describe what you have but not what you want to do.
– Panagiotis Kanavos
Nov 14 '18 at 15:22
1
1
ODATA and CSOM can get you list items and attachments. Libraries like EPPlus or even an OpenXmlReader can read that data. What do you want to do with it though? Each file can have completely different contents, multiple sheets, multiple ranges per sheet
– Panagiotis Kanavos
Nov 14 '18 at 15:34
ODATA and CSOM can get you list items and attachments. Libraries like EPPlus or even an OpenXmlReader can read that data. What do you want to do with it though? Each file can have completely different contents, multiple sheets, multiple ranges per sheet
– Panagiotis Kanavos
Nov 14 '18 at 15:34
You can look at this stackoverflow.com/questions/45555620/… OR Cozyroc (which is out of bizz) was a 3rd party component you can use to dl sharepoint excel. Either way if its a 1 time solution you can go proposed route in url above to just dl the excel locally and then ETL into sql tables. But if its a on-going process you may need a solidified solution.
– junketsu
Nov 14 '18 at 20:28
You can look at this stackoverflow.com/questions/45555620/… OR Cozyroc (which is out of bizz) was a 3rd party component you can use to dl sharepoint excel. Either way if its a 1 time solution you can go proposed route in url above to just dl the excel locally and then ETL into sql tables. But if its a on-going process you may need a solidified solution.
– junketsu
Nov 14 '18 at 20:28
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53303396%2fsharepoint-and-sql-server%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53303396%2fsharepoint-and-sql-server%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Why do that at all? What are you trying to do and why do you think that copying anything to SQL Server is the solution? Besides attachments are files not rows. The question doesn't make sense as is. You describe what you have but not what you want to do.
– Panagiotis Kanavos
Nov 14 '18 at 15:22
1
ODATA and CSOM can get you list items and attachments. Libraries like EPPlus or even an OpenXmlReader can read that data. What do you want to do with it though? Each file can have completely different contents, multiple sheets, multiple ranges per sheet
– Panagiotis Kanavos
Nov 14 '18 at 15:34
You can look at this stackoverflow.com/questions/45555620/… OR Cozyroc (which is out of bizz) was a 3rd party component you can use to dl sharepoint excel. Either way if its a 1 time solution you can go proposed route in url above to just dl the excel locally and then ETL into sql tables. But if its a on-going process you may need a solidified solution.
– junketsu
Nov 14 '18 at 20:28