将Sharepoint数据保存到SQLite表中

问题描述：

我试图将多个Sharepoint站点的数据保存到SQLite数据库文件中。我可以使用Sharepoint库访问数据。但无法将Sharepoint列表转换为Pandas Dataframe &，然后写入SQLite表。我用下面的网站的支持，这里是我的代码 https://pypi.python.org/pypi/sharepoint/0.4.1 Saving SharePoint list with Python 将Sharepoint数据保存到SQLite表中

一个片段，我不知道是否存在通过SharePoint列表不同的技术来循环并写入到SQL插入。我只是对熊猫图书馆更舒服一点。当前的计划是Sharepoint LIst - > DataFrame - > SQL。我怎么解决这个问题？ PS：我是新来的Python和使用它仅上周:)

import pandas as pd 
# Importing Sharepoint Library 
from sharepoint import SharePointSite, basic_auth_opener 
import urllib2 
from ntlm import HTTPNtlmAuthHandler 
# Windows Credentials 
username="xxxxx" 
password='xxxxxx' 

# The sharepoint info 
server_url="https://example.com/" 
site_url=server_url+"sites/XYZ/" 
# list_name='list_name' 
# FieldName='Output Field' 


passman=urllib2.HTTPPasswordMgrWithDefaultRealm() 
passman.add_password(None,server_url,username,password) 
auth_NTLM = HTTPNtlmAuthHandler.HTTPNtlmAuthHandler(passman) 

# Create and Install the opener 
opener=urllib2.build_opener(auth_NTLM) 
urllib2.install_opener(opener) 

# Create a sharepoint object 

site=SharePointSite(site_url,opener) 
sp_list=site.lists['list_name'] 
#  print row.id,row.Column1, row.Column2 
      TestDictionary=dict({'Column1':'Column1','Column2_x0020_Field2' : 'Column2'}) 

df=pd.from_dict(TestDictionary) 
df.to_sql()

答

更新已经开始：我用一个列表存储SharepointList。列表创建完成后，您可以轻松加载到数据框中。

data=[] 
for row in sp_list.rows: 
    data.append[(Column1,Column2_x0020_Field2)] 
df=pd.DataFrame(data,columns=['Column1','Column2'])

将Sharepoint数据保存到SQLite表中

相关推荐