kdog3445
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Fox Pro?
ASKER
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
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
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
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
ASKER
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
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
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! ;)
Lesouef, shame on you... tsk tsk! ;)
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?
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?
ASKER
Lesouef, I dod upload the file.
Did you not get it?
i'll try again
Did you not get it?
i'll try again
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.
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.
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.
master bill,
That's the way I got it, don't worry. BTW, It would be better if EE would offer this possibility.
ASKER
i'll try email
under 2mb
under 2mb
" 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...
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...
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.
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.
ASKER
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
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
ASKER
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.
Erreur ! Il y a un/des espace(s) dans un nom de fichier.
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!
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!
ASKER
I got a diferent message. i think it may have worked :)
Sweet
Sweet
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
So i'll have a look at yr stuff tonight .
Master Bill,
Here it is:
http://extranet.valblor.com/~adispo\GreatEscapes.zip
ASKER
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
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
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.
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.
ASKER
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
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
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...
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...
ASKER
Thats is AWESOME!!!!
Thanks for your help
I get page can not be displayed when clicking on your link though
Thanks for your help
I get page can not be displayed when clicking on your link though
how is that going then?
ASKER
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.
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.
ASKER
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
Let me get it together and then I will close out this with as many points I am allowed
thanks again
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.
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.
ASKER
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
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
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.
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.
ASKER
I am good
Thank you lesouef
Thank you lesouef
till next problem!