![]() There's a comment in the config which shows all the options.Ĭreate a new class under the InsightlyApi.InsightlyObjects namespace. This file is executed on every run, after reset.sql blows everything away.Īdd the new object type that you want to collect "ToDownload" app setting in the config file. (See "Data Mapping" below.)Īdd your new table to the schema.sql file. Add whatever columns you like - you will map them to data in the class defintion below. It's essentially configuration-by-code.ĭesign your database table. To add new objects, you will need to write code - though it's very simple code. The user should have DBO access to an empty database.Īt the default, it will download and sync Contacts, Organizations, and Projects. Input a connection string to your SQL Server.It does not push anything into Insightly, and you shouldn't extend the database tables with your own data, because they get wiped out prior to rewriting. So this only allows a local copy of your Insightly data for querying and reporting. It's one way, and it actually drops all the tables in the database before writing new data. Syncs remote data from an Insightly CRM account with a local SQL Server database.
0 Comments
Leave a Reply. |