Skip to Content

Changes for page Checkin Data Import Tool

Last modified by David Muszynski on 2025/04/11 18:21
From version 6.1
edited by David Muszynski
on 2025/04/11 18:18
Change comment: Uploaded new attachment "Screenshot%202024-11-15%20at%203.25.44%20PM.png", version {1}
To version 9.2
edited by David Muszynski
on 2025/04/11 18:20
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -52,4 +52,18 @@
52 52  
53 53  **Creating the Invoices - **Once it imports all the raw data into the ls_import_temp table, it does a search on the "duplicate_id" field which is a field that checks if there is multiple records for an invoice. (this happens when theres more than 1 line on an invoice). It takes only ONE of those records per invoice, and does an export so that it can import that information to generate Invoice records (which we'll then hook up to the line item records). The export is pretty simple.
54 54  
55 -[[image:https://doctormac.teamwork.com/desk/file/3144609/Screenshot%202024-11-15%20at%203.25.44%20PM.png||alt="Image Placeholder"]]
55 +[[image:Screenshot%202024-11-15%20at%203.25.44%20PM.png||height="611" width="1000"]]
56 +
57 +[[image:Screenshot%202024-11-15%20at%203.29.41%20PM.png||height="474" width="1000"]]
58 +
59 +**Creating the Line Items **- Same thing here, it will export and import the information it needs to generate line items.
60 +
61 +[[image:Screenshot%202024-11-15%20at%203.35.46%20PM.png||height="611" width="1000"]]
62 +
63 +[[image:Screenshot%202024-11-15%20at%203.37.03%20PM.png||height="477" width="1000"]]
64 +
65 +**Cleaning Up **- Currently, after importing the Line Items, it does a few replaces to clean things up, the store id, the company id, recID. But it also tries to automatically fill out the item_id properly using the ls_import_inventory table. This doesn't work currently because the relationship doesn't work perfectly. For the Invoices, it replaces the store ID and company ID and then sets the total of the Invoice.
66 +
67 +* **Manual Clean-up **- Shouldn't be much to do after unless something is found.
68 +
69 +
Screenshot%202024-11-15%20at%203.29.41%20PM.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.tknospdr
Size
... ... @@ -1,0 +1,1 @@
1 +375.1 KB
Content
Screenshot%202024-11-15%20at%203.35.46%20PM.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.tknospdr
Size
... ... @@ -1,0 +1,1 @@
1 +187.4 KB
Content
Screenshot%202024-11-15%20at%203.37.03%20PM.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.tknospdr
Size
... ... @@ -1,0 +1,1 @@
1 +303.7 KB
Content