a. From the Pentaho User Console Home, click Browse Files. The Browse Files page appears.<\/p>\n
b. From the Browse pane on the left, click to choose the destination folder for the upload.<\/p>\n
c. With the destination folder highlighted, click Upload in the Folder Actions pane on the right. The Upload dialog box appears.<\/p>\n
d. Browse to the file or folder to be uploaded by clicking Browse.<\/p>\n
e. Click OK to begin upload using the default settings.<\/p>\n
f. Choose preferences for the upload by clicking to expand the Advanced Options menu.<\/p>\n
g. Choose Replace the Existing File or Do Not Upload from the first menu.<\/p>\n
h. Choose File Permissions from the second menu. The choices are Do Not Change Permissions or Retain Permissions on the Uploaded File.<\/p>\n
i. If you selected Retain Permissions on the Uploaded File, choose File Ownership by selecting Do Not Change Owner or Set Owner Based on Uploaded File from the third menu.<\/p>\n
j. Choose None, Short, or Verbose from the Logging menu.<\/p>\n
k. Click OK.<\/p>\n
a. Open the command line interface by clicking Start and typing cmd. Press Enter.<\/p>\n
b. From the command line interface, go to the location where you have a local copy of Biserver-EE installed, such as \/home\/pentaho\/server.<\/p>\n
c. Enter a space, then type the arguments for upload into the command line interface. A completed upload argument would look something like this:<\/p>\n
$ import-export.bat --import --url=http:\/\/ip:port\/pentaho --username=admin --password=password --charset=UTF-8 --path=\/public --file-path=\/home\/Downloads\/pentaho-solutions.zip --overwrite=true --permission=true --retainOwnership=true<\/pre>\nd. Press Enter after the arguments are typed.<\/p>\n
3. Exporting from Pentaho+ Repository<\/h3>\n
Export Folder contains many files:<\/strong><\/p>\n
a. From the Pentaho+ User Console Home, click Browse Files. The Browse Files page appears.<\/p>\n
b. From the Browse pane on the left, browse to the location of the folder to be downloaded.<\/p>\n
c. With the folder highlighted, click Download in the Folder Actions pane on the right.<\/p>\n
d. Choose Save File in the window that appears, and click OK.<\/p>\n
e. The folder is saved as a .zip file with the manifest located in the top level of the file.<\/p>\n
Export files individually:<\/strong><\/p>\n
a. From the User Console Home, click Browse Files. The Browse Files page appears.<\/p>\n
b. Browse to the location of the file by clicking through the folders in the Browse pane on the left. The Files pane in the center populates with a list of reports.<\/p>\n
c. Click to select the file in the Files pane and choose Download in the Folder Actions pane on the right.<\/p>\n
d. Choose Save File in the window that appears, and click OK.<\/p>\n
e. The file is saved as a .zip file with the manifest located in the top level of the file.<\/p>\n
Export through Command Line:<\/strong><\/p>\n
a. Open the command line interface by clicking Start and typing cmd. Press Enter.<\/p>\n
b. From the command line interface, go to the location where you have a local copy of Biserver-EE installed, such as \/home\/dev701\/pentaho\/server.<\/p>\n
c. Enter a space, then type the arguments for download into the command line interface. A completed download argument would look something like this:<\/p>\n
import-export.bat --export --url=http:\/\/ip:port\/pentaho --username=dvader --password=password --charset=UTF-8 --path=\/public --file-path=\/home\/Downloads\/pentaho-solutions.zip --overwrite=true --permission=true --retainOwnership=true<\/pre>\nd. Press Enter after the arguments are typed.<\/p>\n
Move File repository using export-import for Pentaho data integration<\/h3>\n
1. Importing to Pentaho+ Repository<\/h3>\n
a. In Spoon, go to Tools > Repository > Import Repository.<\/p>\n
b. Locate the export (XML) file that contains the solution repository contents.<\/p>\n
c. Click Open. The Directory Selection dialog box appears.<\/p>\n
d. Select the directory in which you want to import the repository.<\/p>\n
e. Click OK.<\/p>\n
f. Enter a comment, if applicable.<\/p>\n
g. Wait for the import process to complete.<\/p>\n
h. Click Close.<\/p>\n
2. Import through Command Line<\/h3>\n
a. Go to pentaho server appropriate path and run the below command,<\/p>\n
$ sh import.sh -rep=TestRepo -user=admin -pass=password -dir=\/home\/dev701 -file=myTestJob.kjb -rules=import-rules.xml -coe=false -replace=true -comment=\"New version upload from UAT\"<\/pre>\n3. Exporting from Pentaho Plus Repository<\/h3>\n
a. In Spoon, go to Tools > Repository > Export Repository.<\/p>\n
b. In the Save As dialog box, browse to the location where you want to save the export file.<\/p>\n
c. Type a name for your export file in the File Name text box.
\nNote: The export file will be saved in XML format regardless of the file extension used.<\/p>\nd. Click Save.<\/p>\n","protected":false},"excerpt":{"rendered":"
Import and export of a file repository can be done by using import\/export built-in functions. These procedures are useful for backing up and restoring content in the solution repository. <\/p>\n","protected":false},"author":23,"featured_media":2158,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[424],"tags":[554,549,555],"class_list":["post-2134","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-pentaho","tag-file-repository","tag-pentaho-business-analytics","tag-pentaho-repository"],"acf":[],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2134","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/comments?post=2134"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/posts\/2134\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media\/2158"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/media?parent=2134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/categories?post=2134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/blogs\/wp-json\/wp\/v2\/tags?post=2134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}