web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic reporting: ...
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
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:

pastedimage1627381657609v1.png

pastedimage1627381679326v2.png

pastedimage1627381769387v3.png

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)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Electronic reporting: import blank column/value from CSV to entity

    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

  • PK Axapta Profile Picture
    PK Axapta 140 on at
    RE: Electronic reporting: import blank column/value from CSV to entity

    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.

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Electronic reporting: import blank column/value from CSV to entity

    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

  • Verified answer
    Mea_ Profile Picture
    Mea_ 60,284 on at
    RE: Electronic reporting: import blank column/value from CSV to entity

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

  • PK Axapta Profile Picture
    PK Axapta 140 on at
    RE: Electronic reporting: import blank column/value from CSV to entity

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

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

  • Stefano Cordeiro Profile Picture
    Stefano Cordeiro 21 on at
    RE: Electronic reporting: import blank column/value from CSV to entity

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans