Cygnet Vendor Portal Data Sync Utility (DSU)

Cygnet Vendor Portal Data Sync Utility (DSU)

Purpose:

Cygnet Vendor Portal DSU will enable subscriber user to process multiple bulk data files simultaneously. Uploaded files can be tracked and managed through DSU. Data columns from Source File can be mapped to Destination columns with Field mapping while importing.

Subscriber will be able to import data for Vendor, Purchase Order, Invoice, Credit/Debit Notes, GRN, RFQ, Payment Information – Invoice, Debit Notes, and TDS.

Functionality:

      1.       Login (with the same credential as web).

      2.       Select Import Type for the respective module.

      3.       Select location GSTIN if applicable for the respective module.

      4.       Select the respective data format.

      5.       Choose and Upload File(s).

      6.       Change mapping for a file being uploaded.

      7.       Track the ongoing file upload process on the Track Summary tab.

      8.       Track Current and old file status on the File Status tab.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hardware - Software – Firewall Recommendations

Hardware Requirements

Processor

Intel i5 or faster

RAM

If the OS of the server/machine is 64-bit, we need a minimum of 4 GB RAM and for 32-bit OS, a minimum of 6 GB RAM. (This is in case the server/machine is dedicated only to running the utility)

HDD

250 GB

 

Software Requirements

Sr. No.

Infrastructure

Cygnet Vendor Portal

1

Operating System

Windows 8 or above

2

Framework

Microsoft .Net Framework 4.5

3

Network Protocol

TCP

4

Network Speed

Will work with any network speed, for better performance, 2MBPS or above is recommended

5

Internet Access

Yes

6

Remote Support

Team Viewer / AnyDesk/ Cisco WebEx

 

Firewall/Security Setup

·         NET TCP connection must be allowed from the machine where we have installed the Data Exchanger Utility to Cygnet Server. Two Way channel communication must be allowed in the Firewall/Security setup.

 

URL

IPs

Whitelisting

Port

Staging

https://cvpdemo.stagingapplications.com/

https://cvpdemowebapi.stagingapplications.com/

-

Required

443

Production

https://portal.cygnetvendorportal.in/

https://webapi.cygnetvendorportal.in/

-

Required

443

SFTP (Cygnet)

OLD FTP   : extract.cygnetfame.in
NEW FTP : 103.158.108.35  

 

Optional

8422

 

Requires Read/Write rights to the shared directory.

 

 

 

 

 

 

File Generate Format

File Naming convention: EntityName_DocumentType_DateFormat_RandomFileName_DateTimestamp.extension

               

File Name Example

Valid/Invalid

Mumbai_2_2_19082021_1136000001.xlsx

Valid

PurchaseOrder_2_2_19082021_1136000001.xls

Valid

AhmedabadBranch_2_2_19082021_1136000001.csv

Valid

Ahmedabad_Branch_DDMMYYYY_19082021_1136000001.xlsx

Invalid

Mumbai_2021_11_19082021_1136000001.xls

Invalid

PO_20_DDMMYYYY_19082021_1136000001.csv

Invalid

 

Document Type Master

Value

Invoice

1

Purchase Order

2

Vendor

3

Credit/Debit Notes

5

Goods Receipt Notes

6

Request for Quotation

7

Payment Information Invoice

8

Payment Information (Debit Notes)

9

Payment Information (TDS)

10

Inward Supply Invoice

11

Rental Invoice

12

E-Invoice (ASN)

13

OCR (Scan Invoice Copy)

14

 

Date Format Master

Value

dd-MM-yy

1

dd-MM-yyyy

2

dd/MM/yy

3

dd/MM/yyyy

4

MM/dd/yyyy

5

MM/dd/yy

6

MM-dd-yy

7

MM-dd-yyyy

8

dd.MM.yyyy

9

MM.dd.yyyy

10

MM.dd.yy

11

dd.MM.yy

12

Installing Utility:

To install Cygnet Vendor Portal DSU, you can run “Cygnet Vendor Portal Tool.msi” file. This setup will have 4 step installation process:

      1.       Welcome Screen: No input needed for this step. Just press on Next Button.

                   

     

 2.       Select Installation Folder: It is highly recommended to not to change default installation folder. keep this Folder same as already specified.


 

 

 

            3.       Confirmation Screen: No input needed for this step. Just press on Next Butto

 



          4.       Clicking on next button, setup will ask for Administrator access, and it is must to provide administrative access to setup. 

    5.       Installation Complete Screen.

   
How to start:

      1.       Login into the system by running application, usually shortcut for Cygnet DSU will added to desktop. If that is not available you can find .exe file at location “C:\Program Files (x86)\Cygnet\Cygnet  Vendor Portal Tool” and file name would be Cygnet.DSU.exe.

      2.       After login, you can either start uploading files by selecting “File Upload” menu( ) or you can view status for already upload files from File Status menu ().

      3.       File Upload:

To upload File(s), you need to select various options first, like Import Type, Location GSTIN,  Date format and File(s). All the options are compulsory to upload file(s).




      4.       After uploading file(s), you can track upload progress from Task Summary Menu ().

Using this tab can Pause, Resume or Cancel the ongoing process of files.


      5.       If in case there is any change in GSTIN Location (from the web), then you can refresh the location using the Refresh Location button next to the “Select Location GSTIN” Dropdown.



      6.   If you want to re-login using a different credential, then first you can click Logout Menu (), which will redirect you to the log-in screen, and then you can log in using another credential.

 

 

 

 

 

 

Technical Configuration:

There is also one menu available named Settings (), using which you can change various settings for DSU,


l  Chunk size : this is the amount (in KB) of bytes that will sent to SFTP server in each chunk.

l  In Folder path : this is the folder where the background process will pick the manual files to upload.

l  Service URL: this is the URL that will fetch the data like User’s Locations, user’s authentication, etc.

l  Subscriber Name: whatever name you will enter here, one parent folder by this name will be created to specified In folder path to temporarily save uploaded file.

l  In Folder (Local ) path: this is the folder where the background process will pick the files and upload them in the sftp location.

l  SFTP settings: This is a host connection where files are transferring.
Does it allow the SFTP host's connection is connected?
         just press "Test Connection" and get the "SFTP/FTP connection successfully!" message then the application is connected to the SFTP host.

 

Version: V1.0.43

PRODUCTION URL :
https://cvpdemo.stagingapplications.com/presentation/Cygnet_Vendor_Portal_Client_DSU_Utility_Setup_V_1_0_43.zip

1) Data Folder:  This is the DSU data folder, the DSU will use a few physical folders for the processing data file. If clients want to change the default path, then just enter the folder path here.
The default data folder location is the C drive path.

                Default Path: C:\Cygnet Vendor Portal Utility

2) File Import Type:
If FTP is selected, then all data files are processed using the SFTP/FTP connection, also public IP whitelist processes are needed.
If API is selected, then all data files are processed using web API so it’s faster than an FTP way.

                Default Option: FTP



Version: V1.0.44

PRODUCTION DSU 
      URL : https://cvpdemo.stagingapplications.com/presentation/Cygnet_Vendor_Portal_Client_DSU_Utility_Setup_V_1_0_44.zip







    • Related Articles

    • TML ASN URL Update in DSU Process

      1. Check the URL is whitelisted or not – Go the client’s server/local system(where DSU installed) enter the portal and API URL in and Web browser. If you see the screen image below, it indicates that the URL is whitelisted, or whitelisting is not ...
    • TML ASN

      URL- https://portal.cygnetvendorportal.in/ Need to login TML-ASN portal. Use case :- This is being used by TML vendors to generate the ASN number. ASN number- ASN number is must to generate when supply of any goods to tata motors is happening. Tata ...
    • CVP : Production Movement DC to OCI & URL Change

      Old Production Details Portal URL https://portal.cygnetvendorportal.in/ API URL https://webapi.cygnetvendorportal.in/ IPs 103.158.108.8 182.73.38.9 Port Portal: 8081 API: 8082 New Production Details Portal URL https://cvp.cygnettaxtech.com API URL ...