Copy Item from one Company to another

bigdarki · December 15, 2003, 2:21pm

Hey Gays Waht would be the easyest way to Copy Table 27 from one company to another in the same db? any suggestions?

Andre_DDB · December 15, 2003, 2:31pm

quote:

Originally posted by BigDarki
Hey Gays …

Take care with such addresses [:p].

quote:

Originally posted by BigDarki
Hey Gays Waht would be the easyest way to Copy Table 27 from one company to another in the same db? any suggestions?

Open Navision twice (each company once) - copy and paste the table data or - create a dataport - export the data - export the dataport - import the dataport - import the data bye André

xorph · December 15, 2003, 2:57pm

quote:

Originally posted by BigDarki
Hey Gays

I hope you will also accept this answer from a straight guy… [:D] You could write a classic “3-liner” report: Create a report with a dataitem on table 27, and run it from the “source company”. Declare a global variable Item2 of type Record/Table 27, and in the OnPreDataItem trigger you write Item2.CHANGECOMPANY('TargetCompany'); In OnAfterGetRecord, you write Item2 := Item; Item2.INSERT(FALSE); Exactly 3 lines of code [8D]

stryk · December 15, 2003, 3:35pm

Use “Company Copy” by Emiel Romein [:D] http://www.mibuso.com/dlinfo.asp?FileID=275 Regards, Jörg

David · December 15, 2003, 3:46pm

Hi Darki, All the solutions above work fine, and the easiest tool is probably the “Company Copy” tool that Joerg recommended. Just keep in mind that those solutions will only copy the table, and nothing else… So make sure you copy all tables that could relate to this one, like the Item Translation Table, Comments, etc.

Steffen_Voel · December 15, 2003, 3:55pm

… and don’t forget blobs (Picture), if any …

anfinnur · December 15, 2003, 11:54pm

quote:

Originally posted by xorph …and in the OnPreDataItem trigger you write Item2.CHANGECOMPANY('TargetCompany'); In OnAfterGetRecord, you write Item2 := Item; Item2.INSERT(FALSE); Exactly 3 lines of code [8D]

Correct. But don’t forget table “Item Unit of Measure”; that will be some more than 3 lines… [;)]

xorph · December 16, 2003, 7:42am

quote:

Originally posted by Anfinnur
Correct. But don’t forget table “Item Unit of Measure”; that will be some more than 3 lines… [;)]

Correct. There’s also the pricing and supplier table etc. But he didn’t ask for those [:D]

bigdarki · December 16, 2003, 3:42pm

Thanks a lot for the answers quoting: There’s also the pricing and supplier table etc. But he didn’t ask for those , → dont need them, but thanks anayway for the reminder…

Lennart_Nielsen · December 18, 2003, 9:57am

Why not just use the standard functionality in Setup Checklist ??

David · December 18, 2003, 4:06pm

quote:

Originally posted by Lennart Nielsen
Why not just use the standard functionality in Setup Checklist ??

Very good idea Lennart! Why develop something if it already exist ??? However, I think that some additionnal tables (like Item Unit of Measure) are not included in the setup checklist.