FeedZcollector Support
How can I change database type and how can I rename or move the FeedZcollector database?
The installation process prepares FeedZcollector for use with Microsoft Access on your system.
A sample database FeedZcollector.mdb is created in the folder c:/Program Files/Feedzcollector/.
The configuration of FeedZcollector is defined in a file named fcs.exe.Config. It is located in the folder c:/Program Files/Feedzcollector/Resources/
Immediately after installation it looks like this:
1 <configuration>
2 <appSettings>
3
4 <!-- Connectionstring. Dont forget to use the correct 'Database' value -->
5 <add key="ConnectionString" value="Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Program Files\FeedZcollector\FeedZcollector.mdb;Uid=Admin;Pwd=;" />
6 <!-- Example: MySQL connectionstring <add key="ConnectionString" value="DRIVER={MySQL ODBC 3.51 Driver};SERVER=[Hostname];DATABASE=FeedZcollector;UID=root;PASSWORD=;OPTION=3" />-->
7
8 <!-- Database type. Valid values are 'Access' and 'MySQL' -->
9 <add key="Database" value="Access" />
10
11 <!-- Spider interval. '1000' means that every second this spider picks a feed from the queue -->
12 <add key="GrabTimer" value="10000" />
13
14 <!-- Not used -->
15 <add key="ProxySettings" value="http://localhost:8080" />
16
17 <!-- Not used -->
18 <add key="Kanaal" value="0" />
19
20 </appSettings>
21 </configuration>
Changing the location, the name or type of database requires change of this configuration file.
Change MS Access database location
It is allowed to move the MS Access database to any location you prefer, as long as the system where FeedZcollector is running can connect through a connection string as coded in the configuration file. This location may be on the system itself or on any server that allows to connect to a hosted MS Access database.
The new location can be configured in the configuration file c:/Program Files/Feedzcollector/Resources/fcs.exe.Config
a) Stop FeedZcollector
b) Make sure you keep a backup copy of the original file
c) Change the configuration file as follows:
- Line 5: Change the substring 'c:/Program Files/FeedZcollector/' into the path to the location of your choice.
d) Save and close the file after you finished editing.
e) Start FeedZcollector
Change MS Access database name
It is allowed to change the MS Access database name as long as it complies with Microsoft Windows file naming conventions.
The new name can be configured in the configuration file c:/Program Files/Feedzcollector/Resources/fcs.exe.Config
a) Stop FeedZcollector
b) Make sure you keep a backup copy of the original file
c) Change the configuration file as follows:
- Line 5: Change the substring 'FeedZcollector' (just in front of '.mdb') into the name of your choice. Do NOT CHANGE the extension!
d) Save and close the file after you finished editing.
e) Start FeedZcollector
Change database type from MS Assess to MySQL:
The database type can be configured in the configuration file c:/Program Files/Feedzcollector/Resources/fcs.exe.Config
a) Stop FeedZcollector
b) Make sure you keep a backup copy of the original file
c) Change the configuration file as follows:
- Line 6:
Comment out this line by inserting <-- in front of it and --> at the end of this line.
- Line 7:
Remove '<-- Example: MySQL connectionstring' at the beginning of this line
Remove '-->' at the end of this line
Change '[Hostname]' into the name of the server the MySQL database is hosted. Don't forget to remove the square brackets ([ & ])
- Line 9:
Change 'Access' into 'MySQL'
d) Save and close the file after you finished editing
e) Connect to the database server (for instance with SQLYog) and run the SQL script FeedZcollector.sql that is located in the folder c:/Program Files/Feedzcollector/
f) Start FeedZcollector
N.B. When using a MySQL database the MySQL Connector/ODBC 3.51 is required.
» MySQL Connector/ODBC 3.51 download and instructions page
