Page 1 of 1

Adding meta data to an existing database

Posted: Thu Jan 22, 2015 4:14 am
by kcratty
II have a Connect App to be used to submit data to a workflow. When it is submitted, the user would enter information that would be a part of the metadata. I am looking for a script to add the metadata to the existing database on every record.'



Example:

meta data: Presorted



Data as submitted:



Name,Address,city,state,zip

John Doe, 123 doverLane, Lanham, MD, 20008

Jane Doe, 123 doverLane, Lanham, MD, 20008



After script

Name,Address,city,state,zip,Indicia,background

John Doe, 123 doverLane, Lanham, MD, 20008,presorted,imageA

Jane Doe, 123 doverLane, Lanham, MD, 20008,presorted,imageA



Is this possible with Javascript?

Adding meta data to an existing database

Posted: Thu Jan 22, 2015 11:16 am
by freddyp
It is possible. It is easier with the Database Module because then you do not have to script anything. You can directly call the database with the "Database connect" element.



Freddy

Adding meta data to an existing database

Posted: Thu Jan 22, 2015 6:27 pm
by dkelly
You mention that the metadata from Connect will contain the presorted information. Where does the other data come from? Are you updating existing database records or insert new ones?