What is the INI file?

With every install of Genesis R&D Foods, there is an ini file created that can be modified for various changes. Below is a line-by-line explanation of the ini file. (The order of lines may be slightly different in your ini file.)

INI files are located in the install directory (by default C:\Program Files (x86)\Esha Research\GenesisSQL\genesissql.ini)

Note: To edit the ini file either open Notepad as Administrator and navigate to the file location, edit and save the changes.

Alternatively:

The easiest method to edit and save any changes is to copy the ini file to the desktop, edit and save your changes and copy and replace the file back to the program directory.

Example INI File

1. [DatabaseConnection] 
2. DatabaseName=gendata 
3. AttachDBFileName=C:\ProgramData\Esha Research\data\gendata.mdf
4. Provider=SQLNCLI11
5. ServerName=servername\esha
6. DBConnectionString=Provider=SQLNCLI11;Data Source=servername\esha;Initial Catalog=gendata;Integrated Security=SSPI;User Id=;
7. UsesUDLFileConnection=0
8. UDLFilePathString=
9. CommandTimeout=20
10. ConnectTimeout=180
11. [Application]
12. UseGlobalSettings=0
13. GlobalSettingsOwnerId=0
14. GlobalSettingsOwnerName=
15. NovaPdfPrinterName=Genesis PDF Printer
16. NutrientFilesFolderPath=C:\NutrientFiles
17. AlternateReportFilesFolderPath=C:\CustomReports 
18. PersonalTemplateFolder=C:\EshaPortTemplates (This is only for ESHA Port)
19. [Recent File List] 

Line options and other settings:

[DatabaseConnection] 
Denotes the Database Connection section

DatabaseName=gendata
typically "gendata" for Genesis R&D but can be custom name of your database as well, you can verify this with the mdf name on the server

AttachDBFileName=
This is the location of the database file, it can be left blank as noted on the left of the path to the mdf as in line 3 above

Provider=
There are three potential options for this line
   · MSOLEDBSQL.1 (SQL Server 2014 and later)
   · SQLNCLI11 (SQL Server 2012 and later)
   · SQLOLEDB.1 (SQL Server 2008)

ServerName=SQL Server Instance Name. 
Typically, [COMPUTERNAME\ESHA] for an ESHA-installed SQL Server instance.  For a local install it can be (localdb)\v11.0.  It can also be different than the servername\esha format if you created your own instance for the database.  For some cases, a Port is required (e.g. [SERVERNAME], [PORT NUMBER]).

DBConnectionString=Provider=[Provider= from above];Data Source=[SQL Server Instance Name];Initial Catalog=[Database Name as Attached in SQL Server];Integrated Security=SSPI;User Id=; 
This is the connection string and should match with the previous lines (data source = servername and initial catalog = database name) 

UsesUDLFileConnection=0 
This is set to 0 normally, it will be set to 1 if you want to force the UDL connection

UDLFilePathString= 
If using the UDL file, this is the path to where you have the udl file (most commonly in the install directory)

CommandTimeout=20 
This controls the timeout on commands, 20 seconds is default and rarely changed

ConnectTimeout = 180
This controls the timeout when launching the program and connecting to the database, on slow systems this may be extended or rarely shortened (for testing) measured in seconds 180 allows for 3 minutes to connect to the database before timing out

[Application] 
Denotes the Application section

UseGlobalSettings=0 
Change to 1 to use global settings (share settings between users)

GlobalSettingsOwnerId=0 
The owner of the global settings, the name of the user who will be the default settings. Typically it would be something like DomainName\UserName if you are using Windows authentication

NovaPdfPrinterName=Genesis PDF Printer
Starting with 11.4 versions of Genesis and Food Processor this line is set to either Genesis PDF Printer or FoodPro PDF Printer

NutrientFilesFolderPath=C:\NutrientFiles 
This sets an alternate location for nutrient files (this can be a shared drive as well.) The program will look in both the c:\program files (x86)\esha research\programname\nutrientfiles\ and c:\programdata\esha research\programname\nutrientfiles\ folders to find .nut files

AlternateReportFilesFolderPath=C:\CustomReports 
This sets an alternate location for Report Files (this can be a shared drive as well.) The default path for reports is C:\Program Files (x86)\Esha Research\programname\AdditionalReports

PersonalTemplateFolder=C:\EshaPortTemplates 
This is only for ESHA Port, this will allow for additional templates (epf files) to be selected from the template drop-down menu

[Recent File List] 
The files listed here are automatically logged by the program to show up in your recent file list menu on your respective program