Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Scheduled report to be emailed to a directory instead of an email device ?
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
chaoticist
Past 24 Hours:
2
Prev. 24 Hours:
0
Overall:
5185
People Online:
Visitors:
250
Members:
0
Total:
250
Online Now:
New Topics
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Infor ION
ION vs IPA
2/29/2024 1:24 AM
We had a person new to Lawson and Infor go to Info
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Scheduled report to be emailed to a directory instead of an email device ?
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Ruma Malhotra
Veteran Member
Posts: 412
10/7/2011 12:23 PM
I would like to find out whetherwe can email a report to a directory instead of an email device ? Can this be done in LBI ?
We have a report that is scheduled manually every day to refresh. This report needs to be imported to a tool used for budgeting. Can I set a report to refresh on a schedule and then email the scheduled report to go to a directory instead of an email device ?
Matthew Nye
Veteran Member
Posts: 514
10/7/2011 12:44 PM
I think this makes this question the most popular question on this board.
https://www.lawsonguru.co...ant-server-location/
one other way i thought of that i didnt mention in that thread is if you set up a virtual printer that prints to a directory. this still wont let you identify what is in the report but youd at least have the report in the directory. Additionally, you could create one virtual printer for each bursted iteration and in this way be able to save each report to its own directory. of course this would mean youd probably need to maintain hundreds of virtual printers.
Ruma Malhotra
Veteran Member
Posts: 412
10/7/2011 1:31 PM
Hi Matt,
What is the name of the application the 3rd party used?
Also Joe has written about the query he uses to read the LBi tables, But I do know that from LBI version 9.0.2.2 to 9.0.4.1 there was a significant change and some of my queries I wrote on LBI 9.0.2.2 did not work on 9.0.4.1 so I am not in favor of ggoing down the path of writing queries from LBI tables.
Matthew Nye
Veteran Member
Posts: 514
10/7/2011 1:40 PM
This is just a theory that I havent had a chance to put into practice. You could start with freeware such as
http://download.cnet.com/...2079_4-10228474.html
before committing to a more robust solution.
Im not sure about the table query route. Never explored that myself.
Sam Simpson
Veteran Member
Posts: 239
10/7/2011 2:33 PM
Ruma, regarding your original query you can use FTP to send files or report to any directory, network shared directories or even the outside world. This is a common practice.
Ruma Malhotra
Veteran Member
Posts: 412
10/7/2011 2:46 PM
Sam, Thanks for the reply. The answer is not so simple as FTP. The report that is refreshed every day by reporting services needs to be picked up by an interface engine that sends it to another tool. The location where the refreshed file is stored is on a location on the LBI server. Not everyone has access to this directory and in most places this is very secure with very limited access to other users or even other interface tools. The simplest would be to ouput the refreshed file to a location which is easy for an interface engine to pick up. FTP would have worked for any file that is static but in this case the output is more complicated, so a solution like FTP will not work.
Ruma Malhotra
Veteran Member
Posts: 412
10/7/2011 2:55 PM
Hi Matt, I need the ouput to be especially in a csv format or xls format and cannot have it in a pdf format. I will try the link that you posted and see what it does.
LBI email functionality has printer devices but according to Lawson the output can only be PDF otherwise I was planning to use a printer device setup to output it to a tricked printer directory, but now that solution will not work since, it can only output a PDF and not a csv.
Greg Moeller
Veteran Member
Posts: 1498
10/7/2011 2:59 PM
Ruma: You could always refer to the schema diagrams included in the ERP section of this site to figure out what has changed, or at least how to modify your queries to make them functional again... I'm with you in the 'not in favor of' comment, but sometimes it's necessary.
Ruma Malhotra
Veteran Member
Posts: 412
10/7/2011 3:10 PM
Greg, I completely agree with you but I do not want to be in constant woner mode whether the query I built will break with next version upgrade of LBI so do I want to fix this with every version upgrade break. I want the solution to be robust and in place, without having it to constatnly change it.
Greg Moeller
Veteran Member
Posts: 1498
10/7/2011 3:15 PM
Understand! And am completely with you on the 'don't want to fix it with every upgrade' deal!!
Sam Simpson
Veteran Member
Posts: 239
10/7/2011 3:17 PM
Ruma, Sorry that I'm not straightforward about my mention of FTP. Sure you can use ftp or secured ftp to just about anything. We use a third party interface engine called Axway (very expensive) to pickup and delivery any kind of files to just about anywhere (This include LBI, cloverleaf,Epic,cerner Banks, States etc). We use different protocols for different types of delivery like AS2, SFTP, FTPS etc. So like your query, we have a lots of pickup from lbi and delivers to just about any directories.
Ben Coonfield
Veteran Member
Posts: 146
10/7/2011 6:23 PM
LBI can email XLS files, not just PDF. I don't do that any more but I used to do so and it was working fine.
[quote]
Posted By Ruma Malhotra on 10/07/2011 10:55 AM
LBI email functionality has printer devices but according to Lawson the output can only be PDF otherwise I was planning to use a printer device setup to output it to a tricked printer directory, but now that solution will not work since, it can only output a PDF and not a csv.
[/quote]
You are not authorized to post a reply.