|
Your continued generosity and support of FMForums is greatly appreciated. |
alphanitrate
enthusiast
Posts: 85
Loc: Winnipeg, MB
Post Rank (AVG):
FMP: 8.5
OS: Mac OS X Panther
Skill: Beginner
 Tweet This Post!
|
Hello All,
I have a X serve 2Ghz Power PC G5 with 5 GB of RAM that currently only runs FMS10 and does some limited file sharing.
Can I run Server and FMP Pro on this machine at the same time?
**I remember reading that it was not recommended to run server and the application on the same machine**
Is it a resource issue? because i have more than enough.
Here's my problem:
I have one 17.1 MB excel file 40 columns by 30,000 records that we would like to have update more often in the day.
It currently takes over 15 minutes to upload this file to the filemaker database via the FMP Pro8.5 on a 1.25 Ghz Power PC G4 with 2 Ghz RAM from a network folder.
What's the skinny?
|
|
|
IdealData
IdealData
Posts: 2102
Loc: UK
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Tiger
Skill: Advance
Tweet This Post!
|
In response to alphanitrate
Yes you can run FM8.5 on the Xserve - but you must use File > Open > Remote to access the database. I don't think you will see much improvement.
FMS10 allows you to run FM scripts directly and the Import/Export records are supported too (unlike FMS9). You will need FMP10 to generate the script first. There are some limitations to where the files must be placed, but that would seem the most likely method of performance improvement.
Ideal Data - Coherent systems for a chaotic world
I'm available for hire, e-mail me |
|
alphanitrate
enthusiast
Posts: 85
Loc: Winnipeg, MB
Post Rank (AVG):
FMP: 8.5
OS: Mac OS X Panther
Skill: Beginner
Tweet This Post!
|
In response to IdealData
Ideal Data, thanks for responding.
So if I understand you correctly:
1. FMP and FMS can co exist on the same machine, at the same time, while doing some file sharing.
2. FMS10 can do the importing of data directly into itself with out having to pass it through FMP first?
(The file is generated from an AS400 database, then converted to an excel file [need excel file in order to keep formatting of file, no Chinese characters and such] which is then save onto a Xserve, FMP is then scheduled to go and import the file. Total time about 35 minutes)
If FMS can handle that part of the process, then it would certainly make things faster and improve the timing.
I'll have to start looking into how the script process works with the server.
|
alphanitrate
enthusiast
Posts: 85
Loc: Winnipeg, MB
Post Rank (AVG):
FMP: 8.5
OS: Mac OS X Panther
Skill: Beginner
Tweet This Post!
|
In response to alphanitrate
Just an update for anyone reading this.
Filemaker Pro 8.5 will not run on a Leopard X serve (architecture issues)
I looked in to the Server Scripting - the importing and the exporting of records is not compatible.
I will stick with the machine for now that runs the scripts on it's own now. 
Thanks again.
|
 Old Advance Man
Humble Servant
Posts: 4041
Loc: USA
Post Rank (AVG):
FMP: 11 Advanced
OS: Cross Platform
Member: Platinum
Skill: Certified Trainer
Certified:
    
 FMPug
Tweet This Post!
|
In response to alphanitrate
I looked in to the Server Scripting - the importing and the exporting of records is not compatible.
Compatible with what? Server 10 supports import and export server side. What are you trying to do here?
Steven
Steven H. Blackwell
Platinum Member, FileMaker Business Alliance
Partner Member, FileMaker Solutions Alliance (1997-2007)
FileMaker 11 Certified Developer
FileMaker 10 Certified Developer
FileMaker 9 Certified Developer
FileMaker 8 Certified Developer
FileMaker 7 Certified Developer
FileMaker Authorized Trainer 9|10|11
_ _ ____________________________ _ _
http://www.fmp-power.com
http://www.filemakersecurity.com |
|
alphanitrate
enthusiast
Posts: 85
Loc: Winnipeg, MB
Post Rank (AVG):
FMP: 8.5
OS: Mac OS X Panther
Skill: Beginner
Tweet This Post!
|
In response to Old Advance Man
Old Advance Man
thank you for taking part in this discussion.
Here's the scenario.
I am running FMS server10 on a leopard Xserve.
I have FMP 8.5 on a G4 mirror door with my data base running on it.
I have a script that pulls 30,000 records that is provided to me from an AS400 system.
"They" would like the records to be updated more often (shooting for hourly) unfortunately the process takes about 30 or so minutes to run.
At Ideal Data's suggestion i looked into setting up server side scripting as a possible way to improve the uploading process.
I have set up the scripts - but when I try to perform the scripts that will import these records, and export a file - they do not work for me.
Looking into the forums, they made mention of ensuring that they were "server" compatible and I could check by also seeing if they were "web compatible".
Neither of these scripts are web "compatible" because they use Import Records and Export Records.
I"M NOT SAYING THAT THE FILEMAKER SCRIPTING DOES NOT WORK,JUST NOT FOR ME so far.
( Let me be clear on that because I get similar comments at work, and Filemaker runs beautifully)
|
IdealData
IdealData
Posts: 2102
Loc: UK
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Tiger
Skill: Advance
Tweet This Post!
|
In response to alphanitrate
What you are missing is a FileMaker Pro 10 LICENSE. When you have FM10 then the SERVER COMPATIBLE script steps will be available to you - and these include the Import/Export steps I outlined before.
You cannot program FM10+ compatible stuff using FM8.5 - it didn't exist then.
My original post contains all the information you need - but you didn't use FMP10 as I said you must.
The new FM11 is now your only option - and that has raised the bar for OS specifications - minimum is OS X 10.5.7
Ideal Data - Coherent systems for a chaotic world
I'm available for hire, e-mail me |
|
alphanitrate
enthusiast
Posts: 85
Loc: Winnipeg, MB
Post Rank (AVG):
FMP: 8.5
OS: Mac OS X Panther
Skill: Beginner
Tweet This Post!
|
In response to IdealData
Ideal Data,
thanks for correcting me on this.
I was so excited that it could be done I neglected to COMPLETELY READ your post.
I humbly  apologize and thank you for your assistance.
|
IdealData
IdealData
Posts: 2102
Loc: UK
Post Rank (AVG):
FMP: 9 Advanced
OS: Mac OS X Tiger
Skill: Advance
Tweet This Post!
|
In response to alphanitrate
That's okay - but I'd like to see some feedback on any speed improvements you get. Promise?
Ideal Data - Coherent systems for a chaotic world
I'm available for hire, e-mail me |
|
Old Advance Man
Humble Servant
Posts: 4041
Loc: USA
Post Rank (AVG):
FMP: 11 Advanced
OS: Cross Platform
Member: Platinum
Skill: Certified Trainer
Certified:
FMPug
Tweet This Post!
|
In response to alphanitrate
Plus, be sure to read this article here in FM Forums. It will describe server side imports and exports.
Steven
Steven H. Blackwell
Platinum Member, FileMaker Business Alliance
Partner Member, FileMaker Solutions Alliance (1997-2007)
FileMaker 11 Certified Developer
FileMaker 10 Certified Developer
FileMaker 9 Certified Developer
FileMaker 8 Certified Developer
FileMaker 7 Certified Developer
FileMaker Authorized Trainer 9|10|11
_ _ ____________________________ _ _
http://www.fmp-power.com
http://www.filemakersecurity.com |
|
alphanitrate
enthusiast
Posts: 85
Loc: Winnipeg, MB
Post Rank (AVG):
FMP: 8.5
OS: Mac OS X Panther
Skill: Beginner
Tweet This Post!
|
In response to IdealData
Ideal data
I will certainly give you feed back on the speed improvements.
|
|
Your continued generosity and support of FMForums is greatly appreciated. |
alphanitrate
enthusiast
Posts: 85
Loc: Winnipeg, MB
Post Rank (AVG):
FMP: 8.5
OS: Mac OS X Panther
Skill: Beginner
Tweet This Post!
|
In response to Old Advance Man
Old Advance man
Thanks for the link, i'm reading it right now and I am sure that I will put it to good use.
|
|
|
