EDPMS: Export Data Processing and Monitoring System RBI has directed AD Category-I Banks to update the EDPMS with data of export proceeds on “as and when realised basis” and, with effect from October 16, 2017 generate Electronic Bank Realisation Certificate (eBRC) only from the data available in EDPMS, to ensure consistency of data in EDPMS and consolidated eBRC. Nice initiatives taken by RBI to monitor export related information on real time basis. Here we need to understand the EDPMS data. There are 2 legs mainly: 1)- Shipping bill is being generated by customs. 2)- That shipping bill is being transferred to RBI EDPMS data. If there is any issue in data related with shipping bill, Exporter need to contact the custom for taking corrective action.For example, that shipping bill status is LEO Cancelled or the same was sample bill and exporter did not submit GR waiver. There may be other cases also. In 2nd case, banks handling the documents need to clear the GR with received payments/ as per RBI guidleines WOFF, extension etc whatever is possible. As observed by me, at present, bills are appearing due to below mentioned reasons: > BRCs has been generated while it is showing pending.: In this, first check the AD code bills appearing in Shipping Bills, and if AD code of other Bank is appearing, transfer the same in your AD and clear the entry with the help of data center or whatever the process is there. Particular in this case, Banks are more responsible to clear the entries as payment has already been received.\ > LEO Cancelled/SAMPLE BILLS (Where GR waiver was not taken): In such case, one of the solution is to make necessary correction at customs and clear the same entry. > In case of non receipt of payment/any other technical reason: Follow the master circular of Export of goods and services dated 01.01.2016 updated on 12.05.2016 for taking corrective action. Basically where payment has been received, Banks who handled the documents has to be more proactive to clear the bills. Above are illustrative and based on while working on EDPMS.

Working in office on holidays/Late Hours.

Working in office on holidays. It seems that bank officials wait for holidays to finish the important tasks. During the 6 year in Bank's service, i worked in various offices/branches and find that whenever there is a long holiday (between 2 to 4 days), management always have some important works and passes the orders to open the office to finish this task. In my view, there may be only below mentioned reasons which I find if any task does not finish on deadlines: > Due to over burden work on staff: Bank may recruit the staff as per their requirement to address the issue. > Staff is not enough to motivate: Consult with reporting authority and make proper counseling. If even after enough counseling, staff does not improve, take stern action as per rules. >Unskilled staff: In such case, either Bank may provide proper training or on the job training, reporting authority (BOSS) either to guide them properly or assign the task according to their skills with a patience. There may be other reason, but i find these reasons more valid. Due to the continuous working in office on holidays/late hours, it is going to only decrease the efficiency and demotivation in major of staff after a certain period . As such condition is not going to work in a long run and would not be able to run a long show.I think that Banks need to address such HR issues appropriately to ensure a more productive working environment at their earliest.

BANK FRAUD MERGER BIPERTIE

As of now everyone is aware about the position of Banking Sector and after the case of NIRAV MODI, everyone is advising PSUs for improvement in working even though they do not know the even ABCD of Bank. Anyway, the only banking industry is responsible for the same due to adopted wrong practices for gaining the short term benifits. I always fail to understand: What is the purpose of Loan Mela. If PSUs would improve their services basically IT enabled services and would focus to reduce TAT for services would more than enough for growth. What happens in Loan Mela is known to everyone. I have never seen the person who defaults is in trouble, its always a banker who has all the worry to ensure the account as standard. Unfortunately, i have also become the part of such worry. There must be a worry to borrower for repayment not the Banker. Since bankers are not GOD or superhuman who will read the intention of borrower while sanctioning loans. They go by the paper and their experience and if finds correct, they go ahead. It is the borrower who has no will to repay the loans due to obvious reasons and RIN MAFI Schemes are one of them. In place of RIN MAFI, there should be other way to help the needy people. As RIN MAAFI always hurts the honest people and developing the tendency of default or make RIN MAFI to all including who paid well in time. Fraud: Today it seems that account turning into NPA is being called as a FRAUD particularly after the case of NIRAV MODI, but that is not right at all. As explained, account turns into NPA when borrower does not pay and sanctioning after the following norms, just due to bad intent of borrower, banks cant be responsible. Fraud may be called where bank's did not comply the guidelines properly and ignored the same due to malafide intention/ give specific benifits to individual.

Trade Credit

As everybody is aware, in any trade transaction, there will be two parties 1- Buyer and 2-Seller In a trade transaction following are type of payment and risk. Type of Payment and Risk: Advance: Seller has no risk while Buyer has to rely on seller (100%). Open A/C: Seller has to rely on buyer while buyer has no risk. D/P Collection:Seller has a risk of non payment of draft while buyer has to depend on seller to supply of goods ordered. Assurance of shipment would be there. D/A Collection: Seller has more risk as non payment of bill of exchange, even though Buyer has the mechandise. While Buyer has minimal risk and may refuse to pay at maturity. Sight L/C:Seller has minimum risk as issuing/conforming bank's obligation to pay if documents conform to lc while buyer has assurance of shipment, but depends on seller to supply goods ordered. Usance L/C:Seller has minimum risk as issuing/conforming bank's obligation to pay if documents conform to lc while buyer has to pay at maturity regardless of product quality. Above are only illustrative purpose only.

Mysql workbench

MySQL workbench:

To download mysql work bench .Click here

Recently i got chance to work on database. and my assignment was to create database and ER diagram. And to complete this assignment, i used MySQL workbench.

About MySQL Workbench

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench is available as a native GUI tool on Windows, Linux and OS X in different editions. See the following link for more information about the editions available.

If you are familier with other gui tools like MySQL query browser and mysql administrator, both features are available in workbench. Other is data modeling, there you can create ER diagram.
Three parts of MySQL workbench:

1) SQL development: You can run your database query. very similar to mysql query browser.

2) Data Modeling: You can create ER diagram.

3)Server: very similar to mysql administrator browser. You acan create backup and restore of your database script.

I installed on windows 7 and vista. It was creating problems in XP. Error was .netframework, i tried but did not complete it.

Thanks
Deepak

Firbug

Firebug:

To download the firbug development tool:
http://getfirebug.com/

Firebug integrates with Firefox to put a wealth of web development tools at your fingertips while you browse. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.

Features:
Inspect HTML and modify style and layout in real-time: After installing or adding plug-in of firebug, see at the bottom of, an icon image (a worm image), click here,
Use the most advanced JavaScript debugger available for any browser
Accurately analyze network usage and performance

Some very helpful shortcuts and commands when working with firebug. Thanks to Duvet-Dayez for creating this cheat sheet.

Firebug cheat sheet

Deepak

Internationalization in GWT

In my last assignment, i got good assignments on GWT like internationalization, history implementation and maintenance of log.
They are easy, but while you are doing these thing first time specially in GWT,then it is not a simple nut.

So i would like to discuss internationalization here.

First create GWT project. (Here i am creating project name: UsePropertyScreen)

Create 2 interface and 2 properties file with same name like PropertConstant.java and PropertyMessage.java and property files with PropertyConstant.properties and PropertyMessage.properties.

Code for PropertConstant.java
package deepak;
import com.google.gwt.i18n.client.Constants;
public interface PropertConstant extends Constants {

String hello();
//Add more key values here
}

Code for PropertyMessage.java

package deepak;
import com.google.gwt.i18n.client.Messages;
public interface PropertyMessage extends Messages {

String alertMessage();
String alertParameter(String arg);
}

Now Make entries in .property file also. Please provide same key as you gave in java file. i.e function name in java =key value in properties

PropertyConstant.properties
hello=Hello Deepak

PropertyMessage.java
alertMessage=Hello deepak!, welcome
alertParameter= Hello {0}

So if you want to pass more parameter, define function with parameter and in property file use {0} for first parameter and {1} for second parameter etc

Now make samall change in UsePropertyScreen.gwt.xml.file

<inherits name="com.google.gwt.i18n.I18N">

<extend-property name="locale" values="PropertyMessage">

And now use these key value inside client side file. It can't be used server side files.

Screen.java
package deepak;

import com.google.gwt.user.client.ui.RootPanel;
import com.google.gwt.user.client.ui.VerticalPanel;
import com.gwtext.client.widgets.MessageBox;

public class UsePropertyScreen implements {
private final PropertyMessage message=GWT.create(PropertMessage.class);
private final PropertyConstant constant=GWT.create(PropertConstant.class);
public UsePropertyScreen(){
MessageBox.alert(constant.hello());
MessageBOx.alert(message.alertMessage());
MessageBOx.alert(message.alertParameter("Deepak Pandey"));

RootPanel.get().add(new Label(constant.hello()));

}

}

Now run this application.

YOu will get 3 alert,
First with : "Hello Deepak"
Second with : "Hello Deepak!, welcome"
Third with : Hello Deepak Pandey

By default it will take above files. But if you want to change propert file according to your language. Create property file in following manner:
PropertyMessage_hi.properties
and select Hindi language or use hi in url address. So you are able to identify.
and change in UsePropertyScreen.gwt.xml,
<extend-property name="locale" values="hi">

cheers!