If you want to switch from Old Table Fields to New Table Fields while keeping the data your Old Table fields had this article will guide you through the steps to do so.


Video to Come


Old Table fields in RPM show up in views like this


When viewing a Form with an Old Table field




Transferring Old Table Data to New Tables


If there are any fields with important data that needs to be transferred over to new table fields this guide below will help with the transferring of said data.  In this example we'll be replacing the Old Table field Contacts with a New Table field.


First we need to create the New Table fields to replace the Old Table fields. We'll first go into the setup of the process we need to replace the table fields for.


Setup > Process Name > Fields


Then drag the New Table field icon on the right 




You can name the New Table field anything you'd like. Make sure to select Free Rows as all Old Table fields were free row tables.



From here add the columns of the old table as text fields or other fields if need be. You can check the Old Table field for the column headers if need be and come back to this later by editing the New Table field.


Add all the fields, they don't have to be named the same but if you do change the names of the fields make sure to remember what they're called.



Process > Process Name 


Navigate back to the Process view itself and then create a Custom View that includes all the Old Table fields you want to transfer as well as the Number column. The Number column will be used to reference the data back into the forms it belongs to.



Old Table fields show up in the Fields section of the select columns



After creating the view it should look something like this, in this example Contacts is the Old Table Field. 




After creating the view we'll want to download it on using the feature on the far right.



The data will come as shown in the Excel. Not the easiest thing to work with. You'll notice that all of the rows and columns in the table are all in one cell along with the column headers. 


We're going to have to use Excel to parse the data and get it in a format we can use to import back into RPM.


Keep in mind the steps I'm writing about might not work for everyone depending on the version of Excel and the OS you're using. If my steps below don't work you can look up steps on how to Remove Line Breaks and use the Text to Column tool for your specific combination of OS and Excel.



First we'll have to remove the line breaks using the Find and Replace tool.



In the Find What's box hold Alt and type 010 on your numpad or Ctrl + J then hit replace all. This will remove all line breaks in the table data





Then select the Data table in Excel. Then highlight all the Table data. Then copy the data into a Notepad or any text editor that displays the text as plain text






In the Text Editor use the find and replace to remove all quotation marks.



From there copy the text again and paste it back into Excel using Paste Special Text to Columns, I recommend doing this in another worksheet.


You can also sometimes just paste the whole block of text in and Excel will automatically Text to Columns the Data.



Click on a Cell, and use the Text Import Wizard from the top left, or by right clicking a Cell




Delimit using the Comma selector, or if your Table field exported with another symbol 





After all of that you should have something that looks like this. 


The data lines up with the column headers and




From here we'll need to label the row with the numbers, this can range from hard to easy depending on how many rows you have in the tables. If your tables only have one row each then this step is just removing the extra lines and columns.


Copying the Number column back into the data we'll start with this.



Removing the extra lines and duplicate column headers.


You'll want to end up with this. Depending on how large the amount of data you have here it might not be possible to do this step in a timely manner automatically. If need be we can write a Macro for Excel that can do this step.



Now we'll want to Import the data into the new Table fields. You can now refer to this Article on how to import data into Table fields.