Panorama X file corruption


#21

Great info. However, because of the usefulness of such a date/time pattern function which always delivers a chronologically sound date/time stamp (with descending unit values each with leading zeros to force two characters), I think that two simpler specialized functions, such as “isodatepattern(datevariable)” and “isosuperdatetimepattern(superdatevariable)” would be extremely useful. No need to fuss with date/time patterns at all!

Furthermore, the default date input format “MM/DD/YY” in the data sheet should be “YYYY/MM/DD” which would sort correctly whether or not it was formatted as a date or a text data type. Just my opinion to make coding simpler. Thanks for the feedback.


#22

Not quite what you are asking for (doesn’t use the exact ISO format) but Panorama does have a timestampstr( function that I have frequently used for naming files chronologically.

You can use text funnels if you don’t want the time, or only want accuracy down to minutes or seconds.


#23

This is almost what I wished for, except that there is no way to input an arbitrary date/time argument. There are occasions when the date/time of interest may not be “now()” but the date/time of another instant, e.g. past generation of pay slip, invoice, etc.

However, I do like the output format that you have chosen.

I guess one will have to use Dave’s solution … Thanks Dave … which requires only two arguments or define an new function with a one “superdate” argument.


#24

I’d like to report a similar situation of apparent file corruption.
After a break in trying to work on Panorama X because it was all seeming too hard, and I didn’t have enough time, I was spurred into action by messages on my computer saying Panorama 6 wasn’t optimised for the current system, and the developer would have to fix it. Knowing that the developer isn’t planning on doing that, I was panicked back into action.
To my delight, everything was working really smoothly. I was having relatively few crashes (none at all for quite a while), buttons seemed to be doing what they should, and I was getting the programme into relatively good working shape. Then suddenly, everything went crazy. The programme (it runs as 4 separate databases inter-relating) wouldn’t open the other programmes up. The buttons weren’t triggering the programme sequences they were meant to, and even going into the programme and pressing “run” wasn’t doing anything.
I’ve tried re-installing Panorama X, shutting down the computer and letting it sleep on things, and still no change. Sometimes I can open the files from “Find and Open”, and sometimes I can’t (I’d never had to use this option at all previously, but read about it in a different thread about opening databases).
Having read this thread, I’ve opened another database I’d been working on, and it seems to be operating normally, so I guess it is these files rather than the programme. Very devastating. I have no idea where to start to try to get it working again??


#25

I have to point out that I see this entirely differently. I have done nothing BUT plan for this contingency for over six years. Plan, and then code and code and code, hundreds of late nights and weekends. Ensuring that Panorama would continue to work when Apple dropped the Carbon APIs and 32 bit support was the entire point of Panorama X.

Unfortunately I don’t have any immediate suggestions based on the description you have given.


#26

I want to make a general comment on this topic, to try to set a context from my point of view.

Over the past year, Panorama X usage has been steadily growing. It’s now over 5,000 hours per month. In the early beta days (3 years ago), usage was definitely higher on the weekend and lower during the week. I interpreted that as people “playing” with Panorama X rather than seriously using it for work. However, about 18 months ago a crossover point was reached, and now usage is significantly stronger during Monday thru Friday, with a definite dip on the weekend. So I believe that a majority of Panorama X users are using the software as a business tool for production use. Which is good – that’s what it’s for.

I’m bringing this up to give context to reports of problems. Certainly there are problems, and unfortunately there will always be problems in a system with hundreds of thousands of lines of code that runs on an ever changing operating system with hundreds of millions of lines of code. But as far as I can see, Panorama X is running fairly smoothly on a daily basis for the vast majority of users.

I certainly take reports of problems to heart. I want Panorama to work perfectly all the time for every user, it makes me feel kind of sick to read reports like those from Dominique and Michelle. However, I look around and see similar reports for all kinds of software, including and especially Apple system software, so I know I’m in good company in not being able to solve every mysterious problem immediately, or sometimes ever. So I keep chipping away, and keep my eye on the big picture which gives me encouragement that at least I am hopefully on the right path.


#27

I guess if your problem is that you created a programme that was so good, that when it gets too old we’re struggling to replace it, that’s a relatively good problem. Don’t lose too much sleep about it, and keep working towards the goal of creating a replacement that’s just as good.

In the meantime, I guess the solace I drew from your reply is that you are not hearing multiple similar problems occurring everywhere. That gives me the courage to re-convert the original Panorama 6 database and start again. Fingers crossed.


#28

I have a clue re my problem.

The crashes and malfunctions appear to be related to the addition of a text list to the database. It was a single column, no duplicates, database navigator, list.

I discovered this because I made a new version of my database from the Pan6 version. I deleted all forms and all programmes, stripping it down to raw data. Then I started adding forms back in. I’d come up with the idea of using one of these lists on a form, to save me creating an extra form. When I created it, the programme immediately crashed. Although it hadn’t been the last thing I’d done with my other database, I thought, in retrospect, that was probably when the crashes started occurring, (ultimately progressing to complete non functioning of the database). I managed to open my old corrupted database, deleted the 2 lists I had put in, and it started working normally again.

I have used similar lists elsewhere - but probably also with frequent crashes - and never got into this much trouble with it. However, the fact that it happened in both versions of the database makes me feel it is an internal error.

Hope this information helps you sort it out. I’ll play a bit more - probably try to get the list working with a variable rather than navigation, and keep you posted on what works/doesn’t, and keep you posted.


#29

Thanks for this sequence, which I’ve incorporated into my Initialize procedure (without fully analysing how you’ve done it). Is it possible to make a ‘ding’ noise, or a message, to indicate that its done its thing?


#30

“Beep” uses the selected system sound. Or you can have:
Message “Backup Copy Saved”


#31

More options:

The nsnotify statement delivers a notification.

The speak statement speaks a word or phrase.


#32

Thankyou both. Excuse my ignorance, but where do I put it in the above sequence?


#33

PS: I’d already tried to put in a message, but it turned up as I opened the database, not as I used the hotkey!


#34

The notice must be placed inside the hotkey code itself.

definehotkeys “database”,“control-B”,{makefolder dbfolder()+info(“databasename”)+" Backup"
    saveacopyas info(“databasename”)+" Backup/"+info(“databasename”)+"  "
    +superdatepattern(supernow(),"MM\DD\YY @ ",“hh;mm am/pm”)
nsnotify "Backup complete!"}

The nsnotify statement will give a notice in the corner of your screen and sound an alert.


#35

Hello Jim,

We are perfectly aware that there is no such thing as software without problems (and we agree that Apple’s software is a constant reminder of this). I came here not to complain or criticize but to see if others had had a similar experience and maybe learn something. I always think I may be doing something wrong, or there is something specific with my setup causing the problem. If I’m not alone, I feel better and can often get good suggestions from other users as has been the case here.

We’ve been using Panorama for decades, since the OverVUE days. We hope to keep using it for decades to come :slight_smile:

Thanks for all the hard work.


#36

Just this morning I came across some 400K floppy disks I’ve saved: Macintosh System Disk, MacWrite, MacPaint, Red Ryder and OverVUE. I had no idea that OverVUE (now Panorama) was going to be with me for so long, in so many ways and be as significant as it has been in my life. And happily, the learning curve continues because the product continues to move ahead.


#37

Perfect. Love it. Thanks very much.