Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

File conversion from 4.1 to 7.0

I have installed Fox Pro 7.0 and converted the data from 4.1. It all is fine except 2 things.

I open what used to be my "home page" called contacts. From that page I used to be able to click the links that would bring me to all my forms, clients, vendors.....so on.

now when I click that link 2 things happen.

1. It opens that page first and then procedes to open all other forms and tables. In the past all this was done in the back ground. now my "home page" is no longer my home page. but it is my last page now. I can click on a main page link and it brings me back there so not the end of the world. but any help to get it back would be cool.

2. This is the bigest problem. While the database is opening all the forms ( 7 of them) It allways stops at a form called "vendor forms" and says file not found. I then get a windows drop down to search for the file and it is always listed in my folder with all other forms. I click it and it open no problem. but on start up it never finds it.
I can open it independently no problem. But it always stops on that one form.  

Thanks for the help
0
kdog3445
Asked:
kdog3445
  • 14
  • 14
  • 4
1 Solution
 
lesouefCommented:
Normal effect infortunately.
pb1: you have to correct (or create) an opening script and refresh the window in which you want to end up at startup. This is one of the differences, when you refresh (without foreground) or stop a script, FM7 does not necessarily puts the current window above others.
pb2: you are probably calling this file from within a script where the name is specified, but the extension has changed from fp3 to fp7, so you should modify the script for the file name; on top, locating the file once during script execution won't autocorrect the file path in the script as it used to do in the past with fm4/5/6.

0
 
billmercerCommented:
Fox  Pro?
0
 
kdog3445Author Commented:
Thanks Lesouef,
Good to hear this is common. I guess :0

If it is not to much to ask can you give me some pointers on where to start to create or correct the opening script. I had this database made and no longer have contact with the developer

Also how about a pointer on where I may find the script that is calling for the fp3 and not the fp7

Thanks again
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
lesouefCommented:
1
Is there a startup script? check in File/file options/ startup script: anything mentioned?
If yes, note the script name and modify it at the end for:
- display [home page] ([home page]= the name of the layout used for home page)
If no, create a script to do that, then set it as the startup script.

2
How do you open all these form? you click a button or is it done at startup automatically (in fact due to links in between files)?
if they are opened at startup, check file links (file/define data base/links), one should should a missing file, corretc it.
If they are opened with a button, check which script is called by the button (design mode/right click on button/button/script name), then check this script for all files being opened and all external scripts called, one should have a name which does not exist anymore. should be easy if the script is not too long.
If nothing is confidential, you can post it to me as a zipped file to correct it.
my mail: sl at valblor dot com
or you can upload it at www.valblor.com/adispo
0
 
kdog3445Author Commented:
I think I am going to take you up on your offer.
Here is the run down on how it used to work

I click on the file called "contracts"
This opens all the related databases and you will get the missing file error.
After browsing to the file you will then see a button called "main hub"
that was the former 'Home Page"

That is the 2 issues I posted on haveing a problem with. Clicking around it the database I have found a couple other buttons that do not linkup correctly so If you could give ma an ide on how you were able to fix thses 2 problems I may be able to figure the other ones out.

Feal free to click around inside and see if you find any errors

Thanks again for you help

uploading files now
0
 
billmercerCommented:
kdog3445, you really should post the URL where the file has been uploaded, in case someone else wants to try and help you. Private correspondence with a single expert is frowned upon, because it gives that person an unfair advantage over others. In this particular forum it may not matter so much, but there are other areas where the experts are much more competitive, and you could get in trouble.

Lesouef, shame on you... tsk tsk! ;)
0
 
lesouefCommented:
Bill, I have seen you doing the same! Am I wrong?
Anyway, he did not send anything...
And, if users mention the filename they upload, it is available there:
http://extranet.valblor.com/~adispo/[filename]
So, not too private!
Also, what can you do if the guy has no public place apart from using yr own one?
0
 
kdog3445Author Commented:
Lesouef,  I dod upload the file.
Did you not get it?

i'll try again
0
 
billmercerCommented:
Lesouef, I was just teasing you... That's why the ;)


What I was really doing was telling the poster that he should post the URL here so others have access to it as well. That's what I always ask them to do when I mention uploading to my site.
 
0
 
lesouefCommented:
kdog: got nothing: did you wait for file upload completion before closing yr browser? You must wait for the msg telling you it's done otherwise, you abort the upload process before the end.

master bill,
That's the way I got it, don't worry. BTW, It would be better if EE would offer this possibility.
0
 
kdog3445Author Commented:
i'll try email
under 2mb
0
 
billmercerCommented:
" It would be better if EE would offer this possibility."
For certain!
The two things I can't fathom are why we don't have a place to store sample files and why we can't format text as source code...
0
 
lesouefCommented:
Bill,
They probably want to avoid their server to be used as a free file exchange place. After all, you would need to create an EE account to use it. So, let's say just for masters or + then!
Kdog,
Received no mail. What's yr email address? I have an antispam filter, so better use my extranet upload server.
0
 
kdog3445Author Commented:
My email address is kdog3445@yahoo.com.
I have tryed the extranet a few times. I do not get it in english and I dont understand many of the  buttons.

I attach it and then I click what I think is upload and then after a few min I get a message. Not sure what it say's though

do you have an FTP site? Or send me an email and I can reply to it. That may work
0
 
kdog3445Author Commented:
I found the english button and tryed to upload it again. This is the error message I get

Erreur ! Il y a un/des espace(s) dans un nom de fichier.
 
0
 
lesouefCommented:
The file name should have no space in it.
My fellow admin wrote this (I am not PHPaware myself) does not know how to overcome this so far. And since I was born under dos and unix, I don't really care!
0
 
kdog3445Author Commented:
I got a diferent message. i think it may have worked  :)

Sweet
0
 
lesouefCommented:
got yr zip now, but not the related mail normally sent by server, my antispam refuses *@yahoo.com so I'll put you in my whitelist
So i'll have a look at yr stuff tonight .

Master Bill,
Here it is:
http://extranet.valblor.com/~adispo\GreatEscapes.zip
0
 
kdog3445Author Commented:
great thank you --

Just as a reminder here are the problems again

I click on the file called "contracts"
This opens all the related databases and you will get the missing file error.
After browsing to the file you will then see a button called "main hub"
that was the former 'Home Page"

That is the 2 issues I posted on haveing a problem with. Clicking around it the database I have found a couple other buttons that do not linkup correctly so If you could give ma an ide on how you were able to fix thses 2 problems I may be able to figure the other ones out.

Feal free to click around inside and see if you find any errors

Thanks again for you help


0
 
lesouefCommented:
After a quick exam, the pb is within the value list of contracts, some of them refers to a missing file or missing link. There is even one which refers to a missing field.
My idea about this: it seems to be originally a mac data base, v4.1. You are now using it on a pc under v7. But:
In v4, if you were not using pc/mac compatible names, ie no extensions, the database would not work on a pc..
And if you would rename files, file links and everything around it, value lits, external subscripts had to be updated.
So, you can correct them one by one manually, but some problems like the missing field in "Vendor # From Ven Frms" list probably exist before conversion.
I suggest to check the state of the database in v4 first, espacially, the value list and links of the contrats file.
Then you convert it to v7 on a mac rather than on a pc, then rename files at last; files renaming will be easier in v7.
I could also suggest to convert to v6 as an intermediate step as skipping 1 version is possible according to FM, but probably not bulletproof, especially if you do it crossplatform at the same time.
If you want me to make a better report, I need the original files, with original names, completely untouched as some problems seem to exist before conversion, it needs to be sorted out before conversion. Then I want to make sure it runs on a PC and a mac.
Then I'll make a test with FM6 and FM7 finally. So up to you to check this yeself or send it to me. I won't be able to work on it before thursday now.
0
 
kdog3445Author Commented:
Wow your good!!!!!
 I did not even mention the Mac. I put the 4.1 files up on the site with a Hotmail address.
Dont kill yourself over this. If it is going to be to much I understand. And I do greatly apreciate the help.

Let me know what you find

Thanks again
0
 
lesouefCommented:
So, the basic pb exist in the original files, but FM4 does not compain at startup; if there is a broken link or missing field, FM4 and 5/6 complain whenever it is needed while FM7 complains at startup.
I have removed the list which was based on a field which has been deleted from the original file "contracts". value list= "Vendor # From Ven Frms".
To display the right layout at startup, I have modified the opening script to comply FM7 behaviour.
I have also modified this script to call a subscript called "open" in other files instead of opening them strait away to be able to mask non necessary windows at startup
(keeps the screen clean, that's all)
I have also noticed a lot of fields with illegal names containing "\". Thats was reported by FM7 during v4 > v7 conversion. I have renamed these fields with "_".
There were also a few links which were broken (pointing to mac folders with funny names), I have modified them to point at the correct file or deleted it when it was not used. There are still duplicated links which are probably useless, but they may be used in scripts, so I left them.
You can have that stuff back there:
http://extranet.valblor.com/~adispo\ge7.zip
I keep the file for a few days, if you find something else to correct...
0
 
kdog3445Author Commented:
Thats is AWESOME!!!!

Thanks for your help

I get page can not be displayed when clicking on your link though
0
 
lesouefCommented:
0
 
lesouefCommented:
how is that going then?
0
 
kdog3445Author Commented:
Good Stuff.

I have found one small bug. When creating a new contract I enter the dates it give me a message about what mode it is in. Then I click Ok and it clears the date

I can give a better example if you are un able to track this down

What an AWESOME Form this is.
0
 
kdog3445Author Commented:
Well Lesouef if you still are offering to help I have a few little things I still could use a hand with.
Let me get it together and then I will close out this with as many points I am allowed

thanks again
0
 
lesouefCommented:
date stuff: it is defined "with control" and requires a 4 digit year.
But the writer has set a msg to make sure you were changing it only in a given layout and not in find mode, God (and probably him) knows why!
Also, the file is set to use system formats (format menu, last option down), and this may not comply with date formats required yb field definitions. Use file formats instead if it is any easier (it works on my PC as my date format is 4 digits anyway).
And I agree with you, this app is rather weird, ... at least!.
If you'd like to ask some more, no pb, but I'll look at it only later on tonight, I'll be away from kbd today.
0
 
kdog3445Author Commented:
Cool... I can live with the 4 digit year

So I think I have just one more little thing

When I click on 'List view contracts"
Then click on the contract#
I get this action can not be performed because a missing table

I think that is it

0
 
lesouefCommented:
Date: if you don't like 4 digit year notation, you can correct this and remove control from all date fields ... up to you.
2nd one: there again, this problem is the original file but FM does not issue any error msg if you want to jump to a non existing link::field, it simply skips the step, while FM6 and 7 are warning you. To correct, edit the script called "go to related record from list view", and delete the 2nd line.
I think there won't be any side effect, and that this has been left over by the original writer as no error msg was issued, but the expected behaviour is probably the right one.
0
 
kdog3445Author Commented:
I am good

Thank you lesouef

0
 
lesouefCommented:
till next problem!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 14
  • 14
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now