HINA SOFTWARES - NOW IN ABABIC  &  MALAY, MANDARINE LANGUAGES

Hina Softwares delivers accounts software, billing software, inventory software, medical software, ERP software, textiles software, school management software, college management software, hotel management software, hospital management software, MLM (netwoking) software, bulk SMS softwares, android application..

[Read More...]

Send Tamil SMS through  Oracle Forms6i - PL/SQL Procedure

sms 24.06.2016

Forms 6i Coding

 select pri , com into pri , com from sms_com where rownum =1;
 IF pri = 'ON' THEN
     declare
         p varchar2(100);
    n varchar2(100) := ' Dear.'||initcap(:tb_personal.name);
    r varchar2(20) := :tb_personal.regno;
    m varchar2(100);
    co varchar2(100) := com;
    msg varchar2(1000);
    msg1 varchar2(1000);
    sms varchar2(100) :=  '+91'||:tb_personal.mobile1;
    por varchar2(100) ;
    por1 varchar2(100);
    INST_NAME VARCHAR2(100) ;
 begin
     :system.message_level := '20';
    select sum(b.amount) into p from tb_personal a, tb_billing b
  where a.regno = b.regno and b.parity = :block3.date_3 ;
  select initcap(inst_name) into inst_name from encrypt where rownum = 1;

  msg :=inst_name||n||' RollNo. '||r||' Receipt No '||:block3.date_3||' Amount Rs.'||p|| ' has been paid in your Account Thank You!';
    msg1 := msg;
  por:= '/port:'||co||' /nologo /nosummary';
  por1 := por;
  host('d:\11i\sendsms\sendsms.exe '||por1||  ' " '||sms||' "  " '||msg1||' "',NO_SCREEN);

  IF NOT Form_Success THEN
     Message('Error -- '||SMS||' Message not sent.');
     MESSAGE ('CHECK YOUR COMMUNICATION PORT');
     insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Not Sent',SYSDATE);
  ELSE
     Message(SMS||' Message Sent.');
     insert into tb_send_sms_ok values (1,:tb_personal.name,:tb_personal.regno,co,sms,msg1,'Message Sent',SYSDATE);
  END IF;
     end;
     commit;


sms 24.06.2016

[Read More...]

QAMAR's BLOG: Send SMS from Oracle Forms through USB Connected GSM Devices

QAMAR's BLOG: Send SMS from Oracle Forms through USB Connected GSM Devices

The Polytechnic

Hi I am Senthilkumaran Oracle 10g OCP DBA from Tamilnadu,, India

Easy way to send sms through Oracle 10g Forms 6i Reports 6i

See my demo from 

https://youtu.be/gLskpQ3W1Hk 
https://youtu.be/oBP2Rul0ww4
smscaster + third party control usage (Airtel)

its free

thanks

[Read More...]

Hina Softwares

Hina Billing Software (Since 2005)

(Admission + Billing + Accounts + Auditing + Expenses + Balance Sheet + Ledger Balance + SMS + Group SMS + Barcode + NoDue + TC + CC + Bonafide + Declaration Forms + Nominal Role + Govt. Related Forms + More than 100 Reports )

Features:

·         Oracle based First Software in Tamil Language with SMS Support in LOW COST, No Hidden Charges.

·         Software Available in following Languages English, Tamil, Malayalam, Telugu, Hindi, Arabic and Malay.

·         Fully Password Protected Bills & Receipts,

·         Front End : Python, Rail, Oracle Forms & Reports, Back End : Oracle 10g/11i Express, OS : Windows XP

·         Also available in Polytechnic Exam, Assessment, Library Management, Retail POS, Medical POS

Thanks to Our New Clients – Year 2016

·         National Institute of Polytechnic, Jayankondam

·         National Arts & Science College, Jayankondam

·         Nelliandavar Institute of Technology, Pudupalayam,Ariyalur

·         Modern Polytechnic College, Mahimaipuram, Ariyalur

·         Modern Arts & Science College, Ariyalur

·         Modern Matric Hr.Sec.School, Jayankondam

·         Musiri Institute of Technology, Musiri

·         Musiri MIT Education College for Women, Musiri

·         Meenakshi Ramasamy Arts & Science College, Thathanur, Ariyalur

·         Meenakshi Ramasamy Polytechnic College, Thathanur, Ariyalur

·         Meenakshi Ramasamy Engineering College, Thathanur, Ariyalur

·         Meenakshi Ramasamy Catering College, Thathanur, Ariyalur,

·         Meenakshi Ramasamy Educational Institute, Thathanur, Ariyalur

·         Meenakshi Ramasamy CBSE Vidyalaya, Thathanur, Ariyalur

·         Meenakshi Ramasamy Matric Hr.Sec.School, Thathanur, Ariyalur

·         Merit Educational Institute, Ariyalur

·         Pari Vallal CBSE School, V.Kaikatti, Ariyalur

·         Modern Nursery & Primary School, Kattumananrkoil

·         Don Bosco Hr.Sec.School, Varadharajanpet

·         Rajiv Gandhi National Hr.Sec.School, Nattarmangalam,

·         Government Middle School, Nattarmangalam

·         Mother Gnanamma Arts & Science College, Varadharajanpet, Ariyalur. etc.,

Reasonable Prices:

Institutions	1 Server with Client	If you want Extra (Each) Client	AMC
Nursery & Primary Schools	10,000/-	1,000/-	2,000/-
Middle Schools, ITI	10,500/-	1,250/-	2,000/-
CBSE Schools	15,000/-	1,500/-	2,500/-
Higher Secondary Schools	15,000/-	1,500/-	2,500/-
B.Ed, Nursing Colleges	15,000/-	1,500/-	2,500/-
Polytechnic Colleges	20,000/-	2,000/-	2,500/-
Arts & Science Colleges	20,000/-	2,000/-	2,500/-
Engineering Colleges	30,000/-	3,000/-	3,500/-

Contact: (For Free Demo CD, Information)

Senthilkumaran R	9952784002
Oracle 10g OCP DBA	8012784989
HINA SOFTWARES	abisekblogger@gmail.com       WebSite :       http://goo.gl/2QRs2B

hina billing demo

https://youtu.be/gLskpQ3W1Hk

https://youtu.be/oBP2Rul0ww4

[Read More...]

Installing Oracle forms6i d2k

How To Install D2K(Developer Two Thousand) or Forms & Report In Your System

Requirement

OS window xp
(on 7 or 8 it will also install but some features not working properly so prefer xp or use vmware)


After download of developer 6i, Install developer 6i in your system
if you want to install it on Window7 or Window8 then change the compatibility mode to xp.
Developer 6i (download it from here: developer6i)
Oracle database(pre installed)

Installation Steps
Download the Developer 6i from above link and extract it. extracted size will be 614 or 621 MB.
Its very good choice if you install it in window xp or you can install it on 7 or 8 also but some features will not work properly in 7 or 8.

open the extracted folder developer 6i

[Read More...]

10 Passport Photos only Rs.5

 Creating a passport photo
1. Take the photo

http://www.idphoto4you.com/

2. Uploading a photo

 Parameters of the photo to be uploaded

    File format: .JPG, .JPEG
    Bit depth: 24 bit
    Minimum dimensions of image: 130x200
    Minimal image size for good photo quality: 800x800
    (if the height of the head is one third of the image)
    Maximum dimensions of image: 10000x10000
    Maximum file size: 10 MB
   
3.  Do not upload:

    Picture taken with web camera.
    Scanned photo.
    Any photo that was not taken about somebody's face but another body part or object.

4.  Downloading the passport size photo

5.  Print your photo in your favourite Studio, charges you Rs.5 for you

[Read More...]

WhatsApp in your Laptop or PC - Jan 2015 New

Around the world, WhatsApp is an Interactive messaging and media sharing app for smartphone. However the biggest dawback is it is not using some other mobile phones. It's QUITE EASY on how to use PC or LAPTOP.  download this application

http://filehippo.com/download_bluestacks_app_player
or
http://cdn.bluestacks.com/downloads/0.8.1.3011/BlueStacks_HD_AppPlayerICS_setup_0.8.1.3011_REL.msi

get it installed on the computer

 

 

Verification: This is the last step in the “download WhatsApp for pc” procedure. When the application gets installed, an icon will appear and you need to just click on that given icon and type in your mobile number for verification.

[Read More...]

How to trace any phone (Name & Address) - Jan 2015

Wikipedia says moe than more than 960 million using mobile phones in India, top servicer from india is Vodaphone, idea, airtel etc. using this website you can check any number from any location in india or abrosd. enjoy
http://www.truecaller.com
My Mobile Address with Name

[Read More...]

IMEI - How to trace your Mobile - Android / Others

Lost your Mobile Phone


Android:

gmail account +
go to
https://www.google.com/android/devicemanager


Others:
1.Dialing *#06#        -get IMEI
2.It is mentioned on phone box
3.You phone receipt also highlights it

websites:

trackimei , trackimei.co.in , imei info , imei-number  , imeitrack

[Read More...]