You’re offline. This is a read only version of the page.
Hello! so I'm trying to create an integration to take some data from our other software and input it into GP 2013. my mapping is correct and source file is accurate, however when I integrate, it only integrates first line and for the rest of them it says "DOC 2 error: object "test" already exists---cannot insert" any idea why? I'm using a csv file. again the first record integrates but not the rest. I have changed the data for the first record to see if it was a problem on the data but it isn't. it will integrate any first record, but not the rest. I haven't tried creating a new csv file, perhaps my file is corrupt. has anyone ran into this kind of issue before?
*This post is locked for comments
Adal -
Good to hear from you again. I think you are on the right track, but maybe you don't need the extra field. Just because you use the batch number field to coordinate the transaction records doesn't mean you have to import the batch number from the file. Try just changing the source for the Batch ID to user entry. Not sure this would work, but it will be easy to try.
Hey Harry, its been a while but i have a question for you again. if you review the thread above, the batch error was fixed because we had batch id in the text file and then used group by funtion. what if i wanted the user to type in the batch id (input) how would i account for that? that will take me back to ground zero, all i have in my text file is (Employee ID,Code,Position,Amount) i want user to type in the batch id. i can use group by for any of the fields in the text file because they are different. would it be a good idea to add an extra field in the text file just so i can use the group by function, but never integrate that column? or is there a better way?
you are the man!!!!! i owe you a lunch next time you are up here in Alaska!!! it works now!! who would of thought the order of the header and the other source file matters!
Adal,
In my test integration I make two passes through the same text file, which includes a BatchID field. The first pass (source), I use the group by feature on the sort tab to group the transactions by batch ID - selecting only the batch ID, so only the BatchID field shows when the source is previewed.
Then in the second pass I included the BatchID field, but did not group by it - this shows all the records with the same batch ID when previewed.
Then I used Query Relationships to link the first Source file (header) to the second Source file (lines) using the BatchID field. This approach works, so I would recommend it.
It was this design, which I edited earlier to test using the Input method for the BatchID, and likely explains why your integration is not working as mine does.
hey so i was reading online, someone was saying that create another sourse file and point it to the same csv file, which i did, and then sort and order by batch id. i altered the file and manually added a batch id in each row to see if i can make it integrate with that. so the second sourse file the one i sorted and grouped by batch id only showed bath id when i hit preview with one record. i then mapped that particular source to bath id and the rest to my original sourse file, but i had the same result? that sound accurate?
Thank you again, i'll try that, but the transactions per say isn't the issue i don't think. its the fact that it is trying to create a batch for every record and fails after creating the first saying the batch already exist. i'm certain i'm doing something wrong as this is my first time creating an integration. although i think i'm doing it right. i hate to call for support because i'm so close to fixing it. if i can send you screenshots of my settings and procedure could you check to see if something is out of ordinary? if yes, then can i email it to you or just post it here?
Adal,
It sounds like your settings are as they should be. With the Option Tab being blank when the Payroll Transaction folder is selected, the header for import shouldn't create multiple batches. for the multiple transaction lines.
You have already described that when you preview the source file you see the data you expect to see in the file.
Often times when I have trouble with an Integration or Macro, I open the window I am trying to integrate to, and try entering one or two transactions manually using my source data. I would recommend trying this technique with your source file data, to see if you encounter any errors when doing so.
just re-read your comment, the option tab is blank, and the when i highlight "payroll transaction" in the mapping window, only batch id is set to input, others are set to default. on level down from payroll transaction is entries, that is where i have the rest mapped, is this a correct way of doing it?
Thank you Harry, I think you have pointed me on the right track. I have seen in our other integrations that there are two files underneath the sources, header and detail. on this one, i didn't create any header file. i don't know what you exactly mean when you said to check to make sure i don't have anything mapped to my header level.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (