There are a number of common errors you may encounter when you are completing production uploads. 🔗
​
Some of these errors can be easily fixed using free tools as well as a simple find-and-replace function in a text editor program.
​
​

Free text editors:
Windows: Notepad ++ 🔗
Mac: BBEdit 🔗 (also free for download in the App Store)
​
​Spreadsheet tools:
Microsoft Excel or Google Sheets (free)
​

The metadata loadfile could not be parsed
​

This error will usually appear before you get to the mapping screen. This error may be caused by unsupported encoding of your load file. If this is the case, you can attempt to change the encoding of your load file to UTF-8 using the steps below.

A common error that occurs after mapping validation is Date/Time errors which look like this:
​

Date/Time errors occurs when the values if the Date or Time fields do not confirm to our accepted Date/Time formats. Acceptable Date/Time formats are outlined in our production upload requirement article 🔗
​
Our accepted formats are:
​

mm/dd/yyyy

m/d/yyyy

m/dd/yyyy

mm/d/yyyy

mm-dd-yyyy

m-d-yyyy

m-dd-yyyy

mm-d-yyyy

yyyy-mm-dd

yyyymmdd

hh:mm:ss [AM|PM]
hh:mm [AM|PM]
hh:mm:ss
hh:mm

h:mm [AM|PM]

h:mm:ss [AM|PM]

hhmmss

12/31/2019 1:13:30 PM
12/31/2019 1:13 PM
12/31/2019 1 13 30 PM
12/31/2019 1 13 PM
12-31-2019 1:30 PM
12-31-2019 13:13:30
12-31-2019 13:13
2019-12-31 13:13:30
2019-12-31 13:13
20191231 131330
20191231 1313
2019-12-31T13:13:30-06:00
2019-12-31T13:13:30Z

Months (mm), days (dd), and hours (hh) may all be denoted by a single digit except for yyyy-mm-dd and yyyymmdd formatting.
If the time is in military format, the AM/PM indicator is not required.
​

1. Open your DAT in your text editor.
2. Open the find and replace box:
​

3. As quotation marks are one of the CSV delimiters, escape any existing quotes by prepending an additional quotation mark:

Replace " with "":
​

4. Next replace the column breaks with “,”. In most standard DATs these are þ and upside down question mark (as a non printable character, we can reference this with the following hex value: \x{14}m ).

Replace þ\x{14}þ with ","
​

5. The þ at the beginning and end of each line will be replaced with a quotation mark.

Replace þ with "

6. The result should look something like this:
​

7. Save As the DAT and change the extension to CSV. Add MOD in the name so you know this is modified load file you made. Make sure the encoding is UTF-8:
​

Once the DAT has been converted into a CSV, you can open it in excel to convert the dates/times into Logikcull accepted formats.

Steps

1. Select the date or time column(s) that need to formatted:

2. Right click on one of the values in a cell and click format cells:

3. In the pop up window, select custom and choose the appropriate Logikcull supported Date/Time formatting:
​

4. Once the all dates/times have been updated, save the CSV as _MOD.

You can now use this in place of your original DAT in step 2 of the Production Upload by clicking "Re-Upload Load Files".

Another common error missing text, native, and image file errors. Typically these are caused by the path in your zip not matching the path referenced in your load files. You can confirm the actual files aren't missing by looking in your volume zip and checking for a sample image, native, and text.
​
The error looks like this:
​

And the error report will typically read like this:
​(warning) Line 2: Missing text file for TESTIMPORT0001: Test Import\Top Level\TEXT\TESTIMPORT0001.txt
​(warning) Line 4: Missing native file for TESTIMPORT0003: Test Import\Top Level\NativeFiles\TESTIMPORT0003.doc
​
These error will give you the option to skip and continue with the upload; however we recommend you do not skip them if the files exist in your volume zip. This error can usually be solved with a find and replace. Removing everything in the path before the top level NATIVE, TEXT, and IMAGE folders and making the paths relative is usually the solution to these errors.
​

Steps:

1. Open up your DAT and your OPT in a text editor
2. Control + F and search for Native and jump to the first native path; Copy the first part of the path to the natives folder and then do a find and replace all like so:
​

The resulting path should look something like this, with all the leading folders before the native folder removed:

So if the original path was VOL001\NativeFiles\BATES00000013.ics, after the find and replace, the path should be \NativesFolder\BATES00000013.ics. The leading \ before the natives, text, and images folders is still needed.
​

Note, your native folder may be called NATIVES so your replacements and resulting native path may differ.
​
3. Repeat this for the Text and Image paths:
​

4. Save As the modified load files as new load files (do NOT save over your old load files):
​

The new, modified load files can now be used in the place of out old load files. If you have already zipped up your volume, you do not need to remove the old load files from the zip and you do not need to add the new load files to the zip. You will simply need to replace the load files by clicking the "Re-upload load files" button:
​