Genii Weblog


Civility in critiquing the ideas of others is no vice. Rudeness in defending your own ideas is no virtue.


Fri 15 Nov 2013, 04:18 PM
Going to put this out earlier because it is a Friday, so I plan to finish up soon.

I made some good progress today. Went into the SharePoint-community.net discussions and searched for CSV, which is my highest priority for understanding. Found only a few posts, but somebody else seemed to be asking the same thing. Replied asking if he ever got an answer, and a very knowledgable user answer me shortly after that, pointing me at the Import-CSV Cmdlet (a new vocabulary word for me), and also a link describing how to upload files into SharePoint using a script. With those two clues in hand, I was able to find some other resources about importing CSV into SQL Server (the database behind SharePoint).

I also found did some research on SharePoint site templates. Not useful today, but might be a possible direction if I decide to export some design along with the data. I already have the code to created the zipped collections, and the .cab/.wps files might allow me to get the data into SharePoint in something more constructive than a Listing site. No plans yet to try to get all the design over, but the data types and such would be useful. Maybe on Monday I'll have enough time to create a document library and try importing into that.

Overall, I am pleased by the documentation and the supportive community, but a little wary about SQL Server. I think I last used SQL in the 1980s, and my memories of those days are blurred by decades of child rearing and composite data records (a dangerous and volatile mix).

Inline GIF image

Copyright © 2013 Genii Software Ltd.