Creating Dynamic Table + Suppressing of Empty Table Rows + Movement of Static Text

[Prithvi Jagannadh]

Hi,

According to my project requirement, I need to create a table which has mapping of ADOR Objects which are pulled from .CSV file.

Table has 7 columns, and if the first cell of a row is empty, then the following cells of that row will be empty.

In such case I need to suppress the respective row. We have a static text to be displayed immediately after the last row of the table.

I am unable to suppress the rows in table (as like we have an option to suppress the empty mapping fields using "Suppress trailing spaces on empty content").

Is there any possibility that we can suppress the empty rows of a table and dynamically move the static text followed by the table last row.

Please suggest if anyone has an approach for the above mentioned requirement.

Thanks in advance.!

[George Marsh]

Are you using uDirect or do you have uPlan?

If uDirect the table needs to be in another csv file, that links back to the main data source. 

If uPlan you can build the table as a user view and set logic to suppress rows if empty (if required). 

[Prithvi Jagannadh]

Hi,

Thanks for the update. I use uPlan (6.5)
I have tried building the table in user view, but it is not pulling the values given in the .CSV file. Only limited values (2 in this case) are bring displayed.

Could also suggest on the same and let me know if  if there is any way that I can hide the table border when I create a table using the user view.

[couch]

In uPlan, right-click the data sources in the plan objects area and select new data source -> import using wizard.

Select your data source type and the file/server etc

From the left column, select the table from the datasource that you want to add and move it to the right column.

Click next, then finish.

Click the + next to the new datasource so you can see the table(s) you just created.

Right-click on the table you want to use. Select "Create Table ADOR".

In the ADORS area, now double-click the new table ADOR Object.

In the expression area write the SQL Query that you want to select the records from the table.

Type: Select * from

Then drag up the table from the data sources list into the expression.

This should result in something that look a bit like: select * from @[tablename] 

Then type: where 

Then drag up any fields from the table that you want to use as part of the selection criteria for each recipient.

To add a value to the query for the current recipient, drag up the recipient table value from the Recipient Information area of the plan objects area.

Your final query should look something like:

select * from @[tablename] where @[tablename].[CustomerID] = |->[ID]

[Prithvi Jagannadh]

Hi Couch,

Thanks for the approach.!

I have tried doing the same suggested by you. When I tried to validate the SQL query (Written in the same format as you mentioned), the following error is being displayed.

Error: line 1 character 0: An SQL query could not be validated since it does not specify a Data Source for execution.

NOTE: We have given the data source using "import using wizard" option.

[Prithvi Jagannadh]

Can anyone provide me an update on this please.!

[George Marsh]

Try creating a user view from the data source before creating the table content object. 

[Prithvi Jagannadh]

We tried that approach. The problem we are facing is that only the selected values (Values used to create user view and table ADOR) are only being displayed. We are unable to generate table using another source file (.CSV file). Even though different CSV file is selected while generating the PDF file, old values are only being pulled.

* Using uProduce 6.5 to generate the PDF files.

[George Marsh]

We had training recently from XMPIE and it was mentioned that user views should specify the data source names the first line:

@[data_name]:

Which we'd never used previously. 

I've not tried to run a job with multiple data sources on uProduce before - we always wrap up all tables in an Access database per project as makes our versioning and testing easier. If you do it this way and set the relationships up uPlan will set up user views for you on import (only really works for 1:1 matches, but you can work it out once you have the syntax). 

Have you got in touch with XMPIE support? Hope you appreciate that this is a community forum rather than official support, despite the valuable contributions from staff. 

[Shyam]

Hi Prithvi,

I worked this kind of requirements. if you are from India call me so I can help you out to achieve this. If you are okay with that I will give my number.

Thanks,

Shyam