Answers.Body: <p>I would highly advise against trying to import anything directly into tables. I don't know when it was added, but everything now has a global identifier (UID) which you cannot add manually. FeedMe sounded like the right approach; I'd look at running that import on the production site and letting FeedMe import the content for you through the control panel rather than trying to directly add it to the database.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-28T11:05:19.173Z
Answers.Text: Thanks for the heads up on the UID. I cannot get FeedMe running on the production server because it requires PHP 7.3 and getting to that is going to require a huge amount of time.
Answers.UserDisplayName: Jake N
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-29T03:51:05.660Z
Answers.Text: @JakeN FeedMe should work fine with PHP 7.0. Why do you say it requires PHP 7.3?
Answers.UserDisplayName: Brad Bell
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-04-28T11:00:51.620Z
Answers.LastActivityDate: 2020-04-28T11:00:51.620Z
Answers.UserDisplayName: darylknight
Body: <p>I have a very strange situation. </p>
  
  <p>A production site is running Craft3.0 - there is no easy way to get this site up to Craft3.4. This is not possible at present because of the server and upgrading PHP.</p>
  
  <p>I have used FeedMe locally on Craft3.4 to import a few thousand entries into the site. </p>
  
  <p>Now I have these entries on my local machine running Craft3.4, and I need them placing onto the live site which is Craft3.</p>
  
  <p>Exporting that tables that I <em>think</em> are needed results in multiple copies of the entries being created. E.g. 5 of the same news articles all with the same slug. </p>
  
  <p>I am exporting and then importing the following tables...</p>
  
  <ul>
  <li><em>craft_assets</em> (because of images on the entries)</li>
  <li><em>craft_categories</em></li>
  <li><em>craft_content</em></li>
  <li><em>craft_elements</em></li>
  <li><em>craft_elements_sites</em></li>
  <li><em>craft_entries</em></li>
  <li><em>craft_relations</em></li>
  <li><em>craft_userpermissions</em></li>
  <li><em>craft_userpermissions_usergroups</em></li>
  <li><em>craft_userpermissions_users</em></li>
  <li><em>craft_userpermissions_users</em></li>
  <li><em>craft_users</em> (because of authors)</li>
  </ul>
  
  <p>Am I missing a table?</p>
  
  <p>Am I confusing Craft3 by adding a certain table?</p>
  
  <p>Is this impossible because of the differences between Craft3 and 3.4? I have looked at the tables and they are identical so I am unsure why it is getting itself into such a state.</p>
  
  <p>I realise this is a very odd and suboptimal situation - but I am stuck with this at present with no way to upgrade the server and the PHP version.</p>
  
Tags: <craft3><import><export>
Title: Export from Craft 3.4 to Craft 3.0 using Feedback
ThreadText: # Export from Craft 3.4 to Craft 3.0 using Feedback
  
  (Asked by: username_0 on 2020-04-28)
  
  I have a very strange situation.
  
  A production site is running Craft3.0 - there is no easy way to get this site up to Craft3.4. This is not possible at present because of the server and upgrading PHP.
  
  I have used FeedMe locally on Craft3.4 to import a few thousand entries into the site.
  
  Now I have these entries on my local machine running Craft3.4, and I need them placing onto the live site which is Craft3.
  
  Exporting that tables that I *think* are needed results in multiple copies of the entries being created. E.g. 5 of the same news articles all with the same slug.
  
  I am exporting and then importing the following tables...
  
  * *craft\_assets* (because of images on the entries)
  * *craft\_categories*
  * *craft\_content*
  * *craft\_elements*
  * *craft\_elements\_sites*
  * *craft\_entries*
  * *craft\_relations*
  * *craft\_userpermissions*
  * *craft\_userpermissions\_usergroups*
  * *craft\_userpermissions\_users*
  * *craft\_userpermissions\_users*
  * *craft\_users* (because of authors)
  
  Am I missing a table?
  
  Am I confusing Craft3 by adding a certain table?
  
  Is this impossible because of the differences between Craft3 and 3.4? I have looked at the tables and they are identical so I am unsure why it is getting itself into such a state.
  
  I realise this is a very odd and suboptimal situation - but I am stuck with this at present with no way to upgrade the server and the PHP version.
  
  **Tags:** craft3, import, export
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-04-28. Score: 1
  
  I would highly advise against trying to import anything directly into tables. I don't know when it was added, but everything now has a global identifier (UID) which you cannot add manually. FeedMe sounded like the right approach; I'd look at running that import on the production site and letting FeedMe import the content for you through the control panel rather than trying to directly add it to the database.
  
  > **Comments:**
  > **username_0**: Thanks for the heads up on the UID. I cannot get FeedMe running on the production server because it requires PHP 7.3 and getting to that is going to require a huge amount of time.  
  > **username_2**: @username_0 FeedMe should work fine with PHP 7.0. Why do you say it requires PHP 7.3?  
  
  ---
  
  