LawsonGuru.com - LawsonGuru.com Forums - Performance Management -

Name	Points
Greg Moeller	4035
David Williams	3325
JonA	3199
Kat V	2674
Woozy	1973
Jimmy Chiu	1879
Margie Gyurisin	1434
Kwane McNeal	1410
Roger French	1302
mark.cook	1244

Forums
Search Forum
Advanced SearchTopicsPosts

Search this forum:

To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.

Topics

Replies

Views

Last Post

10 Replies and 10104 Views Information for acactivity 10104 10 Started by Ruma Malhotra I am trying to create a smart note for activity management that notifies a user whenever a new activity in the project and activity management system is created. Looking at the ERDs on this site for activity management, there is a table acactivity that has all activity information for each activity created in the system. Looking at the technical documentation for this table there is a field that says acv_date_created which gives the date the activity was created in the system. However whe...

10104

by Ruma Malhotra

01/30/2009 11:49 AM

1 Replies and 18101 Views Loading inside Lawson Portal 18101 1 Started by Deleted User I have Smart Notes sending out emails to employees to fix various issues. In these smart Notes I have included a link to the Lawson Employee Self Service page they need to use. However it will just pull up the page directly. I would like it to load the page inside the Lawson portal. Is there a way to do this I was hoping there would be something like http://LawsonServer/lawson/portal/redirect=lawson/xhrnet/some_page.htm Thanks.

18101

by John Henley

01/30/2008 12:47 PM

0 Replies and 507 Views Language Translator 507 0 Started by thummel1 In certain smart notes we need to offer the option for employees to translate the message in the smart smart note to a different language. Has anyone included a language translation option into any of their smart notes

507

09/09/2020 5:39 PM

0 Replies and 1223 Views Create Smart Note to capture PR116 job 1223 0 Started by thummel1 I am attempting to capture all pay records updated via a PR116 and deliver a Smart Note to employees to confirm they have had a scale increase. Is there a way to isolate for only the records updated via a PR116 I was hoping there is a table that can intercept the data before PR116 is processed, capture the date after PR116 is processed, but be able to isolate for only those records that tie to that PR116. Thoughts

1223

05/22/2020 11:58 AM

1 Replies and 4159 Views Infoset Query String errors out 4159 1 Started by thummel1 I have an SQL Statement that successfully runs in SQL Oracle, but when I add it as an Info set in the Smart Notification tool I receive the following error message: 'Error: ORA-01756: quoted string not properly terminated'. I have double quotes around all my column headers. I also have single quotes around any strings that are part of case statements. (e.g. case when x = 'ABC' then 'Pass' else 'Fail' end as 'Test') My SQL is almost 2500 rows, with very complex case statements. Some strings...

4159

by thummel1

08/21/2019 4:50 PM

7 Replies and 2443 Views Infoset as Attachment? 2443 7 Started by thummel1 Hi, we are on LBI V10. I am looking for a creative way that will allow data to be sent as an email attachment in a smart notification outside of the organization. Ideally, I'd like to convert the data generated from an Info set to an Excel or CSV document, include it in the notification as an attachment versus in the body of the email, and deliver to the recipient. All creative ideas are welcome, thanks, Tania H

2443

by Dave Curtis

07/09/2019 12:58 PM

0 Replies and 750 Views Smart notes to Mobile devices 750 0 Started by thummel1 A law recently went into effect requiring new employees receive certain information on their first day of employment as well as confirmation of receipt of this information. For existing employees, they must receive information 'in advance' of the change, although no confirmation of receipt is required. Ideally we would like to leverage functionality within Lawson to deliver this information electronically, and for the new employees, build in the functionality to allow them to respond electro...

750

07/08/2019 2:47 PM

1 Replies and 965 Views Header row not lining up in SN email 965 1 Started by texasInstruments I am trying to send a simple email with changes/deletes. I have the process working now but for some reason even when I am not using a Template I am still seeing the data come over in a table that does not have header/data lining up. When I send the email as plain text, I can see the html tags....how do I just get the header and data in alignment in an email

965

by Dave Curtis

05/08/2019 3:34 PM

0 Replies and 855 Views Pending Action Reasons Table Name TM 855 0 Started by thummel1 I am creating a Smart Note that points to Talent Management that will deliver to any employee who is terminating from the organization. We would like to exclude pending terminations where the reason for terminating is involuntary. My understanding is that the S_EMPL table stores the pending actions; however, this table does not appear to store the pending action reasons tied to the action. What is the name of the table that stores pending action reason codes that tie back to the pending actio...

855

02/26/2019 3:43 PM

6 Replies and 10674 Views Formatting of Blank Dates in Smart Notification 10674 6 Started by Kay Hamill I am new to Smart Notification and am writing a query that returns a date field where some of the dates are not populated.&160; I am using a JDBC connection against an Oracle 10 database. The records with the blank dates are returned to the infoset as 1/1/1700.&160; I know when I run the query directly in SQLPlus, that tool returns the date as 1/1/2000, but I know that in Lawson the date is unpopulated. When I write the Notification, I see the 1/1/1700 populating there as well.&160; Is ther...

10674

by thummel1

02/07/2018 11:03 AM

4 Replies and 3899 Views Align Columns 3899 4 Started by Randy Can't seem to get the syntax right to align the columns in SN. Admin manual say's it should look like this for column 1. Not working. colopt1|align=center&colopt8=no

3899

by Randy

12/13/2017 2:52 PM

2 Replies and 4254 Views Deliver LBI report in Smart Note 4254 2 Started by thummel1 Hello, is it possible to deliver LBI reports in a designated format (e.g. Excel, PDF) as an attachment in a Smart Note The goal of this would be to eliminate a step where certain staff are tasked with running an LBI report, exporting, saving, and emailing to other customers within the organization that do not have LBI security access. Just wondering if Smart Notes have this type of functionality

4254

by Mark Petereit

11/01/2017 6:54 AM

0 Replies and 1165 Views Changing ownership of Smart Notes 1165 0 Started by thummel1 We recently upgraded to V10. I was tasked with migrating all smart notes to V10. In the process, I became the 'owner' of all smart notes. My colleagues can no longer see any Notifications. In some cases, I have full editing rights of other's notifications, and in other cases I do not have editing rights, and the original publisher cannot even see them, thus no one has editing access to some of these notifications. We have instructions that explains how to change ownership of notifications, w...

1165

07/17/2017 10:57 AM

0 Replies and 1167 Views Migrating Data Sources 1167 0 Started by thummel1 Hi, is there an easy way to tell if when I created a Smart Note Solution Pack, if I accidentally did not uncheck 'Include Data Source Details' under Data Source options I am wondering if that detail would reside in any of the XML documents that are saved in the solution pack and if so, how do I find that (since I am not an expert at XML language).

1167

05/24/2017 12:11 PM

0 Replies and 1182 Views Confirmation of Delivery Device 1182 0 Started by thummel1 Hello, I have an email I set up as a delivery device for Smart Notes; however, the email confirmation is not being delivered to the recipient. We noticed the email address if 48 characters. Does anyone know if there is a character limit when delivering Smart Notes to customers Thanks!

1182

04/18/2017 4:33 PM

0 Replies and 1108 Views CSV as Data Source for SN 1108 0 Started by thummel1 Hello, looking to use a CSV file as a data source for smart notes. The SN would need to look for null values in a string field. Eventually, there may be more conditions to look for (e.g. Column 1 is null, or, Column 2 = Y and Column 3 = No). Is this possible conceptually I was able to set up a CSV file as a data source, but am stuck here and have several questions such as: When I update the Info Set it returns an 'errors' message, but I can still preview the data Do I need to create a measu...

1108

03/20/2017 10:41 AM

1 Replies and 4121 Views Stop Smart Note when no Data 4121 1 Started by thummel1 Hi, is there a way to stop a Smart Note from emailing to the Device if the Info Set did not return any data THE Smart Note is set to generate 'When Data is Updated' in the Delivery options The report is scheduled to run daily, but the end user does not want to receive a notification when no records are present in the Info Set. Thank you,

4121

by SaraP

11/18/2016 11:59 AM

0 Replies and 2092 Views Template and Smart Notes 2092 0 Started by thummel1 Hi, I am on Lawson version 9.0.1. We have a Smart Note that gives us a list of individuals each day. The Smart Note is the only way we have to get at the new 'keys' that are added to this table each day (PERSACTION), We need the data for each individual to populate onto a form that we have designed. The form was designed in MS Word. Is it possible to have this MS Word form(or it's 'look') loaded as a template LBI, and add the data for each data field in the corresponding 'spot' on the form, so t...

2092

09/15/2016 10:35 AM

0 Replies and 1419 Views Excel as a Source 1419 0 Started by thummel1 Is it possible to use an Excel spreadsheet as a data source for Smart Notes We have some processes managed this way and we've been discussing ways to send alerts to managers that appear on the spreadsheet when certain conditions are met. A Smart Notification would be a great way to deliver the message. Thanks!

1419

09/07/2016 10:50 AM

0 Replies and 1328 Views Define Info Set Issue 1328 0 Started by thummel1 I am building a Smart Note to generate to managers. The SQL executes in SQL Developer. Form there I copy/paste the SQL into the Info Set in 'Step 1'. When I advance to Step 2 of the Info Set setup, when I click on the 'Auto-Create' option, nothing generates. I have manually added each column and saved the meta data successfully. When I 'update' the Info set, it says it returns 1 record (And should be appx 13 as SQL Developer and the 'preview' displayed) but when I preview the 'sample' after the ...

1328

09/06/2016 12:47 PM

2 Replies and 3872 Views Pictures within SmartNote changing 3872 2 Started by thummel1 I have a Smart Note that delivers a letter in the body of the email, that contains links to various places or videos on our intranet. The links in some cases are nice visual pictures to click on. In some cases, some customers have said that the picture doesn't look like a picture; instead it looks like a funky icon with an x in a small white box. The link still works, it is just visually unappealing. I check a few of the Outlook settings and the Windows version and service pack of one recipi...

3872

by thummel1

08/11/2016 1:41 PM

2 Replies and 4172 Views Smart Note Delivered Inventory 4172 2 Started by thummel1 Hi, Is there a way to easily extract a list of all the delivered Smart Notes The purpose is to be able to identify possible issues with delivery from time to time, but also to understand Smart Note volume and activity. The only option I've found is to go to Delivered Alert History and sift through page after page. I've been doing a copy/paste into Excel so I can do further analysis, but is there a way to export this list instead Thank you!

4172

by Greg Moeller

07/22/2016 1:17 PM

4 Replies and 4415 Views Help deciphering cron_expression for SN 4415 4 Started by Greg Moeller Has anyone had any luck deciphering the cron_expression field in the QRTZ_CRON_TRIGGERS table For example: I have 10 0 9 * 6 * I know that this notification is scheduled for 9:00 M-F I get the 2nd and 3rd fields, but what do the other fields mean

4415

by Greg Moeller

05/03/2016 9:35 AM

4 Replies and 7507 Views Application Links 7507 4 Started by Robby Do you have some time to help a 'rookie' I've built lots of Smart Notes, but have never incorporated an application link. Let's say I build a simple notification based on HR11 information and I want the Details link to take the recipient to HR11, already inquired on the company/employee in the row from the infoset. When I build the infoset, and get to step 3 adding an application link, there are 4 items to add, Name (just create a name for the link), Class (URL), Tag -this is the major par...

7507

by brainet

04/28/2016 1:21 PM

3 Replies and 4513 Views Reporting from LBI Tables 4513 3 Started by Robby I've created 2 listings reports, one lists all our InfoSets and the other lists all our Notifications (Alerts). I've looked everywhere in the LBI tables and can't seem to find where I can link these 2 lists I would have thought there would be some data (such as 'metadata id') in the notification data fields that would tell me which InfoSet is being used by a Notification (Alert). Has anyone figured this out

4513

by Greg Moeller

04/25/2016 7:25 PM

3 Replies and 4650 Views Duplicate Row Info Set 4650 3 Started by thummel1 Greetings, I have an Info Set that is designed to deliver a Smart Notification to managers when employees are due for various required exams. It has Employee ID, Exam Type, Due Date and manager email. There is one employee that has 2 unique Exam Types due on the same day for the same manager. When I update the info set, the Info Set ignores attempt to create a duplicate record, which is excluding one of the Exam Types for this one employee, but this is clearly not a duplicate record becasue ...

4650

by thummel1

01/22/2016 9:38 AM

6 Replies and 5112 Views Two recipients for a single SmartNote email 5112 6 Started by Steve Erdman I frequently hear the complaint, 'I didn't get that SmartNote'. Sure, I can go into the delivered history and produce a screen print of which SmartNotes were sent, the dates and the recipient's email address, but I cannot view the *content* of what was sent (which would also be great if anyone knows of a way to do that), nor can I say that the email was actually *delivered*. Sure, I can use a UNION query in the Infoset and produce two separate rows and two separate emails with the same content...

5112

by Steve Erdman

01/05/2016 2:05 PM

0 Replies and 1706 Views Schedule is missing 1706 0 Started by thummel1 Hi all, I have 3 schedules set up in Schedule Administration that cannot be viewed for editing or deleting. I know they are set up because when I attempt to add another one with the same name I receive a message that says 'A schedule with the same name already exists'. Has anyone experienced this before and if so, how did you remedy I was wondering if there was a limit to the number of schedules that appear on a page, as I do have many, but there is not a 'page 2' option to view...

1706

11/16/2015 2:20 PM

0 Replies and 1913 Views XML Smart Note 1913 0 Started by thummel1 Hi, I am looking to build a Smart Note where the data would need to be converted to an XML format. I saw there are a couple XML options when I go to Notifications, and click on 'Related Info', then go to 'Formatting Template'. There is: XML via HTTP XML via SMTP Has anyone formatted a Smart Note in XML format before and if so, how has that worked for you Curious to know if there are any setup tips I should be aware of if attempting to set up a Smart Note this way Thank you,

1913

09/25/2015 2:53 PM

3 Replies and 5020 Views Info Set Error 5020 3 Started by thummel1 Hi, I built a query that contains a sub-query in SQL Developer. The query executes just fine in SQL Developer. When I paste this SQL into my Info Set in LBI TEST, I get this screen that prompts that says 'enter parameter values' and contains multiple rows of the data fields that are in my headers. I don't have any parameters build into my SQL so I am not sure what in my SQL could trigger this message prompt. I tried to attached a word doc of the error as well as Any suggestions are appre...

5020

by thummel1

08/28/2015 11:44 AM

0 Replies and 1988 Views Run weekly, compare annually 1988 0 Started by thummel1 Hi, I recently learned that a Smart Note we have set up to run on a weekly schedule to look for new keys in the HR07 table is not being used. This is because there is a lot of in and out maintenance that happens in this table. For example, an employee is added to this table on a temporary basis to help cover while a manager is out of the office for various reason, or perhaps to cover because a manager has left. This has been causing employees to re-appear because the Smart Note sees them...

1988

08/12/2015 9:57 AM

1 Replies and 4525 Views Setting Default Delivery Device after User Device Import 4525 1 Started by Matt Gordon I have successfully imported user devices and they show up under Manage Content > Devices but I do not know how to set the device as the default for the user. I have used the group subscribe and it works to add the subscriber but only those that have set their default receive the notification. On the others, if I have them log in, their default device is not set to anything. Is there a way to force these imported devices to be the default from the Admin perspective

4525

by Matt Gordon

07/14/2015 10:52 AM

0 Replies and 1772 Views Future Dated Scheduled 1772 0 Started by thummel1 I recall scheduling a Smart Note a few weeks ago to update and process effective 6/26, but now I do not see it in the Schedule Editor, making me wonder if I didn't schedule it after all But when I attempt to add the schedule again, I get a message that says a schedule already exists with that name, so where could it be Are we unable to view future dated schedules in Smart Notes

1772

06/22/2015 7:00 AM

0 Replies and 1795 Views Info Set and Letter Template? 1795 0 Started by thummel1 Is it possible to have an Info Set included in your Smart Note as well as a letter template We would like to include a letter to each manager, and below it the list of employees they need to see that the Info Set picked up. Thanks!

1795

06/08/2015 12:31 PM

4 Replies and 5310 Views Display numeric as time 5310 4 Started by thummel1 I am working on a smart note. There are 2 numeric columns designed to display in/out punches that will eventually come over in the Smart Note. One column has 'in' punches and the other has 'out' punches. When the table was designed, these columns were not formatted like hh:mm. They were formatted as numbers, no decimals. So the 'in' punch will look like 701 and the 'out' punch will look like 1150 (example). Question: The end user wants to view these numbers like hh:mm. I am trying to think o...

5310

by thummel1

05/28/2015 7:32 AM

6 Replies and 7445 Views Smart Notes Owner 7445 6 Started by George Graham Never had to deal with this until now - can smart notes only be edited (other than through the Content Manager) by one person - the owner It appears that only the person flagged as the smart note owner can edit or change the smart note - so if someone else needed to come in behind they would have to transfer the ownership to themselves and then be able to do the edits. Is this true as far as anyone else had checked

7445

by Ian Abel

05/01/2015 12:55 PM

0 Replies and 1832 Views Smart Notes - Message Box 1832 0 Started by Robby Obviously, I've never used this! Does anyone out there use the message box Can you tell me about it

1832

04/28/2015 9:52 AM

2 Replies and 5231 Views Smart Notes - Scheduler not working 5231 2 Started by Robby Smart Note goes out OK when manually triggered and the scheduler is setup correctly. But, nothing! Scheduler says it went, Delivered Alert History says it didn't, and Activity says nothing. This is a new implementation and there is only one scheduled notification. Can anyone point me in the right direction to find out why this is happening (NOT happening!) Thanks in advance, -Robby

5231

by Lisa

04/07/2015 2:41 PM

2 Replies and 4689 Views Name Changes 4689 2 Started by thummel1 Hi, I have a name change Smart Note that I am testing for functionality. One thing I noticed is that whenever someone's name changes from all capital letters to lowercase letters, or vice versa, it triggers this record to appear on the Smart Note. (We have a process where some groups of individuals need to be listed as all caps and some don't, and sometimes their role changes, thus we'll change them from all capital letters to non and vice versa). How can I stop the Smart Note from capt...

4689

by The.Sam.Groves

03/26/2015 8:15 AM

2 Replies and 4650 Views Smart Note with CSV file 4650 2 Started by brainet I am wanting to setup a Smart Note with a dataset of selected records and a second one that is from a csv file. The csv file will have the different email address I want the SN to go to. How would I tied the two infosets together where each record in the first infoset could be sent to each of the email address in the second infoset I am trying to just change the csv file and not have to remove and add new devices when a person leaves the company.:D

4650

by Dave Curtis

03/21/2015 10:02 AM

3 Replies and 4492 Views Syntax for combining Data Fields 4492 3 Started by thummel1 Hi, I'm looking for the right syntax to combine 2 data fields with a semi-colon as the separator. It's 2 email address fields. I would expect the data field to look like this: bjonescompany.org; spetersoncompany.org I was going to see if I could burst my smart note to these two email addresses from one data field. Before I can try it, I built my SQL in SQL Developer for Oracle and it looks like this: EMPLOYEE_1.EMAIL_ADDRESS ||';'|| EMPLOYEE.EMAIL_ADDRESS as Em...

4492

by Dave Curtis

03/09/2015 7:03 PM

1 Replies and 5594 Views Smart Notes - Resources 5594 1 Started by thummel1 Hi, I need to know if there is a comprehensive User Guide, or some other in-depth guides for Smart Notes out there. I have a book from Lawson, 'Smart Notification User and Administration Guide', but it does not cover nearly the detail I am constantly seeking on a regular basis. Where's a chapter about schedules Where's a list of all the Conditions within a Smart Note and examples of what they do Can a Smart Note send you the 'Before' when comparing two items Can a Smart Note template have a ...

5594

by Denise L.

03/09/2015 2:31 PM

3 Replies and 4873 Views Change Ownership of Smart Note 4873 3 Started by thummel1 Hi, Is there a way to change the ownership of a Smart Note Let's say someone leaves unexpectedly, or there is a shift in role responsibilities, etc...I'd like to know: 1. How someone can change ownership of someone else's Info Set and Smart Note to themselves. 2. How someone can change ownership of their own their Info Set and Smart Note to someone else. I found one forum post called 'Smart Note Owner' . This forum post addressed how to subscribe to another person's Smart Note, but su...

4873

by thummel1

03/09/2015 8:07 AM

1 Replies and 4549 Views Deliver to 2 Email Sources 4549 1 Started by thummel1 Hi, We have a Smart Note that contains a column for the employee's email address and the Manager's email address. Currently, the Smart Note is set up to deliver to the column that the Supervisor's email address resides in. We'd like to also deliver this Smart Note to the employee's email address that is in the employee email address column. Is it possible to burst this Smart Note using 2 different columns fromour Info Set (SUPV_EMAIL, and EMPLOYEE_EMAIL) The goal is to avoid creating 2 ...

4549

by Dave Curtis

03/09/2015 7:49 AM

1 Replies and 4837 Views Smart Note using Excel 4837 1 Started by thummel1 Hi, I am thinking way outside the box here, but I am wondering if Smart Notes can be create using an Excel file as a Data Source Here is why I am asking: HR tracks annual reviews on a spreadsheet before they are uploaded to Lawson. HR goes through this spreadsheet manually, looks for incomplete reviews and reaches out to the manager. If there was a way to deliver a Smart Note to managers based on criteria in the master spreadsheet (e.g. Column labeled 'Review competed' is null), ...

4837

by Dave Curtis

02/17/2015 4:14 PM

1 Replies and 4751 Views Smart Notes - access RM data 4751 1 Started by timbomom Hi.. Need to access RM data for email address within a smart note. Is the RM data stored in a Lawson database in a different schema, if so, which one Thanks in advance, Pat

4751

by Carl.Seay

02/03/2015 1:09 PM

10 Replies and 5203 Views Burst Smart Notes - Not all delivered 5203 10 Started by Robby LBI ver. 10.2.0.0.126 We just went live with this, and the only Smart Note that is supposed to deliver, failed to go to everyone! Here's what I have: 1 InfoSet, approx 12,000 rows of data. To be burst on the supervisors' email address (in the dataset). Some received, some did not (there should have been 244 notifications sent). Is there a setting somewhere that limits this Any thoughts way it would not go to everyone I've already ruled out bad email addresses. Thanks in ad...

5203

by Robby

01/26/2015 10:52 AM

4 Replies and 4437 Views Burst Smart Notes - Not all delivered 4437 4 Started by Robby LBI ver. 10.2.0.0.126 We just went live with this, and the only Smart Note that is supposed to deliver, failed to go to everyone! Here's what I have: 1 InfoSet, approx 12,000 rows of data. To be burst on the supervisors' email address (in the dataset). Some received, some did not (there should have been 244 notifications sent). Is there a setting somewhere that limits this Any thoughts way it would not go to everyone I've already ruled out bad email addresses. Thanks in ad...

4437

by Robby

01/26/2015 9:25 AM

1 Replies and 4642 Views Smart Notes - Scheduler not working 4642 1 Started by Robby Smart Note goes out OK when manually triggered and the scheduler is setup correctly. But, nothing! Scheduler says it went, Delivered Alert History says it didn't, and Activity says nothing. This is a new implementation and there is only one scheduled notification. Can anyone point me in the right direction to find out why this is happening (NOT happening!) Thanks in advance, -Robby

4642

by thummel1

01/22/2015 2:37 PM

3 Replies and 5099 Views Multiple Email Smart Notes to one Device 5099 3 Started by thummel1 Hi, I have a Smart Note that, once moved to Production, will be designed to deliver a letter template to each email address that appears in the info set (It's a notice that will go to supervisors about their new hires; one will deliver as soon as the employee is put in a HIREACTN2 PA Action and their status is A0, and the other is set up to deliver to the supervisor with a different message on the employees first day of employment). But before we start sending these notices, we wanted to tes...

5099

by Dave Curtis

01/08/2015 6:55 PM

1 Replies and 4381 Views Smart Note did not trigger for all records 4381 1 Started by thummel1 Good Morning, I have a Smart Note set up to burst to 2 devices as part of testing. The Info Set contained 6 records, thus, 6 email notifications should have been delivered to each device. When I looked this morning, only 3 notificaitons delivered to each device. I was able to rule out one of the records. (The email address that is being used to trigger the Smart Note was blank.) But there are 2 other records in the Info Set that didn't deliver...I see no reason why a Smart Note would not gen...

4381

by thummel1

01/06/2015 10:33 AM

0 Replies and 1722 Views Smart Notes-Items No Longer in Data 1722 0 Started by thummel1 Good Morning, i have a Smart Note that I've designed with the intention of triggering when an employee is no longer in the N05 or N10 Job Class. In the Smart Note data, I have Employee ID, Employee name, Hire Date, Adjusted Hire Date, Structure Group, LP Plan, LP Balance, Email Address, Accrual End Date and Master End Date. The Smart Note will trigger when any of these items change. This is done by using the condition that says 'Items no longer in data from...' The problem I am h...

1722

12/03/2014 7:46 AM

9 Replies and 5328 Views Date Format in Smart Note 5328 9 Started by thummel1 Hi, Does anyone know what the SQL should be in an infoset when trying to change the format of the birthdat from mm/dd/yyyy format to just mm/dd I am not versed enough in SQL language to change this in my Infoset. Is there a way to change the format within the step called 'Define Info set'. I saw there are options to change the date format to various things, but of course, what I wanted was not an option. Any tips on how to change within SQL or within the Info Set would be appreciated. ...

5328

by thummel1

11/10/2014 8:13 PM

0 Replies and 1744 Views Smart Notes and Letter Templates 1744 0 Started by thummel1 Hi, I am creating a letter template in a Smart Note. This is a letter that will get emailed to the supervisor when a specific condition is met (employee is hired and a HIREACTN1 is processed). The letter will include things such as the supervisor first and last name, employee ID, employee's job title, etc, etc....In the letter template, I must reference the supervisor's first and last name as part of the greeting. I am forgetting how I identify the correct table number, row number, and column nu...

1744

11/05/2014 10:53 AM

2 Replies and 4565 Views Compare 2 Separate Smart Notes? 4565 2 Started by thummel1 Hi, I need to create a Smart Note that will identify individuals who have transferred OUT OF a specific Job Class. I thought I could set up a Smart Note to compare the current run to the prior run. The Smart Note would have to show who the people that are no longer in C05 and C10. Here's what I 'think' I need to do. First, I would create an Infoset with everyone in C05 or C10 Job Class. (FYI, I am not sure what would be the 'Key' for this Infoset. Would it be Job Class if that's all I want to c...

4565

by thummel1

10/27/2014 2:34 PM

1 Replies and 4200 Views Schedules for Smart Notes 4200 1 Started by thummel1 Hi, Can a Smart Note be scheduled to run hourly I see there is an option to select 'Hourly' in the Scheduler; but then the options for hours requires the user to enter a 'From' hour and a 'To' hour. If the Smart Note needs to be run hourly, what should the settings in the schedule be Thanks!

4200

by Dave Curtis

10/22/2014 12:27 PM

0 Replies and 1886 Views Querying multiple infosets - duplicate warning 1886 0 Started by mterlesky Hello - I've created an infoset in order to query the results of two other infosets following the instructions in this post: https://www.lawsonguru.com/Forums/tabid/96/aft/8005/Default.aspx I can run this query against the tables in MS SQL Server Mgmnt Studio with no issues. It returns merged data from the two infosets. select a.COLUMN0,b.COLUMN1,a.COLUMN1,a.COLUMN2,a.COLUMN3 from INFOSET_1086 b, INFOSET_1087 a WHERE a.COLUMN0=b.COLUMN0 When I place this code into my third infose...

1886

09/12/2014 4:10 PM

1 Replies and 4534 Views Hide Smart Notification Name 4534 1 Started by Giulia I have created a notification with a bar chart. I only want the bar chart to appear on the smart notification. I would like to hide the line at the top of the notification that says Smart Notifications : Name of Notification. I have tried to use the different parameter options under Related Info\Option but can't find one that hides that line. I have tried to create a new template that only has &91;values&93; in the body and that still didn't hide it. Any ideas or suggestions would be greatly a...

4534

by Giulia

06/20/2014 2:06 PM

8 Replies and 4705 Views Dupllicate Smart Notes Delivered 4705 8 Started by JeffCozzag In some cases we have scheduled smart notes that will deliver multiple copies to the same subsriber identically timestamped. There is only one scheduled time each day/week/month for each of these updates. This just started in the past two weeks. Delivery history also shows the duplicate deliveries. Any idea how we got here or how to reverse

4705

by JeffCozzag

05/21/2014 10:23 AM

2 Replies and 4089 Views Break out the messages in the Instructions section 4089 2 Started by Alin Anton Does anyone know a way to break out messages within the “Instructions:” section of notification. Is there a special value that we can enter between the lines to move the next section down About this notification: Hello! The Time & Effort reports for the following employees have been released for certifications. Please click on the link below to access…. vs. About this notification: Hello! The Time & Effort reports for the following employees have been released for certifi...

4089

by Anne-Marie

05/19/2014 2:53 PM

0 Replies and 3023 Views Report type notification using “Options” from Related Links and Options 3023 0 Started by Alin Anton Report type notification using “Options” from Related Links and Options I would like to use SNs to send out data output reports to users via Options. Basically, the data should not be displayed in the body of the email rather accessed via Related Links and Options… Options>View as an Excel Spreadsheet. Is that possible I’ve played with the section 4 Related Info/Results to Include by changing it “Do not display” but that will not display the records in the email or excel. Does anyo...

3023

05/16/2014 12:18 PM

1 Replies and 4342 Views Automated means of deleting delivery history 4342 1 Started by Rick McCahan We're looking for a way to automate the deletion of delivery history for Smart Notes. I know about the Delete Delivery History button within Smart Notes Admin, but would prefer to have the system clean up after itself. We're running SN 10.1.0.0. Scheduling a script or using IPA would work Thanks in advance.

4342

by Patrick Dowd

04/21/2014 9:25 AM

3 Replies and 4581 Views Smart Note Not Tripped Error 4581 3 Started by BrianM When in the Smart Notification 'Notifications' tab, I have 3 Smart Notes with a 'Not tripped' message under the value tab. Has anyone ever encountered this before and if so, what did you do to resolve it Thanks

4581

by Matthew Nye

04/15/2014 11:55 AM

0 Replies and 1837 Views Smartnote Excel Attachments 1837 0 Started by Nabil Hi, We recently upgraded LBI and Smartnote Services to 10.3. My question is why are excel attachments always named ATT00001.xls I would think that if they're called the SN name that would be better, just like in Reporting Services. Does anyone have experience in this area Thank you! Nabil

1837

02/28/2014 9:51 AM

1 Replies and 4114 Views Smartnote Template location and logo issue in email 4114 1 Started by Joe O'Toole I had customized our LSN template to include our company logo a number of years ago. We have siince moved to a newer version (9.1) of LBI and I can no longer locate the modified HTML file. Can someone post the folder location that the default template is stored in on the LBI server The second issue is that our logo is getting replaced by a red X in Outlook / Exchange emails. It appears fine on Smartnotes that are sent to printer devices so I know the logo is good and accessible by the system. I...

4114

by Joe O'Toole

02/20/2014 9:18 AM

1 Replies and 4286 Views Smart Note-View Data in each Info Set 4286 1 Started by thummel1 Hi, I have a Smart Note that is scheduled to run once a week, each Wednesday morning. (I have the Info Set scheduled to run at 8am each Wednesday morning, as well as the Smart Note, which then get's delivered to me). It's designed to compare the prior week's Info Set with the current week's info set and only display the records where there are new keys. My Smart Note is including records that, according to another older query we run out of MS Access, is including records that were already o...

4286

by Nabil

02/18/2014 3:20 PM

4 Replies and 4652 Views How not to send empty smart notes 4652 4 Started by TRK I'm trying to configure my smart notes so that an e-mail is only sent in case the infoset actually contains any data. However, I do not have much luck in this endeavor and I hope someone can point me in the right direction. I've configured an infoset, selecting all failed print jobs from the MEC in case there are any. If there are any I want a notification to be sent to the IT Department. I've setup the notification to send an e-mail on update of the infoset to our ITSM system and I've ticke...

4652

by TRK

01/22/2014 8:15 AM

2 Replies and 4476 Views Smart Note sender email address 4476 2 Started by timbomom My question involves the 'sender email address' for a smart note. In our installation, the Smart Notes are being sent with the 'sender email address' of a specific employee. I've been asked to change this email address to that of another employee. So I looked in the documentation. The documentation says to edit the <LBI_HOME>\<SmartNotification_HOME>\conf\DeviceTypes.xml file and change the From attribute to the sender email address to use for the device type. The problem is...

4476

by timbomom

01/20/2014 10:54 PM

4 Replies and 4444 Views Smartnote Bursting on two email fields 4444 4 Started by Nabil Hello, I have a current smartnote sending Employee HR and BN data to the HR Contact at various locations. Now, the HR Contacts want the employee supervisors getting the notification too. My question is, can my current SN that's sending emails to HR Contacts also send them to Supervisors Those are two different fields residing in two different tables. Appreciate the help! Thanks,

4444

by Nabil

01/15/2014 10:26 AM

3 Replies and 4319 Views Subject line of a burst Smart Note 4319 3 Started by timbomom Have a Notification Named 'Benefit Documents Not Submitted - Employee' When I burst on the email address in our Test environment, the subject line is: Burst Test - Benefit Documents Not Submitted - Employee - testmailtestco.org Is there anyway I can get rid of the 'Burst Test' part of the Subject Line Per the documentation, the subject line is supposed to be the Notification name. I am stumped. Thanks, Patricia

4319

by timbomom

01/04/2014 10:56 PM

8 Replies and 5432 Views Smart Notification Bursting when viewed on Dashboard 5432 8 Started by David Williams Is there a way to limit the Company seen by a user in a Notification (based upon an InfoSet with multiple companies) when they view it on the Dashboard. User 1 can only see Company 1000 even when the Note has data for Company 1000, 2000 & 3000. I know I can limit what the user sees if I do Delivery - Bursting but can I apply this logic to when they view the Note from the Dashboard

5432

by David Williams

12/27/2013 1:27 PM

10 Replies and 5297 Views Burst SN on a dashboard? 5297 10 Started by George Graham I've seen a couple of old postings on this with no resolution so thought I would try this again. Looking for a way to burst the notification both in email and on the dashboard using the same notification. I believe I could do this with the same infoset but creating two different notifications - one for the email notificaiton and one for the dashboard, but with the dashboard using a parameter in the query. But I would rather have a single notification to manage. Has anyone been able to get thi...

5297

by Susan Prentice

12/23/2013 1:12 PM

5 Replies and 5315 Views Smart Notification Instruction Manual? 5315 5 Started by thummel1 i am brand new to Smart Notes and am trying to build my very first one. Yay! But, I kind of need instructions. I had training, which was a year ago, and I am finally applying that knowldge, which means I remembered nothing. Wondering if anyone has any type of Smart Note instruction manual or tips in a word doc that could at least get me started I am sure there is a book buried somewhere in my diesk, but I work from home and my desk is 26 miles from here, so I am hoping that somewhere, someone a...

5315

by thummel1

12/03/2013 8:42 AM

0 Replies and 1803 Views Smart Note-Looking for new Keys 1803 0 Started by thummel1 I have a Smart Note set up intended to capture only the supervisors that are newly added to the HR07 screen in Lawson. The Infoset has many data fields, but only one is set up as a 'Key', which is the Employee ID. All the rest are attributes. The Smart Notification is set up to notify me when the data from my Info Set 'Has New Keys'. Also, in Step 4 of my Smart Note (Related Info), I have 'do not display' checked for the 'Data' from my Info Set, and I have 'Default' set for the new Keys in the ...

1803

11/27/2013 9:09 AM

4 Replies and 4250 Views How can I supress the dark blue SmartNote header 4250 4 Started by Jan Hello Each SmartNote that I create with a table includes a dark blue banner located just above the table that displays information about the Infoset the table comes from, plus any filters involved with the SmartNote. We'd like to supress this and I'm guessing an option may exist to do that, but I haven't seen anything documented. Does anyone have any ideas Please see attached.

4250

by Jan

11/05/2013 12:48 PM

0 Replies and 1689 Views EmailMonitorServlet functionality 1689 0 Started by Rick McCahan We occasionally have email SmartNotes that bounce to our catch-all mailbox. We would like to have an automated process monitor this mailbox and notify us that there was a problem. I found mention of the Email Monitor, but cannot find documentation on what it does or how it works beyond that it updates an activity log. Does it delete bounces from the mailbox after it processes them Does it ignore messages that didn't start out as SmartNotes Is what it writes to the activity log sufficien...

1689

09/04/2013 2:51 PM

4 Replies and 5071 Views could not save infosets 5071 4 Started by imjulian When I modify an infoset and try to save it it takes me to a problem report page with the following error message: 'Unable to create the InfoSet Description. Unmatched braces in the pattern.' Any body has ever come across this type of error Thanks

5071

by imjulian

08/22/2013 8:22 AM

12 Replies and 6677 Views Smart Note name change 6677 12 Started by BarbaraS Hi, I'm brand new to Smart Notes and hoping I can get some direction. I have a request from payroll to be notified when an employee's name changes. If I set up a smart note with the 'has new items' condition it does include the name changes, but also includes all new employees which they do not want. How can I show only name changes of existing employees without all of the new hires And assuming there is a way to do that - can I show the old name in addition to the new name Thank you! ...

6677

by thummel1

08/15/2013 11:57 AM

6 Replies and 4387 Views Smart Notification Scheduling Not Working 4387 6 Started by maalimsimo My organization intends to start using SN. I set up my test Infoset and tried to schedule it to no avail. I do receive the report delivered through my e-mail when I hit 'Process'. but the scheduleing part has failed to work for me. The 'Add Job Schedule' page seems simple enough, and for the 'Select Job Function' I selected the 'Update/Process Infoset' to be processed 'Hourly' all week days. I named the Job Schedule name ans hit 'Save'. Nothing happens thereafter,. Has anyone encountered this...

4387

by maalimsimo

07/15/2013 2:54 PM

4 Replies and 4563 Views Is there a way - SN to printer 4563 4 Started by Greg Moeller Instead of delivery to an email address, is there a way to configure a smart notification to deliver to a printer Any help would be appreciated, -Greg

4563

by Greg Moeller

07/12/2013 1:21 PM

2 Replies and 4785 Views Templates and Smart Notes 4785 2 Started by thummel1 I have a smart note. I also have a template I created to pull the data from the smart note into the template, so when it's emailed to the user, they get a nice customized letter with all their data. This worked just fine yesterday. I made a couple changes to the template and BAM. Now the template is not picking up any of the data from the Smart Note! Steps I've taken to diagnose are: I've done a preview of my SQL and it's picking up all required data. I also viewed the Notification 'Sample'...

4785

by thummel1

06/28/2013 7:16 AM

2 Replies and 4443 Views Creating a condition - select from these columns 4443 2 Started by LisaP I am trying to create a SN that will show me new job codes added and job codes inactivated in Lawson, and am having trouble setting up the condition to show me the inactivated job codes. The closest condition I've been able to come up with so far is 'Tell me if: Data from Active Job Codes List has deleted items'. My infoset shows three items: job code, job title, and status, so if any one of the data items changes it will show up in the notification. What I end up with is any job code that ha...

4443

by LisaP

06/18/2013 9:30 AM

2 Replies and 4496 Views Instructions Token 4496 2 Started by Dave Lis I have a smart note and in the instructions token of the notification I want to say, ‘Dear <employee name>’ My infoset has the employee.first and last names but I can’t seem to get them in the instructions. Does anyone know if I'm able to populate the instruction token with variables from an infoset Thank you.

4496

by Dave Lis

06/10/2013 11:22 AM

3 Replies and 4614 Views Add Logo to template? 4614 3 Started by thummel1 Hi, I have a template that's used to display the information from a smart notification. In the template, I have html code to bring in our company logo; however, that logo is saved in one of my file folders. That's not an efficient way of getting the logo into the template. What if I change roles or leave the organization someday Then the path to the logo would become obscolete. My preference would be to save the logo somewhere with the Smart Notification tool, and paste that location in...

4614

by The.Sam.Groves

06/07/2013 12:52 PM

1 Replies and 5148 Views Smartnote formatting in Outlook 2010 5148 1 Started by Jess O. Smartnote tables look fine in IE but don't look that great in Outlook 2010 (since it uses the Word html renderer). You can see in the image below that the table header and the detail rows extend out past the end of the table. Has anyone come up with a way to modify the templates to make smartnotes look a little better in Outlook 2010 If I change the source to have the correct number of columns in the colspan of the header, the table looks fine in Outlook 2010, but I don't believe I can control ...

5148

by Matthew Nye

05/20/2013 9:00 AM

2 Replies and 4428 Views Javascript in SmartNote Template 4428 2 Started by Randall Hi all, We have a user that is looking to have an altered delivery of his SmartNote to include checkboxes and other items that he can use when he prints out records, in addition to being able to print out one record per page (the important piece). I've been able to create a new master template with some Javascript to accomplish most of it, but have hit a problem when trying to recursively run through the records returned. Using the Template Tokens, I can get the number of rows returned wi...

4428

by Randall

04/15/2013 12:55 PM

4 Replies and 4185 Views Usage of Smart Notifications for HR activities/transcations 4185 4 Started by TBonney Please forgive me if you've already seen this same post in the HR forum! (I wanted to post it in both in case appropriate readers were not subscribed to both forums...) Does anyone use Smart Notifications for HR activities We are on Windows platform, running Lawson 9.0.1.x (environment & apps) and are licensed for LBI, but do not presently use Smart Notifications. We'd like to find out how useful other organizations have found Smart Notifications to be, especially with regards to Human Re...

4185

by TBonney

04/12/2013 8:15 AM

1 Replies and 4144 Views Update & Process with Parameter? 4144 1 Started by David Williams Is there a way to pass a parameter within the URL to Update & Process your Smart Notification so only the data matching that parameter (like Company) is processed in the Note

4144

by John Henley

03/11/2013 1:04 PM

2 Replies and 4433 Views Query Syntax 4433 2 Started by B. Smith We found blank entries for users in our CheckLS field. I've pulled the LDAP into SN to build a report to check for this in the future. I need to figure out the syntax for; CheckLS=NULL, or CheckLS <> YES or NO The query language for SN appears to be SQL, but I'm not getting the correct syntax for this. Does anyone have a cheat sheet for query syntax *I checked the SNUG install/admin guide, but there is no guidance* Thanks

4433

by Matthew Nye

02/26/2013 9:49 AM

4 Replies and 4746 Views No Facts to select in wizard 4746 4 Started by B. Smith I created a new Infoset and tested that it is working with the sample button. I get the data fields that I want. I open the notifications wizard, search for my infoset, find my infoset and click the 'Facts' select button. The window pops open and is blank. I had some items bound to a content and some are blank (I'm new to SN). Did I miss a connection setting or a bind somewhere

4746

by B. Smith

02/26/2013 7:43 AM

11 Replies and 6851 Views Configure SN JDBC connection 6851 11 Started by Xin Li Anyone know how to configure JDBC connection to back end Oracle database Do I need to install Oracle JDBC drive on LBII server or not

6851

by Xin Li

01/30/2013 4:06 PM

5 Replies and 4448 Views user id added to SN makes it not work as requested 4448 5 Started by SueS We have smart notes for showing before and after changes to dependent records. The fields on the smart note are employee , relationship, dependent name, ss, birthdate, and disability flag. Now a request was made to add the user id so they could see who changed the record. I can't get the smart notes to work correctly with the addition of the user id field which is defined as an attribute. It is showing up in the before part of the report because the user id has changed - it does no...

4448

by Matthew Nye

01/10/2013 9:09 AM

14 Replies and 6398 Views Just Started Learning Smart Notifications 6398 14 Started by ric9d Hello, I am reading thru the Smart Notification User and Admin guide to learn but its not very intuitive, and Im having a hard time with it. Does any have or know a link for beginners to get us started. A step by step creating one will be great. Thanks!

6398

by ric9d

01/02/2013 9:33 AM

5 Replies and 5241 Views Hide condition text in notification table? 5241 5 Started by George Graham Anyone know a way to hide the condition text at the footer of the table on a smart note I had thought of a 'cheat' way to do it by making the text the same color as the background on a template for the footer but can't find a standard way to do it. Is it possible to create our own class and make that accessible I'm guessing so by putting it in the rendering xml - not that I really want to go down that path yet.

5241

by Tim

12/03/2012 3:31 PM

3 Replies and 4354 Views Smart Notes - Set scheduler to not run if scheduled time has passed 4354 3 Started by SueS When LBI was down and it came back up our Smart Notes started to run even though the time they were scheduled to kick off was earlier in the evening and their scheduled start time had passed by the time LBI was back up. We had a Lawson beeper coverage consultant during this time who said there was a way to set up the smart notes so when the scheduler runs it will not kick off the smart note is the date and time that they were to run has passed. He said there should also be a way that we can ...

4354

by SueS

11/05/2012 11:55 AM

3 Replies and 4659 Views SN Data source wizard shows blank page with java exception 4659 3 Started by SHCR When I click on the edit action in the Smart Notes data source the screen is blank with the yellow triangle with exclamation mark in the browser status bar. I couldn't find any information on this error message on mylawson. Does anyone know how to resolve this error SN Version: 9-0-4-1-131 When I click on the error the message is Webpage error details Message: Access is denied. Line: 10 Char: 3 Code: 0 URI: https://server:9443/lsn/script/IOSCalls.js Message: 'usersAndG...

4659

by SHCR

10/12/2012 11:10 PM

12 Replies and 5487 Views Measures on a Condition 5487 12 Started by Ellen Bats I have build an Infoset for the orderlines. After that I what a Smart Note with the detail information. However the detail information is a condition. In the Smart Note I have also a counting for the total amount by facility. When I look at the result of the Smart Note I saw that the detail information is correct. But when I verify the total amount by facility the result is not correct. The result of the measure is based on the INFOSET and not on the CONDITION. How get I the right results ...

5487

by Ellen Bats

10/01/2012 1:51 AM

0 Replies and 1978 Views Error in scheduling the SN burst 1978 0 Started by Vishnu Priya Hi All, I am trying to schedule a Smart notification that is burst to send the details of the employees. Here is the scenario. Step 1 I have created an infoset Company property New items in Data from Company Properties EMPLOYEE FIRST_NAME LAST_NAME DEPARTMENT SUPERVISOR CODE EMAIL_ADDRESS 257220 HALINA LINCOLN 79101 NS-NSGPMG KEYS arun.mikkilinenisiemens.com Step 2 : I have created a notification property and I have burst the nootification to send th...

1978

09/26/2012 4:47 AM

6 Replies and 5021 Views Smart Notification - Schedule Administration 5021 6 Started by Suresh Hi, Recently my LBI database has been migrated from one server to another. And DBA's have copied SN database to target server. As earlier I had scheduled jobs for few infosets, but now everything seems to be disappeared, In 'Schedule Administration' screen I couldn't view any single scheduled jobs. And also, I tried by creating new Schedule job for the infoset but it seems like it is not been created / saving new scheduling job. Please find the attached screen sh...

5021

by Suresh

09/12/2012 12:26 AM

0 Replies and 1679 Views Difference in data between the mail notification and Preview 1679 0 Started by Vishnu Priya Hi All, I have a task to send Email notification to supervisors about the Company properties a person holds when the Employee changes the department . I have used the has new items comdition. When I make the updates and do the previoew of the notification, it shows all the values selected with the query rather than showing only the new items added. But when I send the Email notification , in the notification I am able to see only the new row that was updated. I am not sure why there is...

1679

09/11/2012 9:23 AM

0 Replies and 1711 Views Sending notification with the old values in table 1711 0 Started by Vishnu Priya Hi, I am new to Lawson Smart notes. Currently I have a task in which if the supervisor of an employee is changed we need to send a notification to the old supervisor of the employee. Here I need the values of the old table after that table has been updated. So please let me know how can we retrieve the old value and use it

1711

09/10/2012 5:46 AM

1 Replies and 4605 Views Bursting on email addresses pulled from Lawson 4605 1 Started by Lacey I have created a JDBC query which pull the email of each employee's supervisor for the last column. In the query preview the addresses pull wonderfully. However, once the infoset is complete the actual infoset pulls nulls for the emaill address column. I have tried with the type for the column as 'email' and as 'string', neither have worked. I would like to burst this notification out by these addresses. Any ideas why they will not pull through

4605

by Matthew Nye

08/31/2012 2:38 PM

1 Replies and 4988 Views Attach a static PDF to a Smart Note email 4988 1 Started by Rick McCahan I have a notification that is sent to new hires as an email. The notification is working correctly with a custom HTML template. Now I'd like to add a static PDF to the email as an attachment, not a link. Being new to Smart Notes, I'm unclear on whether this is possible and how to implement. Emails are read in Outlook or Outlook Web Access. Any hints Step-by-step or an example would be great! Thanks.

4988

by John Henley

08/29/2012 12:08 PM

2 Replies and 5537 Views smart Notes 5537 2 Started by Roger2010 In smart notifications (9.0) I'm trying to figure out how to trigger a notification based on a field value changing from A to B. Basically it is a killed items smart note, when the requisition kill quantity changes from 0 to a number an email should be sent to the requester to inform about the kill quantity. Thanks!

5537

by Roger2010

08/22/2012 3:12 PM

0 Replies and 2081 Views infoset error 2081 0 Started by AJ I am trying to build an infoset that touches multiple tables. I can preview the data of the infoset on the InfoSet Wizard and successfully produce data when going after 1 table and can even preview the data with selection criteria from 2 tables. The following query allows me to preview data: FILE=MAINVDTL&INDEX=MADSET1&FIELD=COMPANY;PO2DNUMBER;PO2DCODE;LINE2DNBR;VENDOR;INVOICE;STATUS;ENTERED2DQTY;MAAOCDTL2EAOC2DCODE;APINVOICE2EINV2DSTATUS;APINVOICE2EDUE2DDATE;POLINE2ECXL2DQTY;PO...

2081

08/10/2012 3:56 PM

9 Replies and 5444 Views Smart Notification - Admin button NOT AVAILABLE 5444 9 Started by Suresh Hi, Recently my LBI database has been migrated from one server to another. And DBA's have copied SN database to target server. While logging into LBI with admin access rights user, I'm not able to view ADMIN button in Smart notification home page and this applies to not only to one user, it applicable for all the users in LBI. Without ADMIN access, we were not able to modify / create any new notification. As my users are getting affected, Could you please help me to solve this issue ...

5444

by Matthew Nye

08/10/2012 1:30 AM

3 Replies and 5047 Views Some smart notes no longer working correctly 5047 3 Started by SueS We moved a new smart note into production and appear to have broken somethng for 5 other smart notes. When the new smart note went into production, these 5 smart notes stopped working correctly. They are huge and looks like it is just dumping the entire infoset without checking if the keys have changed. I can see in the schedule administration that it runs everyday and it is doing an update/process everyday. These 5 smart notes share the same infoset and no other smart notes use this par...

5047

by Matthew Nye

08/06/2012 2:57 PM

3 Replies and 3438 Views SN no sending mail anymore 3438 3 Started by Ellen Bats We works with the user lawson in Smart Notes. All the settings are down for this user. Device type is activated and works great. Today we want to change the mailaddress by the Device Type by this uers. We get the confirmationcode in the mailbox of the user and we confirm the code. We get the message that the confirmation was succesed. We process one INFOSET to look of the new mailaddress was working. However nothing happend. We change the mailadres back to the original one and confirmed this. Pr...

3438

by Ellen Bats

08/06/2012 2:05 AM

2 Replies and 3432 Views Smart Notification - Admin Page access 3432 2 Started by Suresh Hi, For the last 3weeks Smart Notification doesn't showing up 'Admin' button to access admin page and earlier it was working. And also it doesn't applicable for specific users, for all the users (WHO HAS ADMIN RIGHTS) doesn't able to view admin button. Could you please help me to resolve this Smart Notification issue Appreciating quick replies !!! Thanks Suresh

3432

by Suresh

08/02/2012 9:49 AM

0 Replies and 2532 Views Req to PO Smart Note 2532 0 Started by ErikaS Has anyone written a Smart Note that sends an email to the requester once their requisition has been turned into a PO Secondly, has anyone written a Smart Note where the query is based off of an application form instead of a database table I'm having a hard time finding the Req, PO, Requester and Requesters Email on one form or table. Thanks! Erika

2532

06/08/2012 3:51 PM

3 Replies and 2489 Views Burst same row from single infoset to multiple email recipients 2489 3 Started by JoeS Does anyone know of a way to burst the same row from an InfoSet to multiple email recipients Thanks, Joe

2489

by Matthew Nye

06/07/2012 9:52 AM

0 Replies and 1936 Views Problem w/ Application Link 1936 0 Started by Robby Hi-- Very odd issue here - when I preview the notification (by clicking on the notification title while in the system) I see the link and it functions properly. However, when the notification is delivered, the link name is gone and the 'Details' link is in its place. This issue came up only with a new notification being built. When I process the only other notification with a link (this is a new setup), that link appears OK. What do you think

1936

05/30/2012 12:54 PM

0 Replies and 4478 Views Lawson Query Builder - OleDB 4478 0 Started by JonathanGS Hi Everyone, I am trying to write a query for a SmartNote. I have done successfully what I am about to describe. I am composing a query with 2 filters. Each work separately just fine. When I combine them, neither work. Here they are: Date Hired: FILE=EMPLOYEE&FIELD=EMPLOYEE;FULL-NAME;EMAIL-ADDRESS;DATE- HIRED;POSITION.DESCRIPTION;POSITION.BARGAIN- UNIT;DEPARTMENT.NAME&SELECT=DATE-HIRED3E3D&91;date=-DS7 fmt=yyyyMMdd&93; Bargaining-Unit: FILE=EMPLOYEE&FIELD=EMPLOYEE;DATE-HI...

4478

05/18/2012 2:31 PM

6 Replies and 3203 Views masking a ss on a smart note 3203 6 Started by SueS I have a smart note that HR wants to see the 'before' and 'after' of various fields that may get changed on a dependent's record. One of thee fields is the ss. Is there a way to mask the ss so it shows as ***-**-6789 Any advice would be greatly appreciated.

3203

by SueS

05/07/2012 2:56 PM

0 Replies and 2103 Views Using 'Message Box' as delivery device..... 2103 0 Started by Robby The Smart Notifications User Guide is not very explicit on how to use this, and/or how it works (unless I'm missing something). Is anyone using it How does it actually work What advantages/uses do you utilize it for Thanks in advance... -Robby

2103

03/30/2012 9:30 AM

9 Replies and 3137 Views Scheduling SN report 3137 9 Started by Greg Moeller Schedule report showing last run time, next run time, scheduled run time and name of infoset Would really like to be able to associate this with the notifications as well, but would take the infoset scheduling as a start. Anyone have a working example that they'd be willing to share

3137

by Greg Moeller

03/05/2012 9:50 AM

3 Replies and 3375 Views Smart Notification GUID 3375 3 Started by Dennis Amory What's the best way of knowing exactly which Smart Notification (SN) is tied to a dashboard link In other words, If I edit the dashboard link, when I go to the URL text box (under the Main tab), I can see a value like this: FSRemotefsid=SN:SN-Smart Notification:12992&guid=z64db9132:12c9753609c:-7fd3:18a97. How do I reference this GUID back to an actual SN to determine which SN is actually being run when I click on that dashboard link

3375

by Dennis Amory

02/27/2012 2:47 PM

8 Replies and 2998 Views Is it possible Word doc linked to a SN? 2998 8 Started by Greg Moeller Been tasked with linking a word doc to a smart notification. I don't even know if that is possible. Anyone have any pointers Cook-book style instructions

2998

by Robby

02/20/2012 11:15 AM

3 Replies and 2958 Views Smart Notification Stored Procedure 2958 3 Started by Layne I am using a stored procedure, which has a declared variable, which is being contrained on in the where clause of the stored proc. Here is a crude example. Select * from title where token = token I want Smart Notification to prompt me to enter a valid string for this variable. Can I do that with SmartNotes.

2958

by Matthew Nye

02/14/2012 8:34 AM

11 Replies and 4618 Views App Link to Smart Office Forms 4618 11 Started by KJBULLS Does anyone know how to create an Application link to Smart Office forms I know how to do this to go to portal and inquire a specific record for a specific form but I cant get it to work in Smart Office. Can anyone please post an example Thanks for your help KJ

4618

by mark.cook

02/01/2012 10:22 AM

7 Replies and 4685 Views Smart Notifications Data Source Setup Recommendations 4685 7 Started by Michelle Sundermann We are in the process of rolling out Smart Notifications and have a question regarding setting standards for creating infosets. Our question for everyone has to do with the multiple types of data sources you can use within LBI and specifically Smart Notifications. That said, the one that is delivered when LBI is installed is the DME Query which the syntax is quite cumbersome we have found. However , one of the other options that we have been using is JDBC as our data source (which is essential...

4685

by Ruma Malhotra

01/04/2012 12:51 PM

5 Replies and 5684 Views Share a challenging or interesting Smart Note 5684 5 Started by Robby I've built many Smart Notes, primarily for data integrity checks for HR, payroll and benefits. Everything from one as simple as finding all employees who have not taken mandatory training classes, to a notification to the payroll rep that an employee has not yet cashed a paycheck that is approaching 60 days old. What I am asking for in this forum is for my fellow posters to offer-up one or two of their most challenging/interesting Smart Notes. Share the business need that prompted the request...

5684

by Ruma Malhotra

12/05/2011 9:29 AM

2 Replies and 3834 Views Smart Notes 3834 2 Started by Deleted User I'm not sure why the smart note notifaction isn't sending e-mails to the owner. Does anyone has any solutions I can try

3834

by Ruma Malhotra

10/07/2011 8:35 AM

2 Replies and 2193 Views SN returns no data even though I changed the data 2193 2 Started by RachelM I am trying to create a SN that sends an email when a social security number has been changed. I have the InfoSet created; when I try and do preview it clocks out b/c the data set is too large. I'm not sure if that's a problem or not. I set up the notification and when I get to conditions, the 'compare with ...' section is not available. I want it to say 'if SSN has changed, send SN'. I have made the SSN a key and currently have my criteria set to send a SN if any changes to keys occur. ...

2193

by Matthew Nye

09/30/2011 9:02 PM

0 Replies and 2319 Views Transfer data and open portal form via link on SN email 2319 0 Started by tdosal The current smart note I have is notifying users when GM10.2 templates are added for specific employees. Via either the 'details' link on the line item or a custom link I would like to access the GM10.2 portal form with the company, employee, and effective date populated. Can anyone help me accomplish this I am new to smart notes and would really appreciate any help someone can offer. Thank you, Tina Dosal

2319

08/24/2011 1:35 PM

3 Replies and 2352 Views Transfer of Smart Notes from one environment to another 2352 3 Started by Ruma Malhotra Using the solution builder can you transfer notifications from one environment to another. I know you can transfer infosets, devices and templates but not sure of notifications. Does anybosy else have any other ideas as to how to do this without having to rebuild the notifications from scratch when you go to another environment tia.

2352

by Chris Martin

08/23/2011 1:16 PM

2 Replies and 2302 Views Email Delivery Device - Where is the email address stored in database 2302 2 Started by Tim Hi, I have access to query the SQL Server database that holds the meta information for our smart notifications. I am trying to find the table/column that holds the email address of a registered delivery device. Does anyone know the name of the table and column that holds this information I have not had any success in finding it. I thought it might be in the ENPBATREE table. However, I am not seeing the delivery device that I created for myse...

2302

by Tim

08/12/2011 1:14 PM

2 Replies and 2706 Views Open form from link and inquire? 2706 2 Started by George Graham I have a SN with Employee Reviews - and have it linking to PA26. I've got PA26 defined in lawson.xml with company and employee - and the link does open PA26 successfully, but it is not populating the COmpany or Employee fields nor inquiring. I've got those two fields spelled the same way in the infoset - and both defined as key fields. In the application link I'm calling the Forms class with the tag of PA26 (like it is in lawson.xml). Isn't this supposed to work Or do I have to do this as...

2706

by George Graham

07/19/2011 3:43 PM

8 Replies and 2694 Views Link on SN open outside of module? 2694 8 Started by George Graham Have a SN displayed in the dashboard with an infoset that has an application link. The SN is being displayed as the content of a module within the dashboard. When a cell is clicked the app opens, but only contained within the module. Have not been able to find a way to have this open in a new window or outside of the constraints of the module.

2694

by George Graham

07/15/2011 11:53 AM

9 Replies and 2691 Views Release of Journal entries from smart notifications 2691 9 Started by Ruma Malhotra I have created a smart notification for unposted journal entries and would like the user to release them for the email the user receives. However I am getting an error 500 when this action is taking place. Has anybody done this what am I missing

2691

by Ruma Malhotra

05/04/2011 10:17 AM

1 Replies and 2454 Views Application Link M3 in mail 2454 1 Started by Ellen Bats Did somebody have experience with application links for M3 in Smart Notifications when the email is received in the Inbox from Outlook. When the user click on the link M3 nothing happend in M3. The link open an Inter Explorere page and another page. I want when the user click on the link M3 starts the program with we send with the link.

2454

by Matthew Nye

04/07/2011 6:07 AM

9 Replies and 4895 Views DME vs SQL? 4895 9 Started by George Graham Just curious about opinions. Given that you have access to use JDBC data source....DME vs SQL Why

4895

by Greg Moeller

04/06/2011 5:03 PM

13 Replies and 3193 Views Infoset Data? 3193 13 Started by George Graham Anyone know physically where the infoset data is stored Is it a blob in a table and I'm just missing it

3193

by JeffR

03/14/2011 10:10 AM

4 Replies and 2906 Views Change Layout not visible 2906 4 Started by Ellen Bats I have change something in the layout of a smart note. For the Smart Note “Gemuteerde orders na handmatige vrijgave” I added additional text in the instruction box. The changes are made on 08 march. Today I checked of the changes are also visible on the dashboard in Smart Office. For some reason the additional text is not visible on the Dashboard of Smart Office. Did you know what I have done wrong. Because the data is up-to-...

2906

by Ellen Bats

03/11/2011 8:58 AM

8 Replies and 2723 Views SN Scheduler 2723 8 Started by Ellen Bats Since the end of february 2011 we are live with M3. We have build different Smart Notes for our users. For instance we have one Smart Note that burst to different people and the same Smart Note we also used on the dashboard. The Smart Note on the dashboard contains all records and the bursting Smart Note contains only the records which belong to specifically to the field we burst on. We used the Smart Note with a Infoset which we have scheduled. The settings of the scheduler are ...

2723

by Ruma Malhotra

03/10/2011 3:19 PM

0 Replies and 2253 Views User with imported delivery device not receiving smart note 2253 0 Started by Tim Hi All, We have imported a user delivery device for a new user who will be receiving a smart note. The physical delivery device is their email address. After the import, their delivery device is in an “Enabled” status. I “force-subscribed” the new user to the smart note by following the documentation in the user and admin guide and by using the “Group Content Subscription Tool”. I have force-subscribed this notification to other...

2253

03/10/2011 8:37 AM

5 Replies and 2641 Views Dynamic User Filtering of SN on Dashboard? 2641 5 Started by George Graham I am unfamiliar with any way to accomplish this - and I've communicated that I don't believe we can do this - but thought I would ping the gurus to validate. Have a SN on a dashboard - and can successfully filter this based upon the user that is logged in. But by default we will show all items. Assume we have a SN that has a column like Process Level - the desire is to somehow allow the user to put in a value to filter out that PL. I'm not aware of any way to do this....other than creat...

2641

by Matthew Nye

03/02/2011 11:15 AM

5 Replies and 2330 Views Infoset Processing Scheduler 2330 5 Started by George Graham Anyone have any luck with setting up an infoset that refreshes at a smaller interval that one hour I don't think that you can modify the cron expression in the QRTZ_CRON_TRIGGERS table like you can a true cron job. I know I can create something to simply call the url to do the update/process of the infoset. Just wondered if there was a more 'native' way to handle this...

2330

by George Graham

03/01/2011 2:54 PM

5 Replies and 2487 Views Smart Note LDAP query for InfoSet? 2487 5 Started by George Graham Does anyone have a good example they can share of an LDAP query from Lawson's LDAP that was used to build an info set Trying to build a dataset of users and emails to utilize for bursting....All queries I'm trying come back with no data....

2487

by George Graham

02/22/2011 12:55 PM

2 Replies and 2103 Views smart notification condition/calculation help 2103 2 Started by Ruma Malhotra I am trying to build a smart notification using the activity management piece in Lawson, and I was wondering if anybody can think of a better way to do this: My infoset has a budget, a commitment and actual amount. I am supposed to notify a user when the expense spent on a project reaches a threshold value which is 5 of a budget. My expense equals the actual and commitment amount. I have added an calculation column in my sql which is called the remaining amount which...

2103

by Matthew Nye

02/11/2011 3:06 AM

6 Replies and 2506 Views Conditions on plain attributes? 2506 6 Started by George Graham Have an infoset that has data populated for one notification. Would like another notification on the same data, but with a condition (when FIELD=XYZ). But that field is not a measure so it does not show in the available columns when you open the condition tab in the new notification. Instead of having to build a new infoset that is a subset of another infoset - how can we do this

2506

by Giulia

02/02/2011 8:24 AM

11 Replies and 2499 Views Change Order Of Fields In a Notification 2499 11 Started by Ruma Malhotra Is there a way to change the order of fields in a notification after the infoset creates the fields in a certain order without changing the query Thanks in advance.

2499

by Ruma Malhotra

01/26/2011 4:29 PM

0 Replies and 2112 Views Using an Oracle Procedure in Smart Notes 2112 0 Started by John Cunningham Can anyone share the setup for using an oracle stored procedure with Smart Notifications. How is the procedure set up (With a package, returning a cursor like Crystal) What is the syntax of the call on the Smart notes side

2112

12/15/2010 9:59 AM

1 Replies and 2186 Views Historical content for a smart note 2186 1 Started by Ruma Malhotra I have a smart note that has been in production since January of this year and rendered on the dashboard. So this smart note is not delivered to any user but is scheduled to refresh every first of the month on a dashboard and rendered on the dashboard. It essentially behaves like a report. Where can I find the historical instances for this smart note. I would like to publish all the instances every time the smart note refreshed just like the historical instances for a report. Is there a wa...

2186

by Ruma Malhotra

11/02/2010 11:30 AM

3 Replies and 2878 Views Smart Notification Tools Option - Excel ONLY 2878 3 Started by Carl Gifford I would like to include the link on the bottom of the Smart Note that has the option to export to a spreadsheet. I know that this can be done by updating the template to inlcude the &91;tools&93; token; however I ONLY want to include the options View as an Excel Spreadsheet View as an Microsoft Excel spreadsheet with no formatting Is this possible If so how

2878

by Matthew Nye

10/30/2010 2:18 AM

7 Replies and 3650 Views Smart Notifications merged rows and merged columns 3650 7 Started by Glenn Has anyone ever successfully used merged rows or merged columns in the Notification conditions I'm trying to link two infosets on username from two different data sources.

3650

by Matthew Nye

09/30/2010 3:20 PM

10 Replies and 4048 Views Infosets: Status remain Queued 4048 10 Started by Jeroen Hello, this is my first post in this forum, but I haven't been able to find any answers anywhere else. We are pretty new to smartnotes, but have been using them for a while now. Lately all the scheduled infosets have been in the 'queued' status for a few days, and therefore they will not update. The update / process queue status option reveals the queue, but neiter 'queue' nor 'cancel' will change any status (cancelling one will just give a msgbox &160;'Set state for xxxx to 4' but no changes...

4048

by Anne-Marie

09/23/2010 2:40 PM

5 Replies and 2816 Views Using SN for Address Change notification to HR/Payroll 2816 5 Started by TBonney Can anyone advice on how we can use a Smart Notification to HR and/or Payroll when an employee changes their address through ESS We can't rely on the email notification set up in HS07 because we're on Windows so it only gets sent if the user hits the send button. Also, not all our users have email, so it may not even come up for some users. Thank you.

2816

by Nick

09/05/2010 4:16 PM

0 Replies and 2202 Views Restricted DME in Smart Note Data Source? 2202 0 Started by George Graham Using Lawson Security, not LAUA. Have roles that restrict access to certain tables. When using DME data source in InfoSet I can't use a user authentuication that is CHECK LS=Y. How do I enforce security so that users using this data source are restricted to only the tables they should get to - without having to replicate all of that in LAUA

2202

09/02/2010 6:16 PM

3 Replies and 2492 Views LSN Connection to non-Lawson Database 2492 3 Started by Nick I was wondering if anyone had used LSN to pull information from a SQL database outside of Lawson We are looking at creating some notifications when changes occur in our Time and Attendance system, and I have everything ready on that side. I'm unsure about how to set up the JDBC data source in LSN though. Is it possible to do Thanks! Nick

2492

by Nick

08/19/2010 2:02 PM

3 Replies and 2537 Views Smartnote Options Link 2537 3 Started by vc727 We use smartnotes as a push only tool. I create notifications and push them out to management and Human Resources. I am always being asked if they can get the information in a spreadsheet. I know that in the options link at the bottom of all the notifications is an options link which should allow them to expot the note to a spreadsheet. Why am I the only one that this option works for. Every other user has the Options link grey and will not work. Could it have something to do with them not being...

2537

by Matthew Nye

08/11/2010 2:37 PM

1 Replies and 2166 Views Override Smartnotes From email address 2166 1 Started by JohnO I need to send a smart note out and have the from address be different then our standard notes. All notes come from LBIdomain.com. Is there a way to override this so that one specific notification can come from a different email address for example johndomain.com I know you can use device to control who things are sent to but don't seem to see a way to override the sending address, I know I can change the reply to address but will not work for this notification.

2166

by Matthew Nye

08/10/2010 3:30 PM

0 Replies and 2529 Views Selectively import Smart Note and InfoSet in a Solution Pack 2529 0 Started by Shelby We are using some of the Lawson-provided Smart Notes and InfoSets. However, to keep track of the few we are using, we are creating copies in our own 'PeaceHealth' namespace. Creating the solution pack to port Supply Chain to Production was simple because they were the first (and only) Smart Notes and InfoSets in the namespace. However, now that there are copies of the Finanacial Smart Notes and InfoSets in the same namespace, I would like to create a solution pack to move just those four Smart N...

2529

03/31/2010 11:21 AM

3 Replies and 2625 Views Lawson QuickStep Master/Default Template question 2625 3 Started by Shelby In test, at the bottom of the smart note display are two links to export the data as CSV or XLS. In production, those links are missing and a different section (with 'Related Links and Options' and 'General Information') is displayed. Within the Smart Notification - Content Administration Tools I can preview the two templates (Default is embedded into Master) and they show the CSV/HTML links. But when I preview the smart note it shows the 'Related Links' (etc) section. Does anyone have an idea ...

2625

by Shelby

03/24/2010 6:31 PM

8 Replies and 2782 Views Crystal Report on Smart Notifications 2782 8 Started by JeanneS I am trying to create a crystal report based on the LBI database that lists the names of all Smart Notifications along with owner and date created.&160; Can anyone tell me what table I should use&160; Thanks in advance! &160;

2782

by Chris Martin

03/22/2010 1:54 AM

2 Replies and 2537 Views Link to forms From smart note alerts 2537 2 Started by Ruma Malhotra We just completed our upgrade from LBI 9031 to LBI 904. After the upgrade I am testing my application links from the emails generated by smart notes. &160; For some reason these links are not working. It is not recognizing the LBI service even when the service is present. Anybody come across this tia, Ruma.

2537

by Ruma Malhotra

02/09/2010 11:10 AM

5 Replies and 2457 Views Can a Crystal Report be linked to a smart notification? 2457 5 Started by mxg119 Newbie question - Does anyone know how to link to a crystal report from a smartnotification

2457

by mxg119

01/12/2010 8:02 PM

9 Replies and 4282 Views SmartNotes and Active Directory 4282 9 Started by Jon Lunn Hello, Hope you can help. I'm looking ot build a bursting notifcation that&160;bursts to the user who rasied a zero value purchase order in M3. As our M3 username matches the windows log-on name in active directory, is there a way i can link smartnotes to AD to read the username in the infoset, then read the user name and e-mail address in AD. One solution i have is to export the AD user name and e-mails into a database, and create an infoset over that one, then create the brusting notifica...

4282

by Patrick Dowd

11/05/2009 2:12 PM

2 Replies and 2431 Views Adding a calcuation 2431 2 Started by David Williams I need to take annual contributions and divide them by 24 to include in my Notification. Is there a way to do this in the InfoSet or in the Notification

2431

by Chris Martin

11/03/2009 4:11 PM

1 Replies and 2663 Views Smart_Notification_Installation_Validator 2663 1 Started by HD Could someone help me out with this report

2663

by Chris Martin

09/28/2009 9:42 AM

9 Replies and 4495 Views SN Charting parameters and options 4495 9 Started by Nick Does anyone know of a complete listing of the various charting parameters and options for charts in SN&160; I have looked in the Smart Notification User and Admin Guide (Appendix B), and searched the Lawson KB, but I haven't been able to find a comprehensive list. Specifically, I am having trouble finding a way to show the labels for all of the x-axis vales on a&160;horizontal chart. Even some of the seemingly standard options (such as colopt=, which I have finally figured out is what ...

4495

by kflores01

09/03/2009 3:06 PM

2 Replies and 2618 Views Email address of recipient in data of the note 2618 2 Started by JohnO I have an infoset which queries the lawson DB and returns pedning time records from the PRPENDTIME table as well as the employees email address. We then have a smartnote that sends a not the employee when the time has bee approved. The note is snet out based on the condition of having new items and the email address comes from one of the columns in the infoset. Is there a way I can send to the email adress from the infoset without including the email address in the data in the smart note Curren...

2618

by JohnO

08/18/2009 6:46 PM

0 Replies and 3508 Views Smart Notes Templates 3508 0 Started by WRB I am unable to change the Template for a&160;Smart Notes.&160; I've imported my standard set of templates but when I&160;go into Notification 4 to change the Template&160; for&160;a Dashboard Template and preview, nothing changes.&160; No matter what template or option&160;I select it will not change from the default Template.&160; I had this problem a few years ago but forgot how I resolved.&160; I looked at knowledge base but could not find anything.&160;

3508

07/22/2009 10:49 AM

8 Replies and 4211 Views Smart Notes Infoset Update error 4211 8 Started by mark.cook We upgraded last night our LBI server to 9.032. Once completed, I&160;was running through validation and my infosets will not update. I am getting an invalid query message. When I take my selection criteria out to limit the records in the query I can see the results in preview. Does anyone know of syntax changes that would cause this to happen between versions

4211

by mark.cook

07/08/2009 8:27 AM

3 Replies and 3419 Views Querying LDAP 3419 3 Started by Raj Hi, I am trying to create a smart note with infoset that has the user e-mail id on it, but I need to burst the smart note on dashboard also, so I need to quuery LDAP (ADAM), to get the user id. Lawson Security has the e-mail id along with user id on it. How do I query LDAP via smart notes so that I can schedule it to update and also get the user id. Thanks in Advance, Raj.

3419

by Raj

05/18/2009 1:01 PM

2 Replies and 3698 Views APVENMAST Duplicate Tax ID SN 3698 2 Started by Ken Ptak I'm attempting to build a SN&160;that will return vendor information (Vendor Number, Name, Tax_ID, etc) for vendors who have duplicate tax IDs in the APVENMAST&160;table. I&160;have the following JDBC connection Infoset created that returns the Tax_IDs that exist in the APVENMAST&160;more than one time, but I cannot figure out how to pull the Vendor Number, Vendor Name, etc in the same JDBC&160;connection..&160; Any ideas/suggestions SELECT APVENMAST.TAX_ID, Count(APVENMAST.TAX_ID) AS C...

3698

by Greg Moeller

05/01/2009 3:14 PM

5 Replies and 3520 Views Smart Notification For Procurement 3520 5 Started by Ruma Malhotra I am trying to create a smart notification to notify users when a buyers message clears up in lawson. Has anybody created this already Can you tell me which tables and field is updated when procurement clears up a buyer's message. Thanks in advance, Ruma. &160; &160;

3520

by Mike Lamb

01/22/2009 8:57 AM

7 Replies and 6063 Views Smart Notes missing link 6063 7 Started by WRB Current version of LBI is 9.0.2.2.127 (FWS, RS, SN). &160; We restart Tomcat each morning at 4:00 am, at&160; 6:00am &160;we have a Smart Notes emailed via&160;the&160;scheduler. &160; The Smart Notes that is emailed contain links that drills into other Smart Notes. What should happen is the user receives an email they click on the Department Name, sign on to LBI and the second filtered Smart Notes opens.&160; &160; Since we reboot Tomcat each morning, the Smart Notes are emailed o...

6063

by John Henley

08/07/2008 8:34 AM

3 Replies and 3494 Views Smart Notes Datasource to Essbase 3494 3 Started by WRB We are attempting to&160;create Smart Notes using Hyperion Essbase.&160; SN version 9.0.2.2.127 Hyperion Essbase 7.1.3.0 Build2.&160; Our Lawson and LBI are both hosted by Siemens.&160; When I go and set up the information in SN InfoSet, &160;I&160;get a message that the Database can not be found.&160; Does anyone have a SN&160;using Hyperion Essbase working&160; If so, any suggestion

3494

by Matthew Nye

08/07/2008 8:09 AM

5 Replies and 3982 Views Security in Dashboards 3982 5 Started by BillW I have an issue that I hope someone can shed some light on... We have a handful of dashboards active now, mostly for upper management.&160; The next step is to create something for the Sales reps.&160; Ideally, I would like to create a single 'Sales Rep' dashboard that all Sales reps could access.&160; The dilemma is securing that dashboard so they only see their information.&160; I know that I could use DME for Lawson data, but much of the data I need to display is from an ETL process that...

3982

by Matthew Nye

08/05/2008 9:32 AM

6 Replies and 12693 Views Trigger A Java Class from LSN 12693 6 Started by IloveLawson Hi, I am looking a way of triggering a java program during LSN delivering a notification. Do you think it is possible I am trying to setup XML via HTTP type of device, however, I do not have enough info to get it working. Any suggestions thanks. Chiahao

12693

by IloveLawson

07/31/2008 9:57 AM

3 Replies and 5281 Views Smart Note saved to a file 5281 3 Started by Deleted User We have a smart note notification that we would like to dump out onto the web.&160; I can see in Smart Notes where you can select a output of html file.&160; However how would you tell it what the name and directory where you would like the file placed&160; Is it even possible to do this Thanks --JayR

5281

by Matthew Nye

05/06/2008 11:39 AM

11 Replies and 6166 Views Mass Load Multiple email Devices 6166 11 Started by TBonney I know in Reporting Services you can import a csv file to load multiple emails at once. However, I am unable to find any documentation on how to do this in smart notifications. I'd like to be able to send basic smart notifications to all users, but presently, we only have a handful of devices added in Smart Notes. Is anyone aware of a method of adding email devices into smart notifications other than individually Or, can I somehow use those devices that are available within Reporting Services s...

6166

by TBonney

04/09/2008 12:38 PM

1 Replies and 3697 Views Smart Notification: Underlying Technology? 3697 1 Started by debika_sharma What is the underlying technology of smart notifications SQL or COBOL or something else

3697

by Matthew Nye

04/02/2008 12:24 PM

9 Replies and 14502 Views Smart Notification Links 14502 9 Started by BillW I have a question about SN links. I have created a 'Summary' SN, which I have linked to a 'Detail' SN via one of the fields. This works, but the 'Detail' SN opens in a new window. I would like to have it open in a 'Viewer' module on the same dashboard. I understand the 'OnClick' action of the SN's, but there must be another method when trying to open it from another SN. Has anyone been successful in doing this Thanks for any help. Bill

14502

by Matthew Nye

03/28/2008 4:36 PM

5 Replies and 5008 Views LSN JDBC connection fails on LSF9 5008 5 Started by Joe O'Toole We migrated our Smart Notification from our Env 8.03 server to LSF9 but the connection tests for the JDBC data souce fail on the new box (DME connections test ok). We think all the SQL and JDBC settings are correct but the LSN install validator still reports Tomcat for the connection. Aside from moving from LSN 3.X to 9.X the only other fundemental difference is that LSN 9 is being serviced by Websphere while LSN 3 was using Tomcat. Has anyone else run into this or know how to point LSN&160;at ...

5008

by Joe O'Toole

03/28/2008 10:19 AM

7 Replies and 4815 Views Troubleshoot a SN 4815 7 Started by stcyrk I have developed a simple info set, updated.&160; Created a smart notification, few simple calculations (count and multiplication).&160; Hitting the Preview button opens a browser window that returns the standard Page cannot be displayed windows error message.&160; Save smart notification.&160; Click on it and the window opens with header and footer info, but no body.&160; I have tried simplifying the smart notificiation, simplifying the infoset, to no avail.&160; Any suggestions

4815

by Matthew Nye

03/27/2008 2:16 PM

2 Replies and 4466 Views How to Link 2 Infosets Together 4466 2 Started by Ken Ptak I'm trying to create a Smart Note that will list the accounts that exist in the GMDISTRIB that do not have a Record_Type attribute set up on the GL16.2.&160; Not all accounts should have their Record_Type attribute value assigned, only the accounts in the GMDISTRIB. I've broken it down into two queries: 1. The first infoset JDBC query pulls a listing of all of the unique accounts that exist in the GMDISTRIB. SELECT GMDISTRIB.ACCOUNT FROM GMDISTRIB GROUP BY GMDISTRIB.ACCOUNT 2. The second ...

4466

by Ken Ptak

03/13/2008 8:58 AM

2 Replies and 12553 Views upgrading from 3.2 to 9 12553 2 Started by Bob Beverley Do all existing smart notes with their infosets migrate in the upgrade From what I read in the docs they do - I just need someone to verify that this is so. Thanks

12553

by Joe O'Toole

02/22/2008 12:58 PM

6 Replies and 5252 Views TKN Call from Notification link 5252 6 Started by TBonney I have a notification that gets sent to show unmatched items after MA126 is run. It has a link to form MA60.1 on each row. I have added the URL to the tag in the infoset, including the value for &91Company&93 pulled from the row in the notification. Based on information I found by looking through Lawson KB articles, I thought I could string an additional variable to the end to also pull the &91Vendor&93 from the row too. However, it doesn't work. When MA60.1 is displayed, it is only filte...

5252

by TBonney

02/05/2008 11:12 AM

5 Replies and 12759 Views SQL Date Syntax 12759 5 Started by Ken Ptak Hello - I have a query that creates an Infoset using a JDBC connection successfully. I want to limit the records being returned by the Infoset where the PER_END_DATE is after July 1, 2007. I receive the error “Error: ORA-01843: not a valid month” When I try to add the following criteria to the SQL statement: HAVING ((GMDISTRIB.PER_END_DATE)>'07/01/2007') I’ve tried to play with the formatting of the date but I haven’t found the correct format… Any suggestions/ideas ...

12759

by Ken Ptak

11/14/2007 1:24 PM

2 Replies and 11741 Views JDBC Connection 11741 2 Started by Ken Ptak I just started working with SN's last week (please forgive if this question should not be posted). I have a query built in Access 2003 that runs fine, but when I copy the SQL over to the JDBC connection, I keep receiving an error. I believe it's because the SQL syntax is different between the two, but I don't know what those differences are. My main objective is to create a SN that will return all Employees who appear in the GMDISTRIB table but do not appear in the GMEFFORT table. Any ...

11741

by Ken Ptak

11/12/2007 8:06 AM

4 Replies and 13247 Views Executing Stored Procedures via SmartNotes. 13247 4 Started by Deleted User Basically, we have a need to have a Smart Notification execute a stored procedure in addition to sending the email based on a defined query. The stored procedure will be designed to update tables based on the assumtpion that an email was generated and sent. The issue at hand is that we are being told by our technical team that if the notification is executed in a preview mode (i.e., no notifications are actually sent out), that the stored procedure would be executed as well. In effect...

13247

by John Henley

05/08/2007 4:34 PM

1 Replies and 12261 Views Error-Max Wait Time 12261 1 Started by Deleted User Hi, I am using SQL query and when I am defining my infoset, where we need to define columns, I hit autocreate (Step 2), it takes a while, where you see blue bar below your screen progressing and then it finally throws an error: ' Max wait time 300 reached for object parent.frames.submit.document. Not calling function' I even previewed my data before moving to next step. It takes a while for SQL to generate the data since I have a lot of joins in my query, but it fina...

12261

by John Henley

05/02/2007 10:12 PM

2 Replies and 12564 Views Smart Notification Limits? 12564 2 Started by Deleted User I believe there is a limit to the number of records that can be processed on a smart notification. Does anybody know what it is I seem to recall seeing somewhere that it was around 1000.

12564

by Will

02/14/2007 10:42 AM

1 Replies and 11999 Views Unavailable messages in Activity Report 11999 1 Started by Deleted User We are scheduling Smart Notification processing every morning to create and distribute the SNs to addressess in the infoset and to a couple of devices. We always get a couple of records in the Activity Report for document type Notification, and under Document will be, for instance, Unavailable &91ID:661&93 and in the Device column, Unavailable &91ID:656&93, these two values always being in Red. All the SNs seem to get delivered ok, but I am suspicious of these messages. Lawson Support has ha...

11999

by Matthew Nye

08/14/2006 3:21 PM

1 Replies and 13291 Views Template Modif. 13291 1 Started by Deleted User On the template for the Smart Notification, we would like to display a warning message depending on the value of the &91hostname&93 token e.g. printing a warning when it is not a production smart notification. We've tried using Javascript if statements but they do not interpret the value of the &91hostname&93: if &91hostname&93 == 'some host name' is always false. The value of &91hostname&93 prints at the bottom of the template, it just seems like we can't access i...

13291

by John Henley

06/08/2006 10:01 AM

To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.

Forums Performance Management Smart Notification