Ersen Kavak

$filename holds the following during the script filewin:/C:/Documents and Settings/Administrator/Belgelerim/shareyourscience_v1beta/shareyourscience_v1.fp7 and script accesses the file and opens it and asks for username&pwd so $filename already holds the file path, it is just the name of the variable (my misconceptualizition :

Thanx again for the notification, it helped. However, it does not solve the problem. It does not matter what you use, actually:) Filemaker can locate the file... But, it cannot simply match the Table names to each other in two different files when the file name is introduced as a variable. Right now, I am kind of stuck with this hoping that this is a bug about my version :

I am indeed going to the corresponding layout for different tables. I am attaching the snapshot of the script and also snapshot of the Import Script Step 'Specify Import Order' dialog box, which does not display any source field to select the Table name in the source file (which was prompted by the user and assigned by us to a variable name) And, runtime solutions, to my knowledge and experience, can be multiple user (single-computer) and multiple priviliges. At least, I am using it that way. But, this is not the primary concern currently, as a workout can be fixed, probably. I have checked your very nice example in the importing&exporting part of the forum at http://fmforums.com/forum/showtopic.php?tid/209924/post/335152/hl/runtime/fromsearch/1/#335152 In your example, AT MY COMPUTER (maybe only my computer); the INVLi table does not import the data from v1, where as other 2 tables (invoices and people) do. And this pattern does not change, when I alter the 'Arrange By' option in the 'Specify Import Order' of import script step (see attached image) for any of the tables. This currently looks like an unsystematic thing to me, but maybe it is a late time to think : I am running FM 8.5 Advanced V0.1. Maybe, that is the thing... Regards and Thx for the discussion and nice examples again

Thx for this clear explanation: Following did not work for me though during a script which will update data from 20 tables either between runtimes or between a runtime and normal FP7 file (to my understanding this does not matter, runtime behaves mostly as a single-computer version Filemaker Pro Software); 1 - I dont want to set autologin on for a particular account name because mine is a multi-user system (may be I am missing something). Therefore, I could not manage to escape from the multiple username and password prompting problem; which is quite annoying for 20 tables; i.e 20 imports : 2 - The left hand side of the Import dialog box (the source file) does not display anything because I take the filename into a $filename variable by prompting the user to address the source file and storing a reference to that file. And finally copying that reference to the $filename variable. Therefore, I guess, Filemaker realizes only one Table from the source file and does not bother to search for a matching Table name during the import. This results in no import at 19 tables, but only 1 table. So, do I need to make the user browse the tables one by one ? This will not be proffesional at all. I have been searching for the solution for a long time, but I am unfortunately still where I have started : Any help to the above questions would really be aprreciated. Regards

Well, I think it is better if I can find a non-plugin solution because of two reasons: 1-) I dont want to make the installation more complicated 2-) I think, there should somwhere be a non plugin solution for automatic emailing due to the fact that lots of people should have needed it for some common database solutions (project management, job modules etc) So, I would be very happy with a non-plugin solution. Regards

Thanks very much for the input. I checked that plugin, I have not tried. But I think you are right. However, this will only work for FMSERVER 9. I will distribute my solution freely, and do not want to ask users to buy lots of additional things (there are some restrictions in the developer license, after 10 users, the users should buy enterprice license etc...). I would be very happy if anybody knows a free solution for this problem ?

Hi all, My question is about automatically running a web incompatible script every night. It would have been possible to use FMSERVER 9, if it was not web incompatible. But, I need to send emails and send email script step is not web compatible. I have been doing this by running a Filemaker file which opens the remote file and runs the script inside that remote file and then automatically closes itself. This has interestingly worked for 2 years in a MacOSX server. I added the File reference only once with usr and pwd, and it did not ask me about that usr and pwd again. This is a multi user system with an advanced privilige system, so usr and pwd are musts. Now, I am trying to do this in a Windows Xp machine, and the script is not running when I open the "scriptrunner.fp7" file. And, when I try to run the script, it asks for usr and pwd again. Can you please suggest a solution either how to remember usr and pwd in file references, or some other working solution to run a script on the server side every day ? Best Regards and Thx from now

I had the same problem, I have just solved it, and it was not becuase of a duplicate ID... It was because I had a relationship with a pre-existing table. So, when I want to delete a record from Table1, I could not do it. I had a relationship (in the relationship graph) with a previous table 2. So, Filemaker does not update the relationship graph when you delete a table.. When I delete that occurence of preexisting table, things solved.. Regards

Thanks a lot, It totally solved my problem, and I am very happy to learn that an inner merge is possible like this in Filemaker...And I just started to wonder if an outer merge would be possible ? Regards and Thx again

Hi Thank you very much for the comment Lionel. Any clues how can I use this seperation model in practice (tutorial etc?) Regards and thx again

Hi, If you want to create new record in note details related to anote, than I would recommend checking the "create new records in this table via this relationship" checkbox under "notedetails" table, and then insert a portal which shows records from notedetails, in a layout of "notes" table... cheers

Hi, Any comments will be appreciated. I am really stuck. I am a biologist/bioinformatician. I am trying to track info for mices, in the lab. 1-)A mouse can be part of multiple breeding events. 2-)And, a breeding event can contain multiple mice. This relationship goes over mice::breeder_ID and mice_breeders::ID, as shown in attached image. The problem is, I can not have both of the above 2 points. I should choose either of them. From the mice layout, I want to put a portal which includes the information regarding in which breedings that mouse was used. And, from the breedings layout, I want to put a portal, which shows which mice were used in that breeding. I can not add 1 mice to more than 1 breedings. Because, breeder_id can get only 1 value, I guess. I tried adding new relationship fields into both tables, but there is something interesting going on here, I cannot even name. I am not coming from a computing background, I though I knew relationships, but apperantly I donot. Please Help Me Thx

So, I will take it as this is not possible ?

Hi all, After making the initial release of my filemaker solution, people will hopefully download it and install and use... When, I upgrade the solution's version by adding fields, tables, scripts etc; Is there a secure/accurate way of upgrading the solution on people's computer without altering their already recorded data ?? Regards and Thanks

Thank you very much for the reply; However, my second problem persists: I put my scriptrunner.fp7 file in to the scripts folder and I did the schedule. However, the scriptrunner file did not do what it was supposed to. Within Scriptrunner I have a file reference which remotely opens the labdadatbase . By using this reference I am running a script which should email to some people, I am running the script from the file by remotely opening it, it works and sends the emails But when I use the schedule option it does not work... Any ideas? Best

Hi all; I installed FM Server; As I understand we can run script files by fmserver admin. However, that option is always disabled in my software... My purpose was to run several files from which I am running some filemaker scripts in the files I am hosting to perform some daily or weekly checks and emailing issues... My first question is can we run FM files via this step ? My second question is: Is there any way to enable this option ? Thanks in advance Best wishes

Hi all, I want a demo cd of FMSA from my FMI company.. They have sent me a FM PRO and FMSA cd... I installed the web publishing engine, everything seems OK, except it says FM SERVER could not be found...And, in the Instant Web publishing of FM PRO, nothing has changed...For instance, i have tried to change the language of the IWP interface from the web publishing engine, and it did not work. Therefore, it is clear that, FMSA and FM PRO don't know each other for now ? My question is very simple: Can FMSA run with FM PRO, If so, how? Or is FM SERVER needed, because if so, I will request an FM SERVER cd from my distributor. p.s: I know, you can think why don't you ask this to your FM Distributor, but the thing is that they don't know anything. Thanks and Best Regards

Dear Reed; thanks for your reply.. I have lots of questions to ask about FMSA..in the first hand can the page size be arranged ? Is there a detailed!! documentation about FMSA which I can get...If you have it in the PDF format, can u send it to ersenkavak@gmail.com because if it will face me with the same problems in IWP as FM7 PRO, I will think twice before buying FMSA... Thanks again

Hi; I have been using fm7 since approx 1 year before. I am happy with FM. I made two different databases one of which is for laboratory optimization (15 people), and the other is for department optimization (100 people), I will host these 2 dbs from one MacOSX server G4... With FM7 it is getting difficult to host several files to this much people... So, It seems reasonable to buy advanced server at this point. But, to make bosses believe that advanced server is really neccessary, first I should believe it will be enough...Because, it is quite expensive and no demo is available as I know... In brief, I have two questions: 1: a) Will all the scripts work in web publishing companion? Will it be the same as using FM over network sharing? If not what will be the differences ? 2: I will host a webpage and Mysql over that server, too...Do you know any possible conflicts? Thanks in advance for any help Best

Hi all, I have 10 tables in my db... My problem is in the 3 of these tables...to talk more explicitly the names are projects, orderforms and subbudgets I have a relationship between projects and orderforms on the field projectacronym I have a relationship between subbudgets and projects on the field subbudgetID Thus, orderforms are indirectly related to the subbudget fields... And this indirect relationship is the one I really need and it is the source of the problem... For instance, when I use this while defining a value list with the include only related record option, it works as expected... However, when I use it in the sum function, by trying to take the SUM of related orderforms under a subbudget, it takes the grant sum(which means the sum of the orderforms which are related to the whole project)... And unfortunately, I have multiple subbudgets under a project. And multiple orderforms under each subbudget... ps: I tried creating a different relationship between orderforms and subbudgets, however this creates problems in my db design and hardens lots of things, thus if anybody has an idea why this SUM is not working in this kind of a relationship, waiting for any ideas... Best Ersen

hi thanks for your comments so, does it mean that, I can not create daily backups while serving a file with FM PRO7 I should have FMSERVER 7, Than, what the "Save a copy" method stands for? Just to use it, when you are not serving a file? THat means, the sharing option should be off...

Yes, the db is being served at that moment, although there is not a user connected at the time of backup, because it is exectued at midnight... Also. i have tried executing the script when I am sure nobody is connected...

Hi I was trying to find a way to make a daily backup of my labdatabase db, And finally. I did it by running an external file by using ical, everyday. from this file, i am running a script which 1 Saves a copy of my database (by executing the script in labdatabase by using file reference) 2 and Perform Applescript, and rename the copied file, (I tried performing this script step both from the scriptrunner file(the external file) and from the labdatabase file) 3 close the scriptrunner file... By this way, I am able to make daily backups which has the current date appended to the name of db This method used to work for about a month, However, suddenly it started to give an error like: "Finder got an error(error 2), the operation could not be completed", and when i passed this error by clicking OK a second one comes: "Sorry, there is not enough memory to complete this operation, " below is the applescript I have been using tell application "Finder" activate set theDate to current date set gun to day of theDate set ay to month of theDate set yil to year of theDate set name of document file "Labdatabase.fp7" of folder "Backups" of folder "Filemaker_db" of startup disk to "Labdbbackup_" & gun & "_" & ay & "_" & yil &".fp7" end tell I am working on a MacOSX server 10.3.8 I restarted the server to check if it migh be helpful, but the problem persists Thanks for any kind of help Best

Thanks for the input, I have setup insidescan, But, the first problem arises in the case of communicationg with the scanner I mean somehow the sequence should be ass follows: 1-User will press the scan button in filemaker, 2-Than, the scanner will start scanning automatically (with applescript may be) 3-Than, filemaker will understand the name and the location of the picture which is scanned, somehow 4-And import the picture into the database and create thumbnails and some other manipulations with insidescan,... the third step gets me confused, and i cannot manage it, any suggestions...

Hi all I have been searching the topic for this subject. But I could not find the exact answer i am looking for, This is the situation I am making a big archive with several photos for each item...I made this by relational tables... The problem is that,, I want to scan the photo directly in to the record, because this will create a new related record in another pictures table....And this is really hard to do by hand...I want to ease this job for my users... I guess there is already an answer to this but I could not find any Any ideas or redirections, Thanks