BO3.1Script

来源：互联网发布：腾讯何时优化吃鸡编辑：程序博客网时间：2024/05/01 02:46

The BIARCommand Line Tool only supports migrating objects from one XI 3.x system toanother. You cannot use the tool to import objects from BusinessObjects,Crystal Enterprise, or earlier version of BusinessObjects Enterprise. You mustuse the Import Wizard to import content from previousversions ofBusinessObjects to XI 3.x.

The BiarEngine Command Line tool is called biarengine.jar. On a windows environment,this file is located at Install Directory\Business Objects\common\4.0\java\lib.On UNIX, the file is located at Install Directory/bobje/java/lib/.InstallEntSdkWrapper.jar,the command-line tool for importing BIAR files in BusinessObjects Enterprise XIRelease 2, is not supported with BusinessObjects Enterprise XI 3.x. You mustuse biarengine.jar when importing content from BIAR files in BusinessObjectsEnterprise XI 3.x.

Windows:Script

EXPORT:

Export_BO3.1.bat

cd D:\APPS\Business Objects3.1\common\4.0\java\lib

java -jar biarengine.jarD:\Backups\BIARExport.properties

cd \Backups

mdbiars\%date:~4,4%%date:~9,2%%date:~12,2% :: this is to create the folder withthe current time

move Louis_Prod_Test*.biarbiars\%date:~4,4%%date:~9,2%%date:~12,2%::this is a move Biar file to the previousstep to create the folder

cd D:\APPS\Business Objects3.1\common\4.0\java\lib

java -jar biarengine.jarD:\Backups\BIARExport.properties

cd D:\Backups

move Louis_Prod_Test.biarlouistest

::NamedBiar file after the current time

@echo off

set new=%time::=%

cd D:\Backups\louistest

ren Louis_Prod_Test.biar%new:~1,6%.biar

::Keep in recent five biar file

for /f "skip=5tokens=*" %%i in ('dir /b /a-d /o-d D:\Backups\louistest') do del /f /q D:\Backups\louistest\"%%i"

BIARExport.properties

exportBiarLocation=d:/Backups/Louis_Prod_Test.biar

action=exportXML

userName=fengming

password=

CMS=HMARTQM2:6401

authentication=secEnterprise

includeSecurity=flase

exportDependencies=flase

exportQuery1=select * fromci_Infoobjects where si_name = 'Employees' and si_kind = 'Webi'

exportQuery2=select * fromci_Systemobjects where si_name = 'Employees' and si_kind = 'Server'

exportQuery3=select * fromci_Appobjects where si_name = 'Employees' and si_kind = 'Universe'

Note: when only one exportQuery,only use exportQuery= not exportQuery1=

This is named BIARExport.propertiesand placed in the above directory.
exportBiarLocation shows the file to be created, in thiscase in the d:/Backups
The Admin User and Password together with the name of theCMS should be entered appropriately.
The exportQuery:
select * from ci_Infoobjects
is a select of the entire repository.
This can be changed appropriately to select what youwant.
You can set up a batch file to invoke biarengine.jar andif necessary move, rename, delete or copy the previous BIAR file.

IMPORT:

Import_BO3.1.bat

cd D:\APPS\Business Objects3.1\common\4.0\java\lib

java -jar biarengine.jarD:\Backups\BIARImport.properties

BIARImport.properties

importBiarLocation=d:/Backups/Louis_Prod_Test.biar

action=importXML

userName=fengming

password=

CMS=HMARTQM2:6401

authentication=Enterprise

CI_INFOOBJECTS Contains portal content

CI_SYSTEMOBJECTS Containssystem objects required for the system to function and that are displayed andmanaged in the user interface

CI_APPOBJECTS Other objects stored in therepository but managed through client-server tools or add-ons to the system

1. CI_INFOOBJECTS Kinds

SI_KIND Value

CeKind Enumeration

Interface

AFDashboardPage

AFDASHBOARDPAGE

Unpublished

Analytic

ANALYTIC

Unpublished