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 spreadsheet. Any help would be greatly appreciated. Thanks!
[Prestige Fabricators, Inc.]https://prestigefab.com James Trogdon IT Manager jtrogdon@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 ---
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-bounces@leafe.com] On Behalf Of James Trogdon Sent: Tuesday, April 05, 2022 2:08 PM To: profoxtech@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 jtrogdon@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]
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 tracy@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-bounces@leafe.com] On Behalf Of James Trogdon Sent: Tuesday, April 05, 2022 2:08 PM To: profoxtech@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 jtrogdon@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]
--- 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 ---
--- 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 ---
James,
The listserve does not send the HTML portion of emails through. If you can, send messages as plain text.
Tracy
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of James Trogdon Sent: Wednesday, April 06, 2022 8:01 AM To: profoxtech@leafe.com 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 ---
[excessive quoting removed by server]
-
James Trogdon -
Stephen Russell -
Tracy Pearson