Sunday, December 30, 2018

Spotfire

SpotFire

insert data into view
https://www.codeproject.com/Articles/236425/How-to-Insert-Data-Using-SQL-Views-Created-Using-M

https://spotfired.blogspot.com/
https://www.tibco.com/products/tibco-spotfire/learn/videos?field_video_type_target_id=821
https://www.youtube.com/watch?v=rvZf4ahc3bY&list=PLVHgQku8Z935xrGJK3r4uLv452vE9GzGt&index=4
https://www.youtube.com/user/intellipaaat/search?query=spotfire

SpotFire
https://spotfired.blogspot.com/
https://www.youtube.com/watch?v=Soq428T8mDY&list=PL-nvlz_b2YHgnrD1L5WlP3qkpWOiizT1R&index=1
https://www.tibco.com/products/tibco-spotfire/learn/videos?field_video_type_target_id=821
https://www.youtube.com/watch?v=yQbrv3swz2M&list=PLU3U6HmS8SigjQfLbN1wzcQ2gVxTMxUtp&index=1

Scripting
https://www.youtube.com/watch?v=m1OCnOzUHew
https://wiki.python.org/moin/

https://www.youtube.com/watch?v=yQbrv3swz2M&list=PLU3U6HmS8SigjQfLbN1wzcQ2gVxTMxUtp

https://community.tibco.com/wiki/ironpython-scripting-tibco-spotfire#toc-2

Filter
https://www.youtube.com/watch?v=WVROLbcXyic

TextArea
https://datashoptalk.com/unscrambling-spotfire-text-area/

pls do some POC on pthyon and scripting

Monday, December 17, 2018

Viva

Nama saya Nazmul, saya muslim dan berasal dari bangladesh.i saya insinyur komputer. Saya tinggal di "ikon kota". saya telah melihat Anda di WD banyak hari. aku sangat menyukaimu. Saya ingin menjadi teman Anda. Nomor whatsapp saya adalah +60178855673. tolong beri saya nomor whatsapp Anda.saya tidak bisa berbicara bahasa anda. saya mengerti bahasa Inggris.




Nama saya Nazmul, saya muslim dan berasal dari bangladesh.i saya insinyur komputer. Saya tinggal di "ikon kota". saya telah melihat Anda di WD banyak hari. aku sangat menyukaimu. Saya ingin menjadi teman Anda. Nomor whatsapp saya adalah +60178855673. tolong beri saya nomor whatsapp Anda.


To: "Anna Jones"
Cc: All Staff
From: "James Brown" jamesbrown@abcd.com


Subject: Welcome to our Hive!
Subject: Enquiry about Conference Centre Timings

Dear (title) ____:

I am writing to bring to your attention a serious issue I had in your establishment last week. 


I look forward to hearing from you as soon as possible to resolve this problem. 

Please have a look at the attached [item].

If you have any questions during your training period, please do not hesitate to contact me.You can reach me at this email or on my office line at 000-0001.



Sincerely,
(your full name)

http://consumer.georgia.gov/consumer-services/sample-complaint-letter-to-send-to-a-business
http://www.consumer-action.org/alerts/articles/sample_complaint_letter_and_email

Azure

https://learn.microsoft.com/en-us/azure/devops/pipelines/get-started/key-pipelines-concepts?view=azure-devops#stage

Azure

Top 10 Azure Services Every Developer Must know
1.Virtual Machine
2. Azure Storage
3. Azure SQL
4. WebApp
5. Azure Function
6. CosmosDB
7. Azure Service Bus
8. Azure Active Directory
9. Azure Key Vault
10. Application Insight

  • Azure DevOps or other CI/CD platform

Visual Studio Team Services(VSTS) is now Azure DevOps Services




Azure Repos

Get unlimited, cloud-hosted private Git repos for your project.

Get unlimited private Git repository hosting and support for TFVC that scales from a hobby project to the world’s largest repository.

Azure Boards

Plan, track, and discuss work across your teams.

Track work with Kanban boards, backlogs, team dashboards, and custom reporting

Combine drag-and-drop sprint planning and flexible work item tracking with comprehensive traceability to have the perfect home for all your ideas–big and small.


Azure Pipelines

Continuously build, test, and deploy to any platform and cloud.

Get cloud-hosted pipelines for Linux, macOS, and Windows. Build web, desktop and mobile applications. Deploy to any cloud or on‑premises.

Automate your builds and deployments with Pipelines so you spend less time with the nuts and bolts and more time being creative.

Azure Functions

Azure Functions is a server less solution that allows you to write less code, maintain less infrastructure, and save on costs. Instead of worrying about deploying and maintaining servers, the cloud infrastructure provides all the up-to-date resources needed to keep your applications running.














IF EXIST "G:\_backups\DSP_Backup" (ECHO "G:\inetpub\wwwroot\DSP-PROD"  " Removing.....")
 IF EXIST "G:\_backups\DSP_Backup" (RMDIR /Q /S "G:\_backups\DSP_Backup")
 IF NOT EXIST "G:\_backups\DSP_Backup" (    MKDIR "G:\_backups\DSP_Backup")
`MKDIR` command is used to create the directory "C:\_backups\DSP_Backup".
IF EXIST "G:\_backups\DSP_Backup" (
    ECHO "Copying backup of G:\inetpub\wwwroot\DSP-PROD to G:\_backups\DSP_Backup .........."
    XCOPY /E /I "G:\inetpub\wwwroot\DSP-PROD" "G:\_backups\DSP_Backup"
)


    Friday, December 7, 2018

    Malaysia Police Clearance

    Malaysia Police Clearance
    https://ekonsular.kln.gov.my/en/
    https://www.youtube.com/watch?v=oXUejHakNkc
    https://ekonsular.kln.gov.my/en/ 
    https://ekonsular.kln.gov.my/en/ 
    https://ekonsular.kln.gov.my/en/
    https://wikiprocedure.com/index.php/Malaysia_-_Obtain_Police_Clearance_Certificate_(Certificate_of_Good_Conduct)
    http://www.kln.gov.my/

    Applications for the Certificate of Good Conduct must be accompanied with the following documents:
    • 2 Malaysian passport size photographs (40cm x 55cm);
    • 2 copies of the applicant's Malaysian identification card;
    • 2 copies of the applicant's passport (for non-Malaysians, copies of all passport pages);
    • A self-addressed stamped envelope;
    • An introduction letter from the employer (for non-Malaysians).



    • Two recent passport-size photographs attached
    • Submit two copies of your identification card
    • Two copies of your passport (for foreigners, all pages)
    • A self-addressed envelope (with the required stamp)
    • An introduction letter from Visa Office (for foreign nationals)


    Wednesday, November 14, 2018

    Cert

    Hi NAZMUL.

    There is 2 options to get status  from online table “tx_lot” and get from pre-generate table “REP_EOH_DAILY_CUTOFF” using cutoff date

    This is should separate option and wafer number should be able to enter multiple value.



    I will try to call in afternoon.

    Address: Level 3A, 1 Sentral, Jalan Rakyat, Kuala Lumpur Sentral, 50706 Kuala Lumpur
    Time: 12:00 – 01:00 PM
    Date: Monday, November 19th, 2018

    Amma Date of Birth : 19 Feb, 1958

    AngularJS DirectivesAngularJS directives are extended HTML attributes with the prefix ng- . The ng-app directiveinitializes an AngularJS application. The ng-model directivebinds the value of HTML controls (input, select, textarea) to application data.


















    Dada assalamualaikum,  I need below three papers from the given Kazi Office Address. Information about bride(কনে) and  bridegroom(বর) also given here.
    1. Kabin Nama (Bangla)  
    2. Nekah Nama (English)  
    3. Merriage Certificate (English)

    Below is Kazi Office Address : 


    Merriage date (বিবাহ তারিখ): 8 September 2012

    Bride(কনে)  : 
    Bride Name : Kamrunnahar
    Father : Zainal Abedin
     Mother: Azmeer Pyari
    Date of Birth : October 10, 1988

    Bride(কনে) Permanent and Present Address (English)
    Vill: Toraghor, 
    Word no: 07
    P.O : Hajigonj
    Upazila : Hajigonj
    District : Chandpur.

    কনে স্থায়ী ঠিকানা/ বর্তমান ঠিকানা(Bangla):
    গ্রাম: টোরাগড়
    ওয়ার্ড নং: ০৭,
    পো: হাজীগঞ্জ
    উপজেলা : হাজীগঞ্জ, 
    জেলা : চাঁদপুর

    Bridegroom(বর)  
    Bridegroom Name : Mohammad Nazmul Huda Rubol Chowdhury
    Father : Shamsul Huda Mahbub Chowdhury
     Mother: Kamrun Nahar Chowdhury
    Date of Birth : January 7, 1979

    Permanent and Present Address (English):  
    House No:726/4,Road No: 10,  Baitul Aman Housing Society,
    Mohammadpur,Adabor, Dhaka.

    Friday, October 12, 2018

    MongoDb

    Purpose : To modify stored procedure  scripts to combine data between MITECS + CAMSTAR to support SSRS report  

    Report name                                    Description                                         Stored procedure name
    HGA_WIP_FG_Inventory_Report                    HGA WIP summary Finish good inventory report        REP_HGA_WIP_FG_REPORT
    LotInformation_SubReport (sub report)          Drill down to see detail                            REP_HGA_WIP_FG_SUB_REPORT


    Option select data to generate report 
      1. CAMSTAR
      2. MITECS
      3. CAMSTAR + MITECS

    SQL Server Information :

    WDTBMITECSDEV01.tb.asia.wdc.com\WDBMITECS3TRAIN
    DB : User_datatemp
    User : repuser
    P/W : rep27090*

    Link server to get data from CAMSTAR : DV_THO_DEV

    Example : to query camstar inventory status from DV  
    select * from openquery (DV_THO_DEV,'SELECT TOP 10 * FROM CAMSTAR_INVENTORY_LOT_STATUS')



    require to show existing report compete get data from DV 


    Note... Pls. donot delete any data in table or view....  


    https://westerndigital.metricstream.com/metricstream/systemi/Userloginsso

    Tuesday, September 25, 2018

    WD.AutoProcess

    Microsoft.ACE.OLEDB.12.0(64)
    Microsoft.Jet.OLEDB.4.0
    Microsoft.JET.OLEDB.4.0(32)

    -No password

    -restart the application manually

    Hi Nazmul,

    Please help to setup a discussion on this week Wed/Thursday on WD.AutoProcess.

    Agenda:
    1)What is WD.AutoProcess?
    2)Why we need this?
    3)How it works?
    4)Which team is using?
    5)What are the dependencies in the source code?
    6)Any relation to DAL and XLC?


    If you know the answer, you may reply here. Discussion is to know how much understanding of this.

    Thanks.

    Please explain in detail. Where and how the Auto Process do:

    a)      Stop
    b)      Kill
    c)       Start
    d)      Email/sms
    e)      Authenticate
    f)       Etc.


    Please help to setup on Wednesday afternoon 2-3pm.



    Regards,
    CK Tan
    Global IT HDD MES (Reporting)
    Western Digital ®


    Thursday, September 20, 2018

    Saad

    https://shishirmanir.com/

    পাত্রী / BRIDE  Name : Kamrunnahar
    Name of Father : Jainal Abedin
    Name of Mother: Azmeer Pyari
    BRIDE  Date of Birth : October 10, 1988

    Permanent and Present Address

    Vill: Toraghor, Word no-07
    P.O : Hajigonj
    Upazila Hajigonj
    District : Chandpur.

    স্থায়ী ঠিকানা/ বর্তমান ঠিকানা

    টোরাগড়, ওয়ার্ড নং-০৭, , পো: উপজেলা : হাজীগঞ্জ, জেলা : চাঁদপুর


    Wednesday, September 19, 2018

    BulkInsert

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/39f28a0a-f026-4f0b-bbda-13357b18c494/bulk-copy-failed-user-does-not-have-alter-table-permission?forum=sqlsecurity



    Please prepare some diagram/process flow to show. It might takes a while to understand if no visualize diagram…if possible, provide some scenarios when we need to use each type of transactions…..

    USA Immigration

    1. PETITIONER'S BIRTH CERTIFICATE 
    2. PASSPORT BIOGRAPHIC PAGE
     3. PHOTOGRAPHS 
    4. BIRTH CERTIFICATE
     5. MARRIAGE CERTIFICATE 
    6. POLICE CERTIFICATE (MALAYSIA) 
    7. POLICE CERTIFICATE (BANGLADESH)


    Magnolia Hotel (Dallas, Texas)

    Monday, August 20, 2018

    Data Provider

    Npgsql - .NET Access to PostgreSQL

    About

    Npgsql is an open source ADO.NET Data Provider for PostgreSQL, it allows programs written in C#, Visual Basic, F# to access the PostgreSQL database server. It is implemented in 100% C# code, is free and is open source.


    In addition, providers have been written for Entity Framework Core and for Entity Framework 6.x.

     public Transaction() { }

          ///
    No Transaction for Database.
          public const int  None = 1;
          ///
    Transaction for Connections Separately.
          public const int Yes = 2;
           ///
        One Transaction for All Connections without connection Transaction.
           public const int  TS = 3;
            ///
       One Transaction for All Connections with connection Transaction.
            public const int TSNT = 4;

    Sunday, August 12, 2018

    Europe

    What is the project/achievement you’re most proud of?
    https://www.livecareer.com/interview/questions/tell-me-about-an-accomplishment-you-are-most-proud-of
    https://www.livecareer.com/interview/questions/describe-an-important-project-you-worked-on

    Wednesday, August 8, 2018

    C#

    Recursive function  

    https://www.youtube.com/watch?v=EpU0opEeP6g
    https://www.youtube.com/watch?v=Nl4_jvsDS2Q
    Factorial
    https://www.youtube.com/watch?v=mW5yo8U5dCs


    Convert expression to string

    Binary Expression
    https://www.youtube.com/watch?v=0YJECE45jhk

    Represents an expression that has a binary operator.

    Operators that take two operands, such as arithmetic operators (+,-,*,/), are referred to as binary operators.

    Delegate
    https://www.c-sharpcorner.com/article/how-and-when-to-use-delegates-in-your-project/

    https://www.youtube.com/watch?v=ifbYA8hyvjc

    Main use of Delegate is communication between two parties ,the main use of delegate is callbacks,callback.

    Wednesday, August 1, 2018

    System Scheduler

    System Scheduler
    https://www.splinterware.com/download/index.html
    Eastern Bank Ltd. 
    Name: MOHAMMAD NAZMUL HUDA RUBOL CHOWDHURY
    Account Number: 1041440270946
    Account Number: 1041440270946 
    Branch: Gulshan Branch
    Account Type: Current and Savings

    Thursday, July 19, 2018

    Cover Leter
     B-2-4, AVENUE COURT APARTMENT ,JLN 1/133 TMN SRI SENTOSA, AVENUE COURT
    JLN KLANG LAMA,

    KUALA LUMPUR, MALAYSIA

    58200 

    Mohammad Nazmul Huda Rubol Chowdhury
    T2-13A-06-01, icon city, Jalan no.1, sungai way, petaling jaya, Selangor.Postal: 47300 , Malaysia.
    Telephone: +60178855673

    Company Name: Western Digital (M)

     Address: P6/P7/P8, Jalan SS8/4 (Sungei Way FIZ), 47300 Petaling Jaya, Selangor, Malaysia

    iCrest Sdn Bhd,C-01-06 CoPlace 2, 2260, Jalan Usahawan 1, 63000 Cyberjaya, Selangor, Malaysia.

    Rubol30@gmail.com
    [Date]
    [Recipient Name]
    [Title]
    [Company Name
    [Street Address]
    [City, ST ZIP Code]
    Dear [Recipient Name]:
    [Name of person referring] suggested that I contact you regarding the open [job title] position with [Company Name]. My educational background in Computing & Information System (from London Metropolitan University, London, U.K) along with my professional experience, makes me an excellent candidate for this position.As you will see from the enclosed resume, I have more than 10 years of experience in the field of Software Engineering. My resume shows that I have been consistently rewarded for hard work with promotions and increased responsibilities. These rewards are a direct result of my expertise in .Net, my commitment to personal and professional excellence, and my excellent written and oral communication skills.
    If you have questions, or if you want to schedule an interview, please contact me at +60178855673. I look forward to meeting you to further discuss employment opportunities with [Company Name].
    Sincerely,

    Mohammad Nazmul Huda Rubol Chowdhury 




    20/07/2018
    Sir
     My educational background in Computing & Information System (from London Metropolitan University, London, U.K) along with my professional experience, makes me an excellent candidate for this position.As you will see from the enclosed resume, I have more than 10 years of experience in the field of Software Engineering. My resume shows that I have been consistently rewarded for hard work with promotions and increased responsibilities. These rewards are a direct result of my expertise in .Net, my commitment to personal and professional excellence, and my excellent written and oral communication skills.
    If you have questions, or if you want to schedule an interview, please contact me at +60178855673. I look forward to meeting you to further discuss employment opportunities with you.
    Sincerely,
    Mohammad Nazmul Huda Rubol Chowdhury | Sr. Software Engineer 
    Western Digital Corporation,Malaysia.   
    Telephone: +60178855673
    Rubol30@gmail.com



    Agrani Remittance House Sdn Bhd
    AddressNo. 33, Jalan Tun Tan Siew Sin, City Centre, 50050 Kuala Lumpur, Wilayah Persekutuan Kuala Lumpur

    Driving

     https://youtube.com/shorts/5Ac2qZHrApU?si=_X-G7pJFHiZoD-s7 https://www.youtube.com/watch?v=f6pSsex87oU