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!!
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
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
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.
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:
Best regards,
Ludwig
#1
André Arnaud de Cal...
291,885
Super User 2024 Season 2
#2
Martin Dráb
230,569
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
