search

richeso / dataloadercliq

Automatically exported from code.google.com/p/dataloadercliq
0 stars 0 forks source link

Mapping - (field) will be ignored since the destination column is empty #89

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.logged into  a client system
2.Setup upsert to accounts
3.run accounts.bat file

What is the expected output?
sucess files
 What do you see instead? - errors on everything in the file - it is saying my external ID is missing

What version of the product are you using?
23
 On what operating system? Server 2012

Please provide any additional information below.

I have the same setup on my own machine and with thier data files it works with 
no problem. Could this be some sort of permissions issue?

What does that message mean, "since destination column is empty" and why would 
it be listing it for every column in my CSV file?

Original issue reported on code.google.com by jonestech22 on 27 Oct 2014 at 3:29

Attachments:

GoogleCodeExporter commented 9 years ago 
I encountered same issue.

Original comment by tsubak...@gmail.com on 29 Oct 2014 at 5:52

GoogleCodeExporter commented 9 years ago 
Did you move the files from another system?  Are the paths correct in your 
process-conf.xml file?

Original comment by vijay.swamidass@gmail.com on 29 Oct 2014 at 11:29

GoogleCodeExporter commented 9 years ago 
I do have an update on this issue. Maybe it will help others.

I did not move the files. I created the whole setup on this system and checked, 
and rechecked, and rechecked... the paths in the processes-conf.xml file.

I was bothered a little about some things on this system as it was a clients 
system and then after talking about it further with their IT Manager I 
discovered that they have security in place that stops alot of script calls 
being made from the App/Local environment on this system. We suspect this may 
be causing the problem and he is working on setting up a service to run the 
upload.bat files and see if he can get it to work.

Original comment by jonestech22 on 30 Oct 2014 at 5:24

GoogleCodeExporter commented 9 years ago 
I do have an update on this issue. Maybe it will help others.

I did not move the files. I created the whole setup on this system and checked, 
and rechecked, and rechecked... the paths in the processes-conf.xml file.

I was bothered a little about some things on this system as it was a clients 
system and then after talking about it further with their IT Manager I 
discovered that they have security in place that stops alot of script calls 
being made from the App/Local environment on this system. We suspect this may 
be causing the problem and he is working on setting up a service to run the 
upload.bat files and see if he can get it to work.

Original comment by jonestech22 on 30 Oct 2014 at 5:24

GoogleCodeExporter commented 9 years ago 
thank you for your great information.
if you don't mind, please make sure what kind of "security".
Virus checks? Firewall? others?

Original comment by tsubak...@gmail.com on 31 Oct 2014 at 8:47

GoogleCodeExporter commented 9 years ago 
Hi,
I am facing the exact same issue. I have verified the process-conf.xml file and 
paths are correct. Did anyone find a solution to this. 

Thanks

Original comment by abhinav....@gmail.com on 24 Feb 2015 at 11:02

GoogleCodeExporter commented 9 years ago 
Have you tried this solution?
https://code.google.com/p/dataloadercliq/issues/detail?id=42

Original comment by vijay.swamidass@gmail.com on 25 Feb 2015 at 8:28

GoogleCodeExporter commented 9 years ago 
I was getting "Mapping for Field x destination column is empty" because I did 
not have a correct reference to the mapping (.sql) file - it does not fail and 
can insert null records.  Happily problem solved.

Original comment by kbre...@digital-movement.com on 4 Mar 2015 at 12:55