help please import record

[a7madmotaw3]

Hi all,

In my solution for managing my clinic I made a single step script (that is triggered by a button in the portal) to import records from a portal row to another table portal row using import records step, all of a suddenit stopped working, I tried the script debugger, sometimes no error occurs but records are not imported, other times error 729 occur..any suggestions?

[Ocean West]

The best way to diagnose this is if you can post a pdf of the script or a screen shot of the script.

[a7madmotaw3]

the script supposed to import some fields from this portal on the right side

to this portal in the same layout "semen analysis"

the single step is

I import from the same file without dialog, using matching records depending on the field occuring in the relationship and adding the rest of records as new records..It was working just fine till yesterday..I did nothing in the database except a couple of new scripts.

Edited July 29, 2015 by a7madmotaw3

[Ocean West]

Tough to say are any of the target fields have any validation (such as unique),

Also if you are importing from TableA - to TableB in the same file you need to establish a found set context otherwise you will import EVERYTHING or nothing.

Before the import you should do a GTRR for the portal who's data you wish to import going to a "utility layout" then you can import that found subset of record into TableB then return to your main layout.

[a7madmotaw3]

I revised the validation and no unique values or something is there, regarding the importing of everything, I was only updating the atching records with the data I've just entered in the first record, so when using the same file to import from tableA to tableB depending on that, it was supposed to just add the new data which was exactly going well.

Would u plz give me an example of the script that can copy the fields in the portal row (on which the button triggring the script is pushed)

to another portal going to a next record automatically

[Ocean West]

Try this

 importSample.fmp12.zip

[a7madmotaw3]

Hi

thanks a lot for your help but it still not working and I think am doing something wrong..I need to clarify to you that all the tables in my database are related through a unique field "pat no", my main table "androdatabase" (which is table c in ur example) is related to visits table (in ur example tableA) and to semen table (tableB in ur example).

I made a globale field in Androdatabae table (= tableC) and related it to visists table (=tableB) through the same field and named visits table in the new relation (visits_selected) and still not working?!

[Ocean West]

Database 101 - every table should contain a Unique ID (serial number or UUID).

When you are on androdatabase and then click the button on a row in portal attached to visits the goal here is to set a global temp field of that row's unique ID or serial. 

This establishes a 1:1 relationship to visits_selected where the script then can isolate that one record and allow for the import of this record into the semen table

using your pat no will not work because every record in every child table is already assigned to this value.

alternatively you can also do this without a temp field or relationship by doing a find request for that unique record number in the visits table to isolate the record. (but we still need a unique value) 

Just looking at your graph, as a suggestion you may wish to take a moment and rename your primary key field and the foreign key fields for consistency and clarity, in each table and avoid the apostrophe in field names if you venture into using SQL or other technologies or plugins or web will be problematic. I don't think upper or lower case poses an issue but you having a unified nomenclature can save your sanity  

I currently see:

• pat id
• Pat's ID
• patients no
• Patient's No
• Pat's Id
• pat's id
• patients No
• patient's ID
• pat's ID
• patients no

reference may be helpful http://filemakerstandards.org/display/cs/Field+naming

Edited July 30, 2015 by Ocean West
added alternative method

[a7madmotaw3]

Am really grateful for ur help and patience..I went with ur valuable advice and renamed the fields with unique names and created the global field and the unique id field for the visits table and I think I did everything as it should be but still not working, am getting nuts so plz don't get bored

 

Edited July 31, 2015 by a7madmotaw3

[Ocean West]

when labeling the fields using the term "UNIQUE" in the name for a foreign key is a bit missleading - because the nature of a foreign key is that it is not necessarily unique.

Also remember field types between primary and foreign keys used in a relationship should be of the same type - text or number. 

In addition I added the alternative approach to using a FIND method,

And also yet another approach by just storing values in variables and setting field (no import) - this works but it depends on how many fields you need to set.

I revised the sample file using your table names and appropriate primary and foreign key labels. 

 importSample.fmp12.zip

[a7madmotaw3]

I appreciate your effort but it seems there is something in the structure of the database that prevents the three scripts from working..if u please I could send you a clone copy of my solution to help me solve this out

[Ocean West]

Sure, i'lll take a look.

[Ocean West]

i sent you you file backchannel.

the reason for the import error was one field had a validation for "REQUIRED" which had no data in it from the import, that caused it to fail.  

In the file I sent i went with the Set field option as it is most appropriate in this case as there is less that can go wrong. 

[a7madmotaw3]

thanks for ur great help in the previous issue.

I have a more simple one 

I have a repeat field with a value list that includes 2 values "1ry infertility and 2ry infertility" and other values, i need to hide a popover button depending on the absence of the world "infertility" from this repeat field,

 I used the calculation 

IsEmpty ( FilterValues ( patients::Complaint ; "infertility" ) ) to hide the button using hide object function in the inspector, but it didn't work

Edited August 3, 2015 by a7madmotaw3

[Ocean West]

when testing things against a repeating field you may need to use the Extend ( ) function 

PatternCount ( Extend ( patients::complaint ) ; "infertility" ) = 0 

(i haven't tested this one yet - and haven had my coffee either ) 

[a7madmotaw3]

It worked!

It seems that coffee is not as crucial as we thought 

[a7madmotaw3]

I found that with the above calc  the button appear only when "infertility" is present in the 1st repeat field but not when in the 2nd or 3rd..Is there a modification that could be done?