Vision Global - Revision history

172.68.34.18 at 22:02, 26 June 2023

2023-06-26T22:02:27Z

← Older revision		Revision as of 22:02, 26 June 2023
Line 247:		Line 247:

	'''Data Dump Import:''' <br />		'''Data Dump Import:''' <br />
	The Data dump import will be completed on .33 and .173 by saving the files to both servers. ~~<br />~~		The Data dump import will be completed on .33 and .173 by saving the files to both servers.
	~~Once~~ the files are saved rename them to Distributors.csv and Orders.csv.<br />
			To start save the files to your computer, once the files are saved rename them to Distributors.csv and Orders.csv.<br />
	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.<br />		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.<br />
	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.)<br />		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.)<br />
	~~Place~~ in files\import\commission\distributors, the paths are a little different between both the .33 and .173 server.<br />		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.<br />
	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.<br />		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.<br />
	'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_DataDumpScript DataDumpScript]		'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_DataDumpScript DataDumpScript]

172.68.34.82 at 22:52, 23 June 2023

2023-06-23T22:52:41Z

← Older revision		Revision as of 22:52, 23 June 2023
Line 8:		Line 8:

	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.		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		EventDetail file

172.68.34.82 at 22:52, 23 June 2023

2023-06-23T22:52:15Z

← Older revision		Revision as of 22:52, 23 June 2023
Line 228:		Line 228:

	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!		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~~

	DELETE		DELETE
Line 235:		Line 235:

	WHERE (EventID IN (SELECT EventID FROM TicketEventCodes WHERE (CreatedDate >= '11/16/2074')))		WHERE (EventID IN (SELECT EventID FROM TicketEventCodes WHERE (CreatedDate >= '11/16/2074')))

172.68.34.83 at 22:51, 23 June 2023

2023-06-23T22:51:44Z

← Older revision		Revision as of 22:51, 23 June 2023
Line 228:		Line 228:

	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!		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

	~~delete~~		DELETE

	FROM TicketSales		FROM TicketSales
Line 236:		Line 237:


	~~delete~~
			DELETE

	FROM TicketEventCodes		FROM TicketEventCodes

172.68.34.82 at 22:51, 23 June 2023

2023-06-23T22:51:24Z

← Older revision		Revision as of 22:51, 23 June 2023
Line 241:		Line 241:

	WHERE (CreatedDate >= '11/16/2074')		WHERE (CreatedDate >= '11/16/2074')



	'''Data Dump Import:''' <br />		'''Data Dump Import:''' <br />

172.68.34.82 at 22:51, 23 June 2023

2023-06-23T22:51:09Z

← Older revision		Revision as of 22:51, 23 June 2023
Line 2:		Line 2:


	'''Imports:''' <br/>		'''Imports:''' <br/> Vision Global has two imports they will request, they will send you files for both imports. <br/> Data Dump import and Ticket Sales import.
	Vision Global has two imports they will request, they will send you files for both imports. <br/> Data Dump import and Ticket Sales import.

	~~<br />~~		'''Ticket Sales Import and Re Upload:''' <br />
			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" <br /> --MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER--
	'''Ticket Sales Import:''' <br/>
	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" <br/> --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.		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.
Line 22:		Line 19:
	\|-		\|-
	\|2		\|2
	~~\|$0.00~~
	\|$0.00		\|$0.00
	\|0		\|$0.00
	\|$25.00		\| 0
	\|$0.00		\|$25.00
			\|$0.00
	\|-		\|-
	\|9		\|9
	~~\|$0.00~~
	\|$0.00		\|$0.00
	\|0		\|$0.00
	\|$25.00		\| 0
	\|$0.00		\|$25.00
			\|$0.00
	\|-		\|-
	\|18		\|18
	\|$4,400.00		\|$4,400.00
	\|$4,400.00		\|$4,400.00
	\|0		\| 0
	\|$25.00		\|$25.00
	\|$0.00		\|$0.00
	\|-		\|-
	\|22		\|22
	\|$2,225.00		\|$2,225.00
	\|$2,225.00		\|$2,225.00
	\|0		\| 0
	\|$25.00		\|$25.00
	\|$0.00		\|$0.00
	\|-		\|-
	\|24		\|24
	\|$3,341.36		\|$3,341.36
	\|$3,775.00		\|$3,775.00
	\|0		\|0
	\|$25.00		\|$25.00
	\|$433.64		\|$433.64
	\|-		\|-
	\|27		\|27
	\|$993.02		\|$993.02
	\|$1,000.00		\|$1,000.00
	\|0		\| 0
	\|$25.00		\|$25.00
	\|$6.98		\|$6.98
	\|-		\|-
	\|30		\|30
	\|$9,150.00		\|$9,150.00
	\|$9,150.00		\|$9,150.00
	\|0		\| 0
	\|$25.00		\|$25.00
	\|$0.00		\|$0.00
	\|-		\|-
	\|38		\|38
	\|$2,545.37		\|$2,545.37
	\|$3,900.00		\|$3,900.00
	\|0		\|0
	\|$25.00		\|$25.00
	\|$1,354.63		\|$1,354.63
	\|-		\|-
	\|50		\|50
	\|$1,183.61		\|$1,183.61
	\|$1,200.00		\|$1,200.00
	\|0		\|0
	\|$25.00		\|$25.00
	\|$16.39
			\|$16.39
	\|-		\|-
	\|99		\| 99
	\|$0.00		\|$0.00
	\|$0.00		\|$0.00
	\|0		\|0
	\|$0.00		\|$0.00
	\|$0.00		\|$0.00
	\|}		\|}
Line 214:		Line 212:
	\|0		\|0
	\|0		\|0
	\|0		\| 0
	\|0		\|0
	\|0		\|0
Line 225:		Line 223:
	'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_TicketSalesScript TicketSalesScript]		'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_TicketSalesScript 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:''' <br/>		'''Data Dump Import:''' <br />
	The Data dump import will be completed on .33 and .173 by saving the files to both servers. <br/>		The Data dump import will be completed on .33 and .173 by saving the files to both servers. <br />
	Once the files are saved rename them to Distributors.csv and Orders.csv.<br/>		Once the files are saved rename them to Distributors.csv and Orders.csv.<br />
	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.<br/>		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.<br />
	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.)<br/>		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.)<br />
	Place in files\import\commission\distributors, the paths are a little different between both the .33 and .173 server.<br/>		Place in files\import\commission\distributors, the paths are a little different between both the .33 and .173 server.<br />
	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.<br/>		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.<br />
	'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_DataDumpScript DataDumpScript]		'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_DataDumpScript DataDumpScript]

172.68.34.19 at 17:39, 23 June 2023

2023-06-23T17:39:06Z

Show changes

172.68.34.91 at 17:31, 23 June 2023

2023-06-23T17:31:00Z

← Older revision		Revision as of 17:31, 23 June 2023
Line 8:		Line 8:

	'''Ticket Sales Import:''' <br/>		'''Ticket Sales Import:''' <br/>
	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" <br/> --MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER~~, YOU WILL ALSO NEED TO REVIEW THE FILES AND MAKE SURE THERE ARE NOT EXTRA COMMAS~~--<br/>		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" <br/> --MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER--
	Proceed to the .35, pull files you saved from .33 to .35 <br/>
	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. <br/>		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 examples <br />
	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. <br/>		Proceed to the .35, pull files you saved from .33 to .35 <br />
			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. <br />
			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. <br />
	'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_TicketSalesScript TicketSalesScript]		'''Script:''' [https://wiki.prodigix.com/index.php/Vision_Global_TicketSalesScript TicketSalesScript]

172.68.34.91 at 16:29, 23 June 2023

2023-06-23T16:29:11Z

← Older revision		Revision as of 16:29, 23 June 2023
Line 8:		Line 8:

	'''Ticket Sales Import:''' <br/>		'''Ticket Sales Import:''' <br/>
	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" <br/> --MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER-- <br/>		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" <br/> --MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER, YOU WILL ALSO NEED TO REVIEW THE FILES AND MAKE SURE THERE ARE NOT EXTRA COMMAS--<br/>
	Proceed to the .35, pull files you saved from .33 to .35 <br/>		Proceed to the .35, pull files you saved from .33 to .35 <br/>
	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. <br/>		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. <br/>

172.68.35.9 at 16:03, 23 June 2023

2023-06-23T16:03:26Z

← Older revision		Revision as of 16:03, 23 June 2023
Line 8:		Line 8:

	'''Ticket Sales Import:''' <br/>		'''Ticket Sales Import:''' <br/>
	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-- <br/>		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" <br/> --MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER-- <br/>
	Proceed to the .35, pull files you saved from .33 to .35 <br/>		Proceed to the .35, pull files you saved from .33 to .35 <br/>
	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. <br/>		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. <br/>