Rabu, 06 September 2017

IT : FTP antar server di windows

contoh

PS C:\Users\Administrator.SEGER> cd..
PS C:\Users> cd..
PS C:\> cd '.\BACKUP SQL'
PS C:\BACKUP SQL> cd bal
cd : Cannot find path 'C:\BACKUP SQL\bal' because it does not exist.
At line:1 char:1
+ cd bal
+ ~~~~~~
    + CategoryInfo          : ObjectNotFound: (C:\BACKUP SQL\bal:String) [Set-Location], ItemNotFoundExce
    + FullyQualifiedErrorId : PathNotFound,Microsoft.PowerShell.Commands.SetLocationCommand

PS C:\BACKUP SQL> cd bak
PS C:\BACKUP SQL\bak> dir


diatas itu directory tempat asal file

IT : Reset Setting User Profile di Windows

Klik Start - Computer - Klik Kanan Properties - Advanced System Sharing - Advanced - User Profiles - Settings - Delete Account di User Account tersebut

Rabu, 23 Agustus 2017

PHP : Penambahan Tanggal dengan php

<?php $tgl1 = "2013-01-23";// pendefinisian tanggal awal $tgl2 = date('Y-m-d', strtotime('+6 days', strtotime($tgl1))); //operasi penjumlahan tanggal sebanyak 6 hari echo $tgl2; //print tanggal ?>


atau

date('Y-m-d', strtotime('+6 month', strtotime( variabel_tgl_awal )))
date('Y-m-d', strtotime('+6 year', strtotime( variabel_tgl_awal )))

Kamis, 17 Agustus 2017

PHP : Clear cache input text dan Form

<input type="text" autocomplete="off"/>
Should work. Alternatively, use:
<form autocomplete="off">

Selasa, 08 Agustus 2017

Excel : Picture Lookup Excel ( https://trumpexcel.com/ )

There are many Excel functions (such as VLOOKUP, LOOKUP, INDEX/MATCH) that can go and fetch a value from a list. Imagine doing the same, but instead of fetching a value, you can fetch a picture.
In this tutorial, I will show you how to do a picture lookup in Excel.
It’s simple yet make you look like an Excel Magician (all you need is this blog and sleight of hands on your keyboard).

Picture Lookup in Excel

I have a list of the 20 teams in English Premier league (ranking based on scores as of Nov 20, 2013) along with the club logo in the adjacent cell.
The intent is to select a club and the picture should change to display its logo.
Something as shown below:

Jumat, 04 Agustus 2017

AX : Insert CSV Write IO dengan Container AX 2012

{ 
    container c; 
    CommaIo myfile; 
    FileIoPermission perm; 
  
    #define.ExampleFile(@"c:\myfile.txt") 
    #define.ExampleOpenMode("w") 
  
    // Set code access permission to help protect the use 
    // of CommaIO.new 
    perm = new FileIoPermission(#ExampleFile, #ExampleOpenMode); 
    perm.assert(); 
  
    myfile = new CommaIo(#ExampleFile, #ExampleOpenMode); 
  
    // Assign the entries in the container according to record layout. 
    c = [1,"MyText",1.324,"Last field"]; 
    // Write this record according to file format  
    // (record/field delimiters). 
    myfile.writeExp(c); 
     
    // Close the code access permission. 
    CodeAccessPermission::revertAssert(); 
}

Senin, 31 Juli 2017

AX : Windows Save Dialog AX 2012

static void windowsSaveFileDialog(Args _args)
{
str         filePath;
container     conFilter = ["TXT","*.txt"];

filePath = Winapi::getSaveFileName(
0,
conFilter,
"",
"Save As",
".resx",
"Untitled");

Box::info(filePath);
}