User contributions for WikiSysopdi

21 October 2022

• 11:4111:41, 21 October 2022 diff hist +96‎ N Userdb ‎ Created page with "'''Syntax''' : usedb <DATABASE> <ENTER> Description : To select and use any available database." Tag: Visual edit
• 11:4111:41, 21 October 2022 diff hist +104‎ N Listdb ‎ Created page with "'''Syntax''' : listdb <ENTER> Description : Lists all the available database list under current Server." Tag: Visual edit
• 11:4111:41, 21 October 2022 diff hist +117‎ N Servers ‎ Created page with "'''Syntax''' : logout <ENTER> Description :  To log out from current session as remove current local server detail." Tag: Visual edit
• 11:4011:40, 21 October 2022 diff hist +6‎ Help ‎No edit summary current Tag: Visual edit
• 11:4011:40, 21 October 2022 diff hist +156‎ N Help ‎ Created page with "Syntax : help <command> <ENTER> Description : Displays the command help. Optional parameter of the command name to onlt see that specific command help text" Tag: Visual edit
• 11:3911:39, 21 October 2022 diff hist +13‎ MediaWiki:Sidebar ‎No edit summary
• 11:3811:38, 21 October 2022 diff hist +114‎ N Islands ‎ Created page with "'''Syntax''' : islands <ENTER> Description : Lists all of our islands in the current region added through 'push'." Tag: Visual edit
• 11:3811:38, 21 October 2022 diff hist +157‎ N Regions ‎ Created page with "'''Syntax''' : regions [PUBLIC] <ENTER> Description : Lists all of our regions.  We can also see public/shared regions by adding public optional parameter." current Tag: Visual edit
• 11:3811:38, 21 October 2022 diff hist +252‎ MediaWiki:Sidebar ‎No edit summary
• 11:3411:34, 21 October 2022 diff hist +130‎ MediaWiki:Sidebar ‎No edit summary
• 11:3211:32, 21 October 2022 diff hist +6‎ Pull ‎No edit summary Tag: Visual edit
• 11:3211:32, 21 October 2022 diff hist +510‎ Pull ‎No edit summary Tag: Visual edit
• 11:3111:31, 21 October 2022 diff hist +7‎ Push ‎No edit summary Tag: Visual edit
• 11:3111:31, 21 October 2022 diff hist +661‎ N Push ‎ Created page with "'''Syntax''' : push <ISLANDNAME> [A/D/U] "<COLUMN LIST>" "<DESCRIPTION>" <ENTER> Description : Creates a data island in the current region and adds the data based on the previous run query.  For the FILES provider ONLY, please note that the files (which we get from querydb) will be uploaded to the server. We also have one optional parameter 'a' append or 'd' delete or 'u' update, so if user try to store data into existing island then application will ask whether we are..." Tag: Visual edit
• 11:3011:30, 21 October 2022 diff hist +881‎ N Querydb ‎ Created page with "'''Syntax''' : For SQL/MySQL/PostgreSQL: querydb "<SQL QUERY>" <ENTER> For CSV: querydb "<CSV FILE NAME>" <ENTER> For Xero: querydb <ENTITY> <FILTER> <ENTER> For Files: querydb<PATTERN> <ENTER> Eg: For SQL/ MySQL / PostgreSQL: eg.querydb "select top 10 comp_name from company" For CSV: eg.querydb "test.csv" For Xero: eg.querydb contacts firstname = 'CRM' AND UpdatedDateUTC > DateTime(2022, 03, 24) FILES For Files: eg.querydb "*.csv" Description : Executes the gi..." Tag: Visual edit
• 11:3011:30, 21 October 2022 diff hist +13‎ MediaWiki:Sidebar ‎No edit summary
• 11:2911:29, 21 October 2022 diff hist +248‎ Jint ‎No edit summary Tag: Visual edit
• 11:2811:28, 21 October 2022 diff hist +28‎ Status ‎No edit summary current Tag: Visual edit
• 11:2811:28, 21 October 2022 diff hist +83‎ N Connect ‎ Created page with "'''Syntax''' : connect <ENTER> Description : Log in or Register with CRM Together." Tag: Visual edit
• 11:2711:27, 21 October 2022 diff hist +1,022‎ Addserver ‎No edit summary Tag: Visual edit
• 11:2211:22, 21 October 2022 diff hist +84‎ N Addserver ‎ Created page with " SQLite Example addserver sqlite "DataSource=C:\sqllite\sampledb.db;Version=3;"" Tag: Visual edit
• 11:2011:20, 21 October 2022 diff hist +23‎ MediaWiki:Sidebar ‎No edit summary
• 11:2011:20, 21 October 2022 diff hist +26‎ XERO addserver ‎No edit summary Tag: Visual edit

21 September 2022

• 06:2106:21, 21 September 2022 diff hist −160‎ Pull ‎ LIKE operator description. Tag: Visual edit

20 September 2022

• 12:1612:16, 20 September 2022 diff hist +517‎ Pull ‎ LIKE operator Replaced with ILIKE Tag: Visual edit

19 September 2022

• 12:4512:45, 19 September 2022 diff hist +86‎ MediaWiki:Sidebar ‎No edit summary
• 12:4312:43, 19 September 2022 diff hist +74‎ MediaWiki:Sidebar ‎No edit summary
• 11:3111:31, 19 September 2022 diff hist +51‎ N Pull ‎ Created page with "Syntax pull island destinationname "<whereclause>"" Tag: Visual edit
• 11:3111:31, 19 September 2022 diff hist +13‎ MediaWiki:Sidebar ‎No edit summary

5 September 2022

• 21:2021:20, 5 September 2022 diff hist +428‎ N Embed ‎ Created page with "You can embed lists and dashboards from the web app (data.crmtogether.com) into your own app (ERP or CRM system for example) without having to pull down the code. You do this by embedding an iframe with a src url that has the structure https://data.crmtogether.com/iframe/REGION/ISLAND/?FIELD=fieldvaluetomatch For example <nowiki>https://data.crmtogether.com/iframe/tsxerodata/xeroinvoices/?Contact_Name=Acme</nowiki> Inc" current Tag: Visual edit
• 21:1621:16, 5 September 2022 diff hist +15‎ MediaWiki:Sidebar ‎No edit summary

4 September 2022

• 22:5322:53, 4 September 2022 diff hist +306‎ Sage 300 Queries ‎No edit summary current Tag: Visual edit

1 September 2022

• 12:0912:09, 1 September 2022 diff hist +677‎ Charts ‎ querydb in web app current Tag: Visual edit

29 August 2022

• 16:1016:10, 29 August 2022 diff hist +307‎ Sage 300 Queries ‎No edit summary Tag: Visual edit
• 16:0016:00, 29 August 2022 diff hist +218‎ Sage 300 Queries ‎No edit summary Tag: Visual edit
• 15:4515:45, 29 August 2022 diff hist +602‎ Sage 300 Queries ‎No edit summary Tag: Visual edit
• 15:3515:35, 29 August 2022 diff hist +250‎ Sage 300 Queries ‎No edit summary Tag: Visual edit
• 14:4714:47, 29 August 2022 diff hist +56‎ Sage 300 Queries ‎No edit summary Tag: Visual edit
• 14:4114:41, 29 August 2022 diff hist +997‎ Sage 300 Queries ‎No edit summary Tag: Visual edit
• 12:1512:15, 29 August 2022 diff hist +151‎ N Sage 300 Queries ‎ Created page with " Contained here are some recommended queries for Sage 300 to get only the data needed for Owners and customers. Owners: Single Customer queries:" Tag: Visual edit
• 12:1412:14, 29 August 2022 diff hist −9‎ MediaWiki:Sidebar ‎No edit summary
• 12:1412:14, 29 August 2022 diff hist +1‎ MediaWiki:Sidebar ‎No edit summary
• 12:1312:13, 29 August 2022 diff hist +49‎ MediaWiki:Sidebar ‎No edit summary

17 August 2022

• 21:0221:02, 17 August 2022 diff hist +7‎ XERO Xero Support ‎No edit summary Tag: Visual edit
• 16:4116:41, 17 August 2022 diff hist +546‎ XERO Xero Support ‎No edit summary Tag: Visual edit
• 16:3016:30, 17 August 2022 diff hist +171‎ N XERO Xero Support ‎ Created page with " Note: The xero "invoices" table holds both invoices sent and received. So you should filter this on the "Type" column which contains 1 of 2 values # ACCREC # ACCPAY" Tag: Visual edit
• 12:4212:42, 17 August 2022 diff hist +394‎ N Task Scheduler ‎ Created page with "You can use windows Task Scheduler to run tasks at a specified time In the Task item you set the action to be "Start a Program" and set the "Program/Script" value to be the path to the console exe file. EG "C:\Users\YOURUSER\AppData\Roaming\CRM Together\TSDataIslands\TSDataIslands.exe" and then set the "Add Arguement" to be the path to the script file EG "C:\DIScripts\pushERPdata.tsd"" Tag: Visual edit
• 12:3812:38, 17 August 2022 diff hist +76‎ MediaWiki:Sidebar ‎No edit summary

16 August 2022

• 16:0516:05, 16 August 2022 diff hist +30‎ XERO querydb ‎No edit summary Tag: Visual edit

11 August 2022

• 16:1216:12, 11 August 2022 diff hist +215‎ XERO querydb ‎No edit summary Tag: Visual edit