Greetings All,
I am hoping there is just something simple I am missing. I created an output set using several custom output elements which I feed into some automations outside of tessitura by pulling them out of an excel email attachment. When I apply the output set to a list in the system, everything works. When I run the "Execute and Output Set" utility in Tess, everything works, but when I schedule it with an "Email-Excel" output, 1 element keeps coming in blank. The element is pulling the "notes" field from T_STEP (given specific criteria) so it should just be a basic string.
Has anyone experienced this or have any idea what may be causing this one field to fail.
If it helps, here is my SELECT statement from the Query Element Group table. (The "Deposit Amount" is my issue)
(SELECT o.customer_no,l.li_seq_no,l.num_seats_pur,o.order_dt,o.order_no,l.perf_no,c.fname +' '+ c.lname AS company_name,r.fname +' '+ r.lname AS customer_name,address,GETDATE() AS invoice_date,o.created_by,sd.due_dt AS deposit_due_dt,sb.due_dt AS balance_due_dt,i.description AS perf_name,f.perf_dt,l.tot_pur_amt,o.tot_due_amt,sd.notes AS deposit_amt,o.tot_paid_amt,o.tot_due_amt-o.tot_paid_amt AS balance_amtFROM T_LINEITEM l JOIN T_ORDER o ON o.order_no = l.order_no JOIN T_CUSTOMER c ON c.customer_no = o.customer_no JOIN T_CUSTOMER r ON r.customer_no = o.initiator_no JOIN T_EADDRESS e ON e.customer_no = o.initiator_no AND e.primary_ind = 'Y' JOIN T_PERF f ON f.perf_no = l.perf_no JOIN T_INVENTORY i ON f.perf_no = i.inv_no JOIN T_PLAN p ON p.plan_no = (SELECT MAX(plan_no) FROM T_PLAN WHERE customer_no = o.customer_no) JOIN T_STEP sd ON sd.plan_no = p.plan_no AND sd.step_type = 28 JOIN T_STEP sb ON sb.plan_no = p.plan_no AND sb.step_type = 29)
I've seen issues with emailed notes showing blank in Excel any time there's a /n new line in the note, but never really had to figure out how to solve for that because flipped to pdf.
Would a CSV perhaps not have that problem?
Unfortunately, it happens with CSV output as well.
This assumes the data is actually there and it is not an issue in the query. Could you get the output as an XML document? If so, you could save it, then use Excel to open the XML document using Data - Get Data - From File - From XML.You can then navigate to the data, click Transform, and it will open the Power Query window.You can then change/correct the datatypes. For example, the NScan Scan string should be text instead of a decimal number.
After making some changes, you can load it. To see what data is there.I do this relatively often whenever we have offline NScans. This is the only way I can get the correct data off of them when there is an error when uploading the offline scans.