Category Archives: Galaxy tip and tricks

SingularLogic Galaxy tip and tricks

Simple Order System with Office 365 SharePoint and Galaxy – Part 2

Posted on by

In the previous article we saw how to connect to a database access with Sharepoint and shape the tables needed to implement the ordering.

In this article we will see how to create the forms and macros will introduce them to various processes

We start with Customers Form

To add a Details table to the main table picking out the ribbon tools the Related Items Control and choose plus symbol and choose detail table that you want to show.

To add extra fields choose textbox and label controls and connect fields from table you want.

Customers

Do same things for Suppliers Form

Suppliers

Continue reading →

Simple Order System with Office 365 SharePoint and Galaxy – Part 1

Posted on by

In this blog post we make a simple order system for oursΒ sellers that work in any device (desktop and mobile) and operating system (android, iOS,Windows mobile and desktop) with web browser step by step with Office 365 SharePoint and SingularLogic Galaxy.

Prerequisites are Office 365 SharePoint 2013 , Install Access web app from Office365 Store in SharePoint site , SingularLogic Galaxy and Office 365 Pro

First you must made export actions from SingularLogic GalaxyΒ  to Access Web app , you can use User Actions or dll Entities.

Links below use user actions inside SingularLogic Galaxy , are very simple and must use your imagination to make them better….

Don’t forget to change Sql Server connections strings in code with that you receive from yours access web app that you see below, and guid for Fiscal Year in sql statements.

Export Customers

Export items

Export Suppliers

Export Transactions

Continue reading →

Create extra DataObject in Sharp-Shooter in Galaxy

Posted on by

In this thread we will see how can create an extra DataObject to ours sharp shooter report in Galaxy
Suppose that we want to make labels and repeat them any times that we want
First off all we must make a standalone filter in Report Designer , named that fAntitypa
After that in design of Sharp Shooter :

In Import property of Document properties insert below references
SLnet.Base.Interfaces
SLnet.Sand.Base.Views
SLnet.Sand.Schema

After that write below script in General Script property

Continue reading →

Tips & Tricks – How connect with Facebook and Twitter from Galaxy

Posted on by
In this post we learn how we can connect with ours friends in Facebook and Twitter within Galaxy


Choose CRM Setup / Contacts / Social Account


Here you can create your social account but first you must create a facebook app atΒ https://developers.facebook.com/appsΒ or a twitter app atΒ https://dev.twitter.com/Β Β and fill proper fields in Social Account



Continue reading →

Tips & Tricks – How get all days of range even no values present

Posted on by
In this post we learn how we can get all days of range even no values present in these days
For example we get for a range of days balance of stocks even no transaction made in some of days in range
Β 
Sql that return values for above sample is below
Β 
with cte as
(
select dte = CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103)
union all
select DATEADD(dd,1,dte) from cte where dte < CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103))
select CONVERT(nvarchar,cte.dte,103), GXITEM.GXCODE ITEMCODE,GXITEM.GXDESCRIPTION,GXWAREHOUSE.GXCODE WAREHOUSECODE ,
dbo.GXGETITEMSUMDATEWRHSSTTP(GXITEMCOMPANYPROP.GXITEMID,’743D7942-4CCB-474B-B140-06011F6795CC’ ,cte.dte,’Bal_A’,
GXWAREHOUSE.GXID,’585BA65A-3BF4-426B-A7B7-B7F0C007BF52′) BALANCE
FROM cte,GXWAREHOUSE,
GXITEMCOMPANYPROP inner join GXITEM ON GXITEMCOMPANYPROP.GXITEMID=GXITEM.GXID
WHEREΒ 
(
GXITEMCOMPANYPROP.GXITEMID in (select GXITEMACCUM.GXITEMID FROM GXITEMACCUM WHEREΒ 
GXITEMACCUM.GXDATE>=CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103) AND GXITEMACCUM.GXDATE<=CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103)
AND GXITEMACCUM.GXWRHSID=GXWAREHOUSE.GXID )
or
dbo.GXGETITEMSUMDATEWRHSSTTP(GXITEMCOMPANYPROP.GXITEMID,’743D7942-4CCB-474B-B140-06011F6795CC’ ,CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103),’Bal_A’,
GXWAREHOUSE.GXID,’585BA65A-3BF4-426B-A7B7-B7F0C007BF52′)<>0)
@where
ORDER BY GXITEM.GXCODE,CTE.dte

Let’s see some part of sql command
Β 
Β 
with cte as
(
select dte = CONVERT(datetime,SUBSTRING(CAST(‘@DateFrom’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateFrom’ AS VARCHAR)) – 1),103)
union all
select DATEADD(dd,1,dte) from cte where dte < CONVERT(datetime,SUBSTRING(CAST(‘@DateTo’ AS VARCHAR),1,CHARINDEX(‘ ‘, CAST(‘@DateTo’ AS VARCHAR)) – 1),103))

Tips & Tricks – How enabled Messenger in Galaxy

Posted on by
To enableΒ MessengerΒ in Β GalaxyΒ applicationΒ takes 3Β steps

1. Go toΒ C:\Galaxy\Config\MessengerΒ 
Β  Β  OpenΒ theΒ fileΒ Messenger with notepad .ModifyΒ these 2Β lines

Β  Β  True
Β Β Β  http://compkos-pc:11090/Messenger


Β  Β ForΒ compkos–pcΒ write theΒ name of yoursΒ GalaxyΒ Server

2.Β Login in Galaxy applicationΒ and selectΒ 
Β  Β  SettingsΒ / Installation
Β  Β  SelectΒ MessengerΒ address field andΒ put theΒ addressΒ thatΒ you specifiedΒ above.

3.Β ChooseΒ fromΒ theΒ Widgets toolbarΒ Β MessengerΒ and ifΒ other usersΒ activate theΒ MessengerΒ on their desktop chooseΒ anyone you wantΒ and startΒ theΒ conversation

Note : To see yours messages the user that you choosed Β , he must choose in Messenger widget you and open dialog chat windowΒ 

Happy chat !