RE: VFP to SharePoint Spreadsheet Dashboard

2022-04-06 Thread Tracy Pearson
Subject: RE: VFP to SharePoint Spreadsheet Dashboard --- StripMime Report -- processed MIME parts --- multipart/alternative --- StripMime Errors --- A message with no text/plain section was received. The entire body of the message was removed. Please resend the email using plaintext formatting

RE: VFP to SharePoint Spreadsheet Dashboard

2022-04-06 Thread James Trogdon
--- StripMime Report -- processed MIME parts --- multipart/alternative --- StripMime Errors --- A message with no text/plain section was received. The entire body of the message was removed. Please resend the email using plaintext formatting --- ___ Pos

RE: VFP to SharePoint Spreadsheet Dashboard

2022-04-06 Thread James Trogdon
--- StripMime Report -- processed MIME parts --- multipart/alternative --- StripMime Errors --- A message with no text/plain section was received. The entire body of the message was removed. Please resend the email using plaintext formatting --- ___ Pos

Re: VFP to SharePoint Spreadsheet Dashboard

2022-04-05 Thread Stephen Russell
I'd consider doing a PowerBI dashboard to deliver the "news" on trailer status. Doing it in SP is good too, but updating that data source is a lot harder IMO from VFP. >From SQL Server there are hooks built for doing this in an SSIS job. You could schedule that job to run ever 2-5 min. You coul

RE: VFP to SharePoint Spreadsheet Dashboard

2022-04-05 Thread Tracy Pearson
It was a long time ago I heard a talk about SharePoint. Does the Spreadsheet basically use an Access database, or an MSSql server for the backend data? Wouldn't you just be updating that table and the SharePoint site will take care of the rest? I haven't done this myself, I only remember bits of t