Vision Global
Customizations:
Imports:
Vision Global has two imports they will request, they will send you files for both imports.
Data Dump import and Ticket Sales import.
Ticket Sales Import and Re Upload:
The ticket sales import will require you to save the files to the .33 server in "c$\temp" folder you will rename the files to "TicketSales_JAN 23" and "eventDetail_JAN 23" OR the specified month for example "eventDetail_FEB 23"
--MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER--
Once you have saved the files you will need to open both and make sure they are in the correct format as seen in these example files below.
EventDetail file
| Event ID | Total Expenses | Total Revenue | Points Per Ticket | Ticket Cost | profit |
|---|---|---|---|---|---|
| 2 | $0.00 | $0.00 | 0 | $25.00 | $0.00 |
| 9 | $0.00 | $0.00 | 0 | $25.00 | $0.00 |
| 18 | $4,400.00 | $4,400.00 | 0 | $25.00 | $0.00 |
| 22 | $2,225.00 | $2,225.00 | 0 | $25.00 | $0.00 |
| 24 | $3,341.36 | $3,775.00 | 0 | $25.00 | $433.64 |
| 27 | $993.02 | $1,000.00 | 0 | $25.00 | $6.98 |
| 30 | $9,150.00 | $9,150.00 | 0 | $25.00 | $0.00 |
| 38 | $2,545.37 | $3,900.00 | 0 | $25.00 | $1,354.63 |
| 50 | $1,183.61 | $1,200.00 | 0 | $25.00 | $16.39 |
| 99 | $0.00 | $0.00 | 0 | $0.00 | $0.00 |
Ticket Sales file
| IBONum | 18 | 22 | 24 | 27 | 30 | 38 | 50 |
|---|---|---|---|---|---|---|---|
| 182090 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 182090 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 819874 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1190739 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1190739 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1190739 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1370867 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1370867 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3532878 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3650754 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4488362 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 5079199 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 5079199 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
Proceed to the .35, pull files you saved from .33 to .35
Once you have pulled the files from .35 head to C:\Inetpub\wwwroot\Prodigix Services\Ticket Import\Upload, and place both files in at the same time.
The files will be moved and processed at the same time, you will then run the script's below to make sure the data was imported correct on the SQL server, 173. VisionGLobal_Live, once you have ran the scripts the import will be successful.
Script: TicketSalesScript
Re-Upload:
Sometimes Vision Global will mess up a file and need you to re-upload the file, in order to do this you have to clean up the existing data then upload the new files. Sometimes they only need one file to be re-uploaded but you will need to upload both files, just use the original file they sent that did not change.
To clear the data you will run the query's below, after running the queries change the delete to select * and verify the Tickets and Events for upload date were indeed deleted. Once you have deleted and verified re-upload the files!
DELETE
FROM TicketSales
WHERE (EventID IN (SELECT EventID FROM TicketEventCodes WHERE (CreatedDate >= '11/16/2074')))
DELETE
FROM TicketEventCodes
WHERE (CreatedDate >= '11/16/2074')
Data Dump Import:
The Data dump import will be completed on .33 and .173 by saving the files to both servers.
To start save the files to your computer, once the files are saved rename them to Distributors.csv and Orders.csv.
Once saved you will open the file distributors.csv, the third row is missing the last date column and you will need to add a date to process the file successfully. You can use any date but it is recommended to use the date of the distributor above it.
Once you have updated the date you will need to find any Distributor ID that was converted to Scientific Notation and remove the line.(Search for a e+, there will be emails with this but you only need to find the distributor ID column.)
Next step is pushing the files to both the .33 server and .173 server, the location is in files\import\commission\distributors, the paths are a little different between both the .33 and .173 server but will look similar.
You will then run the Distributor script first and the Order Script second on .33 and .173 using Power Shell ISE, once you have run the scripts then have completed the Data Dump Import.
Script: DataDumpScript