• From: Philippines
  • Registered: 03/14/2015
  • Posts: 25

Topic: Using API

Hello, I have been using FA for months now and it has been great. With my limited knowledge in programming, I was able to modify the reports to suit my needs.

I am planning now to use unicenta for pos. As of now, I dont need to sync the data to FA yet. But in the future, if all goes well. I wish to include inventory management and so needs to sync it to FA. I understand I can use the simpleAPI already made. But it proves to be more than what i can handle. can you guys guide me on what and where to learn the basics of it? Thanks

2 Reply by apmuthu (edited by apmuthu 09/06/2015 06:07:44 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Using API

The latest Unicenta works on Java 8.

It's "thriving community support" site is dead.

Determine what database your Unicenta POS runs on (it supports MySQL).

If both applications run off the same DB server, all you may need is just a few cron jobs or triggers for db data synching locally.

The Wiki and the forum have many good leads to guide you thru.

apmuthu's Website

  • From: Philippines
  • Registered: 03/14/2015
  • Posts: 25

Re: Using API

Thanks amputhu. I guess I don't need to use an API but to figure out replication in mysql? I have zero knowledge with this. Good thing time is on my side. smile

  • From: Philippines
  • Registered: 03/14/2015
  • Posts: 25

Re: Using API

Hi amputhu, I now have a scheduled event which calls the procedure to copy sales from Unicenta to FA. I placed the data on another table in FA.
Do you have tips on how to make invoice of the captured total daily sales. My idea was to look at the sales_invoice_db. But since it is quite complicated I wanted to make sure I am in the right direction before continuing.

5 Reply by apmuthu (edited by apmuthu 04/28/2016 07:06:15 pm)

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Using API

Create an invoice manually in FA for one invoice from Unicenta. Take the diffs of the before and after backups and you will see what has been inserted and what has been updated. Do the same in your procedure directly into FA's tables.

apmuthu's Website

  • From: Philippines
  • Registered: 03/14/2015
  • Posts: 25

Re: Using API

Thank you apmuthu.Your way is easier. I found that I need to update 11 tables. I believe I'll manage everything except src_id. Can you tell me what this field is?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Using API

I trust it is  a self join with:

0_debtor_trans_details.src_id = 0_debtor_trans_details.id

apmuthu's Website