bar code reader & generator

help me to generating bar code & Barcode reader.

Changed type Barry Wang Monday, September 10, 2012 10:06 AM
Moved by Forrest Guo Wednesday, September 19, 2012 8:27 AM (From:.NET Framework Setup)

Reply:

This forum supports .NET Framework installation and setup.

As it appears that you have a software development question, please ask in a topical developer forum. The developer forums are organized by programming language, so choose the link below that applies to you.

For VB: http://social.msdn.microsoft.com/Forums/en-US/category/visualbasic

For C#: http://social.msdn.microsoft.com/Forums/en-US/category/visualcsharp

For C++: http://social.msdn.microsoft.com/Forums/en-US/category/visualc

------------------------------------
Reply:

Hi Maninder Sandhu,

Thanks for your post.

I'm not sure what does "bar code" or "Barcode reader" mean. Could you please describe it?

Regards,

Barry Wang [MSFT]
MSDN Community Support | Feedback to us

Edited by Barry Wang Monday, September 3, 2012 8:19 AM

------------------------------------
Reply:

Change the status to "General Discussion"
We are changing the issue type to "General Discussion" because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to "Question" by editing your initial post and click the button "Change Type" at the top of the post. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

Regards,

Barry Wang [MSFT]
MSDN Community Support | Feedback to us

------------------------------------

header and page number on title page

why does my header and page number keep disappearing from my title page?

Reply:

check this link this may help you out

http://office.microsoft.com/en-us/training/header-and-footer-basics-RZ010239449.aspx?section=2

------------------------------------

Windows Problem

Good morning, I bought a program called Sage Peachtree for a small bussines and I get a sign in error saying this and I have to choose between two answers "YES or NO":

- File :/ / / C :/ Program% 20Files% 20 (x86) / Sage / Peachtree / ProductServices / WhatIsNew / functions.js

and then I get this another sign:

Assertion Failed: Abort, Retry or Ignore.

Sage Peachtree I call them and they tell me that it is a Windows problem and I do not know what to do? I appreciate the help or give me answer.

Moved by Hasham Niaz Friday, September 7, 2012 5:50 AM Moving to more appropriate Forum (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
Changed type Kim Zhou Wednesday, September 19, 2012 12:07 AM

Reply:

Hi,

The information for the problem is not enough. Could you collect the screenshot of the whole error message please?

Kim Zhou

TechNet Community Support

------------------------------------

help need for biztalk map

Hi experts,

This is my input ,

expectd output:

if ype =2 then

based on on type in input ype i want to generate the output.

if type =2 then

please help me someone ,

Changed type LeoTangModerator Tuesday, September 18, 2012 9:35 AM

Reply:

You can use the logical functoid Equal along with the value mapping functoid to do it for an example refer to the article.

Please mark the post answered your question as answer, and mark other helpful posts as helpful, it'll help other users who are visiting your thread for the similar problem, Regards -Rohit Sharma (http://rohitt-sharma.blogspot.com/)

------------------------------------
Reply:

hi rohit ,

alredy i tried with with valumaping , equl type=2 it is not working .

thanks

------------------------------------
Reply:

Can you share the screen shot of the map or its XSLT

------------------------------------
Reply:

Hi rohit , please find my xslt in scrpit

but it doent loop as per condition,

<xsl:template name="ents">

<xsl:param name="ms"/>

<xsl:element name="m"
<xsl:if test="@ype = '2'">
<xsl:element name="typeofclaim">
<xsl:value-of select="@ype"/>
</xsl:element>
<xsl:element name="date"
<xsl:value-of select="@Date"/>
</xsl:element>

</xsl:template>

------------------------------------
Reply:

Your input seems incorrect to me

<ms>   <Type="1" Date="2014-04-01" nce="5" r="1" nt="0" />   <Type="1" Date="2012-01-01" nce="4" r="1" nt="0" />   <ype="2" Date="2012-05-02" nce="6" r="2" nt="50" />  </ms>

Should not it be something like below:

<ms>   <Type Date="2014-04-01" nce="5" r="1" nt="0">1</Type>   <Type Date="2012-01-01" nce="4" r="1" nt="0">1</Type>   <Type Date="2012-05-02" nce="6" r="2" nt="50">2</Type>  </ms>

or something like.

<ms Type="1" Date="2014-04-01" nce="5" r="1" nt="0" />  <ms Type="1" Date="2012-01-01" nce="4" r="1" nt="0" />  <ms Type="2" Date="2012-05-02" nce="6" r="2" nt="50" />

Verify it or share the schema.

------------------------------------
Reply:

my input file is likethis

------------------------------------
Reply:

Share the input schema.

------------------------------------
Reply:

<ms1>

</ms1>

------------------------------------
Reply:

<ms1>

  <ms Type Date="2014-04-01" nce="5" r="1" nt="0">1</Type>
          <msType Date="2012-01-01" nce="4" r="1" nt="0">1</Type>
          <msType Date="2012-05-02" nce="6" r="2" nt="50">2</Type>

</ms1>

I want to check your .xsd file share the content of this file this is the input instance.

------------------------------------
Reply:

BUT HERE NO DEPENDESIES ON SCEMA,

IT S FULLY BASED INPUT FILE .

------------------------------------
Reply:

It would be easier to provide you solution based on that XSD file because I am seeing few variation in the input share by you.

------------------------------------
Reply:

HI,

BUT IT IS FULLY DEPEDNT ON ONLY INPUT FILE.

------------------------------------
Reply:

In BizTalk you need to create the schema for the Input file so that the message can be parsed/validated by the receive pipleine. So how was you creating the map?

------------------------------------
Reply:

ACTUALLY WE TAKE STANRD INPUT SCHEMA , INPUT FILE DYNAMIC FOR MY MAP

------------------------------------
Reply:

Can you just copy the part of the schema representing this record and paste here.

------------------------------------

Calculate percentage based on total

Hi, I have a financial cube that requires percentage of revenue for each account based on the grand total revenue (all accounts) for the period selected to be shown next to the account in the report. I'm sure this can be done through MDX but not sure how and how should I be creating this measure. Would the MDX query go in the calculation section of the SSAS cube? Can someone help me with the query please?

Appreciate your help.

Siva,

Reply:

Hi Siva,

you should create a calculated measure in MDX script:

CREATE MEMBER CurrentCube.Measures.RevenuePercentage AS  (Accounts.Acount.CurrentMember, Measures.Revenue) / (Accounts.Account.All, Measure.Revenue),  Format_String = 'Percent';

Additionally, add logic for handling division by zero using: iif( denominator = 0, null, numerator / denominator ).

Hope it helps or gives an idea,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

------------------------------------
Reply:

Thanks. I spent a half day trying to figure this it did give me direction but can't get it to work unfortunately!!! I need an MDX lesson!!

Anyway this is what i got

([DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember,[Measures].[Amount]) / ([DimTransactionTypeAccount].[Report - Account - Transaction].[(TransactionType)].[ALL], [Measures].[Amount]) it says it can't find TransactionType. I need the percentage to be based on the TransactionType level total not (ALL) like the example you've given. How do I do this?

The hierarchy is like below
Report - Account - Transaction
- Report Type
   - Account Type
     - Transaction Type
       - Account

I need to calculate the percentage for the account (not account type) based on the total from TransactionType.

Any help please???? Thanks

------------------------------------
Reply:

Siva,

next time just post again, together we can solve it much faster.

Ok, the new information you provided makes a difference.

( [DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember,   [Measures].[Amount] )  /  Aggregate( [DimTransactionTypeAccount].[Report - Account - Transaction].[Transaction Type].MEMBERS,   [Measures].[Amount] )

Hope this is it what you need. At least it should give you a direction. Possible modifications are Aggregate->Sum or TransactionType->Account (level name).

PS: Change your thread from discussion to question.

Regards,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

------------------------------------
Reply:

Tomislav,
Just thought I'll figure it out, agree next time I'll post here. So here I am posting :)

The expression you gave is calcualting the percentage on the overall total. I need it to be like this

- Report Type                       (Percent total of all account types)
      - Account Type               (Percent total of all transaction types)
          - Transaction Type      100% <----
                 - Account             xx%

Where as now I'm getting 100% on the report type, its taking the grand total and calculating the percentage instead of taking the Transaction Type subtotal and calculating the percentage for account based on that!!

About making it a question I'm not sure how to do that sorry.....

Thanks again for your help.

------------------------------------
Reply:

Just to give a little more information this is what I want but this is hard corded to get the total for one transaction type how do I make it dynamic so the total would be calculated automatically at each transaction type

( [DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember,
[Measures].[Amount] )
/
SUM( [DimTransactionTypeAccount].[Report - Account - Transaction].[Report Type].&[P & L].&[Income].&[020],
[Measures].[Amount] )

Thanks in advance

------------------------------------
Reply:

Ok, let me see.

You want a ratio. The upper part is most probably all right. The lower part not. It would be, though, if I'd figured out what is it you want exactly.

In the title it say total, but that's not it. The first MDX proved to be wrong.

Next you said you needed a total on Transaction Type level. The MDX provided also didn't work. Terminology? Maybe you were refering to the parent of current member, the one above the current member? Your last two posts describe something like that. Parent's share? On each level? We haven't tried that so far: "total" is "parent" and you want a percentage of parent working on each level?

Here's another shot:

( [DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember,   [Measures].[Amount] )  /  ( [DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember.Parent,   [Measures].[Amount] )

There can be improvements if this is what you need. First, handle division by zero by checking denominator for zero. Next, reference to a parent might cause an error if used on All member. That again can be handled as 1 with another iif or by providing a bit different syntax - using Ancestor() function.

If you need further assistence (and this proves to be the solution you need), feel free to ask again.

PS: Nevermind the change from discussion to question. Moderators will take care of that.

Regards,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

------------------------------------
Reply:

Great!!! Parent is the magic syntax I've been looking for. I really really appreciate your help thank you very much, in fact I think I've learnt quite a bit of MDX syntax in the last few days :)

Thanks again.

------------------------------------
Reply:

Hi Tomislav , I was reading your blog and I must say that you do have a deep knowledge on this stuff, therefore I believe you can answer my question which is originally related to your above answers

You know in Excel and in OWC we do have a functionality of 'Show as % of Column', 'Row' or Total , it was such a cool thing and only available for OWC OLAP component browser, problem is we have a cube built in 2008 analysis server but we are not browsing this cube in OWC any more we are using Dundas Chart controls and we are missing the show as percentage features, I wonder is there any possibility of creating those 'calculated measures' in the cube so we can browse them by any front end.

I must say that those calculated measures must not depend on any dimension or an hierarchy, it should be dynamic and can be calculated by self on the fly based on current dimensions on the plate.

Thanks

Nizar

------------------------------------
Reply:

Hi Nizar,

take a look here, maybe it will help you. Others? Some day ...

Regards,

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

------------------------------------
Reply:

Hi Tomislav,

I just wanted to let you know how helpful I found this thread and your input. Thank you. :)

Regards,

Michelle

Michelle Ufford | SQLFool.com | Please mark solved if I've answered your question :)

------------------------------------
Reply:

Hi Michelle,

it's always nice to see feedback, especially one related to an older solution. It encourages me to keep up with what I do. Therefore - thank you for support!

Tomislav Piasevoli
Business Intelligence Specialist
www.softpro.hr

------------------------------------
Reply:

Parent has helped me and was what I was looking for. I'm using SSAS 2008. Thank you very much.

------------------------------------
Reply:

Hi, I have a financial cube that requires percentage of revenue for each account based on the grand total revenue (all accounts) for the period selected to be shown next to the account in the report. I'm sure this can be done through MDX but not sure how and how should I be creating this measure. Would the MDX query go in the calculation section of the SSAS cube? Can someone help me with the query please?

Appreciate your help.

Siva,

Just found this thread, I think it would help me as well as I am looking into how to get subtotal, percentage in a cube with many dimensions such as a few named below.

Measure: Sales$

Dimensions:

Country>State-City

FiscalYear->FiscalQuater->FiscalMonth-FiscalWeek

ProductCaegory->ProductSubCategory->Product

and more

I need to be able to add a calculated field of percentage of subtotal sales$ /Total $

Being totally new to MDX, I think I will find this post helpful as I am poking into it.

If you can help me getting started, that would be greatly appreciated.

thanks in Advance

------------------------------------
Reply:

In the example above, the syntax is :

( [DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember,
   [Measures].[Amount] )
  /
  ( [DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember.Parent,
   [Measures].[Amount] )

In my case,the naming of the my hierarchy is causing problem. For example, above example has

[Report - Account - Transaction]

my dimension has something like [The report] - [The Account] - [The Transaction] , I am just making up the names here to go with the example. basically my dimension names have a space in it. so instead

[DimTransactionTypeAccount].[Report - Account - Transaction].CurrentMember

I have

[DimTransactionTypeAccount].[The Report] - The Account - Transaction].CurrentMember

it is not working for me.

Can you help?

Many thanks !

------------------------------------
Reply:

[Report - Account - Transaction]

I replace it with [Hierarchy]

It worked !

------------------------------------
Reply:

Hi Thomislav,

I dont know how to work in MDX and i have a requirement as follows:

PLEASE HELP ME, If question is not clear let me know.

the issue is related to this kind of measures, when doing an Aggregation the result is not what we expect (like total of Months, the Aggregation is not coming correctly).

Please check this example:

Measure	Center	Region	Market	10-Nov	10-Dec	11-Jan	11-Feb	Total
PF322 Rate	GCS Unallocated	JAPA	Australia	100.00%	100.00%	100.00%	98.80%	99.70%
			Hong Kong	100.00%	100.00%	100.00%	100.00%	100.00%
			India	103.30%	103.20%			103.25%
			Japan	100.00%	100.00%	100.00%	100.00%	100.00%
			Newzealand	100.00%	100.00%	100.00%	100.00%	100.00%
			Singapore	100.00%	100.00%	100.00%	100.00%	100.00%
			Taiwan	100.00%	100.00%	100.00%	100.00%	100.00%
			Thailand	100.00%	100.00%	100.00%	100.00%	100.00%
			Total	100.79%	100.79%	100.00%	99.68%	100.38%

The feedback from the business related to that grid was:

1. YTD (Total of all months in the grid) value should be for the Year 2011 starting from Jan to Dec. Averaging for the 4 months may not be useful which includes data for 2010. (the 10-Nov is the 2010 Yr)

2. Total JAPA should not just be an average. I believe it should be weighted average as some markets are huge (like Australia) and some markets are small (like New Zealand). Giving equal weightage may impact the region’s performance.

Sunil A.

------------------------------------
Reply:

Hi Thomislav,

I dont know how to work in MDX and i have a requirement as follows:

PLEASE HELP ME, If question is not clear let me know.

the issue is related to this kind of measures, when doing an Aggregation the result is not what we expect (like total of Months, the Aggregation is not coming correctly).

Please check this example:

Measure

Center

Region

Market

10-Nov

10-Dec

11-Jan

11-Feb

Total

PF322 Rate

GCS Unallocated

JAPA

Australia

100.00%

100.00%

100.00%

98.80%

99.70%

Hong Kong

100.00%

100.00%

100.00%

100.00%

100.00%

India

103.30%

103.20%

103.25%

Japan

100.00%

100.00%

100.00%

100.00%

100.00%

Newzealand

100.00%

100.00%

100.00%

100.00%

100.00%

Singapore

100.00%

100.00%

100.00%

100.00%

100.00%

Taiwan

100.00%

100.00%

100.00%

100.00%

100.00%

Thailand

100.00%

100.00%

100.00%

100.00%

100.00%

Total

100.79%

100.79%

100.00%

99.68%

100.38%

The feedback from the business related to that grid was:

1. YTD (Total of all months in the grid) value should be for the Year 2011 starting from Jan to Dec. Averaging for the 4 months may not be useful which includes data for 2010. (the 10-Nov is the 2010 Yr)

2. Total JAPA should not just be an average. I believe it should be weighted average as some markets are huge (like Australia) and some markets are small (like New Zealand). Giving equal weightage may impact the region’s performance.

Sunil A.

Sunil A.

------------------------------------
Reply:

Hi Tomislav

I tried the syntax you have given in the earlier part of this thread changing it suitably for my cube as follows :

createmember currentcube.measures.dsotest as  ([Dim Account Master Fin v01].[Short Name Grp].currentmember, measures.ar_inr_cr) / ([Dim Account Master Fin v01].[Short Name Grp].[parent], measures.avgdailysales),  Format_String = 'Currency';  select dsotest on columns  {descendants([Date Dimension].[cMonth_H].[c year].[2012])    * descendants([Dim Account Master Fin v01].[Short Name Grp])   } ON rows  FROM [eMIS_KEC_AR]

But it gives an error as follows :

Executing the query ...

Query (1, 14) Parser: The syntax for 'currentcube' is incorrect.

Execution complete

Can you help please ?

Sanjay Shah, Prosys, Pune, India

------------------------------------

How to Enable ULS Logging Files in central admin

Hi,

SharePoint 2007

    Open your SharePoint Central Administration site.
    On the top navigation bar, select Operations.
    On the Operations page, in the Logging and Reporting section, select Diagnostic Logging.
    Configure Logging and specify a local path to use for the trace log on all servers in the farm. The default location is C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS. To change the location, type a new one in the Path field. The location must exist on all servers in the farm.
    You can also specify the maximum number of files that you want to maintain and the number of minutes to use each log file.
    Select OK.

SharePoint 2010

    Open your SharePoint Central Administration site.
    Select the Monitoring section.
    Under Reporting, select Configure diagnostic logging.
    Configure Logging and specify a local path to use for the trace log on all servers in the farm. The default location is C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS. To change the location, type a new one in the Path field. The location must exist on all servers in the farm.
    Next specify the number of days to store log files.
    You also have the option to restrict the maximum amount of storage to use for logging.
    Select OK.

New log files will be named in the following format: servername-YYYYMMDD-TTTT.log. For example, a log file created on February 9, 2012 at 1:20PM on a server named "jcriner" would be named jcriner-20120209-1320.log.

Changed type Qiao Wei Monday, September 10, 2012 5:58 AM
Changed type Qiao Wei Monday, September 10, 2012 7:47 AM

Reply:

Hi,

From your description, it seems to be a method to enable ULS logging not a question, if so, I will change it to a discussion as the question type may confuse others.

Thanks,

Qiao Wei

TechNet Community Support

------------------------------------

2.We are able to do the customization of AD attribute that is adding the new attribute manually. We have to do this by script, so please share if any sample script /links available.

We are able to do the customization of AD attribute that is adding the new attribute manually. We have to do this by script, so please share if any sample script /links available.

Changed type Markus VilcinskasMicrosoft employee Sunday, March 17, 2013 9:51 AM

Reply:

I think that you should describe your problem or question more clear - are you talking about AD schema extension? Quickest and simplest way is to use LDIF with schema definition. http://technet.microsoft.com/en-us/library/bb632388.aspx

------------------------------------

Biztalk HL7 issue ...... Urgent Please

Hi All,

In my solution I have to extract BodyPart from 3partHL7 message and send BodyPartMsg to another location. Here the file format from the receive location is in .DAT.

In adminconsole I had set the configurations are like this.

For receiveport:

FileMask: *.dat, type:FILE, Pipeline: hl72xreceivepipeline.

For send port: type:FILE, Pipeline:XMLtransmit, Filename:%MessageID%.XML

Could you please tell me how to solve the following issue.

Error details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.
MessageId: {E151AAD9-6D31-46A7-B5D1-7A021CC915CA}
InstanceID: {B039C30E-5DC5-474E-AD14-57E19D2A659B}

Changed type Steef-Jan WiggersMVP, Moderator Sunday, June 19, 2011 10:23 AM Question turned into discussion

Reply:

Hi,

Is this a messaging solution? If so you need to apply a filter on send port i.e. message type (namespace#root) or for instance receive port name. See MSDN How to configure Filters for a SendPort.

HTH

Regards,

Steef-Jan Wiggers
MVP & MCTS BizTalk Server
http://soa-thoughts.blogspot.com/
If this answers your question please mark it accordingly

BizTalk

------------------------------------
Reply:

Hi steef,

This is the exact error. Please tell me how to resolve the follwing issue.

A message received by adapter "FILE" on receive location "Results From xxx Receive Location" with URI "x:\xx\xx\xx\xx\*.dat" is suspended.

------------------------------------
Reply:

Hi Raj,

As Steef has suggested you check the filter on the send port to resolve this routing failure.

And regarding the extraction of body part. You have 2 option. After rectifying your filter on send port you will be receiving message having 3 parts(MSH,Body and Z Segment).

1. The most flexible solution is to create a pipeline component which will create a new message after attaching the body part of the receive message. You can use then use this pipeline component to send any type of message in pipeline.

2. You can create mapper to use on send port and in this mapper can only map the body part but it would not be flexible solution as you have to create as many maps as the type of message you want to send.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Hi Rohith,

I have a orchestartion in that Receive port and send ports are there. In message assignment shape i have added logic to extract the bodymessage from HL73part message. And through send port I have to send that body message to another folder. I have tried to test that. The error is

A message received by adapter "FILE" on receive location "Results From xxx Receive Location" with URI "x:\xx\xx\xx\xx\*.dat" is suspended.

So please let me know how to resolve this

------------------------------------
Reply:

Have you enlisted the orchestration or if you are using direct bound receive port in orchestration then check the filters. Check the promoted properties on suspended message and compare it with the orchestration subscription.

How to check promoted properties of Message

1. Open the Biztalk Administration Console
2. Click on the Biztalk Group

3. In Group Hub->Under Suspended Items ->Click on Suspended service instances

4. From Query Results select Suspended(Non resumable)

5. Right click "Routing Failure Report for "<ReceivePortName>" and select Service details from popup menu

6. Go to Messages tab and click on message then check the promoted properties from Context of the message

How to check subscription

1. Open the Biztalk Administration Console
2. Click on the Biztalk Group

3. Click on the New Query tab
4. Select Field Name: Search For, Operator: Equals, Value: Subscriptions

5. Select Field Name: Subscription Type, Operator: Equals, Value: Activation Subscriptions

6. Click Run Query

7. Open the subscription for the required artifact(Orchestration or send port).

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Hi,

If you use an orchestration than that needs to subscribe to incoming message. You do have assigned a message type to incoming message (receive shape) and that type needs to correspond to incoming message.

HTH

Regards,

Steef-Jan Wiggers
MVP & MCTS BizTalk Server
http://soa-thoughts.blogspot.com/
If this answers your question please mark it accordingly

BizTalk

------------------------------------
Reply:

Hi Rohith,

Following ARE BIZTALK CONFIGURATIONS.

For receiveport:

FileMask: *.dat, type:FILE, Pipeline: hl72xreceivepipeline.

For send port: type:FILE, Pipeline:XMLtransmit, Filename:%MessageID%.XML

My receive file format is .ADT format.

Is there any problem with the file format?

And also please tell me how to promote .After Checking the promoted properties on suspended message and comparition it with the orchestration subscriptions how we have to modify.

------------------------------------
Reply:

Hi,

Is suggest you go through the HL7 end-to-end tutorial. Perhaps this will give you some better understanding of your situation and what actions to perform.

HTH

Regards,

Steef-Jan Wiggers
MVP & MCTS BizTalk Server
http://soa-thoughts.blogspot.com/
If this answers your question please mark it accordingly

BizTalk

------------------------------------
Reply:

I am not sure what this .ADT format is. The HL72XReceivePipeline is used for receiving the XML message. So please answer the following questions.

What is the encoding of the message received in this .ADT file?

Is the content of this message is XML or it is a flat file?

HL7 provide different pipeline for flat file and XML message use the appropriate pipeline based on your requirement.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Sorry rohith not ADT it is .DAT file

------------------------------------
Reply:

hi rohith,

my recieve file format is .dat

Is there any problem with the file format?

Please let me know

------------------------------------
Reply:

What is the content in this file is it a flat file or XML?

What is the encoding of this file?

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Rohith,

It is a ORU R01 message which is .dat file( Which is coming to receive location). I have to extract bodysegment from this and send BodyPart to another location using send port. So in the orchestration one receive port and one send port are there.

Can we process this .dat file using HL7 pipelines? The error is with the file format?

please let me know

------------------------------------
Reply:

Rohith,

Can we process this .dat file using HL7 pipelines? The error is with the file format?

Following ARE BIZTALK CONFIGURATIONS.

For receiveport:

FileMask: *.dat, type:FILE, Pipeline: hl72xreceivepipeline.

For send port: type:FILE, Pipeline:XMLtransmit, Filename:%MessageID%.XML

A message received by adapter "FILE" on receive location "Results From xxx Receive Location" with URI "x:\xx\xx\xx\xx\*.dat" is suspended.

The Messaging engine failed to process a message submitted by adapter:FILE Source URL:x:\xx\xx*.dat. Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

------------------------------------
Reply:

Try to use HL72FReceivePipeline pipeline. I think you are receiving a flat file message and using wrong type of pipeline.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

It's important to remember what can cause a routing failure exception. Just because you're orchestraiton is bound to that receive port (It is right?) does not mean the orchestration will receive the message. If you look in the BizTalk Administration Console and create a New Query in the group hub page you will see that there is an option for Subscriptions, pick that and then on the second like select Subscription Type and use Activation. Here you will see exactly what your orchestration is looking for. Changes are your orchestration is expecting a specific type of message and it will have something about a BTS.TransportID == XXXXXXXX AND BTS.MessageType = http://somenamespace#SomeNode

You need to find this subscription and look at what it is expecting. Then you need to look at your suspended message and look at the message type, which probably doesn't match. You need to either change the message (map/pipeline) or change the orchestration.

Kind Regards,

-Dan

If this answers your question, please Mark as Answer

------------------------------------
Reply:

Hi Dan,

Here in my case I have coustomnamesapce. I have changed the names spaces of the schemas in the common projects and I have refferd to my solution. In the suspended message details its not showing message type. How can we solve this issue?

Urgent Pleasee

------------------------------------
Reply:

Hi Raj,

I have worked on HL7 Accelerator in past and can help you. For this you need to share all the steps you have followed till now. I'll tell you where you might be wrong.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Rohith,

In my solution I am using custom namespaces. For that first in my solution I have added the BTAHL2x, BTAHL725 and customized name spaces i.e replaced the microsoft.com/HealthCare with testxx in all the schemas in both the common projects and deployed. After that added reference to the mysolution and again ADTA08 schema added to the solution and changed name space(replaced the microsoft.com/HealthCare with testxx) for the schema by editing with notepad. And constructed 3 part msg. In the orchestration added logic to receive ADT msg and Extract the body msg. Send that body message to another local folder. For this I am getting error as below.

A message received by adapter "FILE" on receive location "RcvADTA08Location" with URI "M:xx\xxx\in2\*.hl7" is suspended.
Error details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.
MessageId: {81522CFE-0CC2-4AE7-B132-F8705360B188}
InstanceID: {AEEF822E-81D3-496E-9AEA-AB8DAAFE93B7}

The Messaging engine failed to process a message submitted by adapter:FILE Source URL:M:xx\xxx\in2\*.hl7". Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

I have checked the suspended messages its message type is empty there.

In subscription details it is expecting messagetype== http://Testxx/HL7/2X#ADT_A08_25_GLO_DEF

So please tell me how to resolve this.

------------------------------------
Reply:

Hello rohith,

I have customized the namesapces of schemas in the both common projects. Could you plz tell me how can we resolve???

------------------------------------
Reply:

Still you have not provided details like:

Have you created parties?

Which pipeline are you using to parse this message?

Open the message in notepad and share the MSH segment here?

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

MSH|^~\&|PCC|00040|Caretracker|CT|20110523105740.786||ADT^A08|1484562|P|2.5|||||||||
EVN|A08|20110523105740|||DMS0012|20110523105740|
PID|1||000400000096146||xxxxx JR.^CLYDE^RAY^Jr||19570707|M||xxxxx, not of Hispanic

Above is the part of message and I have created the parties and given the validations schema namespace as http://Testxx/HL7/2X. Pipeline receive is BTAHL72x pipeline( File mask .hl7) and for sending xmltransmit(.xml).

------------------------------------
Reply:

Can you check the suspended message and can see that the 3 parts(MSH,Body,Z Segment) of the message are generated properly.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

One thing more you need not to change the namespace for the schema for MSH and ACK. That is in project 'BTAHL7V2XCommon' you are not required to do these namespace changes. Have you changed the namespace for this project?

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Rohith,

Message Type and message parts showing empty

------------------------------------
Reply:

I have changed the namespaces in 'BTAHL7V2XCommon' also

------------------------------------
Reply:

That is the reason the message is not getting parsed. Remove the existing BTAHL7V2XCommon project and add the BTAHL7V2XCommon project again don't modify the namespace in any of the schema in this project i.e. for MSH and ACK. These schema are used internally by HL7 DASM and you are not required to change the namespace for these schema to use the custom namespace.

Do these changes deploy the solution and try again.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

In BiztalkHl7 v2 user guide they have mentioned to change ACK schemas also but not MSH

------------------------------------
Reply:

I asked you to do this because the custom namespace was not working with ACK and then I done some fix in HL7 assembler code to fix this. But I can't recall the KB article for that fix.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

I was able to find it. Here is the KB949781 which I was talking about. Which version of HL7 are you using?

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Rohith,

We are using Biztalk HL7Accelerator 2010.

------------------------------------
Reply:

And the schemas are of 2.5 version

------------------------------------
Reply:

If you are using BTAHL7 2010 then this fix is already included in product no additional patch is required. Were you able to run this scenario after restoring the namespace for the schema of MSH segment.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Rohith,

I didnt get u what exactly u r asking?

------------------------------------
Reply:

Are you able to run the scenario now.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

No Rohith, still getting same error "no subscribers are found...".

------------------------------------
Reply:

Rohith,

When replacing microsoft.com/Healthcare with Testxx I am editing common project schemas with notepad. Is it required to change the namespaces of all schemas default namespace BTAHL7Schemas?

------------------------------------
Reply:

One simplest way that you can try and I am sure will work though not documented anywhere is to change only the namespace of the schema you want to use i.e. ADT A08 in your case. Try this. Don't modify namespace in any of the common project and also make sure you are just changing the namespace of this schema only.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

No its not working......

------------------------------------
Reply:

What error are you getting?

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

These are the errors

1)"D:\xx\xx\Testxx\in\*.hl7" is suspended.
Error details: The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.
MessageId: {833AD7B8-3B1B-4A61-9E07-CDE663C4D15A}
InstanceID: {0CED181E-5DA7-408F-A36E-27F9619FEC41}

2) The Messaging engine failed to process a message submitted by adapter:FILE Source URL:D:\xx\xx\Testxx\in\*.hl7. Details:The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.

------------------------------------
Reply:

Rohith,

As u told I have added references of common projects with out modification of name spaces and edited AT A08( repaced Microsoft.com/Healthcare with testxx). When tried to assign msessage type for message, modified ADTA08 is not dispalying there. So I have tried in the normal way. But Error is same

------------------------------------
Reply:

Changing the namespaces means just editing those schemas with notepad and replacing Microsoft.com/Healthcare. I am not changing any thing other than this. Is it correct way?

------------------------------------
Reply:

Can you please share the schema for ADTA08you are using. Only share the part before starting the definition of segments.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

<?xml version="1.0" encoding="utf-16" ?>

- <xs:schema xmlns="http://Testxx/HL7/2X" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns:ns0="http://Testxx/HL7/2X/2.5/Segments" targetNamespace="http://Testxx/HL7/2X" xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:import schemaLocation="BTAHL7Schemas.segments_25" namespace="http://Testxx/HL7/2X/2.5/Segments" />

- <xs:annotation>

- <xs:appinfo>

<b:schemaInfo standards_version="HL7.DBVersion.1_5" document_type="HL7 2X Schema" version="2.0.0104.0.2.0" root_reference="ADT_A08_25_GLO_DEF" />

- <b:references>

<b:reference targetNamespace="http://Testxx/HL7/2X/2.5/Segments" />

<b:reference targetNamespace="http://Testxx/HL7/2X/2.5/Tables" />

<b:reference targetNamespace="http://Testxx/HL7/2X/2.5/DataTypes" />

</b:references>

</xs:appinfo>

</xs:annotation>

- <xs:element name="ADT_A08_25_GLO_DEF">

- <xs:complexType>

- <xs:sequence>

<xs:element minOccurs="0" maxOccurs="unbounded" name="SFT_SoftwareSegment" type="ns0:SFT" />

------------------------------------
Reply:

You don't need to do this as you have not modified the namespace in the BTAHL7V2.5Common project. So revert all these changes:-

<xs:import schemaLocation="BTAHL7Schemas.segments_25" namespace="http://Testxx/HL7/2X/2.5/Segments" />

<b:reference targetNamespace="http://Testxx/HL7/2X/2.5/Segments" />

<b:reference targetNamespace="http://Testxx/HL7/2X/2.5/Tables" />

<b:reference targetNamespace="http://Testxx/HL7/2X/2.5/DataTypes" />

or better idea would be to add the schema again and change only the following mentioned

<xs:schema xmlns="http://Testxx/HL7/2X" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns:ns0="http://Testxx/HL7/2X/2.5/Segments"

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

No I have to use custom namespaces. Please tell me how to do with custom namespaces with modification of name spaces of schemas?

------------------------------------
Reply:

Please tell me in the step by step wise

------------------------------------
Reply:

Add the project "BTAHL7V2X Common" and "BTAHL7V2.5 Common" to your solution. Add project to which you can add the schema for ADT A08. Add this schema and use your custom namespace in following location only in ADT A08

<xs:schema xmlns="http://Testxx/HL7/2X" xmlns:b="http://schemas.microsoft.com/BizTalk/2003" xmlns:ns0="http://Testxx/HL7/2X/2.5/Segments"

Deploy your solution and test it.

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Rohith,

In party configurations also we have to change schema namespace or not?

------------------------------------
Reply:

You have to use your custom namespace for the source party i.e. MSH.2

Mark As Answer or Vote As Helpful if My Reply Does, Regards, -Rohit

------------------------------------
Reply:

Hi Raj_Biz,

Can you share the code on how you did extract BodyPart from 3partHL7 message ?? I have a message assignment shape to get the bodysegments, but I keep getting bodysegments not found.

My Code -

HLBodySegment = HLMessageType.BodySegments;

thanks

Carlos Tijerina

------------------------------------
Reply:

Hi sol_rac,

create a message HLBodySegment of type with your required Body schema(Eg: ADT_A01) after that you have to assign

HLBodySegment = HLMessageType.BodySegments;

ANother thing is Create multipart message as in the follwing order only with the same names

1.MSHSegment

2.BodySegments

3.ZSegments

First assign Bodysegments schema and set body part to true.

Next MSHSegment with System.Xml.XmlDocument

Then ZSegments System.string

Edited by Raj_biz Monday, September 10, 2012 8:04 AM

------------------------------------

search in sharepoint 2010

I am trying to search a keyword from document library and i have created search service in central admin and activated some features ,please let me know the steps involved for search.

Blitz

Reply:

Hi Blitz,

Which search service are you using - Enterprise search, SP Foundation Search or Fast Search?

------------------------------------

file.writeallbytes alters the data

Hi all,

I try to get the data from an excel file uploaded on a sharepoint site. Therefore, I download the file using the methods OpenBinaryStream (from the file to byte array) first and then File.WriteAllBytes (from the byte array to a copy of the file on my local disk).

This used to work properly a few days ago but now the copy of the file returns an empty file and I get the message: "the file you are trying to open is in different format than specified by the file extension... verify that the file is not corrupted and is from a trusted source" when I simply try to open it with Excel. Indeed, when I activate the webpart that should use this file, I get also an error (unspecified error on MyConnection.Open()).

Can anybody help me?

Thanx

Reply:

Do you think the file is altered due to the fact that the number of bytes is unknown inadvance (it would work if the byte array had the precise length of the file)? Nevertheless, it worked fine in the past...

------------------------------------

TMG client prevents Outlook "Out of Office Assistant" working

I have what should be a very simple configuration, a single Exchange 2010 SP2 server and single TMG 2010 SP2 server with all workstations running the Forefront TMG client 7.0

When users try to configure there "Out of Office" settings they get the error message - "Your Out of Office settings cannot be displayed becuase the server is currently unavailable".

If I disable the TMg client and remove the proxy setting from Internet Explorer then the "Out of Office Assistant" works.

What is the best way to resolve this or what are the recomened setting for Exchange 2010, IIS 7 and Forefront.

I would have thougth that as all the products are Microsoft and its a common and simple scenario that it would all just work :(

Regards,

Nigel - Gold Coast, Australia

Reply:

Hi,

this is IMHO mostly related to certificate problems or wrong proxy settings. In your case I think proxy settings. Make sure that the name of the CAS Server (DNS FQDN) is configured to bypass the proxy settings. Connections to the CAS Server forAutodiscover/EWS must go directly to the CAS Server

regards Marc Grote aka Jens Baier - www.it-training-grote.de - www.forefront-tmg.de - www.nt-faq.de

------------------------------------
Reply:

Hi Nathan,

I attempted to run the test but I get the error at the bottom of this post..
The folder was empty and accessable, I ran the Activesync test which passed using the same account.

I searched the error "DTD is prohibited in this XML document" and also the Out of office problem and both are very common. Sadly an Exchange enviroment is overly complex and has become almost impossible for admins of smaller sites to manage along with all the other products we have to supports these days :(

Exchange Web Services synchronization, notification, availability, and Automatic Replies (OOF).
Not all of the tests of Exchange Web Services tasks completed.
Test Steps
Ensuring that the test mailbox folder is empty and accessible.
ExRCA couldn't confirm that the folder is accessible and empty.
Additional Details
Exception details:
Message: The response received from the service didn't contain valid XML.
Type: Microsoft.Exchange.WebServices.Data.ServiceRequestException
Stack trace:
at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.ReadXmlDeclaration(EwsServiceXmlReader reader)
at Microsoft.Exchange.WebServices.Data.SimpleServiceRequestBase.ReadResponseXml(Stream responseStream)
at Microsoft.Exchange.WebServices.Data.SimpleServiceRequestBase.ReadResponse(IEwsHttpWebResponse response)
at Microsoft.Exchange.WebServices.Data.MultiResponseServiceRequest`1.Execute()
at Microsoft.Exchange.WebServices.Data.ExchangeService.BindToFolder[TFolder](FolderId folderId, PropertySet propertySet)
at Microsoft.Exchange.Tools.ExRca.Tests.EnsureEmptyFolderTest.PerformTestReally()
Exception details:
Message: DTD is prohibited in this XML document.
Type: System.Xml.XmlException
Stack trace:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ParseDoctypeDecl()
at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
at System.Xml.XmlCharCheckingReader.Read()
at Microsoft.Exchange.WebServices.Data.EwsXmlReader.Read(XmlNodeType nodeType)
at Microsoft.Exchange.WebServices.Data.ServiceRequestBase.ReadXmlDeclaration(EwsServiceXmlReader reader)

------------------------------------
Reply:

Hi Marc,

Thanks for you response. Where do I configure the TMG client to bypass exchange. If I manully enter the FQDN into the Internet Explorer proxy seetings it dissapears soon as I close and reopen IE. Do I need to do this globaly somewhere in the Forefront Management console?

------------------------------------
Reply:

Hi,

TMG MMC - Networking - Networks - select your internal network - Domains tab and Webbrowser tab

regards Marc Grote aka Jens Baier - www.it-training-grote.de - www.forefront-tmg.de - www.nt-faq.de

------------------------------------

Certification in a Recession

Hi Folks,

We're in a recession, IT spending is down, and we're being forced to do more with less.

I remember back in the good old days when the economy was booming, I would prepare for any new certification by purchasing numerous resources: the Microsoft Training Kit, the Microsoft Resource Kit, any useful third-party books, an Exam Cram type book, practice tests from both authorized providers, and my beloved CBT Nuggets.

However, with the economy in the toilet and IT budgets shredded, I've had to make do with much less. I've given up my beloved CBT Nuggets (too expensive), and I only buy one Training Kit per exam (usually the Microsoft kit). I buy ebooks discounted from O'reilly, and I buy my practice tests from MeasureUp or SelfTest when they're on sale.

I now spend more time on TechNet, which is free, although more time-consuming, and I'm stocking up on Second Shot vouchers with the 15% discount.

How has the economy been impacting your certification? What resources are you using now to save money? Do you know of any Microsoft discounts or specials? Please share. Thanks.

James

Edited by James JT Taylor Monday, September 10, 2012 1:03 AM
Changed type Mr. Wharty Friday, September 21, 2012 12:40 AM

Reply:

Hi Folks,

We're in a recession, IT spending is down, and we're being forced to do more with less.

I remember back in the good old days when the economy was booming, I would prepare for any new certification by purchasing numerous resources: the Microsoft Training Kit, the Microsoft Resource Kit, any useful third-party books, an Exam Cram type book, practice tests from both authorized providers, and my beloved CBT Nuggets.

However, with the economy in the toilet and IT budgets shredded, I've had to make do with much less. I've given up my beloved CBT Nuggets (too expensive), and I only buy one Training Kit per exam (usually the Microsoft kit). I buy ebooks discounted from O'reilly, and I buy my practice tests from MeasureUp or SelfTest when they're on sale.

I now spend more time on TechNet, which is free, although more time-consuming, and I'm stocking up on Second Shot vouchers with the 15% discount.

How has the economy been impacting your certification? What resources are you using now to save money? Do you know of any Microsoft discounts or specials? Please share. Thanks.

James

Where are you from as we're not in a recession in Australia :-)

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

------------------------------------
Reply:

Hi Mr. Wharty,

You folks in Australia are certainly lucky. Most of us in the US, Europe, and much of the rest of the world are really feeling it.

Don't worry though, according to the latest predictions recession is headed your way soon. See the following link, for example:

http://theconversation.edu.au/buckle-up-australia-recession-is-coming-7950

However, in the meantime I think I'll move to Australia :-)

------------------------------------
Reply:

lol. People have been saying that for the last 2-3yrs yet our economy has actually gotten stronger with Australia receiving AAA ratings from the 3 worldwide rating agencies for the first time since the Australian currency was floated. Given that we're such a resource rich country, it's unlikely we'll go into recession any time soon.

------------------------------------

No Exchange in Essentials 2012

Just having a look at Essentials 2012 and I see there are only 2 options for Email now.

1 Buy another windows server licence and Buy a full copy of Exchange Std

2 Pay $7.90 per user per month for Office365

For a business with eg 10 staff to use Office365 that's 7.90 per month *10 users *12 months=$948 per year Opex that a small business will have to find ontop of the Capex of setting up the new server to start with, that with the addional Internet downloads and hoping the business's internet speed can cope with the addional traffic since most small business still have very basic internet setups.

Or the Business pays $$ for more hardware to run a second windows server as a VM or physical. More $$ for a windows Licence and More $$ again for a Full Exchange Server Licence and $$ for the Exchange CAL's.

How is this a better system than SBS 2011?? How will sales guys be able to sell this as an upgrade to SBS 2003 or SBS 2008 customers?

The only way I can see this as remotely possible is if Microsoft include free access to Office365 for upto 25 users for anyone that has a Windows Server Essentials 2012 Licence.

The other issue I have is Australia is not listed as one of the options to setup Office365. So I'm guessing you have to set it up with Telstra's MS Office365 service and say you have an existing account??

Edited by chocky005 Friday, September 7, 2012 5:31 AM
Changed type kariya21 Saturday, September 8, 2012 2:32 PM not a technical question

Reply:

How is this a better system than SBS 2011?? How will sales guys be able to sell this as an upgrade to SBS 2003 or SBS 2008 customers?

As much as I like SBS 2011, it still has issues due to the "everything including DC" crammed into one box. I think Microsoft's current "solution" from a licensing perspective is lacking, but from a technology perspective I can see multiple reasons why they decided to stop with SBS standard at SBS 2011.

The good news is SBS 2011 will be supported for at least another four years, and in that time who knows what the market will look like.

And an excellent post by Susan, as usual going into more detail....

------------------------------------
Reply:

If you are looking for just Exchange in the cloud, consider using the E1 Exchange Online plan which costs $7.10 per month.

The other factors that you may not have considered in the scenario above is the cost of the hardware, and operating costs. While you mentioned the costs of internet access in the equation, also consider the following:

The use of less powerful (cheaper) server hardware needed for WS2012 Essentials, vs full blown SBS2011.
The operating costs to manage the first point
The IT management costs to maintain and look after the setup above
The cost of downtime, when some contractor cut's the phone cables down the road, and you have no Internet access for 2-3 days
The cost of money when purchasing a more expensive capex asset and depreciation, versus opex costs which are fully deductible each month

I seriously doubt we will see free Office365 licenses with WS2012 Essentials. I have found that for small business of 10 and under, the Essentials + Office 365 option is probably a much better option for a majority of small (micro) businesses. The grey area comes in at about 15 users plus or minus a few. In these cases, there is often a need for more than 1 server, so a lot of other considerations come into play, and it is more of a case by case decision.

For Australia, you will need to purchase the Office 365 licenses via Telstra or a Telstra reseller. Once the account is set up with Telstra, the Office365 integration wizard works very well.

Regards, Boon Tee - PowerBiz Solutions, Australia - http://blog.powerbiz.net.au

------------------------------------
Reply:

Hi,

Towards your these inquires, I think you could read the following article below:

Windows Server 2012 Essentials FAQ

There are some main questions you would like to know.

1. What is Windows Server 2012 Essentails?

2. Why did Microsoft create Windows Server 2012 Essentials?

...

You could find the answers in the the pdf document after downloading. Also it includes Sales Market, Product Info and Line-of-Business Applications tab.

Regards,

James

Edited by James Xiong Monday, September 10, 2012 2:11 AM

------------------------------------

Announcing the AdventureWorks OData Feed sample

Derrick VanArnam (MSFT) has put together a great blog post on consuming an OData feed based on the AdventureWorks 2012 database.

The AdventureWorks OData service exposes resources based on specific SQL views. The SQL views are a limited subset of the AdventureWorks database that results in several consuming scenarios:

CompanySales
Documents
ManufacturingInstructions
ProductCatalog
TerritorySalesDrilldown
WorkOrderRouting

Source: http://blogs.msdn.com/b/derrick_vanarnams_blog/archive/2012/09/06/announcing-the-adventureworks-odata-feed-sample.aspx

SQL Server e-books available

Hi folks,

The SQL Server team has published several e-books to the new e-book gallery on the TechNet Wiki. This is a pilot project and we would like your feedback. We have provided a sampling of different content types (reference, prescriptive guidance, tutorial) for you to consider. There is a feedback link at the top of the wiki page that you can use to provide your comments. We would appreciate your feedback regarding the formats provided, overall usability, your level of interest in the various content types, suggestions for new content, or any other information you would like us to know.

The e-books that are currently available include:

SQL Server 2012 Transact-SQL DML Reference
Master Data Services Capacity Guidelines
Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery
QuickStart: Learn DAX Basics in 30 Minutes
Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide

More titles are coming later in June, and after that we will evaluate the results of your feedback and determine our next steps.

Kind regards,

Gail

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

Edited by Gail Erickson Tuesday, June 12, 2012 9:08 PM cleanup in title

Reply:

Cool. Perhaps now is the time to get me an e-book reader! :-)

Tibor Karaszi, SQL Server MVP | web | blog

------------------------------------
Reply:

Please view on the below link:

http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx

Ahsan Kabir

------------------------------------
Reply:

Quite helpful...

yup

------------------------------------
Reply:

Transact-SQL Data Manipulation Language (DML) Reference  SQL Server 2012 Books Online  Reference   Data Manipulation Language (DML) is a vocabulary used to retrieve and work with data in SQL Server 2012. Use these statements to add, modify, query, or remove data from a SQL Server database.   Applies to: SQL Server 2012  Source: Microsoft SQL Server 2012 Books Online

Is the above ebook any different from BOL?

Thanks.

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012

------------------------------------
Reply:

The source for all of the Transact-SQL ebooks is the SQL Server 2012 Books Online. The only differences would be any updates or corrections make to the topics in Books Online since the date the ebook was created. Both the DML and DDL ebooks were generated early this summer, so I don't believe there are substantial differences between the e-books and the current version of SQL Server 2012 Books Online.

Best,

Gail

Gail Erickson [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights

------------------------------------

Possible solution for mirroring on Lync 2010

Hello,

I am posting here because we think we have found a possible way of doing mirroring in Lync. We have tried it in our Lab resulting being totally transparent for the users, that is, they dont lose connection at all. I would like you to comment your thoughts because perhaps we are forgetting about something or there are things that can be simplified.

So, our topology is composed by one SIP domain, in which we have an Enterprise Edition front end pool with one server, we have only one SQL Store declared on the topology (SQL01.company.com), a pool of mediations with one mediation, the same thing for the edge pool, and a monitoring server.

We set manually the mirroring from the SQL server declared on our topology, SQL01, to another SQL server (SQL02.company.com).

In this SQL02, if we want monitoring to keep working, the reporting services configuration manager must have the exact same configuration as it has on the SQL01 server.

Having this ready, we execute the following powershell script. The input arguments that we need to specify is, in our case, "SQL02.company.com" and "rtc". Note that we have used the module "pscx" to handle the zip files. The steps that we take are basically these:

- We retrieve the CSconfiguration zip file and the topology tbxml file.
- In those files, we change all references of "SQL01" to "SQL02".
- We perform the failover on the mirrored databases and enable ownership chaining in rtc and rtcdyn.
- We change the ConfigurationStoreLocation to SQL02.
- We import the modified CSConfiguration file, publish the modified topology file and enable the topology. This step is very important to do it in another powershell session.
- Restart services in monitoring server.
- Start services in front end server. We dont restart all the services because we dont want the user to be disconnected. The services that will stop after the script is run are "MASTER" and "FTA". Also we will get errors in the services "LS Address book server" and "LS Call park service" because they will try to connect to the previous SQL Store (SQL01.company.com). Restarting those services will be a solution, but also will imply a temporal disconnection of the users.

Here it is the script:

# Be sure that the recovery model on all databases is set to FULL.
# Create backup of all the Lync databases and logs.
# Restore them in the mirror sql server WITH NORECOVERY mode in the same path as in the principal server.
# Set the mirroring.

param(
[string] $mirrorSQLServerFQDN = (throw "Please specify the SQL mirrored server fqdn"), # FQDN of the mirrored SQL server.
[string] $mirrorSQLInstance = (throw "Please specify the SQL mirrored instance")
)

# This function will unzip a file on the $basePath path. The input parameter must be a zip file.
Function UnzipFile {

Param([string]$name)

# We are importing the module for unzipping zip files.
if(-not(Get-Module -name "pscx")) {
if(Get-Module -ListAvailable | Where-Object { $_.name -eq "pscx" })
{
Import-Module -Name "pscx"

Write-Host "`nModule for $name was loaded!"
}
else {
cp .\pscx C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ -recurse
Import-Module -Name "pscx"
}
} # end if not module

# Unzipping the zip file.
Expand-Archive -Path $($basePath + $name) -OutputPath $basePath -showProgress

}

# Function to test if Modules are available
Function Get-MyModule {

Param([string]$name)

if(-not(Get-Module -name $name)) {
if(Get-Module -ListAvailable | Where-Object { $_.name -eq $name }) {

Import-Module -Name $name

Write-Host "`nModule for $name was loaded!" }

else { Write-Host -BackgroundColor DarkRed "`nModule for $name was not loaded!"
Write-Host "Install the following binaries and restart the script"
# We install the binaries for Lync.
$setupPath = $setupLyncFile + "Setup.exe"
& $setupPath
exit
}

} # end if not module

else {
Write-Host "`nModule for $name was already loaded!"
}

}

Get-Mymodule -name "Lync"

# We get the SQL server FQDN and instance.
$address = get-csconfigurationstorelocation

$SQLserverFQDN = $address.split("\")[0]
$SQLInstance = $address.split("\")[1]
$basePath = "C:\temp\"
$pathCSConfigurationFile = $basepath + "csconfigurationMirroredAuto.zip"
$pathTopologyFile = $basepath + "MirroredTopologyAuto.tbxml"

# The following lines make the trick. We obtain the cs and topology configuration and change the references from one SQL server to the other.
export-csconfiguration -filename $($basepath + "csconfigurationOriginalAuto.zip")
# Get the files inside the zip that contains the CS configuration.
UnzipFile -name "csconfigurationOriginalAuto.zip"

$xmlContent = get-content $($basepath + "docitemset.xml")
$xmlContent = $xmlContent.replace($($SQLserverFQDN.split(".")[0]).toLower(),$($mirrorSQLServerFQDN.split(".")[0]).toLower())
$xmlContent.replace($($SQLserverFQDN.split(".")[0]).toUpper(),$($mirrorSQLServerFQDN.split(".")[0]).toUpper()) | set-content $($basepath + "temp.xml")
move-item $($basepath + "temp.xml") $($basepath + "\docitemset.xml") -force:$true

Write-Zip -level 9 -Path $($basepath + "docitemset.xml"),$($basepath + '`[Content_Types`].xml') -OutputPath $pathCSConfigurationFile
# removing the files that we previously unzip for the renaming operations.
remove-item $($basepath + "docitemset.xml"),$($basepath + '`[Content_Types`].xml')

# Now we are doing the same thing with the topology file.
Get-CSTopology -asxml | out-file ($basepath + "CurrentTopologyAuto.tbxml")
$topologyContent = get-content $($basepath + "CurrentTopologyAuto.tbxml")
$topologyContent = [string]$topologyContent
$topologyContent = $topologyContent.replace($($SQLserverFQDN.split(".")[0]).toLower(),$($mirrorSQLServerFQDN.split(".")[0]).toLower())
$topologyContent.replace($($SQLserverFQDN.split(".")[0]).toUpper(),$($mirrorSQLServerFQDN.split(".")[0]).toUpper()) | set-content $($basepath + "temp.tbxml")
move-item $($basepath + "temp.tbxml") $pathtopologyfile -force:$true

# At this point we have created 4 files: "c:\temp\csconfigurationOriginalAuto.zip", $pathCSConfigurationFile, "c:\temp\CurrentTopologyAuto.tbxml", $pathtopologyfile

#Enable ownership chaining, http://support.microsoft.com/kb/968100
$enableChainingRTC = "sp_dboption 'rtc', 'db chaining', TRUE"
$enableChainingRTCDYN = "sp_dboption 'rtcdyn', 'db chaining', TRUE"
# Lync Databases
$DBs = "cpsdyn","lcscdr","lis","lyncgroupchat","reportserver","reportservertempdb","qoemetrics","rgsconfig","rgsdyn","rtc","rtcab","rtcab1","rtcdyn","xds";
foreach ($DB in $DBs){

$sqlFailover = "ALTER DATABASE " + $DB + " SET PARTNER FAILOVER" # We perform the failover from the sql principal to the mirror.
write-host "`n$sqlFailover`n"

& 'C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE' -S $($SQLServerFQDN + "\" + $SQLInstance) -Q $sqlFailover

}

& 'C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE' -S $($mirrorSQLServerFQDN + "\" + $mirrorSQLInstance) -Q $enableChainingRTC
& 'C:\Program Files\Microsoft SQL Server\100\Tools\Binn\SQLCMD.EXE' -S $($mirrorSQLServerFQDN + "\" + $mirrorSQLInstance) -Q $enableChainingRTCDYN

# Sets the Active Directory service control point for the Central Management store.
set-csconfigurationstorelocation -sqlserverfqdn $mirrorSQLServerFQDN -sqlInstanceName $mirrorSQLInstance -Verbose -confirm:$false

## The following commands have to be run in another powershell Lync session.

#Importing the CS configuration.
#Publishing topology
#Enabling topology
$cmd = "Import-module lync; Import-CSConfiguration -filename $pathCSConfigurationFile -Verbose; Publish-CsTopology -filename $pathtopologyfile -force:1 -Verbose; Enable-CSTopology -Verbose"
$bytes = [System.Text.Encoding]::Unicode.GetBytes($cmd)
$encodedCommand = [Convert]::ToBase64String($bytes)
powershell.exe -encodedCommand $encodedCommand

#Restarting the services in the monitoring server.
Invoke-Command -ComputerName "monitoring.company.com" -ScriptBlock {import-module lync; stop-cswindowsservice; start-cswindowsservice}

#Starting the services in the front end server.
Invoke-Command -ComputerName "frontEnd.company.com" -ScriptBlock {import-module lync; start-cswindowsservice}

#Removing the files created for the CSConfiguration and Topology.
Remove-Item $pathCSConfigurationFile,$pathTopologyFile, "C:\temp\csconfigurationOriginalAuto.zip", "C:\temp\CurrentTopologyAuto.tbxml"

# If after this failover, when accessing to the monitoring reports we can not access, p.e when making request of report we get "The ConnectionString property has not been initialized"...
# Redeploy the monitoring server reports.

We are aware that mirroring is not supported by Microsoft in Lync 2010. We also know that manipulating the csconfiguration and topology files is not a safe approach, but doing it, we manage to have mirroring.

We will really appreciate any comment/thought about this, so that we can improve this sort of solution.

Sorry for the long post.

Best,
Fernando.

Reply:

Sorry, as you wrote mirroring is not supported in Lync 2010. Mirroring is supported in Lync 2013, so you can later migrate to Lync 2013 with mirroring.

regards Holger Technical Specialist UC

------------------------------------

I cannot play blue ray dvds

Whenever i attempt to play blue rays it says content protected cannot be displayed. I emptied out my DRM folder and that did not resolve. I performed a destructive recovery and that did not resolve. I went to microsoft support and the fix it did not resolve. I cannot find how to manage lisences in media player to see if that is the problem. Please HELP!!!!!!

Reply:

会不会是你的光驱有问题？光驱功能不够？

------------------------------------

How can I add an SPGridview and SPDatasource to the Visual Studio toolbox?

I was wondering if there was a way to get the SPGridview and SPDatasource in the toolbox and if they have smart tags like all the other ASP.Net controls so you can configure them in the visual designer.

By referencing the Microsoft.SharePoint.dll assembly I can create and SPGridview and SPDatasource in code behind but I can't figure out how to add them to the toolbox. I tried selecting choose items but they aren't in the .Net components list and if I try to select the SharePoint.dll it errors out.

If I could drag and drop these controls and configure them without coding all the CRUD operations that would be sweet. Otherwise, I don't see any advantages in using them over an ASP.Net Listview binded to a ListCollection's .GetDataTable() method. Am I right?

Any one know how to add them to the toolbox?

Edited by GuyTryinToLearnSharepoint Sunday, September 9, 2012 9:12 AM

O'Reilly 50% Discount off E-Books

Hi Folks,

I now buy my Microsoft certification texts as e-books for use on my PC or Kindle since this is very convenient for me. I purchase them directly from O'Reilly (oreilly.com), bypassing Amazon.com whenever possible because of Amazon's DRM.

O'Reilly is a partner of Microsoft Press, and their e-books (which are available in mobi, pdf, epub, and daisy formats) are DRM-free. You also receive free lifetime updates of your e-books, which includes corrected reprints.

I'm currently using a discount coupon, which is not advertised on the site, to save on my purchases. The coupon code is AUTHD, and when you apply this code at checkout, it will entitle you to 50% off e-books and videos, and 40% off regular books.

I'm not sure how long this code will last, but it's valid now, so please feel free to try it. Good luck.

Reply:

Just got another email from O'Reilly announcing a new Back-to-School promotion offering the same discounts as above, but with a new discount code.

The new discount code is B2S2, and expires September 11, 2012 at 11:59pm PT. Enjoy.

------------------------------------
Reply:

You probably know that O'Reilly is the authorized distributor for Microsoft Press. Just went to the oreilly.com site and found that the 50% discount special has been extended for another week.

The discount code is still B2S2, but it now expires September 18, 2012 at 11:59pm PT. Enjoy.

------------------------------------

Fault tolerance on Hyper v

Hi,

I have installed hyper v and will create 2 VM on that server. I have 5 physical hard disk with 300 GB each. My plan is to create RAID 1 disk for system drive for both the VM and hyper v server, and to create RAID 5 disk for data drive for both the VM. How should I implement the same on my hyper v.

Can I create 2 VHD from the RAID 5 disk and can I assign those VHD to different VM in same hyper v? Also let me know is this type of solution will provide fault tolerance to my data for my both the VMs.

Reply:

Yes, you can create two different RAID sets on your system. Yes, you can create multiple VMs and multiple VHDs and place them in any location you want on the host. Different VMs will have to have different VHDs. The only way you can get VMs to use the same storage is if you set up a cluster between the VMs, and then you would need to present the storage to the VMs as iSCSI LUNs for them to see the same storage.

Putting the data for the VMs on RAID 5 will provide a level of fault tolerance within the storage. However, if the host controller goes down, there is no access to the RAID 5 storage, so that would not provide tolerance for that sort of fault. The term 'fault tolerance' means different things to different people.

tim

------------------------------------
Reply:

Hi,

In this way, we cannot speak about fault tolerance, because your critical point will be the Hyper-v system (OS). If you want a full fault tolerance, you need to create an hyper-v cluster failover, with 2 hyper-v servers at minimum.

About your question, yes you can do it like you have detailed.

But, keep in mind, that the best practice is to store the VHD files (OS and Datas disks) on another disk than the one wich contain the hyper-v OS.

If you store the VM's OS Vhd on the disk wich contain the hyper-v OS, you can have some performances issues.

Best regards

Raynald CHAFFAUX Consultant Virtualisation Nelite North Africa

------------------------------------
Reply:

Hello,

You can certainly put VHDs on different storage targets. In your scenario, you can do as you mention, where your VHDs are split between RAID 1 and RAID 5. As for fault tolerance, you have a few options.

1. Create a Hyper-V Cluster. In a Hyper-V Cluster you have virtual machines running off a form of shared storage (SAN / SMB 3.0 target), and virtual machines can be run on any of the individual servers. You can also live migrate between the servers and if a host fails, a virtual machine will automatically start on another host. Note that Live Migration is not dependant on shared storage, but automatic failover is.

2. Use Hyper-V Replica. Hyper-V Replica is not really fault tolerance as much as it is failover. If you didn't have money for a SAN, but wanted to be able to replicate your virtual machines to a failover site, you can use Hyper-V Replica. Hyper-V Replica can replicate a virtual machine, maintain snapshots at the failover site, and perform test validations of the failover VM. It does not automatically bring up a VM in a failure, but it does provide cross-site failover capabilities. It can be combined with a cluster to replicate from the cluster to another host. Here is how to configure it:

http://blog.concurrency.com/infrastructure/configure-hyper-v-replica-in-windows-8/

Nathan Lasnoski

http://blog.concurrency.com/author/nlasnoski/

------------------------------------
Reply:

Hi,

I have installed hyper v and will create 2 VM on that server. I have 5 physical hard disk with 300 GB each. My plan is to create RAID 1 disk for system drive for both the VM and hyper v server, and to create RAID 5 disk for data drive for both the VM. How should I implement the same on my hyper v.

Can I create 2 VHD from the RAID 5 disk and can I assign those VHD to different VM in same hyper v? Also let me know is this type of solution will provide fault tolerance to my data for my both the VMs.

Microsoft has no technology like you want. You can either use failover cluster or use application built-in clustering tools or if you need to have real FT for generic application - use VMware. They have true working FT.

-nismo

------------------------------------

Ms Support forum

Thursday, February 24, 2022