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 could probably pull from VFP data in SSIS as well. Just getting that running is a hurdle to overcome. What version of SP? On prem or M365? On Tue, Apr 5, 2022 at 1:32 PM Tracy Pearson <tr...@powerchurch.com> wrote: > 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 the talk and none of > the > front end implementation. > > Tracy > > -----Original Message----- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of James > Trogdon > Sent: Tuesday, April 05, 2022 2:08 PM > To: profoxt...@leafe.com > Subject: VFP to SharePoint Spreadsheet Dashboard > > > Hi All, > > The company I work for is eventually going to a new ERP but until that time > I still must maintain some VFP (version 6 and 9) apps. I have a trailer > assigning project that will allow people to scan orders to a trailer. The > orders are then scanned when they begin loading and when they finish > loading. After the loading, a query is run to determine if all the orders > for that trailer is complete. I had thought to just email the information, > but the users are wanting a live dashboard configured as a SharePoint > Spreadsheet where everybody in the company can see it. The shipping tower > would like to mark when an order has been picked and delivered. I've never > done any development accessing SharePoint with VFP so I thought I would ask > how you would display a dashboard that would refresh every 5 minutes or so > but still allow certain fields to be marked as complete on the spreadsheet. > I would assume the program would be setup as scheduled task running every 5 > minutes to update the spreads > heet. Any help would be greatly appreciated. Thanks! > > > > > > > [Prestige Fabricators, Inc.]<https://prestigefab.com> James Trogdon > IT Manager > jtrog...@prestigefab.com > O: 336.626.4596 ext. 12051 > 905 NC Highway 49 S, Asheboro, NC 27205 > ________________________________ > The content of this email is confidential and intended for the recipient > specified in message only. It is strictly forbidden to share any part of > this message with any third party, without a written consent of the sender. > If you received this message by mistake, please reply to this message and > follow with its deletion, so that we can ensure such a mistake does not > occur in the future. > > Disclaimer > > The information contained in this communication from the sender is > confidential. It is intended solely for use by the recipient and others > authorized to receive it. If you are not the recipient, you are hereby > notified that any disclosure, copying, distribution or taking action in > relation of the contents of this information is strictly prohibited and may > be unlawful. > > This email has been scanned for viruses and malware, and may have been > automatically archived by Mimecast Ltd, an innovator in Software as a > Service (SaaS) for business. Providing a safer and more useful place for > your human generated data. Specializing in; Security, archiving and > compliance. To find out more visit the Mimecast website. > > > --- StripMime Report -- processed MIME parts --- > multipart/related > multipart/alternative > text/plain (text body -- kept) > text/html > image/gif > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/cajidmykbopdtm7fabite3h_ofe5wxyapfx-o9hpwmbysba4...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
