Blog

Here I document some issues for searching of which I spent more then 15 minutes

  • Acumatica DAC class generator

    Hello everyboydy,

    today I want to share with anybody mine implementation of DAC class generator.

    By default Acumatica provides you with DAC class generator which is pretty good.

    But time from the time I had a need to generate DAC class into text field, and then

    put it somewhere in my solution, and Acumatica DAC class generator didn't feet to

    mine needs. So I decided to create my own DAC class generator. 

    This form has simple interface. In the first line you enter Connection string, at second

    line you enter table name, press at generate, and receive DAC class.

    You can download source code here. 

    Below goes also some C# code which I've comment later:

        public  … more

  • How to add sitemap into your customization

    Hello everybody,

    today I want to descrive some simple steps of how to add into your customizaiton sitemap. As you already know, sitemap of Acumatica is saved in database. And if you make customization of your sitemap you may need to add to your project.xml something like this:

    <Customization level="0" description="" product-version="5.30">

        <SiteMapNode>

            <data-set>

                <relations version="3" main-table="SiteMap" />

                <layout>

                    <table name="SiteMap" />

                </layout>

                <data>

                    <SiteMap>

    <row Position="72" Title="Warehouse"  Url="~/Frames/Default.aspx"  … more

  • How to make yourself as Administrator in Acumatica with SQL

    Hello everybody,

    today I want to share some piece of SQL code that can help you to add yourself to Administrators group in Acumatica:

    INSERT INTO [dbo].[UsersInRoles]

               ([CompanyID]

             ,[Username]

             ,[Rolename]

             ,[ApplicationName]

             ,[CompanyMask]

             ,[CreatedByID]

             ,[CreatedByScreenID]

             ,[CreatedDateTime]

             ,[LastModifiedByID]

             ,[LastModifiedByScreenID]

             ,[LastModifiedDateTime])

       VALUES

               (2

             ,'yourAccountName'

             ,'Administrator'

             ,'/'

             ,0xAA

             ,'B5344897-037E-4D58-B5C3-1BDFD0F47BF9'

             ,'00000000'

             ,'2010-07-27 17:25:00.000' … more

  • .Net core tag helpers

    Hello everybody,

    today I want to describe some .Net core tag helpers that you can use in order to create your web pages. There are plenty of already implemented tag helpers that can simplify your life as a developer.

    Here is the list of already made:

    Anchor

    Cache

    Distributed

    Environment

    Form

    FormAction

    Img

    Input

    Label

    Link

    Option

    Script

    Select

    TextArea

    ValidationMessage

    ValidationSummary

    It is not a complete list, but I suppose those 16 elements help you to grasp how wide it's functionality.

    Anchor Tag Helper

    Consider following declaration:

    <a asp-controller='Presenter' asp-action='Presentation' asp-route-id=@Model.PresenterID>Presenter ID: @Model.PresenterID</a> … more

  • How to validate input on Insert

    Hello everybody,

    today I want to document small feature in Acumatica which I can call validation of insert. 

    As usually if you need to validate some logic of insertion you can use something like RowXXXXd event. But for simple validations you can use PXUIVerify attribute. Below goes example take from Acumatica itself:

    [PXUIVerify(typeof (Where<LandedCostTran.curyLCAmount, NotEqual<decimal0>>), PXErrorLevel.Error, "The value must be greater than zero", new System.Type[] {}, CheckOnInserted = false)]

    What this command says to you is pretty obvious:

    Verify at ui level ( generate javascript verification code ) that value at LandedCostTran.CuryLCAmount is not equal to zero.  … more

  • Some Elastic search featues

    Hello everybody,

    For few days I've got assigned to work with Elastic search. As faithful to my principles before doing any activity I'd like to familiarize myself with instrument that I had to use. In ordre to use it more effectively.

    So, first of all I want to mention terminology. As a lot of developers I have expereince of working with databases, so I will use analogies from relational db world.

    First of all Kibana has indexes. It has nothing in common with indexes in relational db. Index in terms of relational db would be named database. 

    So each Kibana has one or more indexes ( databases ).

    Each index has one or more types. Types in terms of relational db would be named table.

    In … more

  • How to switch google developer platform to English

    Hello,

    recently I've went into google development platform and faced following issue: 

    all of it's user interface was in Russian. I prefer to see English interface because majority of manuals are written in English, not in Russian. How to switch that language to English? Very simply. Just add to page following line: &hl=en

    For example like this:

    and you'll all set. You'll see everything in english more

  • How to use package manager console for creating migrations

    Hello everybody,

    today I want to describe some basic steps that you can use in order to create and apply migrations to your code.

    So, let's start. 

    Imagine that in your .Net Core project you made some changes and would like them to be created in a form of C# code migration. How to do this in package manager console? Below are steps that I've applied:

    1. add-migration "identity"

    2. update-database

    Enjoy with results. The first command will create for your C# code that will describe which tables need to be created. Second command will execute that C# code and will create on your db them. 

    more

  • How can you explain the role, meaning and substance of ERP in layman's terms?

    Well. It depends from what kind of layman is in front of me. I’ll discuss following layman:

    my mom

    my father

    Some abstract CEO

    Let’s start from my mom. Last time when she asked me what programs I do make I was puzzled. What should I say her? She knows about Android apps, Windows apps and before retirement she used to be train driver. Be she have no idea what is ERP. As you can guess, I can’t say here standard definition of ERP from wikipedia ( actually I can, but it will not add any knowledge to her ). So I started a conversation with her like this ( Y. will stand for me, and M. for my mom ) .

    M. Yuriy, what programs you make?

    Y. ERP systems.

    M. What is this? Is this like my … more

  • How to create plugins that can be loaded/unloaded

    Hello everybody,

    today I want to show sample of code that you can use for your plugins.

    Sometime it can happen that you have some application with it's dlls and you can decide to make ad hoc dlls.

    In order to demonstrate how to do it I prepared following code:

    Create first class library as BaseLib:

    using System;

    namespace BaseClass

    {

        public class BaseClass : MarshalByRefObject

        {

            public virtual bool IsProcessable(string message)

            {

                return true;

            }

            public virtual void Process(string message)

            {

                

            }

        }

    }

    Then create following implementation:

    using System;

    namespace Ext1

    {

        public  … more

General information

Greetings to everybody stopping at my blog. Purpose of this web site is to be google of my brain. Everything I found useful, or of possible beneficial for usage in future I've save here at this blog

Contact information

If you want to contact me more on any subject printed at this web stie, you can email me: zaletskiy(at)gmail.com

Job information

If to speak in general, I'm developer. For now I work as team lead in company GlobalLogic.