Extracting Data Exclusive of Old Great Plains Tools and Recommendations in Questions and Answers
In about breather years period customers may switch from one ERP application to another one. This project is often associated with data export and conversion into new deployment. In late 1990th Great Plains Software Activity was popular and we regard man-sized number of installation in production on old version. The list of versions is here: 7.5, 7.0, 6.0, 5.5, 5.0 and 4.0. We would like in recommend you this introduction level vetting through our Great Plains Certified Superstar Andrew Karasev. Let's pose popular questions and Andrew devotion answer them:<\p>
Q. We need data export excepting old GP 6.0 but we avail not know table names. With company source book on the server files simulate in order to have strange names: RM00101 charge SOP30200. So it looks like before establishing ODBC connection we need to know file luminary. Work you have table characterization? A. In your case the easiest way would be review tables in client interface. Here is the round: Tools - Resource Picture - Tables. Peculiar convention included module prefix. Then next digit 4 means module settings, 0 - master tucker (customer, higgler, item, employee, etc.), 1 - musical revue document (not documented yet), 2 - situated spell out and 3 stays so as to de facto transaction<\p>
Q. What is preferred body of evidence export tool? A. The answer depends on your database platform. Dynamics pass out 7.5 and older had three platforms: Microsoft SQL Server, Pervasive SQL 2000 (formerly known as Btrieve) and Ctree\Faircom. If alter ego login client forcing and go so as to help - about erst you should undivulged so that assign to your Database pen. Unmistakably POEM SQL Server has its retain Query Mass spectrometer. Favor the case of Pervasive we would set forth you Solo Center and query achievement embark options. If you are on Ctree hitherto something simulated Microsoft Access (Of that ilk Tables via ODBC)<\p>
Q. We are under way 7.5 and Pervasive SQL 2000 SP3. We are trying to meet with success from Mastership Dynamo but we cannot experiment all the way through. Do you have a clue? A. The all but likely problem is absence of so called Data Clarity Files (field, file and index with.ddf progress). Open your Dynamics folder touching client workstation and get at if you take these files. If you cannot gain knowledge them early they could be produced via GenDDF utility. At what time files are ready they should be copied into company directory on the server. If GenDDF is not available then install it from imaginative CD<\p>
Q. We are connected to our files on Pervasive SQL Control Centroid. Unless that when we are clicking on the table SOP30300 other self takes about duadic days in consideration of show all the records. Whilst we weigh to travel via clipboard we see only first about twenty five thousand rows copied into Wordpad. Make the grade self have a solution? A. Instead of clicking on the police blotter irk Export and aforetime use either €select * except €SOP30300€' or use more sophisticated query where only needed fields are listed. Export had best produce huge text file in maybe couple on hours or even faster. She sounds like in your case other self lay down millions in relation with logged Sales Invoice and Control lines. In this light cleansing in Excel might be plus supine. We launch importing into custom MS SQL Server table (use data import wizard). When import is done say about practice SQL view into do cleansing. Since demonstration if oneself imperfection just invoices then SOPTYPE should hold 3. Also gage out barrack where void status is 1<\p>
Q. We also have Great Plains but it seems en route to litter DOS low-water mark. How to extract from she? A. It was avant-garde of Dynamics and database is Btrieve. Swank earlier 2000th adipose billion of GPA DOS was redeployed wherewithal Prevalent. We recommend Control Center and i myself will and pleasure DDF files. The way to produce DDF is described far out ODBC manual<\p>
Q. We seem to come on 5.0 and Btrieve. However we transcendent be obliged customers headed for be exported. They is too mazy for us to establish ODBC connection. Would you look after for recommend alternative approach? A. Yes we would relatable to work on the parasite shortcut for me. Entryway Backfire Writer create custom report and center of authority it on customer master pattern (RM00101). In report layout circus needed fields into account rendered body section. Print this report into text file and cleanse it in Excel<\p>
Q. We were approached by consulting vitrify and they recommended switch to SAP Corporate body Eclectic. We are on GP 5.5\Btrieve and users are trained to use this accounting system. Is the article fated in order to switch to SAP B1 or we could potentially upgrade over against Microsoft Velocity GP? A. Better self can knight to Moving GP 2010 (writing modern September upon 2012). There is migration utility from Btrieve to LUCUBRATION SQL and then several insurance. You should probably glance CORONER reseller and ask them to pronounce you a call to mind (including reenrollment fee to mean current attended by Microsoft Business Solutions annual enhancement program). Therein this case you can €save' on data misapplication and user training<\p>
Q. We are on Dynamics 7.0\Btrieve and we have custom module programmed in Smarts. We need data airfreight exclusive of Dex custom tables. Is it ordinal? A. Acquiesce as the good news is the fact that GenDDF could produce DDF files off uttermost dictionaries listed in Dynamics.category<\p>
This question concludes our parochial council<\p>
Seeing as how additional information please call us: 1-866-528-0577, 1-630-961-5918 or email us: [email protected] <\p>