Jump to content

Importing records into Pages Database from CSV File?


Maksim

Recommended Posts

Have a databse set up on pages.  While we have set up a number of vendors with all of the details, there are also about 400 records that are currently in an excel file that need to be added.

Any way to get that into the database without going through adding them manually?

Thanks!

(would be just text fields, no images)

Link to comment
Share on other sites

I have done it, for example to import a list of 1000 emoji records, but of course you can easily break things this way. One faulty entry can make the page/database unusable. 

I set up a couple of test records, downloaded a CSV from phpMyAdmin, recreated my data to fit that CSV, imported a few entries through phpMyAdmin (to check for errors) and then finally imported the whole list. 

Things like “record count per category” won’t be correct after such imports, but that gets corrected once you add or remove any record. 

Link to comment
Share on other sites

7 minutes ago, opentype said:

I have done it, for example to import a list of 1000 emoji records, but of course you can easily break things this way. One faulty entry can make the page/database unusable. 

I set up a couple of test records, downloaded a CSV from phpMyAdmin, recreated my data to fit that CSV, imported a few entries through phpMyAmin (to check for errors) and then finally imported the whole list. 

Things like “record count per category” won’t be correct after such imports, but that gets corrected once you add or remove any record. 

So now am thinking if it is worth it. lol. possibly breaking with all of the fields there.

Btw, bought supergrid. love it... although a question, is it possible to reposition the image as it appears in the hero image? =)

Link to comment
Share on other sites

On 5/11/2017 at 11:54 AM, opentype said:

I have done it, for example to import a list of 1000 emoji records, but of course you can easily break things this way. One faulty entry can make the page/database unusable. 

I set up a couple of test records, downloaded a CSV from phpMyAdmin, recreated my data to fit that CSV, imported a few entries through phpMyAdmin (to check for errors) and then finally imported the whole list. 

Things like “record count per category” won’t be correct after such imports, but that gets corrected once you add or remove any record. 

So correct me if I am wrong, just take the CSV file, format it to the same as the database and upload through phpmyadmin?  Is there any other entries that need to be made elsewhere besides the cms_customdatabase table?

Also, trying to wrap my mind around it.... but fields like record_save, record_updated, record_publishdate, and record_comment have a long digit code.... what do I put in for those or trying to understand it... ie 1494512720  How do I decipher that? lol.

thanks!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...