self generated .csv file not importing correctly in e

[MSRudy]

Hi everyone,

For a billing i need to import .csv files in a pretty old billing system. Its so old i cant get support on it.
This works fine when i use the .csv files i receive from our partner, who provides service A.

However, another partner who provides service B sends us a file in a completely different style that wont be accepted by the billing system.
After some help on the forum here i created some code that converts their file to a file that looks identical to that of partner A.

Now i can upload the file on the billing system, but when i try to generate a report based on the file i made i get a blank excel sheet. When i generate a report from the ready to go file from partner A i get a report without any issues.

When i look at both files in Notepad ++ they look identical. (I changed numbers and e-mail adresses for privacy)

Original file i receive from partner:

File i made using some VBA code to convert things:

Anyone know how it could be that one is working, and the other identical working one is not?

Thanks,

 

[Krayons]

Couldn't tell you; I would need to see the code that handles the import of the .csv file.

From the information you've provided, my only suggestion is what appears to be phone number. In the original file, there is just a "0" for the phone number field. In your example, you've got a leading "+". Perhaps whatever code that handles the import, doesn't know what to do with the "+" symbol? Try removing it and see what happens.

Other than that, I don't know mate, you're going to have to be a little more specific.