![]() The same as IUpdateMatchingReceiver,īut it's called on per field basis. Public bool OnBeforeFieldUpdate(BGField fromField, BGField toField, BGEntity BGEntity to)Ĭallbacks to be called before updating the row' field. Public bool OnBeforeUpdate(BGEntity BGEntity to)Ĭallbacks to be called before updating the row. Public bool OnBeforeAdd(BGEntity fromEntity)Ĭallbacks to be called before adding the row. Public bool OnBeforeDelete(BGEntity toEntity)Ĭallbacks to be called before deleting the row. Return true from OnBeforeMerge to cancel merging Public void OnAfterMerge(BGRepo BGRepo to)Ĭallbacks to be called before after merging. Public bool OnBeforeMerge(BGRepo from, BGRepo to) Return true from this methods to cancel operation Listed below to receive callback method invocations. Implement any number of interfaces (namespace is BansheeGz.BGDatabase, interfaces defined inside class BGMergeSettingsEntity),. ![]() Create your own C# class with unique name, set this class name to "Controller Type" field of merge settings (using the full name with namespace).Merge settings let you configure which table/fields you want to add/delete/update, but it does not give you the opportunity to define which rows you want to add/delete/updateįor row-level control, you can implement C# controller class, which can cancel any operation if some condition is met. ![]() Export data once- all required structure will be created for you.Make sure all tables you want to include have "Add missing rows" toggle turned on.(cause all the rows will be "missing rows" when you export to empty spreadsheet).Included tables/fields will be highlighted in green Make sure to include all tables/fields you want to export in the settings.Make sure to target empty spreadsheet/xls file.You can easily create this structure by exporting your data to the empty spreadsheet/xls file you need sheets, named after your tables names and header columns, named after you field names (as described above in "Data Layout" section). To be able to sync with BGDatabase, you need a corresponding structure created in Excel/GoogleSheets,Į.g. Import/export and Excel/GoogleSheets are all supported. Rows order from the source will be transferred to the destination. Id values from database will be transferred to _id column when you import new rows. If you are adding new rows in external tools, leave _id column empty and enable this parameter. Here is the illustration about how BGDatabase data is mapped to spreadsheets. (click to view additional guides for Excel/OpenOffice and GoogleSheets) This article describes common procedure and ideas, common for both Excel and Google Sheets. ![]() Use json export/import to create full database backup. No way to update GoogleSheets data from players devices yet. You can edit database data in external tools, such as Excel/Open Office/Libre Office or Google Sheets.īG Database supports export/import to/from Excel files (xls and xlsx), Google Sheets and json (backup only).įull import/export works in Editor only, but you can update database data on players devices from GoogleSheets
0 Comments
Leave a Reply. |