Hi all,
I am wrote a excel import job to bulk update the customer addresses while reading the data from csv sometimes garbage values like ??? and ,,,, are getting inserted in to the table where I am storing the data. How can we avoid reading of these garbage values.
And I do totally agree with Martin
Consider using the data import/export framework for such a task.
And if you're really keen on your own code - please debug it.
Regards,
Abdullah
Please double check your csv format.
Share
Report
All responses (
Answers (
DirParty dirParty;
DirPartytable dirPartytable,dirPartyTable_P;
LogisticsLocation logisticsLocation,logisticsLocation1,logisticsLocation_P;
LogisticsLocationRole locationRole,logisticsLocationRole,logisticsLocationRole_P;
Args args = new Args();
DocuRef docRef;
container roles,readCon;
counter icount,inserted;
int recCount =0,fvalid=0;
csvFile = new CommaIO(filename, 'r');
try
{
if (csvFile)
{
readCon = csvFile.read();
while (csvFile.status() == IO_Status::OK)
{
readCon = csvFile.read();
fvalid ;
if(readCon)
{
icount ;
if( !conPeek(readCon,1) && !conPeek(readCon,2) && !conPeek(readCon,3)
&& !conPeek(readCon,4) && !conPeek(readCon,5) && !conPeek(readCon,6)
&& !conPeek(readCon,7) && !conPeek(readCon,8) && !conPeek(readCon,9)
&& !conPeek(readCon,10))
break;
iAccountNum = conPeek(readCon,1);
In the Line number 28 container is reading the account number with garbage values .
Hi mahiim,
Can you please share your code? and also double-check the format in your CSV file
Please check this as well https://www.schweda.net/blog_ax.php?bid=573&wdl=en
while my import job reading values from csv file in to container it is reading the values along with garbage values.
For example:
I have account number :0000004 in my excel file but when reading the value in to the container it is reading line ???0000004
You can avoid such bugs by not writing any code at all. Consider using the data import/export framework already included in AX 2012, which can import both Excel and CSV files without such issues.
If you insists on spending time with your own code anyway, use the debugger to find out where it doesn't behave as intended. If you fail to understand why, share the code together with input values and tell us what's wrong with it.
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156