Posted on

Email etiquette

Thanks for the quick reply.

Thanks for getting back to me.

Thanks for the update on the situation.

Thanks for the updated information

Thanks for gathering the information this week on this issue.

Sorry I haven’t got back to you sooner.

Sorry for the delay getting back to you.

Apologies for the late/short notice.

I apologize if this was not made clear.

Please let me know what you think.

Please let me know your thoughts.

Let me know if you have any questions or concerns.

Please let me know if there aer questions.

Looking forward to your input/insight

pass me the email

get back to you

Attached/Enclosed please find the report.
I attached teh report and let me know what you think.

Hi Mike,
My name is Jenny, I work in the R&D department and am in charge of …

Justt to chime in, xxxxx

issue

Let’s discuss all the bullet points tomorrow.

This issue needs to be addressed.

At your convenience, would you please send me…
Thank you for your assistance.

Our team would appreciate your insighgts
Due to the short time frame for this proposal, promt reply is greatly appreciated.

I want to mindful of your time and we don’t have any updates at this point; therefore I suggest that we cancle /reschedule today’s meeting. if you disagree or need assistance ,please let me know.

My appologies for the late notice, but I need to reschedule tomorrow’s call. There remain a few open itemswe need to address, therefore I will send a new invited once we agree upon a time.

Hope this answers your question.Let me know if further detail/explanation would be helpful.

My sincere apology for this unfortunate situation.I will address to my team immediately.Again, please accept my most sincere apology.

Attached is the drafted xx file. It is still a work in process but I would like to see if anything immediately stood out to you as odd or worthy of follow-up.

Thank you for your email. I will be out of the office on vacation from xx-xx witho no access to emails. I apologize for any delay in response to your email.I will respond to your email as quickly as I can when I return to the office on XXX thanks.

We would appreciate it if you could send us the business proposal at your earlier convenience.

We will do this the first thing /on the top priority tomorrow morning.

I will be generally available next week.

I will get back to you by COB tomorrow.

Please drop me a call or email when you have time.

Your early response is much appreciated.

Could you kindly let me know…

Sorry for my late reply.

Begin the email.

I hope you are well.

I am writting to inquire about xxx

I would be grateful if you could xxx

I would appreicate your help

Please let me know should you have any further question

Your promt repsonse on this will be highly appreciated.

As I mentioned earlier…

As I indicated in my previous email…

As you request..

We would be grateful if you could ..

I could apprecaite if you could …

Your prompt atention to this matter wil be apprecaited.

I would really appreciate meeting up if you can spare tem time. Please let me know what suits you best.

Please let me know if there’s anything I can do to help.

Attached hereto..

Please find enclosed …

I hope my clarification has been helpful.

Please let me know if this is suitable.

Posted on

React Native map ios

Installation
First, download the library from npm:

npm install react-native-maps --save

package.json

"dependencies": {
"react": "15.4.2",
"react-native": "0.41.2",
"react-native-chart": "^1.0.8-beta",
"react-native-check-box": "^1.0.4",
"react-native-checkbox": "^1.1.0",
"react-native-dropdown": "0.0.6",
"react-native-elements": "^0.9.7",
"react-native-maps": "^0.14.0",
"react-native-menu": "^0.20.2",
"react-native-pathjs-charts": "0.0.25",
"react-native-scrollable-tab-view": "^0.7.2",
"react-native-slider": "^0.9.1",
"react-native-swipeable": "^0.3.2",
"react-native-swipeout": "^2.0.12",
"react-native-swiper": "^1.5.4",
"react-native-tab-navigator": "^0.3.3",
"react-native-vector-icons": "^4.0.0",
"rnpm": "^1.9.0"
  },

possible error might be 

TransformError: xxx/.js Unknown plugin "module-resolver" specified in "xxxxx/react-native-maps/.babelrc" at 0, attempted to resolve relative to "xxxxxx/react-native-maps"

to solve this error above:

npm install --save-dev babel-plugin-module-resolver
npm cache clean

close the package windows or the cmd windows,then start it again

react-native run-ios

this problem might be removed

then follow the manual option as below:

Option 3: Manually

  1. This was already done for you if you ran “react-native link”
  2. Open your project in Xcode, right click on Libraries and click Add Files to “Your Project Name” Look under node_modules/react-native-maps/lib/ios and add AIRMaps.xcodeproj.
  3. Add libAIRMaps.a to `Build Phases -Link Binary With Libraries.
  4. Click on AIRMaps.xcodeproj in Libraries and go the Build Settings tab. Double click the text to the right of Header Search Paths and verify that it has $(SRCROOT)/../../react-native/React as well as $(SRCROOT)/../../react-native/Libraries/Image - if they aren’t, then add them. This is so Xcode is able to find the headers that the AIRMaps source files are referring to by pointing to the header files installed within the react-native node_modules directory.
  5. Whenever you want to use it within React code now you can: var MapView = require(‘react-native-maps’);

then you might notice this error

iOS build failed RCTConver+Mapkit.o RCTConvert+Mapkit.m

to solve this problem, just delete the RCTConver+AirMap.h RCTConvert+AirMap.m
this problem might be caused by the rename of files

in Xcode open libraries -right click AirMaps.xcodeproj -add file to AirMaps -go to find react-native-maps into node_module -lib -ios -AirMaps -select RCTConvert+MapKit.h/m -add (to fix ‘File RCTConvert+MapKit.m not found’).
then make suer this step

libAirMaps.a to the Link Binary With Libraries

then clean and build the product
then 

npm install rnpm
react-native link

then

xcode->product->clean->build

All this above is the way to install map based on iOS map not Google Map.
As a result, the api of google map is not mentioned above!

Posted on

Some cmd of React Native

npm install
npm cache clean

these two above are very useful!

react-native log-android
react-native log-ios

these two above are userful for debug

adb devices
adb kill-server

these two above are useful for server and device

to be continued

Posted on

How to remove node module after install it?

Here are different options:

npm uninstall <name> removes the module from node_modules, but not package.json

npm uninstall <name> --save also remove from dependencies in package.json

npm uninstall <name> --save-dev also remove from devDependencies in package.json

npm -g uninstall <name> --save also remove it globally

Posted on

nopcommerce 3.3 newsletter image display bugs

在Edit Campaign 编辑邮件发送后，发现插入的图片不能在测试邮箱（gmail，qq等显示），原因是插入的图片url被富文本剪辑器缩减成了相对地址，在发送出去之后无法link到图片地址
即：

http://microanalytixau.edev.co.nz/Content/images/uploaded/logo.gif

被缩减成为

/Content/images/uploaded/logo.gif

同时，插入的link也被缩减。
官方显示解决方案为升级为3.4版本，以下为不升级版本的解决方案。
解决问题如下

  1. find the under the path:\www\Content\tinymce\tinymce.min.js
  2. change the the js” remove_script_host:!1”
  3. save

Posted on

nopcommerce3.3 newsletter

需要添加subscribe按钮到邮件正文中。当前邮件可以允许使用的token如下 

%Store.Name%, %Store.URL%, %Store.Email%, %NewsLetterSubscription.Email%, %NewsLetterSubscription.ActivationUrl%, %NewsLetterSubscription.DeactivationUrl%

其中，

%NewsLetterSubscription.ActivationUrl%, 为subscribe
%NewsLetterSubscription.DeactivationUrl% 为unsubscribe

可以在正文中输入文字click here 再插入link

但是，由于进行了相对引用和绝对引用的修改，此处的

%NewsLetterSubscription.DeactivationUrl%

在发送出去的邮件正文中显示出了

http://microanalytix.co.nz/http://microanalytix.co.nz/edit%NewsLetterSubscription.DeactivationUrl%

所以需要对富文本编辑器再进行修改

路径如同上一篇日志，修改js中“convert_urls”为！1
此修改禁止了该富文本编辑器对url的增加或者删除功能。

在此之后进行insert link需要对source code进行check以保证正常显示

Posted on

nopcommerce 3.3 local database connect

在local machine 安装了nopcommerce3.3的no source 环境（即将线上文件放在本地IIS 环境www下），同时将线上数据库进行backup，在本地恢复后。
恢复步骤

  1. 点击任一数据库右键，选择还原数据库
    新建名称，点击 源设备，添加文件，勾选文件，进行还原。
  2. 修改数据库连接：App_Data\setting.txt
  3. 在本地数据库执行：SqlServer.StoredProcedures.sql
    执行方式，在sql serve 2008 连接本地数据库后，
  4. 在该数据库MicroAnalytix中新建查询
  5. 打开文件，打开SqlServer.StoredProcedures.sql文件，将内容复制粘贴到新建查询中，为了防止可能出现的问题，全选该sql语言，然后进行执行。
    若不执行2，可能在localhost环境下进行global setting的测试会出现错误。

Posted on

How to install IIS in WIN7
=
由于nopcommerce需要 IIS 下进行发布，所以在win7环境下设置IIS 环境

1.打开控制面板，打开Windows功能

2.选择打钩

3再次进入控制面板，选择管理工具，若在控制面板没有找到管理工具，则搜索管理工具，双击如图所示

4点击 Internet信息服务（IIS）管理工具，打开运行，如果已经有默认网站，建议删除，然后在点击xxx-PC添加网站



然后对目前的网站进行重启

现在只是搞定了IIS环境，接下来进行ASP.NET环境搭建
5.控制面板–系统和安全–管理工具–Internet信息服务（IIS）管理器，打开IIS管理器。选中左侧的默认网站（也就是“Default Web Site“这个网站），单击右侧的高级设置，将应用程序池设置为Classic.NETAppPool。

单击左侧的“应用程序池”

中间会出现如下图所示：



将标识改为localSystem或NetworkService。

Posted on

nopcommerce 3.3 use Python to address product related

# ~*~ coding:utf-8 ~*~
#csv是一个读取csv文件的lib
import csv
#itertools生成组合和排列的lib
import itertools
#pyodbc是连接ms sql server的lib
import pyodbc
#cnxn是数据库连接  更改数据库连接方式，账号密码
cnxn = pyodbc.connect(DRIVER='{SQL Server Native Client 10.0}',SERVER='localhost',DATABASE='MicroAnalytix',UID='sa',PWD='密码')
#cursor是数据库浮标
cursor = cnxn.cursor()

#主方法
def process():
    #读取csv，转换成list 更改文件存储位置
    reader = list(csv.reader(open("c:/Users/Jenny/Desktop/related.csv")))
    #遍历数据，并处理， tips：跳过第一行
    for i in reader[1:]:
        #Cn2产生组合
        for j in itertools.combinations(i,2):
            #处理产生的Cn2组合
            recommend(j)
def recommend(j):
    #产生两次相互推荐
    genRec(j[0],j[1])
    genRec(j[1],j[0])
def genRec(a,b):
    #分别通过sku获得Product的Id
    aid = getIdFromSku(a)
    bid = getIdFromSku(b)
    #生成写RelatedProduct表的sql语句
    sql = "insert into dbo.RelatedProduct (ProductId1,ProductId2,DisplayOrder) values(%d,%d,%d)" % (aid,bid,0)
    #执行sql语句
    cursor.execute(sql)
    #提交事务
    cnxn.commit()
def getIdFromSku(a):
    sql = "select Id from dbo.Product where Sku='%s'" % a
    print sql
    cursor.execute(sql)
    row = cursor.fetchone()
    if row:
        return row[0]


if __name__ == "__main__":
    process()

Posted on

nopcommerce source code version install tips

  1. click the file “CodeFirstInstallationService’’ and save .
    the path is libraries\nop.services\
  2. start with
    presentation\nop.web check in the browser
  3. nop.web/app-data/ to display all files，then open setting.txt，update the database