Warning: mysqli_connect(): (HY000/2002): No route to host in /home/skybizgl/public_html/ticket/header-uc.php on line 38

Warning: mysqli_query() expects parameter 1 to be mysqli, bool given in /home/skybizgl/public_html/ticket/header-uc.php on line 39

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/skybizgl/public_html/ticket/header-uc.php on line 40

Import Fixed Asset from Excel to SkyBiz
Knowledgebase
SkyBiz Support Ticket > SkyBiz Support Ticket > Knowledgebase

Search help:


Import Fixed Asset from Excel to SkyBiz

Solution

Below are guideline(s) on How to Import Fixed Asset from Excel to MySQL

Step 1: Go to Data Excel Conversion Sheet

Go to Local Disk C>>MyERP>>Sample>>Data Conversion Sample

Step 2: Key in all data on Excel Conversion under Fixed Asset

Click "Fixed Asset" on worksheet tabs at bottom of excel >> key in all the data >> save the document

N/B: Note that RED titles are compulsory field.

 https://www.skybizglobal.com/ticket/kbimage/kb_import%20fixed%20asset%20(1).jpg

Step 3: Open SkySyn

Go to Local Disk C>>MyERP>>SkySyn

Step 4: Go to File > Excel to MySQL2

Step 5: Synchronize Data

Select Database >> Choose File Location of Data Excel Convert >> Click Show Excel Sheet >> Tick Fixed Asset >> Click SQL Convert

https://www.skybizglobal.com/ticket/kbimage/kb_import%20fixed%20asset%20(3).jpg

Step 6: Wait until "Process Convert Completed" message shown then press "OK".

 https://www.skybizglobal.com/ticket/kbimage/kb_import%20fixed%20asset%20(2).jpg

 

 
Was this article helpful? yes / no
Related articles Import Sales Order from Excel to SkyBiz Distribution
Import Purchase Order from Excel to SkyBiz Distribution
Import Item Master/Product Master from Excel into SkyBiz System
where to get data excel conversion
Guides on How to Import Text file to Excel format
Article details
Article ID: 319
Category: SkyBiz SkySyn
Date added: 2017-11-21 07:32:41
Views: 155
Rating (Votes): Article not rated yet (0)

 
« Go back

 
Powered by Help Desk Software HESK, brought to you by SysAid