Jump to content

muzz

Members
  • Content Count

    62
  • Joined

  • Last visited

Community Reputation

1 Neutral

About muzz

  • Rank
    keen observer

Profile Information

  • Gender
    Male
  • Location
    Mandurah W.Aust

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    15 Advanced

Platform Environment

  • OS Platform
    Mac
  • OS Version
    10.12
  1. Thanks Fitch, I will give it a go.
  2. I am involved in the production of figures and tables for an eBook that is to be translated into a number of languages. I'd like to create a database of the images (about 20) with fields over the various text blocks in each image into which the translator can type their language version (around 15 per image). Each image is different, as is each text block. My initial thought is to create one record for each language with 20 layouts (one for each image) with the appropriate unique fields overlaying the image (stripped of original text) as they would appear in the English version. My next thought was to have one record per language but 20 tabs (one for each image). I feel like there should be a more efficient way to create this database, perhaps with one record for each language translation of each image but each of these will need to be dependant on one arrangement of unique fields for each different image which sounds like a single layout again and I'm not sure how the record could be related to an individual layout only. Perhaps even separate tables for each image or each language? Is there an obvious choice that I am missing? I am not a developer, just a hobbyist and struggle with basic conceptualising such as this. Any help will be greatly appreciated as I am keen to get started as there are some time pressures.
  3. Yes comment I think you have it right. I'm guessing that alternate layouts or tabs could be used depending on which field is blank as only one record will be presented at a time. I'm not entirely sure how to proceed but will start with trying to populate the scripts randomly for now. Thanks.
  4. I have a simple multiplication table solution ("times tables") that I have made for my daughter and I'd like to improve it and would appreciate some guidance with the strategy to implement it. Currently the records are presented in the format a*b=c, with a*b presented and the input is made into the answer field "c". Currently the times tables to be tested are selected (e.g. for 7 times tables b=7), then the number of questions desired for the test are selected. The records for the table are then created by scripting in a loop from 1*b to 12*b then sorted randomly and the appropriate number of records omitted to show the desired number of records for the test. I would like to make two improvements - firstly to present the equation as 2 known values and one unknown, with either a or b or c requiring the input. Secondly I would like the option to extend the learning by introducing multiplication by 10, 100 or 1000 to the values in the equation. My initial thoughts for the first part were to create a table with all of the possible combinations of 2 knowns and 1 unknown, and find related records (e.g. for 7 times table all the records where a=7 or b=7). This strategy would require a lot of records and the same strategy would be impractical for the second part of the improvement. I'm thinking that a combination of calculation and scripting would be necessary but was hoping for some early suggestions before continuing as I'm not even sure that my current strategy for creating the records is the best way so building on that may be undesirable. Any help will be greatly appreciated.
  5. Thanks rwoods. I probably didn't give as much information as I should have. The appointment calendar is not integrated into Filemaker, we are using Apple Calendars on a Mac. The current workflow would be to manually create one reminder record at a time, enter the appointment time and enter the client code which would then pull the mobile number in and create the message to be sent. Not all clients have a mobile or wish to receive a reminder, or an appointment slot may not be filled so not all time slots will be used. Sometimes the appointments may start later in the day or vary for some other reason. I just thought it would be easier to select an appointment closer to the last appointment made in the drop down value list rather than defaulting to the start time or any other time for that matter if entering the field if it is necessary to change the time. Thanks for your solution though - I may have use for it in another table and appreciate your effort.
  6. I am just working on an appointment reminder system and I would like to create a set of records each day for the next day's appointments. In general, appointments are half hourly and mostly only one for each timeslot. I'd like each new record to auto-enter the appointment time 1 slot (30mins) later than the time slot in the previous record. At the moment the timeslots are in a value list from 8.00AM to 5.00PM in 30min intervals. Once I've created the record for the 10.30AM slot I'd like the next record to auto-enter as 11.00AM etc. My current method is to do it by calculation from the time data in the timeslot field from the previous record by using the value of the n-1th record (where n is the total number of records) and adding 30 mins but this feels more complicated than perhaps it might need to be. If ( Get ( RecordNumber ) =1; "8:00 AM" ;GetAsTime (GetNthRecord ( Time ; Get ( RecordNumber ) -1 )) + GetAsTime ("00:30:00")) Is it simpler (or possible) just to select from the values in a value list? Thanks.
  7. I tried pausing up to 5 seconds but still no joy. When I tested the file opening with export it was almost immediate and I presume that means that it has reached it's destination ($path) before opening. I made another test file (PathTest) and tried that at home with the same script steps and it worked perfectly on my local machine transferring an internally stored file in Container 1 into an externally stored Container 2. Set Variable [ $path; Value:"file:" & Get(TemporaryPath) & PathTest::Container 1 ] Export Field Contents [ PathTest::Container 1; “$path” ] Go to Field [ PathTest::Container 2 [ Select/perform ] Insert File [ “$path” ] Commit Records/Requests [ No dialog ] The solution I am trying is hosted with FMS15 and I am using Apple Remote Desktop to screen share on the Mac with the server and running everything from there with FMP14 on the same machine but still opening it as a hosted file. The script is the same except for the names of the containers. I can leave it as is without using this script but I'm just confused as to why it doesn't work.
  8. Thank you both, I now have it working. I di have one problem though which is when I script to export the container ("file.pdf") to a temp path defined by a variable ("$path"), then insert "$path" into a new container setup with external storage, I get the message that "file.pdf cannot be found. If I select automatically open when defining the export, it opens as expected so I believe the problem must be with the insert step and I haven't solved it. In the meantime I have been able to export a copy to a folder and insert from there. I can delete the few thousand files once done but I'd like to know where the insert step is going wrong. I don't have a strong understanding of these things. I wondered if it could be permissions that are the problem but repairing these with a utility hasn't changed the result. I seem to be following the basics of Wim's script although they are all PDFs so I didn't bother trying to differentiate file types and just used the Insert File script step alone. Thanks again for your help with this. Regards, Murray
  9. Thanks for that comment. I've set up a test file but I think I have my syntax wrong as I'm still getting "The file cannot be found". I created the test file and a folder of scans (MyTestFolder) at the root level of the original Macintosh HD. I then uploaded the test file to the server on the other Mac and copied the folder of scans to the root level of the server Mac (also Macintosh HD), so in the end the file paths were the same, however that didn't work. I wasn't sure if the filewin path would work as they were both Macs but couldn't get it to work either - I tried server name but wasn't sure what shareName was on the Mac. Could you help me with the syntax of the substitution if the server's hard disk is "Macintosh HD", the folder at the root level is "MyTestFolder" the server is called "MyServer". I hope that is enough information. Thanks again. Thanks Wim, I will work through that solution if I can't get the above working. Cheers.
  10. I'm trying to sort out container storage in a solution that originally started on a single machine running FMPro and serving to one other. At that time, containers were used to store PDFs of accounts which were stored by reference and were located elsewhere on the same host machine. Since then, the solution has been moved to FMServer on a dedicated machine on the same network (all Mac). Unfortunately the referenced files were not moved and the files could no longer be accessed remotely from the served solution. At that time, I attempted to import the referenced file to internal storage and then export to another container set up as remote storage but was unsuccessful as the file references could not find the files. To move forward I changed the existing containers to external storage so that subsequent PDFs could be accessed. I would like to relink the previous PDFs and save them into externally stored containers to restore the functionality of the database. The original scans are still in the same place on the original machine. My thoughts include: possibly copying the database file back to the original location (or use a backup pre-dating the change from reference to external storage), change to store internally, copy back to the server and then change to external storage; copy the original scans to a folder on the server that restores the relative reference location to the original database file; open the original folder of scans on the server machine by file sharing the old volume and change the file path so the containers can see it again; some combination of the above; something entirely different. Any thoughts would be greatly appreciated. I'm sure there may be some of my ideas that will ring alarm bells with experienced users so ruling them out quickly would be great. Another point worth mentioning is that some of the folders have been named with a "/" character (e.g. Invoices 2006/2007) and I'm not sure if that impacts on FileMaker's identification of the file path i.e. if it sees 2007 as a subfolder - I thought this may have been the problem with my early failure to import the referenced PDFs into internally stored files. Thanks in anticipation of any help that can be given.
  11. Filemaker have downloaded me to FMAdv14 without a problem and the solution is working fine. Thanks for everyone's input.
  12. Thanks Josh - I already had their number up on my screen. That would be a good solution for the time being.
  13. Thanks Josh. I will just work around by generating the vCards on my laptop and transferring them to my main computer from there. I had already upgraded to FM15 but had to downgrade again due to FM15 generating corrupt PDFs, a problem not yet sorted but I'm assuming that an update will fix that and I can start using 15 on my main computer again. Thanks for your help and I will bear it in mind.
  14. Perhaps I should have said that the example allowed me to adapt it to my use without having to learn other languages or research techniques beyond standard Filemaker functions which I have been able to fumble through with occasional help, usually non-judgemental and always gratefully received. The presence or absence of the above mentioned "tools" in version 13 is debatable as the example file intended for use in FM14 works perfectly in FM13, suggesting that at least in this particular case version 13 does support encoding text in Base64 format. It does not however work in my implementation which is what I would like to resolve if I can.
  15. Hi Kris, I had read Base64 Encode/Decode originated in FM13 (I created the calcs in FM13 and the functions were available there) however I think the documentation refers to "specified container fields" in FM13 and "specified fields" in FM14, a nuance I had missed.
×

Important Information

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