Need help - Copying and pasting records

[rrric]

I'm a newbie in need of some help... I'm trying to figure out a script to copy an entire record from one layout and table and paste it on another layout from another table. It's for an inventory db I'm trying to develop and I want to transfer one record from one location's inventory to another location's. The layouts are identical (as far as the fields) and the tables are basically duplicates of each other. I tried ...

Copy Record/Request

Go to layout(layout name)

Paste[] (also Paste[select])

Go to layout(original layout)

Delete Record/Request

didn't work. Tried adding Open New Record/Request before the Paste and it pasted all the field contents in first field. I also tried copying one field at a time and pasting it to the other layout's matching field, but nothing appeared in the fields i specified it to paste in. Any help would be greatly appreciated. [color:"red"] [color:"red"]

[rrric]

I'm a newbie in need of some help... I'm trying to figure out a script to copy an entire record from one layout and table and paste it on another layout from another table. It's for an inventory db I'm trying to develop and I want to transfer one record from one location's inventory to another location's. The layouts are identical (as far as the fields) and the tables are basically duplicates of each other. I tried ...

Copy Record/Request

Go to layout(layout name)

Paste[] (also Paste[select])

Go to layout(original layout)

Delete Record/Request

didn't work. Tried adding Open New Record/Request before the Paste and it pasted all the field contents in first field. I also tried copying one field at a time and pasting it to the other layout's matching field, but nothing appeared in the fields i specified it to paste in. Any help would be greatly appreciated. [color:"red"] [color:"red"]

[rrric]

I'm a newbie in need of some help... I'm trying to figure out a script to copy an entire record from one layout and table and paste it on another layout from another table. It's for an inventory db I'm trying to develop and I want to transfer one record from one location's inventory to another location's. The layouts are identical (as far as the fields) and the tables are basically duplicates of each other. I tried ...

Copy Record/Request

Go to layout(layout name)

Paste[] (also Paste[select])

Go to layout(original layout)

Delete Record/Request

didn't work. Tried adding Open New Record/Request before the Paste and it pasted all the field contents in first field. I also tried copying one field at a time and pasting it to the other layout's matching field, but nothing appeared in the fields i specified it to paste in. Any help would be greatly appreciated. [color:"red"] [color:"red"]

[MoonShadow]

To move a record from table1 to table 2, be on record you want to move. Click button MOVE with script attached of:

Freeze Window

Show All Records

Omit Record

Show Omitted

Go to Layout [Table 2 Layout]

Import [ Table 1; Add as new records) ... (import created inside script will store. Watch that popup at top of import dialog; select table 1)

Show All Records

Go to Layout [ original layout ]

Delete Record/Request [ perform without dialog ]

[MoonShadow]

To move a record from table1 to table 2, be on record you want to move. Click button MOVE with script attached of:

Freeze Window

Show All Records

Omit Record

Show Omitted

Go to Layout [Table 2 Layout]

Import [ Table 1; Add as new records) ... (import created inside script will store. Watch that popup at top of import dialog; select table 1)

Show All Records

Go to Layout [ original layout ]

Delete Record/Request [ perform without dialog ]

[MoonShadow]

To move a record from table1 to table 2, be on record you want to move. Click button MOVE with script attached of:

Freeze Window

Show All Records

Omit Record

Show Omitted

Go to Layout [Table 2 Layout]

Import [ Table 1; Add as new records) ... (import created inside script will store. Watch that popup at top of import dialog; select table 1)

Show All Records

Go to Layout [ original layout ]

Delete Record/Request [ perform without dialog ]

[rrric]

Thanks much for the help and advice. I'll try this when I get to work tomorrow and let you know how it went. Have a great evening.

[rrric]

Thanks much for the help and advice. I'll try this when I get to work tomorrow and let you know how it went. Have a great evening.

[rrric]

Thanks much for the help and advice. I'll try this when I get to work tomorrow and let you know how it went. Have a great evening.

[rrric]

Tried what you suggested, although I assumed the Import you referred to was Import Records as this was the only import option available. When I proceeded to the specify (import order) it brought up an Import Mapping window (made sure the targetwindow at top had the original layout chosen. The window did not list any source fields on it. When I tried running the script an Open File window came up looking for file. The Impor Record script step showed Import Records [Add:ANSI]. Did I take a wrong turn somewhere?

[rrric]

Tried what you suggested, although I assumed the Import you referred to was Import Records as this was the only import option available. When I proceeded to the specify (import order) it brought up an Import Mapping window (made sure the targetwindow at top had the original layout chosen. The window did not list any source fields on it. When I tried running the script an Open File window came up looking for file. The Impor Record script step showed Import Records [Add:ANSI]. Did I take a wrong turn somewhere?

[rrric]

Tried what you suggested, although I assumed the Import you referred to was Import Records as this was the only import option available. When I proceeded to the specify (import order) it brought up an Import Mapping window (made sure the targetwindow at top had the original layout chosen. The window did not list any source fields on it. When I tried running the script an Open File window came up looking for file. The Impor Record script step showed Import Records [Add:ANSI]. Did I take a wrong turn somewhere?

[MoonShadow]

... it brought up an Import Mapping window (made sure the targetwindow at top had the original layout chosen.

Minor wrong turn; I was unclear. Original layout is SOURCE. Target is destination layout. And to keep the Import Dialog from appearing, click 'Perform Without dialog.' So entire thing would look like:

Script Step Import Records:

Specify Data Source

File Type (select fp7 in lower popup)

Add File (select the fp7 file you are currently in)

Say OK

Import Order:

Top left Source popup (your original layout table with isolated one record)

Top right target popup (your current layout)

Also, if this is multi-user environment, you might want to protect from the possibility that another User creates a new record which would appear with your Omitted record. So a better script would be:

Freeze Window

Loop

Show All Records

Omit Record

Show Omitted Only

Exit Loop If [ Get (FoundCount) = 1 ]

End Loop

Go to Layout [Table 2 Layout]

Import [ Perform Without Dialog, Table 1; Add as new records ]

Show All Records

Go to Layout [ original layout ]

Delete Record/Request [ perform without dialog ]

[MoonShadow]

... it brought up an Import Mapping window (made sure the targetwindow at top had the original layout chosen.

Minor wrong turn; I was unclear. Original layout is SOURCE. Target is destination layout. And to keep the Import Dialog from appearing, click 'Perform Without dialog.' So entire thing would look like:

Script Step Import Records:

Specify Data Source

File Type (select fp7 in lower popup)

Add File (select the fp7 file you are currently in)

Say OK

Import Order:

Top left Source popup (your original layout table with isolated one record)

Top right target popup (your current layout)

Also, if this is multi-user environment, you might want to protect from the possibility that another User creates a new record which would appear with your Omitted record. So a better script would be:

Freeze Window

Loop

Show All Records

Omit Record

Show Omitted Only

Exit Loop If [ Get (FoundCount) = 1 ]

End Loop

Go to Layout [Table 2 Layout]

Import [ Perform Without Dialog, Table 1; Add as new records ]

Show All Records

Go to Layout [ original layout ]

Delete Record/Request [ perform without dialog ]

[MoonShadow]

... it brought up an Import Mapping window (made sure the targetwindow at top had the original layout chosen.

Minor wrong turn; I was unclear. Original layout is SOURCE. Target is destination layout. And to keep the Import Dialog from appearing, click 'Perform Without dialog.' So entire thing would look like:

Script Step Import Records:

Specify Data Source

File Type (select fp7 in lower popup)

Add File (select the fp7 file you are currently in)

Say OK

Import Order:

Top left Source popup (your original layout table with isolated one record)

Top right target popup (your current layout)

Also, if this is multi-user environment, you might want to protect from the possibility that another User creates a new record which would appear with your Omitted record. So a better script would be:

Freeze Window

Loop

Show All Records

Omit Record

Show Omitted Only

Exit Loop If [ Get (FoundCount) = 1 ]

End Loop

Go to Layout [Table 2 Layout]

Import [ Perform Without Dialog, Table 1; Add as new records ]

Show All Records

Go to Layout [ original layout ]

Delete Record/Request [ perform without dialog ]

[rrric]

WooHoooo! It's working now. You've been a great help to me as I stumble along. Thanks again!

[rrric]

WooHoooo! It's working now. You've been a great help to me as I stumble along. Thanks again!

[rrric]

WooHoooo! It's working now. You've been a great help to me as I stumble along. Thanks again!