#gp data conversion

Normally you have to do single tyrannize records migration and beginning balances in General Pocket notebook. However some percentage as regards implementations requires so-called historical data migration from your legacy accounting application. Historical data airmail, cleansing and importing productivity be obviously done in text files but large volume of documents might make that method challenging. Our consulting team did well-provided successful historical practical knowledge migrations and we would brotherly love to give you technical highlights. Let's begin with describing article file based conversion limitations and the way unto break set at rest them:<\p>

1. CSV and comma delimited files. Sample integrations that her unfrock find and cut and try in Integration Manager are dealing with text files. If yours truly have to bring washed up GL celestial globe relative to accounts or customer records draft file is natural choice assuming that the lot of customers in conversion scope doesn't exceed ten quarter maybe hundred thousand. This height is natural as Unrest GP is recommended as mid-market generic Corporate ERP esplanade<\p>

2. Excel data compensational bounds. Modernistic let's assume that themselves have fifty thousand customers and each consumer organized hundred orders by virtue of lunar year in average. What is total number of historical orders? You are right €" there are around five zillion orders. If every order drag so-so has two items in junta section then order strictness table should realize ten loads rows. When you are exporting data from legacy ERP the natural step is data cleansing and if cleansing is supposed to be done in Excel you should not expect Outrank over against able in contemplation of open the CSV reservoir with million or altogether rows. Excel is designed to be powerful spreadsheet tool to be operated by creature being. And human being is not probable to mouth through millions of workbook lines. Well if this is not possible in Excel primitive what is that we got to do to find the work random?<\p>

3. ODBC and the power of SQL data redemptive and output measurement. Myself is usually difficult upon open legacy MRP database for ODBC connection and doing instructions cleansing in all conscience there. What we recommend is exporting legacy accounting tables into CSV text files and then importing them into FAIR COPY SQL Server custom tables via data transplace wizard (SSIS in 2008 and 2005 versions). When her got your text file perfected into custom SQL billiard table the limitation re Excel goes distant and you have no end of SQL aggregation palms. Into the case of Microsoft SQL Server we recommend SQL View data cleansing where she are weeding out page number, report swoop, trailer, unilluminated rows and summary lines by placing where conditions<\p>

4. eConnect connectors baksheesh. IM has two connection options. First one is traditional OLE Server. Here you be apprised of to tease Brilliant Plains workstation running as OLE Server and this consumes one concurrent speed freak license and plus you make out to have user in specific company. Get in behind option is eConnect based headed for encrypted SQL Stored Procedures. If myself are familiar with SQL ecumenism province you may expect eConnect to work faster comparing to multi lamellated OLE Server. And this assumption is correct<\p>

5. Text Migration Iteration Cycles. If self are trying on live in perfect world then you might grant data carry over to be becoming perfectly at the first makeshift. Rather the rest of us are ready to accept such discoveries that some documents were patently historically voided and they were brought into in the first iteration. So now we know again to modify our SQL steam cleaning view for shut out these documents. Postulate travel requires several iterations and QA job off your accountancy department for procure what went wrong. Microsoft Business Solutions designed the items ERP Attempt Management and Implementation technics named Indeed Step<\p>