Get-XmlEulandaBreadcrumb #
SYNOPSIS #
Get-XmlEulandaBreadcrumb generates an XML fragment containing all breadcrumb paths in which an article is found in a property tree.
SYNTAX #
Get-XmlEulandaBreadcrumb [-id <Int32>] [-breadcrumbRoot <String>] [[-tablename] <String>] [[-conn] <Object>]
[[-udl] <String>] [[-connStr] <String>] [-ProgressAction <ActionPreference>] [<CommonParameters>]
DESCRIPTION #
The function takes various parameters such as -barcode, -articleNo, -articleId, and -articleUid to specify the article. The -breadcrumbPath parameter specifies the root of the property tree path starting with a backslash \. The -tablename parameter specifies the table that the property tree corresponds to. The function can connect to a database using either the -conn parameter, the -udl parameter, or the -connStr parameter.
The XML fragment generated by the function contains a list of breadcrumb paths for the specified article.
EXAMPLES #
Example 1:This example generates an XML fragment containing all breadcrumb paths for one article #
PS C:\> Get-XmlEulandaBreadcrumb -articleNo '130100' -breadcrumbPath '\Shop' -tablename 'Article' -udl 'C:\temp\Eulanda_1 JohnDoe.udl'
<MERKMALLISTE>
<MERKMAL>
<PFAD>\Profi-Aqua\Make-Up</PFAD>
</MERKMAL>
<MERKMAL>
<PFAD>\Profi-Aqua\Sensible</PFAD>
</MERKMAL>
</MERKMALLISTE>
This example generates an XML fragment containing all breadcrumb paths in which article number 130100 is found in the Article property tree starting at the root \Shop. The XML fragment contains a single MERKMAL element with the PFAD (path) sub-element containing the breadcrumb path.
PARAMETERS #
-conn #
The connection can be established via an existing ADO object of the type ‘ADODB.Connection’. If the connection is already open, it remains open even after the function has been executed. If it was closed, it will be closed again after the function has been executed.
Type: Object
Parameter Sets: (All)
Aliases:
Required: False
Position: 6
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-connStr #
A ConnectionString can be specified here, with which a database can be opened.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 8
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-tablename #
The parameter specifies the name of the table for which the property tree should be exported. Currently, three tables are supported: Article, Address, and Delivery. The valid table names can be retrieved using the Get-MappingTablename function, which allows input in both the native and English names.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 5
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-udl #
Alternatively to a connection, a string to a UDL file can be specified. In this case an ADO object is created and closed again at the end of the function.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 7
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-breadcrumbRoot #
The root from which to export the properties from the property tree.
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
-id #
The id to the record, such as the item or delivery bill, that is to be exported.
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False
CommonParameters #
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.