Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Linking multiple Files for export

Linking multiple Files for export

Linking multiple Files for export

I want to export fields from multiple inventory related files such as IM.Items, IM.DETAIL, IM.ITEMEXT in MAS90. I couldn't find a file selection which all of the above files linked together. Using Link Files button in configuration tab, I tried to link the files but the fields of newly linked files will not be available in the data tab of export job maintenance window. Am I missing somthing? please help.


RE: Linking multiple Files for export

Are you using VI?  Well don't. Hard and not very fast. Instead PULL the data out of MAS using a program such as Access.   

RE: Linking multiple Files for export

Louie is right. I am in the same boat. I have been trying to pull data from MAS200 using VI. It is so slow kinda like working on a 56kbps internet connection.  

RE: Linking multiple Files for export

I developed a VB application that extracts Items and customer information using ODBC(DSN=SOTAMAS90) connection from MAS90. Can I use the same application to extract items and customers information ffrom another version of MAS90(the version I used to test the application is 3.70) or MAS200. Are tabel and table column names remain the same in every versions of MAS90 and MAS200.


RE: Linking multiple Files for export

The SOTAMAS90 DSN is a simple one. It cannot handle complex SQL calls. The best way to do it is to pull each table individually into the destination and then combine them as desired.

RE: Linking multiple Files for export

No, table and column names are not the same between different versions.  Some versions yes, some versions no.

For example, between 3.70 and 4.30, inventory is the same.

Between 3.70 and 4.30, customer info is not.


Visit Sage's Online Community

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close