Solved

Yellow Notes in Aurena

  • 6 December 2019
  • 33 replies
  • 2093 views

Userlevel 4
Badge +6

Hi,

Does Aurena support the yellow notes, or are these only available in Enterprise Explorer?

 

Thanks in advance,

Sindre Tellevik

icon

Best answer by domze 9 October 2020, 17:05

View original

33 replies

Userlevel 4
Badge +7

Hi Asanka,

Great work this could save us a lot of time, I work with Linda in technical and I tried to run the script.

When I run in PLSQL I get clob_to_blob not declaired:

 

    ifsapp.edm_file_storage_api.write_blob_data(objversion_,
                                                objid_,
                                                clob_to_blob(rec.text));

 

Am I doing something wrong or could this be because we are using 22.2?

 

Thanks,

Alex

Sorry, mate. My bad. Forgot that it indeed needed a custom function deployed prior to work (as there is no standard clob to blob conversion as far as I know). Please deploy the attached before running the script. If you prefer not to create any database objects, you may add this function in the script as well. I’ve dug up this function from the Internet, but works fine for what we’re after.

 

Userlevel 2
Badge +8

Hi Asanka,

Great work this could save us a lot of time, I work with Linda in technical and I tried to run the script.

When I run in PLSQL I get clob_to_blob not declaired:

 

    ifsapp.edm_file_storage_api.write_blob_data(objversion_,
                                                objid_,
                                                clob_to_blob(rec.text));

 

Am I doing something wrong or could this be because we are using 22.2?

 

Thanks,

Alex

Userlevel 6
Badge +13

Thanks, Asanka.  We’ll be rushing off to try it!  

 

Linda

 

Userlevel 4
Badge +7

Would it be possible for R n D to develop  script so we could at least extract the data on Sticky Notes?

 

We use them extensively - things like flagging up an issue on a customer accout so anyone dealing with the customer either in Sales or Finance instantly sees the issue.  Not everyone looks for or has the will to seek out a text box or even look for a checkbox and then have to RMB to Notes to view the comments.  We are making the move from Apps9 to Cloud and it’s one of the things users have mourned the loss of quite heavily.  

 

In Cloud we are thinking of adding a custom notes field and have it conditionally formatted and/or visible if there is any text in the field - to give the users that instant ‘in your face’ notification … as and when conditional formatting makes a return, of course.  

 

In readiness, it would be helpful if we could identify where those sticky notes are and what the text is so we can replicate. 

Hi Linda,

I used the attached script, which will recreate all sticky notes as an rtf (rich text format) document attachment on the original business object (customer orders, suppliers, etc). This way, the users will still be able to access the sticky notes with any of their formatted text in tact (such as bold, italic text). The users need to use the download icon below. The browser settings can be updated so it automatically opens any file of type rtf. While the script worked in Cloud 23R1, feel free to test and mod it in your environment after changing parameters such as the doc class. 

 

Userlevel 6
Badge +13

Would it be possible for R n D to develop  script so we could at least extract the data on Sticky Notes?

 

We use them extensively - things like flagging up an issue on a customer accout so anyone dealing with the customer either in Sales or Finance instantly sees the issue.  Not everyone looks for or has the will to seek out a text box or even look for a checkbox and then have to RMB to Notes to view the comments.  We are making the move from Apps9 to Cloud and it’s one of the things users have mourned the loss of quite heavily.  

 

In Cloud we are thinking of adding a custom notes field and have it conditionally formatted and/or visible if there is any text in the field - to give the users that instant ‘in your face’ notification … as and when conditional formatting makes a return, of course.  

 

In readiness, it would be helpful if we could identify where those sticky notes are and what the text is so we can replicate. 

Userlevel 5
Badge +10

Hi @domze,

Could you please let us know whether there is any internal task/ETA proceeding on this activity?

CC: @Piumi Rubasinghe @Rusiru Dharmadasa 

Best regards
Udara. 

Userlevel 4
Badge +11

I have been asked to elaborate on my previous answer and specifically answer the question

"Are you able to confirm whether the sticky notes are deprecated in future and if so what is the alternative and how to migrate existing sticky notes ?"

The answer is yes, Sticky Notes are deprecated. If Sticky Notes were used to save some additional information connected to an object, then an alternative to use would be Custom Fields. There is currently no alternative to get the same “in your face” feeling that several people seems to be requesting. We have noted the request to find an equivalent solution and it will be considered, but there is no such solution planned for the upcoming release. There is no general migration plan at the moment, but the stored Sticky Notes are not removed so depending on the usage it should be possible to extract needed information during upgrade (or later). 

Hi Dominik,

It's been 1 year since your answer about the sticky notes. Is there any news about it in the meantime? Has a solution been found to implement this in Aurena/Cloud and is there already a timeline for when it will be available?

Userlevel 4
Badge +4

Appreciate the feedback on Sticky Notes.

It’s clear that the easy of use and the “in your face” aspect is key here. We as users of IFS software are humans, and we like to make analogies to the real world and sticky notes are a tangible thing. That was the whole idea behind sticky notes. 

Custom fields or a separate tab or a regular Notes field could seem to serve the same purpose, and as much as it does that from a tech point of view (rich text and images a side) - it doesn’t provide the same user experience.

Note also that Stickies are stored as a connected objected (sort of), so the data is not searchable on the main business object, such as Customer Order or an Invoice. It is also not possible to put the data on a report etc. 

Sticky notes uses RTF (Rich Text Format) which is a (dying) Microsoft format used mostly in Windows - so it is not suitable for cross platform and web use. 

It is clear sticky notes is very important for some of you. It is also clear Sticky Notes is not implemented in IFS Aurena. If sticky notes re-appear in some shape and form it will not be using RTF and user experience would have to adopt to a responsive web layout (not using saved X,Y position) and not be a floating window. But to me it is clear the strength is on the simplicity, the real world yellow sticky note analogy, and the flexible “collaboration” aspect.

Userlevel 6
Badge +13

I have been asked to elaborate on my previous answer and specifically answer the question

"Are you able to confirm whether the sticky notes are deprecated in future and if so what is the alternative and how to migrate existing sticky notes ?"

The answer is yes, Sticky Notes are deprecated. If Sticky Notes were used to save some additional information connected to an object, then an alternative to use would be Custom Fields. There is currently no alternative to get the same “in your face” feeling that several people seems to be requesting. We have noted the request to find an equivalent solution and it will be considered, but there is no such solution planned for the upcoming release. There is no general migration plan at the moment, but the stored Sticky Notes are not removed so depending on the usage it should be possible to extract needed information during upgrade (or later). 

Badge +1

As a customer we use Sticky Notes through the system, as a quick “in your face” notes when someone enters a screen:  customer orders, purchase orders,  purchase requisitions, shop orders, posting proposals, RMA’s, Work Orders.  The loss of the Sticky Note would be a major loss for us.  Please reconsider or come up with an equivalent solution.  

Userlevel 2
Badge +6

Supply Chain

  1. Sticky notes- 
    1. They are important for communicating on Customer orders acting as a pop up message in quickly alert the user if a issue.
    2. Shop Order to communicate internally. They may use Note field but they are not easily noticed.
    3. Obsoleted inventory items to quickly alert someone of the reason why it was obsoleted.

              Everyone would like to have sticky notes in Aurena.  They are a very easy way to communicate information.

Userlevel 7
Badge +30

Hi All,
I have directed a summary of all your concerns and requirement to product development (R&D), and hopefully we will have an update soon from R&D :)
Best Regards,
Yasas

Userlevel 4
Badge +9

Our users heavily use sticky notes in all areas of the application as a means of simple and imediately visible information for communication. it communicates specific information that can not be handled anywhere else in the application.

it also allows to handle pictures or weblinks, which is frequently used.

 

Userlevel 3
Badge +6

We use sticky notes very frequently for communication and collaboration. We have them on almost every Customer Order, Customer, and Project because it shows information very visibly to any person that goes to that record. 

I don’t think it needs to be a STICKY in Aurena, but some functionality needs to exist to serve that purpose. A migration plan also needs to exist to move existing stickies into Aurena.

Userlevel 5
Badge +9

Sticky Notes is the primary driver for our customer service collaboration.  Our users use it every day.  It is the only way they have to insure that key information on a transaction (customer order, purchase order, whatever) is seen.  It’s in your face, you have to move it to see whatever is behind it.  There’s no way someone can say “I didn’t notice it.”  Use has only increased since we moved to working from home.

I just did a quick check in our system.  Since Jan 1, 2020 - we’ve created or modified 25K Yellow Notes on 27 different LUs.  The LUs with the most notes in that time are Customer Order, Purchase Order, and Business Opportunity.  The number is 4K since August 1, 2020.

Userlevel 4
Badge +7

Yellow (Sticy) Notes are extremely important.  They are used to alert the user to special circumstances to the record being displayed on the screen.   The reason that they are important is that the functionality is available on almost all screens of IFS and that they stand out to the user, not a little “Notes” checkbox, but an in your face alert.

What would enhance the functionality:

  1. Have them stored in the database where they can not be easily erased and where they can be retrieved for later use.
  2. Enriched text would be a nice to have, even if it is only limited to the options in this comment box.
Userlevel 4
Badge +8

Sticky notes is a feature that our users use every single day,.  The simplicity and ease of use is hard to beat.  The ability to communicate something temporarily in the context of a specific transaction and have that communication be obvious is a feature that our users would miss a great deal.

While it has limitations, our users understand those limitations and work accordingly.

There’s a reason why the real paper sticky notes are still sold in office supply stores - people buy them and use them and there’s nothing else quite like it.

Userlevel 4
Badge +6

Hi @SORSITEL and @Mark.Feldpausch 

Since we received more questions and feedback on Sticky Notes, we would really appreciate if you also could mention why you appreciate having Sticky (Yellow) Notes and how useful it is, and what exactly are the underlying “problems” that sticky notes solve, so that we could inform R&D on the business critical nature and how useful this feature is to customers :)

Thanks & Best Regards,
Yasas

I think the main value, at least for us, is that they allow easy collaboration/communication of needed action on things like invoices, orders, activities and other areas with high levels of interface/cross-collaboration.
 

They could do the same with Teams, Outlook, Slack, you name it, but nothing beats the simplicity of having it directly in IFS.

 

I like to think of it as Attachments, but for text. You could put attachments on a windows file share, which is kind of like the same as using a separate program for communicating actions.

Userlevel 4
Badge +6

Sticky Notes are currently not in the plan. They do not feel like something that belongs in the current web-based UI, at least not in the form they had previously. Also, we were working from an assumption that Sticky Notes was something that was quite popular in demos, but not really used by customers. From the examples that I’ve heard here it sounds like some customers are using them instead of custom fields to save some additional information. Not that much for collaboration (which was the driving idea behind Sticky Notes).

That’s true.

They’re mostly used for clearly communicating (like “in your face”) what needs to be done/corrected (especially with expense sheets and invoices).

What we care about is that there’s a relatively easy way for our users to do this, without having to use Outlook every time.

 

But yes, I agree that they need to change to be better suited for the web UI.

Userlevel 4
Badge +6

We use sticky notes quite a bit.

They’re stored in RTF format on the database. Converting rich text and images to HTML or plaintext is a nontrivial task.

What we do, is we extract the raw text using a java class, it’s lightning fast, and gets us the content (which is what we care about at least, not the formatting).

Userlevel 7
Badge +30

Hi @SORSITEL and @Mark.Feldpausch 

Since we received more questions and feedback on Sticky Notes, we would really appreciate if you also could mention why you appreciate having Sticky (Yellow) Notes and how useful it is, and what exactly are the underlying “problems” that sticky notes solve, so that we could inform R&D on the business critical nature and how useful this feature is to customers :)

Thanks & Best Regards,
Yasas

Userlevel 7

I have the same experience from when I was a customer. It’s a very nice ‘in your face’ feature to highlight something. We used the extensively in a number of different ways and also had events to automatically create them based on certain criteria for ‘special task’ that were received through an integration. It’s something that we should definitely keep in some shape or form!

Userlevel 5
Badge +9

We use the sticky notes a fair bit for collaboration but also in a digital equivalent of a physical sticky note.

E.g. when raising a purchase req i’ll often leave a sticky note for the procurement team if I really want the specific item (as sometimes they’ll get an alternative product which might not do exactly what I need as well) or for links to suggested suppliers websites if its a non-regular item order.

or

“xxx called yyy and will follow up on zzz” or “spoke to xxx who will yyy” etc.

They’re used pretty heavily here - not saying there’s perhaps not a better way or we couldn’t adapt but just that they are very much used and appreciated. Removal of them would be a big adjustment for our organisation.

Userlevel 7
Badge +18

We use sticky notes quite a bit.

They’re stored in RTF format on the database. Converting rich text and images to HTML or plaintext is a nontrivial task.

Userlevel 6
Badge +13

Sticky Notes are currently not in the plan. They do not feel like something that belongs in the current web-based UI, at least not in the form they had previously. Also, we were working from an assumption that Sticky Notes was something that was quite popular in demos, but not really used by customers. From the examples that I’ve heard here it sounds like some customers are using them instead of custom fields to save some additional information. Not that much for collaboration (which was the driving idea behind Sticky Notes).

Reply