Iron Speed Technical Forums
Register Latest Topics
 
 
 


Reply
  Author   Comment  
supanes

Registered:
Posts: 109
Reply with quote  #1 
I have 3 tables with the same structure, which is the best way to clone an add or edit page?  i just wanna personalize one page, clone it and change the reference table for the other 2 tables.

Sorry about my english!! 
timt

Avatar / Picture

Iron Speed MVP
Registered:
Posts: 556
Reply with quote  #2 
Hi

you can clone a page by right clicking and choose the "Create a Duplicate" option from the ISD Application Explorer. Then rename as required.

HTH

__________________
Tim Titchmarsh Iron Speed Consultant MVP
London UK based
+44 (0)1621 835002
http://www.lightspeeditsolutions.co.uk/dotnetarchitect
timt@dotnetarchitect.co.uk
timt@lsits.co.uk
supanes

Registered:
Posts: 109
Reply with quote  #3 
Thanks. But i think i dont explain my requirment at the right way.

I have an add page pointed to with table name "A"

Now, i want to duplicate that page (add page for example) but i need it for other table name "B"

Both tables "A" and "B" has exactly the same structure (fields, lenghts,etc)

I want to do a page to add sales offers(table "A") and then use other page with the same customization to capture sales orders(table "B") 

Thanks
dingjing

Avatar / Picture

MVP Developer
Registered:
Posts: 256
Reply with quote  #4 
There is no easy way to do this. However, the root problem is your database structure. Why do you need 3 tables with the exact same columns? An ISD application, or any database application, can only be as sound as its underlying database.
supanes

Registered:
Posts: 109
Reply with quote  #5 
It's SAP B1 ..   all the "marketing objects" are in different tables with the same structure (offers, sales orders, invoices, etc)

can you explain me "the hard way"?

Thanks



dingjing

Avatar / Picture

MVP Developer
Registered:
Posts: 256
Reply with quote  #6 
If you don't have much customization on the page, just redo the page 3 times. If  that is not an option, try creating a combined view on top of 3 tables. Build the page based on the view. On add/edit page, write some custom code to save changes to the underlying tables.
Juanro

Avatar / Picture

Registered:
Posts: 104
Reply with quote  #7 
You can always try to copy and hack the .XML with the ISD definition of your page... I've done it many times.
Steps:
a- Backup everything, first closing ISD.
b- Find and copy YourPage.xml
c- Now edit it with your XML editor of choice. Search and replace fundamentally two things: the page location (the folder where your original page was, if you copied it to another folder) and your table name.
d- Cross your fingers, open ISD, eventually do a View -> Refresh, and Rebuild All. Most of the times it works, but as famous TV magician used to say, "it could fail". Should that be the case, restore your backup and come back for some more info.

Hope this helps.
Juanro
supanes

Registered:
Posts: 109
Reply with quote  #8 
Thank you

Quote:
Originally Posted by Juanro
You can always try to copy and hack the .XML with the ISD definition of your page... I've done it many times.
Steps:
a- Backup everything, first closing ISD.
b- Find and copy YourPage.xml
c- Now edit it with your XML editor of choice. Search and replace fundamentally two things: the page location (the folder where your original page was, if you copied it to another folder) and your table name.
d- Cross your fingers, open ISD, eventually do a View -> Refresh, and Rebuild All. Most of the times it works, but as famous TV magician used to say, "it could fail". Should that be the case, restore your backup and come back for some more info.

Hope this helps.
Juanro
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.

Download Iron Speed Designer

Terms of Service Privacy Statement