User contributions for WikiSysopdi
From Data Islands
21 December 2022
- 17:3117:31, 21 December 2022 diff hist +18 Main Page No edit summary Tag: Visual edit
- 17:3017:30, 21 December 2022 diff hist +128 Main Page No edit summary Tag: Visual edit
19 December 2022
- 12:4312:43, 19 December 2022 diff hist −1 Web App No edit summary Tag: Visual edit: Switched
- 12:4112:41, 19 December 2022 diff hist +176 XERO addserver No edit summary current Tag: Visual edit
- 12:3912:39, 19 December 2022 diff hist −3 XERO Xero Support No edit summary Tag: Visual edit
- 12:0612:06, 19 December 2022 diff hist +113 XERO Xero Support No edit summary Tag: Visual edit
21 October 2022
- 12:2112:21, 21 October 2022 diff hist −43 Scripting No edit summary current Tag: Visual edit
- 12:2012:20, 21 October 2022 diff hist +115 N Web App Created page with "The web application is available at https://data.crmtogether.com/ Register here or log on with your credentials" Tag: Visual edit
- 12:1912:19, 21 October 2022 diff hist +19 MediaWiki:Sidebar No edit summary
- 12:1812:18, 21 October 2022 diff hist +2,150 N Get Started Created page with "<b>Welcome to the Data Islands Help</b> ''-What is Data Islands?'' Data Islands is an online service that allows you to securely create Micro Data Warehouses and manage access to that Data. ''-What is a Micro Data Warehouses?'' A Micro Data Warehouses is a collection of datasets that contain small amounts of data fed from your "Data Silos" EG: databses (MSSQL, MySQL,Postgres), CSV and XERO api. -''Why would I need a Micro Data Warehouses?'' Its a great way to prote..." current Tag: Visual edit
- 12:1812:18, 21 October 2022 diff hist +3 MediaWiki:Sidebar No edit summary
- 11:4711:47, 21 October 2022 diff hist +91 N Update Created page with "'''Syntax''' : update <ENTER> Description : Check and Download new version (if available)." current Tag: Visual edit
- 11:4711:47, 21 October 2022 diff hist +68 N Version Created page with "Syntax : version <ENTER> Description : Get the application version." current Tag: Visual edit
- 11:4711:47, 21 October 2022 diff hist +77 N Clear Created page with "'''Syntax''' : clear <ENTER> Description : Clears the command prompt screen." current Tag: Visual edit
- 11:4711:47, 21 October 2022 diff hist +103 N Removeuser Created page with "'''Syntax''' : removeuser <USERNAME> <ENTER> Description : Remove a user's access from current region." current Tag: Visual edit
- 11:4611:46, 21 October 2022 diff hist +197 N Adduser Created page with "'''Syntax''' : adduser <USERNAME> <ACCESS SCOPE> <ENTER> Description : Add a user to allow access the current region. Premissions are controlled by passing access scope as "read" or "readwrite"." Tag: Visual edit
- 11:4611:46, 21 October 2022 diff hist +110 N Access Created page with "'''Syntax''' : access <ENTER> Description : List of user list with their level of access (read or readwrite)." current Tag: Visual edit
- 11:4511:45, 21 October 2022 diff hist +87 N Deleteisland Created page with "'''Syntax''' : deleteisland <ISLANDNAME> <ENTER> Description : Deletes a given island." Tag: Visual edit
- 11:4511:45, 21 October 2022 diff hist +91 N Clearisland Created page with "'''Syntax''' : clearisland <ISLANDNAME> <ENTER> Description : Clear the given island data." current Tag: Visual edit
- 11:4511:45, 21 October 2022 diff hist +135 N Deleteregion Created page with "'''Syntax''' : deleteregion <ENTER> Description : Deletes the current region. The will only work when then region has no data islands." current Tag: Visual edit
- 11:4411:44, 21 October 2022 diff hist +443 N Addregion Created page with "'''Syntax''' : addregion <REGIONNAME> <PUBLIC/PRIVATE> "<DESCRIPTION>" <ENTER> Description : To add/checkout a container region which will contain our data islands. We can also give 'public' parameter to create region with public access. If we wants to give description of new or existing region, then we need to enter text in double quotes. If we wants to make region private, then we can use 'private' parameter while checkout region." current Tag: Visual edit
- 11:4411:44, 21 October 2022 diff hist +219 N Deleteserver Created page with "'''Syntax''' : deleteserver <INDEX> <ENTER> eg.deleteserver 1 Description : Delete a SQL/MYSQL/POSTGRESQL/CSV/XERO server from connection list. ----use the >servers command to get the index of the server connection" current Tag: Visual edit
- 11:4311:43, 21 October 2022 diff hist +46 Describe No edit summary current Tag: Visual edit
- 11:4211:42, 21 October 2022 diff hist +34 Describe No edit summary Tag: Visual edit
- 11:4211:42, 21 October 2022 diff hist +104 N Describe Created page with "'''Syntax''' : describe <TABLENAME> <ENTER> Description : List of all column names of given table name." Tag: Visual edit
- 11:4211:42, 21 October 2022 diff hist +128 N Dbtables Created page with "'''Syntax''' : dbtables <ENTER> Description : Lists all of our database tables in the current server added through 'addserver'." Tag: Visual edit
- 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." current 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." current 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
