Hi Roberto et all, Sure, talend can be used to load the latest data. The latest_data.sql can be broken into various files, either csv or xml, for each table. Talend can then load these files and do some additional transformation/apply rules to the data being loaded. Thanks and regards *ravi
Roberto Musso/Ireland/Contr/IBM 03/03/2008 12:02 To Developer <[email protected]>, Ravi Kutaphale/Ireland/[EMAIL PROTECTED] cc Mifos Developer Mailing List <[email protected]>, [EMAIL PROTECTED] Subject Re: [Mifos-developer] Database upgrade from 174 to 175 Hi ravi, just a question: can be used Talend to pilot the data upgraded ? That means put the data in one or more file and after run a talend job, instead of modify and later running latest_data.sql scripts? Having the data separated from the inserting them in the Mifos database could be a great improvement. as we, at leat, avoid to hard code data inside sql statement as it is now using latest_data.sql script. Best Regards Adam Monsen <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/29/2008 09:28 PM Please respond to Developer <[email protected]> To Mifos Developer Mailing List <[email protected]> cc Subject Re: [Mifos-developer] Database upgrade from 174 to 175 On Fri, 2008-02-29 at 11:46 +0530, Amiruddin Nagri wrote: > We are receiving MIFOS Database Version Upgrade Error on running MIFOS > from latest checkout code this morning. Thank you for letting us know. I'm also affected, though I'm not sure what the solution is just yet. We're looking into it. > We also noticed that there is no 'upgrade_to_175.sql' file added > to /sql folder which will upgrade the database to the required > version. Version 175 is a Java-only upgrade. See register175() in DatabaseVersionPersistence. > Can someone suggest how to upgrade from 174 to 175 ? This is done automatically when the mifos WAR is deployed. See syncDatabaseVersion() in ApplicationInitializer. Information on Java upgrades will eventually be added to http://mifos.org/developers/technical-orientation/mifos-database-development ( http://tinyurl.com/2evefr ). I would suggest running "ant build_db" to fix the database your running Mifos application connects to, but this doesn't appear to be working right now. "ant build_test_db" does appear to get the test database in a known/good state, but I'm having other problems with the unit tests right now (see my post about leap year--that probably won't affect you by the time you read this, though). -- Adam Monsen ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
