Mapping schema for GoogleBase XSD

I want to load into a SQL Server table with SQLXMLBulkload an xml file that
is formatted with google base xsd (http://base.google.com/base/base.xsd). I
need a mapping schema for that, correct? To map the elements of the xml to
my table. Does anyone have a mapping schema for this?
Steve
Hi Steve
The mapping depends on the database tables to which you want to map it to.
Best regards
Michael
"Steve Mc" <stevemc@.zillow.com> wrote in message
news:OGEN6NOiHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I want to load into a SQL Server table with SQLXMLBulkload an xml file that
>is formatted with google base xsd (http://base.google.com/base/base.xsd).
>I need a mapping schema for that, correct? To map the elements of the xml
>to my table. Does anyone have a mapping schema for this?
> Steve
>
|||Hello,
Please take a look at http://msdn2.microsoft.com/en-us/library/ms172649.aspx
to understand how annotations work.
Let me know if you need further assistance.
Regards,
Monica Frintu
"Steve Mc" wrote:

> I want to load into a SQL Server table with SQLXMLBulkload an xml file that
> is formatted with google base xsd (http://base.google.com/base/base.xsd). I
> need a mapping schema for that, correct? To map the elements of the xml to
> my table. Does anyone have a mapping schema for this?
> Steve
>
>

Mapping schema for GoogleBase XSD

I want to load into a SQL Server table with SQLXMLBulkload an xml file that
is formatted with google base xsd (http://base.google.com/base/base.xsd). I
need a mapping schema for that, correct? To map the elements of the xml to
my table. Does anyone have a mapping schema for this?
SteveHi Steve
The mapping depends on the database tables to which you want to map it to.
Best regards
Michael
"Steve Mc" <stevemc@.zillow.com> wrote in message
news:OGEN6NOiHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I want to load into a SQL Server table with SQLXMLBulkload an xml file that
>is formatted with google base xsd (http://base.google.com/base/base.xsd).
>I need a mapping schema for that, correct? To map the elements of the xml
>to my table. Does anyone have a mapping schema for this?
> Steve
>|||Hello,
Please take a look at http://msdn2.microsoft.com/en-us/library/ms172649.aspx
to understand how annotations work.
Let me know if you need further assistance.
Regards,
--
Monica Frintu
"Steve Mc" wrote:

> I want to load into a SQL Server table with SQLXMLBulkload an xml file tha
t
> is formatted with google base xsd (http://base.google.com/base/base.xsd).
I
> need a mapping schema for that, correct? To map the elements of the xml t
o
> my table. Does anyone have a mapping schema for this?
> Steve
>
>sql

Many questions about internationalization options

In RS 2000, I have a version of a set of reports (50+) that are in English and formatted for US letter size. I need to have all of these also in French in A4.
What is the best way to do this? Can I use resource files? If so, for the formatting size as well as the language? How would I do that?
If I can't use resource files, are there any other ideas than a set of separate rdl files?
Is this any different in RS 2005?

Hi Patty,

I am interested to seeing some feedback from the microsoft guys themselves on this (multilingual reports).

I have spent the past days on and of looking for some good references on this. You could even drop the good because there is nothing to find on this!

Bert

|||

Here's Microsoft's answer to internationalization:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_building_v1_31bn.asp

|||

There is a way to use expression to be able to internationalize labels within a report. With each meta data element within your report you specify a switch statement where you translate the label into the respective language. Via a report parameter you pass in the language of choice which is then translated at runtime.

E.g.

Label Expression (right-click on label within report):

=Switch

(

Parameters!Language.Value = "E", "English Label",

Parameters!Language.Value = "D", "Deutscher Label"

...

)

Many questions about internationalization options

In RS 2000, I have a version of a set of reports (50+) that are in English and formatted for US letter size. I need to have all of these also in French in A4.
What is the best way to do this? Can I use resource files? If so, for the formatting size as well as the language? How would I do that?
If I can't use resource files, are there any other ideas than a set of separate rdl files?
Is this any different in RS 2005?

Hi Patty,

I am interested to seeing some feedback from the microsoft guys themselves on this (multilingual reports).

I have spent the past days on and of looking for some good references on this. You could even drop the good because there is nothing to find on this!

Bert

|||

Here's Microsoft's answer to internationalization:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_building_v1_31bn.asp

|||

There is a way to use expression to be able to internationalize labels within a report. With each meta data element within your report you specify a switch statement where you translate the label into the respective language. Via a report parameter you pass in the language of choice which is then translated at runtime.

E.g.

Label Expression (right-click on label within report):

=Switch

(

Parameters!Language.Value = "E", "English Label",

Parameters!Language.Value = "D", "Deutscher Label"

...

)

Many questions about internationalization options

In RS 2000, I have a version of a set of reports (50+) that are in English and formatted for US letter size. I need to have all of these also in French in A4.
What is the best way to do this? Can I use resource files? If so, for the formatting size as well as the language? How would I do that?
If I can't use resource files, are there any other ideas than a set of separate rdl files?
Is this any different in RS 2005?

Hi Patty,

I am interested to seeing some feedback from the microsoft guys themselves on this (multilingual reports).

I have spent the past days on and of looking for some good references on this. You could even drop the good because there is nothing to find on this!

Bert

|||

Here's Microsoft's answer to internationalization:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_building_v1_31bn.asp

|||

There is a way to use expression to be able to internationalize labels within a report. With each meta data element within your report you specify a switch statement where you translate the label into the respective language. Via a report parameter you pass in the language of choice which is then translated at runtime.

E.g.

Label Expression (right-click on label within report):

=Switch ( Parameters!Language.Value = "E", "English Label", Parameters!Language.Value = "D", "Deutscher Label" ... )sql