Thursday 23 October 2014

TICTACTOE APP - MARK 1




SHORT INTRODUCTION:

APPLICATION NAME:

TICTACTOE APP - MARK 1

FUNCTIONALITY: 

TICTACTOE GAME WITH LOW LEVEL ARTIFICIAL INTELLIGENCE FOR TICTACTOE GAME

TECHNOLOGY: 

CORE JAVA 

DATABASE TECHNOLOGY: 

<NOT APPLICABLE>

DEVELOPER: 

SUNEET K. CHAUDHARY

DOWNLOADING 

Saturday 11 October 2014

PROGRAMMER OR ACCOUNTANT: THE STORY OF MY BIZZARE PASSION


PART 1
"ABOUT ME"
ONCE UPON A TIME I WAS A STUDENT, WHO ALWAYS HAD BIZARRE DREAMS ABOUT HIS CAREER FIELD. THOUGH I GRADUATED MAJORLY IN ACCOUNTS & FINANCE WITH DISTINCTION, BUT HAD UNUSUAL AND BIZARRE IDEAS ABOUT WORKING IN THE AREA OF ACCOUNTS AND FINANCE. 
     
I SIMPLY BELIEVED THAT SOFTWARE TECHNOLOGY CAN POTENTIALLY ERADICATE ALL FLAWS IN THE PROCESS OF ACCOUNTING AND FINANCIAL REPORTING. IN GENERAL, I TEND TO BELIEVE THAT, ACCOUNTANTS HAVE UNDERUTILIZED THIS POTENTIAL POWER, BY BEING UNIMAGINATIVE AND PATHETIC IN THEIR APPROACH. 

THUS, WHILE OTHER FELLOW GRADUATES EVEN MY PARENTS WERE CONSIDERING ME A CRACK AND NEVER MADE ANY SENSE OUT OF WHAT I EVER SAID AND BELIEVED. "MAY BE SOFTWARE TECHNOLOGY WILL MAKE GOOD DIFFERENCE BUT THERE'S NO ROLL OF AN ACCOUNTING GUY LIKE ME OVER HERE", THIS WAS THE IDEA OF ALL AROUND ME.      

BUT NOTHING STOPPED ME FROM PURSUING MY PASSIONS & DREAMS. I HAD DREAMED OF MAKING A REVOLUTIONARY YET SIMPLE APP WHICH WOULD INTEGRATE TALLY.ERP 9 AND MS EXCEL OR ANY OTHER DATABASE CONTAINING BUSINESS TRANSATION AND THERE BY RESCUE THE ACCOUNTANTS FROM REDUNDANT WORK.      

"THE BEGINNING OF MY QUEST"
THE ACTION IN MY STORY STARTED WHILE I WAS WORKING UNDER A CHARTERED ACCOUNTANT. I FELT PREPOSTEROUS ABOUT HAVING THE WORK OF ENTERING JOURNAL ENTRIES INTO TALLY.ERP 9 FROM MS EXCEL SHEET. 

"DEFINING MY QUEST & ACCEPTING REALTY"
I HAD ALWAYS WONDERED, AS TO HAVING AN APP WHICH CAN READ THE DATA FROM EXCEL AND CONVERT THEM INTO PAYMENT TRANSACTIONS AND POST THEM INTO TALLY.ERP 9 SOFTWARE.     
NOW THAT IS GOOD BUT CERTAINLY I HAD NO IDEA OF EVEN THE A B C OF HOW TO MAKE A REAL SOFTWARE THEN.      

"WORK OF LUCK"
THEREAFTER, IT SO HAPPENED THAT I HAD CLEARED ICWAI (INSTITUTE OF COST AND WORKS ACCOUNTANTS) GROUP 2 LEVEL EXAMS TO MAKE MY PARENTS HAPPY. AND I WAS IN THE POSITION TO ASK FOR A REWARD OF MY DESIRE. I THEREFORE ASKED MY PARENTS TO ALLOW ME TO JOIN NIIT FOR A SOFTWARE DEVELOPMENT COURSE. I WAS EXTREMELY GLAD WHEN I WAS ALLOWED BY MY PARENTS TO JOIN. FOR THE FIRST TIME EVER LEARNED SOMETHING WITH SUCH A CUROSITY I HAD THEN. 

BUT STILL THE STORY WOULD TAKE NEXT 6 YEARS TO COMPLETED WITH A HAPPY ENDING. 

END OF PART 1.

PART 2

"PERIOD OF TECHNICAL RENAISSANCE"
NEVER HAD I BEEN SO CURIOUS ABOUT LEARNING ANY THING AS MUCH AS I WAS HERE IN NIIT. I HAD JOINED NIIT FOR .NET, CORE JAVA (FRONT END) + SQL SERVER TECHNOLOGY. ALTHOUGH LATER I COULDN'T COMPLETE .NET AS I HAD TO GO FOR JOB BUT COMFORTABLY COMPLETED CORE JAVA & SQL.

BUT DURING MY COURSE OF PROGRAMMING I HAD A PARTICULAR CURIOSITY, THAT IS I ALWAYS WANTED FIND TO HOW TO DEVELOP A SOLUTION TO INTEGRATE TALLY.ERP 9 AND OUTSIDE DATABASE AS IN MS EXCEL OR SQL.

"MEASURING DISTANCE TO GOAL"
BUT FRIENDS I WAS FAR FROM ANY POSSIBLE BREAKTHROUGH. THIS IS BECAUSE I NEVER PONDERED INTO WHAT TALLY.ERP 9 IS MADE UP OF AND MOST IMPORTANTLY HOW DOES IT INTERFACES WITH OUTSIDE TECHNOLOGY, NEVERTHELESS THESE THINGS WERE ABOUT TO BECOME THE GREATEST LESSONS OF MY LIFE IN NEXT COUPLE OF YEARS.

END OF PART 2.

PART 3

"PLEASURE OF TECHNICAL DRIVE"
I HAD REACHED THE HEIGHTS OF THE PLEASURE OF LEARNING A FAVORITE THING, THAT IS PROGRAMMING.
I WAS HAVING LOT OF FUN WRITING MINOR EXERCISE PROGRAMS IN CORE JAVA + SQL.

"HITTING THE DARKNESS"
BUT WHILE I WAS LEARNING SOFTWARE DEVELOPMENT STEP BY STEP, I WAS ALWAYS & CONSISTENTLY IN THE SEARCH OF FINDING THE WAY TO ACCESS THE DATABASE OF TALLY.ERP 9.

BUT I HAD A LONG WAY TO GO FOR MY ULTIMATE QUEST OF INTEGRATING WITH TALLY.ERP 9.

WHILE I WAS ABLE TO INSERT DATA INTO SQL SERVER 2005 & MS ACCESS I HAD NO IDEA AT ALL AS TO HOW TO HOW IT WOULD WORK FOR TALLY.ERP 9 DATABASE.

I MEAN UNLIKE MS ACCESS OR SQL SERVER 2005 WHICH ACCEPTS DATA THROUGH ODBC OR HTTP SERVICES, I HAD NO CLUE WHICH INTERFACE IS THE WAY INTO DATABASE TALLY.ERP 9.      

SO HOW DO WE GO ABOUT INSERTING DATA IN TALLY.ERP 9? THIS QUESTION REMAINED UNTIL THAT DAY AFTER 3 YEARS, WHEN MY FATE WANTED ME TO FINALLY UNDERSTAND IT ALL.

"FIRST RAY BREAK IN THE DARKNESS"
I CAME ACROSS AND READ AN A DOCUMENTATION IN TALLY SOLUTIONS WEBSITE 
[http://www.tallysolutions.com/website/html/tallydeveloper/integration-capabilities.php]
I READ ALL THE DOCUMENTATIONS AND NEVER UNDERSTOOD EVEN 5% AT THE START. BUT I PONDERED UPON IT AGAIN AND AGAIN AND EACH TIME I UNDERSTOOD SOMETHING NEW. EACH TIME LEARNED SOMETHING NEW.

"PARTS OF ZIGSAW PUZZLE"
I BEGAN REALIZING THAT XML AND CONCEPTS OF SOAP WEB SERVICES 

I HAD HEARD ABOUT SOAP WEB SERVICES LONG BACK.
I HAD ONLY HEARD THAT, WE CAN EXCHANGE DATA EMBEDDED IN XML IF THERE IS A SOAP WEB SERVER
BUT NEVER UNDERSTOOD THE SIGNIFICANCE OF IT IN ACCOMPLISHING MY DREAM APP FOR INSERTING DATA IN TALLY.ERP 9.

HOWEVER, THIS WAS THE FIRST GLIMPSE OF MY UNDERSTANDING OF TALLY INTEGRATION.

ONE THING WAS VERY CLEAR TO ME THAT, THE KEY TO TALLY INTEGRATION LIES IN SENDING XML TO TALLY'S WEB SERVICE ARCHITECTURE.

"FINAL DESTINATION & OUTCOME"
AFTER 30 DAYS OF R&D IN SENDING XML REQUEST TO TALLY.ERP 9 I FINALLY GOT THE WORKING JAVA CODE FOR INSERTING A PAYMENT VOUCHER IN TALLY (AS ONLY IF YOU COME TO KNOW THAT TALLY STORES TRANSACTION DATA IN TERMS OF VOUCHERS).

I HAVE EXPLAINED MY FIRST CODE TO TALLY.ERP 9 IN THE FOLLOWING LINK:

FINALLY OUT OF MY TIGHT SCHEDULE OF WORK AND HOBBY IT TOOK NEXT 6 MONTHS FOR ME TO FINALLY DEVELOP MY FIRST TALLY.ERP 9 INTEGRATION APP.
(CLICK BELOW IMAGE TO DOWNLOAD THE APP)
Hop In Tally App (Click here to download)
  
NOW THE FOLLOWING PIC SHOWS THE ACCOUNTING ENTRY INSERTED BY THE ABOVE APP (HOP IN TALLY) INTO TALLY.ERP 9, THROUGH WEB SERVICES EMBEDDED IN XML PROTOCOL


AT THE END THE THING WHICH WAS NOT THE SCOPE OF AN ACCOUNTANT WAS DONE BY ME AS A HOBBYIST PROGRAMMER. 

BUT THE QUESTION REMAINS, AT THE END WHAT AM I? A PROGRAMMER OR ACCOUNTANT? 

Wednesday 8 October 2014

Hop In Tally - Excel to Tally.ERP 9 App for Payment Entries



SHORT INTRODUCTION: 

APPLICATION NAME: 

HOP IN TALLY

FUNCTIONALITY: 

IMPORT PAYMENT ENTRIES FROM EXCEL TO TALLY (IN A NUTSHELL ITS A PROTOTYPE TALLY.ERP 9 INTEGRATION UTILITY)

TECHNOLOGY: 

CORE JAVA 

DATABASE TECHNOLOGY: 

<NOT APPLICABLE>

DEVELOPER: 

SUNEET K. CHAUDHARY


Dear All,


This is an app to import payment entries to tally from excel (.xls) file.


Downloading

Click here to download the 'Hop In Tally' App.
Also, Click here to check the JVM requirements.


Extracting 

Folders

Excel format

Hey! Remember your excel sheet to be imported must not contain the following characters:
  • &
  • "
  • '
  • <


Excel Path Mapping


Click on Check Connection and Import