Please note that Form2Content is no longer being developed. All files from the latest version can be found on Github.

Form2Content Forum

Questions and answers for Form2Content, a Joomla CCK.

Resolved Sync articles with external DB?

  1. Futuron
  2. Form2Content Lite & Pro
  3. Wednesday, 23 September 2015
  4.  Subscribe via email
Hello,

We want to make use of a API to create and sync articles on the website. The API syncs data to a local db-table. We want tot use this table to create articles. Do you have a best practice?

Regards,
Rob

J 3.4.4.
F2C pro 6.10.0
Responses (3)
Accepted Answer Pending Moderation
Hi Rob,

To create and/or updates from external sources we have the XML import mechanism.
What you can do is generate XML from your custom table and then import it using our XML import function.

The easiest way to see which XML you need to generate from the tables is to create one sample article manually and then export it to XML.

best,
Julien
  1. more than a month ago
  2. Form2Content Lite & Pro
  3. # 1
Accepted Answer Pending Moderation
Thanks Julien!

We got the XML import working, but are now trying to keep the articles in sync with the content provided by the custom table. We've read about using an alternate key to create and update articles (http://documentation.form2content.com/f2c-xml-import-export/111-using-an-alternate-key-for-for-importing-f2c-articles-with-xml-import), but updating an article is only working when updating an existing article (using the ID generated by Joomla/F2C).
When trying to use a alternate key (generated from id's from the custom table fields), the initial article is not created with the generated custom id, but the Joomla/F2C id instead. We would like to use our custom id's if possible. Are we using the alternate id mechanism correctly?

http://rits.borol.nl/media/com_form2content/import_template.xml
  1. more than a month ago
  2. Form2Content Lite & Pro
  3. # 2
Accepted Answer Pending Moderation
Did this get resolved?
Please read the F2C documentation before asking questions! Thank you if you've done so ;)
  1. more than a month ago
  2. Form2Content Lite & Pro
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.