Working with TextIO Codepage

Many X++ developers will have used the TextIO class to write files at some point.  Generally we will use it as such:

 MyTextIO = new TextIO(MyFile, #IO_Write);

 There is an optional 3rd parameter to the new method of the TextIO class, and this is the codepage of the output file.  The actual definition of the new method from MSDN:

 
public void new(
    str filename, 
    str mode, 
   [int codepage])

 The default setting for codepage is UTF-16LE, which is fine if you are exporting CSV data to be opened in Excel, for example.  But in the world of ERP systems, many interfaces are with older technology, and while you can't spot the difference just using something like Notepad, looking at the output file in a hex editor would of course show the difference between the default codepage and a simpler one.  Certain interfaces, for example outputting payment or check information to a bank, will require a codepage such as 0 for ANSI.  The MSDN entry (link below) has the full list of codepage values and what they mean.

 https://msdn.microsoft.com/en-us/library/textio.new.aspx

Comments

Post a Comment

Popular posts from this blog

Posting Purchase Order Invoices via X++

In the scenario where you need to post purchase order invoices on a per packing slip basis, you will want to make use of the VendInvoiceInfo series of tables: VendInvoiceInfoTable, VendInvoiceInfoSubTable, VendInvoiceInfoLine, and VendInvoiceInfoSubLine.  A few notes about using these tables from code.  Since there will be no form front end, you won't specify a ParmID in your code.  Also there can only be one invoice line per PO line in each invoice, so if you have multiple receipts to invoice for one PO line, each different packing slip goes in the subLine table.  Also, if you need to use charge codes to apply to the invoice, MarkupTrans table and MarkupAllocation class are your tools.  Below are some code snippets to refer to - they are not intended to be copy/pasted and that's it.  They are just some examples of initializing the tables.  in the code below, psJour is VendPackingSlipJour and psTrans is VendPackingSlipTrans.  You will use class Pu...
Read more

Using X++ to get a list of files in a directory

If you have the need to read a specific directory to get a list of files from it, the following code uses System.IO objects which will work in batch if needed. static container findMatchingFiles(         str _folderPath,         str _filePattern   = '*.*') {     System.IO.DirectoryInfo     directory;     System.IO.FileInfo[]        files;     System.IO.FileInfo          file;     InteropPermission           permission;     str                         fileName;     counter                     filesCount;     counter                     loop;     container        ...
Read more

Split a production order with X++

Below is code for splitting a production order in a Scheduled status based on an input quantity from a dialog.  Note that if this code is put in a class, that class must be set to run on the server, as the AX split code is run on the server.  Note that the status decrease is run twice to get the status to Created, and then the Estimation and Scheduling is run for both the old and new production orders. public void run() {     ProdParmStatusDecrease  prodParmStatusDecrease;     ProdUpdStatusDecrease   prodUpdStatusDecrease;     ProdTable               splitProdTable;     ProdUpdCostEstimation   costEstimation;     ProdParmRelease         prodParmRelease;     ProdUpdScheduling       scheduling;     ProdParmScheduling      prodParmScheduling;     ProdParmSplit  ...
Read more