Requirements:
-
- Python installed on your computer. You can download it from https://www.python.org/ftp/python/3.11.2/python-3.11.2-amd64.exe
- Make sure to add Python to PATH.
- Download the lldconvert.zip file from https://www.mediafire.com/file/oou8plmibkc9jss/lldconvert.zip/file You can also find the link at https://lk.macmarketing.us/abcinitial.
- The customer and gift card databases saved as csv files (make sure there is not keyword like customer, promotion, gift trong original file)
- The Nail_Data.db file in the storage folder.
Steps to follow:
- Extract the llconvert.zip file to the folder D:\lldconvert.
- Open the command line tool.
- Navigate to the folder where you extracted the ezconvert.zip file. You can do this by using the cd command in the command line. For example, if you extracted the file to D:\lldconvert, you would type “cd D:\lldconvert” in the command line.
- Run the following command to convert the customer database file to a format that can be imported into Nail_Data.db:
python lldconvert.py datafuji.csv
- Run the following command to convert the gift card database file to a format that can be imported into Nail_Data.db:
python lldconvertgift.py giftcardfuji.csv
- Run the following command to import the customer and gift card databases into Nail_Data.db:
python import Nail_Data.db datafuji_customer.csv datafuji_promotion.csv giftcardfuji_gift.csv
- Once the import is complete, you can copy the Nail_Data.db file to your database folder and start using it. You may want to backup your old Nail_Data.db file before copying the new one, just in case something goes wrong. You can do this by renaming the old file with “_old” at the end of the filename.
- That’s it! Once you know how to use the scripts, it should only take about 15 seconds to import your customer and gift card databases into Nail_Data.db.
For a visual guide, you can watch this video tutorial: https://drive.google.com/file/d/1_rAJK-jtnq01vRQA87zz_6FSn8xLVDe7/view?usp=share_link