Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sharepoint pulls data from excel or text file

Posted on 2014-09-09
5
Medium Priority
?
177 Views
Last Modified: 2014-10-02
Can someone shed some light on the best easiest way for SharePoint to pull data from a text file or excel?  Basically, I want SharePoint to display the updated Wi-Fi passcode each month automatically from a preset password file.

For example, the data file will include:
2014, JAN, 12345
2014, FEB, 54321
....
2014, DEC, 98765
0
Comment
Question by:Vic T
  • 3
  • 2
5 Comments
 
LVL 37

Expert Comment

by:Neil Russell
ID: 40313254
So i assume that every month somebody has to manually change the WiFi password on at least one device?
Why not just have this person also update the single Item on Sharepoint?

What happens when its automated and the man/woman doing the Manual process of updating your WiFi routers is off sick or just plain forgets for a few hours and nobody can access using the password on sharepoint?
0
 
LVL 5

Author Comment

by:Vic T
ID: 40313277
Neilsr - all APs are already preset with the same passwords on the password file.  There is no manual input required.
0
 
LVL 37

Expert Comment

by:Neil Russell
ID: 40313293
OK so if thats the case and somebody had to type them in, why not create a sharepoint list that holds that self same information and just have a view that filters and only shows the one record that has a month = to the month of [Today] ?

Reading a text file in can be done in many ways but for such a small amount of information the simplest method is human typist.

If you MUST do it by a script then powershell is quite good at doing sharepoint.  Or just use the sharepoint Create new list from import excel feature found on the Create New List page.
0
 
LVL 5

Author Comment

by:Vic T
ID: 40313303
Can you elaborate more on the sharepoint filter?
0
 
LVL 37

Accepted Solution

by:
Neil Russell earned 2000 total points
ID: 40313321
Easiest way would be to have 2 date fields, [Start of month] and [End of Month]
Set these to the start and end dates of the month that each password is for
e.g.
HYT65!ws  01/01/2014 31/01/2014

Now create a view on that list that has a filter set to...

[Today] >= [Start Of Month]

AND

[Today] <= [End Of Month]
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question