Database Conversion

Public Clarification Board

Sharing of contact details is prohibited by the Terms of Service.

Post Message

• 

  wowlighting

  The Apple Bento database file is an Apple Package file which consists of, amongst other components, a database file which I believe to be SQLite compatible, and a folder of images. Unfortunately my sample Bento database is too big to attach here. I would be happy to supply the file by other means if that was acceptable?
  
  You first need to understand:
  
  1) How to extract specific records from the database (e.g. all records that have the 'Ceiling' check box ticked and the 'Recessed' check box ticked.
  2) How to locate the image file which is associated with a particular record.
  
  Once you can do this I imagine the rest is relatively simple:
  
  1) Extract the fields in the Bento database which correspond with the fields in the OsCommerce database.
  2) Where several Bento fields correspond to just one OsCommerce field they need to be joined together with suitable HTML. I will supply a detailed list of which Bento fields correspond to which OsCommerce fields.
  3) It must be possible to either ADD records to the OsCommerce database, or REPLACE records.
  4) Make sure the image files are uploaded to the OsCommerce database and associated with the correct records.

  over 2 years ago

• 

  wowlighting

  As I only use Apple computers the solution should preferably run on an Apple and/or Online.

  over 2 years ago

• 

  wowlighting

  Further clarification....
  
  1) My website has an existing OsCommerce online store to which products have already been added using the OsCommerce web interface.
  2) I have been using Apple Bento 3 to create a database of additional products that I want to add to my existing OsCommerce online database.
  3) The Bento database has similar (but not identical) records to the OsCommerce database.
  4) I want to be able to create a 'Collection' in Bento which can be uploaded to the corresponding Product Category in OsCommerce. A 'Collection' is essentially a subset of the database.
  5) If I create a collection called 'Ceiling Lights', for example, I want to be able to upload it to the 'Ceiling Lights' category of my OsCommerce database.
  6) I would like to have the option to either ADD the records in the Bento Collection to the OsCommerce database, or to REPLACE the corresponding Product Category in the OsCommerce database with the records in the Bento collection.
  7) There is not an exact one to one correspondence of fields between the Bento and OsCommerce database. There needs to be a way to combine some of the Bento fields (e.g. 'Voltage', 'Height', 'Width' etc.) into one OsCommerce field (e.g. 'Description'). In this example the 'Description' field in the OsCommerce database will consist of several Bento fields formatted using HTML.
  8) Bento allows you to export Collections as comma separated variables (CSV) files but this does NOT include the media/photo field. You need to be able to extract the photos from the Bento database so that they can be added to the OsCommerce database. If you CTRL CLICK on the Bento database file and choose SHOW PACKAGE CONTENTS from the menu that appears you will be able to access both the SQLite(?) compatible database and the individual photos. So I guess an AppleScript could be written to do this?
  9) At the end of this I need a SIMPLE way to add parts of a Bento database to the OsCommerce database. This needs to be easy to use and very clearly explained using as much automation as possible.

  over 2 years ago

• 

  wowlighting

  The Apple Bento database has the ability to export the database as a CSV comma delimited file. However this export does not include the photo/media field of the records. The biggest issue to be solved for this project is how to extract the image fields from the Bento database and upload the image files to the OsCommerce website so that they link in with the database.

  over 2 years ago

• 

  nidhigupta

  Hi,
  i read description.
  i may do it.
  sir i m well in osc and providing services in this field from last 4 year. I assure u quality. My price is very low as compare to other bid because i would like to make clients on GAF
  Feel free to ask me if u have any inquiry.
  i would like to show u my oscommerce work if u r interested in profile.
  www.crackmasterscanada.com/store
  www.adorablewigs.com
  http://www.replica-de-relojes.com/
  http://316steel.com
  http://arcadefromhell.com/
  http://www.game-swag.com/
  www.buysextoys.com.au
  
  Looking forward for your response

  over 2 years ago

Show more messages