Manually add invoices

gideon
gideon
Offline
0
Hi there ,

I do have an accounting program that use Mysql as well , My question is like this ,

I want to be able to add invoices and assign it to customer without using the backend for your extension, but I want the customers to be able to login and see their invoices, I want to use my backend to add and update invoices .

Is it possible , do you have any documents that can help in this situation ?

Thanks
Responses (9)
  • Accepted Answer

    Monday, August 12 2013, 11:08 PM - #Permalink
    0
    no.. not at all. if you want to use our program, you have to use our backend...!
    I mean... the question is actually a bit strange to me.. you're saying you want to use our extension but actually no use it? :)

    maybe I just did not understand the situation correctly...
    The reply is currently minimized Show
  • Accepted Answer

    gideon
    gideon
    Offline
    Monday, August 12 2013, 11:27 PM - #Permalink
    0
    Sorry for this misunderstanding ,

    The thing is like this , I am using a Filemaker with my sql tables , we have invoices , products and quotes and much more , its a complete system .
    We are missing the portal part with our system , with is the customer can login and print his invoices.
    I can change the mysql database and tables in our program to actually use your database tables with will give us to create invoices in our backend software and the user can see from your front end .
    Like accessing the the database table and add the content , is it possible , I can not see any issue with unless you have a different view

    Thanks
    The reply is currently minimized Show
  • Accepted Answer

    gideon
    gideon
    Offline
    Tuesday, August 13 2013, 03:53 PM - #Permalink
    0
    HI ,
    Is it possible to send me the database digram for your extension ?

    Thanks
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, August 13 2013, 06:43 PM - #Permalink
    0
    Hello

    I understand better now. It sounds really complicated to me, to be honest. you're thinking in somehow "matching" the DB fields, which "could" work, but then all the login behind it, all the logic made with PHP and JS files would most likely not.. I really see this hard to accomplish.

    the best approach to this is maybe that you can export your invoices and then we could build some custom import function in ours, and this way the users could access their invoices.

    this integration could maybe even be kind of automatic if the DBs where in the same server (in a way that Invoice Manager can read your DB tables and import data into its DB tables), but the original idea you mention, which would be sort of our program running on your DB tables, I really see this hard to accomplish, even if the theoretical base idea would seem reasonable (I can see you're a tech guy and you know what you're saying, and I get your idea.. but I don't see it really doable)...
    The reply is currently minimized Show
  • Accepted Answer

    gideon
    gideon
    Offline
    Tuesday, August 13 2013, 08:04 PM - #Permalink
    1
    Exactly the opposite way , Way program runs / use your DB tables . Your program and code wont be touched by as .
    I want my program to update the tables in your DB , for example
    My invoice DB table called "My_INV" will be deleted and instead we will use your DB tables for it
    think about it like this , I want to use phpmyadmin to access your DB to add invoices records with will be possible if you know the exact diagram for your database and what is related to this table . As I said before I think I can do it , Can you please help with sending me the SQl diagram to look into it before buying this , We are in a hurry and we want this to get done as soon as possible

    Thanks for your help and support
    • pepperstreet
      more than a month ago
      Following... more or less I have the same thoughts among my pre-sale questions. I am thinking of CB (Community Builder) or MintJoomla Emerald / Cobalt. Those extensions are able to fire custom SQL queries on certain events and triggers. Maybe ideal for creating Invoices "in-app" ;-)
    • gideon
      more than a month ago
      I know this option and thank you for your respond ,
      Is it possible to send me the database diagram or structure and tables to see if we can integrate it with our system
      I am asking for this for the third time , this could solve all my issues and questions
      and if you don't have it available at least some screenshots would help
    The reply is currently minimized Show
  • Accepted Answer

    gideon
    gideon
    Offline
    Thursday, August 15 2013, 07:25 AM - #Permalink
    0
    Is it possible to send me the database diagram or structure and tables to see if we can integrate it with our system
    I am asking for this for the third time , this could solve all my issues and questions
    and if you don't have it available at least some screenshots would help
    The reply is currently minimized Show
  • Accepted Answer

    Friday, August 16 2013, 10:04 AM - #Permalink
    0
    hello gideon

    sorry I was out. please send me an email at support@ joolmathat.com and I'll send you the DB structure privately

    best,
    Germi
    The reply is currently minimized Show
  • Accepted Answer

    gideon
    gideon
    Offline
    Saturday, August 17 2013, 07:14 AM - #Permalink
    0
    Hi

    I did send the email as soon as you requested but I did not receive anything
    Please send it to me at : netcotech@gmail.com /or/ admin@netcotech.com

    We are waiting for this to continue our main project , all this is delaying and preventing us to go ahead an decide before we buy
    Its very important to have as soon as possible

    Thanks
    • gideon
      more than a month ago
      admin@netcotech.com
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, August 17 2013, 09:26 AM - #Permalink
    0
    we have send the email.
    The reply is currently minimized Show
Your Reply