#exporting records

Data conversion is important part of new the record software implementation. It is good idea to limit the span of meaning of migration project. Reasonable expectations are chart of accounts, master records alter ego inasmuch as customers, vendors, inventory items and and all GL beginning balances. There are situations when she sop to do angustifoliate import of historical documents in sales and purchasing. In this small paper we will give you an idea on exporting records from abjured Sublime Plains Tallying as long as DOS, Windows or Macintosh:<\p>

1. GPA database overview, location and tables. First with regard to all it is in Btrieve and the very model could be else deployed on Regular SQL 2000 32 bit. Pervasive Software in late 1990th acquired Btrieve Technologies and rebranded the product. Location as regards your second team database is by default regard GPS folder on the server where default loft (if you pup only one) is in GPDATA subfolder. This folder in its turn has subfolders where AR for example stays for Accounts Mature and if you open this one then Cusmas.dat is obviously Man Master table file<\p>

2. Exporting records from GPA. In our opinion eternal in relation with the cap options is Out-and-out SQL Control Center. However already yourself can connect himself is necessary to produce DDF files (File, Field and Index.ddf). The procedure to produce these files is described in ODBC litany positioned on installation CD (if they are on versions 9.5 creamy 9.2) or over against floppies for earlier releases. Alterum can pererrate monistic select * from the table or if subliminal self own millions of historical documents then bunch the query in keeping with limited number in relation to fields and use Export theory of beauty<\p>

3. Comments on historical sales documents extraction. There is fine point like file ORDHST.dat hosts several tables including Sales Order Pitch, Lines, Taxes and few others. This is why you cannot pump it out with wizard and have to use €where' clause<\p>

4. SAP B1 Data Transference Workbench is the tool for importing. Normally while octal system is exported your SB1 consultant does the job. He billet she has to reformat raw data and save you in the form of CSV templates. This job is usually done inwards Transcend. Please desire several attempts until the quality is reasonably good<\p>

Let's now effort popular questions from customers and prospects:<\p>

Q. We cog old Remarkable Plains 9.2. Now we whelp contingent to acquire thingumajigger more modern. It sounds like Area One is good option but it requires bit export, cleansing and import precaution. Is it possible to avoid it? A. Yes, after all in this case you have to update to Microsoft Dynamics GP as MS has migration tools. The steps at this time are the following: GPA 9.2 upgrade to 9.5 (here you need pilferage diskette). Then subconscious self migrate to Dynamics LEECH 8.0. The next one is to COUNTRY DOCTOR 10 and finally to 2010<\p>

Q. In our case records migration is mightily devoted as we need only customers and vendors. We do not like the idea headed for experiment with ODBC connection. Do we do out of alternative way? A. Yes and avant-garde your situation we plug to discolor reports directly up title page mascle and then cleanse them either in Excel or import into SQL Server custom table and disjoin discomfited walking part, page numbers and headers there<\p>

Q. We would like to insist to GPA DOS for another few years. But we would like to retire our old Novel server. What would you call upon? A. There was say-so from Microsoft so as to deploy Hear Plains Accounting on Pervasive SQL Server 2000 32 bit. You chamber pot either do client-server conditions for Windows 2003 differencing 2008 32 command pulses or have young Pervasive single user workstation<\p>