Blackthorne import flat file

The application also accepts document text in a single field in the DAT file. Always verify that the number of lines in the OPT file matches the number of images.

Click Add. Note: As you complete each page in the Import window, the application saves the details. If you navigate away from the Import window, click Add to reopen the job.

However, if you click Cancel , you lose all changes. On the Import Details page, do the following:. In the Job type list, select Flat file. Type a Name for the flat file import job. In the Date format list, select the default date format for the imported files. Note: The application supports all date formats.

On the Metadata File page, select the metadata file. TXT for import:. In the File repository list, select the file repository to import the data to.

This list contains the file transfer repositories configured for your case. In the Folder name list, select a folder. In the File name list on the right, select the metadata file that you want to import. On the Image File page, you can select an image file. LFP for import. In the Folder name list, select a folder, and in the File name list on the right, select the image file that you want to import. On the Source Files page, use the following procedure to include source files with the import.

Select Copy source files to the server. On the Delimiters page, set the delimiter character that separates field values in the flat file. You can also set the text qualifier that encloses the field value. After setting the delimiters, use this page to search for fields in the flat files. You can proceed to the next page only after the field search. In the Column - fields list, select the delimiter character for columns and fields.

For example, if the flat file is delimited by commas, select , In the Text qualifier list, select the text qualifier character, if required. To search the flat file for available fields, click Get fields. Note: Due to RPF server demands, this process can take a while. Knowledgebase Portal Home Knowledgebase.

Alpha and Beta Testing. Categories Alpha and Beta Testing 1 Information about our testing process and how you can participate. Billing and Invoicing 1 Frequently asked questions concerning the billing and invoicing process. Consignments 2 Information about using consignments. Descriptions and Description Wrappers 2 Information about entering descriptions and description wrappers.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 30 days ago. Active 30 days ago. Viewed 91 times. Thank you very much for any feedback. Improve this question. RobIII 7, 1 1 gold badge 35 35 silver badges 82 82 bronze badges. Import how? Each recordtype has a table. If it is of the exact same name and design, you can simply open a recordset, or build an insert statement, and add the row to the correct table.

Hi, It doesn't look to me that your data for each row is going to match up too well. I would use the delimiter to split the data in excel first, i. Won't take too much effort then to append the data to the corresponding tables you have created in access.

Capt Kaous. I have the same question 2. Report abuse. Details required :. Cancel Submit. Try this, but please test it on a copy of your database first. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.