AnsweredAssumed Answered

How to automate daily import into accounts module from an external DB?

Question asked by Ugorji Ugorji on Oct 17, 2014
Latest reply on Oct 17, 2014 by Francesca Shiekh
Sugar CE 6.5.2

On my Sugar instance, I have to update Accounts module daily - import from an Excel sheet.(I retrieve the Excel sheet from another database on a different server).

I'm requesting direction for a way to automate this daily update. Is it possible to:

1. Connect Sugar to the external DB so that it pulls the data into the Accounting module directly
2. Schedule an automated daily import from a CSV file

If any of this is possible, I'd be grateful for a guide with directions.

Thank you.

Ugorji

Outcomes