Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

Composer / Dots and commas

  • 1.  Composer / Dots and commas

    Posted 09-17-2018 05:29
    ​Dear community

    I have a solution connected to material domain.
    In the process we are to create a new material either from scratch thru various sharepoint values that are derrived, OR we can choose to download excisting data from SAP, amend it and reupload as a new version OR a new base-product.

    The issue I have is that when I extract data from SAP thru a query-script, all numeric values are retrived with "," (comma) values, EX 123,456

    While when upload information, data needs to be in format with "." (dots), EX 123.456
    How can this be achived, anyone who has a simular issue?
    Since data is being used cross country, we can not ask all the users to have the same personal settings in SAP.


    BR // Henrik

    ------------------------------
    Henrik Axell | Master Data Analyst
    ESSITY Hygiene & Health
    ------------------------------


  • 2.  RE: Composer / Dots and commas

    Employee
    Posted 09-17-2018 09:50
    Hi Henrik,

    Unfortunately, there is no "default locale' setting for numbers. 

    If you wanted to display the number with formatting, that is fine, but if you can pass a version of it to SAP without formatting, that might help.

    It looks like it is a number with decimal places, correct? 
    - If so, you can choose a format that has no commas or dots from the field properties. 
    - Also, you can right click on the field name in the form data tab and make it a whole number.  

    Hope this helps.

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle North America
    ------------------------------



  • 3.  RE: Composer / Dots and commas

    Posted 09-18-2018 03:25

    ​Hello Sigrid and thanks for your reply.

    The specific issue I have is in my solution, the query-script returns 123.456 (dot) on one attribute.
    Then I have a transaction-script that is bind to this but this one needs 123,456 (comma) when pushed to SAP
    Would it then help to change the DATA TYPE from STRING to DECIMALS in field properties
    Wholenumber is not an option since I need to apply decimals

    The feedback I have gotten before is to use a javascript



    ------------------------------
    Henrik Axell | Master Data Analyst
    ESSITY Hygiene & Health
    ------------------------------

    Original Message


  • 4.  RE: Composer / Dots and commas

    Posted 09-18-2018 03:04

    Have you tried changing the defaults in your SAP user profile, to use "." Rather than","?

     

    Kind regards,

     

    Martin Burrage
    Master Data Manager
    CMS Distribution Ltd
    Tel: +44 1423 704716
    Mob: +44 7770 661737
    Email: martin.burrage@cmsdistribution.com
    Web: www.cmsdistribution.com  

    Linked InTwitterYou TubeGoogle Plus


    https://www.cmsdistribution.com/wp-content/uploads/2018/04/email-sig_CMS.jpg

    This e-mail (and any attachment) has been sent from CMS Distribution, registered office in England No. 2214562 VAT No. GB125 4785 05 WEEE Reg No.WE/JB0057TS/PRO.

    Registered in Ireland No. 193425 IE VAT No.IE6593425W GB VAT No. GB894484958
    If you receive it in error, please tell us by return and then delete it from your system; you may not rely on its contents nor copy/disclose it to anyone.
    Opinions, conclusions and statements of intent in this e-mail are those of the sender and will not bind CMS Distribution unless confirmed by an authorised representative independently of this message.

    We do not accept responsibility for viruses; you must scan for these.



    Disclaimer

    The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

    This email has been scanned for viruses and malware, and may have been automatically archived. To find out more about email security, ransomware, anti-malware, spam filtering and archiving solutions from CMS Distribution, either on-premise or in-cloud, please click here.



    ------Original Message------

    ​Dear community

    I have a solution connected to material domain.
    In the process we are to create a new material either from scratch thru various sharepoint values that are derrived, OR we can choose to download excisting data from SAP, amend it and reupload as a new version OR a new base-product.

    The issue I have is that when I extract data from SAP thru a query-script, all numeric values are retrived with "," (comma) values, EX 123,456

    While when upload information, data needs to be in format with "." (dots), EX 123.456
    How can this be achived, anyone who has a simular issue?
    Since data is being used cross country, we can not ask all the users to have the same personal settings in SAP.


    BR // Henrik

    ------------------------------
    Henrik Axell | Master Data Analyst
    ESSITY Hygiene & Health
    ------------------------------


  • 5.  RE: Composer / Dots and commas

    Posted 09-18-2018 08:16

    HI,

     

    I am not sure but it may have to do with the Decimal Notation Defaults in SAP.  Check in SAP to see if your default under System> User Profile> Own Data> Defaults. Here you can change the Decimal Notation to be either commas or dots.

     

    Sent from Mail for Windows 10

     


    This e-mail message and all attachments transmitted with it may contain confidential and proprietary information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, please delete this message from your system and avoid any dissemination, distribution, copying, or any other use of this message or its attachments. If you are not the intended recipient, please notify the sender immediately by electronic mail. 




    ------Original Message------

    ​Dear community

    I have a solution connected to material domain.
    In the process we are to create a new material either from scratch thru various sharepoint values that are derrived, OR we can choose to download excisting data from SAP, amend it and reupload as a new version OR a new base-product.

    The issue I have is that when I extract data from SAP thru a query-script, all numeric values are retrived with "," (comma) values, EX 123,456

    While when upload information, data needs to be in format with "." (dots), EX 123.456
    How can this be achived, anyone who has a simular issue?
    Since data is being used cross country, we can not ask all the users to have the same personal settings in SAP.


    BR // Henrik

    ------------------------------
    Henrik Axell | Master Data Analyst
    ESSITY Hygiene & Health
    ------------------------------


  • 6.  RE: Composer / Dots and commas

    Posted 09-18-2018 09:31
    ​You could transform the data in in excel with a macro prior to loading or use the transform functionality to replace the . with , or vise versa.

    The formula would look like this
    =SUBSTITUTE(D3,".",",")

    Where D3 is the cell containing the data pull from SAP.

    R.

    ------------------------------
    Randall Tupper | senior project analyst
    Kohler Company | [Kohler] | 920-698-7335
    ------------------------------

    Original Message


  • 7.  RE: Composer / Dots and commas

    Posted 09-19-2018 02:47
    ​Martin and Wendy, I belive you both provide the same solution and it is not realistic to do since there are several users (more than 50.000) using the tool and we can not ask them to all change their settings, even thou this might be the answer.

    Randall, this might be a good idea, will test and let you all know.

    Anyone else who creates materials with winshuttle composer and creates a full Unit of meassure-table.
    Any challanges with numeric decimals?

    ------------------------------
    Henrik Axell Master Data Analyst
    Essity Hygiene and Health
    ------------------------------

    Original Message


  • 8.  RE: Composer / Dots and commas

    Posted 09-20-2018 09:00

    Hi, you may want to speak to your SAP Administrator and see if they can change the default for all users from their end. 

     

    Sent from Mail for Windows 10

     


    This e-mail message and all attachments transmitted with it may contain confidential and proprietary information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, please delete this message from your system and avoid any dissemination, distribution, copying, or any other use of this message or its attachments. If you are not the intended recipient, please notify the sender immediately by electronic mail. 




    ------Original Message------

    ​Martin and Wendy, I belive you both provide the same solution and it is not realistic to do since there are several users (more than 50.000) using the tool and we can not ask them to all change their settings, even thou this might be the answer.

    Randall, this might be a good idea, will test and let you all know.

    Anyone else who creates materials with winshuttle composer and creates a full Unit of meassure-table.
    Any challanges with numeric decimals?

    ------------------------------
    Henrik Axell Master Data Analyst
    Essity Hygiene and Health
    ------------------------------


  • 9.  RE: Composer / Dots and commas

    Employee
    Posted 09-19-2018 03:16

    ​Maybe you need to extend the formula from Randall to have the number as a proper value:
    =VALUE(SUBSTITUTE(D3,",","."))

    Best regards
    Alain
    <°)))><



    ------------------------------
    alain@fish-lee.ch
    ------------------------------

    Original Message


  • 10.  RE: Composer / Dots and commas

    Employee
    Posted 09-19-2018 05:42
    Hello Henrik
    I suggest getting the values from a SharePoint list as best practice, rather than copying from another material. There are additional benefits to storing the rules in a SharePoint list: they can be edited on the fly externally, without your application having to be changed and redeployed. I have described this solution in my post entitled: Composer Solutions: Defaulting Fields according to Predefined Standards.
    https://community.winshuttle.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=0731d064-2f50-4612-87be-0f987bbaecae&forceDialog=0
    Winshuttle remove preview
    View this on Winshuttle >


    ------------------------------
    Monika Pletschke | solution engineer
    Winshuttle Germany | Munich | 089444580221
    ------------------------------



  • 11.  RE: Composer / Dots and commas

    Posted 12-13-2018 04:09

    I took me while to resolve this but it now indentified and resolved.
    This is how I did it

    1 Create a rule on the attribute in COMPOSER you want to convert from DOT to COMMA or vice versa
    TYPE should be ACTIONS and to "SET A FIELD VALUE
    2 Field Value should be the same attribute that you should change as well as the VALUE
    3 Add code for VALUE to convert; ".replace(/\./g, ',');" for dot to comma, (.replace(/\,/g, '.');) for comma to dot

    The code should look like this:


    $form.getValue('VALUE_FROM_FORM').replace(/\./g, ','); Where 'VALUE_FROM_FORM' is the attribute.
    This will work on both QUERY and TRANSACTION

    I hope this helps

    BR // Henrik



    ------------------------------
    Henrik Axell Master Data Analyst
    Essity Hygiene and Health
    ------------------------------

    Original Message