madams
26th June 2007 21:11 UTC

Can NSIS do this?
Hello,

I am totally new to NSIS and was wondering if I could use it to create an installer file that would do the following:

1) Take in a bunch of information from the user and edit values in .properties, .txt and .sql files to reflect this information.

2) Execute the edited .sql file to create a MySql database.

3) Execute an ANT command to build the code.

If anyone knows if NSIS can be used to complete the above tasks please let me know.

Thanks!

Joel
27th June 2007 00:51 UTC

Yes to all...
Basically using plugins, like this.

madams
27th June 2007 14:44 UTC

Thanks for the reply Joel. I think I have located most of the plugins that I will need to do the job:

1) Edit text file with user info: TextReplace plugin (http://nsis.sourceforge.net/TextReplace_plugin)
2) Execute SQL file: MSSQL OLEDB plug-in (thanks to Joel)
3) Execute ANT command (via command prompt) to build the code: ExecCmd plug-in (http://nsis.sourceforge.net/ExecCmd_plug-in)

If someone could tell me if these are the correct plugins for the job, I would really appreciate it. Also, I couldn't find any plug-ins to manipulate .properties or .txt files. Does anybody know where I could find such plug-ins?

Thanks a lot.

EDIT: The hyperlinks weren't working for some reason so I took them out.

Comm@nder21
27th June 2007 20:54 UTC

i guess the plugins are correct.

though, depending on how the target system is prepared, you may not need any plugins at all.

for (text)file editing have a look at the "Useful Headers" section in the NSIS documentation. this should fit the .properties and .txt files as well as the one mentioned in #1.

for #2: if you just want to execute an sql file, doesn't

ExecWait sql.exe file.sql