Integration Manager Log file

Hi All,
Actually, the log file which is generated from IM is not user friendly 
becasue it is a text file with all sort of source doc nos, Activity Time and 
date and so on. These information makes user to get confused. So, user 
requested to get only warning/error msgs and write to a txt/csv files along 
with AccountNo, Credit/Debit amonuts to be written in that file. Sothat he 
can view in excel sheet and reimport it again. 
That is the reason I started opening a csv file and writing logs in that 
file line by line. 
For my scenario, I am integrating GP GL data where one header file with 
format DocNo, Date, Reference and a details file as DocNo, AccountNo, 
Amount(+/-). 
But as per IM view even though the detail account is missing it just takes 
as warning and commits integration. In that scenario I have to update a flag 
in source file as 'Success', 'Fail', 'Warning'. Next time it should reupload 
again for cases of 'Fail' & 'Warning'. But IM warning files also successfully 
integrates with warning. So, the flag(warning) which I am suppose to update 
is not doing it ocrrectly due to committ of doc. Since the lack of Ducument 
Commit Script in version IM 8.0, I could not update the flag currectly for 
warning cases.
I want get the current document to write into csv file.
 
Hope you understand. Let me know your suggestions. Thanks in advance.
 
Regards,
Vijay
0
Vijay1 (49)
1/28/2008 7:44:01 PM
greatplains 29623 articles. 5 followers. Follow

0 Replies
560 Views

Similar Articles

[PageSpeed] 1

Reply:

Similar Artilces:

Picture manager is not in my MS Office tools folder
MSPM has suddently disappeared from my start menu. No longer in Office tools. Can still use MSPM to work with pictures but left side task bar is gone. Easy email, cd creating, etc are all gone. Can't find any of it. Now only have shortcuts with a gazillian files. What have I done wrong? Your question may be better answered in a newsgroup appropriate to your problem. This newsgroup is dedicated to the Microsoft Access database product. The Microsoft website may have misdirected you. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://...

How to extract entire database to XML and from XML back to MDB file
Does anyone know of an automated way to extract the entirety of a MDB file to a XML flag file? I see there is a way to extract single tables from the menu, but I would like to store the entire MDB file in a flat file(s), store it in a versioning system (eg, CVS) that computes and stores deltas, retrieve it from the versioning system and rebuild the MDB file. Thanks, Siegfried To get the list of the tables, loop through the TableDefs. Alternative: OpenRecordset() on this query: SELECT MsysObjects.Name FROM MsysObjects WHERE (([Type] In (1,4,6)) AND ([Name] Not Like "~*") ...

Integration Questions
Where do I go or how do I get the CRM to integrate with Great Plains, I think there is supposed to be an integration tool somewhere, but I cannot find it. There is an integration CD which you will have received if you are a CRM partner or customer "Nathan Tidd" <NTiddSPAM@douglas-associates.com> wrote in message news:0d1a01c3b421$ec4437c0$a501280a@phx.gbl... > Where do I go or how do I get the CRM to integrate with > Great Plains, I think there is supposed to be an > integration tool somewhere, but I cannot find it. It is much more than a "Utility", i...

delete info from source file w/out changing the destination file
Hello I have two work sheet linked together for patient tracking files. All the information from the open source file is automatically updated in the Closed file. I want to be able to constantly update the closed file with out keeping more then 30 rows in the open file. Therefore, Once the patient tracking is completed, I should be able to delete the information form the source file with out removing it from the destination file. I am also having difficulty in moving the data down once I want to add another patient into the open file. e.g. row one was Tricia - info completed - delete Tr...

Opening Publisher 2003 Files
For some unknown reason I can no longer open Publisher 2003 Files with Publisher. When the attempt is made to open a file Microsoft Word 2003 always tries to open and then I have all xxxxxxxxs for the text, etc. I need to open a number of the Publisher files but cannot due to this problem. I would appreciate any assistance. Have you attempted to correct the file association? Right-click any Publisher file, properties, Opens with...click change. Associate Publisher files with the Publisher application. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://m...

Play a video file in form
Hii Play a video file in form in Access program Hoping someone will give the correct answer. Thanks in advance, This might be what you are looking for http://www.fmsinc.com/MicrosoftAccess/controls/components/video/avi-player.htm -- Hope this helps, Daniel Pineault http://www.cardaconsultants.com/ For Access Tips and Examples: http://www.devhut.net Please rate this post using the vote buttons if it was helpful. "Spier2vb" wrote: > Hii > Play a video file in form in Access program > > Hoping someone will give the correct answer. &g...

Opening a csv file in word
Hi, I'm having a problem at the moment - I need to do a large find replace with my excel data. I actually do two, the first one works fin but the second one doesn't; The first one I just open my.csv file in word, do my find and replace save again and it opens fine in excel. The second one though, I need to find and replace the paragraph break and replace them with the tag <br />. When I save it again and open i excel, my results are displayed across the top row instead of th column, and they're no longer in a single cell for each record. I'm guessing it's becaus...

looking for a case management template
I need to manage over 600 organization with a variety of variances. My primary key is a manually created file no. Can anyone provide suggestions. Search on-line for "case management" template. Search at Microsoft.com for "case management" template. Regards Jeff Boyce Microsoft Office/Access MVP "DB ADMIN" <DB ADMIN@discussions.microsoft.com> wrote in message news:E9F774D0-BAF7-494E-AAFE-157317D7C416@microsoft.com... >I need to manage over 600 organization with a variety of variances. My > primary key is a manually created file no. Can anyo...

CString::Format misinterpreting managed String as parameter
I'm mixing managed and unmanaged code in my VC++ projects and using CString and String classes at the same time. Following code-snippet worked without problems in VC++ .NET 2002: CString strTemp; String *sManaged = "anything"; strTemp.Format("%s", sManaged ); SetWindowText(strTemp); The result was, of course, "anything" on the screen. The same snippet, when compiled under VC++.NET 2003 and started in release mode or with Ctrl+F5 in debug mode reproduces unreadable output. However, it worls when debugging.. Any idea of what's going on here? "...

CRM Integration with an other SQL db
I'm looking to bridge Navision on SQL with CRM. Any body got some suggestions on the best way to built that real time link? -- Benoit How "Real Time" do you want it. If you want, you can use PostCallouts to implement this kind of integration (and there is a paper on MSDN on this subject) where you post changes to Accounts, new Orders, etc. from CRM to your Accounts package. For the other direction, bringing Accounts and sales information from the Accounts package into MSCRM then I would look at using a package like Scribe (BizTalk is also an option) to do this on a sch...

Scheduling Integration for Integration Manager
Hi, Does anyone have any step by step procedure or documentation for scheduling integrations for Integration Manager? I hope there is a workable way for not so technical users to use so that I won't need to customize a functionality for this in Dynamics GP. They want to update their price list if possible using integration manager. However, they want it to be scheduled, like for example the manager will create the integrations today, then it will the update (integration), the end of next week without human intervention. Reason being is that updates/integration can run during ...

Order Management with multiples sites
for improve the product, we need that order management permit to generate orders from multiple sites and with diferent documents type. This because, the orders could be delivered from different sites. This is necessary for the mobility. Thanks ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree"...

Finding data files
I just installed Windows XP but my Money 2001 now doesn't show any of my data. I saved everthing on my hard drive before I installed XP, but I did not back up my Money data. Isn't there a file that contains my current information? What is the name of the file Money saves its information to? Thank You!! See http://umpmfaq.info/faqdb.php?q=109. "Dale" <dalevan@iserv.net> wrote in message news:2a57301c466e7$63e929c0$a501280a@phx.gbl... > I just installed Windows XP but my Money 2001 now doesn't > show any of my data. I saved everthing on my hard d...

Populate Acrobat pdf file from Access
I have a database that I created a few years back that uses the activex installation of the old Adobe Acrobat FDF tookit. My code creates an fdf using fields from my form and then opens the corresponding pdf. The end result is that Access populates my pdf's for me. Now for my problem... I now have a computer with Windows Vista on it. I can't find a way to install the FDF toolkit. The way I had to do it before was to copy two files to the "system" folder and run this from a command prompt... "regsvr32 fdfacx.dll" and then the same for fdftk.dll When I ...

ACT! Address Book integration
When integrating or using an address book in Outlook, the display name is automatically appended with the name of the address book the 'look up' found the name in... example: Jonathan Dorfman (ACT!) Is there any way to edit this feature or suppress it? Thanks in advance. Jonathan ------------------------------------------------ ~~ Message posted from http://www.OutlookForum.com/ ~~ View and post usenet messages directly from http://www.OutlookForum.com/ ...

Lost files #3
I use money to keep track of my expenses and income on my rental properties. I exported the files from money 1999 to money 2004, when the files showed up on my check register it did not list the properties addresses . How do I go back into money and make sure that the addresses stay posted with each check Thank You Michael C ...

not being prompted that user has file open
One of my clients has Excel 2000 and the other Excel 2003. A file has been saved to a shared network drive. The file has a password to modify. Neither one of the users is notified when they open the file that the other has the file open. The sharing feature is not turned on. I have heard of this happening before with other users. Could this be a version compatibility issue? -- maryj ...

Integration Transaction Order Issue
We just switched from using Integration Assistant for Excel to Integration Manager 9.0. The integrations are defined the same way for both programs. When the General Journal integrations run they complete without errors/warnings. But when you view the transactions in the batch in Great Plains the transactions are not in the same order as they were in the Excel spreadsheet. They seem to be very random. The total dollar amounts balance and the integration runs successfully but we can't get the transactions to maintain their order from the Excel spreadsheet. We can't use a so...

How do I access a zip file after i have extracted it?
I am receiving zip files via email and have extracted file. Following this I am unable to view my file. What do I do? what happens when you try? Where are you saving it and how are you extracting it? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide) Author, Google and Other Search Engines (Visual QuickStart Guide) Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Join OneNote Tips mailing list: http://www.onenote-tips.net/ "-"...

Bar Graphs, Semi-Log Graphs
Dear Friends, I have the Millennium 2000 edition of Excel and I can't figure out how to make a) bar graphs of one variable vs. time. (all the options seem to be for two variables.) b) semi-logarithmic graphs. With my previous computer I had the Excel that went with Windows 95, and the Chart Wizard had options you could check for either one variable bar graphs or for semi-log graphs. In the Millennium 2000 I don't find either of these options with the Chart Wizard. Question No. 1: At the bookstore I see an expensive upgrade I can purchase to upgrade Millennium to Windows XP...

Encumbrance Management #3
EM will encumber any account on a PO. It would be nice to see a feature in EM that will allow a way to exclude balance sheet accounts in the encumbering of PO's. Numerous companies do not have balance sheet budgets as the income statement accounts are usually the main focus. The work around is extremely difficult when purchasing inventory to a BS account that is not budgeted for. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message p...

Outlook .ost file
One of my colleagues uses synchronized folders in Outlook. His info. is stored in an outlook.ost file. He is getting a new laptop and I need to copy his data from one laptop to the other. Everything I read says you need to copy the .pst file but he doesn't appear to have one. Is that possible? Can I simply copy his .ost file to his new laptop (will it import?). How do I go about doing that? MaryC <anonymous@discussions.microsoft.com> wrote: > One of my colleagues uses synchronized folders in Outlook. His info. > is stored in an outlook.ost file. He is getting a new lap...

Paste file name into cell
I am trying to have Excel automatically paste the file name into a cell - I don't want to use the header or footer for this. Thanks, Julie Try: =CELL("filename") -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29182 View this thread: http://www.excelforum.com/showthread.php?threadid=493604 Julie See Bob Phillips' site for this. http://www.xldynamic.com/source/xld.xlFAQ0002.html Gord Dibben Excel MVP On Wed, 14 Dec 2005 13:47:47 -0800, JulieK <J...

UNC Path length problem opening a file in excel 2002 or 2003
I've had several of my users that can't open an excel file when the UNC path length gets close to 220 characters. The UNC points to a 2003 server. This happens if you try to open using windows explorer or using the OPEN command in excel. Only excel is giving us problems. Word and other programs work just fine. I can't find anything in the knowledge base. Has anyone else seen this problem? Thanks John P.S. Please CC to j w a r r e n _ r e m o v e (a t ) p r u d e n t r x _ r e m o v e . c o m Take out the "_ r e m o v e" from the address. From Excel Help ...

how to auto open file when starting excel?
is there a way for me to preset a file to automatically open when start excel? i always have a specific file opened at all times whe excel is running & am tired of having to keep opening it -- Message posted from http://www.ExcelForum.com You can put the file where your PERSONAL.xls file is located. In Windows 2000 the full path is: (spanish) C:\Documents and Settings\Datos de programa\Microsoft\Excel\INICIAR Good luc -- Message posted from http://www.ExcelForum.com When it starts, Excel will try to open any (and all) document files in your XLStart folder. The default location in...