Sage MAS 90 and 200 Extended Enterprise Suite

[timt]

I am trying to VI a list of extended descriptions and some of the descriptions have more than one line of data in the description field. The problem when I save my document as a CSV and the line feed characters creates a new row. When MAS imports the VI the added rows are seen as added rows and thus give and error.

What might be the best solution for adding descriptions that have more than one line of data?

Tim

[thebottomline]

Simplest would be to combine all rows into one field.

[timt]

That would be the simplest solution but it's not an acceptable solution at this point. Combining them would be my last plan of action.

Thanks for the comment

Tim

[thebottomline]

Perhaps you can figure out something with temp fields but since you state that the extended fields are on separate rows, I don't see how this would work for you.

Hopefully, someone else will have a easier fix but at this time, you should start working on this last plan of action.

[timt]

Is there any code that Sage will accept as either unicode or ASCII such as C code /n /r? I did try these in various formats, but it did not work.

[DFeller · Accepted solution]

Bring this into an ODBC table and import from ODBC (e.g. like Access).

Dawn

[thebottomline]

Excellent suggestion Dawn.  I need to get out of my comfort zone more often.

[timt]

I used the Microsoft Query and excel to get the data out from MAS but was not sure it is bi-directional.

Would access allow me to do that or would I need to use some VB script?

Tim

[DFeller]

No, in Access you just import external data.  Then set up an ODBC data source to point to the access database and use MAS to import from that.

Dawn