Does anyone in the group have experience moving a company from MAS 200
accounting software (big brother to MAS 90) to a Pick based system? I
am mainly interested in converting data. I know that MAS 200 has an
ODBC interface but I am not familiar at this point with the database
schema.

Anyone that has any insight and would like to share would be greatly
appreciated.

Thanks,
Dick Thiot
dthiot/at/mavsys/dot/com

"Thiot" <Dick.Thiot (AT) gmail (DOT) com> wrote

ODBC should be your last resort unless you only have 1000 records or less.
ODBC is slow and has problems maintaining connections with large volumes of
data.

If MAS has an export feature then use it. FTP the data to the Pick side for
speed. Write a Pick program to do your date & time conversions to internal
format and parse the data to the proper files. If you have indexes on the
Pick files they will be updated as the data is added.

Hi,

You can use ODBC or DAO features in BRIZ. This feature allows You to
access to other DB through client PC DAO or ODBC, directly from
PickBasic. Free of charge for in-house using.

Regards,
Grigory

Thiot wrote:

Thanks for the replies. We don't have any problems moving the data
into the multi-value database. Our issue is extracting the data from
MAS200. If there is an industry standard connection we can use that
but will need to understand the DB schema.

This is probably more a question for a MAS200 experienced person. I am
trying to find a MAS200 group where I can post this question.

Thanks again,
Dick

GVP wrote:

I believe MAS200 has the ability to export data to an Excel spread sheet. I
would convert the spread sheets to tab delimited text and convert from
there.

Years ago I did a conversion from MAS90. It could not export data at all. I
set up program to receive information over a serial port and write it into a
data file. Then I had MAS90 print reports such as customer listings and
inventory to a serial printer that was attached to my serial port. After
receiving the report, I parsed the data from the report format into usable
data.


"Thiot" <Dick.Thiot (AT) gmail (DOT) com> wrote

Jeffrey Kaufman wrote:
You could run into problems with the Excel option. Excel can only
support 64K rows (or 32K for older versions).

Luke

For one conversion (not from MAS) I had an app that would only print to the
lpt1 port. I simply remapped (net use) it to a windows printer I had setup
that printed to a local file. I would print a report, it would ask for the
file name. I then just extracted the data from the text file (parserat -
www.parserat.com is pretty good at this).

This way you don't have to worry about serial ports ...

hth
Colin

"Jeffrey Kaufman" wrote
[snip]

I presume that the convert to spreadsheet option is actually CSV file
format? In which case don't use Excel to manipulate the file, just access
the CSV format itself.

I have a program somewhere that converts CSV to AM/VM delimited data (ie
rows are attributes and each column becomes a value).

Regards
Simon

--
Simon Verona

"Luke Webber" <luke (AT) webber (DOT) com.au> wrote