How To bulk delete records.

To bulk delete records you can use the Find Feature in combination with, Records/Omit Multiple and Records/Delete Found Records feature. 

To do what you need...

Please Back up your MyArt.MA2 data file first. 

1. Unsort your art list if it is sorted. For instance, if you imported 4000 good records on top of 4000 bad ones, the good ones will be after the bad ones. Unsorting them will place them in the order of entry with the good after the bad.

2. If the first 4000 records out of 8000 records need to be removed then go to Records/Omit Multiple.

3. Type in the number or records to omit. In this example, use 4000. We are going to first omit the Bad then show them to isolate the bad ones. 

4. Now out of 8000 records, the first 4000 are now hidden. 

5. To show the first 4000 go to Records/Show Omitted.

6.  Now the good are hidden and the bad are showing.  Go to Records/Delete Found records to delete the bad ones. That will leave you with the records that are good. 

Selecting your Time and Date Settings

Selecting your Time and Date Settings

Q; "Incidentally, whenever I open MyArtCollection, I always get a window asking me what date and time settings I want.  Whichever option I choose, nothing seems to happen. What is this for?"

The below was written for a client. This solved the date time issue. 

BACK UP YOUR MY ART COLLECTION PROGRAM FOLDER WITH ALL FILES IN IT TO A SAFE LOCATION

1. Launch My Art Collection.

2. Go to File/Save a Copy as and save a copy of the MyArt.MA2 data file as a Type: Clone(no records) to your desktop. Name it "MyArt.MA2"

2. Go To Back Up and Save to Back Up.

3. Quit My Art Collection

4. Drag and Drop the cloned MyArt.MA2 file on your desktop into the My Art Collection application folder and choose replace.

5. Open My Art Collection.

6. Accept the blank License Agreement.

.

7. A dialog will appear asking if you'd like to import your data, choose Cancel.

8. Go to Back Up/Import from Back Up

9. Your data will be imported.

10. Reset the columns by clicking and choosing which data to see the empty space next to each down arrow. 

This should solve your problem. 

How to Batch Load Images

How to Batch Load Images

To batch load images, go to File/Batch Import a Folder of Images.  Select the folder of images you wish to import. A new record will be created for each image. 

Saving a report as PDF OSX

How to Save My Art Collection Files as a PDF using OSX.

Q:  How can I share my database with images?  Can I import the images into Excel?  What is the relationship between My Art Collection and FileMaker?

Our product was built using FileMaker as the engine. We use software that lets us build applications using FileMaker as the engine to our product. Filemaker is a database platform like Mac and Windows are platforms. We designed and built our product in-house and it is what you actually interact with. Filemaker just runs the back end. Assuming you have a license for My Art Collection Professional, it will let you create multiple files for managing multiple collections so you are set there. 

As for exporting to Excel, FileMaker does not let you export images to an Excel file, only text. The only file format that you can export text to with FileMaker is another FileMaker file. 

The best way to share the data with images is to use one of the reports in our program and then save it as a PDF. With OSX you can do that when you select print. There is an option to save as a PDF.