Skip to Content
It is currently March 3rd, 2021, 4:10 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
PostPosted: July 1st, 2019, 2:19 am 
Offline
New User
New User

Joined: January 15th, 2019, 7:32 pm
Posts: 7
Location: Padang, Indonesia
I follow the threads but still, I could not find how to save the Event Scheduler I have created. It's so annoying to re-type and re-organize again an ES. I have read it can be done by doing something with the database / MySql. Why make it so diffiicult ? Why SAM can not just make it simple. Like to save an ES to a file (same how we do in PAL Script) ?

Then if we want to make a new ES just rename it, and change a bit the content. It will save a lot our times and much more easier for the newbie user. It is so scary for me to work/modify the MySQL file. It's a database file. Once it's broken, the whole program will not function .

Anyone knows how to Save the ES ?


Top
 Profile  
Reply with quote  
PostPosted: July 1st, 2019, 7:54 am 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10526
Location: Denver, CO
The difference is the two is huge. PAL scripts are simply text FILES read into a command Interpreter.
The Event Scheduler does not use text files but database tables to store events. Spacial uses one table for the Event Actions and a separate table for the Event Times. Since Spacial has chosen to keep the events in the database and not text files, it's not likely that there would be an easy way to do what you ask.

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: July 1st, 2019, 3:09 pm 
Offline
SVS Member
SVS Member

Joined: December 6th, 2004, 9:00 am
Posts: 8156
Location: Cologne (Germany)
Dump the event and eventtimes tables as CSV, then change the CSV and reimport the tables.
I strongly recommend not trying to modify the CSV using MS Excel. While it's possible to safely handle CSV files with Excel, the default way of opening the CSV file in Excel will destroy the file. (simply speaking. If you want proper CSV handling in Excel, import the CSV INTO an empty spreadsheet instead of opening the CSV AS a spreadsheet)
For an out-of-the-box way of working with CSV files from almost any source use LibreOffice instead.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode


Top
 Profile  
Reply with quote  
PostPosted: July 5th, 2019, 8:23 am 
Offline
New User
New User

Joined: January 15th, 2019, 7:32 pm
Posts: 7
Location: Padang, Indonesia
Thanks for your reply guys but seems like too technical / complicated for me to do.
Perhaps in the nearest future, Spacial may provide a facility to make it easier for the users


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 15 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group