Difference between revisions of "Connecting ODBClink to Xero using a private certificate"

no edit summary
Line 19: Line 19:
# Select '''Connect to Xero using your own private certificate''' as the '''Connection Type''';
# Select '''Connect to Xero using your own private certificate''' as the '''Connection Type''';
# Click the '''Setup''' button which will launch your web browser;
# Click the '''Setup''' button which will launch your web browser;
## In your web browser, login to the XERO website;
# In your web browser, login to the XERO website;
## If this is not your first private application, click '''Add Application''';
# If this is not your first private application, click '''Add Application''';
## Select '''Private''' as the type of application to creare;
# Select '''Private''' as the type of application to creare;
## Enter a unique application name. We recommend including the organisation or company name;
# Enter a unique application name. We recommend including the organisation or company name;
## Select the organisation;
# Select the organisation;
## Tick the '''Upload X509 certificate file (.cer)''';
# Tick the '''Upload X509 certificate file (.cer)''';
## Click the '''Choose File''' button and browse for your '''X509 Certificate''';
# Click the '''Choose File''' button and browse for your '''X509 Certificate''';
## Tick the '''Enable Payroll API for this organisation''' if you need payroll data;
# Tick the '''Enable Payroll API for this organisation''' if you need payroll data;
## Tick the '''I have read and agree to the Xero Developer Platform Terms''';
# Tick the '''I have read and agree to the Xero Developer Platform Terms''';
 
# Click the '''Save''' button to save the private application settings;
# Return to '''ODBClink''';
# Click both '''Show''' buttons under '''OAuth Credentials''';
# Enter the '''Consumer Key''';
# Copy the values for '''Consumer Key''' and '''Consumer Secret''', return to '''ODBClink''' and paste the values in the relevant fields;
# Enter the '''Consumer Secret''';
# Open the '''Private Key PEM''' file generated when you created your organisation certificiate, copy the contents and paste in the '''Private Key''' field;
# Enter the '''Private Key''';
# Click the '''Test''' button to ensure the connection is created correctly;
# Click '''Refresh Lists''' and login to the XERO data file;
# If using '''Jobs''' or '''Categories''', click '''Refresh Lists''';
# Select tracking category used for '''Jobs''' (if required);
# Select tracking category used for '''Jobs''' (if required);
# Select tracking category used for '''Categories''' (if required);
# Select tracking category used for '''Categories''' (if required);
Line 39: Line 39:
# Click '''Close''' to close the Manage Data Files dialogue;
# Click '''Close''' to close the Manage Data Files dialogue;
# Run your first [[Get Data]].
# Run your first [[Get Data]].
1) Download openssl, install, reboot
2) Run command lines
3) Go to odbclink data file page, click setup
4) Enter unique name, select data file, upload cert, save
5) Show consumer key and secret and paste back into ODBClink
6) Paste PEM file
7) Test
8) OK




==
==
1,349

edits