2020年10月4日 星期日

c

 #!/bin/sh

if [ls /var/atlassian/application-data/confluence/index/plugin/usage -lR|grep "^-"| wc -l ] = 13

then

rsync -av /var/atlassian/application-data/confluence/index/plugin/usage/* /home/anderson/index

mv /home/anderson/index/home/anderson/indextest

else

rsync -av /var/atlassian/application-data/confluence/index/plugin/usage/* /home/anderson/index

mv /home/anderson/index /home/anderson/indexok

fi


2020年10月3日 星期六

excel and linux command

 https://ithelp.ithome.com.tw/questions/10200008


https://dotblogs.com.tw/chou/2011/10/24/46165

copy

 SELECT sp.permid, sp.permtype, s.spacekey, s.spacename, sp.permgroupname, um.user_name

FROM SPACEPERMISSIONS sp

JOIN SPACES s ON sp.spaceid = s.spaceid

LEFT JOIN cwd_user um ON sp.permusername = um.user_name

2020年10月1日 星期四

do

 https://confluence.atlassian.com/confkb/how-to-list-which-spaces-a-group-can-access-720636535.html


If my understanding is correct, one way to do is to create a shell script, this is when Confluence is running as service:

cat confluence_auto_start.sh
#!/bin/bash

# stop Confluence
sudo /etc/init.d/confluence stop

# wait for 5 minutes
sleep 5m

# start Confluence
sudo /etc/init.d/confluence start

Now, execute this shell script in the background using nohup as shown below. This will keep executing the script even after you logout from your session. You'll need system administrator permissions in order to edit and manually run jobs and start/stop CConfluence using the Confluence user.

 Please keep note that support for cronjobs/scheduling tasks falls outside the scope of our Support Offerings, so our exposure to it is limited and we suggest you try them in your test environment first.

Please let us know if you have any questions. 

sample

Imports Microsoft.VisualBasic

Imports System.Data

Imports System.Data.SqlClient

Imports Npgsql

Imports NpgsqlTypes

Partial Public Class Udf 

 Public Shared Function eipConnectionString() As String

        '資料庫連線字串

        Dim connString As String = ConfigurationManager.ConnectionStrings("researchConnectionString").ConnectionString

        Return connString

    End Function

    Public Shared Function checkid(ByVal iNumber As String) As String

        '(0:預約 1:未審核 2:審核過  3:第一階段)

        Dim tempValue As String = String.Empty

        Select Case iNumber

            Case "President"

                'A0_經營理念

                tempValue = " Wang"

                Exit Select

           

        End Select

        Return tempValue

    End Function

2020年9月28日 星期一

iii

 https://lawrencetech.blogspot.com/2012/10/aspnetexcel_18.html



如果你 html 完整,全選複製存成 .htm 後,用 IE 看。

大部分這類文件,通常是被防毒軟體移除 Mail Header 的部分,導致 Mail Client 無法正確解碼,又或是 Mail Body 沒有依據 RFC 標準,僅有 HTML Body ,部分 Mail Server 會使用此規則將該信件標示為 spam。



https://ektron0116.neocities.org/software/WindowsApplication1.zip

outlook

 如果你 html 完整,全選複製存成 .htm 後,用 IE 看。

大部分這類文件,通常是被防毒軟體移除 Mail Header 的部分,導致 Mail Client 無法正確解碼,又或是 Mail Body 沒有依據 RFC 標準,僅有 HTML Body ,部分 Mail Server 會使用此規則將該信件標示為 spam。