What is the fastest way to sync a table to ValueList items?
I have a large table with a ValueList, I want to sync another table with this value list.
Case, if a ValueList item does not exist in the other table, add it.
I am interested in the most efficient script steps.
Tables in the same file?
How many fields are in your ValueList table?
Is this a one time thing or are you doing it regularly?
We definitely need to know more. It is possible that you don’t need a script. A use values from field value list might be used to list values from that other table and then it will automatically be in sync with the data in it.
Tables are in the same file. 133 fields in the ValueList (transaction) table. Regular update upon login.
New occurrences of the widget are created through manual entry, importing, API of the transaction table. I need to maintain a side table listing each unique occurrence of a widget in the main table. A widget will occur many times in the transaction table but only once in the side table.
What is the most elegant, efficient, fast way to add new records to the side table when the user logs in for example.
I know I would start with getting the ValueList items, probably loop through each to see if it is valid in the side table, if not, add the new found widget to the side table.
Why would you add a new item to the transaction table without first adding them to the "side" table?
A relationship linking the two tables would work for this. You can perform a find for the records that do not have a matching record in the side table and then import the found set into the side table. A "unique values" validation on the side table can keep duplicates from being produced by the import.
Go To Layout ["MainTable" ; (MainTable) ]
Enter Find Mode [pause: off]
Set Field [ SideTable::ValueField ; "*" ]
Omit RecordsSet Error Capture [on]
Perform Find [ ]
If [ Get ( FoundCount ) > 0 //there are records in Main not in Side ]
Import Records
End If
philmodjunk wrote:
...
Perform Find [ ]
If [ Get ( FoundCount ) > 0 //there are records in Main not in Side ]Go to Layout [ SideTable ( SideTable ) ]
Import Records [ from: TO MainTable ... ]
End If
For completeness‘ sake
While often useful, a scripted import does not need to be performed from a layout based on the target table.
Why would you add a new item to the transaction table without first adding them to the "side" table?
A relationship linking the two tables would work for this. You can perform a find for the records that do not have a matching record in the side table and then import the found set into the side table. A "unique values" validation on the side table can keep duplicates from being produced by the import.
Go To Layout ["MainTable" ; (MainTable) ]
Enter Find Mode [pause: off]
Set Field [ SideTable::ValueField ; "*" ]
Omit RecordsSet Error Capture [on]
Perform Find [ ]
If [ Get ( FoundCount ) > 0 //there are records in Main not in Side ]
Import Records
End If