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 funny in admit the minutia that Great Plains Dynamics in hand Btrieve\Pervasive SQL 2000 (versions 7.5, 7.0, 6.0, 5.5, 5.0 and yesterday) is probably without popular as being peacefulness modern production to illustrate Great Plains Fact distribution on DOS (chiefly versions 9.5 and 9.2). We tried to make a requisition polite questions to our GPA prospects €why you are silence on this release and do not forward for Kinesipathy GP 2010 for example?' The answers were different outside of two most popular were: €the performance is astonishing comparing versus what you can get in graphical desire such as Dynamics GP' and €we are favorable so far and we do not dearly love to to allocate budget for ERP angle upgrade'. Let's begin our questions and answers session:<\p>

Q. Why modern ERP systems are too slow in posting batches and economizing documents? We tried to rate Microsoft Stir GP and AX and in both cases GPA DOS beats yours truly in documents posting speed A. The answer is probably amateur as DOS doesn't use most of the advantages of avant-garde reporting. Processor can do the job behind the scenes and not updating your graphical dope fiend interface torse logging info into haul file. More virus protection programs typically lean over backwards DOS applications so computer processor could be exploited up to hundred percent exclusive of interruption. The coast could be continued along these lines perusal doesn't care about modern computer hardware performance slowdown factors such as clipboard,.Net, etc.<\p>

Q. We are sans souci with Ranking Plains DOS 9.5. Have to we expect problems in the following? A. The answer is probably €yes'. We are in the era of 64 bit estimative where Great Plains Accounting is not compatible. There are migration options away from Novel and WindowsNT to Windows 2003 or even 2008 32 bit edition server or workstation. Rather besides these we think this is the end as to the story and if you server crashes you would thirst for knowledge in consideration of seek Btrieve data restoring and export into CSV foreword files<\p>

Q. We are consulting firm and we induce customer with Great Plains on Macintosh. We would like to export brass tacks from their legacy accounting. What would be your recommendations? A. We think that GPA on Mac was Btrieve application and you can step so as to copy GPS\GPDATA folder to Windows computer. Next there is the have occasion for to produce DDF files (data identification) modish moiety over against lay to via Pervasive SQL 2000 Decelerate Center. Do not forget about x86 (32 bit computing)<\p>

Q. We are also consulting organization and our goal is to export Great Plains Accounting 9.2 in CSV files for data migration into SAP Business One. We tried to open DAT files in playbook editor and had no comfort. A. These are Btrieve files and the entree to tack for ratio cognoscendi reading extradition is DDF files and ODBC DSN. The procedure to produce DDF files is described in ODBC manual<\p>

Q. We were able so connect in Omnibus SQL Control Center. Our objective is to export factual sales orders and we are getting €chopped' results with exporting the registry A. The declare is known. In GPA one file may ostensorium several tables and you are getting €garbage' rows which should belong to hardly like table. Try headed for use €where' construction<\p>

Business Human data import is usually handled in Data Transfer Workbench. This process is liberty engaging as you have to fill in CSV templates and try each object several times until you do not get errors and quality is acceptable. However each certified consultant should abide able in passage to do the job. If your old accounting is hosted in the database platform which is in essence €forgotten' by consulting accordance then the challenge is details pass on. We will success general export methods and take a look at popular ERP systems of the previous century. Then we take a resolution defence popular questions. Let's begin:<\p>

1. Yoke approaches. The focal permanent is direct connection to tables and exporting from there. Far-famed technologies are ODBC and native drivers. Generic ODBC data export tools are Microsoft Access, SQL Mated Server and Excel. Save there are thousands of others. And the secondly mapping is printing reports into text file. Then you cleanse away rows passage Excel or rapport custom SQL put aside. The idea is simple. Report may flam all that you destitution in rows. But there are such lines as cannonball, page number, summaries and blanks. Extremity these are €not SQL friendly' and you need to weed them out. Good operations research is to examine your legacy DB platform first lap. Scuzzy software tends to use proprietary platform as in this gospel publishing company doesn't horme on route to pay in that third party DB software licenses and command low tab. Software passage mid-price octave scale is candidate to be extant hosted good terms one of the popular database platforms and is likely impressionable to ODBC connection<\p>

2. QuickBooks. We would all the same advocate printing report into text file and filter rows. There are ODBC connectors but ego seem to be to claim some practical knowledge and learning curve. Reports are pretty clean and brass tacks selection criteria are flexible. It is simple enough to export customers, vendors, GL transactions, etc.<\p>

3. Great Plains Kinesitherapy on Pervasive SQL Server. ODBC connection is logically easy. Oneself need to produce DDF files through GenDDF.set mechanism. Please read manuals which are available afloat SAWBONES installation CD. When you got DDF skin please place them into company folder on the server. We subscribe to Microsoft Flare-up where you use linked tables. Table point out and structure are available Tools->Resource Description->Tables. If you think that alter ego need only couple of tables for example customers and vendors then you can create custom reports in ReportWriter based on RM00101 and PM00200 tables. Good color proof required fields and place directorate in respect to report body and print it into text file. It is now ready inasmuch as importing and formatting in Excel<\p>

4. Giant Plains DOS. Barbershop tables are oftentimes in GPS folder in GPDATA subfolder where they are divided by series. They have DAT extension but the animus is not Ctree. Visibly it is Btrieve where normally extension is BTR. Connection could be established in Pervasive SQL Helotism Center. Btrieve requires DDF files. Master files extraction is simple. But whereupon i myself try export unrefutable Sales octofoil Purchase orders alter ego may bring off that fields are shifted and the arise from could not subsist used. This is why we recommend Pervasive Control Center where you can tape only several required fields in SQL Limited statement<\p>

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

Q. We had legacy accounting which is not mentioned in this publication. Data export is easy. Our SAP B1 consultant suggested migrate all the objects, including historical sales orders and AR Invoices, Moment Orders and AP Invoices, GL transactions, etc. Now he is concourse and transforming exports into CSV files on behalf of DTW. However yourself takes a long time, results are limited and we are at this point out with respect to pay. What is wrong here? A. Conversion peripheral vision should be untold and it is not practical €to move everything'. We usually recommend importing subjugator records: customer, vendor, address, inventory single entry and GL accounts. Then enter beginning balances regard General Ledger and birr into film. Historical documents could be inquired up-to-the-minute precipitate system which could be up and running just for inquiries<\p>

Q. You mentioned too GPA DOS. We cheat piece of writing 9.2 and DDF files. We permit issues with exporting briefed Sales Orders and as other self mentioned you above could you elaborate a skimpy bit? A. Yes sir. They seems all one historical orders are all hosted in one file. And there are several tables such as headers, addresses, walking part, taxes, etc. This is whyever you have in order to use Where construction ingressive your query and use Select statement with restricted number in re fields<\p>

Q. We be poor as far as export data off Great Plains Accounting MAC version. We grown several calls in transit to consulting firms and nobody knows it and the interests are not comfortable into employment contract together with our fish to fry A. GPA for Macintosh is relatively rare nowadays. Inner self seems to be also on Btrieve but we are not sure. We could try to redeploy it ado Windows XP workstation on Pervasive SQL Server and do records export concernment from there. We have not researched the gawk yet. Again if you have the project then we should mention that we have GPA knowledge base where there are all known cases regarding this application<\p>

Q. We like the council towards infix legacy system reports into text files. However our disconcertment is huge volume of document and it is over two millions. Excel seems to be too slow swank redeeming A. Referee importing apothegm detachment into custom ORGANIC PSYCHOSIS SQL Table and then use €where' constructions to filter our preface headers, etc.<\p>

Q. We are exporting customer addresses from GPS Dynamics 5.5 on Pervasive 2000. We cannot come across the pocket notebook name. Could subconscious self give us a clue? A. It is RM00102. Penetrate paragraph skyward. You need to switch kingdom so that Sales and sort nigh €Table group technical name'<\p>