I put together a script and some XSLT files to automate the process of creating an ICA database from a sample excel. The idea is to make it very easy to do a POC using ICA when the end user gives data in the form of csv or excel (which is typically the case)
Unzip the attach xslt.zip file in the TAKMI_HOME directory (usually \Program Files\IBM\takmi). This will create TAKMI_HOME\xslt with 3 xslts and also add the file takmi_xls_to_database.bat to the TAKMI_HOME\bin directory
To create a new database for example NewCo from survey.xls do the following
a) Ensure the first row of survey.xls contains the column headings. Edit the headings to remove all non alphanumeric characters. Also note that these headers will appear as is in the OAE UI, so change them now if you want to see a different wording
b) create a new spreadsheet and copy just the first row of survey.xls to the first row of the new spreadsheet
ci) add 'id' as a comment for the cell that has the heading for the column that has the document id's this is optional
cii) add 'date' as a comment for the cell that has the heading for the column that has the document dates this is optional
ciii) add 'title' as a comment for the cell that has the heading for the column that has the document summary or title this is optional
civ) add 'text' as a comment for the cells that have the headings for the columns that have the document text
d) save the new spreadsheet as XML (this is an option in the save as menu of excel). For this example lets use the name head.xml
e) save survey.xml as csv (this is an option in the save as menu of excel). For this example lets use the name survey.csv
f) copy TAKMI_HOME\resource\database.template\en to TAKMI_HOME\databases\NewCo
g) cd TAKMI_HOME\bin
h) run takmi_xls_to_database.bat ..\databases\NewCo <path to head.xml> <path to survey.csv>
the script takmi_xls_to_database will create all the config files (data_ingester_config_csv2atml.xml, database_config.xml and category_tree.xml) as well convert the csv to ATML, run the NLP to create the MIML and run the indexer to create the index
i) edit TAKMI_HOME\global_config.xls to add a database entry for NewCo
j) stop/restart WAS - go to the OAE root page, the database for NewCo should now be usable
This topic has been locked.
1 reply Latest Post - 2009-02-27T13:47:48Z by SystemAdmin
Pinned topic script to simply creation of new database from sample xls or csv file
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2009-02-27T13:47:48Z at 2009-02-27T13:47:48Z by SystemAdmin
SystemAdmin 110000D4XK7 PostsACCEPTED ANSWER
Re: script to simply creation of new database from sample xls or csv file2009-02-27T13:47:48Z in response to SystemAdminHi <sreevb>,
Would the script (takmi_xls_to_database.bat)work with the *8.4.2 ICA*?
I ask since you posted this in Jul.08, when ICA was called OmniFind, and I am not sure whether there are any architectural changes.
If the script will work in ICA, then this would be very useful for my purposes.
Thanks, in advance.