Job Spec Sheet attached to PDF Review Mail Send
Posted: Fri Oct 08, 2021 4:54 pm
I have set up PDF Review module flows and they are working well. But I have requests from our project managers handling job production. With our previous MIS, job spec sheets (PDFs) were sent to the customer along with the proof. When the proof was manually attached in the old system the spec sheet PDFs were generated automatically and included with the proof; links to both PDFs (proof and specs) were in the sent email.
Now with PDF Review module you do not have that, it's just the job proof that the customer sees. We don't have to manually attach proofs anymore, we just drop it in a folder (much faster), which is great, but Switch is not including job spec information.
So for now, in cases where the customer needs this spec sheet, the proof email goes to the project manager. They use Crystal Reports to make the spec sheet PDF and then they attach that to the email and forward to the customer.
That works but it's a little time consuming. I have been trying to think of a solution where Switch can attach the spec sheet to the email. The first problem, I don't have the spec sheet to attach it. I have the job XML, and the proof. The XML unfortunately does not have all of the information that this spec sheet has.
I discovered that they can instead generate an XML from Crystal Reports, not a PDF. I think I can come up wit a flow that successfully joins this XML with the job. So to illustrate:
1. Proof and job XML are in folder. Prepress drops this into hotfolder.
2. Project Manager creates spec sheet XML and writes that to a Switch monitored location. This gets married with the proof and job XML. (So yes, 2 XMLs, crazy as it sounds)
3. The spec sheet XML needs to be a PDF attached. I think I can use XLST transform to somehow rework this spec sheet into a PDF format. The reason I can't just have them generate a PDF to begin with – when they make the PDF out of Crystal Reports, there is no metadata in that PDF. I need that so Switch can link it up with the correct job proof.
4. Once I have that spec sheet PDF I feel fairly confident I can get that attached to the PDF Review email (we don't actually attach the proof, but I am sure there is a way to swap that out with the spec sheet, and then set the email to "Attach file"
I hope this makes sense. This is a convoluted solution. The project managers are still having to make these spec sheets manually out of Crystal Reports, but at least they would not have to attach them and forward the email. I just want to know: is there some obvious, much easier solution? The last thing I want to do is build this flow and find out later there is a more efficient workaround.
Now with PDF Review module you do not have that, it's just the job proof that the customer sees. We don't have to manually attach proofs anymore, we just drop it in a folder (much faster), which is great, but Switch is not including job spec information.
So for now, in cases where the customer needs this spec sheet, the proof email goes to the project manager. They use Crystal Reports to make the spec sheet PDF and then they attach that to the email and forward to the customer.
That works but it's a little time consuming. I have been trying to think of a solution where Switch can attach the spec sheet to the email. The first problem, I don't have the spec sheet to attach it. I have the job XML, and the proof. The XML unfortunately does not have all of the information that this spec sheet has.
I discovered that they can instead generate an XML from Crystal Reports, not a PDF. I think I can come up wit a flow that successfully joins this XML with the job. So to illustrate:
1. Proof and job XML are in folder. Prepress drops this into hotfolder.
2. Project Manager creates spec sheet XML and writes that to a Switch monitored location. This gets married with the proof and job XML. (So yes, 2 XMLs, crazy as it sounds)
3. The spec sheet XML needs to be a PDF attached. I think I can use XLST transform to somehow rework this spec sheet into a PDF format. The reason I can't just have them generate a PDF to begin with – when they make the PDF out of Crystal Reports, there is no metadata in that PDF. I need that so Switch can link it up with the correct job proof.
4. Once I have that spec sheet PDF I feel fairly confident I can get that attached to the PDF Review email (we don't actually attach the proof, but I am sure there is a way to swap that out with the spec sheet, and then set the email to "Attach file"
I hope this makes sense. This is a convoluted solution. The project managers are still having to make these spec sheets manually out of Crystal Reports, but at least they would not have to attach them and forward the email. I just want to know: is there some obvious, much easier solution? The last thing I want to do is build this flow and find out later there is a more efficient workaround.