Jump to content
hamamelis@ntlworld.com

TMG 7.04 - Backup/restore works under linux wine

Recommended Posts

The problem noted below has been corrected with TMG V 704

For further details of installing see http://appdb.winehq.org/objectManager.php?...TestingId=37240

 

************* Note below only applies to versions of TMG before 7.04 **********************************

TMG 7.03 Works well under linux wine with one problem: backup.

 

Mon 10 Nov 2008: Wholly Genes are onto this problem and Jim Byram has found the solution and this will be made available imminently with release 7.04.

 

System: wine v1.1.7 (& earlier recent versions) & Crossover Office v7.1 with Ubuntu Hardy 8.04 Linux as of October 2008. I use both a PC and a Acer Travelmate 3004 laptop. I use the UK version of TMG.

 

The instructions for installing TMG7 under wine can be found here:

http://appdb.winehq.org/objectManager.php?...TestingId=23660

 

Instructions for installing TMG7 under Crossover Office can be found here. Crossover is the commercial operation of wine and automatically installs new applications in separate instances of wine.

http://www.codeweavers.com/compatibility/b...rum=1;msg=28168

 

If you do all this correctly then TMG runs faultlessly as far as I and others can see. However there is one mysterious problem with the generation of the .sqz file during backup. The backup appears to go fine but there are about 45 essential project files not copied to the backup. The same problem appears in CrossOver v7.1.0, the commercial version of wine.

 

This problem did not occur with TMG 6. In fact, TMG6 will back up a TMG7 project perfectly with all the project appearing as they should be. So there is something about TMG7 which is different which is causing this problem

 

Below are the details of what happens taken from the winehq website above. These were written by me. Along with Nathan N, I am a maintainer of TMG running under wine.

 

I have copied these here and I would be grateful if any TMG/VFP specialists would have a look at this and see if they can fathom why these files are missing. This has been mentioned before in a post related to a slightly different issue and I think it merits being a thread of its own.

 

 

********************************************************************************

*********************************************

NOTE WELL: As yet, the Backup project does not function correctly under either Wine 1.1.7 or Crossover 7.02, TMG703 & Ubuntu 804 Hardy . When a Backup is performed all appears to go correctly and the .sqz file is created. Restore works correctly but I find that I get the message "Nothing to Restore". The Backup has backup all configurations but ignored the Project files. I see no warning to this effect. I wonder if there is a dll relating to zip that has to be altered.

There is a workaround. All the Project files are in the directory UserData=C:\TMG7\UserData stated in Data_paths.txt.

 

Solution 1: just back these up periodically.

 

Solution 2: Change C:\TMG7\UserData to in, say, the home directory as UserData=z:/home/ian/TMG7Backups, or wherever seems best for you.

 

This problem exists when TMG7 is installed for All User, or just for a single user, ian. The problem does not exist when using WinXP in Win4Lin or VirtualBox with the UserData kept on the home directory so it is not a program error and does not seem to be related to permissions.

 

Every attempt to Backup any project files in TMG7 using Files>Backup with any configuration of project & backup paths results in a successful backup according to TMG. However. always the important 45 or so project files are missing. See below for a list of the files that should be there and what is missing.

 

(This can be checked by opening the TMG7 .sqz backup file in Linux with the archiver and going down the archived directory tree to Projects/Sample. The important 45 or so files are missing.

It just seems that the project files are not being found for some reason.)

 

I have tried to mapping both the project source and destination files to the same drive letter "P:", with still the same result. Every time on Backup the project files are missing. I have tried everything I can think of. It appears to write all the files OK so I wonder if TMG cannot access the project files for some reason. Permissions seems unlikely as all the files in the project folder have the same permissions. It seems more likely to be a problem in VFPro. It is strange that this problem did not occur in TMG6. What is different in this part of TMG7, I wonder?

 

Project files copied into Project/Backup.sqz when using Windows Emulator WinXP

all .acc & .flp files

SAMPLE_UK_A.CDX

sample_uk_a.dbf

sample_uk_a.fpt

SAMPLE_UK_B.CDX

SAMPLE_UK_B.DBF

SAMPLE_UK_C.CDX

SAMPLE_UK_C.DBF

SAMPLE_UK_$.CDX

Sample_UK_c.FPT

SAMPLE_UK_$.DBF

SAMPLE_UK_D.CDX

Sample_UK_d.dbf

Sample_UK_d.FPT

SAMPLE_UK_DNA.CDX

SAMPLE_UK_dna.dbf

SAMPLE_UK_dna.FPT

SAMPLE_UK_E.CDX

sample_uk_e.dbf

sample_uk_e.fpt

SAMPLE_UK_F.CDX

SAMPLE_UK_F.DBF

Sample_UK_f.FPT

SAMPLE_UK_G.CDX

SAMPLE_UK_G.DBF

Sample_UK_g.FPT

SAMPLE_UK_i.CDX

sample_uk_i.dbf

sample_uk_i.fpt

SAMPLE_UK_K.CDX

Sample_UK_k.dbf

SAMPLE_UK_L.CDX

sample_uk_l.dbf

sample_uk_l.fpt

SAMPLE_UK_M.CDX

sample_uk_m.dbf

sample_uk_m.fpt

SAMPLE_UK_N.CDX

sample_uk_n.dbf

SAMPLE_UK_ND.CDX

Sample_UK_nd.dbf

Sample_UK_nd.FPT

sample_uk_n.fpt

SAMPLE_UK_NPT.CDX

Sample_UK_npt.dbf

SAMPLE_UK_NPV.CDX

SAMPLE_UK_NPV.DBF

SAMPLE_UK_O.CDX

sample_uk_o.dbf

SAMPLE_UK_P.CDX

SAMPLE_UK_P.DBF

SAMPLE_UK_PD.CDX

SAMPLE_UK_PD.DBF

Sample_UK_pd.FPT

Sample_UK_p.FPT

SAMPLE_UK__.PJC

SAMPLE_UK_PPT.CDX

SAMPLE_UK_PPT.DBF

SAMPLE_UK_PPV.CDX

SAMPLE_UK_PPV.DBF

SAMPLE_UK_R.CDX

SAMPLE_UK_R.DBF

Sample_UK_r.FPT

SAMPLE_UK_S.CDX

sample_uk_s.dbf

sample_uk_s.fpt

SAMPLE_UK_ST.CDX

SAMPLE_UK_ST.DBF

Sample_UK_st.FPT

SAMPLE_UK_T.CDX

sample_uk_t.dbf

sample_uk_t.fpt

SAMPLE_UK_U.CDX

Sample_UK_u.dbf

SAMPLE_UK_W.CDX

SAMPLE_UK_W.DBF

SAMPLE_UK_XD.CDX

Sample_UK_xd.dbf

 

Files copied into Project/Backup.sqz in wine & crossover

All .acc & .flp files

SAMPLE_UK_DNA.DBF,

SAMPLE_UK_DNA.FPT,

SAMPLE_UK_NPT.DBF,

SAMPLE_UK_NPV.DBF,

SAMPLE_UK_PPT.DBF,

SAMPLE_UK_PPV.DBF

About 45 project files are missing.

 

Can anyone think of a reason for this?

 

I have tried experimenting with altering settings for FoxFix5.dll to no avail.

Thanks to Jim Byram I now know that "Foxsqz5.fll has nothing to do with backup. It is only used when importing very old non-ZIP TMG database backups (v3.5 or so) that were archived using the FoxPro SQZ function."

 

8 Nov 2008

The current situation which has been worked out with the willing help of Jim Byram of Wholly Genes, seems to be:

Something has changed in Visual Fox Pro from version 7 (used in TMG6) to version 9 (used in TMG7). Under wine v1.1.7 and crossover office v 7.1, backup will not include project files. Also the backup.log which is referred to is not produced either. At the moment there is no solution to this because, I understand, the TMG script to run the backup is virtually identical in the two versions of TMG. The DynaZip dlls which are used in TMG7 and TMG6 to produce the .sqz backup file have not changed. TMG6 can be used to backup a TMG7 project and that appears to work OK. I find that this is the easiest way to backup TMG7 projects, even if it is a bit of a pain. However, check that this works for you before relying on it.

Edited by hamamelis@ntlworld.com

Share this post


Link to post
Share on other sites

Foxsqz5.fll has nothing to do with backup. It is only used when importing very old non-ZIP TMG database backups (v3.5 or so) that were archived using the FoxPro SQZ function.

 

The ZIP function is provide by the dynazip library. The dynazip.log might provide some hint but it's really about the zip function and not about backup.

 

WinXP

..\windows\dynazip.log

 

WinVista

C:\Users\username\AppData\Local\VirtualStore\Windows\DYNAZIP.LOG

 

V7.04 will include a 'Last Backup.log' in the TMG Logs folder which might help. There will also be a 'List of external exhibits.log' which is designed to help diagnose backup and restore issues.

Edited by Jim Byram

Share this post


Link to post
Share on other sites
TMG 7.03 Works well under linux wine with one problem: backup.

 

Mon 10 Nov 2008: Wholly Genes are onto this problem and Jim Byram has found the solution and this will be made available imminently with release 7.04.

 

System: wine v1.1.7 (& earlier recent versions) & Crossover Office v7.1 with Ubuntu Hardy 8.04 Linux as of October 2008. I use both a PC and a Acer Travelmate 3004 laptop. I use the UK version of TMG.

 

Where are we with TMG7.04? Just wondering. I'd like to buy a copy for Christmas for someone.

 

Still thinking about this. Ian.

Edited by hamamelis@ntlworld.com

Share this post


Link to post
Share on other sites
TMG 7.03 Works well under linux wine with one problem: backup.

 

Mon 10 Nov 2008: Wholly Genes are onto this problem and Jim Byram has found the solution and this will be made available imminently with release 7.04.

 

System: wine v1.1.7 (& earlier recent versions) & Crossover Office v7.1 with Ubuntu Hardy 8.04 Linux as of October 2008. I use both a PC and a Acer Travelmate 3004 laptop. I use the UK version of TMG.

 

Where are we with TMG7.04? Just wondering. I'd like to buy a copy for Christmas for someone.

 

Still thinking about buying this before 31 December when the half price offer ends. Ian.

Share this post


Link to post
Share on other sites

I think that it's unlikely that v7.04 could be ready by Dec 31. The upgrade from v7.03 to v7.04 will cost nothing so why not buy v7.03 now to take advantage of the price.

Share this post


Link to post
Share on other sites
I think that it's unlikely that v7.04 could be ready by Dec 31. The upgrade from v7.03 to v7.04 will cost nothing so why not buy v7.03 now to take advantage of the price.

 

I value your honesty about when it will be ready. I will buy 7.03 and upgrade as you say.

 

I have been trying to enter the gift certificate code from the Message Centre in TMG to get 1/2 price UK edition for a friend before 31 Dec 08. I keep being told that it is only valid from an individual product page. I cannot see anywhere which allows me to enter this code for the UK edition. I see where it is entered for the US edition. I am happy with a download and do not need a CD.

Can you help me before 31 Dec.

Best wishes,

Ian.

Edited by hamamelis@ntlworld.com

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×