Closed

Small MySQL Project that requires install of windows apps.

Please read everything and time is a big factor in getting this completed.

You need these demos to begin.

Formdocs filler

[login to view URL]

CD Data Xero ODBC Connector

[login to view URL]

CD Data connection can be made with the below values and attached .pfx file.

Fields to fill:

OAuth:

Xero App Auth – Private

Cert stor type: PFXFILE

Cert Store: [where in your computer you saved the attached certificate .pfx file]

Example: C:\Users\TonyMSI\Desktop\509 certificate\[login to view URL]

Cert Store Password: [Removed]

Cert subject: *

OAuth Access token: [Removed]

OAuth Access Secret: [Removed]

OAuth Client ID: [Removed]

OAuth Client Secret: [Removed]

Once you are connected you will open Achieva Sheet FDT in formdocs designer. When you type 1011 into the “Tracking number field, the form should auto populate from my xero account. If you see on the bottom, you can right click and manage autofills and just next to end to edit sql statement. I would like the sql coded so it will pull data from the next row if the key id matches. The key ID is the # in the red box. So when we enter a xero invoice number, all the item lines can be pulled down to the formdocs template. I need this to show upto 10 lines with quantity, part number and part description. Need this done as soon as possible.

Skills: MySQL

See more: www sql designer, mysql software download, i need designer apps, pdf mysql php small project, mysql jsp small project, small php mysql project, php mysql project scale small, php mysql small website, php mysql small server, php mysql small hotel, mysql small multimedia file, php mysql small project, project small windows, php mysql small gallery, php mysql small cms, outsourcing php mysql small project, mysql small system, install php mysql windows 2003, mysql small, install php mysql windows 2003 server

About the Employer:
( 5 reviews ) Fenton, United States

Project ID: #10666321

2 freelancers are bidding on average $110 for this job

orpivte

HI I am Irshad, I work as a Freelance Web Developer and I have work experience of 7 years in Expert Web Development, Word Press Web Development , PHP Code igniter Development, Magento Web Development, Open cart We More

$53 USD in 3 days
(0 Reviews)
0.0
marekw63

Hi, I was just looking at Xero projects and this one came up. I use Xero to integrate data and download from 9 companies. I don't think that the ODBC SQL is necessarily the right approach here - happy to try, but I su More

$166 USD in 4 days
(1 Review)
0.0