Electronic reporting: import blank column/value from CSV to entity

(0) Share

Report

Posted on by PK Axapta

140

Hi there,

i am working on ER where i have to pass/import blank columns from csv to respective entity (say customer payment journal entity).

So file structure is like Value1,,,,,,,

So after 1st column, all columns are blank during import. so i have created string columns in mapping & format and wanna to pass null value to those columns...but i am getting below error:

Could you please let me know how can i pass blank value during import or m i missing anything here.

Thanks in advance!!

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Peter,

Do you need to import those files into a customer payment journal?

Using a GL journal might be easier and gives you more flexibility if you have different payments included in the CSV file.

This series of blog posts might help:

Link to part 1:

dynamicsax-fico.com/.../

Best regards,

Ludwig

Was this reply helpful? Yes No
PK Axapta 140 on at

Like (0)

Report
Copy link

Link copied!

Many thanks Ludwig for your reply.

If it's ER, your blog posts are always very helpful :)

Actually i am referring/deriving my model from camt.054 and to that custpaymjournal entity is integration point.

Rest of the part is working as expected...only concern is how to pass blank/optional values from csv file to format/mapping fields (as explained above).

i did test.... if record is value1,,,,,,, then it's throwing above error but if i pass

Value1,"","","","","" then it's not throwing any error.

Any pointers how can i pass blank/optional values. i tried with IF(LEN(field)=0,"","") but no luck.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Peter,

I have not dealt many times with CSV files but one of my friends has.

Let me try to bring him in here.

Best regards,

Ludwig

Was this reply helpful? Yes No
Verified answer

Mea_ 60,286 on at

Like (1)

Report
Copy link

Link copied!

In the format mapping change Multiplicity property for those fields to allow blanks

Was this reply helpful? Yes No
PK Axapta 140 on at

Like (1)

Report
Copy link

Link copied!

Many thanks Ievgen, by changing multiplicity property, it's working as expected.

Thanks again Ievgen & Dr. Ludwig for all your help as always.

Was this reply helpful? Yes No
Stefano Cordeiro 21 on at

Like (0)

Report
Copy link

Link copied!

Hello, I'm having trouble configuring it to import a txt/csv... when simulating the import it generates an XML with this data:

<?xml version="1.0" encoding="UTF-8"?>

<Root />

What could I have done incorrectly?

Regards,

Stefano

Was this reply helpful? Yes No