Importing Multiple Events

[dave_gordon]

Hi Brian/Gervais,
I need to import 3 events for each week for a period of 3 years, so as you can apprechiate this is fairly long winded. The three seperate events all last the same length of time, and the only thing that changes is the descriptiion which denotes a price, which is the part that changes.

Can you tell me when (if atall) the Import facility will be available and will it be compatible with v6.

If not in the near future do you know if there is a hack or 3rd party tool that I can purchase seperately to easily import multile events.

Also, I'm using the flat file setup.
Many thanks in advance
Dave

[dave_gordon]

Sorry, I also forgot to mention that each of the seperate events is the same catgory?
Regards
Dave

[ve9gra]

I was going to say that you could enter a few events, export your database, find the entries that you just did and find the commonality between them, and then simply replicate the lines... but since you're using the flat-file, you don't even need to export anything.

I would suggest that you create a new file for this test. Then enter you first three events or so, just enough to figure out the pattern. If I remember correctly, each event is separated by a -||- (dash, pipe, pipe, dash) and each field is separated by a | (pipe).

Once you find the pattern, then you just need to repeat the same lines over and over. You'd need to change the date value (you can use the php function gregoriantojd for help on that one) and the price for each event, but pretty much everything else should stay the same.

[dave_gordon]

Many thanks for you assistance Gervais, and I understand what you are saying.

The only problem is if I look in the caldat.php file the first enteries are the Julian Start and End days.

I don't know php so will be manually editing and using Excel to convert the days to Julian, but when I enter 01/08/2010 to 01/15/2010 I expect it to read 10008|10015 but instead the file says 2455205|2455212. Can you explain?

Many thanks in advance
Dave

[ve9gra]

The 2455205 is actually the Julian Day format for Jan 8, 2010. The 10008 is not the actual Julian Date. 10008 just means it's the 8th day of the year 10.

You got confused with ordinal date, and the "julian day number".

http://www.vertex42.com/ExcelTemplat...-calendar.html

That link gives you how to convert Gregorian dates into Julian day number.

[dave_gordon]

Many thanks once again Gervais.

For those that ae interested the calculation is;

=DATE(Y,M,D)+2415018.5
where Y is the year, M is the month, and D is the day, and DATE(Y,M,D) could be replaced with just a standard Excel date. The problem is that this only works for years after 1901.