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/004601d8491b$8355c2d0$8a014870$@powerchurch.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.
