Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Contributor
6toes2
Posts: 14
Registered: 04-04-2011
0

7.4 ASCII AR import File Format

Can someone please advise me of the following:

Is the ASCII file format suppose to use fixed, spaced or camma seperators?

Is there a Max field length.

 

Also, can anyone tell me which is better to use an ASCII file or a CSV file?

 

Sage Employee
manookian
Posts: 84
Registered: 07-06-2009
0

Re: 7.4 ASCII AR import File Format

Are you attempting to use Data Import Manager to import this file?

Contributor
6toes2
Posts: 14
Registered: 04-04-2011
0

Re: 7.4 ASCII AR import File Format

Yes we are but we are not upgrading to 7.4 until late January and I wanted to make sure that the 7.4 format is the same as the 7.2 format.

Sage Employee
manookian
Posts: 84
Registered: 07-06-2009
0

Re: 7.4 ASCII AR import File Format

If you are using data import manager you need to setup the source connection. The best type to use would be the one that closely matches the source file data, i.e. you probably want to massage the data as little as possible.