Forum Replies Created

  • Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 1 week ago
    Up
    0
    Down
    ::

    Hi Thomas,

    Unfortunately, Simplifier does not have a connector for MS Access Databases.
    So you need to migrate/export the data in the MS Access Database, for example to MS SQL or SQLite. Then, you can use an SQL connector in Simplifier to read/write data.

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 2 months ago
    Up
    2
    Down
    ::

    Hi Mr. Steinbach,

    Thanks for your suggestion, we’ve added it to our Feature Request list for upcoming releases.

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 2 months ago
    Up
    0
    Down
    ::

    Hi Christian,

    Having multiple languages in Simplifier basically works like having only two: each language needs its own PO file. The respective language can be set using the Client-Side Business Object ‘SIMP_UI5Helper’ – ‘setLanguage’ with the respective language code.

    I understand that you also want to translate the labels of the EntityStatus, is that correct? Then I’d recommend adding a language column to the EntityStatus table (or having a separate table for that, depending on your use case) and adding the label text in each language.

    When fetching the status labels from the database in a Business Object, you can add the language code to the input parameters and pass it to the SQL connector, e.g. ‘WHERE language = <language_code>’.

    When changing the language in the application, you then need to execute the statement again that fetches the entity status labels in the correct language (e.g. by using an event that is fired when the language is changed).

    Let me know if you have any questions.

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 3 months ago
    Up
    1
    Down
    ::

    Hi Christian,

    When transporting an application, all artifacts that are referenced in the application (Business Objects, Connectors, Data Types etc.) are also included in the transport automatically.

    The only artifacts that you have to add to the transport manually are roles. When you create an app with the name ‘MyApplication’, Simplifier will automatically create a role which is called ‘AppMyApplication’ (so it’s always ‘App’ + Appname). This role is automatically added to the transport, too, because Simplifier can detect that it belongs to the application.

    However, if you use any other roles in the application (for example, to distinguish that some users are administrators and some users are ‘normal’ users), you have to add these roles to the transport manually.

    Regarding the difference between Packages/Transports/Releases: I think this knowledge base article describes it quite well: https://community.simplifier.io/knowledge/version-and-release-management-in-simplifier/
    Packages are compiled at runtime, which means that always the current version of the included artifacts is taken.
    Whereas Transports are fixed snapshots of the components, which means that the artifact version is taken from the time where the Transport was created.
    When you create a release for an application, a transport is always created automatically, so you can download different versions of your application.

     

    I hope this makes more clear how the Transport System works.

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 3 months ago
    Up
    0
    Down
    ::

    Hi Amit,

    To access your SharePoint, you can use the SharePoint Connector, which is available on our Marketplace. In general, you can access SharePoint via REST API, which is described in this documentation by Microsoft.

    Access to SharePoint requires authentication with OAuth. You need to set up OAuth as authentication mechanism on your Simplifier instance (here is the documentation) and also, OAuth needs to be configured on your Azure instance (here is the documentation from Microsoft).

    In Simplifier, we do not have a built-in feature to display PPT files. You could convert your PPT files to PDFs or images and then show them in a sap.m.Carousel widget.

    Or make them available for download, if that’s an option in your use case.

     

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 3 months ago
    Up
    1
    Down
    ::

    Oh, I just realized that the error also occurs when the validation is off, because also here, Integer/Float expects a value that cannot be empty.

    So, you need to change the datatype in your BO from Integer/Float to String and add a validation before executing the BO (as described in 1b)) or work with default values for Integers/Floats (as described in 2)).

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 3 months ago
    Up
    0
    Down
    ::

    Hi Christian,

    The validation mechanism for Integers/Floats expects some kind of value, so an empty value leads to an error in conversion.

    So, if your business process allows empty values here, you need to implement a validation mechanism yourself. There are several possibilities:

    1a) Deactivate the validation in the business object. In your BO code, you then need to validate the input values manually (e.g., using Javascript Regex)

    1b) You can also do the manual validation before even executing the business object: select your input field in the UI Designer and click on the small button next to the property ‘value’. Here, you can define when the input field is validated and what kind of datatype it should be (see attached image). In the datatype, you can define a Regular Expression and include that the value can be empty. Then, when the user inserts a value that does not match the datatype, the value state of the input field will change to ‘error’. Before executing the BO, you can check if any of the input fields have the value state ‘error’ (this can be done in the Process Designer using a UI action shape), and, if so, display an error message instead of triggering the BO.

    2) This only works depending on the business process: you could keep the validation in the BO active and set a zero as the default value in the input fields

     

    I hope this information can help you.

    Attachments:
    You must be logged in to view attached files.
    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    0
    Down
    ::

    Hi Mr. Steinbach,

    Thank you for your input! We will discuss your points in our development team to check if we can implement them in further Simplifier releases.

    In general, I see the problem that you are facing. When choosing ‘overwrite’ as transport mode, you do not have the option to deselect single artifacts that should be excluded from being overwritten. But usually, the actual overwrite process should not take that long, so the timespan where errors could occur in other apps is kept short.

    Kind regards,
    Jennifer

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    0
    Down
    ::

    Hi Christian,

    Have you already checked what the output of the file reader contains?
    In Chrome, you can debug it like this:

    • Open your application. If necessary, add ‘sap-ui-debug=<Appname>’ to the URL. For example, when your application is called ‘Example_App’, the URL needs to look like this:
      https://<your Simplifier instance>/appDirect/Example_App/index.html?sap-ui-debug=Example_App
    • Press F12 to open Chrome Dev Tools. Select ‘Sources’, and in the tree structure on the left, select ‘modules’ – ‘ClientBusinessObject’ and then your Client Side Business Object where your CSV upload code is (see attached image)
    • Add a breakpoint to your upload function
    • In your application, upload a csv file while the Chrome Dev Tools are open
    • The process will pause at your breakpoint. Now you can debug all the variables inside the code (e.g., by hovering over them with the mouse)
    • Check if the return value of the Business Object contains the values from the csv. If not, maybe your user does not have the permissions/roles for the uploader? If this is the case, check Step 5 of this article: https://community.simplifier.io/knowledge/drawing-on-images-with-the-signaturepad-widget/

    To use this Business Object output as an input to another Business Object, you can use the ‘Process Output’ shape in the Process Designer (https://community.simplifier.io/doc/current-release/applications/add-application-logic/mapping-area/, ‘Process Output’).

    I hope this information is helpful.

    Attachments:
    You must be logged in to view attached files.
    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    1
    Down
    ::

    Additional note: in our Standard Content, there’s the Client Side Business Object ‘ITIZ_CSV’ which can be used to parse CSV files to JSON (and vice versa). It also uses the libary PapaParse.

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    2
    Down
    ::

    Hello Dimitri,

    your use case seems to be structured into 3 parts:
    1) uploading a csv file
    2) parsing the csv file
    3) getting the data into the SQLite database

    So for the respective steps:

    1) You need to implement the upload process. On our marketplace, we have an example app where the upload process is implemented. Here is the article that describes it, you can also find the download link for the application there: https://community.simplifier.io/knowledge/drawing-on-images-with-the-signaturepad-widget/
    The example app deals with the Signature Pad widget, but you can use the upload process from there. In the Business Object function ‘upload file'(described in Step 3), change the code line temporaryFileReader.readAsDataURL(oFile);
    to temporaryFileReader.readAsText(oFile);

    2) Parsing the csv file: after uploading the file, you can parse it from CSV to JSON using the javascript library ‘PapaParse’ (https://www.papaparse.com/). Upload this library to your Simplifier instance (here is the documentation on how to do this: https://community.simplifier.io/doc/current-release/extend/including-libraries/add-new-library/). Also add this library to your Business Object to be able to use its functions there.
    Create a business object function that takes the result from the fileReader and parses it to JSON (with PapaParse).

    3) Now you have the data from the csv in JSON format. This data can be used in a connector to be written into the SQLite database (it depends on your use case which data you want to write).

    I hope these tips are useful.

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    1
    Down
    ::

    Yes, you need to update the Simplifier version using docker. The article that you already found describes the process quite well, so you can follow those steps (if you have access to the server of course).

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    1
    Down
    ::

    Here you can see Simplifier’s changelog: https://community.simplifier.io/changelog/

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    1
    Down
    ::

    Hi Dimitri,

    Can you please update your Simplifier version to the latest 6.5 hotfix? With version 6.5.153-LTS.73, the app wizard bug that you have described has been fixed.
    In higher versions, the app wizard should be working fine again.

    Jennifer
    Moderator
      Has successfully completed the online course Basics - 100.
    • Topics: 0
    • Replies: 44
    # 4 months ago
    Up
    1
    Down
    ::

    Hi Dimitri,

    It’s difficult to debug this behaviour. To get further information on what could be the issue, you can do the following:

    – When loading the UI Designer, open your browser’s Debug Console (e.g., by pressing the F12 key). Is an error displayed in the console?
    – Check the Simplifier Logs. In our documentation, we show you how to retrieve log files: https://community.simplifier.io/knowledge/logs-and-monitoring-in-simplifier/ (Step 2) Can you see any error in the log file for the respective time when you have opened the UI Designer?
    – Which Simplifier version are you using?
    – Which OpenUI5 version are you using in your application?

    Maybe with this additional information, we can find out what the issue is here.

Viewing 15 posts - 1 through 15 (of 44 total)