
chlowden
Members-
Posts
198 -
Joined
-
Last visited
Everything posted by chlowden
-
The conflict with Mac & PC special characters in file names e.g. *µç¤ etc I have now read that external referenced files was deprecated sometime ago and external storage is now the revised method. I must confess that I have not used FM for nearly 10 years and I struggled with it in version 7 to 12. I used FM as a web server and at the time, the images in containers had to be internal. My goal is to extract the files and have the database intact. Once that done, either continue with FM or migrate to a php solution. Many thanks for all your help
-
Whilst trying the troubleshoot the file name issue, I stumbled on the Container Storage option below. By clicking on the Store container data externally check box, it extracted virtually all the pictures to a folder and updated the ContainerFieldName field. A csv export shows that the database looking to an external source.
-
Thank you so much for sharing the above. Maybe you can where I am stumbling as I get generic error on the script below Go to Layout ["Images" (Image); Animation:None] Show All Records Go to Record/Request/Page [First] Loop Set Variable [$$filePath ; Value: " Set Variable [$$filePath ; Value: Get( C:/Users/christ/Desktop/FM_EXPORT/HTML_files/images/ ) & Images::ContainerFieldName & \".jpg\"]" Export Field Contents [Images::Image ; “$$filePath”] Insert File [ Reference ; Target: MyPics::Picture ; “$filePath”; Create directory:On ] Go to Record/Request/Page [Next; Exit after last: Off] End Loop Layout name : Images Container field name : Image Original file name : ContainerFieldName Below is my attempt to migrate the jpgs to the folder C:/Users/christ/Desktop/FM_EXPORT/HTML_files/images/ My first question is that the script uses / like on mac when PC usually uses \ (which is what I am using.) But when I use \ in the script I get errors. I took example for the Insert File element from the link below as I did not understand why I need the Option box. https://help.claris.com/en/pro-help/content/insert-file.html?Highlight=insert file Below is the error. The user account admin and there is plenty of space on the hard drive. Any thoughts are most welcome. Thank you
-
Thank you for clarifying this. To be honest, I'm no script writing, and I have searched "container calculate path" on the site but nothing very pertinent comes up. Could you advise me where I might find an example script? Also, I would seem logical that the path change be part of the migrate script .. Or that not such a good idea? Many thanks
-
Hello I have read the thread below about a script that will export container images to an external folder I have 11000 jpgs embedded in an FM file and I wish to migrate these files from an embedded state to an external folder. Go to Layout [ MyPics ] Show All Records Go to Record/Request/Page [First] Loop Set Variable [$filePath; Value: Get ( DesktopPath ) & MyPics::Description & ".jpg"] Export Field Contents [MyPics::Picture; “$filePath”] Go to Record/Request/Page [Next; Exit after last] End Loop Firstly, I am unsure if the above script rewrites the container path to the new folder or just exports the data but leaves the container intact. Any thoughts would be most helpful. Thank you
-
OK. Sounds like the RPi is not upto speed as a FMSA server. Interesting to npte all the same. Thanks
-
Thanks for the reply. As apple wants to move away from intel, maybe a hybrid OS will emerge that can do simple tasks. Filemaker have flirted with different lite versions of the app, without great success. Who knows? But then again, RPi is not a very apple facing product.
-
Hello I have an old portable mac running FMSA 11 in a dusty cupboard and it works fine. I am reading great things about Raspberry Pis and so I am wondering if anyone has tried to run Filemaker on a RPi? As apple is already using ARM processors maybe it is possible? I hasten to add that I have absolutely no programming, dev or linux experience, so this is a really neophyte question. Thanks for any thoughts
-
How to have a running sum of previous fields?
chlowden replied to chlowden's topic in Calculation Engine (Define Fields)
Many thanks for all the suggestions. Admittedly I had forgotten to put a date field. That is done. In the end I found my solution courtesy of LaRetta as described below. Many thanks again for your time. ------ It would be easier if you used one field for debit/credit (debit plus amount; credit minus amount). Delete your last field sTotalGlobal and add field (type calculation) called cLineDiff (result is number) with MontantReceites - MontantDepense, selecting your regular fields and not the summary fields. Now create a summary field sRunning (which is Total of cLineDiff and at bottom, checkbox 'running.' If you used only one field, you wouldn't need that calculation at all because the summary would reference only one field (your amount). -
Hello I am a total newby on filemaker. i have a table that is designed to a debits and credits field in a list. I use the summary function to addition all of the credits and another to addition for the debits. I have a 3rd field summary field that gives me the total difference of both fields. Obviously, this running total result is repeated in each table entry. I am struggling to have a running total where each entry progressively adds or subtracts from the sum of all the previous entries. This would give me a result like a bank statement, telling me what the consequences of each entry are on the sum up until that point. I am not sure how clear this is, but in excel it is as simple subtracting or adding from the sum cell of a column. Many thanks for any ideas
-
IWP & Webviewer & QT files - Does it work for you?
chlowden replied to chlowden's topic in Other Internet Technologies
Delving further, I Have discovered that it is NOT the QT file that is causing the problem, but either the calc field that creates the html address or the webviewer script that I use. So for those of you that have a web server & FMSA, you can use the webviewer to view your QT files. So I am now fishing for more info on what the limitations of the webviewer are concerning calc fields & php scripts. -
IWP & Webviewer & QT files - Does it work for you?
chlowden replied to chlowden's topic in Other Internet Technologies
Thank you for that. To get round this issue of serving up container fields using only the docement folder, I use a web address that points to the webserver. The webviewer does not have the same constraints as containers. To the webviewer, this should just be another html address, be it a QT file or flash or whatever. I cannot find any docs on webviewer limitations with IWP but I have a feeling there are. -
Cumulative Calc Solution for Name & Date
chlowden replied to chlowden's topic in Calculation Engine (Define Fields)
Thank you both for your comments. Before I started this db, I watched a Lynda Filemaker tutorial & tried to be a good student. I did a ERD and most of the workflow, worked. But as I developed the db, the Lynda rules seemed to start flying out of the window. I have spent an incalculable amount of hours fiddling around trying to get the TO graph to work & there are still bits that I can't fix & I can't see why. Now I read the pdf and discover that what I had been lead to believe isn't quite that ... but it is (sort of). I must confess that it is a little discouraging, but my work so far has saved my wife hours of excel nonsense, so it must be worth it. I will have to reread the pdf to understand what this all really means to the work so far, but I have a very horrible suspicion that I have to start again. One thing I still don't understand is how to 'block' information. I created an entry form system that creates an entry that I call an archive. The flow of information starts only with the archive & not the entry form. If I understand write, you say that is not right and that there are duplicate fields. No information is held in the entry form apart from calcs. It is the archive that keeps all the info. If I don't have this separation, the information flows freely, making it possible to change info. I see FM like plumbing, the info flowing from one table to another, each table having a consequence on the flow. I was lead to believe that the golden rule was that the flow went only in one direction, from one to many, like roots of a tree. I have often found myself stuck in loops (this being one of them) and it seems that neither my concept of FM nor trees like them. Anyway, I will read and view all that you have supplied and see how I get on. Many thanks again. -
Cumulative Calc Solution for Name & Date
chlowden replied to chlowden's topic in Calculation Engine (Define Fields)
Many, many thanks for all your work. I have had a look at it but I am still perplex. I have attached my work so far. But it will need explaining as it is in french. This is a simple - work in progress - db to help my wife deal with her theatre company. The primary purpose is to create payslip for the actors & techs. For the moment, her only actor is called Lawrence Olivier ... hmmm. User: admin Password: admin The opening page is a resume of the project: MACBETH with the representations booked, the 'PERSONNEL' who will work on it & the FACTURE (INVOICES) that have been issued (this does n't work yet). In the layouts is CREE FICHE DE PAIE ARTISTE (Create Artiste Payslip). This is a layout that the user uses to fill in the payslip form & it calculates all the very high french taxes. There is a big button "CREE FICHE DE PAIE" that runs a script that will copy all the fields into a new layout called "ARCHIVE FICHE PAIE ARTISTE" (Archive Artiste Payslip). Now I am sure that you alarm bells have already sounded, but there is a simple reason why I have such a complex copy script. I found no other way to have a 'hardcopy' version within the db that I was sure could not be easily modified. Once the payslip is created, it becomes its own entity & has no subsequent connection with any previous action i.e. if the actor changes house address, I don't want all his old payslips changing address. So ... at the bottom of the newly created ARCHIVE FICHE PAIE ARTISTE is a box called CUMUL (CUMULATE) which I am trying to make work (among other things). The idea is that the field NET IMPOSABLE (TAXABLE INCOME) should be the sum of all that persons salaries in any calendar year. Following what I understood of your instructions, I created a new table called ARTISTE_CUMUL with a layout that sucks in info from the created payslip. From here, I have tried the sum functions & copied your model but with little success. What bothers me is that, logically, I don't see why it is so difficult (apart from the fact that I really don't know what I am doing) I think this is clear. Many thanks in advance for any light you can shed on all this. LAFRONDE_GESTIONCopy.fp7.zip -
Cumulative Calc Solution for Name & Date
chlowden replied to chlowden's topic in Calculation Engine (Define Fields)
Ok. I'm struggling. I have set up a new table that has a connection between the payslip & the new table. There is also a field for the year, the salary paid the ID of the person & a summary field. I am struggling with the case function to to resume it all. Can anyone explain in layman terms how to have numerous parameters in the case function? I find the FM help is written in a language that I have trouble understanding. Actually is there an FM book for idiots like me that explains all this? -
Is there nobody who can help me with this ne?
-
Cumulative Calc Solution for Name & Date
chlowden replied to chlowden's topic in Calculation Engine (Define Fields)
The clue is very interesting. I say excel because often pay slips are created with it. The pay slip is just one of many things i do with FM Many thanks -
Cumulative Calc Solution for Name & Date
chlowden replied to chlowden's topic in Calculation Engine (Define Fields)
Soren, Many thanks for the reply. Sorry that I have not quite understood all the subtleties of the your 'carpal' thinking, but if I get one thing, it is why I don't use a sub summary report. Admittedly, we are in the Excel realm, but not exactly as this is the sum part of a db. A sub summary report is a powerful reporting over view. What I am looking for is the sum of figures defined by a sort and that it be done automatically. This is for a theatre company that does 60 pay slips a year, so no big deal. I figure that for a small db, doing a quick sort through the db to calc the field is possible. If it is a million payslips, another system is needed. -
Cumulative Calc Solution for Name & Date
chlowden replied to chlowden's topic in Calculation Engine (Define Fields)
I'm trying to get my head round this. If I setup "join field" that means I will have a new table that will have a date & an amount associated to a person. The sum of this table, defined by the year will make the, will be created by a calc back into the original file. Is it possible to go loop back into the same entry? What would the calc look like? -
I have just served up the Youtube file on FMSA9 & it does not work in IWP either.
-
I am a little stumped. I have tried loads browsers but the qt file does not show up in IWP. I have attached 2 pix that graphically show the result between FM & IWP. I also have another layout with another webviewer taken from a url & that works great, so why not the script? Any ideas are welcome.
-
You have just solved one of my greatest FM mysteries. Thank you. But ... Do you know why it does not work in IWP?