Jump to content

alphanitrate

Members
  • Posts

    82
  • Joined

  • Last visited

alphanitrate's Achievements

Enthusiast

Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. Phrase For best selection See a store near you Phrase Export For best selection See a store near you Phrase Export French Visitez nos magazins pour la gemme Displayed as "Drop Down List" Values from " Undercopy drop down Value List Using Values from "Phrase" When i use it, I select the Phrase- and the Phrase Export Displays in the drop down menu for selection. I have the "Phrase Export French in the Table, but I cannot make it display on the page properly for french. I wanted to link these together so that when the English was changed the french would be automatically changed as well. Any help you could provide wouuld be greatly appreciated. I am using FileMaker Pro 8.5
  2. I have a table that has the following fields: Phrase/ Phrase Export/ Phrase Export French The idea is that I can create a list of warnings, and the long form of the warning will be available for export. - This works fine. The Phrase Export French is the translated version of the warning. My problem is that I can not get the french field to display properly on the layout. It comes up blank. I have set it to the specific field it self,but I get an . I tried creating created another drop down that's supposed to display the Phrase Export French - but it also comes up as . Since these fields only exist in this one table, I'm not sure what to use to make them related. Can I even do this ?
  3. tomp I'm not sure if I understand correctly, but I have a drop down list that is connected to a layout. I have the fields sorted there within the layout. The drop down shows them the same way, and my 2nd field is not shown. Not sure if this helps or not.
  4. 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.
  5. 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.
  6. 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)
  7. 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. :)
  8. 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.
  9. 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?
  10. You guys are awesome! thanks for replying to me on this simple topic!
  11. ok found it thanks, is there a way just to do the one field? I have 16 other number fields that do not require the decimal.
  12. I import an excel file to gain pricing info etc. Currently I have Round(field):1 this take all the weights and rounds them up to a single decimal place. Works great. 10.37 = 10.4 The issue i have is if the weight comes in as 10 only i need to put in a zero at the end. Any thoughts?
  13. just in case you were curious what it ended up looking like: missing Trim ( Substitute ( Proper ( Cluster Title ) & " " ; [ "Led " ; "LED " ] ; [ "Orb " ; "ORB " ] ; [ "The " ; "the " ] ; [ "Of " ; "of " ] ; [ "And " ; "and " ] ; [ "For " ; "for " ] ; [ "Pc " ; "pc " ] ; [ "Oz. " ; "oz. " ] ; [ "With " ; "with" ] ; [ "Hdmi " ; "HDMI" ] ; [ "Vhs-C " ; "VHS-C " ] ; [ "Vhs " ; "VHS " ] ; [ "Atv " ; "ATV " ] ; [ "Aa " ; "AA " ] ; [ "Aaa " ; "AAA " ] ; [ "Wd-40 " ; "WD-40 " ] ; [ "Psi " ; "PSI " ] ; [ "psi " ; "PSI " ] ; [ "In " ; "in " ] ; [ "X " ; "x " ] ; [ "To " ; "to " ] ; [ "Mm " ; "mm " ] ; [ "Ml " ; "ml " ] ; [ "Lb " ; "lb " ] ; [ "Pk " ; "pk " ] ; [ "Ft " ; "ft " ] ; [ "Hp " ; "HP " ] ; [ "hp " ; "HP " ] ; [ "Jic " ; "JIC " ] ; [ "Jicm " ; "JICM " ] ; [ "Jicf " ; "JICF " ] ; [ "Sae " ; "SAE " ] ; [ "Bm " ; "BM " ] ; [ "Cp " ; "CP " ] ; [ "Bf " ; "BF " ] ; [ "i " ; "I " ] ; [ "ii " ; "II " ] ; [ "iii " ; "III " ] ; [ "iv " ; "IV " ] ; [ "B&s " ; "B&S " ] ; [ "Tv " ; "TV " ] ; [ "Npt " ; "NPT " ] ; [ "Nptf " ; "NPTF " ] ; [ "Nptm " ; "NPTM " ] ; [ "Fnpt " ; "FNPT " ] ; [ "a " ; "A " ] ; [ "w " ; "W " ] ; [ "v " ; "V " ] ; [ "Vac " ; "VAC " ] ; [ "Vdc " ; "VDC " ] ; [ "Atv " ; "ATV " ] ; [ "Utv " ; "UTV " ] ; [ "Rv " ; "RV " ] ; [ "Hss " ; "HSS " ] ; [ "Unc " ; "UNC " ] ; [ "Nf " ; "NF " ] ; [ "Nc " ; "NC " ] ; [ "Asa " ; "ASA " ] ; [ "Btu " ; "BTU " ] ; [ "Gpm " ; "GPM " ] ; [ "Gph " ; "GPH " ] ; [ "Cfm " ; "CFM " ] ; [ "Dot " ; "DOT " ] ; [ "Dot-c " ; "DOT-C " ] ; [ "Cv " ; "CV " ] ; [ "Wd-40 " ; "WD-40 " ] ; [ "Hvlp " ; "HVLP " ] ; [ "Pvc " ; "PVC " ] ; [ "Din " ; "DIN " ] ; [ "Gm " ; "GM " ] ; [ "Mig " ; "MIG " ] ; [ "Tig " ; "TIG " ] ; [ "Rca " ; "RCA " ] ; [ "Co2 " ; "CO2 " ] ; [ "Ohv " ; "OHV " ] ; [ "Tgh " ; "TGH " ] ; [ "Obdii " ; "OBDII " ] ; [ "Atm " ; "ATM " ] ; [ "Atc " ; "ATC " ] ; [ "Agc " ; "AGC " ] ; [ "Vsr " ; "VSR " ] ; [ "Abs " ; "ABS " ] ; [ "Thx " ; "THX " ] ; [ "Xl " ; "XL " ] ; [ "xl " ; "XL " ] ; [ "Xxl " ; "XXL " ] ; [ "xxl " ; "XXL " ] ; [ "Xxxl " ; "XXXL " ] ; [ "xxxl " ; "XXXL " ] ) ) Works like a dream. Only had an issue with the single letter appearing at the end of words. Thanks again!
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.