Skip to main content
M
Mikki
January 27, 2026
Solved

How to export from and import to custom OS tables

  • January 27, 2026
  • 2 replies
  • 0 views

Hi,

For the v8 to v9 upgrade, it seems like we need to remove our custom tables and add them back after the upgrade.

We have scripts to add the tables back but what is the process you follow to export and import the data back. Table Data Manager or write a script to save csv file to OS folder and load it back?

Thank you in advance,

Praveen

Best answer by SimonHesford

Table Data Manager will work no need to write a script (unless you want to) 

2 replies

S
SimonHesfordAnswer
January 27, 2026

Table Data Manager will work no need to write a script (unless you want to) 

M
MikkiAuthor
January 27, 2026

Would this still work if our custom tables do not start with prefix "XFC_"?

Thank you,

Praveen

R
rhankey
January 27, 2026

TDM by design on works with tables named with a particular prefix.

There are many way one could transfer custom tables over to a new App.  One method would be to have the old V8 DB temporarily restored to the V9 DB server alongside the new v9 DB so that you can use SQL statements to copy the Tables from the old to new DB.  This would definitely be the way I'd go if dealing with large tables or tables containing binary or other challenging data.  Beyond that, if you will find that there are at least as many export/import methods employing business rules as people who respond.

Terms & ConditionsAccessibility statement