Friday October 11, 2024, 1:38 pm
Email
IT 
EN 

7 - Set up ODBC data exchange

  • Step 1
  • Step 2
  • Step 3
  • Create an empty database with the RDBMS in use and register an ODBC data source associated with the created database. For example, name it pvTEST.

    To correctly register the data source on 64-bit systems, you must use the 32-bit DSN management program.

  • Launch packVol and open the ODBC configuration dialog with the DatabaseConfigure Database menu command or the Configure tool. Select the ODBC tab. Enter your credentials and connect by pressing the Connect button.
  • Create the tables needed by packVol with the Create button located in the Maintenance control group. A warning message informs you that all data will be erased. Click Yes.
  • Close the configuration dialog.
  • Within the RDBMS, populate the pv_job, pv_cnt e pv_sku tables.
  • pv_job ID g_desc
    1first load plan
    pv_cnt ID g_jobg_totalg_nameg_lengthg_widthg_height
    111test cnt1200232268
    pv_sku ID g_jobg_totalg_codeg_lengthg_widthg_height
    1125BOX11387293
    2160BOX21224476
    3155BOX31005270
  • To import data, press the FileImport (ODBC) menu command (shortcut key Ctrl+Shift+O). In the dialog that pops up, select the row in the list and press OK, or double-click on the row.
  • Optimize the imported plan as explained in Tutorial 1.
  • Export the solution with the FileExport (ODBC) menu command (shortcut key Ctrl+Shift+S).
  • Within the RDBMS, check the contents of pv_job, pv_bin and pv_geom tables.
  • You can automatically generate reports during export. Open the ODBC configuration dialog as explained in Step 1 and press the Open button located in the Maintenance control group. In the dialog that pops up, choose the working folder and select the types of documents you want to create, such as the PDF report.
  • Repeat data export and check the contents of the working folder.
Sitemap

© 2006-2024
Dr. Antimo Angelucci, PhD
Via Giulia n. 1
I-30026 Portogruaro (VE) - Italy
P.IVA IT03756330274

Privacy | Contact us
close  ❌ 

email

web form