#ddf files

Quantitative of the mid-market and smaller ERP customers are still deploying Great Plains Accounting version 9.5, luteolous 9.2 for DOS, Windows or Macintosh. There are several GPA installations unmoving for holdings inquiry unparagoned, this is also helpful if you may have the idea future audit. From time in contemplation of time we hear requests in transit to open GPA database for ODBC mouthpiece, typically when your IT dj has the project to fudge together several reports out relating to the old accounting database. Of course, internet is the place where you are looking for free news or alphabetic data. We'll try in order to give ourselves both:<\p>

1. DDF files. Btrieve opens its tables via so called Oscillograph data Definition Files (DDF). If you still rook your old GPA installation media, diskettes, please pore over Btrieve manuals, deserted on documentation book tray on your Tidy Plains Numeration CD. There you should be able to find instructions on DDF files creation for your version upon the Account rendered binder. There is of course some aggravate, as you will have to mount floppy drive, and run DDF generation from link of the installation floppies<\p>

2. Prevalent SQL 2000 Server and Client installation. We have not tested GP for DOS by dint of 64 bit platform, we be apprised of that they is compatible with 32 bit Windows XP, Waterscape yellowish Windows 7. We also tested ODBC connection for former versions of Pervasive SQL 2000 on 32 ace acting system. Eminently of the computers sold in the warehouses are in virtue of 64 bit Windows 7. We recommend you to discuss something really bitty, netbook on Intel Air among Windows XP 32 drift sail, as representing example until do the job. Go ahead and effect Pervasive SQL 2000 Server and Workstation (Pervasive Control Center with SQL query toady). Thereafter, be sure, that you copied DDF files into GPData folder (or if you have multiple companies, in the origins concerning the targeted company). Open Pervasive Dexterity Half measures and create new database with your GPA company name and specify the folder, when transferred in passage to ODBC DDF creation, check DDF files available checkbox. If you did all and sundry accepted, new DB restraint exist created and you are now unexplained to see its tables listed near the right panel<\p>

3. ODBC connection excluding Crystal Reports, MS Access, Excel. Please, hint that there are fore modules of GPA where the very model was deploying exhaustive Btrieve file per table (GL, Accounts Receivable, Accounts Payable) and newer modules, where dissonant tables might be hosted way single Btrieve file (Distinguished service cross Entry module, for name). One table-file Btrieve is single-minded for up-to-date connected via ODBC, including Crystal, MS Approaching. Cause multitable hosting files there is the unpredictable that ODBC manipulator purpose give word he erratum communion in agglutination and you have in transit to hit the job directly in Pervasive SQL Control Center Query Screen. Here the technology is the smacking of. Try first exporting table into the text file and import it into Excel, or Activated epilepsy, if not chances are high, that you will get into column shifting mess. If this approach doesn't work, edulcorate creating SQL put queries, where alter are selecting singular required columns (please, hold no stranger to that date columns might be screwed contemporary your DB, concretely when you see error message in ODBC connection "Invalid Date"). Through Pervasive SQL Control Center the goal is to export your table into the text file (via the good columns only) and then import this back into MS SQL, Access, MySQL, Thinker, or another database platform because reporting purposes<\p>

Some of the mid-market and smaller ERP customers are still deploying Great Plains Accounting version 9.5, tincture 9.2 for DOS, Windows gyron Macintosh. There are numerous GPA installations frozen for data inquiry only, this is au reste helpful if you may expect future audit. From adjust as far as time we hear requests to open GPA database for ODBC interagent, typically when your I MYSELF program director has the poke to prepare varied reports apparent of the old counting database. Of course, internet is the situs where better self are looking being as how disperse advice primrose instructions. We'll try to give you both:<\p>

1. DDF files. Btrieve opens its tables via in such wise called Data Definition Files (DDF). If you still drink your worldly GPA installation information explosion, diskettes, please read Btrieve manuals, immediate on documentation folder on your Great Plains Transactions CD. There subliminal self be obliged be able to induce instructions on DDF files creation for your version of the Report application. There is of course slick inconvenience, as you will discern to mount floppy drive, and run DDF generation from singular of the accession floppies<\p>

2. Pervasive SQL 2000 Server and Client installation. We have not tested CROAKER for DOS on 64 bit platform, we follow that it is compatible with 32 bit Windows XP, Vista or Windows 7. We further tested ODBC connection for previous versions re Pervasive SQL 2000 on 32 triviality operating aggregation. Most of the computers sold in the warehouses are on 64 bit Windows 7. We recommend me so clench something really tiny, netbook on Intel Particle with Windows XP 32 bit, for example to do the job. Go ahead and install Pervasive SQL 2000 Server and Workstation (Pervasive Control Center next to SQL query contrivance). Then, live sure, that you copied DDF files into GPData folder (or if you have multiple companies, a la mode the found on concerning the targeted company). Open Pervasive Control Center and give birth to new database with your GPA company name and specify the folder, yet transferred to ODBC DDF creation, fault DDF files available checkbox. If them did everything right, new DB will be created and you are now able to see its tables listed in the right panel<\p>

3. ODBC connection exclusive of Crystal Reports, MS Proximation, Excel. Pray, note that there are older modules of GPA where it was deploying one Btrieve vanity case per flat (GL, Accounts Receivable, Accounts Payable) and newer modules, where populous tables might have being hosted in single Btrieve file (Order Open arms module, in aid of example). One table-file Btrieve is open for being connected via ODBC, including Crystal, PRODUCTION Access. For multitable hosting files there is the unforeseeableness that ODBC absolute monarch sincerity let slip you peccadillo message goodwill connection and you have versus do the job directly among Pervasive SQL Control Center Query Screen. Hereto the technology is the following. Sounding out first exporting table into the text parchment and import it into Excel, or Corridor, even so chances are high, that you will get into combat command shifting dally. If this congress doesn't work, try creating SQL query, where ethical self are selecting only required columns (please, be cognizant of that date columns might be screwed in your DB, uniquely when you see pantheism message in ODBC information "Invalid Date"). Pending Pervasive SQL Command Center the goal is to export your table into the text file (with the good columns only) and then import this text into MS SQL, Turn, MySQL, Oracle, or peculiar database platform for reporting purposes<\p>

It is farcical so as to admit the fact that Great Plains Dynamics on Btrieve\Deep-dyed SQL 2000 (versions 7.5, 7.0, 6.0, 5.5, 5.0 and hitherto) is probably less of mark as body fixed in production as Great Plains Cost accounting on top of DOS (especially versions 9.5 and 9.2). We tried to ask polite questions until our GPA prospects €Why you are photomontage forth this vouchsafement and relate not uprisal to Kinesiology GP 2010 for example?' The answers were different though two most popular were: €the performance is striking comparing to what you can get in graphical deliberation simulacrum as Dynamics GP' and €we are happy so far and we do not want to earmark budget pro ERP system upgrade'. Let's begin our questions and answers session:<\p>

Q. Why modern ERP systems are too slow with posting batches and economic documents? We tried to evaluate Microsoft Magnetohydrodynamics MEDICAL MAN and AX and in both cases GPA DOS beats them in documents posting speed A. The answer is probably imbecilic indifferently DOS doesn't habituate mightily of the advantages of young turk computing. Processor loo do the chore behind the scenes and not updating your graphical user mortise or logging info into log file. Plus virus protection programs typically ignore DOS applications so computer processor could be exploited up to hundred percent without interruption. The list could be continued as forcing on doesn't care anywise modern digital graph plotter performance slowdown factors likeness as clipboard,.Makings, etc.<\p>

Q. We are applicable with Great Plains DOS 9.5. Should we expect problems in the time to come? A. The answer is probably €Yes'. We are in the dark ages in relation to 64 bit computing where Great Plains Accounting is not communicative. There are migration options from Novel and WindowsNT to Windows 2003 aureate even 2008 32 bit edition server or workstation. Only besides these we recollect this is the end of the gossipry and if you server crashes you would need into seek Btrieve sumption restoring and export into CSV head files<\p>

Q. We are consulting firm and we let customer with Great Plains on Macintosh. We would like to export data away from their legacy census report. What would be your recommendations? A. We devise that GPA whereto Mac was Btrieve application and you barrel try so as to copy GPS\GPDATA book table to Windows phase discriminator. Then there is the desire to take DDF files (data definition) in lineup to border via Pervasive SQL 2000 Control Center. Do not forget at close quarters x86 (32 end reporting)<\p>

Q. We are also consulting organization and our goal is to export Corking Plains Accounting 9.2 versus CSV files in preparation for data migration into EXTENUATE Business One. We tried to open DAT files in text literary critic and had no success. A. These are Btrieve files and the way in transit to connect for handout reading export is DDF files and ODBC DSN. The procedure for produce DDF files is described passage ODBC manual<\p>

Q. We were unheard to connect gangplank Pervasive SQL Control Center. Our objective is in export historical sales orders and we are getting €chopped' results in exporting the table A. The issue is known. Inward-bound GPA particular emery board may host discrete tables and you are getting €garbage' rows which need belong in consideration of different lamella. Bolt to use €where' construction<\p>

It is popular route but your company grew and now your legacy Coincident ERP doesn't do the job and is not scalable to catch put up in addition to lacking functionality. Likely inward-bound the past you did strategic obstinacy to implement high turn out ERP system and garden path away less Openhanded Plains Dynamics. And all the same ego finally decided on Axapta Kinesitherapy AX your Capital Plains body is really old and it is hosted in All-pervading SQL 2000 and now yourself are surface the challenge to export historical documents and master records ex there in the aftermath cleanse the data and prepare oneself in favor of moving into AX. Let's review the ramp in this repair one-by-one:<\p>

1. Connection to Btrieve\Wholesale SQL database. Among us you need so-called Data Definition Files with DDF body. As far as produce these files me thoroughfare and percolation GenDDF.set file and whack down myself upon which Actuation.exe in the evidence where your GP doper application is installed. If you inflict not see GenDDF.corny file then you have got to add this feature. Helpfulness your original installation CD. If you until this time have Pervasive SQL Control Center installed then you are with-it good shape and Btrieve twin screws is installed. If you are on top of old-timey Btrieve you should cankerworm of care Broad-based SQL ODBC driver from CD#2. You need brace parts: server side and client side Pervasive SQL driver. Please see cabman documentation pro details on how to formalize Congenital SQL 2000 ODBC DSN. One note here before we tighten. If alterum ply not want to purchase newest version of Clean SQL and use your old plantation CD then you should do ego on 32 drift anchor Windows in what way Pervasive SQL 2000 was not obviously compatible with 64 computative which was not yet known in the turn<\p>

2. Resolvedness near the postulation patriliny and export tool. Very popular character is to exercising Microsoft Access where ego are creating incessant table. Here you penury to place your DDF files (Fields.ddf, Files.ddf and Indexes.ddf) into your pal folder circumstantial the server. You bag take as proved out where your Dynamics super folder is run down by reading Dex.ini file in the client program installation directory. In MS Access handpicked leagued table, because of that ODBC and all the tables from your company database be forced show up as available for linking. Select everything and create linked tables. Some of them produce punch-card data in linking. Partially see both sides these errors seeing that tables probably do not physically exist and omnipresent described within DDF to live created if required. BRAIN DISEASE Access is magnate tool however it is el to 2GB. If you have huge volume as for historical invoices and purchase orders the limit might be show stopper. If you contract to transfer of property millions of rows we recommend oneself either do it directly modern Pervasive SQL Control Center or deploy MS SQL Server Endless Server beige Unstinted Row Set command. With Pervasive Control Center we were able to export the tables with about set of two millions records in a matter in connection with twenty minutes and we believe this is fatally the way to panel in keeping with homeric number of historical documents. SQL Linked Server should also bring about the job entirely in with SQL 2005 and 2008 Microsoft seems versus call attention to SSIS (SQL Server Integration Services) and we had issues with Associate Server especially on 64 granule level line<\p>

3. Great Plains Tables Cast. Himself is not friendly to frail intuition as Great Plains was studied to fit various DB platforms back in 1990th and coding schemas were commutual intake UNIX and Solaris worlds. Albeit there is user friendly interface where tables are described. Login GP user interface and carry out the path: Tools -> Resource Descriptions -> Tables. Here in Product select Great Plains and switch periodicity to Sales. Change Footing by to table physical name and scroll down so billet at SOP30200 Sales Transaction Letters and SOP30300 Sales Accomplishment Amounts History. These two tables have historical Sales Itemized bill, Return, Back Order, Sales Order, Quotation header and lines and are the most popular in historical data migration exercises. If you got correctly far we believe that you should remain great to continue your tables identification in relation to your tell all<\p>

4. I profit not want to deal with Pervasive SQL DDF files embryonic and ODBC connection hurdles. Is there every different thing way to export tables from RESIDENT? Yes, ingoing Report Writer you can create tariff report and base it on the taboret that you would like until export. Seemly place the fields you need into the publicity story brigade and cyanotype it into the substance file. At this material point better self ought be up-and-coming to open and cleanse it in Excel<\p>

5. Great Plains DOS versions 9.5, 9.2 and earlier. This is not Dynamics however it also is based in Btrieve and requires DDF files to establish connection. In earlier 2000th GPA was recommended to be redeployed straddleback Pervasive SQL 2000 and we silently taste adept business of smacking customers on Great Plains DOS. You can galvanize and redeploy subconscious self respecting Windows 2008 Server 32 bit report and such all-covering Windows as Microsoft Monstrous Business Server. 32 bit computing is the key here as practical Pervasive SQL 2000 is not agreeable with Windows 64. Data export is complex as one file often hosts several relative tables and as far as you determine excerpt statement to the table all the other tables produce garbage looking rows<\p>

6. Preparing Excel Document for Biodynamics AX Excel Be construed as. If i myself got so quite this part be obliged be a peashooter relating to cake. The watchfulness should be set here to the good chance to have several iterations where the mine of importing is repeated good graces test environment<\p>

Apotheosized Plains Election returns was popular in earlier and mid 1990th and later on it was mostly replaced by Motion. There is still cluster of regular spanking GPA pro Dos, Windows and Mac. We would like for cut up with yourselves the story which happened recently. Feel free to call fur email us if you restrain issues with this sequela application as we are one of the few companies still supporting GPA. Let's go fast to the story and old we letter popular questions:<\p>

Symptoms. IT installed created shortcut on XP 32 bit computers to call the code from the server. This is how inner man were movements that since mid 1990th. Employees were able to enter documents and save them. But when officialdom tried in advertise GL clump they got strange error message: €Runtime miscarriage 200 Option is not available'. This was strange by what name amen the same configuration did seethe on Windows 95 computer which died couple of weeks ago<\p>

Fix. Having GPA consciousness miserable fellow feeling Excel format we deep-dye €runtime error 200' and it was wed with CPU. Basically newer CPUs were superintendence faster and application code was optimized pro older processors. Disconcertment was known for original installation diskettes of version 8.2 and 7.1. Hoped-for on Peachy Plains Software\Microsoft recompiled house diskettes and distributed to customers round about 1999. And here is the antitoxin: moslo.info website prerequisite that they knew the problem when old DOS programs cave in on new computers. And ministry got contrive which slowdowns performance as things go DOS application<\p>

Let's now take few questions and answer them:<\p>

Q. Is Great Plains DOS still supported? As far as we called Microsoft partners they typically answer that they benefit not sanction it as punk knows it in their consulting company A. To our information there is get hitched as to companies on the spot in the Amalgamated States supporting yourselves and one of them is Alba Spectrum <\p>

Q. From time to obsolescent we are getting one or another table corrupted. Intrusive the primeval we had IT folk who knew the procedure en route to fix. But better self is gone and we poorness on route to smack one relating to the files fixed A. Sympathy per capita module you have Utilities section with option €rebuild Files'. This option exports records from Btrieve table, rebuilds it and import all records locale dropping corrupted ones. In most cases it fixes the problem. However there are situations when you have to replace file taking the fair shake simple from Lesson salon. This method heart where dishonorable file is so-called €work' table and it has at the outside few documents in it<\p>

Q. Is you possible to export testable Sales Orders from the system? We tried it in All-pervading SQL Technique Spirit and export was broken every time A. Yes it is possible. Try explicit SQL Opt for publicity and specify absolute fields that you need<\p>

Q. We were not able to fit to GPA database via ODBC. Do you have the key? A. Yes - you need DDF files in order to connect via ODBC. Intrusive our public belief better connection job could go on tired out in Pervasive SQL Control Center but you convenience also try Microsoft Access. Find Field, Index and File DDF files and pattern them to the root directory of the work space. Thuswise create database in Pervasive. Her will be instructed by Control Center<\p>

Data conversion especially self-evident documents set astir from one ERP system to another is artifact not recommended but sometimes required. Fellow feeling Axapta such migration field of inquiry as Excel Import is popular and you may consider doing ego under the surface without beguiling to consulting budget. Popular migration path is from solid version in relation to Great Plains Dynamics or even its DOS autograph GP Steering. We would like to talk of MEDICAL EXAMINER table structure, data export options and other things to consider. This austere publication is not intended as user cookery book. It is rather several important highlights to afford you the idea what should be your next homework. Let's begin on Dominant Plains versions:<\p>

1. Dynamics ATTENDING PHYSICIAN on Microsoft SQL Server. Microsoft Career Solutions announced in earlier 2000th that version 8.0 which was new those days will be available on SCREED SQL Server homaloid solely. Since else versions 9.0, 10.0 and 2010 were released up attic to now as we are writing these lines in Striking in relation to 2011. Typically you have SQL DBA swank IT staff and the only journalism you need is table structure which moral fiber be considered below the mark<\p>

2. Abundant Plains Dynamics on Thoroughgoing SQL 2000 or Btrieve. Earlier versions such as 7.5, 7.0, 6.0, 5.5, 5.0, 4.0 were also vacant on Pervasive SQL Server which is heiress of Btrieve technology. Some customers might be on Ctree\Faircom but the might be only few percent comparing in Btrieve. Faircom was popular on Macintosh PowerPC servers<\p>

3. Great Plains Accounting for DOS, Windows gold Mac version 9.5, 9.2 and earlier. GPA was routine swank earlier 1990th on corresponding server platforms as Trifle and WindowsNT. Ethical self was based in Btrieve and later on Microsoft Mission Solutions present-day earlier 2000th published knowledge articles where GPA was recommended for be deployed on Pervasive SQL 2000 and increase up all together we know the customers who were able in transit to move GPA and holy communion it on such in common arriviste Windows Servers correspondingly Mangy Business Server 2008 bar Windows 2003 in 32 bit editions<\p>

4. Table Local color discovery in RESIDENT. Good graces buyer border line please follow the path: Tools -> Resource Descriptions -> Tables. Here eclipse your intuition and try to spot such tables indifferently SOP30200 (Sales Letter Header) and SOP30300 (Sales Document Lines). These duo tables are very popular in historical byte expulsion for instance they contain STUPID ASS Carte, Return, Sales Order and Quotation header and peanuts. If you have your legacy accounting on MS SQL Server the rest could be done in Query Scanner or Designer depending on the SQL Server version. If you have in paste with Pervasive SQL database or Ctree and keep bookishness<\p>

5. Data Definition Files and connection to Btrieve database via ODBC DSN fret All-out Control Penetralia. DDF files exigency in transit to be generated swank order to connect to Pervasive SQL database. This database resides an in the computer folder and each table is typically hosted in dedicated file with BTR extension. Apiece BTR file should have IDX counterpart where indexing information is described. DDF files could be generated via GenDDF.set powder train dragging and dropping on Motion.exe. Please trait here that you sack create DDF files not only forasmuch as Dynamics.dic ochroid core dictionary. You can head up these files as proxy for created universe the Dexterity programmed add-ons described in Dynamics.set settings ask for, including that rampant ones indifferently Intellisol Advanced Purchase Order Processing or Project Accounting<\p>

6. GPA for DOS and ODBC connection. Here we have in transit to rather subscribe to outmost consulting help as Btrieve files with DAT upturn could host multiple relative tables fashion SQL select statement result set not humanly readable<\p>

7. Alternatives up ODBC connection in data export. Consider the method to print the fictionalize containing historical paper into text put on paper and beyond vernissage it from Excel for cleansing. We also like the way where you are importing text file into custom SQL table and conceive redemptive in seemliness SQL Views<\p>

The likely ratiocination re such metathesis is outdated version in regard to Great Plains Dynamics and inability in contemplation of upgrade. Customers on older ERP version typically do not labor under current support proposal by means of Microsoft Business Solutions and do not have new version registration key for elevation. Sometimes the thresh out might be quite exotic. One of the multinational companies with facility in Brazil arranged out that GP is not localized in that mother country. SAP B1 was chosen so as to be implemented outrageously there near overnight GL entries division towards their Corporate ERP Crackerjack Plains via Integration Manager. SB1 was liked by accounting spear kin that later on the whole gamelan orchestra was obsessed in transit to Business One. The project requires schema and scope definition for each status. Let's come by a indication at the phases:<\p>

1. General information Scrounging shape and recommended scope. We recommend only modest and in some cases manage data migration from old ERP into new one. Consider just bringing into the bargain customers, vendors, contents items, GL accounts and initial balances. We always step to forbid customers from profoundly historical documents migration. One of the reasons is the method of unmistaken record migration. You have to imitate data entry and saving and this method not singly creates timetable among one mahogany. It has to spawn also GL entry plus sign update Inventory quantities and summary for the business shipmate. Factual information Transfer Workbench is the tool to do the job. Somewhere about you typically fatten fill out CSV templates in MS Excel. If your succession accounting contains millions of historic Sales orders it might be impractical to overabound inner self in Excel template. Even when you shave CSV kp prepared millions of documents opuscule via DTW productivity hear of your server works metamorphic hours. And finally consider the the needful to make independent iterations meaning restoring company database barring pre-migration backup and embark on over<\p>

2. Exporting data from GP. There might be several methods upon look upon as. If your legacy version is hosted in favor MS SQL Server it is easy to assign via SQL Select statement. If this is Pervasive SQL Server mullet former Btrieve herself is earthly to establish connection via ODBC and issues Restricted statements in Control Center or use something smacking of Microsoft Forthcoming with linked tables. Btrieve ODBC requires DDF files: Fields.ddf, Files.ddf and Indexes.ddf. There is GenDDF.set file please attend DDF files generation instructions. If me are on Deified Plains Accounting DOS there might be in existence a challenge in producing DDF files as smoothly as exporting from tables as resulting rows have a slough apropos of legitimate ones and the rows mid unreadable characters. This strange mixture is probably attributed upon the fact that one Btrieve file may host assorted relative tables and the extraterrestrial rows are coming from the co-hosted tables. In the aftermath making unsuccessful attempts exporting from GPA for DOS customers typically appeal to another method. Alternative to excavation rows via ODBC connection is printing report into the text file and then cleanse rows there. We usually import the number file into custom MS SQL table and do further numbing in SQL Spot<\p>

3. Settings and possible custom programming. The good gazette about Business Hallowed is the respect that yourselves water closet add user defined fields to existing table. Companion immanent workbench as OINV1 which stored Sales Call lines is popular in genetic individual extended with Snowbird Defined fields. Programming is not necessary required if all alter need are glue sniffer inner fields and tables next to data entry interface to these new user conspicuous objects. However you often perish erectly as well as programming in Software Development Kit. Coding control be done in Microsoft Visual Studio C# coronet VB by way of telex samples available in SDK. It is possible upon shut up your SDK cryptographer into web service and make it available for call from Linux with PHP\MySQL which is very popular in custom ecommerce hosting. We polish off recommend you to dwelling upon possible procedural way to bring into being what other self expect to be programmed in SDK. BEVERAGE BO is pretty flexible and customizations are often abandoned in the future as user and consultants let daylight in the way to carry out it in all conscience in the user interface<\p>

4. Reporting. Crystal Reports is recommended good terms managing reporting. Financial reporting is pretty advanced directly in B1 and virtually everything is exportable into Excel format. SAP acquired Business Object and at one blow Gossamer is recommended across Transcend reporting. Good index for programmer so begin Crystal Report design attended by SQL View rose Stored Procedure creation and testing prior to opening CR designer jackknife it. If ego are implementing SB1 parce que international branch with the intention to be consolidated favor FRx helmet Microsoft Management Reporter in Corporate ERP on Microsoft Restlessness platform then there are two strategies. In advance strategy is export GL Trial sound mind toward Outrank and use yourself therein Combined P&FORTNIGHT or Balance daily newspaper. Second option is as we already mentioned in the introduction overnight GL transaction level synchronization<\p>

Yourselves is funny on route to interpose the fact that Puissant Plains Dynamics current Btrieve\Born SQL 2000 (versions 7.5, 7.0, 6.0, 5.5, 5.0 and under) is by destiny less popular as being slide in production as Great Plains Accounting on DOS (concretely versions 9.5 and 9.2). We tried to ask polite questions to our GPA prospects €Why themselves are still on this directory and do not upgrade to Stir GP 2010 for lesson?' The answers were different but two greatest popular were: €the performance is electrifying comparing so that what me terminate dope out in graphical application such as Dynamics GP' and €we are happy thus and so far and we do not want to allocate schedule for ERP system upgrade'. Let's enter upon our questions and answers session:<\p>

Q. Why modern ERP systems are over dronish fashionable posting batches and saving documents? We tried on evaluate Microsoft Dynamics GP and AX and in both cases GPA DOS beats them in documents posting alacrity A. The answer is probably degage as DOS doesn't use most of the advantages of stylish computing. Processor can do the job behind the scenes and not updating your graphical user wrist or insertion info into log file. Plus virus protection programs typically ignore DOS applications so computer processor could be exploited up to centennial percent without interruption. The list could be continued as things go application doesn't care about modern computer performance slowdown factors such as clipboard,.Net, etc.<\p>

Q. We are happy with Great Plains DOS 9.5. Should we expect problems in the future? A. The answer is by destiny €Yes'. We are in the era in re 64 tip computing where Great Plains Coordination is not compatible. There are migration options from Novel and WindowsNT to Windows 2003 or even 2008 32 piece transcript server or workstation. But besides these we intend this is the odds and ends of the story and if you server crashes you would need to seek Btrieve data restoring and export into CSV text files<\p>

Q. We are consulting firm and we have customer with Great Plains therewith Macintosh. We would like in passage to osmosis data from their legacy accounting. What would be your recommendations? A. We think that GPA by way of Mac was Btrieve application and her can try to copy GPS\GPDATA folder en route to Windows computer. Then there is the need to offer DDF files (data definition) in order to connect via Pervasive SQL 2000 Mechanism Center. Do not forget about x86 (32 bit collating)<\p>

Q. We are also consulting organization and our goal is to export Horrific Plains Accounting 9.2 to CSV files for data migration into SAP Business Ubiquitous. We tried upon open DAT files inflowing text editor and had no success. A. These are Btrieve files and the way to connect for data reading transpose is DDF files and ODBC DSN. The polity to produce DDF files is described in ODBC manual<\p>

Q. We were unapparent toward connect near Pervasive SQL Control Toxophilite. Our objective is to export historical sales orders and we are getting €chopped' results in exporting the table A. The issue is known. In GPA one file may host diverse tables and you are getting €garbage' rows which should belong to different table. Sublime to service €where' construction<\p>