Replies – Forums – jtaylor

John Taylor

Member

06/25/2024 at 11:08 AM in reply to: Uploading Doc/Images to Quantum on the Cloud

Hi Warren,

I would be interested to know how people are connecting a scanner. We couldn’t figure out how to configure that functionality.

John Taylor

Member

06/25/2024 at 11:07 AM in reply to: Uploading Doc/Images to Quantum on the Cloud

Hi Clinton,

Yes, we are currently scanning to a local folder and uploading it to the cloud. It’s super slow this way.

John Taylor

Member

03/18/2024 at 1:12 PM in reply to: PURCHASE MANAGEMENT – FILTER BY WO STATUS

@mike.carey Mike, did you have any luck creating the script for PM you mentioned? I am currently trying to create an SQL Update statement to toggle on and off the requisition field in the WO BOM. I’ve had success running the following statement to toggle on and off the release field in the WO_OPERATION table but haven’t been able to figure out an update statement that will query more than one table. Unfortunately, my understanding of SQL is pretty limited. I would be curious to know if anyone knows how to do this. Or if it’s even possible. What I am looking to do is toggle on/off the requisition field in WO_BOM when WOO.WOS_AUTO_KEY equals a specified status.

UPDATE WO_OPERATION

SET RELEASED = ‘F’

WHERE WOS_AUTO_KEY <> ‘3’ AND

OPEN_FLAG = ‘T’

John Taylor

Member

02/22/2024 at 6:44 AM in reply to: How to create a View in a schema other than QCTL

Thanks everyone for the help! Mike, yes, we did have the database on-premise in a local server. I saved the views as text files, so loading them should be easy now that you guys have provided instructions.

John Taylor

Member

02/21/2024 at 3:56 PM in reply to: How to create a View in a schema other than QCTL

Hi Warren,

Thank you for your feedback. Unfortunately, I am not experienced enough to even understand what you are trying to explain. You will have to dumb it down a bit. My understanding of SQL and Oracle databases are pretty limited.

John Taylor

Member

08/04/2023 at 12:04 PM in reply to: Quantum NXT Alpha Testing

I would be interested. (jtaylor@skyteam.cc)

John Taylor

Member

02/16/2023 at 1:25 PM in reply to: Event Manager Email – WO# in Subject Line

Thanks Mike. I kinda figured that would work. I will give it a try. Thanks for your help.

John Taylor

Member

11/07/2022 at 2:17 PM in reply to: How to add Hyperlink to XSL for Email Event Manager Notification

Disregard. I figured it out. 🙄

John Taylor

Member

11/07/2022 at 2:07 PM in reply to: How to add Hyperlink to XSL for Email Event Manager Notification

Mike,

I am getting an error. Must have input the URL link in the wrong place. Can you please clarify where in the code the link is placed?

John Taylor

Member

11/07/2022 at 1:00 PM in reply to: How to add Hyperlink to XSL for Email Event Manager Notification

Thanks Mike! I will give that a try. Appreciate your help!

John Taylor

Member

07/27/2022 at 5:23 AM in reply to: Event Manager – How to edit/change a Xsl Template

Thanks Tim! That’s a huge help and a great place to start. Let the fun begin! Time to learn. Appreciate the help.

Regards,

John

John Taylor

Member

07/26/2022 at 10:18 AM in reply to: Event Manager – How to edit/change a Xsl Template

Hi Tim,

Thanks for the quick reply. I will look into Visual Studio. How do you access the existing templates though? I would assume once you have the software you can connect to the database and see the templates.

Unfortunately, I am not attending the conference. As a business owner, it’s difficult to get away. I would like to do it one of these days. I am sure it’s very informative. Thanks for your assistance.

Regards,

John

John Taylor

Member

11/06/2023 at 8:24 AM in reply to: Blank Fields in Event Manager Email Notification

Yes, I have confirmed they are the same in the XML and XSL. I will send you an email. Thx!!

jtaylor

Forum Replies Created