Skip to content
+1-888-319-3663

COMMUNITY FORUM

SmartConnect schema file needs to be recreated

Kevin asked 6 years ago
We upgraded to GP 2015 and SmartConnect 20.15..51 and ever since then, our integrations that use a text file, when we change the file to a new file every month for the integration, we have to recreate the schema file, which then requires us to re-map all of the fields from the file, even though the names of the columns are still the same. This is very tedious and frustrating. Is there some way to avoid this or what are we doing wrong? We also get a message that states “Please note the schema file will be deleted every time  the map is run”.
Thanks,
 
Answers
Lorren Zemke Staff answered 6 years ago
Kevin,
If the file name changes each time but the format is the same, then I would change the Data Source to a Folder Data source. This allows you to set up a file template and schema.ini based on that template and the file name used for the data source will not matter.
http://www.eonesolutions.com/Manuals/SmartConnect/SmartConnect%202015/?page=smartconnect_folder_data_source
 
 
Matt Flowers replied 5 years ago

Hey Lorren,
I’m having a similar issue where I am copying an existing map (ODBC Text) and pointing to a new file. As soon as I do this I cannot connect to the file. We are using a script to create the data from the csv file and it looks like if I use the folder data source I cannot use the script. Thoughts? And yes, this is Matt who worked with you at a former employer. Thanks, Lorren! Would be happy to do a screen share with you.


If you would like to submit an answer or comment, please sign in to the eOne portal.