Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 16th December 2009, 17:11
davenon davenon is offline
Newbie
 
Join Date: Oct 2009
Posts: 1
davenon is on a distinguished road
Baan: baan IV c4 - DB: SQL server - OS: Windows Server
We were baaN Users on Unix and Oracle. We migrate to Windows and SQL server. ^Problem

A new blog entry has been added:

We were baaN Users on Unix and Oracle. We migrate to Windows and SQL server. ^Problem with files format

Quote:
We create, in a report script files with code like below:
        IF code.login = "davenon" THEN
  idfac = seq.open(FICFACDV,"w")
 ELSE
  idfac = seq.open(FICFAC,"w")
        endif
 IF idfac < 1 THEN
  |*Ouverture rapport impossible
  mess("spsls4404055.1",1,FICFAC)
 endif
and write with :
  mntbrut  = sprintf$("%@9999999,99@",( -1 * transport.forfait))
  enrcpt = "VTE" & CSV
   & dat6factur & CSV & nopiece & CSV
   & tdsls045.ttyp & SLASH & nofactur & CSV
   & "708" & nucompte708.SAGE & CSV
   & "" & CSV
         & facturavoir & nofactur & " " & raisocpt & CSV
   & "" & CSV
   & "" & CSV
   & mntbrut & CSV
   & mntbrut & CSV
   & "0,00"
         retour = seq.puts(enrcpt,idcpt)
Now , we are using in Windows and SQL server environnement. The files created with this code are in format Unix and we need to convert  them in Windows Format.
How can we obtain files in windows format ?
Thanks to all. I'm sure to obtain a good respons by you 
Daniel VENON .
Reply With Quote
Sponsored Links
  #2  
Old 18th December 2009, 20:20
dhowells's Avatar
dhowells dhowells is offline
Member
 
Join Date: Oct 2001
Location: Detroit, MI
Posts: 52
dhowells is on a distinguished road
Baan: Baan 4c4 - DB: Oracle - OS: UNIX
to fix file format

use a 't' with the 'w' on your seq.open. We just had the same problem.

idfac = seq.open(FICFACDV,"wt")
Reply With Quote
  #3  
Old 19th December 2009, 15:39
sushil's Avatar
sushil sushil is offline
Guru
 
Join Date: Jan 2006
Posts: 451
sushil is on a distinguished road
Baan: BAAN IV C4 - DB: Oracle - OS: Windows
post your queries / problem in Forum section not in blogs - to get solution from members.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
instantOLAP: strong, fast, easy to implement Stephane Hess General Discussion & Chat 0 26th January 2009 13:40
Baan Tools Administrator Muhammad Ali Jobs and Resumes 0 27th June 2007 09:49
SSA ERP-NL / Baan V6 is it Vaporware ? tjbyfield General Discussion & Chat 18 1st October 2004 10:50
Upgrade Baan IV (HP-UX, SQL Server 2000) cfasini Operating Systems & Databases 3 20th May 2003 13:56
Baanboard.com Community Bulletin 01/05/2002 patvdv About Baanboard.com 0 1st May 2002 15:04


All times are GMT +2. The time now is 15:11.


©2001-2017 - Baanboard.com - Baanforums.com