Hi, all

             I am very new to this concept and the ERP of microsoft. I really do not know where my query fits into, if iam at a wrong place hope you guide me to right place.

                coming on to my query, i have an application which uses MYSQL as its Database. It generates a data which is stored in a table. The requirement now is, i want  to  migrate the Data in this particular table to the Data base of MS GP, may be  i need to create a new table in the GP itself to accommodate this new data. Will i be able to achieve this, if so then how? Do i need to use eConnect to achieve my purpose or are there any other tools which will help me in achieving this task, like some adapters provided by MS GP. I am keen on seeking a suggestion.

Regards
 

Hi, It dpends what you want, you wanted to create a link of transaction to GP mean suppose your application is generating item master and you want that Item master should goes to GP. Please describe exactly what your application is and what you wanted to move to GP.

Becasue there is no sense or relation to move data without any need to GP.

 Hi again,

               First of all thanks for the reply. Let me describe in detail. There is an custom application made using C# .Net and which uses MYSQL as its database and  which generates payroll.

                      The client already has MS GP installed at his side, now he wishes to get just the payroll data which is saved into a table say a Table_Payroll_History in the MYSQL database. I need to migrate this data in the table Table_Payroll_History to the MS GP database. He wishes this, since all the financial aspects of his company is handled by the GP, so he wishes to keep even the Payroll related aspect in GP.                    

                        Now i want to migrate the Payroll Data of the Custom application into GP. I hope i have made my question very clear. If any further doubts prevails i can clear the air Inshallah.

hi, Understand tell me now do you know how to use Import and Export in GP. send me your email if you do not know then I suggest that you wanted to load the data to history tables then no need to write big application. Better use MS GP import data utitlity to import the data to GP. you can map fields to field level by using this.

Hi again,

                   Thanks for the reply and thanks for helping me out. I am very new to this term of MS GP itself and have no understanding of how this GP works. I am unaware of it tools and process totally.

                   I would really appreciate your help. here is my mail id. latifsaqib@gmail.com

                   Thanking you in advance.
 

Hi Alwani, I am waiting for your reply as how to map the data. I searched on the net and i found that Integration manager could help and also econnect but iam still waiting for your wise suggestion of resolving my problem. Hope you reply me. What if i have to migrate data on  a periodic basis, like monthly, since it is a payroll?

For your situation, it is integration manager, how do i send you the integration guide, it is noramlly avaialble with the GP cd. but I am not sure you have bought the license for the integration manager or not. go to Great Plains and click about button so you will know you have license for it or not. 2nd I suggested to use the import utiltiy of GP where you can do this table by table and no need any license for this. tell me how do I send you all these guide.

 Thanks for your suggestions, i really appreciate your reply. Presently i have no idea does the client has a license for Integration Manager or not. To keep myself well acquainted i have already downloaded IM user guide and IM quick starts. After going through your suggestions i have even downloaded the Import Utility help. 

I do understand that sending all these and many more related stuff is not wise on mail. If the client has IM what would you suggest? My brief search regarding my problem makes me aware that i have to use IM and if i want to automate this process since it is periodic i need to use eConnect and do some programming in it, and keeping in mind the two options what you have suggested.

1. If you have a license of IM then go for IM

2. You can use Import Utility.

Am i right? 

Well again IM you can use but to some extend depends what you wanted to load, I perfer for you the import because quite easy, but noteout the IM is not also bad and very usful, lets wait till you will tell me what data you really wanted to move. show me some sample data.

Hi, Alwain Iam here again to disturb you.

                                                              You asked me about the data which wish to export to GP. How should i send you since i do not know your mail id. Right here i will give you some scenario which will make it clear.

As i have said i have an C# .Net application which generates Payroll. Which stores generated Data in to MYSQL. I will first integrate this application into GP using the Shortcuts menu -> Add -> Add Macro Shortcut.

 This application generates the Payroll data and when i wish to save it in MYSQL using the application save option it should as well save the generated payroll data into GL of GP.

The Data what i have

Employee ID  dbtype as VarChar  Example EMPLOYEE001

Employee Salary dbType as Decimal Example 10000.00

Food Aloowance dbType as Decimal Example 500.00

Transport Allowance dbType as Decimal Example 500.00

GOSI Deductions dbType as Decimal Example 500.00

OverTime dbType as Decimal Example 500.00

Absent Dedcutions dbType as Decimal Example 80.00

Benefits dbType as Decimal Example200.00

Loans dbType as Decimal Example1000.00

Sum of Dedcutions dbType as Decimal

Net Salary dbType as Decimal

Payroll Date dbType as Date dd/MM/yyyy

 Hope you are able to get

Note this is a Payroll Data suiting KSA and so its assumed to be in Riyals and hence use NO currency symbols, just plain numbers. Now i want to export this Data to GL of GP.

Since i wish to automate the process of exporting the data, how should i do it. SInce the payroll will be generated on monthly basis and i do not want the client to do it manually every time he generates payroll. 

give me your ksa no. or can you come to skype or msn my id is alwani89. This is hotmail ID.

 I have a yahoo id of latifsaquib2000 and

Gmail id latifsaqib     but i do not have a Hotmail account. if you wish i will make one