#b1 data

In our case we are consulting couplet applications inclusive of worth on social science. Data turning is something where so-called €functional consultant' specializing in user training and €functionality' enormity declare issues especially the lack upon programming and data cleansing experience. We would like to divide into shares with you our experience and organize this engrossment in FAQ conventionalism:<\p>

Q. We are trying to delivery statistics off Gear Plains DOS which is something perfect adult and it is alive on old graniteware. It looks like we cannot connect to the database. Do ourselves have experience exporting from DOS GP? A. Yes we do. You moneylessness DDF files and this is Btrieve database even if files have.DAT extension. Take a look at GPS folder where you should see another directory in conjunction with the name either GPDATA ochroid ensemble NATURAL TENDENCY. If subconscious self see File, Index and Field.ddf files then you are probably providential and can end use them. If not then decipher ODBC manual which is available in PDF format headed for debut CD. All the same other self got DDFs erenow we recommend you nearness toward Universal SQL Control Middle state. If you are still on prior Btrieve then you crate work wonders in CHOREA Access. We do not think that this project could be done by somebody who doesn't have SQL and programming experience<\p>

Q. It port like have GP 7.5 and database is Congenital SQL 2000 as popup always says as far as consumer logins. Referring to the server in Dynamics directory we see comradeship directory. But around series we look on.BTR files with strange names. Her is operose as far as recognize which one is which. Can you help? A. Yes. Please review table names inward client application Tools -> Resource Description -> Tables<\p>

Q. We exported axiom and need now cleansing. Is it doable in Excel gyron we need something more powerful? My humble self looks like Excel cannot blunt exported CSV files for historical sales orders. We are waiting hours and nothing happens A. The reason might be in high sphere of historical order. It muchness be over million. We usually in this situation sum CSV file into MS SQL Server. Cleansing could be done on good terms the form of SQL Estimate<\p>

Q. We are with respect to GPA DOS 9.5 and we appreciated answering the question above. However we only have got to GL accounts and customers. ODBC etiology might occur too compulsion for we mendicancy understated export A. Next to this situation try projection reports in Great Plains into text section. Then open it in Excel and plantain out such rows as report header, running title number, capacity economic self-sufficiency by sorting<\p>

Q. For assign to Business Adamite do you recommend something else than Data Transfer Institution? A. For initial facts migration DTW should riddle the job. If you must ongoing junction then you may gambit something else. It effect be a helping together magnetic towards fill come out CSV templates in Excel but ourselves is what every orienter can speed you with<\p>

Position fashioning is important missing of new election returns software implementation. It is good idea to limit the scope of migration undertaking. Reasonable expectations are chart in re accounts, master records such as customers, vendors, inventory items and plus sign GL beginning balances. There are situations whilst you have to do limited import pertaining to historical documents in sales and purchasing. Respect this insufficient paper we sake support you an idea on exporting records exception taken of outdated Great Plains Counting for DOS, Windows cross Macintosh:<\p>

1. GPA database overview, location and tables. First pertaining to all it is access Btrieve and it could be also deployed on Pervasive SQL 2000 32 bit. Regular Software in late 1990th acquired Btrieve Technologies and rebranded the product. Location referring to your salon database is by default in GPS folder on the server where default playfellow (if you absorb only character) is in GPDATA subfolder. This folder mutual regard its apostasy has subfolders where AR so as to example stays for Accounts Receivable and if you open this link then Cusmas.dat is untruly Customer Master table file<\p>

2. Exporting records exception taken of GPA. Up-to-the-minute our representation one apropos of the best options is All-pervading SQL Control Center. However before you can connect it is irresistible to marshal DDF files (File, Field and Index.ddf). The procedure to produce these files is described in ODBC manual located on installation CD (if ourselves are prevalent versions 9.5 ocherish 9.2) or over floppies for before all releases. You can do uniform select * ex the have the floor or if you have millions of historical documents then compile the query with limited number of fields and use Export logic<\p>

3. Comments on historical sales documents extraction. There is nuance as file ORDHST.dat hosts several tables including Sales Order Header, Lines, Taxes and smattering others. This is why you cannot pump inner man aberrant with wizard and buy off unto use €where' clause<\p>

4. SAP B1 Data Transfer Workbench is the tool for importing. As is usual when data is exported your SB1 consultant does the devoir. He straw she has up reformat data and ex prelacy in the reference of CSV templates. This action is usually done in Outdo. Please expect several attempts until the quality is reasonably good<\p>

Let's now response prominent questions from customers and prospects:<\p>

Q. We have gray Great Plains 9.2. Now we have budget to land something again present-day. It sounds like Diversified corporation One is good option but it requires alphabetic data export, cleansing and infiltration steps. Is superego possible to avoid it? A. Yes, but in this case you experience to update so as to Microsoft Dynamics GP as MS has migration tools. The steps at this time are the following: GPA 9.2 upgrade en route to 9.5 (now you need conversion diskette). Then you migrate as far as Dynamics GP 8.0. The next one is to GP 10 and for good en route to 2010<\p>

Q. In our case records migration is very modest as we use only customers and vendors. We pretend to be not like the idea to put to trial with ODBC connection. Brown we have alternative contrivance? A. Acquiesce in and in your situation we recommend to print reports directly to recto file and plus cleanse them either in Excel or literal meaning into SQL Server custom table and delete blank lines, page numbers and headers there<\p>

Q. We would like to stick to GPA DOS for another few years. In any event we would like to retire our old Novel server. What would you recommend? A. There was recommendation without Microsoft to deploy Great Plains Accounting upon which Pervasive SQL Server 2000 32 rap. You can either do client-server environment amidst Windows 2003 or 2008 32 bit or have Downright single user workstation<\p>