How to rebuild the Integration Manager?

Presently the one we have is corrupted and the need to have this fixed is very urgent.
GArneaudAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bernard S.CTOCommented:
Hi GArneaud,
Woulb a good idea to explain here what You posted on the request for attention, si That all those who Read This page here know more détails about jour problem.
0
David Johnson, CD, MVPOwnerCommented:
no points from request for attention:
Yes, correct it relates to GP . Integration Manager is an integration tool used to convert and transfer data from most database formats or desktop applications into Microsoft Dynamics GP
1
GArneaudAuthor Commented:
Integration is not recognizing general ledger codes.

Once this file is opened in notepad it displays correct information, however when it is opened as Excel the account data changes. It is advised to always open csv file types with notepad only and never with Excel as data can become corrupted.

In addition to this I also noticed that the GL account format still does reflect the account in GP, the dashes in between are missing. You can attempt an upload as Figure 1 below. If Integration Manager does not accept this, then the user will need to edit the file to include the dashes.

Figure 1 - IN NOTEPAD

3312015,120010101010000,11424,STBCASHBOOK
3312015,120030201010000,4355.71,STBCASHBOOK
3312015,120010201010000,13884.6,STBCASHBOOK
3312015,120010601010000,6613,STBCASHBOOK
3312015,120010501010000,1217.49,STBCASHBOOK
3312015,120010301500000,2024,STBCASHBOOK
3312015,130011801010000,-39518.8,STBCASHBOOK

Figure 2 - IN EXCEL
3312015      1.2001E+14      11424      STBCASHBOOK
3312015      1.2003E+14      4355.71      STBCASHBOOK
3312015      1.2001E+14      13884.6      STBCASHBOOK
3312015      1.20011E+14      6613      STBCASHBOOK
3312015      1.20011E+14      1217.49      STBCASHBOOK
3312015      1.2001E+14      2024      STBCASHBOOK
3312015      1.30012E+14      -39518.8      STBCASHBOOK
STB_GL_EXPORT_03312015.csv
0
Lionel MMSmall Business IT ConsultantCommented:
So what do you need help with, to get the excel file to show the proper values? If that's all then simply format the second column as a number column. It is normal for Excel to covert 120010101010000 into 1.2001E+14  if it is using the default general format. Also make sure you remove the decimals places (2) and make it zero.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
slightwv (䄆 Netminder) Commented:
Excel tries to "guess" at what the data types of the data is.  When it sees a large series of numbers, it thinks number.

You can change the way the CSV file is produced and Excel will open it as a string.

This will produce the scientific notation you currently see:
abc,1234567889012346677

This will produce a string:
abc,="1234567889012346677"


If you cannot change the way the file is generated, you need to change the way you open it.  Just don't double click on it.  Open it as a txt file and manually select the way the columns are imported.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Document Management

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.