Splitting Data Files

Prior to separating the Datafiles, make sure that you close all 4D clients and then 4D Server (if running in Server mode).

In standalone, make sure that you quit 4D Runtime or exit CurrencyXchanger.

Duplicate The CurrencyXChanger Folder

  • First you must locate the 'CurrencyXChanger' folder on your hard drive (usually located in the root folder C:\).
  • Duplicate the folder by right clicking on the folder and selecting 'Copy'.
Duplicate The CurrencyXChanger Folder
  • Then right click in the same location and select 'Paste'.
  • When you 'Paste' the folder it will be renamed by the OS as a 'Copy'.

Rename the Folder

  • Rename the duplicate folder something meaningful (ie; add ' _YEAR' to distinguish between previous year files).
  • To rename the folder right click on it and select 'Rename'.
Rename the Folder

**IT IS VERY IMPORTANT TO NAME ALL THE FILES CONSISTENTLY.

Rename The DateFiles Folder

  • Open the new folder and find the DataFiles folder then rename it. The DataFiles folder is inside the CurrencyXchanger folder.
  • Remember to be consistent with the renaming, ie; always add the same postfix (e.g._2015).
Rename The DateFiles Folder

Rename The Structure File

  • Remember to also be consistent with the renaming the Structure File.
Rename The Structure File

Rename the Structure Resource Files

  • Also rename the Structure Resource Files. If you cannot see the extension of the file (.RSR) then you should rename all files consistently.
  • If you rename a file inconsistently this process will not work and the database won't be able to work.
Rename the Structure Resource Files

1) Open the new renamed structure file by clicking 'Browse' (see step below)

2) Open the new data file (see two steps below)

3) Click 'Open Interpreted'.

Opening the new structure file

Opening the new structure file

Rename the datafile

Rename the datafile

If you pay attention, you can see that the data file in this step is still using 2011, although it is located in the 2012 folder. By right clicking on the data file, you can rename it.

After you renamed the datafile, you can now open it.

Missing Log File

Missing Log File

Since the datafile is renamed, 4D will not be able to associate the old log file to the new data file, therefore it will give you the above error message. At this point you have to create a new log file.

Creating a new Log File

Creating a new Log File

Create a new log file by clicking the new button.

Make sure that you  rename the log file consistent with the data files and structure file (adding the correct postfix 2012).

Backup

Backup

After you create a new log file, the database needs to backup.

One last check.

One last check.

At this point, the structure file, data file, log file and backup file should all be postfixed with _2012. Run 4D client and make sure that all data from last year is still avaialable.

0 Comments

Add your comment

E-Mail me when someone replies to this comment