---
title: "Export Layouts Missing"
canonical: "https://servicedesk.maxgeo.com/space/DataShed4/1270186044/Export%20Layouts%20Missing"
format: markdown
---
## Problem

- All export layouts in the export manager are missing but they exist in the database.
- The list of Data Sources are displayed incorrectly or missing data sources.
  
- All export layouts are being assign to the TABLE table
  

## Solution

The issue is when a table is retested in Config Manager and there is a “,” (Comma) in the <Table Name> and/or <Display Name>.

![image](media://8a2da5a1-34b5-4aab-86f4-9cd65bb8e72b)

Removing this comma can be done is two different ways:

Option 1:

1. Unregistered the table in config manager
2. Delete the table from Config Manager
3. Recreate the table without the comma
4. Re-register the table

OR:

Run the following Queries:

```sql
update tblSYSDSConfig set UserName = replace(UserName,',','') where UserName like '%,%'
update tblSYSDSConfig set DisplayName = replace(DisplayName,',','') where DisplayName like '%,%'
```


> ⚠️ DB Modification
> ⚠️ 
> ⚠️ Before any change is made to a user database (or system), maxgeo recommends competent staff should follow all standard database change management practices and never make untested changes to a production database.  
> ⚠️ Change, test and document all modifications on a test copy of your database to ensure results are as expected before implementing them on your live database. Always ensure a full backup is available in case rollback is required and follow all company change management procedures and practices.

## Related articles



> Macro (contentbylabel)

> Macro (details)
> 
> | Related issues |  |
> | --- | --- |