Can data stored in Extender tables be exported to tables in a third party database?

(0) Share

Report

Posted on by Community Member

We are trying to limit the number of times the same information is manually entered for our company. We have Extender installed with GP 2010 to store additional information on each Item Maintenance card. It is working great for data imports into GP from an Excel spreadsheet created from a dBASE IV system for thousands of items. However, we would also like to export that same data from GP to the third party Accellos' vship database tables to avoid manually entering it again. Is this possible in Extender?

Any help is greatly appreciated.

Patti Parks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Community Member on at

Like (0)

Report

Yes - in that the Extender tables are SQL tables - so you can export the data, say with a sql view or something. Or by creating triggers. Hwever while extender is a great product the data is stored in a complex way (it needs to be done this way to allow extender to be so flexible). Anoher way you could export the data is to use a smartlist if you install the extender extensions. Export to XL and import to the other system.

Was this reply helpful? Yes No