List file names in a directory by file explorer

• Go to the specific directory where files are stored.
• Select all files by CNTRL+A.
• Press Shift and Right click on files
• Select “copy as path” from right click menu
• Paste the result in file editor

VLOOKUP - Data Cleansing - MSExcel

 =IF(ISNA(VLOOKUP($B3,G$3:G$26,1,FALSE)), "Not Present", "Present")

=IF(ISNA(VLOOKUP($D3,B$3:B$27,1,FALSE)), "Not Used", "Used")

Create Sequence in tables

CREATE SEQUENCE public.seq_abcded_id

    INCREMENT 1

    START 1

    MINVALUE 1

    MAXVALUE 9223372036854775807

    CACHE 1;

ALTER SEQUENCE public.seq_abcded_id

    OWNER TO postgres;

CREATE TABLE public.abcde

(

    id integer NOT NULL DEFAULT nextval('seq_abcded_id'::regclass),

    name character varying(100),

    PRIMARY KEY (id)

)

WITH (

    OIDS = FALSE

);

ALTER TABLE public.abcde

    OWNER to postgres;

Windows Script to return current path

 cd - To use in the command line

%cd% - To use in the scripts

Java Script - Replace forward slash with backward slash

 str = get_instal_path_org;

res = str.replace(/\//g, "\\");;

AWS - Useful commands

 LINUX Command to connect AWS using KEYS,

export AWS_ACCESS_KEY_ID=AKIAAAAUQG7QC2O4KS6NKGSM; 

export AWS_SECRET_ACCESS_KEY=I1DCBC3nwsRcV8+aoXl0c/PX4iFsTJMr1aZ8EzIDKGSMS;  

aws s3 ls s3://kgsm/active/

s3://kgsm/raw

s3://kgsm/active

WINDOWS Command to connect AWS using KEYS,

setx AWS_ACCESS_KEY_ID AKIAV7UQG7Q7C2O4KS6NKGSM

setx AWS_SECRET_ACCESS_KEY I1DCBC3nwsRcV8+aoXl0c/PX4iFsTJMr1aZ8EzIDKGSMS

setx AWS_DEFAULT_REGION us-east-1

aws s3 ls s3://kgsm/active/

WINDOWS Command to CREATE NEW FOLDER IN AWS and UPLOAD THE FILE

aws s3 cp F:\run.bat s3://kgsm/active/a1/

Postgresql : Generate token

 CREATE TABLE adempiere.license_tomato_app

(

    customerid integer,

    name text COLLATE pg_catalog."default",

    location text COLLATE pg_catalog."default",

    key text COLLATE pg_catalog."default" DEFAULT upper(substr(md5((random())::text), 0, 50)),

    plan text COLLATE pg_catalog."default",

    license_start_date timestamp without time zone,

    license_end_date timestamp without time zone,

    last_sync_data_time timestamp without time zone,

    industry_type character varying(50) COLLATE pg_catalog."default",

    business_name character varying(50) COLLATE pg_catalog."default",

    isactive integer DEFAULT 1,

    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP,

    updated_at timestamp without time zone,

    created_by integer,

    updated_by integer

)

WITH (

    OIDS = FALSE

)

TABLESPACE pg_default;