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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / SafePay CSV Double Quotes
Microsoft Dynamics GP (Archived)

SafePay CSV Double Quotes

(1) ShareShare
ReportReport
Posted on by devinmcm1 582

I am setting up SafePay for a bank that requires a CSV file with now text delimiters, so the file in their format example looks like this

12345678,12345,02252016,24567,IS,

I have only worked with SafePay on Fixed Field, and it appears as though if I use Comma Delimited as the Output Type, I cannot make it happen without SafePay enclosing the values in double-quotes.

I cannot believe this is not possible given all the possible ways a bank may want their Positive Pay upload files to be formatted.  Am I missing something about SafePay setup?  Everywhere I have read so far, it doesn't seem like I missed anything.

Can someone provide guidance?

Thanks

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    devinmcm1 Profile Picture
    devinmcm1 582 on at

    https://support.microsoft.com/en-us/kb/2511178

    Oh well, it seems like this is a limitation that cannot be handled without a workaround.  Seems pretty limiting

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    I've run in to the same situation before multiple times.  I've gone a couple of routes.  I've gone the route of creating it as a fixed length and hard-coding the commas.  It's tedious but once it's set, there's no other maintenance to it.  I've also done a .bat file that will run and strip out all the quotes from the file after it's been generated.

  • Suggested answer
    devinmcm1 Profile Picture
    devinmcm1 582 on at

    I hard-coded the commas

  • Community Member Profile Picture
    Community Member on at

    is anyone able to create through  Fixed Field? if please can share how did it? thanks

  • Community Member Profile Picture
    Community Member on at

    Hi Devin, could you please elaborate further, how can use and do hardcoded? with fixed length and using comma aswell. thanks

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans