Search this forum:
Search
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.
Page 1 of 1012345 > >>
Topics
 Replies
 Views
 Last Post
10 Replies and 10299 Views Information for acactivity    10299  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...
10 10299
by  Ruma MalhotraJump to last post
01/30/2009 11:49 AM
1 Replies and 18295 Views Loading inside Lawson Portal    18295  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.
1 18295
by  John HenleyJump to last post
01/30/2008 12:47 PM
0 Replies and 741 Views Language Translator  741  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
0 741
09/09/2020 5:39 PM
0 Replies and 1395 Views Create Smart Note to capture PR116 job  1395  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
0 1395
05/22/2020 11:58 AM
1 Replies and 5233 Views Infoset Query String errors out  5233  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...
1 5233
by  thummel1Jump to last post
08/21/2019 4:50 PM
7 Replies and 2679 Views Infoset as Attachment?  2679  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
7 2679
by  Dave CurtisJump to last post
07/09/2019 12:58 PM
0 Replies and 867 Views Smart notes to Mobile devices  867  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...
0 867
07/08/2019 2:47 PM
1 Replies and 1139 Views Header row not lining up in SN email  1139  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
1 1139
by  Dave CurtisJump to last post
05/08/2019 3:34 PM
0 Replies and 956 Views Pending Action Reasons Table Name TM  956  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...
0 956
02/26/2019 3:43 PM
6 Replies and 10878 Views Formatting of Blank Dates in Smart Notification  10878  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...
6 10878
by  thummel1Jump to last post
02/07/2018 11:03 AM
4 Replies and 4086 Views Align Columns  4086  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
4 4086
by  RandyJump to last post
12/13/2017 2:52 PM
2 Replies and 4431 Views Deliver LBI report in Smart Note  4431  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
2 4431
by  Mark PetereitJump to last post
11/01/2017 6:54 AM
0 Replies and 1241 Views Changing ownership of Smart Notes  1241  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...
0 1241
07/17/2017 10:57 AM
0 Replies and 1252 Views Migrating Data Sources  1252  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).
0 1252
05/24/2017 12:11 PM
0 Replies and 1277 Views Confirmation of Delivery Device  1277  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!
0 1277
04/18/2017 4:33 PM
0 Replies and 1190 Views CSV as Data Source for SN  1190  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...
0 1190
03/20/2017 10:41 AM
1 Replies and 4291 Views Stop Smart Note when no Data  4291  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,
1 4291
by  SaraPJump to last post
11/18/2016 11:59 AM
0 Replies and 2195 Views Template and Smart Notes  2195  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...
0 2195
09/15/2016 10:35 AM
0 Replies and 1514 Views Excel as a Source  1514  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!
0 1514
09/07/2016 10:50 AM
0 Replies and 1420 Views Define Info Set Issue  1420  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 ...
0 1420
09/06/2016 12:47 PM
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.
Page 1 of 1012345 > >>


RSS Feed Available